private DataTable GetSourceData() { DataTable Dt = new DataTable(); int intTotal_Cnt = 0; int intNomal_Cnt = 0; int intErr_Cnt = 0; int intTotal_Trans_Qty = 0; PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(H_Supplier.Value); ParameterList.Add(H_Chan_No.Value); ParameterList.Add(H_Store.Value); ParameterList.Add(txtChan_Trans_No.Text); ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value); Dt = BCO.GetSourceData(ParameterList, out intTotal_Cnt, out intNomal_Cnt, out intErr_Cnt, out intTotal_Trans_Qty); return Dt; }
//匯入 protected void btnImport_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; if (CheckImport()) { H_InTmpSec.Value = QueryLocateImport(SLP_Locate_No.Text); DataTable Dt = new DataTable(); int intTotal_Cnt = 0; int intNomal_Cnt = 0; int intErr_Cnt = 0; int intTotal_Trans_Qty = 0; PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(H_Supplier.Value); ParameterList.Add(H_Chan_No.Value); ParameterList.Add(H_Store.Value); ParameterList.Add(txtChan_Trans_No.Text); ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value); Dt = BCO.GetSourceData(ParameterList, out intTotal_Cnt, out intNomal_Cnt, out intErr_Cnt, out intTotal_Trans_Qty); string SessionIDName = "IVM144_" + PageTimeStamp.Value; Session[SessionIDName] = Dt; Session["H_ChanSourceNo"] = txtChan_Trans_No.Text; H_ChanSourceNo.Value = txtChan_Trans_No.Text; if (Dt.Rows.Count != 0) { //gvIn.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); gvIn.PageIndex = 0; gvIn.DataSource = Dt; gvIn.DataBind(); PanelGrid.Visible = true; lblTrans_Cnt.Text = intTotal_Cnt.ToString(); lblNormal.Text = intNomal_Cnt.ToString(); lblErr_Cnt.Text = intErr_Cnt.ToString(); lblNormalTotal.Text = intTotal_Trans_Qty.ToString(); PanelResult.Visible = true; btnImport.Enabled = false; SLP_Locate_No.ReadOnly = true; txtChan_Trans_No.ReadOnly = true; txtChan_Trans_No.CssClass = "readtxtbox"; } else { PanelGrid.Visible = false; PanelResult.Visible = false; SLP_Locate_No.ReadOnly = false; txtChan_Trans_No.ReadOnly = false; txtChan_Trans_No.CssClass = ""; //ScriptManager.RegisterStartupScript(Page, this.GetType(), "NoTransInData", "alert(' 查無待轉入資料 ');", true); ErrorMsgLabel.Text = "無正常待轉入資料"; } if (intErr_Cnt > 0) { btnViewErrorData.Enabled = true; } else { btnViewErrorData.Enabled = false; } if (intNomal_Cnt > 0) { btnTransIn.Enabled = true; } else { btnTransIn.Enabled = false; } if (Request.QueryString["PageMode"] == "3") { hdPageMode.Value = "new"; Session["PageMode" + PageTimeStamp.Value] = "new"; } else { hdPageMode.Value = "view"; Session["PageMode" + PageTimeStamp.Value] = "view"; } } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "DataFilledError", "alert(' 條件輸入不完整 ');", true); } }