private static int AutoSelect(AutoIssueCreateEntity autogotelplanEntity) { StringBuilder sbString = new StringBuilder(); DataSet dsResult = AutoIssueCreateDA.AutoListSelect(autogotelplanEntity); StringBuilder sbResult = new StringBuilder(); string strIssueID = string.Empty; foreach (DataRow drRow in dsResult.Tables[0].Rows) { strIssueID = AutoIssueCreateDA.InsertIssueData(drRow); if (!String.IsNullOrEmpty(strIssueID)) { drRow["IssueID"] = strIssueID; drRow["Title"] = String.Format(drRow["Title"].ToString(), drRow["IssueID"].ToString()); AutoIssueCreateDA.UpdateIssueData(drRow); sbString.Append("<tr><td align='center'>" + drRow["IssueID"].ToString() + "</td><td align='center'>" + SetIssueLink(drRow["IssueID"].ToString(), drRow["Title"].ToString()) + "</td><td align='center'>" + drRow["Priority"].ToString() + "</td><td align='center'>" + SetIssueTypeNM(drRow["IssueType"].ToString()) + "</td><td align='center'>" + drRow["DISStatus"].ToString() + "</td><td align='center'>" + drRow["RelatedTypeNM"].ToString() + "</td><td align='center'>" + drRow["RelatedID"].ToString() + "</td><td align='center'>" + drRow["CreateUser"].ToString() + "</td><td align='center'>" + DateTime.Now.ToString() + "</td><td align='center'>" + drRow["AssigntoNm"].ToString() + "</td></tr>"); sbResult.Append("<div style='font-size:16;font-family:Microsoft YaHei;font-weight:bold;'>"); //sbResult.Append("Dear " + dsResult.Tables[0].Rows[0]["AssigntoNm"].ToString() + ", <br/><br/>"); sbResult.Append("Dear All, <br/><br/>"); sbResult.Append("您已经被指派了一个新的Issue,Issue概要:<br/><br/>"); sbResult.Append("<table style='font-size:14;font-family:Microsoft YaHei;' border='1'><tr style='background-color:#f6f6f6;font-weight:bold;'><td style='width:100px' align='center'>IssueID</td><td style='width:150px' align='center'>Title</td><td style='width:80px' align='center'>优先级</td><td style='width:100px' align='center'>类别</td><td style='width:80px' align='center'>状态</td><td style='width:100px' align='center'>关联Item</td><td style='width:150px' align='center'>关联ID</td><td style='width:80px' align='center'>创建人</td><td style='width:150px' align='center'>创建时间</td><td style='width:120px' align='center'>Assign指派</td></tr>" + sbString.ToString().Trim() + "</table><br/><br/>"); sbResult.Append("BR<br/>"); sbResult.Append("Hotelvp CMS<br/>"); sbResult.Append("</div>"); SendMailExpress(sbResult.ToString(), "0", "[IssueID:" + drRow["IssueID"].ToString() + "] Newly Assigned Issue Notification", ""); sbString = new StringBuilder(); sbResult = new StringBuilder(); } } return dsResult.Tables[0].Rows.Count; }
//static string _nameSpaceClass = "HotelVp.JobConsole.Biz.AutoIssueCreating Method: "; public static void AutoIssueCreating(string ActionType) { DateTime dtBegin = new DateTime(); dtBegin = System.DateTime.Now; AutoIssueCreateEntity _autoissuecreateEntity = new AutoIssueCreateEntity(); CommonEntity _commonEntity = new CommonEntity(); _autoissuecreateEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _autoissuecreateEntity.LogMessages.Userid = "JOB System"; _autoissuecreateEntity.LogMessages.Username = "******"; _autoissuecreateEntity.AutoMsgCancelOrdDBEntity = new List<AutoMsgCancelOrdDBEntity>(); AutoMsgCancelOrdDBEntity appcontentDBEntity = new AutoMsgCancelOrdDBEntity(); _autoissuecreateEntity.AutoMsgCancelOrdDBEntity.Add(appcontentDBEntity); Console.WriteLine("问题订单自动创建Issue单JOB自动运行开始"); //所有CC取消状态为:满房/变价的自动判定为“酒店问题”Issue单 //所有LMBAR&LMBAR2的订单处理时长超过30分钟自动判定为“订单问题”Issue单 int iCount = 0; if ("1".Equals(ActionType)) { AutoTodaySelect(); } else if ("2".Equals(ActionType)) { iCount = AutoSelectHotel(_autoissuecreateEntity); } else { iCount = AutoSelect(_autoissuecreateEntity); } Console.WriteLine("问题订单自动创建Issue单JOB自动运行 执行记录数:" + iCount.ToString()); DateTime dtEnd = new DateTime(); dtEnd = System.DateTime.Now; Console.WriteLine(dtEnd - dtBegin); }
public static DataSet AutoListSelectHotel(AutoIssueCreateEntity automsgcancelordEntity) { OracleParameter[] parm ={ new OracleParameter("StartDt",OracleType.VarChar), new OracleParameter("EndDt",OracleType.VarChar) }; parm[0].Value = DateTime.Now.AddDays(-1).ToShortDateString() + " 04:00:00"; parm[1].Value = DateTime.Now.ToShortDateString() + " 04:00:00"; DataSet dsResult = DbManager.Query("AutoIssueCreate", "AutoListSelectHotel", false, parm); return dsResult; }
public static AutoIssueCreateEntity ApplySendMsgService(AutoIssueCreateEntity automsgcancelordEntity) { AutoMsgCancelOrdDBEntity dbParm = (automsgcancelordEntity.AutoMsgCancelOrdDBEntity.Count > 0) ? automsgcancelordEntity.AutoMsgCancelOrdDBEntity[0] : new AutoMsgCancelOrdDBEntity(); string MsgContent = string.Empty; if (DateTime.Now >= DateTime.Parse(DateTime.Now.ToShortDateString() + " 18:00:00")) { MsgContent = String.Format(ConfigurationManager.AppSettings["MsgContent18after"].ToString(), dbParm.UserNM, dbParm.HotelNM); } else { MsgContent = String.Format(ConfigurationManager.AppSettings["MsgContent18befor"].ToString(), dbParm.UserNM, dbParm.HotelNM); } string DataString = ""; DataString = DataString + "{\"method\":\"save\",\"data\":{\"syscode\":\"" + "CMS" + "\",\"reqid\":\"" + dbParm.CreateUser +"\",\"bizcode\":\"" + "CMS-JOB-短信提示取消单" +"\","; DataString = DataString + "\"cnfnum\":\"" + dbParm.OrderNo + "\",\"mobiles\":\"" + dbParm.CreateUser + "\",\"msg\":\"" + MsgContent + "\","; DataString = DataString + "\"sign\":\"" + PostSignKey("CMS" + dbParm.CreateUser) + "\"},\"version\":\"v1.0\"}"; string HotelFullRoomUrl = JsonRequestURLBuilder.applySendMsgV2(); CallWebPage callWebPage = new CallWebPage(); string strHotelFullRoom = callWebPage.CallWebByURL(HotelFullRoomUrl, DataString); JObject oHotelFullRoom = JObject.Parse(strHotelFullRoom); if ("success".Equals(JsonRequestURLBuilder.GetJsonStringValue(oHotelFullRoom, "message").Trim('"'))) { automsgcancelordEntity.Result = 1; automsgcancelordEntity.ErrorMSG = "保存成功!"; } else { automsgcancelordEntity.Result = 2; automsgcancelordEntity.ErrorMSG = "保存失败!" + JsonRequestURLBuilder.GetJsonStringValue(oHotelFullRoom, "message").Trim('"'); } return automsgcancelordEntity; }
public static DataSet AutoListSelect(AutoIssueCreateEntity automsgcancelordEntity) { DataSet dsResult = DbManager.Query("AutoIssueCreate", "AutoListNewSelect", false); return dsResult; }