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();
}
protected bool save()
{
Dictionary <int, Dictionary <string, object> > modifiedDict = GridGoodsList.GetModifiedDict();
List <CommandInfo> cmdList = new List <CommandInfo>();
foreach (int rowIndex in modifiedDict.Keys)
{
string rowID = GridGoodsList.DataKeys[rowIndex][1].ToString();
string Seqno = GridGoodsList.DataKeys[rowIndex][0].ToString();
if (GridGoodsList.DataKeys[rowIndex][2].ToString() == "定数申领" && modifiedDict[rowIndex]["FPSL"].ToString() != "0" && modifiedDict[rowIndex]["FPSL"].ToString() != GridGoodsList.DataKeys[rowIndex][3].ToString())
{
Alert.Show("单号【" + Seqno + "】为定数申领单，分配数量只能维护成0或申领数量");
return(false);
}
cmdList.Add(new CommandInfo(string.Format("UPDATE DAT_SL_COM SET FPSL = '{0}',FPUSER = '******',FPDATE = SYSDATE WHERE SEQNO ='{1}' AND ROWNO = {2}", modifiedDict[rowIndex]["FPSL"], Seqno, rowID, UserAction.UserID), null));
cmdList.Add(new CommandInfo(string.Format("UPDATE DAT_CK_COM SET FPSL = '{0}',FPUSER = '******',FPDATE = SYSDATE WHERE SEQNO ='{1}' AND ROWNO = {2}", modifiedDict[rowIndex]["FPSL"], Seqno, rowID, UserAction.UserID), null));
OperLog("库存分配", "修改单据【" + Seqno + "】出库数量");
}
if (cmdList.Count > 0)
{
DbHelperOra.ExecuteSqlTran(cmdList);
}
return(true);
}
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();
}
}
