public EditForm(Model.AcCollection acc, string action)
: this()
{
this._acCollection = acc;
this.action = "view";
LastFlag = 1;
}
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);
}
}
/// <summary>
/// Insert a AcCollection.
/// </summary>
public void Insert(Model.AcCollection acCollection)
{
Validate(acCollection);
try
{
BL.V.BeginTransaction();
acCollection.InsertTime = DateTime.Now;
TiGuiExists(acCollection);
acCollection.UpdateTime = DateTime.Now;
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acCollection.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acCollection.InsertTime.Value.Year, acCollection.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acCollection.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(acCollection);
addDetail(acCollection);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
protected override void AddNew()
{
this._acCollection = new Model.AcCollection();
this._acCollection.AcCollectionId = this._acCollectionManager.GetId();
this._acCollection.Employee = BL.V.ActiveOperator.Employee;
this._acCollection.AcPaymentDate = DateTime.Now;
this._acCollection.Detail = new List <Model.AcCollectionDetail>();
}
protected override void MovePrev()
{
Model.AcCollection temp = this._acCollectionManager.GetPrev(this._acCollection);
if (temp == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._acCollection = this._acCollectionManager.Get(temp.AcCollectionId);
}
protected override void MoveLast()
{
if (this.LastFlag == 1)
{
this.LastFlag = 0;
return;
}
this._acCollection = this._acCollectionManager.Get(this._acCollectionManager.GetLast() == null ? "" : this._acCollectionManager.GetLast().AcCollectionId);
}
public override void Refresh()
{
if (this._acCollection == null)
{
this.AddNew();
this.action = "insert";
}
else
{
if (this.action == "view")
{
this._acCollection = this._acCollectionManager.GetDetails(this._acCollection);
if (this._acCollection == null)
{
this._acCollection = new Book.Model.AcCollection();
}
}
}
this.textAcCollectionId.Text = this._acCollection.AcCollectionId;
this.textAuditingState.Text = this.GetAuditName(this._acCollection.AuditState);
this.textBankAccount.Text = this._acCollection.BankAccount;
this.textBillNo.Text = this._acCollection.BillNo;
this.calcAdvanceCollectionBalance.Value = this._acCollection.AdvanceCollectionBalance == null ? 0 : this._acCollection.AdvanceCollectionBalance.Value;
this.calcDomesticCashAgio.Value = this._acCollection.DomesticCashAgio == null ? 0 : this._acCollection.DomesticCashAgio.Value;
this.calcDomesticEealityCollection.Value = this._acCollection.DomesticEealityCollection == null ? 0 : this._acCollection.DomesticEealityCollection.Value;
this.calcDomesticMayChargeMoney.Value = this._acCollection.DomesticMayChargeMoney == null ? 0 : this._acCollection.DomesticMayChargeMoney.Value;
this.calcJoinAdvanceCollection.Value = this._acCollection.JoinAdvanceCollection == null ? 0 : this._acCollection.JoinAdvanceCollection.Value;
this.calcSubscriptionAdvanceCollection.Value = this._acCollection.SubscriptionAdvanceCollection == null ? 0 : this._acCollection.SubscriptionAdvanceCollection.Value;
this.newChooseAtCurrencyCategoryId.EditValue = this._acCollection.AtCurrencyCategory;
this.newChooseCustomerId.EditValue = this._acCollection.Customer;
this.newChooseEmployee0Id.EditValue = this._acCollection.AuditEmp;
this.newChooseEmployee1Id.EditValue = this._acCollection.Employee1;
this.newChooseEmployeeId.EditValue = this._acCollection.Employee;
this.newChoosePayMethodId.EditValue = this._acCollection.PayMethod;
this.newChooseSubjectId.EditValue = this._acCollection.Subject;
this.dateAcPaymentDate.Text = this._acCollection.AcPaymentDate == null ? "" : this._acCollection.AcPaymentDate.Value.ToString();
this.memoAcDesc.Text = this._acCollection.AcDesc;
this.bindingSourceDetails.DataSource = this._acCollection.Detail;
this.gridView1.GroupPanelText = "共: " + (this._acCollection.Detail == null ? "0" : this._acCollection.Detail.Count.ToString()) + " 項";
base.Refresh();
if (this.action == "view")
{
this.barBtnInvoiceXO.Enabled = false;
}
else
{
this.barBtnInvoiceXO.Enabled = true;
}
this.textAcCollectionId.Enabled = false;
this.newChooseEmployeeId.Enabled = false;
this.calcAdvanceCollectionBalance.Enabled = false;
this.calcDomesticCashAgio.Enabled = false;
this.calcDomesticMayChargeMoney.Enabled = false;
}
public Model.AcCollection GetDetails(Model.AcCollection acCollection)
{
Model.AcCollection temp = accessor.Get(acCollection.AcCollectionId);
if (temp != null)
{
temp.Detail = acCollectionDetailaccessor.Select(temp);
}
return(temp);
}
public void Delete(Model.AcCollection acc)
{
try
{
BL.V.BeginTransaction();
calEffect(acc.Detail);
acCollectionDetailaccessor.DeleteByAccid(acc.AcCollectionId);
this.Delete(acc.AcCollectionId);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void TiGuiExists(Model.AcCollection model)
{
if (this.ExistsPrimary(model.AcCollectionId))
{
//设置KEY值
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, model.AcPaymentDate.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.AcPaymentDate.Value.Year, model.AcPaymentDate.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.AcPaymentDate.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);
model.AcCollectionId = this.GetId(model.AcPaymentDate.Value);
TiGuiExists(model);
//throw new Helper.InvalidValueException(Model.Product.PRO_Id);
}
}
protected override void Delete()
{
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
try
{
this._acCollectionManager.Delete(this._acCollection);
this._acCollection = this._acCollectionManager.GetNext(this._acCollection);
if (this._acCollection == null)
{
this._acCollection = this._acCollectionManager.GetLast();
}
}
catch
{
throw;
}
}
/// <summary>
/// Update a AcCollection.
/// </summary>
public void Update(Model.AcCollection acCollection)
{
try
{
BL.V.BeginTransaction();
Validate(acCollection);
acCollection.UpdateTime = DateTime.Now;
accessor.Update(acCollection);
IList <Model.AcCollectionDetail> olddetail = acCollectionDetailaccessor.Select(acCollection);
calEffect(olddetail);
acCollectionDetailaccessor.DeleteByAccid(acCollection.AcCollectionId);
addDetail(acCollection);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void Validate(Model.AcCollection acc)
{
//if (string.IsNullOrEmpty(acc.PayMethodId))
//{
// throw new global::Helper.RequireValueException(Model.AcCollection.PRO_PayMethodId);
//}
if (string.IsNullOrEmpty(acc.CustomerId))
{
throw new global::Helper.RequireValueException(Model.AcCollection.PRO_CustomerId);
}
if (string.IsNullOrEmpty(acc.Employee1Id))
{
throw new global::Helper.RequireValueException(Model.AcCollection.PRO_Employee1Id);
}
foreach (Model.AcCollectionDetail item in acc.Detail)
{
if (item.DomesticNoPaymentMoney < item.DomesticThisChargeMoney)
{
throw new global::Helper.InvalidValueException(Model.AcCollectionDetail.PRO_DomesticThisChargeMoney);
}
}
}
public IList <Model.AcCollectionDetail> Select(Model.AcCollection acCollection)
{
return(accessor.Select(acCollection));
}
public Model.AcCollection GetPrev(Model.AcCollection e)
{
return(sqlmapper.QueryForObject <Model.AcCollection>("AcCollection.get_prev", e));
}
public Model.AcCollection GetNext(Model.AcCollection e)
{
return(sqlmapper.QueryForObject <Model.AcCollection>("AcCollection.get_next", e));
}
public bool HasRowsAfter(Model.AcCollection e)
{
return(sqlmapper.QueryForObject <bool>("AcCollection.has_rows_after", e));
}
public bool HasRowsBefore(Model.AcCollection e)
{
return(sqlmapper.QueryForObject <bool>("AcCollection.has_rows_before", e));
}
public void Update(Model.AcCollection e)
{
this.Update <Model.AcCollection>(e);
}
public void Insert(Model.AcCollection e)
{
this.Insert <Model.AcCollection>(e);
}
public Model.AcCollection GetPrev(Model.AcCollection e)
{
return(accessor.GetPrev(e));
}
public Model.AcCollection GetNext(Model.AcCollection e)
{
return(accessor.GetNext(e));
}
protected override void MoveFirst()
{
this._acCollection = this._acCollectionManager.Get(this._acCollectionManager.GetFirst() == null ? "" : this._acCollectionManager.GetFirst().AcCollectionId);
}
public bool HasRowsAfter(Model.AcCollection e)
{
return(accessor.HasRowsAfter(e));
}
public IList <Model.AcCollectionDetail> Select(Model.AcCollection acCollection)
{
return(sqlmapper.QueryForList <Model.AcCollectionDetail>("AcCollectionDetail.selectByAcCollection", acCollection.AcCollectionId));
}
public XR(string AcCollectionId)
{
InitializeComponent();
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelDataName.Text = "ÊÕ¿î½YËã";
this.xrLabelPrintDate.Text = DateTime.Now.ToShortDateString();
this.AcCollection = this.AcCollectionManager.Get(AcCollectionId);
if (this.AcCollection == null)
{
return;
}
this.AcCollection.Detail = this.AcCollectionDetailManager.Select(this.AcCollection);
this.DataSource = this.AcCollection.Detail;
this.xrLabelAcCollectionId.Text = this.AcCollection.AcCollectionId;
this.xrLabelAcCollectionDate.Text = this.AcCollection.AcPaymentDate.Value.ToString("yyyy-MM-dd");
if (this.AcCollection.Subject != null)
{
this.xrLabelSubjectId.Text = this.AcCollection.Subject.SubjectName;
}
if (this.AcCollection.Customer != null)
{
this.xrLabelCustomerId.Text = this.AcCollection.Customer.CustomerShortName;
}
if (this.AcCollection.AtCurrencyCategory != null)
{
this.xrLabelAtCurrencyCategoryId.Text = this.AcCollection.AtCurrencyCategory.AtCurrencyName;
}
if (this.AcCollection.PayMethod != null)
{
this.xrLabelPayMethodId.Text = this.AcCollection.PayMethod.PayMethodName;
}
if (this.AcCollection.Employee0 != null)
{
this.xrLabelEmployee0Id.Text = this.AcCollection.Employee0.EmployeeName;
}
if (this.AcCollection.Employee != null)
{
this.xrLabelEmployeeId.Text = this.AcCollection.Employee.EmployeeName;
}
if (this.AcCollection.Employee1 != null)
{
this.xrLabelEmployee1Id.Text = this.AcCollection.Employee1.EmployeeName;
}
this.xrLabelDomesticCashAgio.Text = this.AcCollection.DomesticCashAgio.ToString();
this.xrLabelDomesticEealityPayment.Text = this.AcCollection.DomesticEealityCollection.ToString();
this.xrLabelDomesticMayChargeMoney.Text = this.AcCollection.DomesticMayChargeMoney.ToString();
this.xrLabelEealityPayment.Text = this.AcCollection.EealityCollection.ToString();
this.xrLabelJoinAdvancePayment.Text = this.AcCollection.JoinAdvanceCollection.ToString();
this.xrLabelSubscriptionAdvancePayment.Text = this.AcCollection.SubscriptionAdvanceCollection.ToString();
this.xrLabelAcDesc.Text = this.AcCollection.AcDesc;
this.xrLabelAdvancePaymentBalance.Text = this.AcCollection.AdvanceCollectionBalance.ToString();
this.xrLabelAlreadyChargeMoney.Text = this.AcCollection.AlreadyChargeMoney.ToString();
this.xrLabelBankAccount.Text = this.AcCollection.BankAccount;
this.xrLabelBillNo.Text = this.AcCollection.BillNo;
this.xrLabelCashAgio.Text = this.AcCollection.CashAgio.ToString();
//Ã÷ϸ
this.xrTableAcInvoiceId.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_AcInvoiceId);
this.xrTableAcInvoiceType.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_AcInvoiceType);
this.xrTableDetailCashAgio.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_DetailCashAgio, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableDomesticDetailCashAgio.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_DomesticDetailCashAgio, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableDomesticNoPaymentMoney.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_DomesticNoPaymentMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableDomesticShouldPaymentMoney.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_DomesticShouldCollectionMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableDomesticThisChargeMoney.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_DomesticThisChargeMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableMayChargeMoney.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_MayChargeMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableNoPaymentMoney.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_NoCollectionMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableShouldPaymentMoney.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_ShouldCollectionMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableThisChargeMoney.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_ThisChargeMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.xrTableBillId.DataBindings.Add("Text", this.DataSource, Model.AcCollectionDetail.PRO_BillId);
}
public bool HasRowsBefore(Model.AcCollection e)
{
return(accessor.HasRowsBefore(e));
}
