public void Execute(XmlNode node)
{
int curHours = 0;
int curPoint = 0;
SiteSettings masterSettings = SettingsManager.GetMasterSettings(true);
if (!string.IsNullOrWhiteSpace(masterSettings.CountDownCouponHours))
{
int.TryParse(masterSettings.CountDownCouponHours, out curHours);
}
int.TryParse(masterSettings.CountDownCouponPoint, out curPoint);
// 判断是否是该点发送提醒短信
if (DateTime.Now.Hour == curPoint)
{
DateTime curDate = DateTime.Now.AddHours(curHours);
List <CountDownCoupons> list = new List <CountDownCoupons>();
DataTable dtCoupons = CouponHelper.GetAllCountDownCoupons(curDate);
if (dtCoupons != null && dtCoupons.Rows.Count > 0)
{
foreach (DataRow r in dtCoupons.Rows)
{
CountDownCoupons cc = new CountDownCoupons();
string currcellphone = string.Empty;
string currcontent = string.Empty;
int value = 0;
if (r["CellPhone"] != null && !string.IsNullOrWhiteSpace(r["CellPhone"].ToString()))
{
currcellphone = r["CellPhone"].ToString();
}
if (r["DiscountValue"] != null && !string.IsNullOrWhiteSpace(r["DiscountValue"].ToString()))
{
value = Convert.ToInt32(r["DiscountValue"]);
}
if (r["ClosingTime"] != null && !string.IsNullOrWhiteSpace(r["ClosingTime"].ToString()) && value > 0)
{
currcontent = string.Format(masterSettings.CountDownCouponContent, value, r["ClosingTime"].ToString());
}
if (!string.IsNullOrWhiteSpace(currcellphone) && !string.IsNullOrWhiteSpace(currcontent))
{
cc.CellPhone = currcellphone;
cc.Content = currcontent;
cc.ClaimCode = r["ClaimCode"].ToString();
list.Add(cc);
}
}
if (list.Count > 0)
{
SmsHelper.QueueSMS(list, 0, 2);
}
}
}
}
private void btnTestSend_Click(object sender, System.EventArgs e)
{
//SiteSettings masterSettings = SettingsManager.GetMasterSettings(false);
//ConfigData configData = new ConfigData(HiCryptographer.Decrypt(masterSettings.SMSSettings));
//string text;
//ConfigData configData = this.LoadConfig(out text);
//if (string.IsNullOrEmpty(text) || configData == null)
//{
// this.ShowMsg("请先选择发送方式并填写配置信息", false);
// return;
//}
//if (!configData.IsValid)
//{
// string text2 = "";
// foreach (string current in configData.ErrorMsgs)
// {
// text2 += Formatter.FormatErrorMessage(current);
// }
// this.ShowMsg(text2, false);
// return;
//}
//text = this.txtSelectedName.Value;
//configData.SettingsXml = this.txtConfigData.Value;
//SMSSender sMSSender = SMSSender.CreateInstance(this.txtSelectedName.Value, this.txtConfigData.Value);
//SMSSender sMSSender = SMSSender.CreateInstance(masterSettings.SMSSender, configData.SettingsXml);
//string msg = "";
//bool success = false;
//string[] str=this.txtTestCellPhone.Text.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
//for (int i = 0; i < str.Length; i++)
//{
// if (!System.Text.RegularExpressions.Regex.IsMatch(str[i], "^(13|14|15|17|18)\\d{9}$"))
// {
// this.ShowMsg("请填写正确的手机号码", false);
// return;
// }
// success = sMSSender.Send(str[i], this.txtTestSubject.Text.Trim(), out msg);
//}
//this.ShowMsg(msg, success);
if (string.IsNullOrEmpty(this.txtTestCellPhone.Text) || string.IsNullOrEmpty(this.txtTestSubject.Text) || this.txtTestCellPhone.Text.Trim().Length == 0 || this.txtTestSubject.Text.Trim().Length == 0)
{
this.ShowMsg("接收手机号和发送内容不能为空", false);
return;
}
string[] str = this.txtTestCellPhone.Text.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
SmsHelper.QueueSMS(str, this.txtTestSubject.Text.Trim(), 0);
this.ShowMsg("已加入发送短信列表", true);
}
private void btnSend_Click(object sender, System.EventArgs e)
{
if (string.IsNullOrEmpty(this.txtSubject.Text) || this.txtSubject.Text.Trim().Length == 0)
{
this.ShowMsg("发送内容不能为空", false);
return;
}
string[] str = MemberHelper.GetAllUserCellPhones();
if (str.Length > 0)
{
SmsHelper.QueueSMS(str, this.txtSubject.Text.Trim(), 0, 2);
this.ShowMsg("已加入发送短信列表", true);
}
else
{
this.ShowMsg("未找到符合的用户", false);
return;
}
}
private void SendSKUData()
{
ErrorLog.Write("执行了SKUJob->SendSKUData");
try
{
ProductBrowseQuery query = new ProductBrowseQuery();
query.PageIndex = pageIndex;
query.PageSize = 100;
query.DateContrastType = dateContrastType;
query.DateContrastValue = dateContrastValue;
query.SendWMSCount = sendWMSCount;
ErrorLog.Write("执行了SKUJob->SendSKUData");
DataTable dt = (DataTable)ProductBrowser.GetWMSBrowseProductList(query).Data;
if (dt != null && dt.Rows.Count > 0)
{
pageIndex++;
flag = true;
string skuData = CreateSKUData(dt);
//string skuData="<xmldata><header><CustomerID>61</CustomerID><SKU>3500_0</SKU><Active_Flag>Y</Active_Flag><Descr_C>法国MEDICOX雪亮+白晳精华 30ML</Descr_C><Descr_E></Descr_E><GrossWeight></GrossWeight><NetWeight>0.00</NetWeight><Cube></Cube><Price>100.00</Price><SKULength></SKULength><SKUWidth></SKUWidth><SKUHigh></SKUHigh><CycleClass>A</CycleClass></header></xmldata>";//
//WMS 无法正常接收部分字符
skuData = skuData.Replace("\n", "").Replace("\t", "").Replace("\r", "").Replace("+", "＋");
string tempdata = appSecret + skuData + appSecret;
string md5tempdata = WMSHelper.MD5(tempdata);
string basetempdata = WMSHelper.EncodingString(md5tempdata.ToLower(), System.Text.Encoding.UTF8);
sign = System.Web.HttpUtility.UrlEncode(basetempdata.ToUpper(), System.Text.Encoding.UTF8);
//
timestamp = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");//YYYY-MM-DD HH:MM:SS
string postData = "method=putSKUData&client_customerid=" + customerid + "&client_db=" + client_db + "&messageid=SKU&apptoken=" + apptoken + "&appkey=" + appkey + "&sign=" + sign + "×tamp=" + timestamp;
//.NET和java UrlEncode处理机制不一样，加号"+"在java里面会被替换成空格，需要转换2次
skuData = System.Web.HttpUtility.UrlEncode(skuData);
//skuData = System.Web.HttpUtility.UrlEncode(skuData);
ErrorLogs("url=" + url + ";postData=" + postData + "&data=" + tempdata);
//
WMSHelper.SaveLog("putSKUData", tempdata, "调用方法", "info", "out");
//
string sendResult = WMSHelper.PostData(url, postData + "&data=" + skuData);
string tempResult = System.Web.HttpUtility.UrlDecode(sendResult);
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.LoadXml(tempResult);
XmlNode node = xmlDocument.SelectSingleNode("Response/return/returnCode");
XmlNode nodeFlag = xmlDocument.SelectSingleNode("Response/return/returnFlag");
//先全部修改成成功
for (int i = 0; i < dt.Rows.Count; i++)
{
//更新订单表同步wms成功状态
this.UpdateSKUSendStatus(dt.Rows[i]["ProductId"].ToString(), "1");
}
//
//0
if (node.InnerText != "0000")
{
ErrorLogs("调用WMS推送SKU失败:" + tempResult + "\n");
WMSHelper.SaveLog("putSKUData", "", "返回结果：" + tempResult, "error", "in");
if (nodeFlag.InnerText == "0")
{
//node.InnerText == "0001" &&
//全部失败
for (int i = 0; i < dt.Rows.Count; i++)
{
//更新订单表同步wms成功状态
this.UpdateSKUSendStatus(dt.Rows[i]["ProductId"].ToString(), "0");
}
}
else if (nodeFlag.InnerText == "2")
{
//node.InnerText == "0001" &&
foreach (XmlNode infonode in xmlDocument.SelectNodes("Response/return/resultInfo"))
{
string skuId = infonode.SelectSingleNode("SKU").InnerText;
//OrderHelper.UpdateOrderWMSStatus(orderno, 0);
this.UpdateSKUSendStatusBySKUId(skuId, "0");
}
}
SmsHelper.QueueSMS(mobiles, "系统在" + DateTime.Now.ToString("yyyy年MM月HH点mm分ss秒") + "调用WMS推送SKU(putSKUData)接口失败，详情请查询推送日志", 3);
}
}
else
{
flag = false;
}
}
catch (Exception ex)
{
ErrorLogs("出现异常：" + ex.Message + "\n");
SmsHelper.QueueSMS(mobiles, "系统在" + DateTime.Now.ToString("yyyy年MM月HH点mm分ss秒") + "调用WMS推送SKU(putSKUData)接口发生异常，详情请查询推送日志", 3);
}
if (flag)
{
SendSKUData();
}
}
private void SendOrderData()
{
ErrorLog.Write("执行了OrderSendJob->SendOrderData");
try
{
OrderQuery orderQuery = new OrderQuery();
orderQuery.PageIndex = pageIndex;
orderQuery.PageSize = 100;
orderQuery.DateContrastType = dateContrastType;
orderQuery.DateContrastValue = dateContrastValue;
orderQuery.SendWMSCount = sendWMSCount;
//ErrorLog.Write("执行了OrderSendJob->SendOrderData.GetWMSUserOrders");
OrdersInfo userOrders = OrderHelper.GetWMSUserOrders(orderQuery);
DataTable dt = (DataTable)userOrders.OrderTbl;
if (dt != null && dt.Rows.Count > 0)
//if (true)
{
ErrorLog.Write("执行了OrderSendJob->SendOrderData.GetWMSUserOrders返回查询结果:" + dt.Rows.Count);
pageIndex++;
flag = true;
string skuData = CreateSKUData(dt);
//string skuData = "<xmldata><header><OrderNo>201601060896873</OrderNo><OrderType>CM</OrderType><CustomerID>SINCNET</CustomerID><SOReference2></SOReference2><SOReference5>22</SOReference5><H_EDI_01></H_EDI_01><H_EDI_02></H_EDI_02><H_EDI_03>6.00</H_EDI_03><H_EDI_04>14.40</H_EDI_04><H_EDI_05>广东省，深圳市，龙岗区</H_EDI_05><ConsigneeID>何小娟</ConsigneeID><ConsigneeName>何小娟</ConsigneeName><C_Address1>坂田南坑街道办麒麟西七巷9栋812</C_Address1><C_Province>广东省</C_Province><C_City>深圳市</C_City><C_ZIP>000000</C_ZIP><CarrierID>YUANTONG</CarrierID><UserDefine2>何小娟</UserDefine2><C_Tel1>-</C_Tel1><C_Tel2>13692207500</C_Tel2><WarehouseID>WH01</WarehouseID><Notes></Notes><detailsItem><CustomerID>SINCNET</CustomerID><SKU>10084_0</SKU><QtyOrdered_Each>1</QtyOrdered_Each><UserDefine2>38.40</UserDefine2><UserDefine1>箱</UserDefine1><GrossWeight>0</GrossWeight></detailsItem></header><header><OrderNo>201601066096339</OrderNo><OrderType>CM</OrderType><CustomerID>SINCNET</CustomerID><SOReference2></SOReference2><SOReference5>-2</SOReference5><H_EDI_01></H_EDI_01><H_EDI_02></H_EDI_02><H_EDI_03>6.00</H_EDI_03><H_EDI_04>20.40</H_EDI_04><H_EDI_05>广东省，深圳市，宝安区</H_EDI_05><ConsigneeID>邓女士</ConsigneeID><ConsigneeName>邓女士</ConsigneeName><C_Address1>龙华新区长城里程家园4栋1单元104</C_Address1><C_Province>广东省</C_Province><C_City>深圳市</C_City><C_ZIP>518000</C_ZIP><CarrierID>YUANTONG</CarrierID><UserDefine2>邓女士</UserDefine2><C_Tel1></C_Tel1><C_Tel2>13602509805</C_Tel2><WarehouseID>WH01</WarehouseID><Notes></Notes><detailsItem><CustomerID>SINCNET</CustomerID><SKU>10055_0</SKU><QtyOrdered_Each>2</QtyOrdered_Each><UserDefine2>10.30</UserDefine2><UserDefine1>包</UserDefine1><GrossWeight>0</GrossWeight></detailsItem><detailsItem><CustomerID>SINCNET</CustomerID><SKU>10071_0</SKU><QtyOrdered_Each>2</QtyOrdered_Each><UserDefine2>11.90</UserDefine2><UserDefine1>包</UserDefine1><GrossWeight>0</GrossWeight></detailsItem></header><header><OrderNo>20160106174579511</OrderNo><OrderType>CM</OrderType><CustomerID>SINCNET</CustomerID><SOReference2></SOReference2><SOReference5>26</SOReference5><H_EDI_01></H_EDI_01><H_EDI_02></H_EDI_02><H_EDI_03>7.00</H_EDI_03><H_EDI_04>83.80</H_EDI_04><H_EDI_05>广东省，深圳市，福田区</H_EDI_05><ConsigneeID>林宏涛</ConsigneeID><ConsigneeName>林宏涛</ConsigneeName><C_Address1>福强路宝田苑A1502</C_Address1><C_Province>广东省</C_Province><C_City>深圳市</C_City><C_ZIP>000000</C_ZIP><CarrierID>YUANTONG</CarrierID><UserDefine2>林宏涛</UserDefine2><C_Tel1>-</C_Tel1><C_Tel2>13828811950</C_Tel2><WarehouseID>WH01</WarehouseID><Notes></Notes><detailsItem><CustomerID>SINCNET</CustomerID><SKU>10088_0</SKU><QtyOrdered_Each>1</QtyOrdered_Each><UserDefine2>38.40</UserDefine2><UserDefine1>箱</UserDefine1><GrossWeight>0</GrossWeight></detailsItem><detailsItem><CustomerID>SINCNET</CustomerID><SKU>10089_0</SKU><QtyOrdered_Each>1</QtyOrdered_Each><UserDefine2>38.40</UserDefine2><UserDefine1>箱</UserDefine1><GrossWeight>0</GrossWeight></detailsItem></header><header><OrderNo>20160106174579521</OrderNo><OrderType>CM</OrderType><CustomerID>SINCNET</CustomerID><SOReference2></SOReference2><SOReference5>26</SOReference5><H_EDI_01></H_EDI_01><H_EDI_02></H_EDI_02><H_EDI_03>6.00</H_EDI_03><H_EDI_04>42.20</H_EDI_04><H_EDI_05>广东省，深圳市，福田区</H_EDI_05><ConsigneeID>林宏涛</ConsigneeID><ConsigneeName>林宏涛</ConsigneeName><C_Address1>福强路宝田苑A1502</C_Address1><C_Province>广东省</C_Province><C_City>深圳市</C_City><C_ZIP>000000</C_ZIP><CarrierID>YUANTONG</CarrierID><UserDefine2>林宏涛</UserDefine2><C_Tel1>-</C_Tel1><C_Tel2>13828811950</C_Tel2><WarehouseID>WH01</WarehouseID><Notes></Notes><detailsItem><CustomerID>SINCNET</CustomerID><SKU>10142_0</SKU><QtyOrdered_Each>2</QtyOrdered_Each><UserDefine2>18.10</UserDefine2><UserDefine1>支</UserDefine1><GrossWeight>0</GrossWeight></detailsItem></header><header><OrderNo>201601062078357</OrderNo><OrderType>CM</OrderType><CustomerID>SINCNET</CustomerID><SOReference2></SOReference2><SOReference5>-2</SOReference5><H_EDI_01></H_EDI_01><H_EDI_02></H_EDI_02><H_EDI_03>6.00</H_EDI_03><H_EDI_04>6.90</H_EDI_04><H_EDI_05>广东省，湛江市，雷州市</H_EDI_05><ConsigneeID>林嘉豪</ConsigneeID><ConsigneeName>林嘉豪</ConsigneeName><C_Address1>雷州市第八中学</C_Address1><C_Province>广东省</C_Province><C_City>湛江市</C_City><C_ZIP>524200</C_ZIP><CarrierID>YUANTONG</CarrierID><UserDefine2>林嘉豪</UserDefine2><C_Tel1></C_Tel1><C_Tel2>18344175319</C_Tel2><WarehouseID>WH01</WarehouseID><Notes></Notes><detailsItem><CustomerID>SINCNET</CustomerID><SKU>10055_0</SKU><QtyOrdered_Each>3</QtyOrdered_Each><UserDefine2>10.30</UserDefine2><UserDefine1>包</UserDefine1><GrossWeight>0</GrossWeight></detailsItem></header></xmldata>";
//WMS 无法正常接收部分字符
skuData = skuData.Replace("\n", "").Replace("\t", "").Replace("\r", "").Replace("+", "＋");
string tempdata = appSecret + skuData + appSecret;
string md5tempdata = WMSHelper.MD5(tempdata);
string basetempdata = WMSHelper.EncodingString(md5tempdata.ToLower(), System.Text.Encoding.UTF8);
sign = System.Web.HttpUtility.UrlEncode(basetempdata.ToUpper(), System.Text.Encoding.UTF8);
//
timestamp = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");//YYYY-MM-DD HH:MM:SS
string postData = "method=putSOData&client_customerid=" + customerid + "&client_db=" + client_db + "&messageid=SO&apptoken=" + apptoken + "&appkey=" + appkey + "&sign=" + sign + "×tamp=" + timestamp;
//
skuData = System.Web.HttpUtility.UrlEncode(skuData);
//skuData = System.Web.HttpUtility.UrlEncode(skuData);
ErrorLogs("url=" + url + ";postData=" + postData + "&data=" + tempdata);
//数据库日志
WMSHelper.SaveLog("putSOData", tempdata, "调用方法", "info", "out");
string sendResult = WMSHelper.PostData(url, postData + "&data=" + skuData);
string tempResult = System.Web.HttpUtility.UrlDecode(sendResult);
//
ErrorLogs("接收WMS消息:" + tempResult + "\n");
WMSHelper.SaveLog("putSOData", "", "返回结果：" + tempResult, "error", "in");
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.LoadXml(tempResult);
XmlNode node = xmlDocument.SelectSingleNode("Response/return/returnCode");
XmlNode nodeFlag = xmlDocument.SelectSingleNode("Response/return/returnFlag");
//先全部修改成成功
for (int i = 0; i < dt.Rows.Count; i++)
{
//更新订单表同步wms成功状态
OrderHelper.UpdateOrderWMSStatus(dt.Rows[i]["OrderId"].ToString(), 1);
}
//
//0
if (node.InnerText != "0000")
{
ErrorLogs("调用WMS推送订单失败:" + tempResult + "\n");
WMSHelper.SaveLog("putSOData", "", "返回结果：" + tempResult, "error", "in");
if (nodeFlag.InnerText == "0")
{
//node.InnerText == "0001" &&
//全部失败
for (int i = 0; i < dt.Rows.Count; i++)
{
//更新订单表同步wms成功状态
OrderHelper.UpdateOrderWMSStatus(dt.Rows[i]["OrderId"].ToString(), 0);
}
}
else if (nodeFlag.InnerText == "2")
{
//node.InnerText == "0001" &&
foreach (XmlNode infonode in xmlDocument.SelectNodes("Response/return/resultInfo"))
{
string orderno = infonode.SelectSingleNode("OrderNo").InnerText;
OrderHelper.UpdateOrderWMSStatus(orderno, 0);
}
}
SmsHelper.QueueSMS(mobiles, "系统在" + DateTime.Now.ToString("yyyy年MM月HH点mm分ss秒") + "调用WMS推送订单(putSOData)接口失败，详情请查询推送日志", 3);
}
}
else
{
flag = false;
}
}
catch (Exception ex)
{
ErrorLogs("出现异常：" + ex.Message);
SmsHelper.QueueSMS(mobiles, "系统在" + DateTime.Now.ToString("yyyy年MM月HH点mm分ss秒") + "调用WMS推送订单(putSOData)接口发生异常，详情请查询推送日志", 3);
}
if (flag)
{
SendOrderData();
}
}
private void SendSupplierData()
{
ErrorLog.Write("执行了SupplierJobs -> SendSupplierData");
try
{
string setdate = this.GetOrderSendCoupontime();
SupplierQuery query = new SupplierQuery();
query.PageIndex = pageIndex;
query.PageSize = 100;
query.DateContrastType = dateContrastType;
query.DateContrastValue = dateContrastValue;
query.DataVersion = setdate;
query.SortBy = "DataVersion";
ErrorLog.Write("执行了SupplierJobs -> GetWMSSupplier");
DataTable dt = (DataTable)SupplierHelper.GetWMSSupplier(query).Data;
ErrorLog.Write("执行了SupplierJobs -> GetWMSSupplier 查询完成");
if (dt != null && dt.Rows.Count > 0)
{
ErrorLog.Write("执行了SupplierJobs -> GetWMSSupplier 查询结果：" + dt.Rows.Count);
pageIndex++;
flag = true;
string skuData = CreateSupplierData(dt);
//WMS 无法正常接收部分字符
skuData = skuData.Replace("\n", "").Replace("\t", "").Replace("\r", "").Replace("+", "＋");
string tempdata = appSecret + skuData + appSecret;
string md5tempdata = WMSHelper.MD5(tempdata);
string basetempdata = WMSHelper.EncodingString(md5tempdata.ToLower(), System.Text.Encoding.UTF8);
sign = System.Web.HttpUtility.UrlEncode(basetempdata.ToUpper(), System.Text.Encoding.UTF8);
//
timestamp = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");//YYYY-MM-DD HH:MM:SS
string postData = "method=putCustData&client_customerid=" + customerid + "&client_db=" + client_db + "&messageid=CUSTOMER&apptoken=" + apptoken + "&appkey=" + appkey + "&sign=" + sign + "×tamp=" + timestamp;
//.NET和java UrlEncode处理机制不一样，加号"+"在java里面会被替换成空格，需要转换2次
skuData = System.Web.HttpUtility.UrlEncode(skuData);
//skuData = System.Web.HttpUtility.UrlEncode(skuData);
//文本日志
ErrorLogs("url=" + url + ";postData=" + postData + "&data=" + tempdata);
//数据库日志
WMSHelper.SaveLog("putCustData", tempdata, "调用方法", "info", "out");
string sendResult = WMSHelper.PostData(url, postData + "&data=" + skuData);
string tempResult = System.Web.HttpUtility.UrlDecode(sendResult);
XmlDocument xmlDocument = new XmlDocument();
xmlDocument.LoadXml(tempResult);
XmlNode node = xmlDocument.SelectSingleNode("Response/return/returnCode");
if (node.InnerText != "0000")
{
ErrorLogs("调用WMS推送商家失败:" + tempResult + "\n");
WMSHelper.SaveLog("putCustData", "", "返回结果：" + tempResult, "error", "in");
SmsHelper.QueueSMS(mobiles, "系统在" + DateTime.Now.ToString("yyyy年MM月HH点mm分ss秒") + "调用WMS推送商家(putCustData)接口失败，详情请查询推送日志", 3);
}
else
{
//更新最后一个推送WMS客户档案时间戳
this.UpdateOrderSendCoupontime(dt.Rows[dt.Rows.Count - 1]["DataVersion"].ToString());
}
}
else
{
flag = false;
}
}
catch (Exception ex)
{
ErrorLogs("出现异常：" + ex.Message);
SmsHelper.QueueSMS(mobiles, "系统在" + DateTime.Now.ToString("yyyy年MM月HH点mm分ss秒") + "调用WMS推送商家(putCustData)接口发生异常，详情请查询推送日志", 3);
}
if (flag)
{
SendSupplierData();
}
}
