private D_Purchase_Entity GetEntity() { dpe = new D_Purchase_Entity { PurchaseDateFrom = detailControls[(int)EIndex.ArrivalPlanDateFrom].Text, PurchaseDateTo = detailControls[(int)EIndex.ArrivalPlanDateTo].Text, StoreCD = CboStoreCD.SelectedValue.ToString(), VendorCD = detailControls[(int)EIndex.OrderCD].Text, }; if (ChkMisyutsuryoku.Checked) { dpe.ChkMisyutsuryoku = 1; } else { dpe.ChkMisyutsuryoku = 0; } if (ChkSyutsuryokuZumi.Checked) { dpe.ChkSyutsuryokuZumi = 1; } else { dpe.ChkSyutsuryokuZumi = 0; } dpe.InsertOperator = InOperatorCD; dpe.PC = InPcID; return(dpe); }
/// <summary> /// 表示ボタンを押下時GridViewにデータを表示する処理 /// </summary> private void F11() { dgvPurchaseSearch.DataSource = null; if (ErrorCheck()) { if (!string.IsNullOrWhiteSpace(scSupplier.TxtCode.Text)) { M_Vendor_Entity mve = new M_Vendor_Entity() { VendorCD = scSupplier.TxtCode.Text, ChangeDate = scSupplier.ChangeDate.ToString() }; string aa = scSupplier.TxtCode.Text; payeeflg = dpurchase_bl.SelectPayeeFlg(mve); } dpde = GetSearchInfo(); DataTable dtPurchase = dpurchase_bl.D_Purchase_Search(dpde); if (dtPurchase.Rows.Count > 0) { dgvPurchaseSearch.Refresh(); dgvPurchaseSearch.DataSource = dtPurchase; dgvPurchaseSearch.Enabled = true; dgvPurchaseSearch.Focus(); Btn_F10.Enabled = true; } else { dpurchase_bl.ShowMessage("E128"); dgvPurchaseSearch.DataSource = null; } } }
/// <summary> /// 仕入単価訂正依頼書印刷よりデータ取得 /// </summary> /// <param name="dpe"></param> /// <returns></returns> public DataTable D_Purchase_SelectForPrint(D_Purchase_Entity doe) { string sp = "D_Purchase_SelectForPrint"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@PurchaseDateFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = doe.PurchaseDateFrom } }, { "@PurchaseDateTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = doe.PurchaseDateTo } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = doe.StoreCD } }, { "@VendorCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = doe.VendorCD } }, { "@Flg1", new ValuePair { value1 = SqlDbType.TinyInt, value2 = doe.ChkMisyutsuryoku.ToString() } }, { "@Flg2", new ValuePair { value1 = SqlDbType.TinyInt, value2 = doe.ChkSyutsuryokuZumi.ToString() } }, }; return(SelectData(dic, sp)); }
/// <summary> /// 既に出荷済みチェック /// </summary> /// <returns></returns> public DataTable CheckShippingData(D_Purchase_Entity dpe) { string sp = "CheckShippingData"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@PurchaseNO", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.PurchaseNO } }, }; return(SelectData(dic, sp)); }
/// <summary> /// 進捗チェック /// 既に出荷済み /// </summary> /// <param name="errno"></param> /// <returns></returns> public bool CheckShippingData(D_Purchase_Entity dpe, out string errno) { DataTable dt = ddl.CheckShippingData(dpe); bool ret = false; errno = ""; if (dt.Rows.Count > 0) { errno = dt.Rows[0]["errno"].ToString(); } return(ret); }
/// <summary> /// 仕入入力データ取得処理(発注・入荷なし) /// HacchuuNyuuryokuよりデータ抽出時に使用 /// </summary> public DataTable D_Purchase_SelectData(D_Purchase_Entity de, short operationMode) { string sp = "D_Purchase_SelectData"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@OperateMode", new ValuePair { value1 = SqlDbType.TinyInt, value2 = operationMode.ToString() } }, { "@PurchaseNO", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.PurchaseNO } }, }; return(SelectData(dic, sp)); }
/// <summary> /// 返品入力データ取得処理 /// HenpinNyuuryokuよりデータ抽出時に使用 /// </summary> /// <param name="de"></param> /// <param name="operationMode"></param> /// <returns></returns> public DataTable D_Purchase_SelectDataH(D_Purchase_Entity de, short operationMode) { string sp = "D_Purchase_SelectDataH"; //command.Parameters.Add("@SyoKBN", SqlDbType.TinyInt).Value = mie.SyoKBN; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@OperateMode", new ValuePair { value1 = SqlDbType.TinyInt, value2 = operationMode.ToString() } }, { "@PurchaseNO", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.PurchaseNO } }, }; return(SelectData(dic, sp)); }
/// <summary> /// 返品入力更新処理 /// HenpinNyuuryokuより更新時に使用 /// </summary> /// <param name="dpe"></param> /// <param name="operationMode"></param> /// <returns></returns> public bool D_Purchase_ExecH(D_Purchase_Entity dpe, DataTable dt, short operationMode) { string sp = "PRC_HenpinNyuuryoku"; command = new SqlCommand(sp, GetConnection()); command.CommandType = CommandType.StoredProcedure; command.CommandTimeout = 0; AddParam(command, "@OperateMode", SqlDbType.Int, operationMode.ToString()); AddParam(command, "@PurchaseNO", SqlDbType.VarChar, dpe.PurchaseNO); AddParam(command, "@StoreCD", SqlDbType.VarChar, dpe.StoreCD); AddParam(command, "@PurchaseDate", SqlDbType.VarChar, dpe.PurchaseDate); AddParam(command, "@PaymentPlanDate", SqlDbType.VarChar, dpe.PaymentPlanDate); AddParam(command, "@StaffCD", SqlDbType.VarChar, dpe.StaffCD); AddParam(command, "@CalledVendorCD", SqlDbType.VarChar, dpe.CalledVendorCD); AddParam(command, "@PayeeCD", SqlDbType.VarChar, dpe.PayeeCD); AddParam(command, "@CalculationGaku", SqlDbType.Money, dpe.CalculationGaku); AddParam(command, "@AdjustmentGaku", SqlDbType.Money, dpe.AdjustmentGaku); AddParam(command, "@PurchaseGaku", SqlDbType.Money, dpe.PurchaseGaku); AddParam(command, "@PurchaseTax", SqlDbType.Money, dpe.PurchaseTax); AddParam(command, "@CommentInStore", SqlDbType.VarChar, dpe.CommentInStore); AddParam(command, "@ExpectedDateFrom", SqlDbType.VarChar, dpe.ExpectedDateFrom); AddParam(command, "@ExpectedDateTo", SqlDbType.VarChar, dpe.ExpectedDateTo); AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt); AddParam(command, "@Operator", SqlDbType.VarChar, dpe.InsertOperator); AddParam(command, "@PC", SqlDbType.VarChar, dpe.PC); //OUTパラメータの追加 string outPutParam = "@OutPurchaseNO"; command.Parameters.Add(outPutParam, SqlDbType.VarChar, 11); command.Parameters[outPutParam].Direction = ParameterDirection.Output; UseTransaction = true; bool ret = InsertUpdateDeleteData(sp, ref outPutParam); if (ret) { dpe.PurchaseNO = outPutParam; } return(ret); }
public DataTable D_Purchase_Search(D_Purchase_Entity dp_e) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@VendorCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.VendorCD } }, { "@DeliveryNo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.DeliveryNo } }, { "@ArrivalDateFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.ArrivalDateFrom } }, { "@ArrivalDateTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.ArrivalDateTo } }, { "@PurchaseDateFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.PurchaseDateFrom } }, { "@PurchaseDateTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.PurchaseDateTo } }, { "@PaymentDueDateFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.PaymentDueDateFrom } }, { "@PaymentDueDateTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.PaymentDueDateTo } }, { "@ChkValue", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.CheckValue } }, //{ "@Paid", new ValuePair { value1 = SqlDbType.TinyInt, value2 = dp_e.Paid } }, //{ "@Unpaid", new ValuePair { value1 = SqlDbType.TinyInt, value2 = dp_e.UnPaid } }, { "@StaffCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dp_e.StaffCD } }, { "@PayeeFLg", new ValuePair { value1 = SqlDbType.TinyInt, value2 = dp_e.PayeeFLg } }, }; return(SelectData(dic, "D_Purchase_Select")); }
protected override void ExecDisp() { bool exists = false; for (int i = 0; i < detailControls.Length; i++) { if (i != (int)EIndex.StoreCD && !string.IsNullOrWhiteSpace(detailControls[i].Text)) { exists = true; } if (CheckDetail(i) == false) { detailControls[i].Focus(); return; } } if (!exists) { snbl.ShowMessage("E111"); detailControls[0].Focus(); return; } dpe = GetSearchInfo(); DataTable dt = snbl.D_Purchase_SelectAll(dpe, mse); GvDetail.DataSource = dt; if (dt.Rows.Count > 0) { GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect; GvDetail.CurrentRow.Selected = true; GvDetail.Enabled = true; GvDetail.Focus(); } else { snbl.ShowMessage("E128"); } }
/// <summary> /// Display event /// </summary> /// <param name="type"></param> /// private void F11() { if (ErrorCheck()) { dape = new D_ArrivalPlan_Entity { SoukoCD = cboWarehouse.SelectedValue.ToString(), CalcuArrivalPlanDate1 = txtStockDate1.Text, CalcuArrivalPlanDate2 = txtStockDate2.Text, //FrmSoukoCD = cboSourceWH.SelectedValue.ToString(), ITEMCD = ScItem.TxtCode.Text, JanCD = ScJanCD.TxtCode.Text, SKUCD = ScSKUCD.TxtCode.Text, statusFlg = CheckValue1(), DisplayFlg = CheckValue2(), }; if (cboSourceWH.SelectedValue.ToString() == "-1") { dape.FrmSoukoCD = string.Empty; } dae = new D_Arrival_Entity { ArrivalDate1 = txtArrivalDay1.Text, ArrivalDate2 = txtArrivalDay2.Text, PurchaseSu = "0", VendorDeliveryNo = txtDeliveryNote.Text, }; dpe = new D_Purchase_Entity { PurchaseDateFrom = txtPurchaseDate1.Text, PurchaseDateTo = txtPurchaseDate2.Text, VendorCD = ScSupplier.TxtCode.Text, }; dtSearch = nkskbl.D_ArrivalPlan_Select(dape, dae, dpe); dgvNyuukaShoukai.DataSource = dtSearch; } }
/// <summary> /// 仕入単価訂正依頼書印刷時のフラグ更新処理 /// フラグ更新時に使用 /// </summary> /// <param name="dme"></param> /// <param name="dt"></param> /// <param name="operatorNm"></param> /// <param name="pc"></param> /// <returns></returns> public bool D_Purchase_Update(D_Purchase_Entity dme, DataTable dt) { string sp = "D_Purchase_Update"; command = new SqlCommand(sp, GetConnection()); command.CommandType = CommandType.StoredProcedure; command.CommandTimeout = 0; AddParamForDataTable(command, "@Table", SqlDbType.Structured, dt); AddParam(command, "@Operator", SqlDbType.VarChar, dme.InsertOperator); AddParam(command, "@PC", SqlDbType.VarChar, dme.PC); UseTransaction = true; string outPutParam = ""; //未使用 bool ret = InsertUpdateDeleteData(sp, ref outPutParam); return(ret); }
/// <summary> /// エラーチェック処理 /// </summary> private D_Purchase_Entity GetSearchInfo() { dpde = new D_Purchase_Entity { VendorCD = scSupplier.TxtCode.Text, StaffCD = scStaff.TxtCode.Text, ArrivalDateFrom = txtArrivalDateFrom.Text, ArrivalDateTo = txtArrivalDateTo.Text, PurchaseDateFrom = txtPurchaseDateFrom.Text, PurchaseDateTo = txtPurchaseDateTo.Text, PaymentDueDateFrom = txtPaymentDueDateFrom.Text, PaymentDueDateTo = txtPaymentDueDateTo.Text, DeliveryNo = txtDeliveryNoteNo.Text, PayeeFLg = payeeflg, CheckValue = CheckValue() //Paid = paid, //UnPaid=unpaid, }; return(dpde); }
public DataTable D_Order_Select(D_Order_Entity doe, D_Purchase_Entity dpe) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = doe.DestinationSoukoCD } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = doe.StoreCD } }, { "@TargetDateFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.PurchaseDateFrom } }, { "@TargetDateTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.PurchaseDateTo } }, }; UseTransaction = true; return(SelectData(dic, "D_Order_SelectForReport")); }
public DataTable D_Purchase_SelectAll(D_Purchase_Entity dpe, M_SKU_Entity mse) { string sp = "D_Purchase_SelectAll"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@PurchaseDateFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.PurchaseDateFrom } }, { "@PurchaseDateTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.PurchaseDateTo } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.StoreCD } }, { "@StaffCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.StaffCD } }, { "@VendorCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.VendorCD } }, { "@SKUName", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SKUName } }, { "@ITemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ITemCD } }, { "@SKUCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SKUCD } }, { "@JanCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.JanCD } }, { "@MakerItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.MakerItem } }, }; return(SelectData(dic, sp)); }
private D_Purchase_Entity GetSearchInfo() { dpe = new D_Purchase_Entity { PurchaseDateFrom = detailControls[(int)EIndex.DayStart].Text, PurchaseDateTo = detailControls[(int)EIndex.DayEnd].Text, VendorCD = ScCustomer.TxtCode.Text, StaffCD = ScStaff.TxtCode.Text, StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(), }; mse = new M_SKU_Entity { SKUName = detailControls[(int)EIndex.SKUName].Text, ITemCD = detailControls[(int)EIndex.ITemCD].Text, //カンマ区切り SKUCD = detailControls[(int)EIndex.SKUCD].Text, //カンマ区切り JanCD = detailControls[(int)EIndex.JanCD].Text, //カンマ区切り MakerItem = detailControls[(int)EIndex.MakerItem].Text, //カンマ区切り }; return(dpe); }
/// <summary> /// 仕入単価訂正依頼書印刷よりデータ取得 /// </summary> /// <param name="dpe"></param> /// <returns></returns> public DataTable D_Purchase_SelectForPrint(D_Purchase_Entity dpe) { return(ddl.D_Purchase_SelectForPrint(dpe)); }
/// <summary> /// 仕入単価訂正依頼書印刷時のフラグ更新処理 /// フラグ更新時に使用 /// </summary> public bool D_Purchase_Update(D_Purchase_Entity dme, DataTable dt) { return(ddl.D_Purchase_Update(dme, dt)); }
public DataTable D_ArrivalPlan_Select(D_ArrivalPlan_Entity dape, D_Arrival_Entity dae, D_Purchase_Entity dpe) { return(dapdl.D_ArrivalPlan_Select(dape, dae, dpe)); }
public DataTable D_Purchase_Search(D_Purchase_Entity dpure) { return(dpur_dl.D_Purchase_Search(dpure)); }
/// <summary> /// 仕入入力取得処理(発注・入荷なし) /// ShiireNyuuryokuよりデータ抽出時に使用 /// </summary> public DataTable D_Purchase_SelectData(D_Purchase_Entity de, short operationMode) { DataTable dt = ddl.D_Purchase_SelectData(de, operationMode); return(dt); }
/// <summary> /// 仕入入力更新処理 /// ShiireNyuuryokuより更新時に使用 /// </summary> public bool Purchase_Exec(D_Purchase_Entity dme, DataTable dt, short operationMode) { return(ddl.D_Purchase_Exec(dme, dt, operationMode)); }
public DataTable D_Order_Select(D_Order_Entity doe, D_Purchase_Entity dpe) { return(dodl.D_Order_Select(doe, dpe)); }
/// <summary> /// 仕入データ取得処理 /// </summary> /// <param name="set">画面展開なしの場合:falesに設定する</param> /// <returns></returns> private DataTable CheckData(out DataTable dtForUpdate) { dtForUpdate = null; for (int i = 0; i < detailControls.Length; i++) { if (CheckDetail(i, false) == false) { detailControls[i].Focus(); return(null); } } //どれかのチェックがあること if (!ChkMisyutsuryoku.Checked && !ChkSyutsuryokuZumi.Checked) { //E180 bbl.ShowMessage("E111"); ChkMisyutsuryoku.Focus(); return(null); } //[D_Purchase_SelectForPrint] dpe = GetEntity(); DataTable dt = stbl.D_Purchase_SelectForPrint(dpe); //以下の条件でデータが存在しなければエラー (Error if record does not exist)E133 if (dt.Rows.Count == 0) { //bbl.ShowMessage("E133"); //previousCtrl.Focus(); stbl.ShowMessage("E128"); ckM_TextBox1.Focus(); return(null); } else { //明細にデータをセット int i = 0; dtForUpdate = new DataTable(); dtForUpdate.Columns.Add("no", Type.GetType("System.String")); foreach (DataRow row in dt.Rows) { if (row["DisplayRows"].ToString() == "1") { bool ret = SelectAndInsertExclusive(row["PurchaseNO"].ToString()); if (!ret) { return(null); } i++; // データを追加 DataRow rowForUpdate; rowForUpdate = dtForUpdate.NewRow(); rowForUpdate["no"] = row["PurchaseNO"].ToString(); dtForUpdate.Rows.Add(rowForUpdate); } } } return(dt); }
/// <summary> /// 仕入番号検索にて使用 /// </summary> /// <param name="de"></param> /// <returns></returns> public DataTable D_Purchase_SelectAll(D_Purchase_Entity de, M_SKU_Entity mse) { return(ddl.D_Purchase_SelectAll(de, mse)); }
public void F12() { if (ErrorCheck()) { doe = new D_Order_Entity { StoreCD = cboStore.SelectedValue.ToString(), DestinationSoukoCD = cboWareHouse.SelectedValue.ToString(), }; DateTime firstday = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); firstday.AddDays(-1).ToString("dd/MM/yyyy"); string Text = txtTargetDateTo.Text; if (!string.IsNullOrWhiteSpace(Text)) { string[] p = Text.Split('/'); string y = p[0].ToString(); string m = p[1].ToString(); int yy = Convert.ToInt32(y); int mm = Convert.ToInt32(m); DateTime lastday = new DateTime(yy, mm, DateTime.DaysInMonth(yy, mm)); dpe = new D_Purchase_Entity { PurchaseDateFrom = firstday.ToShortDateString(), PurchaseDateTo = lastday.ToShortDateString(), }; } else { dpe = new D_Purchase_Entity { PurchaseDateFrom = firstday.ToShortDateString(), PurchaseDateTo = null, }; } DataTable dt = zkybl.D_Order_Select(doe, dpe); //if (dt == null) if (dt.Rows.Count == 0) { //if (dt == null) return; zkybl.ShowMessage("E128"); txtTargetDateTo.Focus(); } else { dt.Columns.Add("Total"); dt.Rows[0]["Total"] = dt.Rows[0]["Gaku"].ToString(); decimal t = Convert.ToDecimal(dt.Rows[1]["Gaku"]) + Convert.ToDecimal(dt.Rows[0]["Total"]); dt.Rows[1]["Total"] = t.ToString(); for (int i = 2; i < dt.Rows.Count; i++) { dt.Rows[i]["Total"] = Convert.ToDecimal(dt.Rows[i]["Gaku"]) + Convert.ToDecimal(dt.Rows[i - 1]["Total"]); } try { ZaikoYoteiHyouReport Report = new ZaikoYoteiHyouReport(); DialogResult ret; switch (PrintMode) { case EPrintMode.DIRECT: ret = bbl.ShowMessage("Q202"); if (ret == DialogResult.Cancel) { return; } // 印字データをセット Report.SetDataSource(dt); Report.Refresh(); Report.SetParameterValue("PrintDate", System.DateTime.Now.ToString("yyyy/MM/dd") + " " + System.DateTime.Now.ToString("hh:mm")); Report.SetParameterValue("TargetDate", txtTargetDateFrom.Text + " ~ " + txtTargetDateTo.Text); Report.SetParameterValue("txtSouko", cboWareHouse.SelectedValue.ToString() + " " + cboWareHouse.Text); if (ret == DialogResult.Yes) { var previewForm = new Viewer(); previewForm.CrystalReportViewer1.ShowPrintButton = true; previewForm.CrystalReportViewer1.ReportSource = Report; previewForm.ShowDialog(); } else { //int marginLeft = 360; CrystalDecisions.Shared.PageMargins margin = Report.PrintOptions.PageMargins; margin.leftMargin = DefaultMargin.Left; // mmの指定をtwip単位に変換する margin.topMargin = DefaultMargin.Top; margin.bottomMargin = DefaultMargin.Bottom; //mmToTwip(marginLeft); margin.rightMargin = DefaultMargin.Right; Report.PrintOptions.ApplyPageMargins(margin); /// Error Now // プリンタに印刷 System.Drawing.Printing.PageSettings ps; try { System.Drawing.Printing.PrintDocument pDoc = new System.Drawing.Printing.PrintDocument(); CrystalDecisions.Shared.PrintLayoutSettings PrintLayout = new CrystalDecisions.Shared.PrintLayoutSettings(); System.Drawing.Printing.PrinterSettings printerSettings = new System.Drawing.Printing.PrinterSettings(); Report.PrintOptions.PrinterName = "\\\\dataserver\\Canon LBP2900"; System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings); Report.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true; Report.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex; Report.PrintToPrinter(printerSettings, pSettings, false, PrintLayout); // Print the report. Set the startPageN and endPageN // parameters to 0 to print all pages. //Report.PrintToPrinter(1, false, 0, 0); } catch (Exception ex) { } } break; } } finally { txtTargetDateTo.Focus(); } } } }
public DataTable D_ArrivalPlan_Select(D_ArrivalPlan_Entity dape, D_Arrival_Entity dae, D_Purchase_Entity dpe) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dape.SoukoCD } }, { "@CalcuArrivalPlanDate1", new ValuePair { value1 = SqlDbType.Date, value2 = dape.CalcuArrivalPlanDate1 } }, { "@CalcuArrivalPlanDate2", new ValuePair { value1 = SqlDbType.Date, value2 = dape.CalcuArrivalPlanDate2 } }, { "@FrmSoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dape.FrmSoukoCD } }, { "@ITEMCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dape.ITEMCD } }, { "@JanCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dape.JanCD } }, { "@SKUCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dape.SKUCD } }, { "@ArrivalDate1", new ValuePair { value1 = SqlDbType.Date, value2 = dae.ArrivalDate1 } }, { "@ArrivalDate2", new ValuePair { value1 = SqlDbType.Date, value2 = dae.ArrivalDate2 } }, { "@PurchaseSu", new ValuePair { value1 = SqlDbType.Int, value2 = dae.PurchaseSu } }, { "@VendorDeliveryNo", new ValuePair { value1 = SqlDbType.VarChar, value2 = dae.VendorDeliveryNo } }, { "@PurchaseDateFrom", new ValuePair { value1 = SqlDbType.Date, value2 = dpe.PurchaseDateFrom } }, { "@PurchaseDateTo", new ValuePair { value1 = SqlDbType.Date, value2 = dpe.PurchaseDateTo } }, { "@VendorCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpe.VendorCD } }, { "@StatusFlg", new ValuePair { value1 = SqlDbType.TinyInt, value2 = dape.statusFlg } }, { "@DisplayFlg", new ValuePair { value1 = SqlDbType.TinyInt, value2 = dape.DisplayFlg } }, }; UseTransaction = true; return(SelectData(dic, "D_ArrivalPlan_Select")); }