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)E133 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)); }