protected void bindGrid(string goodNo) { try { if (goodNo == "ALL") { goodNo = "%"; } DataTable dt = new DataTable(); string sqlCmd = "select * from [goodsList] where [goodsNo] like '" + goodNo + "' order by goodsno"; SqlSel_Pro.GetSqlSel(ref dt, sqlCmd); Grid1.DataSource = dt; Grid1.DataBind(); sqlCmd = "select max(id) from goodsList"; string curMaxId = SqlSel_Pro.GetSqlScale(sqlCmd).ToString(); if (string.IsNullOrEmpty(curMaxId)) { label_hidden.Text = "0"; } else { label_hidden.Text = curMaxId; } } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
protected void btn_rePush_Click(object sender, EventArgs e) { try { //是否存在非异常单 CheckBoxField field1 = (CheckBoxField)Grid1.FindColumn("CheckBoxField1"); string sqlCmd = string.Empty; foreach (GridRow row in Grid1.Rows) { int rowIndex = row.RowIndex; bool isSel = field1.GetCheckedState(rowIndex); if (isSel) { string apiState = row.Values[7].ToString();//API状态 int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]); if (apiState != "异常") { continue; } else { sqlCmd = "update sfyordertab set isnew='0' where SOId='" + rowID + "'"; SqlSel_Pro.ExeSql(sqlCmd); } } } Alert.Show("操作成功!"); reBound(); } catch (Exception ex) { Alert.ShowInTop(ex.Message); } }
protected void btnLogin_Click(object sender, EventArgs e) { string userName = tbxUserName.Text.Trim(); string password = tbxPassword.Text.Trim(); string psw = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5"); // DataTable dt = new DataTable(); string sqlCmd = "select * from T_UserList where userId='" + userName + "' and userPsw='" + psw + "'"; SqlSel_Pro.GetSqlSel(ref dt, sqlCmd); if (dt.Rows.Count > 0) { if (dt.Rows[0]["enabled"].ToString() == "0") { Alert.ShowInTop("用户未启用,请联系管理员!"); return; } Session["loginUser"] = userName; Response.Redirect("main.aspx"); } else { Alert.ShowInTop("用户名或密码错误!"); return; } }
//服务器端删除 protected void deleteFromDb(int DbId) { string sqlCmd = "delete from goodsList where id=" + DbId; SqlSel_Pro.ExeSql(sqlCmd); bindGrid("ALL"); }
protected void btn1_Click(object sender, EventArgs e) { string sqlCmdStr = "select parentid from SFYOrderTab where OrderId='" + txb1.Text + "'"; string orgId = SqlSel_Pro.GetSqlScale(sqlCmdStr).ToString(); TextBox1.Text = orgId; }
protected void btn_save_Click(object sender, EventArgs e) { try { string sqlCmd = ""; // 修改的现有数据 Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict(); foreach (int rowIndex in modifiedDict.Keys) { int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]); sqlCmd = "update [SFYOrderTab] set CONTACT_NAME='" + Grid1.Rows[rowIndex].Values[4].ToString() + "',"; sqlCmd += "PHONE_NUMBER='" + Grid1.Rows[rowIndex].Values[5].ToString() + "',ADDRESS='" + Grid1.Rows[rowIndex].Values[6].ToString() + "'"; sqlCmd += " where [SOId]=" + rowID; SqlSel_Pro.ExeSql(sqlCmd); } Alert.Show("已保存"); //刷新结果集 //tgb_PO_TriggerClick(sender, e); reBound(); } catch (Exception ex) { Alert.Show(ex.ToString()); return; } }
protected void menuTreeBind(string userId) { if (userId != null || userId != "") { string sqlCmd = "select * from t_sysMenu where id in( "; sqlCmd += "select menuId from t_rolemenu where roleid in ( "; sqlCmd += "select roleid from t_userrole where userid=( "; sqlCmd += "select id from t_userlist where userid='" + userId + "')) group by menuId) order by sortIndex"; DataTable treeDt = new DataTable(); SqlSel_Pro.GetSqlSel(ref treeDt, sqlCmd); DataSet ds = new DataSet(); ds.Tables.Add(treeDt); ds.Relations.Add("TreeRelation", ds.Tables[0].Columns["Id"], ds.Tables[0].Columns["ParentMenuId"], false); foreach (DataRow row in ds.Tables[0].Rows) { if (row.IsNull("ParentMenuId")) { TreeNode node = new TreeNode(); node.Text = row["Title"].ToString(); node.NodeID = row["id"].ToString(); //node.NavigateUrl = ResolveUrl(row["NavigateUrl"].ToString()); tree_menu.Nodes.Add(node); ResolveSubTree(row, node); } } tree_menu.Nodes[0].Expanded = true; } }
protected void btn_save_Click(object sender, EventArgs e) { try { string curUser = GetUser(); string sqlCmd = ""; // 修改的现有数据 Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict(); foreach (int rowIndex in modifiedDict.Keys) { if (string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[0].ToString())) { Alert.ShowInTop("商品编码不可为空!"); return; } int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]); sqlCmd = "update goodsList set goodsNo='" + Grid1.Rows[rowIndex].Values[0].ToString() + "',"; sqlCmd += "[goodsName]='" + Grid1.Rows[rowIndex].Values[1].ToString() + "',"; sqlCmd += "[specification]='" + Grid1.Rows[rowIndex].Values[2].ToString().Trim() + "',"; sqlCmd += "enabled='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[3]) + "',"; sqlCmd += "[createDte]='" + DateTime.Now + "',[createUser]='" + curUser + "' "; sqlCmd += "where id=" + rowID; SqlSel_Pro.ExeSql(sqlCmd); } // 新增数据 List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); for (int i = 0; i < newAddedList.Count; i++) { //DataRow rowData = CreateNewData(table, newAddedList[i]); //table.Rows.Add(rowData); if (string.IsNullOrEmpty(newAddedList[i]["goodsNo"].ToString())) { Alert.ShowInTop("商品编码不可为空!"); return; } sqlCmd = "insert into goodsList (goodsNo,goodsName,specification,enabled,createDte,createUser) values "; sqlCmd += "('" + newAddedList[i]["goodsNo"].ToString().Trim() + "','" + newAddedList[i]["goodsName"].ToString() + "','" + newAddedList[i]["specification"].ToString().Trim() + "',"; sqlCmd += "'" + Convert.ToBoolean(newAddedList[i]["enabled"]) + "','" + DateTime.Now + "','" + curUser + "')"; SqlSel_Pro.ExeSql(sqlCmd); } //表格数据重新绑定 bindGrid("ALL"); Alert.Show("保存成功!"); } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
protected void tree_menu_NodeCommand1(object sender, TreeCommandEventArgs e) { DataTable menuDt = new DataTable(); int menuId = Convert.ToInt32(e.NodeID); string sqlCmd = "select * from t_sysMenu where id=" + menuId; SqlSel_Pro.GetSqlSel(ref menuDt, sqlCmd); string NavigateUrl = menuDt.Rows[0]["NavigateUrl"].ToString(); string tabName = menuDt.Rows[0]["Title"].ToString(); PageContext.RegisterStartupScript(mainTabStrip.GetAddTabReference("dynamic_tab" + menuId.ToString(), ResolveUrl(NavigateUrl), tabName, IconHelper.GetIconUrl(Icon.ApplicationAdd), true)); }
//获取商品Id protected int getGoodIdByNo(string goodsNo) { try { int goodId = 0; string sqlCmd = "select id from goodsList where goodsNo='" + goodsNo + "'"; goodId = Convert.ToInt32(SqlSel_Pro.GetSqlScale(sqlCmd)); return(goodId); } catch (Exception ex) { Alert.ShowInTop(ex.Message); return(0); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["loginUser"] == null) { Response.Redirect("default.aspx"); } else { string userId = GetUser(); menuTreeBind(userId); string sqlCmd = "select userName from t_userlist where userid='" + userId + "' "; string curUser = SqlSel_Pro.GetSqlScale(sqlCmd).ToString(); l_loginInfo.Text = curUser + ",欢迎登陆."; } } }
//加载数据 protected void bindGrid(string loadField) { try { DataTable dt = new DataTable(); string sqlCmd = ""; if (loadField == "ALL")//加载全部 { sqlCmd = "select (select goodsNo from goodsList where goodsList.id=SaleAct.origGoodsId) as goodsNo,"; sqlCmd += "(select goodsNo from goodsList where goodsList.id=SaleAct.giftGoodsId) as giftNo,"; sqlCmd += "CONVERT(varchar(100), startDte, 23) as dstartDte,"; sqlCmd += "CONVERT(varchar(100), endDte, 23) as dendDte,"; sqlCmd += " * from SaleAct order by giftGoodsId"; } else //根据编码查询 { sqlCmd = "select * from (select (select goodsNo from goodsList where goodsList.id=SaleAct.origGoodsId) as goodsNo,"; sqlCmd += "(select goodsNo from goodsList where goodsList.id=SaleAct.giftGoodsId) as giftNo,"; sqlCmd += "CONVERT(varchar(100), startDte, 23) as dstartDte,"; sqlCmd += "CONVERT(varchar(100), endDte, 23) as dendDte,"; sqlCmd += " * from SaleAct) A where A.goodsNo='" + loadField + "'"; } SqlSel_Pro.GetSqlSel(ref dt, sqlCmd); Grid1.DataSource = dt; Grid1.DataBind(); //取当前最大数据id sqlCmd = "select max(id) from SaleAct"; string curMaxId = SqlSel_Pro.GetSqlScale(sqlCmd).ToString(); if (string.IsNullOrEmpty(curMaxId)) { label_hidden.Text = "0"; } else { label_hidden.Text = curMaxId; } } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
protected void btn_save_Click(object sender, EventArgs e) { try { string sqlCmd = ""; // 修改的现有数据 Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict(); foreach (int rowIndex in modifiedDict.Keys) { if (string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[0].ToString()) || string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[2].ToString())) { Alert.ShowInTop("商品编码或索菲亚编码不可为空!"); return; } if (Convert.ToBoolean(Grid1.Rows[rowIndex].Values[3]) == true & Convert.ToInt32(Grid1.Rows[rowIndex].Values[4]) == 0) { Alert.ShowInTop("不为最小单位的商品请添加计量数量!"); return; } int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]); sqlCmd = "update t_MapGoodsList set goodsNo='" + Grid1.Rows[rowIndex].Values[0].ToString() + "',"; sqlCmd += "goodsSpec='" + Grid1.Rows[rowIndex].Values[1].ToString() + "',"; sqlCmd += "targetNo='" + Grid1.Rows[rowIndex].Values[2].ToString().Trim() + "',"; sqlCmd += "isMinUnitOrNo='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[3]) + "',"; sqlCmd += "UnitTimes=" + Convert.ToInt32(Grid1.Rows[rowIndex].Values[4]) + ",isOrder='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[5]) + "' "; sqlCmd += "where id=" + rowID; SqlSel_Pro.ExeSql(sqlCmd); } // 新增数据 List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); DataTable table = createDataTable(); for (int i = 0; i < newAddedList.Count; i++) { //DataRow rowData = CreateNewData(table, newAddedList[i]); //table.Rows.Add(rowData); if (string.IsNullOrEmpty(newAddedList[i]["goodsNo"].ToString()) || string.IsNullOrEmpty(newAddedList[i]["targetNo"].ToString())) { Alert.ShowInTop("商品编码或索菲亚编码不可为空!"); return; } if (Convert.ToBoolean(newAddedList[i]["isMinUnitOrNo"]) == true & Convert.ToInt32(newAddedList[i]["UnitTimes"]) == 0) { Alert.ShowInTop("不为最小单位的商品请添加计量数量!"); return; } sqlCmd = "insert into t_MapGoodsList (goodsNo,goodsSpec,targetNo,isMinUnitOrNo,UnitTimes,isOrder) values "; sqlCmd += "('" + newAddedList[i]["goodsNo"].ToString().Trim() + "','" + newAddedList[i]["goodsSpec"].ToString() + "','" + newAddedList[i]["targetNo"].ToString().Trim() + "',"; sqlCmd += "'" + Convert.ToBoolean(newAddedList[i]["isMinUnitOrNo"]) + "'," + Convert.ToInt32(newAddedList[i]["UnitTimes"]) + ",'" + Convert.ToBoolean(newAddedList[i]["isOrder"]) + "')"; SqlSel_Pro.ExeSql(sqlCmd); } //表格数据重新绑定 bindGrid("ALL"); Alert.Show("保存成功!"); } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
public string wdgj_TradeList(string ShopId, string tradeDate) { //获取已发货送货单信息 string shortDate = Convert.ToDateTime(tradeDate).ToShortDateString(); string sqlCmd = "select TradeId,TradeTime,TradeNo,SndTo,NickName,t1.Tel,t1.Adr,t1.GoodsTotal,CustomerRemark,t1.warehouseId,"; sqlCmd += "t1.PostId,t1.SndTime,t1.AllTotal,t1.Postage,TradeFrom,TradeStatus,t3.Name AS LogisticName,tradeNo2,t1.Remark"; sqlCmd += " from g_trade_tradeList t1 left join g_customer_customerlist t2 "; sqlCmd += " on t1.customerId=t2.customerId left join G_Cfg_LogisticList t3 on t1.LogisticID=t3.LogisticID"; sqlCmd += " where t1.shopId='" + ShopId + "' and Convert(nvarchar(50),sndTime,23)='" + tradeDate + "' and tradeStatus='11'"; DataTable dt = new DataTable(); SqlSel.GetSqlSel(ref dt, sqlCmd); for (int i = dt.Rows.Count - 1; i >= 0; i--) { DataRow dr = dt.Rows[i]; //精简联系人信息 if (dr["SndTo"].ToString().Contains(" ") & dr["SndTo"].ToString().Contains("*")) { string sndTo = dr["SndTo"].ToString(); dr["SndTo"] = sndTo.Substring(0, sndTo.IndexOf(" ")); } if (ShopId == "1029") { //排除非新业务店铺的这两个仓库的订单 if (dr["warehouseId"].ToString() != "1027" && dr["warehouseId"].ToString() != "1039") { dt.Rows.Remove(dr); } } } //foreach (DataRow dr in dt.Rows) //{ // if (ShopId == "1029") // { // //排除非新业务店铺的这两个仓库的订单 // if (dr["warehouseId"].ToString() != "1027" && dr["warehouseId"].ToString() != "1039") // { // dt.Rows.Remove(dr); // } // } //} WdgjOrders WdgjOrder = new WdgjOrders { ShopId = ShopId, GetDate = Convert.ToDateTime(tradeDate) }; List <OrderInfo> orders = new List <OrderInfo>(); foreach (DataRow dr in dt.Rows) { string tradeId = dr["TradeId"].ToString(); string origOrderNo = dr["tradeNo2"].ToString(); OrderInfo orderInfo = new OrderInfo { OrderId = tradeId, TradeTime = Convert.ToDateTime(dr["TradeTime"]), OrderNo = dr["TradeNo"].ToString(), CustomerNo = dr["NickName"].ToString(), Adr = dr["Adr"].ToString(), ContactName = dr["SndTo"].ToString(), ContactPhone = dr["Tel"].ToString(), SendTime = Convert.ToDateTime(dr["SndTime"]), LogisticName = dr["LogisticName"].ToString(), PostId = dr["PostId"].ToString(), NeedDate = Convert.ToDateTime(dr["SndTime"]), WarehouseId = dr["warehouseId"].ToString() }; //新业务部订单 if (ShopId == "1029") { //非手工单获取大客户编码 if (dr["TradeFrom"].ToString() == "蜘蛛") { DataTable tempDt = new DataTable(); sqlCmd = "select * from view_sfyorders where cust_po_num='" + dr["NickName"].ToString() + "'"; if (SqlSel_Pro.GetSqlSel(ref tempDt, sqlCmd)) { orderInfo.CustomerNo = tempDt.Rows[0]["ouNO"].ToString(); orderInfo.ContactName = dr["SndTo"].ToString() + "/" + dr["NickName"].ToString();//客户姓名+PO号 } else { orderInfo.CustomerNo = null; } } } //添加商品明细 List <Goods> goodsList = new List <Goods>(); DataTable goodsTable = new DataTable(); sqlCmd = "select a.*,b.goodsNo from g_trade_goodsList a left join G_Goods_GoodsList b" + " on a.goodsid = b.goodsid where tradeId = '" + tradeId + "'"; SqlSel.GetSqlSel(ref goodsTable, sqlCmd); foreach (DataRow item in goodsTable.Rows) { string goodsNo = item["goodsNo"].ToString(); Goods goods = new Goods { GoodsNo = goodsNo, Descriptions = item["TradeSpec"].ToString(),//定制规格 SellCount = Convert.ToInt32(item["SellCount"]), SellPrice = Convert.ToDouble(item["SellPrice"]), IsOrder = string.IsNullOrEmpty(item["TradeSpec"].ToString()) ? false : true, IsGift = Convert.ToDouble(item["SellPrice"]) > 0 ? false : true }; if (ShopId == "1029" & dr["TradeFrom"].ToString() == "蜘蛛") { if (goods.Descriptions.Contains("*")) { string sizeInfo = goods.Descriptions; string productLength = "", productWidth = "", productHeight = ""; productLength = sizeInfo.Substring(0, sizeInfo.IndexOf("*")); //长 productWidth = sizeInfo.Substring(sizeInfo.IndexOf("*") + 1, sizeInfo.LastIndexOf("*") - sizeInfo.IndexOf("*") - 1); //宽 productHeight = sizeInfo.Substring(sizeInfo.LastIndexOf("*") + 1); //厚 decimal lastLenth = Convert.ToDecimal(productLength) / 10; //以厘米为单位 decimal lastWidth = Convert.ToDecimal(productWidth) / 10; decimal lastHeight = Convert.ToDecimal(productHeight) / 10; goods.Descriptions = lastLenth + "*" + lastWidth + "*" + lastHeight; } //string[] orderArr = origOrderNo.Split(','); //System.Text.StringBuilder builder = new System.Text.StringBuilder(); //foreach (string order in orderArr) //{ // builder.AppendFormat("'{0},'", order); //} //string orderListStr = builder.ToString().TrimEnd(','); //sqlCmd = "select * from sfyordertab where orderId in (" + orderListStr + ")"; //DataTable sfyOrigOrders = new DataTable(); //SqlSel_Pro.GetSqlSel(ref sfyOrigOrders, sqlCmd); //if (dr["Remark"].ToString().Contains("索菲亚定制")) //{ // goods.IsOrder = true; // goods.IsGift = false; //} //else //{ // goods.IsOrder = false; // goods.IsGift = false; //} //判断是否赠品 goods.IsGift = Convert.ToDouble(item["SellPrice"]) > 0 ? true : false;//接口赠品价格大于0为标识 } goodsList.Add(goods); } orderInfo.GoodsList = goodsList; orders.Add(orderInfo); } WdgjOrder.Orders = orders; //dt.Columns.Add("NeedDate"); //dt.Columns.Add("Items"); ////索菲亚订单提取需求日期(交期) //if (ShopId == "1029") //{ // for (int i = 0; i < dt.Rows.Count; i++) // { // string CustomerRemark = dt.Rows[i]["CustomerRemark"].ToString(); // string sndTo = dt.Rows[i]["SndTo"].ToString().Replace(" ", "");//去除空格 // if (dt.Rows[i]["TradeFrom"].ToString() == "蜘蛛") // { // dt.Rows[i]["NeedDate"] = CustomerRemark.Substring(CustomerRemark.LastIndexOf(":") + 1);//需求日期 // } // if (sndTo.Contains("规格")) // { // dt.Rows[i]["SndTo"] = sndTo.Substring(0, sndTo.IndexOf("规"));//联系人去除部分定制规格信息 // } // else // { // dt.Rows[i]["SndTo"] = sndTo; // } // } //} ////添加商品明细 //string curTradeId = ""; //for (int i = 0; i < dt.Rows.Count; i++) //{ // curTradeId = dt.Rows[i]["TradeId"].ToString(); // dt.Rows[i]["Items"] = wdgj_TradeItems(curTradeId); //} //string tradeInfo = string.Empty; //tradeInfo = JsonConvert.SerializeObject(dt); //return tradeInfo; //dt.TableName = "tradeInfo"; //return dt; return(JsonConvert.SerializeObject(WdgjOrder)); }
protected void btn_save_Click(object sender, EventArgs e) { try { string sqlCmd = ""; int origGoodsId = 0, giftGoodsId = 0; // 修改的现有数据 Dictionary <int, Dictionary <string, object> > modifiedDict = Grid1.GetModifiedDict(); foreach (int rowIndex in modifiedDict.Keys) { if (Convert.ToBoolean(Grid1.Rows[rowIndex].Values[2]) == true & (string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[0].ToString()) || string.IsNullOrEmpty(Grid1.Rows[rowIndex].Values[2].ToString()))) { Alert.ShowInTop("商品编码或赠品编码不可为空!"); return; } int rowID = Convert.ToInt32(Grid1.DataKeys[rowIndex][0]); origGoodsId = getGoodIdByNo(Grid1.Rows[rowIndex].Values[0].ToString().Trim()); giftGoodsId = getGoodIdByNo(Grid1.Rows[rowIndex].Values[1].ToString().Trim()); if (origGoodsId == 0 || giftGoodsId == 0) { Alert.ShowInTop("商品编码不存在,请校验!"); return; } sqlCmd = "update SaleAct set origGoodsId=" + origGoodsId + ","; sqlCmd += "giftGoodsId=" + giftGoodsId + ","; sqlCmd += "enabled='" + Convert.ToBoolean(Grid1.Rows[rowIndex].Values[2]) + "',"; sqlCmd += "startDte='" + Convert.ToDateTime(Grid1.Rows[rowIndex].Values[3]) + "',"; sqlCmd += "endDte='" + Convert.ToDateTime(Grid1.Rows[rowIndex].Values[4]) + "' "; sqlCmd += "where id=" + rowID; SqlSel_Pro.ExeSql(sqlCmd); } // 新增数据 List <Dictionary <string, object> > newAddedList = Grid1.GetNewAddedList(); for (int i = 0; i < newAddedList.Count; i++) { //DataRow rowData = CreateNewData(table, newAddedList[i]); //table.Rows.Add(rowData); if (Convert.ToBoolean(newAddedList[i]["enabled"]) == true & (string.IsNullOrEmpty(newAddedList[i]["goodsNo"].ToString()) || string.IsNullOrEmpty(newAddedList[i]["giftNo"].ToString()))) { Alert.ShowInTop("商品编码或赠品编码不可为空!"); return; } origGoodsId = getGoodIdByNo(newAddedList[i]["goodsNo"].ToString().Trim()); giftGoodsId = getGoodIdByNo(newAddedList[i]["giftNo"].ToString().Trim()); if (origGoodsId == 0 || giftGoodsId == 0) { Alert.ShowInTop("商品编码不存在,请校验!"); return; } sqlCmd = "insert into SaleAct (origGoodsId,giftGoodsId,enabled,startDte,endDte) values "; sqlCmd += "(" + origGoodsId + "," + giftGoodsId + ",'" + Convert.ToBoolean(newAddedList[i]["enabled"]) + "',"; sqlCmd += "'" + Convert.ToDateTime(newAddedList[i]["startDte"]) + "','" + Convert.ToDateTime(newAddedList[i]["endDte"]) + "')"; SqlSel_Pro.ExeSql(sqlCmd); } //表格数据重新绑定 bindGrid("ALL"); Alert.Show("保存成功!"); } catch (Exception ex) { Alert.ShowInTop(ex.Message); return; } }
private DataTable bindGrid(string dateStr, string poNumb, int pageIndex, int pageSize) { //数据集行数 string sqlCmd = "select isnull(count(*),0) as rowsCount from sfyordertab where cust_po_num like '" + poNumb + "'"; sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "'"; int rowCount = Convert.ToInt32(SqlSel_Pro.GetSqlScale(sqlCmd)); Grid1.RecordCount = rowCount; DataTable dt = new DataTable(); if (pageIndex == 0) { sqlCmd = " select top " + pageSize + " * from sfyordertab where cust_po_num like '" + poNumb + "'"; sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "' order by soid"; } else { sqlCmd = "select top " + pageSize + " * from sfyordertab where soid>("; sqlCmd += " select max(soid) from "; sqlCmd += " (select top (" + pageIndex + "*" + pageSize + ") soid from sfyordertab where cust_po_num like '" + poNumb + "'"; sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "' order by soid) t)"; sqlCmd += " and cust_po_num like '" + poNumb + "'"; sqlCmd += " and convert(nvarchar,createdate,23) like '" + dateStr + "' order by soid"; } if (SqlSel_Pro.GetSqlSel(ref dt, sqlCmd)) { string tradeNo = string.Empty; DataTable apiDt = new DataTable(); dt.Columns.Add("isAPI", typeof(string)); dt.Columns.Add("APIStatus", typeof(bool)); string str = ""; foreach (DataRow dr in dt.Rows) { tradeNo = dr["OrderId"].ToString(); str += " tradeNo='" + tradeNo + "' or"; } sqlCmd = "select tradeNo from g_api_tradelist where " + str.Substring(0, str.Length - 2); if (!SqlSel.GetSqlSel(ref apiDt, sqlCmd)) { foreach (DataRow dr in dt.Rows) { if (dr["isNew"].ToString() == "1") { dr["isAPI"] = "异常"; dr["APIStatus"] = true; } else { dr["isAPI"] = "待同步"; dr["APIStatus"] = false; continue; } } } else { foreach (DataRow dr in dt.Rows) { tradeNo = dr["OrderId"].ToString(); if (dr["isNew"].ToString() == "1") { DataRow[] drArr = apiDt.Select("tradeNo='" + tradeNo + "'"); if (drArr.Length > 0) { dr["isAPI"] = ""; dr["APIStatus"] = false; } else { dr["isAPI"] = "异常"; dr["APIStatus"] = true; } } else { dr["isAPI"] = "待同步"; dr["APIStatus"] = false; continue; } } } return(dt); } else { return(null); } }
/// <summary> /// 发送反馈 /// </summary> /// <param name="OrderNO">订单号</param> /// <param name="SndStyle">物流方式</param> /// <param name="BillID">物流单号</param> /// <returns></returns> public void mSndSFY(string OrderNO, string SndStyle, string BillID, string tradeNo, string sendTime, string shopId) { try { int i = OrderNO.Split(',').Length - 1; string IPAddress = IPHelp.ClientIP; DataTable dt2 = new DataTable(); foreach (var id in OrderNO.Split(',')) { if (id.Contains("-")) { string sqlstr = "select * from WDApiFH where OrderId='" + id + "' and LOG_INFO='" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "'"; SqlSel.GetSqlSel(ref dt2, sqlstr); if (dt2.Rows.Count > 0) { continue; } else { string dtbln = id.Split('-')[0]; string dline = id.Substring(dtbln.Length + 1); string qunty = "0"; string sqlCmd2 = "insert into WDApiFH ([Header_ID],[Line_ID],[OrderId],[TQuantity],[LOG_INFO],[FHSat],[Create_Date],[TradeNO],[sendTime],cipher) values ('" + dtbln + "','" + dline + "','" + id + "','" + qunty + "','" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "','0','" + DateTime.Now + "','" + tradeNo + "','" + sendTime + "','" + shopId + "')"; //执行发货同步 int execounts2 = SqlSel.ExeSql(sqlCmd2); if (execounts2 == 0) { label_mark.Text = string.Format("执行发货同步失败,SQL语句:{0}", sqlCmd2); return; } } } if (id.Contains("SFY")) { string sqlCmdStr = "select parentid from SFYOrderTab where OrderId='" + id + "'"; string orgId = SqlSel_Pro.GetSqlScale(sqlCmdStr).ToString(); sqlCmdStr = "select * from WDApiFH where OrderId='" + orgId + "' and LOG_INFO='" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "'"; SqlSel.GetSqlSel(ref dt2, sqlCmdStr); if (dt2.Rows.Count > 0) { continue; } else { string dtbln = orgId.Split('-')[0]; string dline = orgId.Substring(dtbln.Length + 1); string qunty = "0"; string sqlCmd2 = "insert into WDApiFH ([Header_ID],[Line_ID],[OrderId],[TQuantity],[LOG_INFO],[FHSat],[Create_Date],[TradeNO],[sendTime]) values ('" + dtbln + "','" + dline + "','" + orgId + "','" + qunty + "','" + string.Format("发货类型:{0},快递单号:{1} ", SndStyle, BillID) + "','0','" + DateTime.Now + "','" + tradeNo + "','" + sendTime + "')"; //执行发货同步 int execounts2 = SqlSel.ExeSql(sqlCmd2); if (execounts2 == 1) { } } } else { continue; } } //string sqlCmdt = "insert into WDApi_logs ([PageUrl],[AddedTime],[UserName],[IPAddress],[Privilege],[Description]) values ('','" + DateTime.Now + "','wdgj_api','" + IPAddress + "','发货同步','" + string.Format("【wdgj_发货同步】订单号:{0},同步时间{1},发货类型:{2},快递单号:{3} ", OrderNO.Replace(',', ','), DateTime.Now, SndStyle, BillID) + "')"; //执行插入日志 //int execountst = SqlSel_Pro.ExeSql(sqlCmdt); } catch (Exception ex) { Label_status.Text = ex.Message; Timer1.Enabled = false; } }