// 列印 protected void btnPrint_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; try { PURModel.MaintainPurchaseDeliveryGoods BCO = new PURModel.MaintainPurchaseDeliveryGoods(ConnectionDB); string vPICK_SELECT_1 = "0"; string vPICK_SELECT_2 = "0"; //固定傳 1 vPICK_SELECT_1 = "1"; vPICK_SELECT_2 = "1"; ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.txtPLAN_ACCEPT_DATE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(this.txtPICK_BATCH.Text, "string", false)); ParameterList.Add(GetValueSetParameter(vPICK_SELECT_1, "int", false)); ParameterList.Add(GetValueSetParameter(vPICK_SELECT_2, "int", false)); DataTable Dt_Print = BCO.QuerySwitch(PURModel.MaintainPurchaseDeliveryGoods.QueryType.QueryByPrint, ParameterList); if (Dt_Print.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "PUR041.aspx", "alert(' 查無資料 ');", true); return; } ShowReport(Dt_Print); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
// 品項載入(續2) private void Item_Load2() { string vPICK_SELECT_1 = "0"; string vPICK_SELECT_2 = "0"; if (this.chkPICK_SELECT_1.Checked == true) //正常品 vPICK_SELECT_1 = "1"; if (this.chkPICK_SELECT_2.Checked == true) //客服查補 vPICK_SELECT_2 = "1"; SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); string SessionIDName_Pick = "PUR041_Pick" + PageTimeStamp.Value; Session[SessionIDName_Pick] = null; //第一次查詢,為了餵給BCO.InsertMaster Dt資料 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text, "int", false)); ParameterList.Add(GetValueSetParameter(this.txtPLAN_ACCEPT_DATE.Text, "string", false)); ParameterList.Add(GetValueSetParameter(vPICK_SELECT_1, "int", false)); ParameterList.Add(GetValueSetParameter(vPICK_SELECT_2, "int", false)); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(DateTime.Now.ToString(), "datetime", false)); PURModel.MaintainPurchaseDeliveryGoods BCO = new PURModel.MaintainPurchaseDeliveryGoods(ConnectionDB); DataTable Dt = BCO.QuerySwitch(PURModel.MaintainPurchaseDeliveryGoods.QueryType.QueryByLOAD, ParameterList); string msg = "", msg1 = "", msg2 = ""; if (getDataType() == "1") { for (int i = 0; i < Dt.Rows.Count; i++) if (ChkDup(Dt.Rows[i]["ST_ACCEPT_DATE"].ToString(), Dt.Rows[i]["VIRTUAL_CODE"].ToString(), Dt.Rows[i]["PERIOD"].ToString(), "2")) { msg1 += "品號:" + Dt.Rows[i]["VIRTUAL_CODE"].ToString() + "、期別:" + Dt.Rows[i]["PERIOD"].ToString() + "<br \\>"; Dt.Rows.Remove(Dt.Rows[i]); } if (msg1 != "") msg1 += "已存在客服查補裏,故未載入<br \\>"; } else if (getDataType() == "2") { for (int i = 0; i < Dt.Rows.Count; i++) if (ChkDup(Dt.Rows[i]["ST_ACCEPT_DATE"].ToString(), Dt.Rows[i]["VIRTUAL_CODE"].ToString(), Dt.Rows[i]["PERIOD"].ToString(), "1")) { msg2 += "品號:" + Dt.Rows[i]["VIRTUAL_CODE"].ToString() + "、期別:" + Dt.Rows[i]["PERIOD"].ToString() + "<br \\>"; Dt.Rows.Remove(Dt.Rows[i]); } if (msg2 != "") msg2 += "已存在正常品裏,故未載入"; } msg = msg1 + msg2; if (msg != "") lblMsg.Text = msg; //2009/9/17 修改流程:「品項載入」後即可經由管制鈕的選擇而ENABLE「通路管制設定」鈕,所以要先Reset該DB的資料 //先全部刪除~再新增 ParameterList.Clear(); ParameterList.Add(this.txtPLAN_ACCEPT_DATE.Text); ParameterList.Add(this.txtPICK_BATCH.Text); ParameterList.Add(Session["UID"].ToString()); ParameterList.Add(getDataType()); // 2010/3/8 By Tony 新增資料來源條件:1:正常品 2:客服查補 3:正常品 + 客服查補 DateTime dNow = DateTime.Now; //DeleteAll、InsertMaster、QuerySwitch使用統一的時間 BCO.DeleteAll(ParameterList, null, dNow); BCO.InsertMaster(this.getMasterParameterList(), Dt, null, dNow); //第二次查詢,為了找出BCO.InsertMaster後的Update資訊 string v_PICK_CNT = "0"; string v_RESTRAIN_CNT = "0"; ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text, "int", false)); ParameterList.Add(txtPLAN_ACCEPT_DATE.Text); ParameterList.Add(txtPICK_BATCH.Text); ParameterList.Add(getDataType()); Dt = BCO.QueryPICK_CONTROL(ParameterList); GridView1.DataSource = Dt; Session[SessionIDName] = Dt; #region 將明細資料放至DetailDt中 detailTmpDt = Dt; #endregion //將空白的資料做處理 Dt = ProcessDBNull(Dt); #region 使用XML放置到前端資料 DataSet Ds = Dt.DataSet; DetailOLDData.InnerHtml = Ds.GetXml(); #endregion //設定分頁大小 GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { LabelQueryRecordCount.Text = ""; this.hid_PICK_CNT.Value = "0"; this.hid_RESTRAIN_CNT.Value = "0"; btnPrint.Visible = false; btnEdit.Visible = false; ErrorMsgLabel.Text = "查無資料"; btnDelItem.Visible = false; //btnImportOnDate.Visible = false; this.hid_PageStatus.Text = "VIEW"; } else { LabelQueryRecordCount.Text = "品項數:理貨品:" + Dt.Rows.Count + "筆 管制品:0筆"; this.hid_PICK_CNT.Value = Dt.Rows.Count.ToString(); this.hid_RESTRAIN_CNT.Value = "0"; btnPrint.Visible = true; btnEdit.Visible = true; this.hid_PageStatus.Text = "LOAD"; SetPageStatus(); LockControlChk();//對ControlChk鎖定編輯 btnDelItem.Visible = true; //btnImportOnDate.Visible = true; btnImportOnDate.Enabled = true; } #region ToolBar設定 if (detailTmpDt == null || (detailTmpDt != null && detailTmpDt.Rows.Count <= 0)) { GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.Other; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "PUR041.aspx?Code=PUR04", null, WUI_GMToolbarV.ClickAction.LinkURL); //GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.New, false, string.Empty, this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, false, string.Empty, this.btnSave, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, false, string.Empty, this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, false, string.Empty, this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); } else { GMToolbar1.GMToolbarStatus = WUI_GMToolbarV.GMToolbarStatusEnum.Other; GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "PUR041.aspx?Code=PUR04", null, WUI_GMToolbarV.ClickAction.LinkURL); // GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.New, false, string.Empty, this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, true, string.Empty, this.btnSave, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, false, string.Empty, this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, false, string.Empty, this.btnEdit, WUI_GMToolbarV.ClickAction.ButtonClick); } #endregion }
//指定日期匯入(續) private void LoadFromDate1(string importDate) { SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); string SessionIDName_Pick = "PUR041_Pick" + PageTimeStamp.Value; string vPICK_SELECT_1 = "0"; string vPICK_SELECT_2 = "0"; if (this.chkPICK_SELECT_1.Checked == true) //正常品 vPICK_SELECT_1 = "1"; if (this.chkPICK_SELECT_2.Checked == true) //客服查補 vPICK_SELECT_2 = "1"; DataTable dt_main_tmp = new DataTable(); //第一次查詢,為了餵給BCO.InsertMaster Dt資料 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(TextBoxRowCountLimit.Text, "int", false)); ParameterList.Add(GetValueSetParameter(importDate, "string", false)); ParameterList.Add(GetValueSetParameter("1", "int", false)); //只取得正常品的資料 ParameterList.Add(GetValueSetParameter("0", "int", false)); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string", false)); ParameterList.Add(GetValueSetParameter(DateTime.Now.ToString(), "datetime", false)); PURModel.MaintainPurchaseDeliveryGoods BCO = new PURModel.MaintainPurchaseDeliveryGoods(ConnectionDB); DataTable Dt = BCO.QuerySwitch(PURModel.MaintainPurchaseDeliveryGoods.QueryType.QueryByLOAD, ParameterList); if (Session[SessionIDName] != null && Session[SessionIDName] != "") dt_main_tmp = (DataTable)Session[SessionIDName]; Session["dt_main_tmp" + PageTimeStamp.Value] = dt_main_tmp;//為了給變更Lock使用者後,繼續執行程式用 int Dt_Count = Dt.Rows.Count; DataTable Dt_Copy = Dt.Copy(); //已存在的資料就不再寫入了 if (dt_main_tmp.Rows.Count > 0) for (int i = 0; i < Dt_Count; i++) //刪除虛擬品號、期別已存在於dt_main_tmp的資料 { Dt_Copy.Rows[i]["ST_ACCEPT_DATE"] = txtPLAN_ACCEPT_DATE.Text; DataRow[] drsTmp = dt_main_tmp.Select("VIRTUAL_CODE = '" + Dt_Copy.Rows[i]["VIRTUAL_CODE"].ToString() + "' and PERIOD = '" + Dt_Copy.Rows[i]["PERIOD"].ToString() + "'"); DataRow[] drsCop = Dt.Select("VIRTUAL_CODE = '" + Dt_Copy.Rows[i]["VIRTUAL_CODE"].ToString() + "' and PERIOD = '" + Dt_Copy.Rows[i]["PERIOD"].ToString() + "'"); if (drsTmp.Length > 0) Dt.Rows.Remove(drsCop[0]); } if (Dt.Rows.Count > 0) { Session["LoadFromDate1" + PageTimeStamp.Value] = Dt;//為了給變更Lock使用者後,繼續執行程式用 if (hid_PageStatus.Text == "VIEW") { DataTable dtLock = getControlChk(); if (dtLock.Rows.Count > 0) { ViewState["ControlChk"] = dtLock; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "if (confirm('該進貨日期、理貨批次目前仍由(" + dtLock.Rows[0]["UPDATEUID"].ToString() + ")於" + dtLock.Rows[0]["UPDATEDATE"].ToString() + "編輯中\\n\\n如繼續,將會重新鎖定該日期、批號\\n\\n於編輯期間由(" + dtLock.Rows[0]["UPDATEUID"].ToString() + ")編輯中的資料將無法存檔\\n\\n是否確定仍要繼續匯入品項?')){__doPostBack('','LoadFromDate2');}", true); return; } } LoadFromDate2(); } else ErrorMsgLabel.Text = "無資料可載入 !!"; }