/// <summary>
/// 月次債権計算処理
/// GetsujiZaikoKeisanSyoriより更新時に使用
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public bool D_MonthlyStock_Exec(D_MonthlyStock_Entity de)
{
string sp = "PRC_GetsujiZaikoKeisanSyori";
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));
}
private D_MonthlyStock_Entity MonthlyStockInfo()
{
dmse = new D_MonthlyStock_Entity()
{
SoukoCD = cboSouko.SelectedValue.ToString(),
YYYYMM = txtTargetDate.Text.Replace("/", "")
};
return(dmse);
}
public void ExecUpdate(D_MonthlyStock_Entity de)
{
try {
sbl.GetsujiZaikoKeisanSyori(de);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
private D_MonthlyStock_Entity D_MonthlyStock_data()
{
int year = Convert.ToInt32(txtTargetPeriodT.Text.Substring(0, 4));
int month = Convert.ToInt32(txtTargetPeriodT.Text.Substring(5, 2));
string lastday = "/" + DateTime.DaysInMonth(year, month).ToString();
dms = new D_MonthlyStock_Entity()
{
YYYYMMFrom = txtTargetPeriodF.Text.Replace("/", ""),
YYYYMMTo = txtTargetPeriodT.Text.Replace("/", ""),
SoukoCD = cboSouko.SelectedValue.ToString(),
TargetDateFrom = txtTargetPeriodF.Text + "/01",
TargetDateTo = txtTargetPeriodT.Text + lastday
};
return(dms);
}
public DataTable ZaikoMotochoulnsatsu_Report(M_SKU_Entity mse, D_MonthlyStock_Entity dms, int chk)
{
string sp = "ZaikoMotochoulnsatsu_Report";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@YYYYMMFrom", new ValuePair {
value1 = SqlDbType.Int, value2 = dms.YYYYMMFrom
} },
{ "@YYYYMMTo", new ValuePair {
value1 = SqlDbType.Int, value2 = dms.YYYYMMTo
} },
{ "@SoukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dms.SoukoCD
} },
{ "@itemcd", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.ITemCD
} },
{ "@sku", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SKUCD
} },
{ "@jan", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.JanCD
} },
{ "@makeritem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.MakerItem
} },
{ "@skuName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = mse.SKUName
} },
{ "@related", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = chk.ToString()
} },
{ "@targetDateFrom", new ValuePair {
value1 = SqlDbType.Date, value2 = dms.TargetDateFrom
} },
{ "@targerDateTo", new ValuePair {
value1 = SqlDbType.Date, value2 = dms.TargetDateTo
} }
};
return(SelectData(dic, sp));
}
public DataTable RPC_ZaikoKanriHyou(D_Purchase_Details_Entity dpde, D_MonthlyStock_Entity dmse, int chk)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@targetdate", new ValuePair {
value1 = SqlDbType.Date, value2 = dpde.ChangeDate
} },
{ "@soukoCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dmse.SoukoCD
} },
{ "@YYYYMM", new ValuePair {
value1 = SqlDbType.Int, value2 = dmse.YYYYMM
} },
{ "@itemcd", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpde.ItemCD
} },
{ "@sku", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpde.SKUCD
} },
{ "@jan", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpde.JanCD
} },
{ "@makeritem", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpde.MakerItemCD
} },
{ "@itemName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpde.ITemName
} },
{ "@related", new ValuePair {
value1 = SqlDbType.VarChar, value2 = chk.ToString()
} }
};
UseTransaction = true;
return(SelectData(dic, "RPC_ZaikoKanriHyou"));
}
/// <summary>
/// Print Report on F12 Click
/// </summary>
protected override void PrintSec()
{
if (PrintMode != EPrintMode.DIRECT)
{
return;
}
if (ErrorCheck())
{
sku_data = M_SKU_data();
dms = D_MonthlyStock_data();
chk = Check_ITemORMakerItem();
dtReport = new DataTable();
dtReport = zmibl.ZaikoMotochoulnsatsu_Report(sku_data, dms, chk);
if (dtReport.Rows.Count > 0)
{
CheckBeforeExport();
try
{
ZaikoMotochoulnsatsu_Report zm_report = new ZaikoMotochoulnsatsu_Report();
DialogResult DResult;
switch (PrintMode)
{
case EPrintMode.DIRECT:
DResult = bbl.ShowMessage("Q201");
if (DResult == DialogResult.Cancel)
{
return;
}
// 印字データをセット
zm_report.SetDataSource(dtReport);
zm_report.Refresh();
zm_report.SetParameterValue("lblYearMonth", txtTargetPeriodF.Text + " ～ " + txtTargetPeriodT.Text);
zm_report.SetParameterValue("lblSouko", cboSouko.SelectedValue.ToString() + " " + cboSouko.Text);
zm_report.SetParameterValue("lblToday", DateTime.Now.ToString("yyyy/MM/dd") + " " + DateTime.Now.ToString("HH:mm"));
//zm_report.SetParameterValue("lblSKU", dtReport.Rows[0]["SKUCD"].ToString());
// zm_report.SetParameterValue("lblJANCD", dtReport.Rows[0]["JANCD"].ToString());
// zm_report.SetParameterValue("lblCSB", dtReport.Rows[0]["ColorName"].ToString() + " " + dtReport.Rows[0]["SizeName"].ToString() + " " + dtReport.Rows[0]["BrandName"].ToString());
vr.CrystalReportViewer1.ReportSource = zm_report;
//vr.ShowDialog();
try
{
// crv = vr.CrystalReportViewer1;
}
catch (Exception ex)
{
var msg = ex.Message;
}
//out log before print
if (DResult == DialogResult.Yes)
{
//印刷処理プレビュー
vr = new Viewer();
vr.CrystalReportViewer1.ShowPrintButton = true;
vr.CrystalReportViewer1.ReportSource = zm_report;
vr.ShowDialog();
}
else
{
//int marginLeft = 360;
CrystalDecisions.Shared.PageMargins margin = zm_report.PrintOptions.PageMargins;
margin.leftMargin = DefaultMargin.Left; // mmの指定をtwip単位に変換する
margin.topMargin = DefaultMargin.Top;
margin.bottomMargin = DefaultMargin.Bottom; //mmToTwip(marginLeft);
margin.rightMargin = DefaultMargin.Right;
zm_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();
zm_report.PrintOptions.PrinterName = "\\\\dataserver\\Canon LBP2900";
System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings);
zm_report.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
zm_report.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex;
zm_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;
}
//プログラム実行履歴
InsertLog(Get_L_Log_Entity());
}
finally
{
//画面はそのまま
txtTargetPeriodF.Focus();
}
}
else
{
bbl.ShowMessage("E128");
}
}
}
/// <summary>
/// 月次在庫計算処理
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public bool GetsujiZaikoKeisanSyori(D_MonthlyStock_Entity de)
{
D_MonthlyStock_DL dl = new D_MonthlyStock_DL();
return(dl.D_MonthlyStock_Exec(de));
}
public DataTable RPC_ZaikoKanriHyou(D_Purchase_Details_Entity dpde, D_MonthlyStock_Entity dmse, int chk)
{
return(zkhdl.RPC_ZaikoKanriHyou(dpde, dmse, chk));
}
protected override void PrintSec()
{
if (PrintMode != EPrintMode.DIRECT)
{
return;
}
if (ErrorCheck())
{
dpde = new D_Purchase_Details_Entity();
dmse = new D_MonthlyStock_Entity();
dpde = PurchaseDetailInfo();
dmse = MonthlyStockInfo();
if (chkRelatedPrinting.Checked == true)
{
if (rdoITEM.Checked == true)
{
chk = 1;
}
else if (rdoProductCD.Checked == true)
{
chk = 2;
}
}
else
{
chk = 3;
}
DataTable dt = zkhbl.RPC_ZaikoKanriHyou(dpde, dmse, chk);
if (dt.Rows.Count > 0)
{
// CheckBeforeExport();
try
{
ZaikoKanriHyou_Report zkh_Report = new ZaikoKanriHyou_Report();
DialogResult DResult;
switch (PrintMode)
{
case EPrintMode.DIRECT:
DResult = bbl.ShowMessage("Q201");
if (DResult == DialogResult.Cancel)
{
return;
}
zkh_Report.SetDataSource(dt);
zkh_Report.Refresh();
zkh_Report.SetParameterValue("lblDate", txtTargetDate.Text);
zkh_Report.SetParameterValue("lblSouko", cboSouko.SelectedValue.ToString() + " " + cboSouko.AccessibilityObject.Name);
zkh_Report.SetParameterValue("lblToday", dt.Rows[0]["Today"].ToString() + " " + dt.Rows[0]["Now"].ToString());
try
{
}
catch (Exception ex)
{
var msg = ex.Message;
}
//out log before print
if (DResult == DialogResult.Yes)
{
var vr = new Viewer();
vr.CrystalReportViewer1.ShowPrintButton = true;
vr.CrystalReportViewer1.ReportSource = zkh_Report;
vr.ShowDialog();
}
else
{
CrystalDecisions.Shared.PageMargins margin = zkh_Report.PrintOptions.PageMargins;
margin.leftMargin = DefaultMargin.Left;
margin.topMargin = DefaultMargin.Top;
margin.bottomMargin = DefaultMargin.Bottom;
margin.rightMargin = DefaultMargin.Right;
zkh_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();
zkh_Report.PrintOptions.PrinterName = "\\\\dataserver\\Canon LBP2900";
System.Drawing.Printing.PageSettings pSettings = new System.Drawing.Printing.PageSettings(printerSettings);
zkh_Report.PrintOptions.DissociatePageSizeAndPrinterPaperSize = true;
zkh_Report.PrintOptions.PrinterDuplex = PrinterDuplex.Simplex;
zkh_Report.PrintToPrinter(printerSettings, pSettings, false, PrintLayout);
}
catch (Exception ex)
{
}
}
break;
}
InsertLog(Get_L_Log_Entity());
}
finally
{
txtTargetDate.Focus();
}
}
else
{
zkhbl.ShowMessage("E128");
txtTargetDate.Focus();
}
}
}
public DataTable ZaikoMotochoulnsatsu_Report(M_SKU_Entity mse, D_MonthlyStock_Entity dms, int chk)
{
return(dwdl.ZaikoMotochoulnsatsu_Report(mse, dms, chk));
}
static void Main(string[] args)
{
Console.Title = "GetsujiZaikoKeisanSyori";
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_MonthlyStock_Entity de = new D_MonthlyStock_Entity
{
PC = Login_BL.GetHostName(),
Operator = InOperatorCD,
YYYYMM = InFiscalYYYYMM,
StoreCD = InStoreCD,
Mode = Mode
};
api.ExecUpdate(de);
}
}
}
