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