/// <summary>
/// 根据XML内容更新服务器申请单
/// </summary>
/// <returns></returns>
public bool Execute()
{
DateTime timeNow = DateTime.Now;
if (timeNow.DayOfWeek != DayOfWeek.Sunday)
{
//System.Threading.Thread.Sleep(30000);
AMSendWS.MsgCenter msg = new AMSendWS.MsgCenter();
msg.SendSubjectMsg("AM", "ITSM", "各位好，请将今天的工作内容发给我。谢谢！", "马卫清", "马卫清", "各位好，请将今天的工作内容发给我。谢谢！", DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
msg.SendSubjectMsg("AM", "ITSM", "各位好，请将今天的工作内容发给我。谢谢！", "刘洪", "马卫清", "各位好，请将今天的工作内容发给我。谢谢！", DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
msg.SendSubjectMsg("AM", "ITSM", "各位好，请将今天的工作内容发给我。谢谢！", "张凯军", "马卫清", "各位好，请将今天的工作内容发给我。谢谢！", DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
msg.SendSubjectMsg("AM", "ITSM", "各位好，请将今天的工作内容发给我。谢谢！", "郭琦琦", "马卫清", "各位好，请将今天的工作内容发给我。谢谢！", DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
msg.SendSubjectMsg("AM", "ITSM", "各位好，请将今天的工作内容发给我。谢谢！", "俞晓东", "马卫清", "各位好，请将今天的工作内容发给我。谢谢！", DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
Dbconn conn = new Dbconn("WS_Log");
conn.Excute("INSERT INTO Log_MDMTEST (name1) values('" + System.Net.Dns.GetHostName() + "')");
}
return true;
}
private void Resend()
{
string strName = Request["Name"];
string strOldPhone = Request["oldphone"];
string strNewPhone = Request["newphone"];
string strcrdate = Request["crdate"].ToString();
string strsums = Request["sums"].ToString();
string strticketid = Request["ticketid"].ToString();
string strverifycode = Request["verifycode"].ToString();
string strVipID = Request["vipid"].ToString();
string strUid = Request["uid"].ToString();
if (string.IsNullOrEmpty(strOldPhone) ||
string.IsNullOrEmpty(strcrdate) ||
string.IsNullOrEmpty(strsums) ||
string.IsNullOrEmpty(strticketid) ||
string.IsNullOrEmpty(strVipID) ||
string.IsNullOrEmpty(strUid)
)
{
Response.Write("{'Message':'非法提交'}");
return;
}
else
{
if (strNewPhone == null)
{
strNewPhone = "";
}
string strPhone = strNewPhone;
if (strPhone == "")
{
strPhone = strOldPhone;
}
string strMessage = "尊敬的" + strName;
strMessage += "贵宾,您已通过EP雅莹店铺" + strcrdate.ToString() + "成功以";
strMessage += Convert.ToDecimal(strsums) * 25;
strMessage += "分兑换面额为" + strsums + "的券，券号" + strticketid;
strMessage += "，使用即使验证码：" + strverifycode;
strMessage += "。生活之美，EP雅莹愿与您一同缔造。";
AMSendWS.MsgCenter cls = new AMSendWS.MsgCenter();
string strResult = cls.SendSubjectMsgImmediately("SMS", "ep_actualtime", "积分兑换券验证码", strPhone, "信息部服务中心", strMessage, DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
if (strResult == "0")
{
Response.Write("{'Message':'发送成功'}");
}
else
{
Response.Write("{'Message':'发送失败，原因：" + strResult.Remove('\n') + "'}");
}
//写日志
DataTable dt = new DataTable();
dt.Columns.Add("Account_Id");
dt.Columns.Add("Phone_Old");
dt.Columns.Add("Phone_New");
dt.Columns.Add("Ticket_Id");
dt.Columns.Add("Create_UserId");
dt.Columns.Add("Create_Time");
DataRow dr = dt.NewRow();
dr["Account_Id"] = strVipID;
dr["Phone_Old"] = strOldPhone;
dr["Phone_New"] = strNewPhone;
dr["Ticket_Id"] = strticketid;
dr["Create_UserId"] = strUid;
dr["Create_Time"] = DateTime.Now;
dt.Rows.Add(dr);
string strConnstr = ConfigurationManager.AppSettings["ConnectionString_CRMCUS"];
Dbconn conn = new Dbconn(strConnstr, true);
conn.BeginTransaction();
conn.Insert("Log_PhoneChange", dt);
conn.CommitTransaction();
return;
}
}
public static void SendAMMessage(string strGuid, string strAMRevier,string strTitle,string strContent)
{
AMSendWS.MsgCenter msg = new AMSendWS.MsgCenter();
string strResult = msg.SendSubjectMsg("AM", "ITSM", strTitle, strAMRevier, "信息部服务中心", strContent, DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
}
/// <summary>
/// 获取MDM应用的数据
/// </summary>
/// <returns></returns>
public bool Execute()
{
DateTime dateStart = DateTime.Now;
DateTime dateEnd = DateTime.Now;
if (m_request != null && m_request.Tables.Count >0 && m_request.Tables[0].Rows.Count == 1)
{
if (m_request.Tables[0].Columns.Contains("dateStart"))
{
dateStart = Convert.ToDateTime(m_request.Tables[0].Rows[0]["dateStart"]).AddDays(-1);
}
if (m_request.Tables[0].Columns.Contains("dateEnd"))
{
dateEnd = Convert.ToDateTime(m_request.Tables[0].Rows[0]["dateEnd"]).AddDays(-1);
}
}
DateTime currentDate = dateStart;
Dbconn conn = new Dbconn("BI_CustomerFlow");
DataTable dtLog = new DataTable();
dtLog.Columns.Add("Execute_Date");
dtLog.Columns.Add("Result");
dtLog.Columns.Add("Message");
dtLog.Columns.Add("Exception");
while (currentDate <= dateEnd)
{
try
{
dtLog.Clear();
//获取FTP的数据
GetFTPData(currentDate);
conn.LockTableList.Add("T_CustomerFlow");
conn.BeginTransaction();
conn.Delete("T_CustomerFlow", "Local_Date_and_Time between '" + currentDate.ToString("yyyy-MM-dd 00:00:00.000") + "' and '" + currentDate.ToString("yyyy-MM-dd 23:59:59.999") + "' ");
//插入数据
conn.InsertBYSQLBC("T_CustomerFlow", m_dtFTP);
dtLog.Rows.Add(new object[] { currentDate, true, "", "" });
conn.Insert("Log_GetFTPData", dtLog);
//throw new Exception("test");
conn.CommitTransaction();
}
catch (Exception ex)
{
conn.RollbackTransaction();
try
{
dtLog.Rows.Add(new object[] { currentDate, false, ex.Message, ex.ToString() });
conn.BeginTransaction();
conn.Insert("Log_GetFTPData", dtLog);
conn.CommitTransaction();
}
catch (Exception ex1)
{
}
try
{
AMSendWS.MsgCenter cls = new AMSendWS.MsgCenter();
cls.SendMsg("AM", "BI客流数据获取", "马卫清", "信息部服务中心", "BI客流数据获取:执行日期：“" + currentDate.ToString("yyyy-MM-dd") + "”时发生错误：" + ex.ToString(), DateTime.Now.AddDays(-1).ToString());
}
catch (Exception ex2)
{
}
}
currentDate = currentDate.AddDays(1);
}
return true;
}
private void Resend()
{
string strName = Request["Name"];
string strOldPhone = Request["oldphone"];
string strNewPhone = Request["newphone"];
string strcrdate = Request["crdate"].ToString();
string strsums = Request["sums"].ToString();
string strticketid = Request["ticketid"].ToString();
string strverifycode = Request["verifycode"].ToString();
string strVipID = Request["vipid"].ToString();
string strUid = Request["uid"].ToString();
if (string.IsNullOrEmpty(strOldPhone)
|| string.IsNullOrEmpty(strcrdate)
|| string.IsNullOrEmpty(strsums)
|| string.IsNullOrEmpty(strticketid)
|| string.IsNullOrEmpty(strVipID)
|| string.IsNullOrEmpty(strUid)
)
{
Response.Write("{'Message':'非法提交'}");
return;
}
else
{
if (strNewPhone == null)
{
strNewPhone = "";
}
string strPhone = strNewPhone;
if (strPhone == "")
{
strPhone = strOldPhone;
}
string strMessage = "尊敬的"+strName;
strMessage += "贵宾,您已通过EP雅莹店铺" + strcrdate.ToString() + "成功以";
strMessage += Convert.ToDecimal(strsums) * 25;
strMessage += "分兑换面额为" + strsums + "的券，券号" + strticketid;
strMessage += "，使用即使验证码：" + strverifycode;
strMessage += "。生活之美，EP雅莹愿与您一同缔造。";
AMSendWS.MsgCenter cls = new AMSendWS.MsgCenter();
string strResult = cls.SendSubjectMsgImmediately("SMS", "ep_actualtime", "积分兑换券验证码", strPhone, "信息部服务中心", strMessage, DateTime.Now.AddHours(-1).ToString("yyyy-MM-dd HH:mm:ss"), "1");
if (strResult == "0")
{
Response.Write("{'Message':'发送成功'}");
}
else
{
Response.Write("{'Message':'发送失败，原因：" + strResult.Remove('\n') + "'}");
}
//写日志
DataTable dt = new DataTable();
dt.Columns.Add("Account_Id");
dt.Columns.Add("Phone_Old");
dt.Columns.Add("Phone_New");
dt.Columns.Add("Ticket_Id");
dt.Columns.Add("Create_UserId");
dt.Columns.Add("Create_Time");
DataRow dr = dt.NewRow();
dr["Account_Id"] = strVipID;
dr["Phone_Old"] = strOldPhone;
dr["Phone_New"] = strNewPhone;
dr["Ticket_Id"] = strticketid;
dr["Create_UserId"] = strUid;
dr["Create_Time"] = DateTime.Now;
dt.Rows.Add(dr);
string strConnstr = ConfigurationManager.AppSettings["ConnectionString_CRMCUS"];
Dbconn conn = new Dbconn(strConnstr, true);
conn.BeginTransaction();
conn.Insert("Log_PhoneChange", dt);
conn.CommitTransaction();
return;
}
}
public bool Execute()
{
bool bSendAMMessage = false; //变量，判断是否需要发送小翅膀信息
Dbconn conn = new Dbconn("MDM"); //创建MDM的连接对象
string strTask_ID = this.m_request.Tables[0].Rows[0]["TASK_ID"].ToString(); //获取参数任务ID
bool strExecute_Result = Convert.ToBoolean(this.m_request.Tables[0].Rows[0]["Execute_Result"]); //获取参数执行结果
string Execute_StartTime = this.m_request.Tables[0].Rows[0]["Execute_StartTime"].ToString(); //获取参数执行开始时间
int nRemind_ErrorCount = 1;//错误次数达到多少时提醒，默认设置1
string strRemind_UserName = string.Empty; //达到错误次数时，需要提醒的用户
string strTaskName = string.Empty;
//创建DataTable
DataTable dtWS_Scheduling = new DataTable();
dtWS_Scheduling.Columns.Add("TASK_ID");
dtWS_Scheduling.Columns.Add("Last_Execute_Time");
if (strExecute_Result)
{
dtWS_Scheduling.Columns.Add("Last_Execute_Right_Time");
}
dtWS_Scheduling.Columns.Add("Error_Count");
//设置更新信息
DataRow dr = dtWS_Scheduling.NewRow();
dr["TASK_ID"] = strTask_ID;
dr["Last_Execute_Time"] = Execute_StartTime;
if (strExecute_Result)
{
dr["Last_Execute_Right_Time"] = Execute_StartTime;
dr["Error_Count"] = 0;
}
else
{
//根据TaskID获取任务名称，错误次数，提醒错误次数，需提醒用户
DataTable dtOld = conn.GetDataTable("SELECT WS_Name,Error_Count,Remind_ErrorCount, Remind_UserName FROM dbo.WS_Scheduling WHERE TASK_ID = @Param0", new string[] { strTask_ID });
if (dtOld.Rows.Count == 0)
{
return false;
}
int nError_Count = dtOld.Rows[0]["Error_Count"] == DBNull.Value ? 0 : Convert.ToInt32(dtOld.Rows[0]["Error_Count"]);
nRemind_ErrorCount = dtOld.Rows[0]["Remind_ErrorCount"] == DBNull.Value ? 1 : Convert.ToInt32(dtOld.Rows[0]["Remind_ErrorCount"]);
strRemind_UserName = dtOld.Rows[0]["Remind_UserName"] == DBNull.Value ? "郭琦琦" : dtOld.Rows[0]["Remind_UserName"].ToString();
strTaskName = dtOld.Rows[0]["WS_Name"] == DBNull.Value ? string.Empty : dtOld.Rows[0]["WS_Name"].ToString();
dr["Error_Count"] = nError_Count + 1;
if (nError_Count == nRemind_ErrorCount)
{
bSendAMMessage = true;
}
}
dtWS_Scheduling.Rows.Add(dr);
//创建插入日志表的DataTable
DataTable dtWS_Scheduling_Execute_log = this.m_request.Tables[0].Copy();
ArrayList listLockTable = new ArrayList();
listLockTable.Add("WS_Scheduling");
listLockTable.Add("WS_Scheduling_Execute_log");
try
{
conn.TableLock(listLockTable);
conn.BeginTransaction();
//更新WS_Scheduling表
conn.Update("WS_Scheduling", dtWS_Scheduling, "TASK_ID='" + strTask_ID + "'");
//往dbo.WS_Scheduling_Execute_log表里面增加数据
conn.Insert("WS_Scheduling_Execute_log", dtWS_Scheduling_Execute_log);
conn.CommitTransaction();
}
catch
{
conn.RollbackTransaction();
}
dtWS_Scheduling_Execute_log = null; //清空
dtWS_Scheduling = null; //清空
if (bSendAMMessage)
{
//小翅膀发送信息对象
AMSendWS.MsgCenter cls = new AMSendWS.MsgCenter();
//发送信息
StringBuilder sbContent = new StringBuilder();
sbContent.Append(" 任务[");
sbContent.Append(strTaskName);
sbContent.Append("]在重试");
sbContent.Append(nRemind_ErrorCount);
sbContent.Append("次之后仍然出错，请查看192.168.0.64:MDM数据库的WS_Scheduling，发生时间为：");
sbContent.Append(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
//发送信息
cls.SendMsg("AM", "WEB Service调用程序", strRemind_UserName, "信息部服务中心", sbContent.ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
cls.SendMsg("SMS", "WEB Service调用程序", "13736814324", "", sbContent.ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
return true;
}
