/// <summary> /// IVM144_1報表(列印鈕) /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable IVM144_1(ArrayList ParameterList) { #region IVMModel.MaintainDataTrans BCO = new IVMModel.MaintainDataTrans(ConntionDB); DataTable Dt = BCO.QueryTransInErr(ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } else { return Dt; } #endregion }
/// <summary> /// BUTTON [查詢]鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void but_Query_Click(object sender, EventArgs e) { try { #region 設定變數 DataTable dt_Return_UP = new DataTable(); #endregion #region 檢查條件 BCO_CAA.CAACommon CAAComm = new BCO_CAA.CAACommon(); ArrayList arl_Check_Condition = Check_Condition("BUTTON [查詢]鈕"); #region 如果檢查有誤,則Return if (arl_Check_Condition[1].ToString() != string.Empty) { #region 錯誤訊息 this.ErrorMsgLabel.Text = arl_Check_Condition[1].ToString(); #endregion #region Focus欄位 if (arl_Check_Condition[0].ToString() != string.Empty) { string s_ScriptManager_Script = CAAComm.ToMakeUp_SetFocus_Script(arl_Check_Condition[0].ToString(), true); ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CGD261", s_ScriptManager_Script, true); } #endregion return; } #endregion #endregion #region 取得欄位[條碼][二段條碼][品名][品號][期別] #region 傳入參數 ParameterList.Clear(); ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_FULL_BARCODE.Text, "string", false));//[商品條碼] #endregion #region 連接資料庫 BCO_IVM.MaintainDataTrans bco_IVM = new BCO_IVM.MaintainDataTrans(ConntionDB); dt_Return_UP = bco_IVM.GetItemByBarCode(ParameterList); #endregion #region 檢查回傳資料 if (dt_Return_UP.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; dt_Result = null; this.Repeater1.DataSource = dt_Result; this.Repeater1.DataBind(); this.txt_BARCODE.Text = string.Empty;//條碼 this.txt_PERIOD_BARCODE.Text = string.Empty;//二段條碼 this.txt_ITEM_NAME.Text = string.Empty;//品名 this.txt_ITEM.Text = string.Empty;//品號 this.txt_PERIOD.Text = string.Empty;//期別 return; } #endregion #region 將資料寫入欄位 this.txt_BARCODE.Text = dt_Return_UP.Rows[0]["BARCODE"].ToString(); this.txt_PERIOD_BARCODE.Text = dt_Return_UP.Rows[0]["PERIOD_BARCODE"].ToString(); this.txt_ITEM_NAME.Text = dt_Return_UP.Rows[0]["ITEM_NAME"].ToString(); this.txt_ITEM.Text = dt_Return_UP.Rows[0]["ITEM"].ToString(); this.txt_PERIOD.Text = dt_Return_UP.Rows[0]["PERIOD"].ToString(); #endregion #endregion #region 傳入參數 ParameterList.Clear(); ParameterList.Add(CAAComm.GetValueSetParameter(this.slp_ST_ACCEPT_DATE.Text, "date", false));//[門市進貨日] ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_PICK_BATCH.Text, "string", false));//[理貨批次] ParameterList.Add(CAAComm.GetValueSetParameter(this.ddl_LINE_B.SelectedValue, "string", false));//[理貨線]起 ParameterList.Add(CAAComm.GetValueSetParameter(this.ddl_LINE_E.SelectedValue, "string", false));//[理貨線]迄 ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_ITEM.Text, "string", false));//[品號] ParameterList.Add(CAAComm.GetValueSetParameter(this.txt_PERIOD.Text, "string", false));//[期別] ParameterList.Add(CAAComm.GetValueSetParameter(Session["UID"].ToString(), "string", false));//[登入人員] #endregion #region 連接資料庫 BCO_CGD.CGD26_BCO bco_CGD = new BCO_CGD.CGD26_BCO(ConntionDB); dt_Result = bco_CGD.QUERY_CGD26_DATA(ParameterList); #endregion #region 資料載入畫面 this.Repeater1.DataSource = dt_Result; this.Repeater1.DataBind(); #endregion #region 檢查回傳資料 if (dt_Result.Rows.Count == 0) { this.ErrorMsgLabel.Text = "查無資料"; ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CGD261_FOCUS", "setTimeout(function(){document.getElementById('" + txt_FULL_BARCODE.ClientID + "').focus();},10);", true); } else { string s_Filter_Expression = string.Empty;//篩選資料SQL s_Filter_Expression = "ROW_TYPE = 'ITEM'"; DataRow[] dr_IMG = dt_Result.Select(s_Filter_Expression); if (dr_IMG.Length == 1) { } else { this.ErrorMsgLabel.Text = "該筆資料查無商品的資料。"; } txt_FULL_BARCODE.Text = ""; ScriptManager.RegisterStartupScript(this.up_Msg, typeof(UpdatePanel), "CGD261_FOCUS", "setTimeout(function(){document.getElementById('" + but_Out.ClientID + "').focus();},10);", true); } #endregion } catch (Exception ex) { WaringLogProcess(ex.Message); this.ErrorMsgLabel.Text = ex.Message; } }
private void GetExceptionVendor() { IVMModel.MaintainDataTrans BCO = new IVMModel.MaintainDataTrans(ConntionDB); string Chan = ""; string Store = ""; string Supplier = ""; BCO.GetExceptionData(out Chan, out Store, out Supplier); this.hidVendorException.Value = Supplier; }
protected void btnQuery_Click(object sender, EventArgs e) { PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(TextBoxRowCountLimit.Text); ParameterList.Add(txtTrans_No.Text); ParameterList.Add(txtChan_Source_No.Text); ParameterList.Add(SLP_Trans_Date.Text); ParameterList.Add(SLP_Locate_No.Text); ParameterList.Add(""); ParameterList.Add(txtChan_Trans_No.Text); DataTable Dt = BCO.QueryTransInByFind(ParameterList); if (Dt.Rows.Count != 0) { BindGrid(Dt); } else { ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "QueryNoData", "alert(' 查無資料 ');", true); } }
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; }
//取得 CHAN_NO, STORE, SUPPLIER 備用 private void GetValueForAdd() { string strChanNo = string.Empty; string strStore = string.Empty; string strSupplier = string.Empty; PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); BCO.GetExceptionData(out strChanNo, out strStore, out strSupplier); H_Chan_No.Value = strChanNo; H_Store.Value = strStore; H_Supplier.Value = strSupplier; }
private void LoadData(string strID) { PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(int.Parse(strID)); DataTable Dt = BCO.QueryTransDetl(ParameterList); if (Dt.Rows.Count != 0) { //gvIn 賦值 BindGrid(Dt); int intSum = 0; for (int i = 0; i < Dt.Rows.Count; i++) { intSum += int.Parse(Dt.Rows[i]["TRANS_QTY"].ToString()); } PanelGrid.Visible = true; //畫面上控制項賦值 BindControl(strID, intSum); } else { ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "QueryNoData", "alert(' 查無資料 ');", true); } }
private void SetNoRangeValue(string strTransNo) { PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(1); ParameterList.Add(strTransNo); ParameterList.Add(""); ParameterList.Add(""); ParameterList.Add(""); ParameterList.Add(""); ParameterList.Add(""); DataTable Dt = BCO.QueryTransInByFind(ParameterList); DataRow dr = Dt.Select("TRANS_NO ='" + strTransNo + "'")[0]; if (dr["REMOVE_NO_RANGE"].ToString().IndexOf('~') != -1) { string[] strREMOVE_NO_RANGE = dr["REMOVE_NO_RANGE"].ToString().Split(new char[] { '~' }); lblRemove_No_Range.Text = strREMOVE_NO_RANGE[0] + "~<br>" + strREMOVE_NO_RANGE[1]; } else { lblRemove_No_Range.Text = ""; } if (dr["BACKWARD_NO_RANGE"].ToString().IndexOf('~') != -1) { string[] strRETURN_NO_RANGE = dr["BACKWARD_NO_RANGE"].ToString().Split(new char[] { '~' }); lblReturn_No_Range.Text = strRETURN_NO_RANGE[0] + "~<br>" + strRETURN_NO_RANGE[1]; } else { lblReturn_No_Range.Text = ""; } if (dr["ACCEPT_NO_RAGNE"].ToString().IndexOf('~') != -1) { string[] strST_ACCEPT_NO_RANGE = dr["ACCEPT_NO_RAGNE"].ToString().Split(new char[] { '~' }); lblST_Accept_No_Range.Text = strST_ACCEPT_NO_RANGE[0] + "~<br>" + strST_ACCEPT_NO_RANGE[1]; } else { lblST_Accept_No_Range.Text = ""; } if (dr["INOUT_NO_RANGE"].ToString().IndexOf('~') != -1) { string[] strINOUT_NO_RANGE = dr["INOUT_NO_RANGE"].ToString().Split(new char[] { '~' }); lblInOut_No_Range.Text = strINOUT_NO_RANGE[0] + "~<br>" + strINOUT_NO_RANGE[1]; } else { lblInOut_No_Range.Text = ""; } PanelList.Visible = true; //this.MID.Value = dr["ID"].ToString(); Session["MID"] = dr["ID"].ToString(); }
//執行轉入 protected void btnTransIn_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; try { int intID = 0; string strTransNo = string.Empty; string strMsg = string.Empty; string strResult = string.Empty; PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(H_Supplier.Value); //0 ParameterList.Add(H_Store.Value); //1 ParameterList.Add(H_Chan_No.Value); //2 ParameterList.Add(Session["H_ChanSourceNo"].ToString()); //3 ParameterList.Add(Session["UID"].ToString()); //4 ParameterList.Add(SLP_Locate_No.Text); //5 ParameterList.Add(H_InTmpSec.Value); //6 ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value); //7 BCO.CreateTransIn(ParameterList, DBT, out intID, out strTransNo, out strMsg, out strResult); if (strResult == "1") { txtTrans_No.Text = strTransNo; Session["ForChanTransNo"] = strTransNo; //MID.Value = intID.ToString(); Session["MID"] = intID.ToString(); SetDefaultStatus("1"); SetNoRangeValue(strTransNo); hdPageMode.Value = "view"; Session["PageMode" + PageTimeStamp.Value] = "view"; DataTable dtTemp = GetSourceData(); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
//匯入 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); } }
protected void btnDelTransData_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; string strMsg = string.Empty; if (CheckImport()) { try { PIC.VDS2G.VSM.IVM.MaintainDataTrans BCO = new PIC.VDS2G.VSM.IVM.MaintainDataTrans(ConntionDB); ParameterList.Clear(); ParameterList.Add(txtChan_Trans_No.Text); BCO.DeleteTransData(ParameterList, DBT, out strMsg); if (strMsg == "") { ScriptManager.RegisterClientScriptBlock(Page, this.GetType(), "Success", "alert(' 刪除成功 ');location.href='IVM144.aspx?Code=IVM14&PageMode=3'", true); //Response.Redirect("IVM144.aspx?Code=IVM14&PageMode=3", false); } else { ErrorMsgLabel.Text = strMsg; } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "DataFilledError", "alert(' 條件輸入不完整 ');", true); } }