public ShiireShoukaiDetails()
{
InitializeComponent();
dpd_entity = new D_Purchase_Details_Entity();
ssdbl = new ShiireShoukaiDetails_BL();
bbl = new Base_BL();
}
private void F11()
{
if (ErrorCheck())
{
dpd_entity.ProgramID = "1";
dpd_entity = GetDPurchaseDetails();
DataTable dtResult = new DataTable();
dtResult = ssdbl.ShiireShoukaiDetails_Select(dpd_entity);
if (dtResult.Rows.Count > 0)
{
dgv_PurchaseDetails.DataSource = dtResult;
Btn_F10.Enabled = true;
//dgv_SizeColor.DataSource = dtResult;
//dgv_Store.DataSource = dtResult;
}
else
{
ssdbl.ShowMessage("E128");
dgv_PurchaseDetails.DataSource = null;
}
}
}
public DataTable ShiireShoukaiDetails_Select(D_Purchase_Details_Entity dpd_e)
{
string sp = "D_Purchase_SearchselectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.VendorCD
} },
{ "@JANCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.JanCD
} },
{ "@SKUCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.SKUCD
} },
{ "@ItemCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.ItemCD
} },
{ "@ItemName", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.ITemName
} },
{ "@MakerItemCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.MakerItemCD
} },
//{ "@MakerItemCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpd_e.MakerName } },
{ "@PurchaseSDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.Purchase_SDate
} },
{ "@PurchaseEDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.Purchase_EDate
} },
{ "@PlanSDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.Plan_SDate
} },
{ "@PlanEDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.Plan_EDate
} },
{ "@OrderSDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.Order_SDate
} },
{ "@OrderEDate", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.Order_EDate
} },
{ "@ChkValue", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dpd_e.CheckValue
} },
//{ "@ChkSumi", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpd_e.ChkSumi } },
// { "@ChkMi", new ValuePair { value1 = SqlDbType.VarChar, value2 = dpd_e.ChkMi } },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dpd_e.StaffCD
} },
};
//return SelectData(dic, "ShiireShoukaiDetails_SelectAll");
return(SelectData(dic, sp));
}
private D_Purchase_Details_Entity PurchaseDetailInfo()
{
int year = Convert.ToInt32(txtTargetDate.Text.Substring(0, 4));
int month = Convert.ToInt32(txtTargetDate.Text.Substring(5, 2));
string lastday = "/" + DateTime.DaysInMonth(year, month).ToString();
dpde = new D_Purchase_Details_Entity()
{
ChangeDate = txtTargetDate.Text + lastday,
ItemCD = scMakerShohinCD.Code,
SKUCD = scSKUCD.Code,
JanCD = scJANCD.Code,
MakerItemCD = scITEM.Code,
ITemName = txtSKUName.Text
};
return(dpde);
}
private D_Purchase_Details_Entity GetDPurchaseDetails()
{
dpd_entity = new D_Purchase_Details_Entity
{
VendorCD = scMakerCD.TxtCode.Text,
JanCD = scJanCD.TxtCode.Text,
SKUCD = scSkuCD.TxtCode.Text,
ItemCD = scItem.TxtCode.Text,
ITemName = txtItemName.Text,
MakerItemCD = txtMakerItemCD.Text,
//MakerName = txtMakerItemCD.Text,
Purchase_SDate = txtPurchaseDate1.Text,
Purchase_EDate = txtPurchaseDate2.Text,
Plan_SDate = txtPlanDate1.Text,
Plan_EDate = txtPlanDate2.Text,
Order_SDate = txtOrderDate1.Text,
Order_EDate = txtOrderDate2.Text,
CheckValue = CheckValue(),
//ChkSumi = chkOk.Checked ? "1" : "0",
//ChkMi = chkNotOK.Checked ? "1" : "0",
StaffCD = scStaffCD.TxtCode.Text,
};
return(dpd_entity);
}
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"));
}
public DataTable ShiireShoukaiDetails_Select(D_Purchase_Details_Entity dpde)
{
return(dpd_dl.ShiireShoukaiDetails_Select(dpde));
}
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();
}
}
}
