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