public DataTable UriageMotochou_PrintSelect(UriageMotochou_Entity ume) { string rpc = "RPC_UriageMotochou_PrintSelect"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>() { { "@FromYYYYMM", new ValuePair { value1 = SqlDbType.Int, value2 = ume.YYYYMMFrom } }, { "@ToYYYYMM", new ValuePair { value1 = SqlDbType.Int, value2 = ume.YYYYMMTo } }, { "@FromDate", new ValuePair { value1 = SqlDbType.Date, value2 = ume.TargetDateFrom } }, { "@ToDate", new ValuePair { value1 = SqlDbType.Date, value2 = ume.TargetDateTo } }, { "@CustomerCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = ume.CustomerCD } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = ume.StoreCD } }, { "@chkValue", new ValuePair { value1 = SqlDbType.TinyInt, value2 = ume.ChkValue } } }; return(SelectData(dic, rpc)); }
public UriageMotouchou() { InitializeComponent(); ume = new UriageMotochou_Entity(); lle = new L_Log_Entity(); bbl = new Base_BL(); umbl = new UriageMotochou_BL(); dtReport = new DataTable(); dtCheck = new DataTable(); }
protected override void PrintSec() { if (ErrorCheck()) { if (PrintMode != EPrintMode.DIRECT) { return; } ume = GetDataInfo(); dtReport = umbl.UriageMotochou_PrintSelect(ume); if (dtReport.Rows.Count > 0) { string StoreCD = cboStore.SelectedValue.ToString(); string YYYYMM = txtTargetTo.Text.Replace("/", ""); if (umbl.CheckData(1, StoreCD, YYYYMM)) { //月次処理(債権集計処理)を起動 Exe Console Run string ProgramID = "GetsujiSaikenKeisanSyori"; OpenForm(ProgramID, txtTagetFrom.Text); //印刷処理 PrintDataSelect(); } else if (umbl.CheckData(2, StoreCD, YYYYMM)) { //印刷処理 PrintDataSelect(); } } else { umbl.ShowMessage("E128"); txtTagetFrom.Focus(); } } }
private UriageMotochou_Entity GetDataInfo() { string Todate = string.Empty; if (!string.IsNullOrWhiteSpace(txtTargetTo.Text)) { int year = Convert.ToInt32(txtTargetTo.Text.Substring(0, 4)); int month = Convert.ToInt32(txtTargetTo.Text.Substring(5, 2)); string lastday = "/" + DateTime.DaysInMonth(year, month).ToString(); Todate = txtTargetTo.Text + lastday; } ume = new UriageMotochou_Entity() { YYYYMMFrom = txtTagetFrom.Text.Replace("/", ""), YYYYMMTo = txtTargetTo.Text.Replace("/", ""), CustomerCD = sc_Customer.TxtCode.Text, StoreCD = cboStore.SelectedValue.ToString(), TargetDateFrom = txtTagetFrom.Text + "/01", TargetDateTo = Todate, ChkValue = CheckValue() }; return(ume); }
public DataTable UriageMotochou_PrintSelect(UriageMotochou_Entity ume) { return(dmcdl.UriageMotochou_PrintSelect(ume)); }