public void SendMail1() { StChineseCalendar dat = new StChineseCalendar(DateTime.Now); string nowDay = dat.GanZhiYearString + dat.ChineseMonthString + dat.ChineseDayString + "日"; DateTime dt1 = new DateTime(2014, 11, 21); DateTime dt2 = DateTime.Now; //dt2 = new DateTime(2016, 11, 21); //邮件内容 string ya = string.IsNullOrWhiteSpace(dat.DateHoliday) ? "" : "(" + dat.DateHoliday + ")"; string yi = string.IsNullOrWhiteSpace(dat.ChineseCalendarHoliday) ? "" : " " + dat.ChineseCalendarHoliday + ""; string w = string.IsNullOrWhiteSpace(dat.WeekDayHoliday) ? "" : "(" + dat.WeekDayHoliday + ")"; string SendContent = "亲爱的bd,今天是" + DateTime.Now.ToString("yyyy年MM月dd日") + ya + "(农历:" + nowDay + yi + ")" + w + ",庆祝我俩相爱 <span style='color:red;'>" + StDate.GetDateTimeSpanString(dt1, dt2) + "</span>"; StMail mail = Pub.GetMailAcc("你家的sg"); Account to = new Account() { Address = this.textBox1.Text, IsSSL = true, IsBodyHtml = true }; //Account to = new Account() { Address = "*****@*****.**", IsSSL = true, IsBodyHtml = true }; SetControlValue(this.label2, "准备发送..."); bool rel = mail.Send(to, "sg的致电", SendContent); SetControlValue(this.label2, string.IsNullOrWhiteSpace(mail.ErroMsg) ? "发送成功" : mail.ErroMsg); }
private void Re() { this.label1.Text = ""; DateTime dt1 = new DateTime(2014, 11, 21); DateTime dt2 = DateTime.Now; this.label1.Text += "今天是:" + dt2.ToString("yyyy-MM-dd HH:mm:ss"); this.label1.Text += "\r\n" + dt1.ToString("yyyy-MM-dd HH:mm:ss") + "距离现在"; this.label1.Text += "\r\n" + StDate.GetDateTimeSpanString(dt1, dt2) + "或者"; this.label1.Text += "\r\n" + (int)((dt2 - dt1).TotalSeconds) + "秒"; }
private void LoadTable() { try { DateTime StDate; DateTime EndDate; string DateFmt; DAO.Recordset RS; int ID = 0; // make tmp table string SQL1 = "SELECT recTimeStamp, senSensorNumber, recTemp INTO tmpRecs"; SQL1 += " FROM tblSensors LEFT JOIN tblRecords ON tblSensors.senID = tblRecords.recSenID"; SQL1 += " GROUP BY recTimeStamp,senSensorNumber,recTemp,senBinNumber,senCableNumber"; SQL1 += " Having senBinNumber = " + tbBin.Text; SQL1 += " And senCableNumber = " + tbCable.Text; // date StDate = dtpSingle.Value; EndDate = dtpRange.Value; if (StDate == EndDate | rbSingle.Checked) { // single date, end date is beginning of the next day EndDate = StDate.AddDays(1); } else { // date range, end date is beginning of the next day after user selected end date EndDate = EndDate.AddDays(1); } SQL1 += " And recTimeStamp >= " + mf.Dbase.ToAccessDate(StDate) + " And recTimeStamp < " + mf.Dbase.ToAccessDate(EndDate); SQL1 += " Order By senBinNumber,recTimeStamp,senCableNumber,senSensorNumber"; mf.Dbase.DeleteTable("tmpRecs"); // delete old table, if any mf.Dbase.DB.Execute(SQL1); // create tmp table // make crosstab recordset if (rbHour.Checked) { DateFmt = "" + (char)39 + "yyyy/mm/dd hh" + (char)39; } else { DateFmt = "" + (char)39 + "yyyy/mm/dd" + (char)39; } string SQL = "Transform Avg(recTemp) as AvgOfrecTemp"; SQL += " Select Format([recTimeStamp]," + DateFmt + ") as ReadDate"; SQL += " From tmpRecs"; SQL += " Group By Format([recTimeStamp]," + DateFmt + ")"; SQL += " PIVOT senSensorNumber In (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16)"; RS = mf.Dbase.DB.OpenRecordset(SQL); dataSet1.Clear(); try // needed to close recordset after error { while (!RS.EOF) { ID++; DataRow Rw = dataSet1.Tables[0].NewRow(); Rw[0] = ID; Rw[1] = mf.Dbase.FieldToString(RS, "ReadDate"); for (int i = 0; i < 16; i++) { Rw[i + 2] = mf.Dbase.FieldToFloat(RS, (i + 1).ToString("N0")); } dataSet1.Tables[0].Rows.Add(Rw); RS.MoveNext(); } } catch (Exception) { } RS.Close(); } catch (Exception ex) { mf.Tls.TimedMessageBox(ex.Message); mf.Tls.WriteErrorLog("frmBinReport:LoadTable " + ex.Message); } }