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);
}
}
