private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
Model.AtSummonDetail _detail = this.gridView1.GetRow(e.RowHandle) as Model.AtSummonDetail;
IList <Model.AtSummonDetail> _detailList = this.bindingSource1.DataSource as IList <Model.AtSummonDetail>;
if (e.Column == this.colJinE || e.Column == this.colJieorDai)
{
this.spinEditTotalDebits.EditValue = _detailList.Where(d => d.Lending == "借").ToList().Sum(d => d.AMoney);
this.spinEditCreditTotal.EditValue = _detailList.Where(d => d.Lending == "貸").ToList().Sum(d => d.AMoney);
}
else if (e.Column == this.colKemuBianHao || e.Column == this.colKeMuMingCheng)
{
if (!string.IsNullOrEmpty(_detail.SubjectId)) //&& string.IsNullOrEmpty(_detail.Summary)
{
var subject = new BL.AtAccountSubjectManager().Get(_detail.SubjectId);
if (subject != null && !string.IsNullOrEmpty(subject.CommonSummary))
{
_detail.Summary = subject.CommonSummary;
}
}
}
//this.bindingSource1.Position = this.bindingSource1.IndexOf(_detail);
this.gridControl1.RefreshDataSource();
}
public XRPeriodTryTo(ConditionPeriodTryTo condition)
{
InitializeComponent();
decimal?bb = 0;
decimal?cc = 0;
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelDataName.Text = "期試算表";
IList <Model.AtSummonDetail> list = detailManager.Select(condition.StartDate, condition.EndDate, null, null);
this.xrLabel1.Text = "列表日期：" + DateTime.Now.ToShortDateString();
this.xrLabel2.Text = "日期區間：" + condition.StartDate.ToShortDateString() + "至" + condition.EndDate.ToShortDateString();
if (list != null)
{
foreach (Model.AtSummonDetail at in list)
{
at.J = new BL.AtSummonDetailManager().CountSummonTo("借", at.SubjectId);
at.K = new BL.AtSummonDetailManager().CountSummonTo("貸", at.SubjectId);
Model.AtAccountSubject atSub = new BL.AtAccountSubjectManager().Get(at.SubjectId);
if (atSub != null)
{
at.B = atSub.SubjectName;
at.A = atSub.Id;
}
at.E = at.DebitMoney;
at.F = at.CreditMoney;
at.G = at.E - at.F;
bb += at.E;
cc += at.F;
oList.Add(at);
}
}
this.DataSource = oList;
this.xrLabel3.Text = bb.ToString();
this.xrLabel4.Text = cc.ToString();
this.xrTableCell8.DataBindings.Add("Text", this.DataSource, "A");
this.xrTableCell9.DataBindings.Add("Text", this.DataSource, "B");
this.xrTableCell10.DataBindings.Add("Text", this.DataSource, "E", "{0:0}");
this.xrTableCell11.DataBindings.Add("Text", this.DataSource, "F", "{0:0}");
this.xrTableCell12.DataBindings.Add("Text", this.DataSource, "G", "{0:0}");
this.xrTableCell13.DataBindings.Add("Text", this.DataSource, "J");
this.xrTableCell14.DataBindings.Add("Text", this.DataSource, "K");
}
public XRTayTo(ConditionTryTo condition)
{
InitializeComponent();
decimal?bb = 0;
decimal?cc = 0;
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelDataName.Text = "Spreadsheet";
IList <Model.AtSummonDetail> list = detailManager.Select(condition.StartDate, condition.EndDate, null, null);
this.xrLabel1.Text = "Print date£º" + DateTime.Now.ToShortDateString();
this.xrLabel2.Text = "Date range£º" + condition.StartDate.ToShortDateString() + "To" + condition.EndDate.ToShortDateString();
if (list != null)
{
foreach (Model.AtSummonDetail at in list)
{
Model.AtAccountSubject atSub = new BL.AtAccountSubjectManager().Get(at.SubjectId);
if (atSub != null)
{
at.B = atSub.SubjectName;
at.A = atSub.Id;
}
at.E = at.DebitMoney;
at.F = at.CreditMoney;
bb += at.E;
cc += at.F;
oList.Add(at);
}
}
this.DataSource = oList;
this.xrLabel3.Text = bb.ToString();
this.xrLabel4.Text = cc.ToString();
this.xrTableCell5.DataBindings.Add("Text", this.DataSource, "A");
this.xrTableCell6.DataBindings.Add("Text", this.DataSource, "B");
this.xrTableCell7.DataBindings.Add("Text", this.DataSource, "E", "{0:0}");
this.xrTableCell8.DataBindings.Add("Text", this.DataSource, "F", "{0:0}");
}