//信息错误提醒,提醒前一天内错误信息 protected void getcwtx() { net.sogal.www.WebService aa = new SFYWebApi.net.sogal.www.WebService(); string strjson = aa.GetPoRequisition(DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd")), DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")));//传入参数 DataTable dtbl = new DataTable(); dtbl = Json2Dtb(strjson); DataTable newdt = new DataTable(); string sqlCmd = "select * from SFYOrderTab where CREATION_DATE between '" + DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd")) + "' and '" + DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")) + "'"; SqlSel.GetSqlSel(ref newdt, sqlCmd); if (dtbl.Rows.Count > newdt.Rows.Count)//当索菲亚服务端大于本地 { Label3.Text += "索菲亚数据和本地数据不对应!在" + DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd") + ",请重新获取!"; } }
protected void Button2_Click(object sender, EventArgs e) { string sqlcmd = ""; string sqltr = ""; for (int i = 0; i < GridView1.Rows.Count; i++) { string hdid = this.GridView1.Rows[i].Cells[13].Text; string lineid = this.GridView1.Rows[i].Cells[14].Text; string orderid = this.GridView1.Rows[i].Cells[15].Text; string fhrq = ((TextBox)(GridView1.Rows[i].Cells[0].Controls[0]).FindControl("TextBox3")).Text.Trim().ToString(); string bzrmk = ((TextBox)(GridView1.Rows[i].Cells[0].Controls[0]).FindControl("txtBZRMK")).Text.Trim().ToString(); //TextBox txb = GridView1.Rows[i].Cells[8].FindControl("TextBox3") as TextBox; //string data = txb.Text.Trim(); if (fhrq != "" || bzrmk != "") { sqltr = "select YJFHRQ from yjfhtab where OrderID='" + orderid + "' and FKSate=0 "; //未同步到索菲亚 String YJFH = Convert.ToString(SqlSel.GetSqlScale(sqltr)); sqltr = "select YJFHRQ from yjfhtab where OrderID='" + orderid + "' and FKSate=1 "; //已同步到索菲亚 String YJFH2 = Convert.ToString(SqlSel.GetSqlScale(sqltr)); if (YJFH != "") //可更新 { sqlcmd = "update YJFHTab set Header_ID='" + hdid + "',Line_ID='" + lineid + "',YJFHRQ='" + fhrq + "',Remark='" + bzrmk + "',FKSate=0 where OrderID='" + orderid + "' "; int execountsp = SqlSel.ExeSql(sqlcmd); if (execountsp == 0) { break; } } else if (YJFH2 != "")//直接跳出 { break; } else { sqlcmd = "insert into YJFHTab(Header_ID,Line_ID,YJFHRQ,Remark,FKSate,OrderID) values('" + hdid + "','" + lineid + "','" + fhrq + "','" + bzrmk + "',0,'" + orderid + "') "; int execounts = SqlSel.ExeSql(sqlcmd); if (execounts == 0) { break; } } } } Label1.Text = "保存成功。"; }
protected void Button1_Click(object sender, EventArgs e) { //获取所有网店管家省市区信息 //addMap = wdgjService.wdgj_AddressMap(); //获取网店管家省市区实时信息 //DataSet addMap = new DataSet(); if (System.Web.HttpContext.Current.Session["addMap"] != null) { addMap = (DataSet)System.Web.HttpContext.Current.Session["addMap"]; } else { wdgjWebService.wdgjWebService wdgjService = new SFYWebApi.wdgjWebService.wdgjWebService(); addMap = wdgjService.wdgj_AddressMap(); System.Web.HttpContext.Current.Session.Add("addMap", addMap); } DateTime date1 = Convert.ToDateTime(TextBox1.Text); DateTime date2 = Convert.ToDateTime(TextBox2.Text); string sqlCmd = "select * from sfyorderTab where createdate>='" + date1 + "' and createdate<='" + date2 + "'"; DataTable dt = new DataTable(); SqlSel.GetSqlSel(ref dt, sqlCmd); string AddrStr = "", province = "", city = "", area = ""; string[] addrArr = new string[3]; dt.Columns.Add("sendProvince"); dt.Columns.Add("sendCity"); dt.Columns.Add("sendArea"); for (int i = 0; i < dt.Rows.Count; i++) { AddrStr = dt.Rows[i]["Address"].ToString(); addrArr = SplitAddressStr(AddrStr); dt.Rows[i]["sendProvince"] = addrArr[0]; dt.Rows[i]["sendCity"] = addrArr[1]; dt.Rows[i]["sendArea"] = addrArr[2]; } GridView1.DataSource = dt; GridView1.DataBind(); }
//判断是否是定制订单 private bool isCustOrder(string GoodsNo) { DataTable goodsTable = new DataTable(); string sqlstr1 = "select * from t_MapGoodsList where goodsNo='" + GoodsNo + "'"; SqlSel.GetSqlSel(ref goodsTable, sqlstr1); if (goodsTable.Rows.Count > 0) { if (Convert.ToBoolean(goodsTable.Rows[0]["isOrder"]) == true) { return(true); } else { return(false); } } else { return(false); } }
protected void Button1_Click(object sender, EventArgs e) { Label1.Text = "订单正在获取中,请稍后。"; Label2.Text = ""; if (txtNeedDate.Value.Length == 0) { Label1.Text = "请选择需求日期!"; GridView1.DataSource = null; GridView1.DataBind(); return; } net.sogal.www.WebService aa = new SFYWebApi.net.sogal.www.WebService(); DateTime dt = DateTime.Parse(txtNeedDate.Value); DateTime dt2 = DateTime.Parse(Text1.Value); string strjson = aa.GetPoRequisition(dt, dt2); //Label4.Text = strjson; DataTable dtbl = new DataTable(); dtbl = Json2Dtb(strjson); //编码对照表 DataTable goodsTable = new DataTable(); string sqlstr1 = "select * from t_MapGoodsList"; SqlSel.GetSqlSel(ref goodsTable, sqlstr1); for (int i = 0; i < dtbl.Rows.Count; i++) { string itemNum = dtbl.Rows[i]["ITEM_NUMBER"].ToString(); //int quantity = Convert.ToInt32(dtbl.Rows[i]["QUANTITY"]); //if (dtbl.Rows[i]["ITEM_DESC"] != "" && dtbl.Rows[i]["ITEM_DESC"] != null) //{ // DataRow newRow; // newRow = dtbl.NewRow(); // string orderid = dtbl.Rows[i]["HEADER_ID"].ToString() + "-" + dtbl.Rows[i]["LINE_ID"].ToString(); // if (dtbl.Rows[i]["ITEM_DESC"].ToString().Contains("[")) // { // //判断物料描述中【】内计量单位与实际计量单位是否相符 // string descunitA = dtbl.Rows[i]["ITEM_DESC"].ToString().Split('/')[1]; // string descunit = descunitA.Substring(0, 1); // string realunit = dtbl.Rows[i]["UOM_CODE"].ToString(); // if (descunit != realunit) // { // MessageBox.Show("订单号为" + orderid + "的备注计量单位与实际返回计量单位不符,请相关人员确认!", "请注意!"); // } // string strcount = dtbl.Rows[i]["ITEM_DESC"].ToString().Split('[')[1]; // string innerstr = strcount.Substring(0, strcount.IndexOf("]")); // int itemcount = Convert.ToInt32(innerstr.Substring(0, GetIndexOfChinese(innerstr) + 1)); // dtbl.Rows[i]["QUANTITY"] = itemcount * Convert.ToInt32(dtbl.Rows[i]["QUANTITY"]); // } // if (dtbl.Rows[i]["ITEM_DESC"].ToString().Contains("【")) // { // //判断物料描述中【】内计量单位与实际计量单位是否相符 // string descunitA = dtbl.Rows[i]["ITEM_DESC"].ToString().Split('/')[1]; // string descunit = descunitA.Substring(0, 1); // string realunit = dtbl.Rows[i]["UOM_CODE"].ToString(); // if (descunit != realunit) // { // MessageBox.Show("订单号为" + orderid + "的备注计量单位与实际返回计量单位不符,请相关人员确认!", "请注意!"); // } // string strcount = dtbl.Rows[i]["ITEM_DESC"].ToString().Split('【')[1]; // string innerstr = strcount.Substring(0, strcount.IndexOf("】")); // int itemcount = Convert.ToInt32(innerstr.Substring(0, GetIndexOfChinese(innerstr) + 1)); // dtbl.Rows[i]["QUANTITY"] = itemcount * Convert.ToInt32(dtbl.Rows[i]["QUANTITY"]); // } // if (dtbl.Rows[i]["ITEM_DESC"].ToString().Contains("(")) // { // string dpm = dtbl.Rows[i]["ITEM_DESC"].ToString().Split('(')[0]; // //获取()之间的字符 // int IndexofA = dtbl.Rows[i]["ITEM_DESC"].ToString().IndexOf("("); //或者( // int IndexofB = dtbl.Rows[i]["ITEM_DESC"].ToString().IndexOf(")"); //或者) // string pinname = dtbl.Rows[i]["ITEM_DESC"].ToString().Substring(IndexofA + 1, IndexofB - IndexofA - 1); // dtbl.Rows[i]["ITEM_DESC"] = dpm; // dtbl.Rows[i]["ITEM_NUMBER"] = pinname; // } // if (dtbl.Rows[i]["ITEM_DESC"].ToString().Contains("(")) // { // string dtbln = dtbl.Rows[i]["ITEM_DESC"].ToString().Split('(')[0]; // //获取()之间的字符 // int IndexofC = dtbl.Rows[i]["ITEM_DESC"].ToString().IndexOf("("); //或者( // int IndexofD = dtbl.Rows[i]["ITEM_DESC"].ToString().IndexOf(")"); //或者) // string pname = dtbl.Rows[i]["ITEM_DESC"].ToString().Substring(IndexofC + 1, IndexofD - IndexofC - 1); // dtbl.Rows[i]["ITEM_DESC"] = dtbln; // dtbl.Rows[i]["ITEM_NUMBER"] = pname; // } // string pname = dtbl.Rows[i]["ITEM_DESC"].ToString().Substring(dtbln.Length).Replace("(", "").Replace(")", ""); // string otherstr = dtbl.Rows[i]["ITEM_DESC"].ToString().Split('(')[1]; // string pinname = otherstr.Split(')')[0]; //} //匹配商品编码 if (!string.IsNullOrEmpty(itemNum)) { int find = -1; for (int k = 0; k < goodsTable.Rows.Count; k++) { string sfyNo = goodsTable.Rows[k]["targetNo"].ToString(); if (sfyNo == itemNum) { find = k; break; } } if (find >= 0) { dtbl.Rows[i]["ITEM_NUMBER"] = goodsTable.Rows[find]["goodsNo"]; //非最小计量数量则乘以相关数量 if (Convert.ToBoolean(goodsTable.Rows[find]["isMinUnitOrNo"]) == true) { dtbl.Rows[i]["QUANTITY"] = (Convert.ToInt32(dtbl.Rows[i]["QUANTITY"]) * (Convert.ToInt32(goodsTable.Rows[find]["UnitTimes"]))).ToString(); } //定制款商品增加“索菲亚定制”备注,以便相关订单匹配定制仓库--2016年12月16日 19:17:36 if (Convert.ToBoolean(goodsTable.Rows[find]["isOrder"]) == true) { dtbl.Rows[i]["SPECIFICATION"] = dtbl.Rows[i]["SPECIFICATION"].ToString() + " 备注:索菲亚定制"; } } } } GridView1.DataSource = dtbl; StringBuilder sbresault = new StringBuilder(); sbresault.Append(""); for (int i = 0; i < dtbl.Rows.Count; i++) { DataTable newdt = new DataTable(); string orderid = dtbl.Rows[i]["HEADER_ID"].ToString() + "-" + dtbl.Rows[i]["LINE_ID"].ToString(); string sqlCmd = "select * from SFYOrderTab where OrderId='" + orderid + "' "; SqlSel.GetSqlSel(ref newdt, sqlCmd); if (newdt.Rows.Count > 0) { continue; //sqlCmd = "select QUANTITY from SFYOrderTab where OrderId='" + orderid + "' and ITEM_NUMBER='" + dtbl.Rows[i]["ITEM_NUMBER"].ToString() + "'"; //int curcount = Convert.ToInt32(dtbl.Rows[i]["QUANTITY"]); //int befcount = Convert.ToInt32(SqlSel.GetSqlScale(sqlCmd)); //if (curcount!=befcount) //{ // sbresault.Append(string.Format("订单号为{0}的订单,货品数量发生改变:原始数量为{2},现数量为({1}),请通知相关人员!<br/>", orderid, curcount,befcount)); // Label2.Text = sbresault.ToString(); // continue; //} //else //{ // continue; //} } else { //联系人是否为空 if (dtbl.Rows[i]["CONTACT_NAME"].ToString() == "" || dtbl.Rows[i]["CONTACT_NAME"].ToString() == null) { sbresault.Append(string.Format("PO号为{0}的联系人为空,请查验!<br/>", dtbl.Rows[i]["CUST_PO_NUM"].ToString())); } //联系电话是否为空 if (dtbl.Rows[i]["PHONE_NUMBER"].ToString() == "" || dtbl.Rows[i]["PHONE_NUMBER"].ToString() == null) { sbresault.Append(string.Format("PO号为{0}的联系电话为空,请查验!<br/>", dtbl.Rows[i]["CUST_PO_NUM"].ToString())); } //判断订单地址是否存在疑问 if (dtbl.Rows[i]["Address"].ToString() == "" || dtbl.Rows[i]["Address"].ToString() == null) { sbresault.Append(string.Format("PO号为{0}的地址为空,请查验!<br/>", dtbl.Rows[i]["CUST_PO_NUM"].ToString())); } else { if (dtbl.Rows[i]["Address"].ToString().Length >= 8) { string origAdr = dtbl.Rows[i]["Address"].ToString(); DataTable prodtl = new DataTable(); string sqlstr = "select * from tb_sys_capital"; SqlSel.GetSqlSel(ref prodtl, sqlstr); int find = -1; for (int j = 0; j < prodtl.Rows.Count; j++) { string provincename = prodtl.Rows[j]["CapitalName"].ToString(); if (origAdr.Substring(0, 8).Contains(provincename)) { find = j; break; } } if (find < 0) { sbresault.Append(string.Format("PO号为{0}的地址可能不具体“{1}”,请查验!<br/>", dtbl.Rows[i]["CUST_PO_NUM"].ToString(), dtbl.Rows[i]["Address"].ToString())); } } else { sbresault.Append(string.Format("PO号为{0}的地址可能不具体“{1}”,请查验!<br/>", dtbl.Rows[i]["CUST_PO_NUM"].ToString(), dtbl.Rows[i]["Address"].ToString())); } } string guige = ""; int quantity = Convert.ToInt32(dtbl.Rows[i]["QUANTITY"]); //定制款的实际数量transaction_quantity int realQty; try { realQty = Convert.ToInt32(dtbl.Rows[i]["transaction_quantity"]); } catch (Exception) { realQty = 0; } //如果定制数量大于0,则取定制数量 if (realQty > 0) { quantity = realQty; } string crationname = dtbl.Rows[i]["CONTACT_NAME"].ToString(); //判断是否是定制款 if (isCustOrder(dtbl.Rows[i]["ITEM_NUMBER"].ToString())) { guige = " 规格:" + dtbl.Rows[i]["SPECIFICATION"].ToString(); //插入原始数据记录表origDataLog //sqlCmd = "insert into origDataLog (origId,origText,sourceTab) values ('" + orderid + "','transaction_quantity:" + dtbl.Rows[i]["QUANTITY"].ToString() + "','SFYOrderTab')"; //int curExeCount = SqlSel.ExeSql(sqlCmd); //if (curExeCount == 0) //{ // return; //} //else //{ // //订单表SFYOrderTab中存储定制款的实际数量 // quantity = realQty; // crationname = crationname + guige; //} crationname = crationname + guige; } //索菲亚关于部分需配备礼盒的商品生成相应订单(支持一个产品对应多个赠品的情况) string origGoods = dtbl.Rows[i]["ITEM_NUMBER"].ToString(); DataTable saledtl = new DataTable(); sqlCmd = "select (select goodsNo from goodslist where SaleAct.origgoodsid=goodslist.id) as origNo,(select goodsName from goodslist where SaleAct.origgoodsid=goodslist.id) as origName,"; sqlCmd += " (select goodsNo from goodslist where SaleAct.giftgoodsid=goodslist.id) as giftNo,(select goodsName from goodslist where SaleAct.giftgoodsid=goodslist.id) as giftName,* from SaleAct"; sqlCmd += " where enabled=1 and startdte<'" + DateTime.Now + "' and enddte>'" + DateTime.Now + "'"; SqlSel.GetSqlSel(ref saledtl, sqlCmd); for (int bb = 0; bb < saledtl.Rows.Count; bb++) { string curGoodsNo = saledtl.Rows[bb]["origNo"].ToString(); if (origGoods == curGoodsNo) { sqlCmd = "select * from SFYOrderTab where parentid is not null and ITEM_NUMBER='" + saledtl.Rows[bb]["giftNo"].ToString() + "' and"; sqlCmd += " parentid='" + dtbl.Rows[i]["HEADER_ID"].ToString() + "-" + dtbl.Rows[i]["LINE_ID"].ToString() + "'"; DataTable curdtl = new DataTable(); SqlSel.GetSqlSel(ref curdtl, sqlCmd); if (curdtl.Rows.Count > 0) { continue; } else { sqlCmd = "insert into SFYOrderTab (HEADER_ID,LINE_ID,PO_NUMBER,CUST_PO_NUM,ITEM_NUMBER,ITEM_DESC,NEED_BY_DATE,CREATION_DATE,QUANTITY,"; sqlCmd += " UOM_CODE,DESCRIPTION,CONTACT_NAME,PHONE_NUMBER,ADDRESS,ISNew,OrderId,OrderStatus,cipher,CreateDate,parentid) values ("; sqlCmd += " '" + dtbl.Rows[i]["HEADER_ID"].ToString() + "','" + dtbl.Rows[i]["LINE_ID"].ToString() + "','" + dtbl.Rows[i]["PO_NUMBER"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["CUST_PO_NUM"].ToString() + "','" + saledtl.Rows[bb]["giftNo"].ToString() + "','" + saledtl.Rows[bb]["giftName"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["NEED_BY_DATE"].ToString() + "','" + dtbl.Rows[i]["CREATION_DATE"].ToString() + "'," + quantity + ",'" + dtbl.Rows[i]["UOM_CODE"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["CUST_PO_NUM"].ToString() + guige + "','" + crationname + "','" + dtbl.Rows[i]["PHONE_NUMBER"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["ADDRESS"].ToString() + "',0,'SFY" + DateTime.Now.Ticks + "',"; sqlCmd += " 1,'MBH3Q2W876EG422','" + DateTime.Now + "','" + dtbl.Rows[i]["HEADER_ID"].ToString() + "-" + dtbl.Rows[i]["LINE_ID"].ToString() + "')"; int insertCounts = SqlSel.ExeSql(sqlCmd); if (insertCounts == 0) { break; } } //break; } } sqlCmd = "insert into SFYOrderTab (HEADER_ID,LINE_ID,PO_NUMBER,CUST_PO_NUM,ITEM_NUMBER,ITEM_DESC,NEED_BY_DATE,CREATION_DATE,QUANTITY,"; sqlCmd += " UOM_CODE,DESCRIPTION,CONTACT_NAME,PHONE_NUMBER,ADDRESS,ISNew,OrderId,OrderStatus,cipher,CreateDate) values ("; sqlCmd += " '" + dtbl.Rows[i]["HEADER_ID"].ToString() + "','" + dtbl.Rows[i]["LINE_ID"].ToString() + "','" + dtbl.Rows[i]["PO_NUMBER"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["CUST_PO_NUM"].ToString() + "','" + dtbl.Rows[i]["ITEM_NUMBER"].ToString() + "','" + dtbl.Rows[i]["ITEM_DESC"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["NEED_BY_DATE"].ToString() + "','" + dtbl.Rows[i]["CREATION_DATE"].ToString() + "'," + quantity + ",'" + dtbl.Rows[i]["UOM_CODE"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["CUST_PO_NUM"].ToString() + guige + "','" + crationname + "','" + dtbl.Rows[i]["PHONE_NUMBER"].ToString() + "',"; sqlCmd += " '" + dtbl.Rows[i]["ADDRESS"].ToString().Replace("'", "") + "',0,'" + dtbl.Rows[i]["HEADER_ID"].ToString() + "-" + dtbl.Rows[i]["LINE_ID"].ToString() + "',"; sqlCmd += " 1,'MBH3Q2W876EG422','" + DateTime.Now + "')"; int execounts = SqlSel.ExeSql(sqlCmd); if (execounts == 0) { sbresault.Append(string.Format("客户{0}的信息存在异常,未能抓单成功,请校验!", dtbl.Rows[i]["CUST_PO_NUM"].ToString())); continue; } } } if (!string.IsNullOrEmpty(sbresault.ToString())) { Label2.Text = sbresault.ToString(); } GridView1.DataBind(); Label1.Text = "订单获取完成。"; }
/// <summary> /// 订单查询 /// </summary> /// <param name="cipher"></param> /// <param name="TimeStamp1">起始时间(时间戳),0表示不限制起始时间</param> /// <param name="TimeStamp2">截止时间(时间戳),0表示不限制截止时间</param> /// <param name="OrderStatus">0:表示所有,1:表示已经付款,2:表示未付款,3:表示已经取消,4:已经发货</param> /// <returns></returns> //[HttpPost] public static string mOrderSearch(string cipher, string TimeStamp1, string TimeStamp2, int OrderStatus) { DateTime apibeginTime = new DateTime(); if (TimeStamp1 != "") { apibeginTime = DateTime.Parse(TimeStamp1.ToString()); } DateTime apiendTime = DateTime.Parse(TimeStamp2.ToString()); string ids = ""; //查询订单 //使用本地时间: object otmp = SqlSel.GetSqlScale(" select top 1 AddedTime from WDApi_logs order by AddedTime desc"); string addtime = ""; if (otmp != null) { addtime = otmp.ToString(); } string beginTime = addtime; DateTime endTime = DateTime.Now; string descrip = string.Format("【wdgj_抓单】起始时间{0},结束时间{1},订单状态{2}", beginTime, endTime, OrderStatus); //LogHelper.InsertApiLog(db, "订单查询", cipher, descrip, "wdgj_api"); string IPAddress = IPHelp.ClientIP; string sqlCmd = "insert into WDApi_logs ([PageUrl],[AddedTime],[UserName],[IPAddress],[Privilege],[Description],[cipher]) values ('','" + DateTime.Now + "','wdgj_api','" + IPAddress + "','订单查询','" + descrip + "','" + cipher + "')"; //执行插入日志 int execounts = SqlSel.ExeSql(sqlCmd); string sql = "select OrderId,OrderStatus,cipher from SFYOrderTab where cipher='" + cipher + "' AND ISnew=0 "; //if (beginTime.Length != 0) //{ // sql += OrderStatus == 1 ? " and CREATION_DATE>='" + beginTime+"' " : " and CREATION_DATE>='" + beginTime+"' "; //} //if (endTime.ToString().Length != 0) //{ // sql += OrderStatus == 1 ? " and CREATION_DATE<'" + endTime + "' " : " and CREATION_DATE<'" + endTime + "' "; //} //if (OrderStatus != 0) //{ // sql += " and OrderStatus= " + OrderStatus; //} DataTable dtb1 = new DataTable(); SqlSel.GetSqlSel(ref dtb1, sql); StringBuilder xml = new StringBuilder(); xml.Append("<?xml version='1.0' encoding='gb2312'?>"); xml.Append("<OrderList>"); for (int item = 0; item < dtb1.Rows.Count; item++) { string oid = dtb1.Rows[item]["OrderId"].ToString(); //List.Add(string.Format("{0}[{1}]", oid, 1)); ids += oid + ", "; xml.Append("<OrderNO>" + oid + "</OrderNO>"); } //LogHelper.debug(string.Format("【网店管家测试】--订单总数:{0};", data.Count)); //InsertLogsFile("订单总数:" + dtb1.Rows.Count + "订单编号:" + ids +"/r/n"+ string.Format("【wdgj_抓单】本地调用起始时间{5},结束时间{6};API起始时间【{3}】{0},结束时间【{4}】{1},订单总数{2}", apibeginTime, apiendTime, dtb1.Rows.Count, TimeStamp1, TimeStamp2, beginTime, endTime)+"/r/n"); xml.Append("<Page>1</Page>"); xml.Append("<Result>" + "1" + "</Result>"); xml.Append("<OrderCount>" + dtb1.Rows.Count + "</OrderCount>"); xml.Append("</OrderList>"); return(xml.ToString()); }
public static string mSndGoods(string OrderNO, string SndStyle, string BillID) { string orderlist = ""; DataTable dtn = new DataTable(); string sqldt = "select * from WLCode "; SqlSel.GetSqlSel(ref dtn, sqldt); for (int dd = 0; dd < dtn.Rows.Count; dd++) { string wlcode = dtn.Rows[dd]["EWL"].ToString(); if (SndStyle.Contains(wlcode)) { orderlist = dtn.Rows[dd]["ZWL"].ToString(); break; } } //InsertLogsFile(string.Format("【wdgj_发货同步】订单号:{0},发货类型:{1},快递单号:{2} ", OrderNO, orderlist, BillID)); string cipher = "MBH3Q2W876EG422"; int i = OrderNO.Split(',').Length - 1; int m = 0; Encoding coding = Encoding.UTF8; //LogHelper.InsertLogToFile("wdgj_api", string.Format("【wdgj_发货同步】订单号:{0},发货时间{1},同步时间{2},发货类型:{3},用户:{4},快递单号:{5} ", OrderNO, SndDate, DateTime.Now, SndStyle, CustomerID, BillID)); string IPAddress = IPHelp.ClientIP; //引用索菲亚接口 //net.sogal.www.WebService aa = new SFYWebApi.net.sogal.www.WebService(); foreach (var id in OrderNO.Split(',')) { string sqlcmd = "select cipher,CREATION_DATE,OrderStatus,QUANTITY from SFYOrderTab where OrderId='" + id + "' "; DataTable dtb1 = new DataTable(); SqlSel.GetSqlSel(ref dtb1, sqlcmd); if (dtb1 == null) { return(xml(0, OrderNO)); } string dtbln = id.Split('-')[0]; string dline = id.Substring(dtbln.Length + 1); string qunty = dtb1.Rows[0]["QUANTITY"].ToString(); string sqlCmd2 = "insert into WDApiFH ([Header_ID],[Line_ID],[OrderId],[TQuantity],[LOG_INFO],[FHSat],[Create_Date],[cipher]) values ('" + dtbln + "','" + dline + "','" + id + "','" + qunty + "','" + string.Format("订单号:{0},发货类型:{1},快递单号:{2} ", id, orderlist, BillID) + "','0','" + DateTime.Now + "','" + cipher + "')"; //执行发货同步 int execounts2 = SqlSel.ExeSql(sqlCmd2); if (execounts2 == 1) { m += 1; } //aa.AddPoRequisition(Int32.Parse(dtbln), Int32.Parse(dline), Decimal.Parse(qunty), string.Format("订单号:{0},发货类型:{1},快递单号:{2} ", id, orderlist, BillID));//写入索菲亚接口 //string sqlstr = "update WDApiFH set [FHSat]=1 where [OrderId]='" + id + "' "; //int execounts = SqlSel.ExeSql(sqlstr); //if (execounts == 0) //{ // break; //} //DataTable newdt = new DataTable(); //string sqlCmd = "select * from WDApiFH where FHSat=0 and OrderId='" + id + "'"; //SqlSel.GetSqlSel(ref newdt, sqlCmd); //string orderid = newdt.Rows[0]["OrderId"].ToString(); //aa.AddPoRequisition(Int32.Parse(newdt.Rows[0]["Header_ID"].ToString()), Int32.Parse(newdt.Rows[0]["Line_ID"].ToString()), Decimal.Parse(newdt.Rows[0]["TQuantity"].ToString()), newdt.Rows[0]["LOG_INFO"].ToString());//传值测试 //string sqlstr = "update WDApiFH set [FHSat]=1 where [OrderId]='" + orderid + "' "; //int execounts = SqlSel.ExeSql(sqlstr); //if (execounts == 0) //{ // break; //} } //写入索菲亚接口 //net.sogal.www.WebService aa = new SFYWebApi.net.sogal.www.WebService(); //DataTable newdt = new DataTable(); //string sqlCmd = "select * from WDApiFH where FHSat=0 "; //SqlSel.GetSqlSel(ref newdt, sqlCmd); //for (int ii = 0; ii < newdt.Rows.Count; ii++) //{ // string RQTId = newdt.Rows[ii]["RQTId"].ToString(); // aa.AddPoRequisition(Int32.Parse(newdt.Rows[ii]["Header_ID"].ToString()), Int32.Parse(newdt.Rows[ii]["Line_ID"].ToString()), Decimal.Parse(newdt.Rows[ii]["TQuantity"].ToString()), newdt.Rows[ii]["LOG_INFO"].ToString());//传值测试 // string sqlstr = "update WDApiFH set [FHSat]=1 where [RQTId]='" + RQTId + "' "; // int execounts = SqlSel.ExeSql(sqlstr); // if (execounts == 0) // { // break; // } //} string sqlCmdt = "insert into WDApi_logs ([PageUrl],[AddedTime],[UserName],[IPAddress],[Privilege],[Description],[cipher]) values ('','" + DateTime.Now + "','wdgj_api','" + IPAddress + "','发货同步','" + string.Format("【wdgj_发货同步】订单号:{0},同步时间{1},发货类型:{2},快递单号:{3} ", OrderNO.Replace(',', ','), DateTime.Now, orderlist, BillID) + "','" + cipher + "')"; //执行插入日志 int execountst = SqlSel.ExeSql(sqlCmdt); if (m == i + 1) { return(xml(1, "1")); } else { return(xml(0, OrderNO)); } }
// 订单下载 //[HttpPost] public static string mGetOrder(string cipher, string OrderNO) { //var data = new DbObject(); StringBuilder sb = new StringBuilder(); string IPAddress = IPHelp.ClientIP; string sqlCmd = "insert into WDApi_logs ([PageUrl],[AddedTime],[UserName],[IPAddress],[Privilege],[Description],[cipher]) values ('','" + DateTime.Now + "','wdgj_api','" + IPAddress + "','订单查询','" + string.Format("【wdgj_订单下载】时间{0},订单编号{1} ", DateTime.Now, OrderNO) + "','" + cipher + "')"; //执行插入日志 int execounts = SqlSel.ExeSql(sqlCmd); string sql = @"select OrderId,CREATION_DATE,CUST_PO_NUM,CONTACT_NAME,PO_NUMBER,ITEM_NUMBER,ADDRESS,description,ITEM_DESC,NEED_BY_DATE,QUANTITY,UOM_CODE ,PHONE_NUMBER from SFYOrderTab where OrderId='" + OrderNO + "' "; string ponum = ""; string[] addrArr = new string[3]; string province = ""; //省 string city = ""; //市 string area = ""; //区 DataTable dtb1 = new DataTable(); SqlSel.GetSqlSel(ref dtb1, sql); if (dtb1 == null) { return("不存在该订单编号"); } StringBuilder xml = new StringBuilder(); //data.Add("Item", Items); if (dtb1.Rows.Count > 0) { string curdte = Convert.ToDateTime(dtb1.Rows[0]["CREATION_DATE"]).ToString("yyyy-MM-dd HH:mm:ss"); string contact_name = dtb1.Rows[0]["contact_name"].ToString().TrimEnd(); string needdte = Convert.ToDateTime(dtb1.Rows[0]["NEED_BY_DATE"]).ToString("yyyy-MM-dd"); //DataTable prodtl =new DataTable(); //string sqlstr="select * from tb_sys_capital"; //SqlSel.GetSqlSel(ref prodtl,sqlstr); string Address = dtb1.Rows[0]["Address"].ToString().TrimEnd(); if (Address.Length >= 8) { addrArr = SplitAddress(Address); province = addrArr[0]; city = addrArr[1]; area = addrArr[2]; //int find = -1; //for (int f = 0; f < prodtl.Rows.Count; f++) //{ // string provincename = prodtl.Rows[f]["CapitalName"].ToString(); // if (Address.Substring(0, 8).Contains(provincename)) // { // find = f; // province = prodtl.Rows[f]["CapitalName"].ToString(); // break; // } //} //if (find < 0) //{ // return "地址格式有误!"; //} } else { return("地址格式有误!"); } if (contact_name == "" || contact_name == null) { contact_name = "-"; } string TelPhone = dtb1.Rows[0]["PHONE_NUMBER"].ToString().TrimEnd(); //if (TelPhone == ""|| TelPhone == null) //{ // TelPhone = "-"; //} ponum = dtb1.Rows[0]["cust_po_num"].ToString(); xml.Append("<Order>"); xml.Append("<Result>1</Result>"); xml.Append("<Cause></Cause>"); xml.Append("<OrderNO>" + OrderNO + "</OrderNO>"); xml.Append("<DateTime>" + curdte + "</DateTime>"); xml.Append("<BuyerID><![CDATA[" + ponum + "]]></BuyerID>"); xml.Append("<BuyerName><![CDATA[" + contact_name + "]]></BuyerName>"); xml.Append("<Country><![CDATA[" + "中国" + "]]></Country>"); xml.Append("<Province><![CDATA[" + province + "]]></Province>"); xml.Append("<City><![CDATA[" + city + "]]></City>"); xml.Append("<Town><![CDATA[" + area + "]]></Town>"); xml.Append("<Adr><![CDATA[" + Address + "]]></Adr>"); xml.Append("<Zip><![CDATA[" + "]]></Zip>"); xml.Append("<Email><![CDATA[" + "]]></Email>"); xml.Append("<Phone><![CDATA[" + TelPhone + "]]></Phone>"); xml.Append("<Total>0</Total>"); xml.Append("<Postage>0</Postage>"); xml.Append("<PayAccount><![CDATA[支付宝]]></PayAccount>"); //支付方式 xml.Append("<PayID><![CDATA[" + "" + "]]></PayID>"); //支付编号 xml.Append("<logisticsName><![CDATA[" + "]]></logisticsName>"); xml.Append("<chargetype><![CDATA[担保交易]]></chargetype>"); //结算方式 xml.Append("<CustomerRemark><![CDATA[需求日期:" + needdte + "]]></CustomerRemark>"); xml.Append("<Remark><![CDATA[" + dtb1.Rows[0]["description"].ToString() + "]]></Remark>"); xml.Append("<InvoiceTitle><![CDATA[" + "" + "]]></InvoiceTitle>"); xml.Append("<Item>"); xml.Append("<GoodsID><![CDATA[" + dtb1.Rows[0]["ITEM_NUMBER"].ToString() + "]]></GoodsID>"); xml.Append("<GoodsName><![CDATA[" + dtb1.Rows[0]["ITEM_DESC"].ToString() + "]]></GoodsName>"); xml.Append("<GoodsSpec><![CDATA[" + dtb1.Rows[0]["uom_code"].ToString() + "]]></GoodsSpec>"); xml.Append("<Count>" + dtb1.Rows[0]["quantity"].ToString() + "</Count>"); xml.Append("<Price>0</Price>"); xml.Append("</Item>"); xml.Append("</Order>"); } sql = "update SFYOrderTab set isnew=1 where OrderId='" + OrderNO + "'"; SqlSel.ExeSql(sql); //插入日志文件 //InsertLogsFile(string.Format("【网店管家_订单下载】时间{0},订单编号{1},用户名{2} ", DateTime.Now, OrderNO, ponum)); return(xml.ToString()); //LogHelper.InsertLogToFile("wdgj_api", string.Format("【网店管家_订单下载】时间{0},订单编号{1},用户名{2} ", DateTime.Now, OrderNO, data["BuyerID"])); }
public void DisplayData() { if (Request["uCode"] != null && Request["mType"] != null) { string uCode = Request["uCode"].ToString(); object otmp = SqlSel.GetSqlScale(" select top 1 AddedTime from WDApi_logs order by AddedTime desc"); string addtime = ""; if (otmp != null) { addtime = otmp.ToString(); } string beginTime = addtime; DateTime endTime = DateTime.Now; if (1 == 1) { if (Request["mType"] == "mOrderSearch" && uCode == SqlSel.getcipher()) { Response.Write(wdgjV3API.mOrderSearch(SqlSel.getcipher(), beginTime, endTime.ToString(), 1)); Response.End(); } else if (Request["mType"] == "mGetOrder" && uCode == SqlSel.getcipher()) { string OrderNO = Request["OrderNO"].ToString(); byte[] buffer = Encoding.Default.GetBytes(wdgjV3API.mGetOrder(uCode, OrderNO)); string strDest = Encoding.GetEncoding("gb2312").GetString(buffer); Response.Clear(); Response.ContentType = "text/xml"; Response.Write("<?xml version='1.0' encoding='UTF-8'?>" + strDest); Response.End(); } else if (Request["mType"] == "mSndGoods" && uCode == SqlSel.getcipher()) { //string orderlist = ""; string OrderNO = Request["OrderNO"].ToString(); string SndStyle = Request["SndStyle"].ToString(); //string SndStyle = System.Text.Encoding.UTF8.GetBytes(sndsty).ToString(); string BillID = Request["BillID"].ToString(); //if (SndStyle.Contains("德邦")) //{ // orderlist = "debang"; //} //else if (SndStyle.Contains("申通")) //{ // orderlist = "shentong"; //} //else if (SndStyle.Contains("顺丰")) //{ // orderlist = "shunfeng"; //} //else if (SndStyle.Contains("中通")) //{ // orderlist = "zhongtong"; //} //else if (SndStyle.Contains("EMS")) //{ // orderlist = "ems"; //} //else if (SndStyle.Contains("优速")) //{ // orderlist = "yousu"; //} //else //{ // orderlist = ""; //} string xml = wdgjV3API.mSndGoods(OrderNO, SndStyle, BillID); Response.Write(xml); Response.End(); } else { Response.Write(wdgjV3API.xml(0, "canshu error")); Response.End(); } } else { Response.Write(wdgjV3API.xml(0, "uCode Error")); Response.End(); } } else { Response.Write(wdgjV3API.xml(0, "uCode Error or uCode is null")); Response.End(); } }