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 = "保存成功。"; }
/// <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 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(); } }