public RODetailLedger(ConditionDetailLedger condition)
{
InitializeComponent();
startDate = condition.DateStart.Date;
List = manager.SelectDetailLedger(condition.DateStart, condition.DateEnd, condition.StartSubId, condition.EndSubId);
if (List == null || List.Count == 0)
{
throw new Exception("無數據");
//MessageBox.Show("無數據", "提示", MessageBoxButtons.OK);
//return;
}
this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
this.lbl_ReportDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.lbl_DataRange.Text += condition.DateStart.ToString("yyyy-MM-dd") + " ~ " + condition.DateEnd.ToString("yyyy-MM-dd");
this.lbl_SubRange.Text += condition.StartSubId + " ~ " + condition.EndSubId;
var group = List.GroupBy(D => D.Subject_Id).Select(S => S.Key).ToList <string>();
this.DataSource = group;
this.xrSubreport1.ReportSource = new RODetailLedger_Sub();
}
protected override void OnOK()
{
_condition = new ConditionDetailLedger();
if (this.date_Start.EditValue == null || this.date_End.EditValue == null)
{
throw new Exception("日期區間不完整！");
//MessageBox.Show("日期區間不完整！", this.Text, MessageBoxButtons.OK);
//return;
}
else
{
_condition.DateStart = this.date_Start.DateTime;
_condition.DateEnd = this.date_End.DateTime;
}
if (this.lue_StartSubject.EditValue == null || this.lue_EndSubject.EditValue == null)
{
throw new Exception("會計科目區間不完整！");
//MessageBox.Show("會計科目區間不完整", this.Text, MessageBoxButtons.OK);
//return;
}
else
{
_condition.StartSubId = lue_StartSubject.Text;
_condition.EndSubId = lue_EndSubject.Text;
}
}
public ROJournal(ConditionDetailLedger condition)
{
InitializeComponent();
BL.AtSummonDetailManager manager = new Book.BL.AtSummonDetailManager();
IList <Model.DetailLedger> list = manager.SelectJournal(condition.DateStart, condition.DateEnd, condition.StartId, condition.EndId, condition.Category);
if (list == null || list.Count == 0)
{
MessageBox.Show("無數據", "提示", MessageBoxButtons.OK);
return;
}
this.lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
this.lbl_ReportDate.Text += DateTime.Now.ToString("yyyy-MM-dd");
this.lbl_DataRange.Text += condition.DateStart.ToString("yyyy-MM-dd") + " ~ " + condition.DateEnd.ToString("yyyy-MM-dd");
this.lbl_IdRange.Text += condition.StartId + " ~ " + condition.EndId;
var group = list.GroupBy(D => new { D.SummonDate, D.Id });
//group = group.OrderBy(d => new { d.Key.SummonDate, d.Key.Id });
List <Model.DetailLedger> source = new List <Book.Model.DetailLedger>();
foreach (var item in group)
{
var sublist = item.ToList();
for (int i = 0; i < sublist.Count; i++)
{
if (i != 0)
{
sublist[i].SummonDate = null;
}
source.Add(sublist[i]);
}
}
xrSubreport1.ReportSource = new ROJournal_Sub(source);
//this.DataSource = source;
//this.TCDate.DataBindings.Add("Text", this.DataSource, "SummonDate", "{0:yyyy/MM/dd}");
//this.TCID.DataBindings.Add("Text", this.DataSource, "Id");
//this.TCCategory.DataBindings.Add("Text", this.DataSource, "SummonCategory");
//this.TCSubId.DataBindings.Add("Text", this.DataSource, "Subject_Id");
//this.TCSubName.DataBindings.Add("Text", this.DataSource, "SubjectName");
//this.TCSummary.DataBindings.Add("Text", this.DataSource, "Summary");
//this.TCJMoney.DataBindings.Add("Text", this.DataSource, "JMoney", "{0:0.00}");
//this.TCDMoney.DataBindings.Add("Text", this.DataSource, "DMoney", "{0:0.00}");
}
private void btn_Ok_Click(object sender, EventArgs e)
{
Condition = new ConditionDetailLedger();
if (this.date_Start.EditValue == null || this.date_End.EditValue == null)
{
//throw new Exception("日期區間不完整！");
MessageBox.Show("日期區間不完整！", this.Text, MessageBoxButtons.OK);
return;
}
else
{
Condition.DateStart = this.date_Start.DateTime;
Condition.DateEnd = this.date_End.DateTime;
}
Condition.StartId = txt_StartId.Text;
Condition.EndId = txt_EndId.Text;
Condition.Category = "'',";
if (checkEdit_Income.Checked)
{
Condition.Category += "'現金收入傳票',";
}
if (checkEdit_Pay.Checked)
{
Condition.Category += "'現金支出傳票',";
}
if (checkEdit_Trans.Checked)
{
Condition.Category += "'轉帳傳票',";
}
Condition.Category = Condition.Category.Trim(',');
ROJournal ro = new ROJournal(this.Condition);
ro.ShowPreviewDialog();
}
