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