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)
{
//Ｅ１８０
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)Ｅ１３３
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"));
}
