protected void btnAddRight_Click(object sender, EventArgs e) { if (ddlDept.SelectedValue.Length > 0) { int[] selectArray = GridGoods.SelectedRowIndexArray; if (selectArray.Length > 0) { List <CommandInfo> cmdList = new List <CommandInfo>(); MyTable myGoodsCFG = new MyTable("DOC_GOODSCFG"); for (int i = 0; i < selectArray.Length; i++) { Object OBJ = DbHelperOra.GetSingle(String.Format("SELECT DEPTID FROM DOC_GOODSCFG A,SYS_DEPT B WHERE A.DEPTID = B.CODE AND B.TYPE = '1' AND A.GDSEQ = '{0}'", GridGoods.Rows[selectArray[i]].Values[2].ToString())); if ((OBJ ?? "").ToString().Length > 0) { Alert.Show(string.Format("商品【{0}】已配置到库房【{1}】!", GridGoods.Rows[selectArray[i]].Values[2].ToString(), OBJ), "消息提示", MessageBoxIcon.Warning); return; } if (GridGoods.Rows[selectArray[i]].Values[8].ToString() != "Y" && GridGoods.Rows[selectArray[i]].Values[8].ToString() != "T") { Alert.Show(string.Format("商品【{0}】状态信息错误!", GridGoods.Rows[selectArray[i]].Values[2].ToString()), "消息提示", MessageBoxIcon.Warning); return; } myGoodsCFG.ColRow.Clear(); myGoodsCFG.ColRow.Add("GDSEQ", GridGoods.Rows[selectArray[i]].Values[0]); myGoodsCFG.ColRow.Add("DEPTID", ddlDept.SelectedValue); myGoodsCFG.ColRow.Add("ISCFG", "Y"); myGoodsCFG.ColRow.Add("NUM1", "0"); myGoodsCFG.ColRow.Add("NUM3", "0"); myGoodsCFG.ColRow.Add("DSNUM", "0"); if (DbHelperOra.Exists("SELECT 1 FROM SYS_DEPT WHERE CODE = '" + ddlDept.SelectedValue + "' AND TYPE IN('1','2')")) { trbHJCODE1.Enabled = true; } else { myGoodsCFG.ColRow.Add("HJCODE1", ddlDept.SelectedValue); trbHJCODE1.Enabled = false; } cmdList.Add(myGoodsCFG.Insert()); OperLog("商品配置", "修改科室【" + ddlDept.SelectedValue + "】商品【" + GridGoods.Rows[selectArray[i]].Values[0] + "】"); } DbHelperOra.ExecuteSqlTran(cmdList); dataSearch(); dataSearch("right"); } else { Alert.Show("请选择要进行配置的商品信息!"); GridGoods.Focus(); } } else { Alert.Show("请选择要进行配置的部门!"); ddlDept.Focus(); } }