/// <summary> /// 搜尋鈕 /// </summary> protected void btnSearch_Click(object sender, EventArgs e) { DataTable Dt; string strMsg = string.Empty; string strResult = string.Empty; CGRModel.MaintainBackWard BCO = new PIC.VDS2G.LGT.CGR.MaintainBackWard(ConntionDB); ParameterList.Clear(); ParameterList.Add("0"); ParameterList.Add(SLP_StoreChain.Text); Dt = BCO.GetUnClosedBatch(ParameterList, out strMsg, out strResult); if (strResult == "0") { ErrorMsgLabel.Text = strMsg; PanelBatch.Visible = false; PanelOK.Visible = false; } else { BindBatch(Dt); PanelBatch.Visible = true; btnCount.Enabled = true; SLP_StoreChain.ReadOnly = true; btnSearch.Enabled = false; PanelOK.Visible = false; } }
/// <summary> /// 計算數量鈕 /// </summary> protected void btnCount_Click(object sender, EventArgs e) { try { if (chkBatchIsSelect()) { string strMsg = string.Empty; string strResult = string.Empty; DataTable Dt = new DataTable(); DataTable Dt_Error = new DataTable(); PIC.VDS2G.LGT.CGR.MaintainBackWard BCO = new PIC.VDS2G.LGT.CGR.MaintainBackWard(ConntionDB); ParameterList.Clear(); string strBatchNo = GetBatchNo(); if (rdoType.SelectedIndex == 0) //Sorter結轉 { ParameterList.Add(SLP_StoreChain.Text); ParameterList.Add(strBatchNo); ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value); Dt = BCO.GetSorterData(ParameterList, out strMsg, out strResult); if (strResult == "0") { if (strMsg == "檢核結果異常" || strMsg == "無可結轉資料") { ParameterList.Clear(); ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value); Dt_Error = BCO.GetErrData(ParameterList); PanelError.Visible = true; btnPrint.Visible = false; gvError.Visible = false; //CheckErrorMsg.Text = "檢核結果異常!"; CheckErrorMsg.Text = strMsg; if (strMsg == "檢核結果異常") { PanelError.Visible = true; btnPrint.Visible = true; gvError.Visible = true; BindError(Dt_Error); } } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "BatchIsClosed", "alert('" + strMsg + "');", true); } } else { if (Dt.Rows.Count > 0) { ViewState["EnableAdjust"] = true; //Bind gvDetail BindDetail(Dt); } //顯示訊息,控制畫面 SetOkStatus(); } } else //通路退貨結轉 { ParameterList.Add(SLP_StoreChain.Text); ParameterList.Add(strBatchNo); Dt = BCO.GetChanRtnData(ParameterList, out strMsg, out strResult); if (strResult == "1") { if (Dt.Rows.Count > 0) { ViewState["EnableAdjust"] = true; //Bind gvDetail BindDetail(Dt); } //顯示訊息,控制畫面 SetOkStatus(); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "BatchIsClosed", "alert('" + strMsg + "');", true); } } } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "chkBatchIsSelect", "alert(' 無批號被選擇 ');", true); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }
/// <summary> /// CRM07_1 /// </summary> /// <param name="Parameter">變數集</param> /// <param name="Ds">回傳結果</param> /// <returns>回傳成功失敗</returns> public bool CGR02_1(ArrayList ParameterList, ref DataSet Ds ) { bool Result = false; try { string strInOut_No = string.Empty; string strMsg = string.Empty; string strResult = string.Empty; string strMainID = string.Empty; string strAdjustNo = string.Empty; ArrayList ErrList = new ArrayList(); ArrayList ParameterList2 = new ArrayList(); DataTable Dt = new DataTable(); if (Ds==null) { Ds = new DataSet(); } for (int i = Ds.Tables.Count-1; i >=0 ; i--) { Ds.Tables.RemoveAt(i); } //PIC.VDS2G.LGT.CGR.MaintainBackWard BCO = new PIC.VDS2G.LGT.CGR.MaintainBackWard(ConntionDB); //ParameterList.Clear(); //ParameterList.Add(GetIsAdjust()); //IsAdjust //ParameterList.Add(rdoType.SelectedValue); //Type //ParameterList.Add(GetBatchNo()); //BatchNos //ParameterList.Add(SLP_StoreChain.Text); //ChanNo //ParameterList.Add(Session["UID"].ToString()); //CreateID //ParameterList.Add(Session["UID"].ToString() + PageTimeStamp.Value); //V_TIMESTAMP //Dt = BCO.CreateBackWard(ParameterList, DBT, Dt_Adjust, out strInOut_No, out strMsg, out strResult, out strMainID, out strAdjustNo, out ErrList); CGRModel.MaintainBackWard BCO = new CGRModel.MaintainBackWard(ConntionDB); ParameterList2.Clear(); for (int i = 0; i < ParameterList.Count; i++) { if (i < ParameterList.Count - 1) { ParameterList2.Add(ParameterList[i]); } } string DetailSelectXML = ParameterList[ParameterList.Count - 1].ToString(); DataSet DetailDs = new DataSet(); if (DetailSelectXML != "") { #region 使用XML轉回DataSet System.IO.StringReader sr = new System.IO.StringReader(DetailSelectXML); DetailDs.ReadXml(sr); #endregion } DataTable Dt_Adjust = null; if (DetailDs.Tables.Count > 0) { Dt_Adjust = DetailDs.Tables[0]; } Dt = BCO.CreateBackWard(ParameterList2, null, Dt_Adjust, out strInOut_No, out strMsg, out strResult, out strMainID, out strAdjustNo, out ErrList ); //Dt.TableName = "ResultDt"; //Ds.Merge(Dt.DataSet); #region DtResult DrResult DrResult2 DataTable DtResult = new DataTable("ResultDt"); DtResult.Columns.Add("BACKWARD_NO"); if (Dt.Rows.Count > 0) { DataRow DrResult = DtResult.NewRow(); DrResult["BACKWARD_NO"] = Dt.Rows[0]["BACKWARD_NO"].ToString(); DtResult.Rows.Add(DrResult); DataRow DrResult2 = DtResult.NewRow(); DrResult2["BACKWARD_NO"] = Dt.Rows[Dt.Rows.Count-1]["BACKWARD_NO"].ToString(); DtResult.Rows.Add(DrResult2); } #endregion Ds.Tables.Add(DtResult); #region DtInOutNo strInOut_No DataTable DtInOutNo = new DataTable("InOutNoDt"); DtInOutNo.Columns.Add("strInOut_No"); DataRow DrInOutNo = DtInOutNo.NewRow(); DrInOutNo["strInOut_No"] = strInOut_No; DtInOutNo.Rows.Add(DrInOutNo); #endregion Ds.Tables.Add(DtInOutNo); #region DtStrMsg strMsg DataTable DtStrMsg = new DataTable("strMsg"); DtStrMsg.Columns.Add("strMsg"); DataRow DrStrMsg = DtStrMsg.NewRow(); DrStrMsg["strMsg"] = strMsg; DtStrMsg.Rows.Add(DrStrMsg); #endregion Ds.Tables.Add(DtStrMsg); #region DtStrResult strResult DataTable DtStrResult = new DataTable("strResult"); DtStrResult.Columns.Add("strResult"); DataRow DrStrResult = DtStrResult.NewRow(); DrStrResult["strResult"] = strResult; DtStrResult.Rows.Add(DrStrResult); #endregion Ds.Tables.Add(DtStrResult); #region DtStrMainID strMainID DataTable DtStrMainID = new DataTable("strMainID"); DtStrMainID.Columns.Add("strMainID"); DataRow DrStrMainID = DtStrMainID.NewRow(); DrStrMainID["strMainID"] = strMainID; DtStrMainID.Rows.Add(DrStrMainID); #endregion Ds.Tables.Add(DtStrMainID); #region DtStrAdjustNo strAdjustNo DataTable DtStrAdjustNo = new DataTable("strAdjustNo"); DtStrAdjustNo.Columns.Add("strAdjustNo"); DataRow DrStrAdjustNo = DtStrAdjustNo.NewRow(); DrStrAdjustNo["strAdjustNo"] = strAdjustNo; DtStrAdjustNo.Rows.Add(DrStrAdjustNo); #endregion Ds.Tables.Add(DtStrAdjustNo); #region DtErrList ErrList DataTable DtErrList = new DataTable("ErrList"); DtStrAdjustNo.Columns.Add("ErrList"); if (ErrList != null) { for (int j = 0; j < ErrList.Count; j++) { DataRow DrErrList = DtErrList.NewRow(); DrErrList["ErrList"] = ErrList[j].ToString(); DtErrList.Rows.Add(DrErrList); } } else { DataRow DrErrList = DtErrList.NewRow(); DrErrList["ErrList"] = " "; DtErrList.Rows.Add(DrErrList); } #endregion Ds.Tables.Add(DtErrList); Result = true; } catch (Exception ex) { throw ex; } return Result; }