After a long time, the micro-letter official finally released the. NET Demo.
Main code:
/** * Generate direct Payment URL, payment URL is valid for 2 hours, Mode II * @param productId Commodity ID * @return mode two URL/public string Getpayurl (String Pro Ductid, string body, string attach, int total_fee, string goods_tag) {Log.info (this. GetType ().
ToString (), "Native pay Mode 2 URL is producing ...");
Wxpaydata data = new Wxpaydata (); Data. SetValue ("Body", body);//Product de
asp.net| static//51aspx.com generate static page demo file, reprint please keep this information
2 Public partial class _default:system.web.ui.page
3.. {
4 protected void Page_Load (object sender, EventArgs e)
5.. {
6
7}
8
9//According to the template generated, remain in the HTML folder (part of the source code collection on the network)
protected void Button1_Click (object sender, EventArgs e)
11.. {
12//Source code is the replacement of the feature characters in the template
13
Mbpath =server
, only the maximum/minimum value is saved.Iv. Date and Time typeGeneral use: Registration time Class time meeting time birthday entry dateYear YYYY 2017 takes 1 bytesDate directive: Date YYYYMMDD 20170619 takes 4 bytesTime HH:MM:SS 160258 takes 3 bytesDate Time instruction: datetime YYYYMMDDHHMMSS 201706191602Occupies 8 bytes The default value is null if the DateTime field is not assigned a valueDate-time instruction: timestamp
'Time_format (Time,format)Similar to Date_format (), but Time_format only handles hours, minutes, and seconds (the remaining symbols produce a null value or 0)Curdate ()Current_date ()Returns the current date value in ' Yyyy-mm-dd ' or YYYYMMDD format (a string or number based on the context in which the return value is located)Mysql> select Curdate ();' 1997-12-15 'Mysql> Select Curdate () 0;19971215Curtime ()Current_time ()Returns the current time value in ' HH:MM:SS ' or HHMMSS format (a str
Label:SQL BACKUP Database Code #regionThe service backs up the database once a day///
///The service backs up the database once a day///
Public voidserviceforbackupdatabaseeveryday () {thread thread=NewThread (NewThreadStart (backupdatabaseeveryday)); Thread. IsBackground=true; Thread.
Start (); }
Private voidBackupdatabaseeveryday () { while(true)
{
Try
{
//full backup Every 1 o'clock in the morning
if(DateTime.Now.Hour = =1)
{
6 'Time_format (Time,format)Similar to Date_format (), but Time_format only handles hours, minutes, and seconds (the remaining symbols produce a null value or 0)Curdate ()Current_date ()Returns the current date value in ' Yyyy-mm-dd ' or YYYYMMDD format (a string or number based on the context in which the return value is located)Mysql> select Curdate ();' 1997-12-15 'Mysql> Select Curdate () 0;19971215Curtime ()Current_time ()Returns the current time value in ' HH:MM:SS ' or HHMMSS format (a s
%s%w ');-10:23:00 PM 22:23:00 00 6 'Time_format (Time,format)Similar to Date_format (), but Time_format only handles hours, minutes, and seconds (the remaining symbols produce a null value or 0)Curdate ()Current_date ()Returns the current date value in ' Yyyy-mm-dd ' or YYYYMMDD format (a string or number based on the context in which the return value is located)Mysql> select Curdate ();' 1997-12-15 'Mysql> Select Curdate () 0;19971215Curtime ()Current_time ()Returns the current time value in '
Date_format (' 1997-10-04 22:23:00 ', '%H%k%I%r%T%s%w ');-10:23:00 PM 22:23:00 00 6 'Time_format (Time,format)Similar to Date_format (), but Time_format only handles hours, minutes, and seconds (the remaining symbols produce a null value or 0)Curdate ()Current_date ()Returns the current date value in ' Yyyy-mm-dd ' or YYYYMMDD format (a string or number based on the context in which the return value is located)Mysql> select Curdate ();' 1997-12-15 'Mysql> Select Curdate () 0;19971215Curtime ()C
Integer type:tinyint, smallint, mediumint, int, bigint respectively use 8, 16, 24, 32, 64-bit storage space, in the case of ensuring that the storage value is sufficient, select the smallest data typeReal type (when a fractional part is included):DecimalString type:VarChar type stores variable length stringsChar stores fixed-length string performance up to char (1) to store t/f BooleanDate and Time type:DateTime can hold a wide range of values 1001 to 9999 he encapsulates the date and time into
'Time_format (Time,format)Similar to Date_format (), but Time_format only handles hours, minutes, and seconds (the remaining symbols produce a null value or 0)Curdate ()Current_date ()Returns the current date value in ' Yyyy-mm-dd ' or YYYYMMDD format (a string or number based on the context in which the return value is located)Mysql> select Curdate ();' 1997-12-15 'Mysql> Select Curdate () 0;19971215Curtime ()Current_time ()Returns the current time value in ' HH:MM:SS ' or HHMMSS format (a str
(itsThe remainder symbol produces a null value or 0)Curdate ()Current_date ()Returns the current date value in ' Yyyy-mm-dd ' or YYYYMMDD format (a string or number based on the context in which the return value is located)Mysql> select Curdate ();' 1997-12-15 'Mysql> Select curdate () + 0;19971215Curtime ()Current_time ()Returns the current time value in ' HH:MM:SS ' or HHMMSS format (a string or number based on the context in which the return value is located)Mysql> select Curtime ();' 23:50:
digital context:Mysql> SELECT curtime ();' 23:50:26′Mysql> SELECT curtime () + 0;235026Now ()Sysdate ()Current_timestampReturns the current datetime value in ' Yyyy-mm-dd HH:MM:SS ' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or in a digital context:Mysql> SELECT now ();' 1997-12-15 23:50:26′Mysql> SELECT Now () + 0;19971215235026Note that the function now () is evaluated only once in each query, that is, when the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.