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