private D_PayPlan_Entity GetSearchInfo()
{
dppe = new D_PayPlan_Entity
{
PayeeCD = scPaymentDestinaion.TxtCode.Text,
PaymentDueDateFrom = txtPaymentDueDateFrom.Text,
PaymenetDueDateTo = txtPaymentDueDateTo.Text,
CloseStatusSumi = RdoCloseStsSumi.Checked ? "1" : "0",
PaymentStatusUnpaid = RdoUnpaid.Checked ? "1" : "0",
Purchase = chkPurchase.Checked ? "1" : "0",
Expense = chkExpense.Checked ? "1" : "0",
StoreCD = comboStore.SelectedValue.ToString()
};
return(dppe);
}
/// <summary>
/// 入金予定表データ取得処理
/// </summary>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private DataTable CheckData(int type)
{
DataTable dt = null;
if (ErrorCheck())
{
dppe = GetSearchInfo();
dt = shyhbl.D_PayPlan_SelectForPrint(dppe, type);
//以下の条件でデータが存在しなければエラー (Error if record does not exist)Ｅ１３３
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E128");
return(null);
}
}
return(dt);
}
public DataTable D_Pay_SelectForPayPlanDate1(D_PayPlan_Entity dppe)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PayeePlanDateFrom", new ValuePair {
value1 = SqlDbType.Date, value2 = dppe.PayPlanDateFrom
} },
{ "@PayeePlanDateTo", new ValuePair {
value1 = SqlDbType.Date, value2 = dppe.PayPlanDateTo
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dppe.Operator
} },
{ "@PayeeCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dppe.PayeeCD
} }
};
return(SelectData(dic, "D_Pay_SelectForPayPlanDate1"));
}
/// <summary>
/// 入金予定表よりデータ抽出時に使用
/// </summary>
/// <param name="dce"></param>
/// <returns></returns>
public DataTable D_PayPlan_SelectForPrint(D_PayPlan_Entity dppe, int type)
{
string sp = "D_PayPlan_SelectforPrint";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@PaymentDueDateFrom", new ValuePair {
value1 = SqlDbType.Date, value2 = dppe.PaymentDueDateFrom
} },
{ "@PaymentDueDateTo", new ValuePair {
value1 = SqlDbType.Date, value2 = dppe.PaymenetDueDateTo
} },
{ "@PaymentCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dppe.PayeeCD
} },
{ "@ClosedStatusSumi", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dppe.CloseStatusSumi
} },
{ "@PaymentStatusUnpaid", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dppe.PaymentStatusUnpaid
} },
{ "@Purchase", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dppe.Purchase
} },
{ "@Expense", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = dppe.Expense
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dppe.StoreCD
} },
{ "@Type", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = type.ToString()
} }
};
return(SelectData(dic, sp));
}
public DataTable D_Pay_SelectForPayPlanDate2(D_PayPlan_Entity dppe)
{
return(dppdl.D_Pay_SelectForPayPlanDate2(dppe));
}
public DataTable D_PayPlan_SelectForPrint(D_PayPlan_Entity dppe, int type)
{
return(dpp_dl.D_PayPlan_SelectForPrint(dppe, type));
}
public DataTable D_PayPlan_SelectDetail(D_PayPlan_Entity dppe)
{
return(dppdl.D_PayPlan_SelectDetail(dppe));
}
