static void Main(string[] args)
{
log4net.ILog logInfo = log4net.LogManager.GetLogger("loginfo");
log4net.ILog logError = log4net.LogManager.GetLogger("loginfo");
DataBaseMgr dbMgr = new DataBaseMgr();
log4net.Config.XmlConfigurator.Configure();
while (true)
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "：准备请求发送短信");
string sql = string.Format(@"select o.id, d.name doctor_name,c.tel mobile
,concat( o.meeting_date,' ', reverse(substring_index(reverse(substring_index(o.meeting_time,'-',1)),'-',1))) order_date
from tb_order o
inner join tb_doctor d on o.doctor_id=d.id
inner join tb_member_case c on o.case_id=c.id
where IFNULL(o.send,'N')<>'Y'");
//and concat( o.meeting_date,' ', reverse(substring_index(reverse(substring_index(o.meeting_time,'-',1)),'-',1)))>'{0}'
//and concat( o.meeting_date,' ', reverse(substring_index(reverse(substring_index(o.meeting_time,'-',1)),'-',1)))<'{1}' ", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.AddMinutes(17).ToString("yyyy-MM-dd HH:mm:ss"));
DataTable dt = dbMgr.executeDataTable(sql);
int successCount = 0;
foreach (DataRow dr in dt.Rows)
{
string id = dr["id"].ToString();
string doctor_name = dr["doctor_name"].ToString();
string order_date = dr["order_date"].ToString();
string mobile = dr["mobile"].ToString();
SMSMgr smsMgr = new SMSMgr();
bool sent = smsMgr.sendSuccessBookingMsg(mobile, doctor_name, order_date);
if (sent)
{
string format = string.Format("发送{0}短信成功", mobile);
Console.WriteLine(format);
logInfo.Info(format);
string update = "update tb_order set send='Y' where id=" + id;
dbMgr.executeNoneQuery(update);
successCount++;
}
else
{
string format = string.Format("发送{0}短信失败，原因：{1}", mobile, smsMgr.Result);
Console.WriteLine(format);
logError.Error(format);
}
}
string totalFormat = string.Format("完成发送，共{0}条信息需要发送，其中{1}条发送成功", dt.Rows.Count, successCount);
Console.WriteLine(totalFormat);
Thread.Sleep(1000 * 60);
}
Console.Read();
}
static void Main(string[] args)
{
log4net.ILog logInfo = log4net.LogManager.GetLogger("loginfo");
log4net.ILog logError = log4net.LogManager.GetLogger("loginfo");
DataBaseMgr dbMgr = new DataBaseMgr();
log4net.Config.XmlConfigurator.Configure();
while (true)
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "：准备请求发送短信");
string sql = string.Format(@"select o.id,o.mobile, d.name doctor_name,o.order_date+' '+o.order_time order_date from tb_order o
inner join tb_order_videochat v on o.id=v.order_id
inner join tb_doctor d on v.doctor_id=d.id
where ISNULL(send,'N')<>'Y'
and Convert(datetime,o.order_date+' '+o.order_time)>'{0}'
and Convert(datetime,o.order_date+' '+o.order_time)<'{1}'
", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), DateTime.Now.AddMinutes(17).ToString("yyyy-MM-dd HH:mm:ss"));
DataTable dt = dbMgr.executeDataTable(sql);
if (dt == null)
{
string format = string.Format("获取数据失败:" + sql + ": " + dbMgr.Return);
Console.WriteLine(format);
logInfo.Error(format);
}
else
{
int successCount = 0;
foreach (DataRow dr in dt.Rows)
{
string id = dr["id"].ToString();
string doctor_name = dr["doctor_name"].ToString();
string order_date = dr["order_date"].ToString();
string mobile = dr["mobile"].ToString();
SMSMgr smsMgr = new SMSMgr();
bool sent = smsMgr.sendSuccessBookingMsg(mobile, doctor_name);
if (sent)
{
string format = string.Format("发送{0}短信成功", mobile);
Console.WriteLine(format);
logInfo.Info(format);
string update = "update tb_order set send='Y' where id=" + id;
if (!dbMgr.executeNoneQuery(update))
{
string format1 = string.Format("更新数据失败:" + update + ": " + dbMgr.Return);
Console.WriteLine(format1);
logInfo.Error(format1);
}
successCount++;
}
else
{
string format = string.Format("发送{0}短信失败，原因：{1}", mobile, smsMgr.Result);
Console.WriteLine(format);
logError.Error(format);
}
}
string totalFormat = string.Format("完成发送，共{0}条信息需要发送，其中{1}条发送成功", dt.Rows.Count, successCount);
Console.WriteLine(totalFormat);
}
Thread.Sleep(1000 * 60);
}
Console.Read();
}