protected void btnCanl_Click(object sender, EventArgs e) { if (hfdBCode.Text.Length < 1) { return; } if (!DbHelperOra.Exists("SELECT 1 FROM V_KCSP WHERE NUM1 = " + hfdBCode.Text + "")) { Alert.Show("您分配的商品信息已被其他人操做,请检查!", "提示信息", MessageBoxIcon.Warning); return; } List <CommandInfo> cmdList = new List <CommandInfo>(); cmdList.Add(new CommandInfo(string.Format("UPDATE DAT_SL_COM SET FPSL = 0 WHERE SEQNO IN (SELECT SEQNO FROM V_KCSP WHERE NUM1 = {0} AND FLAG = 'Y')", hfdBCode.Text), null)); cmdList.Add(new CommandInfo(string.Format("UPDATE DAT_SL_DOC SET NUM1 = 0 WHERE NUM1 = {0} AND FLAG IN ('S','D','W')", hfdBCode.Text), null)); cmdList.Add(new CommandInfo(string.Format("UPDATE DAT_CK_COM SET FPSL = 0 WHERE SEQNO IN (SELECT SEQNO FROM V_KCSP WHERE NUM1 = {0} AND FLAG = 'Y')", hfdBCode.Text), null)); cmdList.Add(new CommandInfo(string.Format("UPDATE DAT_CK_DOC SET NUM1 = 0 WHERE NUM1 = {0} AND FLAG = 'N'", hfdBCode.Text), null)); DbHelperOra.ExecuteSqlTran(cmdList); Alert.Show("波次[" + hfdBCode.Text + "]取消分配成功!"); OperLog("库存分配", "取消手工分配波次【" + hfdBCode.Text + "】"); GridGoods.DataSource = null; GridGoods.DataBind(); GridGoodsList.DataSource = null; GridGoodsList.DataBind(); TabStrip1.ActiveTabIndex = 0; DataSearch(); }
protected void GridGoods_RowDoubleClick(object sender, GridRowClickEventArgs e) { lblMessage.Text = "<span style='font-size: 12px;'>商品:</span><span style='color:red;font-weight:bold;'>[" + GridGoods.DataKeys[e.RowIndex][0] + "]" + GridGoods.DataKeys[e.RowIndex][2] + "</span></br><span style='font-size: 12px;'>可分配库存数量:</span><span style='color:red;font-weight:bold;'>" + GridGoods.DataKeys[e.RowIndex][1] + "</span>"; if (!save()) { return; } string gdseq = GridGoods.DataKeys[e.RowIndex][0].ToString(); string strSql = string.Format(@"SELECT A.*,f_getdeptname(A.DEPTOUT) DEPTOUTNAME,f_getdeptname(A.DEPTID) DEPTIDNAME,f_getunitname(A.UNIT) UNITNAME ,f_getusername(A.LRY) LRYNAME,f_getusername(A.SHR) SHRNAME,DECODE(FPTYPE,'1','定数申领','非定数申领') FPTYPENAME FROM V_KCSP A WHERE A.GDSEQ = '{0}' AND NVL(A.NUM1,0) = {1}", gdseq, hfdBCode.Text); GridGoodsList.DataSource = DbHelperOra.Query(strSql).Tables[0]; GridGoodsList.DataBind(); }
private void HDataSearch() { //根据hfdBCode打开对应单据 string strSQL = string.Format(@"SELECT A.DEPTOUT,GDSEQ,GDNAME,f_getunitname(A.UNIT) UNITNAME,GDSPEC,SUM(A.XSSL) SLSL, NVL((SELECT SUM(KCSL-LOCKSL) FROM DAT_GOODSSTOCK WHERE GDSEQ = A.GDSEQ AND KCSL > 0 AND DEPTID = A.DEPTOUT),0) KCSL FROM V_KCSP A WHERE NVL(NUM1,0) = {0} GROUP BY A.DEPTOUT,GDSEQ,GDNAME,UNIT,GDSPEC", hfdBCode.Text); int total = 0; DataTable dtData = PubFunc.DbGetPage(GridGoods.PageIndex, GridGoods.PageSize, strSQL + " ORDER BY GDSEQ", ref total); GridGoods.RecordCount = total; GridGoods.DataSource = dtData; GridGoods.DataBind(); GridGoodsList.DataSource = null; GridGoodsList.DataBind(); }
private void GridLoadData() { try { string sql = @"SELECT G.GDSEQ, G.GDNAME, G.GDSPEC, F_GETUNITNAME(G.UNIT) UNITNAME, G.HSJJ FROM DOC_GOODS G WHERE G.GDSEQ IN (SELECT DISTINCT P.GDSEQ FROM DOC_GOODSCFG P WHERE P.SPLB='Y' AND P.DEPTID IN (SELECT CODE FROM SYS_DEPT WHERE F_CHK_DATARANGE(CODE, '" + UserAction.UserID + @"') = 'Y'))"; int total = 0; GridGoodsList.DataSource = PubFunc.DbGetPage(GridGoodsList.PageIndex, GridGoodsList.PageSize, sql, ref total); GridGoodsList.RecordCount = total; GridGoodsList.DataBind(); } catch (Exception ex) { //有异常也不抛出,防止影响系统主界面运行 c 20150414 return; } //GridToDoList.DataSource = dtDaiBan; //GridToDoList.DataBind(); //GridBillStatus.DataSource = dtDD; // GridBillStatus.DataBind(); //if (dtYuJing != null && dtYuJing.Rows.Count > 0) //{ // List<object> list = new List<object>(); // foreach (DataRow row in dtYuJing.Rows) // { //if (row["TOTAL"].ToString() == "0") continue; //FineUI.HyperLink link = new FineUI.HyperLink(); //link.ID = row["DOTYPE"].ToString(); //link.Text = string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()); //link.NavigateUrl = "javascript:" + mainTabStrip.GetAddTabReference(row["FUNCID"].ToString(), row["RUNWHAT"].ToString(), row["FUNCNAME"].ToString(), "~/extjs/res/ext-theme-classic/images/tree/leaf.gif", true); //FineUI.LinkButton btnLink = new FineUI.LinkButton(); //btnLink.ID = "btn_" + row["SEQNO"].ToString(); //btnLink.ShowLabel = false; //btnLink.Label = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(); //if (row["DOTYPE"].ToString() == "DO_2") //{ // list.Add(new // { // PARA = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(), // INSTRUCTIONS = "部门『" + row["DEPT"].ToString() + "』" + string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()) // }); //btnLink.Text = "部门『" + row["DEPT"].ToString() + "』" + string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()); //} //else //{ // if (row["DOTYPE"].ToString() == "ksjxq") // { // string[] total_number = row["TOTAL"].ToString().Split(';'); // list.Add(new // { // PARA = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(), // INSTRUCTIONS = string.Format(row["INSTRUCTIONS"].ToString(), total_number[0], total_number[1]) // }); // } // else // if (row["DOTYPE"].ToString() != "DO_1") // { // list.Add(new // { // PARA = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(), // INSTRUCTIONS = string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()) // }); // // btnLink.Text = string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()); // } //} ////btnLink.OnClientClick = mainTabStrip.GetAddTabReference(row["FUNCID"].ToString(), row["RUNWHAT"].ToString(), row["FUNCNAME"].ToString(), "~/extjs/res/ext-theme-classic/images/tree/leaf.gif", true); //btnLink.Click += new EventHandler(btnLink_Click); //btnLink.EnablePostBack = true; //Panel3.Items.Add(btnLink); //} //GridYuJing.DataSource = list; //GridYuJing.DataBind(); //} }
private void GridLoadData() { try { string sql = @"SELECT A.GDSEQ,B.GDNAME,B.GDSPEC,f_getunitname(B.UNIT) UNITNAME,B.HSJJ,A.ZGKC,A.ZDKC,DECODE(A.NUM1,0,'否',DECODE(A.DSNUM,0,'否','是')) ISDS, NVL((SELECT SUM(KCSL)FROM DAT_GOODSSTOCK K WHERE KCSL > 0 AND K.DEPTID = A.DEPTID AND K.GDSEQ = A.GDSEQ),0) KCSL FROM DOC_GOODSCFG A,DOC_GOODS B WHERE A.GDSEQ = B.GDSEQ AND A.DEPTID IN (SELECT CODE FROM SYS_DEPT WHERE F_CHK_DATARANGE(CODE, '{0}') = 'Y')"; int total = 0; DataTable dt = PubFunc.DbGetPage(GridGoodsList.PageIndex, GridGoodsList.PageSize, String.Format(sql, UserAction.UserID), ref total); GridGoodsList.RecordCount = total; GridGoodsList.DataSource = dt; GridGoodsList.DataBind(); } catch (Exception ex) { //有异常也不抛出,防止影响系统主界面运行 c 20150414 return; } //GridToDoList.DataSource = dtDaiBan; //GridToDoList.DataBind(); //GridBillStatus.DataSource = dtDD; // GridBillStatus.DataBind(); //if (dtYuJing != null && dtYuJing.Rows.Count > 0) //{ // List<object> list = new List<object>(); // foreach (DataRow row in dtYuJing.Rows) // { //if (row["TOTAL"].ToString() == "0") continue; //FineUIPro.HyperLink link = new FineUIPro.HyperLink(); //link.ID = row["DOTYPE"].ToString(); //link.Text = string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()); //link.NavigateUrl = "javascript:" + mainTabStrip.GetAddTabReference(row["FUNCID"].ToString(), row["RUNWHAT"].ToString(), row["FUNCNAME"].ToString(), "~/extjs/res/ext-theme-classic/images/tree/leaf.gif", true); //FineUIPro.LinkButton btnLink = new FineUIPro.LinkButton(); //btnLink.ID = "btn_" + row["SEQNO"].ToString(); //btnLink.ShowLabel = false; //btnLink.Label = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(); //if (row["DOTYPE"].ToString() == "DO_2") //{ // list.Add(new // { // PARA = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(), // INSTRUCTIONS = "部门『" + row["DEPT"].ToString() + "』" + string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()) // }); //btnLink.Text = "部门『" + row["DEPT"].ToString() + "』" + string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()); //} //else //{ // if (row["DOTYPE"].ToString() == "ksjxq") // { // string[] total_number = row["TOTAL"].ToString().Split(';'); // list.Add(new // { // PARA = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(), // INSTRUCTIONS = string.Format(row["INSTRUCTIONS"].ToString(), total_number[0], total_number[1]) // }); // } // else // if (row["DOTYPE"].ToString() != "DO_1") // { // list.Add(new // { // PARA = row["SEQNO"].ToString() + "," + row["FUNCID"].ToString() + "," + row["RUNWHAT"].ToString() + "," + row["FUNCNAME"].ToString() + "," + row["EXECTYPE"].ToString(), // INSTRUCTIONS = string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()) // }); // // btnLink.Text = string.Format(row["INSTRUCTIONS"].ToString(), row["TOTAL"].ToString()); // } //} ////btnLink.OnClientClick = mainTabStrip.GetAddTabReference(row["FUNCID"].ToString(), row["RUNWHAT"].ToString(), row["FUNCNAME"].ToString(), "~/extjs/res/ext-theme-classic/images/tree/leaf.gif", true); //btnLink.Click += new EventHandler(btnLink_Click); //btnLink.EnablePostBack = true; //Panel3.Items.Add(btnLink); //} //GridYuJing.DataSource = list; //GridYuJing.DataBind(); //} }
protected void btnSure_Click(object sender, EventArgs e) { if (hfdBCode.Text.Length < 1) { return; } if (!save()) { return; } //对分配的数量进行判断 string sql = string.Format(@"SELECT 1 FROM (SELECT DEPTOUT, GDSEQ, SUM(XSSL) SL FROM V_KCSP WHERE NUM1 = '3247' GROUP BY DEPTOUT, GDSEQ) A, (SELECT SUM(KCSL - LOCKSL) SL, GDSEQ, DEPTID FROM DAT_GOODSSTOCK GROUP BY DEPTID, GDSEQ) B WHERE A.DEPTOUT = B.DEPTID AND A.GDSEQ = B.GDSEQ AND A.SL > B.SL", hfdBCode.Text); if (DbHelperOra.Exists(sql)) { Alert.Show("分配的商品数量大于可出库库存数量,请检查!", "", MessageBoxIcon.Warning); HDataSearch(); return; } try { OracleParameter[] parameters = { new OracleParameter("VTASKID", OracleDbType.Varchar2, 20), new OracleParameter("VPARA", OracleDbType.Varchar2, 800) }; parameters[0].Value = hfdBCode.Text; parameters[1].Value = UserAction.UserID; DbHelperOra.RunProcedure("STOREDS.P_FP_AUDIT", parameters); Alert.Show("波次[" + hfdBCode.Text + "]配给确认成功!"); GridGoods.DataSource = null; GridGoods.DataBind(); GridGoodsList.DataSource = null; GridGoodsList.DataBind(); TabStrip1.ActiveTabIndex = 0; DataSearch(); OperLog("库存分配", "分配波次【" + hfdBCode.Text + "】-2"); } catch (Exception mx) { if (mx.Message.IndexOf("ORA-20001") > -1) { string msg = mx.Message.Substring(0, mx.Message.IndexOf("\n")); Alert.Show("配给确认失败,错误信息:\n\r\n\r " + msg.Substring(msg.IndexOf("ORA-20001") + 10), "错误信息", MessageBoxIcon.Warning); } else if (mx.Message.IndexOf("ORA-20099") > -1) { string msg = mx.Message.Substring(0, mx.Message.IndexOf("\n")); Alert.Show("配给确认失败,错误信息:\n\r\n\r " + msg.Substring(msg.IndexOf("ORA-20099") + 10), "错误信息", MessageBoxIcon.Warning); } else { Alert.Show("配给确认失败!" + mx.Message + "", "错误信息", MessageBoxIcon.Question); } HDataSearch(); } }