/// <summary> /// PIU08_1報表(列印鈕) /// </summary> /// <param name="ParameterList">變數清單</param> /// <returns>回傳查詢結果</returns> public DataTable PUR09_1(ArrayList ParameterList) { #region PURModel.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB); DataTable Dt = BCO.QuerySwitch(PURModel.PUR09_BCO.QueryType.QueryByPrint,ParameterList); if (Dt.Rows.Count == 0) { throw new Exception("查無資料"); } else { return Dt; } #endregion }
// 品項載入(續) 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"; ViewState["DelDataType"] = "1"; } if (this.chkPICK_SELECT_2.Checked == true) //客服查補 { vPICK_SELECT_2 = "1"; ViewState["DelDataType"] = "2"; } if ((vPICK_SELECT_1 == "1") && (vPICK_SELECT_2 == "1")) ViewState["DelDataType"] = "3"; Session["PUR091_Pick" + PageTimeStamp.Value] = null; //第一次查詢,PKG_VDS_PUR_PUR09.LoadDeliveryGoods ParameterList.Clear(); 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.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB); DataTable Dt = BCO.QuerySwitch(PURModel.PUR09_BCO.QueryType.QueryByLOAD, ParameterList); string msg = ""; for (int i = 0; i < Dt.Rows.Count; i++) { string strCheckMsg = ChkDupData(Dt.Rows[i]["ST_ACCEPT_DATE"].ToString(), Dt.Rows[i]["VIRTUAL_CODE"].ToString(), Dt.Rows[i]["PERIOD"].ToString(), txtPICK_BATCH.Text.Trim(), ViewState["DelDataType"].ToString()); if (strCheckMsg != "") { msg += strCheckMsg; Dt.Rows[i].Delete(); } } Dt.AcceptChanges(); Session["PUR091_MST" + PageTimeStamp.Value] = Dt; if (msg != "") ErrorMsgLabel.Text = msg; if (Dt == null || Dt.Rows.Count == 0) { LabelQueryRecordCount.Text = ""; this.hid_PICK_CNT.Value = "0"; this.hid_RESTRAIN_CNT.Value = "0"; if (msg == "") ErrorMsgLabel.Text = "查無資料"; this.hid_PageStatus.Text = "EMPTY"; GridView1.DataSource = null; GridView1.DataBind(); SetToolBar(true, false, false, false, false); } else { LabelQueryRecordCount.Text = "品項數:理貨品:" + Dt.Rows.Count + "筆 管制品:0筆"; this.hid_PICK_CNT.Value = Dt.Rows.Count.ToString(); this.hid_RESTRAIN_CNT.Value = "0"; this.hid_PageStatus.Text = "EDIT"; GridView1.DataSource = Dt; GridView1.DataBind(); foreach (DataRow dr in Dt.Rows) { AddNewChannel(dr["VIRTUAL_CODE"].ToString(), dr["PERIOD"].ToString(), txtPLAN_ACCEPT_DATE.Text, txtPICK_BATCH.Text, "0", ""); } SetToolBar(true, false, true, false, false); } SetPageStatus(); }
// 列印 protected void btnPrint_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; try { PURModel.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB); 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.PUR09_BCO.QueryType.QueryByPrint, ParameterList); if (Dt_Print.Rows.Count == 0) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "PUR091.aspx", "alert(' 查無資料 ');", true); return; } ShowReport(Dt_Print); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } finally { } }
//指定日期匯入(續) private void LoadFromDate1(string importDate) { 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 dtMST = new DataTable(); //第一次查詢,為了餵給BCO.InsertMaster Dt資料 ParameterList.Clear(); 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.PUR09_BCO BCO = new PURModel.PUR09_BCO(ConntionDB); DataTable dtQuery = BCO.QuerySwitch(PURModel.PUR09_BCO.QueryType.QueryByLOAD, ParameterList);//PKG_VDS_PUR_PUR09.LoadDeliveryGoods if (Session["PUR091_MST" + PageTimeStamp.Value] != null && Session["PUR091_MST" + PageTimeStamp.Value] != "") dtMST = (DataTable)Session["PUR091_MST" + PageTimeStamp.Value]; string msg = ""; bool bDel = false; //已存在的資料就不再寫入了 for (int i = 0; i < dtQuery.Rows.Count; i++) { bDel = false; dtQuery.Rows[i]["ST_ACCEPT_DATE"] = txtPLAN_ACCEPT_DATE.Text; if (dtMST.Rows.Count > 0) { DataRow[] FindExists = dtMST.Select("VIRTUAL_CODE = '" + dtQuery.Rows[i]["VIRTUAL_CODE"].ToString() + "' and PERIOD = '" + dtQuery.Rows[i]["PERIOD"].ToString() + "'"); if (FindExists.Length > 0) { msg += "品號: " + dtQuery.Rows[i]["VIRTUAL_CODE"].ToString() + " 期別:" + dtQuery.Rows[i]["PERIOD"].ToString() + " 已存在門市進貨日:" + txtPLAN_ACCEPT_DATE.Text + " 同批次中 <br \\>"; dtQuery.Rows[i].Delete(); bDel = true; } } if (bDel == false) { string strCheckMsg = ChkDupData(txtPLAN_ACCEPT_DATE.Text, dtQuery.Rows[i]["VIRTUAL_CODE"].ToString(), dtQuery.Rows[i]["PERIOD"].ToString(), txtPICK_BATCH.Text.Trim(), ViewState["DelDataType"].ToString()); if (strCheckMsg != "") { msg += strCheckMsg; dtQuery.Rows[i].Delete(); } } } dtQuery.AcceptChanges(); if (msg != "") ErrorMsgLabel.Text = msg; if (dtQuery.Rows.Count > 0) { if (hid_PageStatus.Text == "EMPTY") hid_PageStatus.Text = "EDIT"; LoadFromDate2(dtQuery); } else { if (msg == "") ErrorMsgLabel.Text = "無資料可載入 !!"; } }