/// <summary> /// 月次仕入計算処理 /// GetsujiShiireKeisanSyoriより更新時に使用 /// </summary> /// <param name="de"></param> /// <returns></returns> public bool D_MonthlyPurchase_Exec(D_MonthlyPurchase_Entity de) { string sp = "PRC_GetsujiShiireKeisanSyori"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@FiscalYYYYMM", new ValuePair { value1 = SqlDbType.Int, value2 = de.YYYYMM } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.StoreCD } }, { "@Mode", new ValuePair { value1 = SqlDbType.TinyInt, value2 = de.Mode.ToString() } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.Operator } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.PC } }, }; UseTransaction = true; return(InsertUpdateDeleteData(dic, sp)); }
public SiiresakiZaikoYoteiHyou() { InitializeComponent(); szybl = new SiiresakiZaikoYoteiHyou_BL(); dmpe = new D_MonthlyPurchase_Entity(); dt = new DataTable(); }
private D_MonthlyPurchase_Entity GetData() { dmpe = new D_MonthlyPurchase_Entity() { StoreCD = cboStore.SelectedValue.ToString(), YYYYMMS = txtTargetDateFrom.Text.Replace("/", ""), YYYYMME = txtTargetDateTo.Text.Replace("/", "") }; return(dmpe); }
public void ExecUpdate(D_MonthlyPurchase_Entity de) { try { sbl.GetsujiShiireKeisanSyori(de); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); } }
private void F11() { if (ErrorCheck()) { dmpe = new D_MonthlyPurchase_Entity(); dmpe = GetData(); DataTable dt = szybl.RPC_SiiresakiZaikoYoteiHyou(dmpe); if (dt.Rows.Count > 0) { DataTable dtExport = dt; dtExport = ChangeDataColumnName(dtExport); string folderPath = "C:\\SES\\"; if (!Directory.Exists(folderPath)) { Directory.CreateDirectory(folderPath); } SaveFileDialog savedialog = new SaveFileDialog(); savedialog.Filter = "Excel Files|*.xlsx;"; savedialog.Title = "Save"; savedialog.FileName = "仕入先在庫予定表"; savedialog.InitialDirectory = folderPath; savedialog.RestoreDirectory = true; if (savedialog.ShowDialog() == DialogResult.OK) { if (Path.GetExtension(savedialog.FileName).Contains(".xlsx")) { Microsoft.Office.Interop.Excel._Application excel = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = excel.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel._Worksheet worksheet = null; worksheet = workbook.ActiveSheet; worksheet.Name = "worksheet"; using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dtExport, "worksheet"); wb.Worksheet("worksheet").Row(1).InsertRowsAbove(1); wb.Worksheet("worksheet").Row(1).InsertRowsAbove(1); wb.Worksheet("worksheet").Cell(1, 1).Value = "年月:"; wb.Worksheet("worksheet").Cell(2, 1).Value = "店舗:"; wb.Worksheet("worksheet").Cell(1, 2).Value = txtTargetDateFrom.Text; wb.Worksheet("worksheet").Cell(1, 3).Value = "~"; wb.Worksheet("worksheet").Cell(1, 4).Value = txtTargetDateTo.Text; wb.Worksheet("worksheet").Cell(2, 2).Value = cboStore.SelectedValue.ToString(); wb.Worksheet("worksheet").Cell(2, 3).Value = cboStore.Text.ToString(); wb.SaveAs(savedialog.FileName); szybl.ShowMessage("I203", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); } Process.Start(Path.GetDirectoryName(savedialog.FileName)); } } } } }
public DataTable RPC_SiiresakiZaikoYoteiHyou(D_MonthlyPurchase_Entity dmpe) { string sp = "RPC_SiiresakiZaikoYoteiHyou"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dmpe.StoreCD } }, { "@TargetSDate", new ValuePair { value1 = SqlDbType.Int, value2 = dmpe.YYYYMMS } }, { "@TargetEDate", new ValuePair { value1 = SqlDbType.Int, value2 = dmpe.YYYYMME } } }; return(SelectData(dic, sp)); }
/// <summary> /// 月次仕入計算処理 /// </summary> /// <param name="de"></param> /// <returns></returns> public bool GetsujiShiireKeisanSyori(D_MonthlyPurchase_Entity de) { D_MonthlyPurchase_DL dl = new D_MonthlyPurchase_DL(); return(dl.D_MonthlyPurchase_Exec(de)); }
protected override void PrintSec() { if (PrintMode != EPrintMode.DIRECT) { return; } if (ErrorCheck()) { dmpe = new D_MonthlyPurchase_Entity(); dmpe = GetData(); DataTable dt = szybl.RPC_SiiresakiZaikoYoteiHyou(dmpe); if (dt.Rows.Count > 0) { // CheckBeforeExport(); try { SiiresakiZaikoYoteiHyou_Report szy_Report = new SiiresakiZaikoYoteiHyou_Report(); DialogResult DResult; switch (PrintMode) { case EPrintMode.DIRECT: DResult = bbl.ShowMessage("Q201"); if (DResult == DialogResult.Cancel) { return; } szy_Report.SetDataSource(dt); szy_Report.Refresh(); szy_Report.SetParameterValue("lblDateFrom", txtTargetDateFrom.Text); szy_Report.SetParameterValue("lblDateTo", txtTargetDateTo.Text); szy_Report.SetParameterValue("lblStore", cboStore.SelectedValue.ToString() + " " + cboStore.AccessibilityObject.Name); szy_Report.SetParameterValue("lblToday", dt.Rows[0]["Today"].ToString()); try { } catch (Exception ex) { var msg = ex.Message; } if (DResult == DialogResult.Yes) { var vr = new Viewer(); vr.CrystalReportViewer1.ShowPrintButton = true; vr.CrystalReportViewer1.ReportSource = szy_Report; vr.ShowDialog(); } else { CrystalDecisions.Shared.PageMargins margin = szy_Report.PrintOptions.PageMargins; margin.leftMargin = DefaultMargin.Left; margin.topMargin = DefaultMargin.Top; margin.bottomMargin = DefaultMargin.Bottom; margin.rightMargin = DefaultMargin.Right; szy_Report.PrintOptions.ApplyPageMargins(margin); 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(); szy_Report.PrintOptions.PrinterName = "\\\\dataserver\\Canon LBP2900"; System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings); szy_Report.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true; szy_Report.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex; szy_Report.PrintToPrinter(printerSettings, pSettings, false, PrintLayout); } catch (Exception ex) { } } break; } InsertLog(Get_L_Log_Entity()); } finally { txtTargetDateTo.Focus(); } } else { szybl.ShowMessage("E128"); txtTargetDateTo.Focus(); } } }
static void Main(string[] args) { Console.Title = "GetsujiShiireSyuukeiSyori"; if (loginbl.ReadConfig() == true) { //コマンドライン引数を配列で取得する string[] cmds = System.Environment.GetCommandLineArgs(); if (cmds.Length - 1 >= (int)FrmMainForm.ECmdLine.PcID + 1) { InOperatorCD = cmds[(int)FrmMainForm.ECmdLine.OperatorCD]; InStoreCD = cmds[(int)FrmMainForm.ECmdLine.PcID + 1]; InProcessMode = cmds[(int)FrmMainForm.ECmdLine.PcID + 2]; InFiscalYYYYMM = cmds[(int)FrmMainForm.ECmdLine.PcID + 3].Replace("/", ""); } gsbl = new GetsujiShimeShori_BL(); //処理モードを覚える M_Control_Entity mce = new M_Control_Entity(); mce.MainKey = "1"; Mode = gsbl.GetMode(mce); bool execFlg = false; M_StoreClose_Entity me = new M_StoreClose_Entity(); if (Mode.Equals(1)) { //Mode = 1 の場合 (=ALL店舗) } else if (Mode.Equals(2)) { //Mode = 2 の場合 (=店舗ごとに計算) me.StoreCD = InStoreCD; } bool ret = gsbl.M_StoreClose_SelectAll(me); if (ret) { //FiscalYYYYMM<Parameter受取 FiscalYYYYMM //またはFiscalYYYYMM=Parameter受取 FiscalYYYYMM& ClosePosition5=0なら if (gsbl.Z_Set(me.FiscalYYYYMM) <= gsbl.Z_Set(InFiscalYYYYMM)) { if (gsbl.Z_Set(me.FiscalYYYYMM) == gsbl.Z_Set(InFiscalYYYYMM)) { if (me.ClosePosition5.Equals("0")) { execFlg = true; } } else { execFlg = true; } InFiscalYYYYMM = me.FiscalYYYYMM; } } if (execFlg) { //【データ更新】 D_MonthlyPurchase_Entity de = new D_MonthlyPurchase_Entity { PC = Login_BL.GetHostName(), Operator = InOperatorCD, YYYYMM = InFiscalYYYYMM, StoreCD = InStoreCD, Mode = Mode }; api.ExecUpdate(de); } } }
public DataTable RPC_SiiresakiZaikoYoteiHyou(D_MonthlyPurchase_Entity dmpe) { return(dmpdl.RPC_SiiresakiZaikoYoteiHyou(dmpe)); }