public int InsertDeliverStatus(DeliverStatus dsmodel) { string sqlDS = string.Format("insert into deliver_status(deliver_id,state,settime,endtime,freight_type,Logistics_providers) values({0},{1},'{2}','{3}',{4},{5})", dsmodel.deliver_id, dsmodel.state, CommonFunction.DateTimeToString(dsmodel.settime), CommonFunction.DateTimeToString(dsmodel.endtime), dsmodel.freight_type, dsmodel.Logistics_providers); int row = _accessMySql.execCommand(sqlDS); return row; }
public bool Start(string schedule_code,DateTime startTime) { DeliverStatusDao dsDao = new DeliverStatusDao(mySqlConnectionString); // DateTime startTime = DateTime.Now; string HourNum = string.Empty; MailModel mailModel = new MailModel(); mailModel.MysqlConnectionString = mySqlConnectionString; string GroupCode = string.Empty; string MailTitle = string.Empty; string MailBody = string.Empty; //bool IsSeparate = false; //bool IsDisplyName = true; //獲取該排程參數 List<ScheduleConfigQuery> store_config = new List<ScheduleConfigQuery>(); ScheduleConfigQuery query_config = new ScheduleConfigQuery(); query_config.schedule_code = schedule_code; ScheduleServiceMgr _secheduleServiceMgr = new ScheduleServiceMgr(mySqlConnectionString); store_config = _secheduleServiceMgr.GetScheduleConfig(query_config); foreach (ScheduleConfigQuery item in store_config) { if (item.parameterCode.Equals("HourNum")) { HourNum = item.value; } else if (item.parameterCode.Equals("MailFromAddress")) { mailModel.MailFromAddress = item.value; } else if (item.parameterCode.Equals("MailHost")) { mailModel.MailHost = item.value; } else if (item.parameterCode.Equals("MailPort")) { mailModel.MailPort = item.value; } else if (item.parameterCode.Equals("MailFromUser")) { mailModel.MailFromUser = item.value; } else if (item.parameterCode.Equals("MailFormPwd")) { mailModel.MailFormPwd = item.value; } else if (item.parameterCode.Equals("GroupCode")) { GroupCode = item.value; } else if (item.parameterCode.Equals("MailTitle")) { MailTitle = item.value; } else if (item.parameterCode.Equals("MailTitle")) { MailTitle = item.value; } else if (item.parameterCode.Equals("MailBody")) { MailBody = item.value; } } IDeliverMasterImplMgr DeliverMaster = new DeliverMasterMgr(mySqlConnectionString); DataTable table = DeliverMaster.GetDeliverMaster(HourNum); int delNumber = table.Rows.Count; int updateNumber = 0; if (delNumber > 0) { DeliveryInfo Model; LogisticsTcatSodDao LTSDao=new LogisticsTcatSodDao(mySqlConnectionString); for (int i = 0; i < table.Rows.Count; i++) { table.Rows[i]["gettime"] = ""; Model =LTSDao.GetLogisticsTcatSod(table.Rows[i]["delivery_code"].ToString()); if (Model.Status == "順利送達") { table.Rows[i]["gettime"] = Model.CreateTime; updateNumber++; DeliverStatus dsmodel = new DeliverStatus(); dsmodel.freight_type = 11;//物流配送模式 dsmodel.Logistics_providers = 1;//物流商 dsmodel.deliver_id = Int64.Parse(table.Rows[i]["deliver_id"].ToString()); dsmodel.state = 99; dsmodel.settime = Model.CreateTime; dsmodel.endtime = Model.CreateTime; dsDao.InsertDeliverStatus(dsmodel); } } } DateTime endTime = DateTime.Now; TimeSpan ts = endTime - startTime; double Second = ts.TotalSeconds; int num1 = 0;//期望到貨日<運達時間的物流單個數 int num2 = 0;//期望到貨日>今天的物流單個數 MailHelper mail = new MailHelper(mailModel); StringBuilder sbmailBody = new StringBuilder(); string tablestr = GetHtmlByDataTable(GetSendTable(table), out num1, out num2); sbmailBody.Append("物流狀態抓取排程執行成功<br/>"); sbmailBody.Append("更新<span style=\"font-size:large;\">" + delNumber + "</span>個出貨單<br/>"); sbmailBody.Append("更新<span style=\"font-size:large;\">" + updateNumber + "</span>個物流單<br/>"); sbmailBody.Append("期望到貨日小於運達時間的物流單個數:<span style=\"font-size:large;\">" + num1 + "</span><br/>"); sbmailBody.Append("期望到貨日小於今天的物流單個數:<span style=\"font-size:large;\">" + num2 + "</span><br/>"); sbmailBody.Append("共耗時<span style=\"font-size:large;\">" + Second + "</span>秒<br/>"); sbmailBody.Append("更新出貨單詳情如下:<br/><br/>"); sbmailBody.Append(tablestr); return mail.SendToGroup(GroupCode, MailTitle,sbmailBody.ToString(), false, true); }