protected override void MoveLast()
{
//if (AcOtherShouldCollection == null)
{
this.AcOtherShouldCollection = this.AcOtherShouldCollectionManager.Get(this.AcOtherShouldCollectionManager.GetLast() == null ? "" : this.AcOtherShouldCollectionManager.GetLast().AcOtherShouldCollectionId);
}
}
public EditForm(Model.AcOtherShouldCollection AcOtherShouldCollection, string action)
: this()
{
this.AcOtherShouldCollection = AcOtherShouldCollection;
this.AcOtherShouldCollection.Details = this.AcOtherShouldCollectionDetailManager.Select(AcOtherShouldCollection);
this.action = action;
}
private void calEffect(IList <Model.AcCollectionDetail> detail)
{
foreach (Model.AcCollectionDetail item in detail)
{
if (string.IsNullOrEmpty(item.AcInvoiceId))
{
continue;
}
if (item.AcInvoiceType == "銷售發票單")
{
Model.AcInvoiceXOBill xobill = acInvoiceXOBillaccessor.Get(item.AcInvoiceId);
if (xobill == null)
{
continue;
}
xobill.mHeXiaoJingE = xobill.mHeXiaoJingE == null ? 0 : xobill.mHeXiaoJingE - item.DomesticThisChargeMoney;
xobill.NoHeXiaoTotal = xobill.ZongMoney - xobill.mHeXiaoJingE;
acInvoiceXOBillaccessor.Update(xobill);
}
else if (item.AcInvoiceType == "其它應收款")
{
Model.AcOtherShouldCollection acoSc = acOtherShouldCollectionAccessor.Get(item.AcInvoiceId);
if (acoSc == null)
{
continue;
}
acoSc.mHeXiaoJingE = acoSc.mHeXiaoJingE == null ? 0 : acoSc.mHeXiaoJingE - item.DomesticThisChargeMoney;
acoSc.NoHeXiaoTotal = acoSc.HeJi - acoSc.mHeXiaoJingE;
acOtherShouldCollectionAccessor.Update(acoSc);
}
}
}
public void Delete(Model.AcOtherShouldCollection acOtherShouldCollection)
{
//
// todo:add other logic here
//
accessor.Delete(acOtherShouldCollection.AcOtherShouldCollectionId);
}
private void addDetail(Model.AcCollection acCollection)
{
foreach (Model.AcCollectionDetail item in acCollection.Detail)
{
if (string.IsNullOrEmpty(item.AcInvoiceId))
{
continue;
}
item.AcCollectionId = acCollection.AcCollectionId;
if (item.AcInvoiceType == "銷售發票單")
{
Model.AcInvoiceXOBill xobill = acInvoiceXOBillaccessor.Get(item.AcInvoiceId);
if (xobill == null)
{
goto mustdo;
}
xobill.mHeXiaoJingE = xobill.mHeXiaoJingE == null ? 0 : xobill.mHeXiaoJingE + item.DomesticThisChargeMoney;
xobill.NoHeXiaoTotal = xobill.ZongMoney - xobill.mHeXiaoJingE;
acInvoiceXOBillaccessor.Update(xobill);
}
else if (item.AcInvoiceType == "其它應收款")
{
Model.AcOtherShouldCollection acoSc = acOtherShouldCollectionAccessor.Get(item.AcInvoiceId);
if (acoSc == null)
{
goto mustdo;
}
acoSc.mHeXiaoJingE = acoSc.mHeXiaoJingE == null ? 0 : acoSc.mHeXiaoJingE + item.DomesticThisChargeMoney;
acoSc.NoHeXiaoTotal = acoSc.HeJi - acoSc.mHeXiaoJingE;
acOtherShouldCollectionAccessor.Update(acoSc);
}
mustdo:
acCollectionDetailaccessor.Insert(item);
}
}
protected override void MovePrev()
{
Model.AcOtherShouldCollection AcOtherShouldCollection = this.AcOtherShouldCollectionManager.GetPrev(this.AcOtherShouldCollection);
if (AcOtherShouldCollection == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this.AcOtherShouldCollection = this.AcOtherShouldCollectionManager.Get(AcOtherShouldCollection.AcOtherShouldCollectionId);
}
public Model.AcOtherShouldCollection GetDetails(string AcOtherShouldCollectionId)
{
Model.AcOtherShouldCollection AcOtherShouldCollection = accessor.Get(AcOtherShouldCollectionId);
if (AcOtherShouldCollection != null)
{
AcOtherShouldCollection.Details = AcOtherShouldCollectionDetailAccessor.Select(AcOtherShouldCollection);
}
return(AcOtherShouldCollection);
}
//List搜索
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
UI.AccountPayable.AcOtherShouldCollection.ListForm f = new ListForm();
if (f.ShowDialog(this) == DialogResult.OK)
{
this.AcOtherShouldCollection = f.SelectItem;
this.action = "view";
this.Refresh();
}
}
private void Validate(Model.AcOtherShouldCollection acOtherShouldCollection)
{
if (string.IsNullOrEmpty(acOtherShouldCollection.AcOtherShouldCollectionId))
{
throw new Helper.RequireValueException(Model.AcOtherShouldCollection.PRO_AcOtherShouldCollectionId);
}
if (acOtherShouldCollection.InvoiceTax + acOtherShouldCollection.InvoiceHeji != acOtherShouldCollection.HeJi)
{
throw new Helper.InvalidValueException(Model.AcOtherShouldCollection.PRO_InvoiceHeji);
}
}
/// <summary>
/// Update a AcOtherShouldCollection.
/// </summary>
public void Update(Model.AcOtherShouldCollection acOtherShouldCollection)
{
//
// todo: add other logic here.
//
Validate(acOtherShouldCollection);
if (acOtherShouldCollection != null)
{
this.Delete(acOtherShouldCollection);
acOtherShouldCollection.UpdateTime = DateTime.Now;
this.Insert(acOtherShouldCollection);
}
}
protected override void AddNew()
{
this.AcOtherShouldCollection = new Model.AcOtherShouldCollection();
this.AcOtherShouldCollection.AcOtherShouldCollectionId = this.AcOtherShouldCollectionManager.GetId();
this.AcOtherShouldCollection.AcOtherShouldCollectionDate = DateTime.Now;
this.AcOtherShouldCollection.TaxCaluType = 0;
this.AcOtherShouldCollection.Details = new List <Model.AcOtherShouldCollectionDetail>();
this.AcOtherShouldCollection.Employee = BL.V.ActiveOperator.Employee;
if (this.action == "insert")
{
Model.AcOtherShouldCollectionDetail detail = new Model.AcOtherShouldCollectionDetail();
detail.AcOtherShouldCollectionId = this.AcOtherShouldCollection.AcOtherShouldCollectionId;
this.AcOtherShouldCollection.Details.Add(detail);
this.bindingSource1.Position = this.bindingSource1.IndexOf(detail);
}
}
/// <summary>
/// Insert a AcOtherShouldCollection.
/// </summary>
public void Insert(Model.AcOtherShouldCollection acOtherShouldCollection)
{
//
// todo:add other logic here
//
Validate(acOtherShouldCollection);
try
{
acOtherShouldCollection.InsertTime = DateTime.Now;
BL.V.BeginTransaction();
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acOtherShouldCollection.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acOtherShouldCollection.InsertTime.Value.Year, acOtherShouldCollection.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acOtherShouldCollection.InsertTime.Value.ToString("yyyy-MM-dd"));
string sequencekey = string.Format(invoiceKind);
SequenceManager.Increment(sequencekey_y);
SequenceManager.Increment(sequencekey_m);
SequenceManager.Increment(sequencekey_d);
SequenceManager.Increment(sequencekey);
accessor.Insert(acOtherShouldCollection);
foreach (Model.AcOtherShouldCollectionDetail acOtherShouldCollectionDetail in acOtherShouldCollection.Details)
{
acOtherShouldCollectionDetail.AcOtherShouldCollectionDetailId = Guid.NewGuid().ToString();
acOtherShouldCollectionDetail.AcOtherShouldCollectionId = acOtherShouldCollection.AcOtherShouldCollectionId;
AcOtherShouldCollectionDetailAccessor.Insert(acOtherShouldCollectionDetail);
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public void Insert(Model.AcOtherShouldCollection e)
{
this.Insert <Model.AcOtherShouldCollection>(e);
}
public bool HasRowsAfter(Model.AcOtherShouldCollection e)
{
return(accessor.HasRowsAfter(e));
}
public bool HasRowsBefore(Model.AcOtherShouldCollection e)
{
return(sqlmapper.QueryForObject <bool>("AcOtherShouldCollection.has_rows_before", e));
}
public XO(string acOtherShouldCollectionId)
{
InitializeComponent();
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelDataName.Text = "其他應收款";
this.xrLabelPrintDate.Text = "列表日期： " + DateTime.Now.ToShortDateString();
this.acOtherShouldCollection = this.acOtherShouldCollectionManager.Get(acOtherShouldCollectionId);
if (this.acOtherShouldCollection == null)
{
return;
}
this.acOtherShouldCollection.Details = this.acOtherShouldCollectionDetailManager.Select(this.acOtherShouldCollection);
this.DataSource = this.acOtherShouldCollection.Details;
if (this.acOtherShouldCollection.Customer != null)
{
this.xrLabelCustomerId.Text = this.acOtherShouldCollection.Customer.CustomerShortName;
}
this.xrLabelId.Text = this.acOtherShouldCollection.AcOtherShouldCollectionId;
this.xrLabelAcOtherShouldCollectionDate.Text = this.acOtherShouldCollection.AcOtherShouldCollectionDate.Value.ToString("yyyy-MM-dd");
this.xrLabelAdvancePayableDate.Text = this.acOtherShouldCollection.AdvancePayableDate.Value.ToString("yyyy-MM-dd");
if (this.acOtherShouldCollection.Employee0 != null)
{
this.xrLabelEmployee0Id.Text = this.acOtherShouldCollection.Employee0.EmployeeName;
}
if (this.acOtherShouldCollection.Employee != null)
{
this.xrLabelEmployeeId.Text = this.acOtherShouldCollection.Employee.EmployeeName;
}
if (this.acOtherShouldCollection.Employee1 != null)
{
this.xrLabelEmployee1Id.Text = this.acOtherShouldCollection.Employee1.EmployeeName;
}
//if (this.acOtherShouldCollection.AtCurrencyCategory != null)
//{
// this.xrLabelAtCurrencyCategoryId.Text = this.acOtherShouldCollection.AtCurrencyCategory.AtCurrencyName;
//}
this.xrLabelAcDesc.Text = this.acOtherShouldCollection.AcDesc;
// this.xrLabelExchangeRate.Text = this.acOtherShouldCollection.ExchangeRate.ToString();
this.lblHeJi.Text = this.acOtherShouldCollection.HeJi.ToString();
// this.xrLabelInvoiceId.Text = this.acOtherShouldCollection.InvoiceId;
this.lblObjectName.Text = this.acOtherShouldCollection.ObjectName;
this.lblInvoiceHeJi.Text = this.acOtherShouldCollection.InvoiceHeji.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value));
this.lblInvoiceTax.Text = this.acOtherShouldCollection.InvoiceTax.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value));
this.lblInvoiceTaxrate.Text = this.acOtherShouldCollection.InvoiceTaxrate.Value.ToString();
switch (this.acOtherShouldCollection.TaxCaluType)
{
case 0:
this.lblTaxCaluType.Text = "免稅";
break;
case 1:
this.lblTaxCaluType.Text = "外加稅";
break;
case 2:
this.lblTaxCaluType.Text = "內含稅";
break;
}
//明细
// this.xrTableCellAcOtherShouldCollectionId.DataBindings.Add("Text", this.DataSource, Model.AcOtherShouldCollectionDetail.PRO_AcOtherShouldCollectionId);
this.xrTableCellLoanName.DataBindings.Add("Text", this.DataSource, Model.AcOtherShouldCollectionDetail.PRO_LoanName);
this.xrTableCellSubjectId.DataBindings.Add("Text", this.DataSource, "Subject." + Model.AtAccountSubject.PRO_SubjectName);
this.xrTableCellDetailDesc.DataBindings.Add("Text", this.DataSource, Model.AcOtherShouldCollectionDetail.PRO_DetailDesc);
this.xrTableCellAcMoney.DataBindings.Add("Text", this.DataSource, Model.AcOtherShouldCollectionDetail.PRO_AcMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
}
public bool HasRowsAfter(Model.AcOtherShouldCollection e)
{
return(sqlmapper.QueryForObject <bool>("AcOtherShouldCollection.has_rows_after", e));
}
public Model.AcOtherShouldCollection GetPrev(Model.AcOtherShouldCollection e)
{
return(sqlmapper.QueryForObject <Model.AcOtherShouldCollection>("AcOtherShouldCollection.get_prev", e));
}
public Model.AcOtherShouldCollection GetNext(Model.AcOtherShouldCollection e)
{
return(accessor.GetNext(e));
}
public void Update(Model.AcOtherShouldCollection e)
{
this.Update <Model.AcOtherShouldCollection>(e);
}
public IList <Model.AcOtherShouldCollectionDetail> Select(Model.AcOtherShouldCollection acOtherShouldCollection)
{
return(sqlmapper.QueryForList <Model.AcOtherShouldCollectionDetail>("AcOtherShouldCollectionDetail.getByAcOtherShouldCollectionId", acOtherShouldCollection.AcOtherShouldCollectionId));
}
protected override void MoveFirst()
{
this.AcOtherShouldCollection = this.AcOtherShouldCollectionManager.Get(this.AcOtherShouldCollectionManager.GetFirst() == null ? "" : this.AcOtherShouldCollectionManager.GetFirst().AcOtherShouldCollectionId);
}
public IList <Model.AcOtherShouldCollectionDetail> Select(Model.AcOtherShouldCollection acOtherShouldCollection)
{
return(accessor.Select(acOtherShouldCollection));
}
public override void Refresh()
{
if (this.AcOtherShouldCollection == null)
{
this.AddNew();
this.action = "insert";
}
else
{
if (this.action == "view")
{
this.AcOtherShouldCollection = this.AcOtherShouldCollectionManager.GetDetails(AcOtherShouldCollection.AcOtherShouldCollectionId);
}
}
this.textEditFPId.EditValue = this.AcOtherShouldCollection.InvoiceId;
this.calcFPMoney.EditValue = this.AcOtherShouldCollection.BillMoney;
this.textEditAcOtherShouldCollectionId.Text = this.AcOtherShouldCollection.AcOtherShouldCollectionId;
// this.textEditInvoiceId.Text = this.AcOtherShouldCollection.InvoiceId;
this.textEditObjectName.Text = this.AcOtherShouldCollection.ObjectName;
this.memoEditDesc.Text = this.AcOtherShouldCollection.AcDesc;
if (global::Helper.DateTimeParse.DateTimeEquls(this.AcOtherShouldCollection.AcOtherShouldCollectionDate, global::Helper.DateTimeParse.NullDate))
{
this.dateEditAcOtherShouldCollectionDate.EditValue = null;
}
else
{
this.dateEditAcOtherShouldCollectionDate.EditValue = this.AcOtherShouldCollection.AcOtherShouldCollectionDate;
}
if (global::Helper.DateTimeParse.DateTimeEquls(this.AcOtherShouldCollection.AdvancePayableDate, global::Helper.DateTimeParse.NullDate))
{
this.dateEditAdvancePayableDate.EditValue = null;
}
else
{
this.dateEditAdvancePayableDate.EditValue = this.AcOtherShouldCollection.AdvancePayableDate;
}
// this.spinEditExchangeRate.EditValue = this.AcOtherShouldCollection.ExchangeRate;
this.calcZongEMoney.EditValue = this.AcOtherShouldCollection.HeJi;
// this.newChooseContorlAtCurrencyCategoryId.EditValue = this.AcOtherShouldCollection.AtCurrencyCategory;
this.newChooseContorlCustomerId.EditValue = this.AcOtherShouldCollection.Customer;
this.newChooseContorlEmployee0Id.EditValue = this.AcOtherShouldCollection.AuditEmp;
this.newChooseContorlEmployee1Id.EditValue = this.AcOtherShouldCollection.Employee1;
this.newChooseContorlEmployeeId.EditValue = this.AcOtherShouldCollection.Employee;
this.nccCompany.EditValue = this.AcOtherShouldCollection.Company;
this.bindingSource1.DataSource = this.AcOtherShouldCollection.Details;
this.calcTaxRate.EditValue = this.AcOtherShouldCollection.InvoiceTaxrate;
this.calcTaxRateMoney.EditValue = this.AcOtherShouldCollection.InvoiceTax;
this.TaxType.SelectedIndex = this.AcOtherShouldCollection.TaxCaluType.Value;
this.calcHeJiMoney.EditValue = this.AcOtherShouldCollection.InvoiceHeji;
if (this.AcOtherShouldCollection.Details != null && this.AcOtherShouldCollection.Details.Count > 0)
{
foreach (Model.AcOtherShouldCollectionDetail d in this.AcOtherShouldCollection.Details)
{
d.TaxCalualateDictionary = new global::Helper.TaxCalculateHelper((Helper.TaxType)d.AcOtherShouldCollection.TaxCaluType.Value, d.AcOtherShouldCollection.InvoiceTaxrate.Value, d.AcOtherShouldCollection.InvoiceTaxrate.Value, d.AcMoney.Value, 1).TaxCalculateDictionary;
}
}
this.txt_AuditState.EditValue = this.GetAuditName(this.AcOtherShouldCollection.AuditState);
base.Refresh();
switch (this.action)
{
case "insert":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "update":
this.gridView1.OptionsBehavior.Editable = true;
break;
case "view":
this.gridView1.OptionsBehavior.Editable = false;
break;
default:
break;
}
this.newChooseContorlEmployeeId.Enabled = false;
this.calcZongEMoney.Enabled = false;
this.calcHeJiMoney.Enabled = false;
this.calcTaxRateMoney.Enabled = false;
}