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