一.——2 .时间 日期格式

 详细打印时间日期：

DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")

 

 

 //add 20151207  wlina             
string date1;             
DateTime dt1;             
string date2;             
DataTable dt_temp = new DataTable();             

if ((procedure_name1 == "POW_STA.shift_refer") || (procedure_name1 == "POW_STA.day_refer"))             

{                 

date1 = string.Format("{0}/{1}/{2} 00:00:00", inputParam[0], inputParam[1], inputParam[2]);                 //String转为DateTime类型，

DateTime.ParseExact（string，string的格式，***）                 

dt1 = DateTime.ParseExact(date1, "yyyy/MM/dd HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);                 //然后计算第二天的时间                 

date2 = dt1.AddDays(1).ToString("yyyy/MM/dd HH:mm:ss");//"yyyyMMdd HH:mm:ss"                 

string t = string.Format("select max(HBBH_P),min(HBBH_P),avg(HBBH_P) from ZB1 where recordtime >to_date('{0}','yyyy/mm/dd hh24:mi:ss')  and recordtime <to_date('{1}','yyyy/mm/dd hh24:mi:ss') ", date1, date2);                 

dt_temp = oraDbApp.ExecuteQueryStr(string.Format("select trunc(max(HBBH_P)/1000,2),trunc(min(HBBH_P)/1000,2),trunc(avg(HBBH_P)/1000,2) from ZB1 where recordtime >to_date('{0}','yyyy/mm/dd hh24:mi:ss')  and recordtime <to_date('{1}','yyyy/mm/dd hh24:mi:ss') ", date1, date2));             }            
 if (procedure_name1 == "POW_STA.month_refer")             
{
                
date1 = string.Format("{0}/{1}/01 00:00:00", inputParam[0], inputParam[1]);                
 
dt1 = DateTime.ParseExact(date1, "yyyy/MM/dd HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);                 
date2 = dt1.AddMonths(1).ToString("yyyy/MM/dd HH:mm:ss");                 
string t = string.Format("select max(HBBH_P),min(HBBH_P),avg(HBBH_P) from ZB1 where recordtime >to_date('{0}','yyyy/mm/dd hh24:mi:ss')  and recordtime <to_date('{1}','yyyy/mm/dd hh24:mi:ss') ", date1, date2);                 

dt_temp = oraDbApp.ExecuteQueryStr(string.Format("select trunc(max(HBBH_P)/1000,2),trunc(min(HBBH_P)/1000,2),trunc(avg(HBBH_P)/1000,2) from ZB1 where recordtime >to_date('{0}','yyyy/mm/dd hh24:mi:ss')  and recordtime <to_date('{1}','yyyy/mm/dd hh24:mi:ss') ", date1, date2));             }            
 if (procedure_name1 == "POW_STA.year_refer")            
 {                
 
date1 = string.Format("{0}/01/01 00:00:00", inputParam[0]);                 

dt1 = DateTime.ParseExact(date1, "yyyy/MM/dd HH:mm:ss", System.Globalization.CultureInfo.CurrentCulture);                 

date2 = dt1.AddYears(1).ToString("yyyy/MM/dd HH:mm:ss");                 

string t = string.Format("select max(HBBH_P),min(HBBH_P),avg(HBBH_P) from ZB1 where recordtime >to_date('{0}','yyyy/mm/dd hh24:mi:ss')  and recordtime <to_date('{1}','yyyy/mm/dd hh24:mi:ss') ", date1, date2);                 

dt_temp = oraDbApp.ExecuteQueryStr(string.Format("select trunc(max(HBBH_P)/1000,2),trunc(min(HBBH_P)/1000,2),trunc(avg(HBBH_P)/1000,2) from ZB1 where recordtime >to_date('{0}','yyyy/mm/dd hh24:mi:ss')  and recordtime <to_date('{1}','yyyy/mm/dd hh24:mi:ss') ", date1, date2));             }             
textBox15.Text = dt_temp.Rows[0][0].ToString();             

textBox16.Text = dt_temp.Rows[0][1].ToString();