protected void bntSave_Click(object sender, EventArgs e) { List <CommandInfo> cmdList = new List <CommandInfo>(); JArray jary = GridGoods.GetModifiedData(); if (jary.Count < 1) { Alert.Show("未修改信息,不需要保存!", MessageBoxIcon.Warning); return; } foreach (JObject job in jary) { String deptid = GridGoods.DataKeys[Convert.ToInt16(job["index"])][0].ToString(); String ddlSTR4 = (job.SelectToken(string.Format("$..values.{0}", "STR4")) ?? "").ToString(); String ddlDHZQ1 = (job.SelectToken(string.Format("$..values.{0}", "DHZQ1")) ?? "").ToString(); String ddlDHZQ2 = (job.SelectToken(string.Format("$..values.{0}", "DHZQ2")) ?? "").ToString(); String ddlDHZQ3 = (job.SelectToken(string.Format("$..values.{0}", "DHZQ3")) ?? "").ToString(); String ddlDHZQ4 = (job.SelectToken(string.Format("$..values.{0}", "DHZQ4")) ?? "").ToString(); String ddlDHZQ5 = (job.SelectToken(string.Format("$..values.{0}", "DHZQ5")) ?? "").ToString(); String ddlDHZQ6 = (job.SelectToken(string.Format("$..values.{0}", "DHZQ6")) ?? "").ToString(); String ddlDHZQ7 = (job.SelectToken(string.Format("$..values.{0}", "DHZQ7")) ?? "").ToString(); cmdList.Add(new CommandInfo(string.Format(@"UPDATE SYS_DEPT SET STR4 = NVL('{0}',STR4),DHZQ1 = NVL('{1}',DHZQ1), DHZQ2 = NVL('{2}',DHZQ2),DHZQ3 = NVL('{3}',DHZQ3), DHZQ4 = NVL('{4}',DHZQ4),DHZQ5 = NVL('{5}',DHZQ5), DHZQ6 = NVL('{6}',DHZQ6),DHZQ7 = NVL('{7}',DHZQ7) WHERE CODE = '{8}'", ddlSTR4, ddlDHZQ1, ddlDHZQ2, ddlDHZQ3, ddlDHZQ4, ddlDHZQ5, ddlDHZQ6, ddlDHZQ7, deptid), null)); } if (DbHelperOra.ExecuteSqlTran(cmdList)) { Alert.Show("数据保存成功!"); DataSearch(); } }
protected void bntSave_Click(object sender, EventArgs e) { String uptSql = "update doc_goods set NUM1={1},str3='{2}',hiscode='{3}',hisname='{4}' where GDSEQ='{0}'"; List <CommandInfo> lci = new List <CommandInfo>(); JArray ja = GridGoods.GetModifiedData(); foreach (JToken jt in ja) { JArray theJa = JArray.FromObject(jt); object[] keys = GridGoods.DataKeys[Convert.ToInt16(theJa[0])]; String gdseq = keys[0].ToString(); int num1 = Convert.ToInt16(keys[1]); String str3 = keys[2].ToString(); String hiscode = keys[3].ToString(); String hisname = keys[4].ToString(); JObject jo = JObject.FromObject(theJa[2]); if (!string.IsNullOrWhiteSpace(jo.Value <String>("NUM1"))) { num1 = Convert.ToInt16(jo.Value <String>("NUM1")); } if (!string.IsNullOrWhiteSpace(jo.Value <String>("STR3"))) { str3 = jo.Value <String>("STR3"); } if (!string.IsNullOrWhiteSpace(jo.Value <String>("HISCODE"))) { hiscode = jo.Value <String>("HISCODE"); } if (!string.IsNullOrWhiteSpace(jo.Value <String>("HISNAME"))) { hisname = jo.Value <String>("HISNAME"); } lci.Add(new CommandInfo(String.Format(uptSql, gdseq, num1, str3, hiscode, hisname), null)); } DbHelperOra.ExecuteSqlTran(lci); DataSearch(); }
protected void bntSave_Click(object sender, EventArgs e) { //JObject defaultObj = Doc.GetJObject(GridGoods, e.RowID); String querySql = "select COUNT(1) from doc_goodscfg WHERE GDSEQ='{0}' AND DEPTID='{1}'"; String insSql = "insert into doc_goodscfg (GDSEQ,DEPTID,NUM1,DSNUM,ISCFG,HJCODE1) values ('{0}','{1}',{2},{3},'Y','{1}')"; String uptSql = "update doc_goodscfg set NUM1={2},DSNUM={3},ISCFG='Y' where GDSEQ='{0}' and DEPTID='{1}'"; List <CommandInfo> lci = new List <CommandInfo>(); JArray ja = GridGoods.GetModifiedData(); foreach (JToken jt in ja) { //取ID String res = (jt.SelectToken(string.Format("$.{0}", "index")) ?? "").ToString(); String rowid = (jt.SelectToken(string.Format("$.{0}", "id")) ?? "").ToString(); JObject defaultObj = Doc.GetJObject(GridGoods, rowid); object[] keys = GridGoods.DataKeys[Convert.ToInt16(res)]; int num1 = Convert.ToInt32(defaultObj["DSHANL"]); int dsnum = Convert.ToInt32(defaultObj["DSNUM"]); String gdseq = keys[0].ToString(); String deptId = ""; if (DbHelperOra.Exists(string.Format("SELECT 1 FROM DOC_GOODS WHERE GDSEQ = '{0}' AND ISGZ='Y'", gdseq))) { Alert.Show(string.Format("商品【{0}】为高值商品,不允许设置为定数", keys[4].ToString()), "消息提示", MessageBoxIcon.Warning); return; } if (DbHelperOra.Exists(string.Format("SELECT 1 FROM DOC_GOODS WHERE GDSEQ = '{0}' AND ISFLAG3='Y'", gdseq))) { Alert.Show(string.Format("商品【{0}】为直送商品,不允许设置为定数", keys[4].ToString()), "消息提示", MessageBoxIcon.Warning); return; } if (!string.IsNullOrWhiteSpace((String)keys[1])) { deptId = keys[1].ToString(); } else if (!string.IsNullOrWhiteSpace(ddlDEPTID.SelectedValue)) { deptId = ddlDEPTID.SelectedValue; } else { Alert.Show("新增配置需要选择库房!"); return; } //if (string.IsNullOrEmpty(keys[3].ToString())) //{ // Alert.Show("定数数量不能为空!"); // return; //} //if (string.IsNullOrEmpty(keys[2].ToString())) //{ // Alert.Show("定数含量不能为空!"); // return; //} //int num1 = Convert.ToInt32(keys[2]); //int dsnum = Convert.ToInt32(keys[3]); //JArray theJa = JArray.FromObject(jt); //JObject jo = JObject.FromObject(theJa[2]); //if (!string.IsNullOrWhiteSpace(jo.Value<String>("DSNUM"))) //{ // dsnum = Convert.ToInt32(jo.Value<String>("DSNUM")); //} //if (!string.IsNullOrWhiteSpace(jo.Value<String>("DSHANL"))) //{ // num1 = Convert.ToInt32(jo.Value<String>("DSHANL")); //} if (DbHelperOra.Exists(String.Format(querySql, gdseq, deptId))) { lci.Add(new CommandInfo(String.Format(uptSql, gdseq, deptId, num1, dsnum), null)); } else { lci.Add(new CommandInfo(String.Format(insSql, gdseq, deptId, num1, dsnum), null)); } OperLog("定数设置", "修改商品【" + gdseq + "】"); } if (lci.Count == 0) { Alert.Show("信息无需保存。"); } else { DbHelperOra.ExecuteSqlTran(lci); Alert.Show("信息保存成功。"); } DataSearch(); }
protected void bntSave_Click(object sender, EventArgs e) { String querySql = "select COUNT(1) from doc_goodscfg WHERE GDSEQ='{0}' AND DEPTID='{1}'"; String insSql = "insert into doc_goodscfg (GDSEQ,DEPTID,DHXS,DAYSL,ZDKC,ZGKC,ISAUTO,ISCFG) values ('{0}','{1}',{2},{3},{4},{5},'{6}','1')"; String uptSql = "update doc_goodscfg set DHXS={2},DAYSL={3},ZDKC={4},ZGKC={5},ISAUTO='{6}',ISCFG='Y' where GDSEQ='{0}' and DEPTID='{1}'"; List <CommandInfo> lci = new List <CommandInfo>(); JArray ja = GridGoods.GetModifiedData(); foreach (JToken jt in ja) { String res = (jt.SelectToken(string.Format("$.{0}", "index")) ?? "").ToString(); String rowid = (jt.SelectToken(string.Format("$.{0}", "id")) ?? "").ToString(); JObject defaultObj = Doc.GetJObject(GridGoods, rowid); object[] keys = GridGoods.DataKeys[Convert.ToInt16(res)]; int dhxs = Convert.ToInt32(defaultObj["DHXS"]); int daysl = Convert.ToInt32(defaultObj["DAYSL"]); int zdkc = Convert.ToInt32(defaultObj["ZDKC"]); int zgkc = Convert.ToInt32(defaultObj["ZGKC"]); String isAuto = (Convert.ToBoolean(defaultObj["ISAUTO"])) ? "Y" : "N"; String gdseq = keys[0].ToString(); String deptId = ""; if (!string.IsNullOrWhiteSpace((String)keys[1])) { deptId = keys[1].ToString(); } else if (!string.IsNullOrWhiteSpace(ddlDEPTID.SelectedValue)) { deptId = ddlDEPTID.SelectedValue; } else { Alert.Show("新增配置需要选择库房!"); return; } //int dhxs = 0; //int daysl = 0; //int zdkc = 0; //int zgkc = 0; //if (keys[2] != null && !string.IsNullOrWhiteSpace(keys[2].ToString())) //{ // dhxs = (Convert.ToInt32(keys[2])); //} //if (keys[3] != null && !string.IsNullOrWhiteSpace(keys[3].ToString())) //{ // daysl = Convert.ToInt32(keys[3]); //} //if (keys[4] != null && !string.IsNullOrWhiteSpace(keys[4].ToString())) //{ // zdkc = Convert.ToInt32(keys[4]); //} //if (keys[5] != null && !string.IsNullOrWhiteSpace(keys[5].ToString())) //{ // zgkc = Convert.ToInt32(keys[5]); //} //String isAuto = (Convert.ToInt32(keys[6]) == 1) ? "Y" : "N"; if (zdkc > zgkc && zgkc > 0) { Alert.Show("商品【" + gdseq + "】最高库存应大于最低库存!", "提示信息", MessageBoxIcon.Warning); return; } if (DbHelperOra.Exists(String.Format(querySql, gdseq, deptId))) { lci.Add(new CommandInfo(String.Format(uptSql, gdseq, deptId, dhxs, daysl, zdkc, zgkc, isAuto), null)); OperLog("商品配置", "修改商品【" + gdseq + "】"); } else { lci.Add(new CommandInfo(String.Format(insSql, gdseq, deptId, dhxs, daysl, zdkc, zgkc, isAuto), null)); OperLog("商品配置", "增加商品【" + gdseq + "】"); } } DbHelperOra.ExecuteSqlTran(lci); Alert.Show("信息保存成功。"); DataSearch(); }