/// <summary>
/// 尾笔
/// </summary>
protected override void MoveLast()
{
// if (_acbeginAccountPayble == null)
{
this._acInvoiceXoBill = this._acInvoiceXoBillManager.Get(this._acInvoiceXoBillManager.GetLast() == null ? "" : this._acInvoiceXoBillManager.GetLast().AcInvoiceXOBillId);
}
}
private void TiGuiExists(Model.AcInvoiceXOBill model)
{
if (this.ExistsPrimary(model.AcInvoiceXOBillId))
{
//设置KEY值
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, model.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, model.InsertTime.Value.Year, model.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.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);
model.AcInvoiceXOBillId = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
//throw new Helper.InvalidValueException(Model.Product.PRO_Id);
}
if (this.IsExistsId(model.Id)) //发票编号重复
{
model.Id = GetIdNumber();
while (this.IsExistsId(model.Id))
{
AddIdNumber();
model.Id = GetIdNumber();
}
}
}
public void Delete(Model.AcInvoiceXOBill acInvoiceXOBill)
{
try
{
BL.V.BeginTransaction();
calEffect(acInvoiceXOBill.Details);
accessorDetails.Delete(acInvoiceXOBill);
this.Delete(acInvoiceXOBill.AcInvoiceXOBillId);
//发票编号回收
//Model.BillIdDeleted billIdDeleted = new Book.Model.BillIdDeleted();
//billIdDeleted.BillId = acInvoiceXOBill.Id;
//billIdDeleted.DeleteTime = DateTime.Now;
//billIdDeleted.BillIdSetId = billIdSet.BillIdSetId;
//BillIdDeletedManager.Insert(billIdDeleted);
Model.BillIdSet billIdSet = new BL.BillIdSetManager().SelectEnable();
billIdSet.IdNumber = Convert.ToInt32(billIdSet.IdNumber) - 1;
new BL.BillIdSetManager().UpdateIdnumber(billIdSet);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
/// <summary>
/// Insert a AcInvoiceXOBill.
/// </summary>
public void Insert(Model.AcInvoiceXOBill acInvoiceXOBill)
{
//
// todo:add other logic here
//
Validate(acInvoiceXOBill);
try
{
BL.V.BeginTransaction();
acInvoiceXOBill.InsertTime = DateTime.Now;
TiGuiExists(acInvoiceXOBill);
acInvoiceXOBill.UpdateTime = DateTime.Now;
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, acInvoiceXOBill.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, acInvoiceXOBill.InsertTime.Value.Year, acInvoiceXOBill.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, acInvoiceXOBill.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(acInvoiceXOBill);
addDetail(acInvoiceXOBill);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
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);
}
}
}
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);
}
}
public bool ExistsExcept(Model.AcInvoiceXOBill e)
{
Hashtable paras = new Hashtable();
paras.Add("newId", e.Id);
paras.Add("oldId", Get(e.AcInvoiceXOBillId) == null?null:Get(e.AcInvoiceXOBillId).Id);
return(sqlmapper.QueryForObject <bool>("AcInvoiceXOBill.existsexcept", paras));
}
public Model.AcInvoiceXOBill GetDetails(Model.AcInvoiceXOBill acinvoiceXoBill)
{
if (acinvoiceXoBill != null)
{
acinvoiceXoBill.Details = accessorDetails.SelectByAcInvoiceXOBill(acinvoiceXoBill);
}
return(acinvoiceXoBill);
}
protected override void MoveNext()
{
Model.AcInvoiceXOBill temp = this._acInvoiceXoBillManager.GetNext(this._acInvoiceXoBill);
if (temp == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this._acInvoiceXoBill = this._acInvoiceXoBillManager.Get(temp.AcInvoiceXOBillId);
}
public override void Refresh()
{
if (this._acInvoiceXoBill == null)
{
this.AddNew();
this.action = "insert";
}
else
{
if (this.action == "view")
{
this._acInvoiceXoBill = this._acInvoiceXoBillManager.GetDetails(this._acInvoiceXoBill);
if (this._acInvoiceXoBill == null)
{
this._acInvoiceXoBill = new Book.Model.AcInvoiceXOBill();
}
}
}
this.newChooseCustomer2.EditValue = this._acInvoiceXoBill.CustomerShouPiao;
this.AcInvoiceXOBillId.Text = this._acInvoiceXoBill.AcInvoiceXOBillId;
this.XoId.Text = this._acInvoiceXoBill.Id;
this.memoAcInvoiceXOBillDesc.Text = this._acInvoiceXoBill.AcInvoiceXOBillDesc;
this.dateAcInvoiceXOBillDate.DateTime = this._acInvoiceXoBill.AcInvoiceXOBillDate.Value;
this.calcHeJiMoney.Value = this._acInvoiceXoBill.HeJiMoney == null ? 0 : this._acInvoiceXoBill.HeJiMoney.Value;
this.TaxType.SelectedIndex = Convert.ToInt32(this._acInvoiceXoBill.TaxRateType);
this.calcTaxRate.Value = Convert.ToDecimal(this._acInvoiceXoBill.TaxRate == null ? 0 : this._acInvoiceXoBill.TaxRate.Value);
this.calcTaxRateMoney.Value = this._acInvoiceXoBill.TaxRateMoney == null ? 0 : this._acInvoiceXoBill.TaxRateMoney.Value;
this.calcZongMoney.Value = this._acInvoiceXoBill.ZongMoney == null ? 0 : this._acInvoiceXoBill.ZongMoney.Value;
this.calcmHeXiaoJingE.Value = this._acInvoiceXoBill.mHeXiaoJingE == null ? 0 : this._acInvoiceXoBill.mHeXiaoJingE.Value;
this.calcNoHeXiaoTotal.Value = this._acInvoiceXoBill.NoHeXiaoTotal == null ? 0 : this._acInvoiceXoBill.NoHeXiaoTotal.Value;
// this.dateForYSDate.DateTime = this._acInvoiceXoBill.YSDate == null ? DateTime.Now : this._acInvoiceXoBill.YSDate.Value;
this.newChooseEmployee0Id.EditValue = this._acInvoiceXoBill.AuditEmp;
// this.newChooseEmployee1Id.EditValue = this._acInvoiceXoBill.Employee1;
this.newChooseEmployeeId.EditValue = this._acInvoiceXoBill.Employee;
this.newChooseCustomerId.EditValue = this._acInvoiceXoBill.Customer;
this.txt_AuditState.EditValue = this.GetAuditName(this._acInvoiceXoBill.AuditState);
this.bindingSourceDetails.DataSource = this._acInvoiceXoBill.Details;
base.Refresh();
//if (this.action == "view")
//{
// this.barBtnChuHuoDan.Enabled = false;
//}
//else
//{
// this.barBtnChuHuoDan.Enabled = true;
//}
this.newChooseEmployeeId.Enabled = false;
// this.calcHeJiMoney.Enabled = false;
this.calcZongMoney.Enabled = false;
this.calcTaxRateMoney.Enabled = false;
this.calcmHeXiaoJingE.Enabled = false;
this.calcNoHeXiaoTotal.Enabled = false;
}
protected override void AddNew()
{
this._acInvoiceXoBill = new Model.AcInvoiceXOBill();
this._acInvoiceXoBill.AcInvoiceXOBillId = this._acInvoiceXoBillManager.GetId(DateTime.Now);
this._acInvoiceXoBill.AcInvoiceXOBillDate = DateTime.Now;
this._acInvoiceXoBill.Employee = BL.V.ActiveOperator.Employee;
this._acInvoiceXoBill.TaxRateType = 1;
this._acInvoiceXoBill.TaxRate = 5;
this._acInvoiceXoBill.Details = new List <Model.AcInvoiceXOBillDetail>();
}
/// <summary>
/// Update a AcInvoiceXOBill.
/// </summary>
public void Update(Model.AcInvoiceXOBill acInvoiceXOBill)
{
Validate(acInvoiceXOBill);
acInvoiceXOBill.UpdateTime = DateTime.Now;
accessor.Update(acInvoiceXOBill);
IList <Model.AcInvoiceXOBillDetail> olddetail = accessorDetails.SelectByAcInvoiceXOBill(acInvoiceXOBill);
calEffect(olddetail);
accessorDetails.Delete(acInvoiceXOBill);
addDetail(acInvoiceXOBill);
}
private void barButtonSearch_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
ListForm lf = new ListForm();
if (lf.ShowDialog(this) == DialogResult.OK)
{
this._acInvoiceXoBill = (Model.AcInvoiceXOBill)lf.SelectItem;
this.action = "view";
this.Refresh();
}
lf.Dispose();
GC.Collect();
}
private void addDetail(Model.AcInvoiceXOBill acInvoiceXOBill)
{
foreach (Model.AcInvoiceXOBillDetail Detail in acInvoiceXOBill.Details)
{
//if (string.IsNullOrEmpty(Detail.InvoiceId)) continue;
Detail.AcInvoiceXOBillId = acInvoiceXOBill.AcInvoiceXOBillId;
accessorDetails.Insert(Detail);
Model.InvoiceXSDetail ixsd = mInvoiceXSDetailAccessor.Get(Detail.InvoiceXODetailId);
if (ixsd != null)
{
ixsd.InvoiceXSDetailFPQuantity = Convert.ToDouble(ixsd.InvoiceXSDetailFPQuantity) + Convert.ToDouble(Detail.InvoiceXODetaiInQuantity);
}
mInvoiceXSDetailAccessor.Update(ixsd);
}
}
private void Validate(Model.AcInvoiceXOBill AcInvoiceXOBill)
{
if (string.IsNullOrEmpty(AcInvoiceXOBill.Id))
{
throw new Helper.RequireValueException(Model.AcInvoiceXOBill.PRO_Id);
}
if (string.IsNullOrEmpty(AcInvoiceXOBill.CustomerId))
{
throw new Helper.RequireValueException(Model.AcInvoiceXOBill.PRO_CustomerId);
}
if (AcInvoiceXOBill.Details == null || AcInvoiceXOBill.Details.Count == 0)
{
throw new Helper.RequireValueException("AcInvoiceXOBill.Details");
}
}
protected override void AddNew()
{
this._acInvoiceXoBill = new Model.AcInvoiceXOBill();
this._acInvoiceXoBill.AcInvoiceXOBillId = this._acInvoiceXoBillManager.GetId(DateTime.Now);
this._acInvoiceXoBill.AcInvoiceXOBillDate = DateTime.Now;
this._acInvoiceXoBill.Employee = BL.V.ActiveOperator.Employee;
this._acInvoiceXoBill.TaxRateType = 1;
this._acInvoiceXoBill.TaxRate = 5;
this._acInvoiceXoBill.IsCancel = 0;
this._acInvoiceXoBill.ClearanceType = "1";
this._acInvoiceXoBill.SalesType = "0";
this._acInvoiceXoBill.Details = new List <Model.AcInvoiceXOBillDetail>();
//生成發票編號
GenerateBillId();
}
public void Delete(Model.AcInvoiceXOBill acInvoiceXOBill)
{
try
{
BL.V.BeginTransaction();
calEffect(acInvoiceXOBill.Details);
accessorDetails.Delete(acInvoiceXOBill);
this.Delete(acInvoiceXOBill.AcInvoiceXOBillId);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public Ro(Model.AcInvoiceXOBill acInvoiceXOBill)
{
InitializeComponent();
//报表标题
this.ReportName.Text = BL.Settings.CompanyChineseName;
this.ReportTitle.Text = Properties.Resources.AcInvoiceXOBill;
//列印日期
this.ReportDate.Text += System.DateTime.Now.ToShortDateString();
//头资料
this.AcInvoiceXOBillId.Text = acInvoiceXOBill.AcInvoiceXOBillId;
this.lblfpbh.Text = acInvoiceXOBill.Id;
this.RepDate.Text = acInvoiceXOBill.AcInvoiceXOBillDate.Value.ToString("yyyy-MM-dd");
this.lblBeiZhu.Text = acInvoiceXOBill.AcInvoiceXOBillDesc;
//this.newChooseCustomerId.Text = acInvoiceXOBill.Employee.ToString();
this.newChooseCustomerId.Text = acInvoiceXOBill.Customer.CustomerShortName;
//this.newChooseEmployee0Id.Text = acInvoiceXOBill.Employee0.ToString();
this.newChooseEmployeeId.Text = string.IsNullOrEmpty(acInvoiceXOBill.EmployeeId) ? "" : acInvoiceXOBill.Employee.ToString();
this.newChooseEmployee1Id.Text = string.IsNullOrEmpty(acInvoiceXOBill.Employee1Id) ? "" : acInvoiceXOBill.Employee1.ToString();
this.newChooseEmployee0Id.Text = string.IsNullOrEmpty(acInvoiceXOBill.Employee0Id) ? "" : acInvoiceXOBill.Employee0.ToString();
this.calcTaxRate.Text = acInvoiceXOBill.TaxRate.ToString();
this.calcTaxRateMoney.Text = acInvoiceXOBill.TaxRateMoney.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value));
this.calcShuiBie.Text = acInvoiceXOBill.TaxRateType.ToString();
this.calcHeJi.Text = acInvoiceXOBill.HeJiMoney.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value));;
this.calcZongE.Text = acInvoiceXOBill.ZongMoney.Value.ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value));
this.lblYSDate.Text = acInvoiceXOBill.YSDate == null ? "" : acInvoiceXOBill.YSDate.Value.ToString();
this.lblmHeXiaoJingE.Text = (acInvoiceXOBill.mHeXiaoJingE == null ? 0 : acInvoiceXOBill.mHeXiaoJingE.Value).ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value));
this.lblNoHeXiaoTotal.Text = (acInvoiceXOBill.NoHeXiaoTotal == null ? 0 : acInvoiceXOBill.NoHeXiaoTotal.Value).ToString(global::Helper.DateTimeParse.GetFormat(BL.V.SetDataFormat.XSZJXiao.Value));
//绑定详细数据源
this.DataSource = acInvoiceXOBill.Details;
//详细资料
this.CellInvoiceId.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceId);
this.CellProduct.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
this.CellInvoiceAllowance.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceAllowance);
this.CellInvoiceXODetailPrice.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetailPrice, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSDJXiao.Value));
this.CellInvoiceXODetaiInQuantity.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetaiInQuantity);
this.CellInvoiceXODetailMoney.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetailMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.CellInvoiceXODetailTax.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetailTax, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.CellInvoiceXODetailTaxMoney.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetailTaxMoney, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSZJXiao.Value));
this.CellInvoiceXODetailTaxPrice.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetailTaxPrice, global::Helper.DateTimeParse.GetFormatA(BL.V.SetDataFormat.XSDJXiao.Value));
}
protected override void Delete()
{
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
{
return;
}
try
{
this._acInvoiceXoBillManager.Delete(this._acInvoiceXoBill);
this._acInvoiceXoBill = this._acInvoiceXoBillManager.GetNext(this._acInvoiceXoBill);
if (this._acInvoiceXoBill == null)
{
this._acInvoiceXoBill = this._acInvoiceXoBillManager.GetLast();
}
}
catch
{
throw;
}
}
public Model.AcInvoiceXOBill GetNext(Model.AcInvoiceXOBill e)
{
return(sqlmapper.QueryForObject <Model.AcInvoiceXOBill>("AcInvoiceXOBill.get_next", e));
}
protected override void MoveFirst()
{
this._acInvoiceXoBill = this._acInvoiceXoBillManager.Get(this._acInvoiceXoBillManager.GetFirst() == null ? "" : this._acInvoiceXoBillManager.GetFirst().AcInvoiceXOBillId);
}
public FPRO(Model.AcInvoiceXOBill model)
: this()
{
this.DataSource = list = model.Details;
if (model.AcInvoiceXOBillDate.HasValue)
{
this.lblYear.Text = (model.AcInvoiceXOBillDate.Value.Year - 1911).ToString();
this.lblMonth.Text = model.AcInvoiceXOBillDate.Value.Month.ToString();
this.lblDay.Text = model.AcInvoiceXOBillDate.Value.Day.ToString();
}
this.lblFPNo.Text = model.Id;
//¼ì²éÂë
if (!string.IsNullOrEmpty(model.Id))
{
string englishid1 = model.Id.Substring(0, 1);
string englishid2 = model.Id.Substring(1, 1);
decimal x = Math.Truncate((decimal)(((int)System.Text.Encoding.ASCII.GetBytes(englishid1)[0] * (int)System.Text.Encoding.ASCII.GetBytes(englishid2)[0]) / 2)) % 10;
string str = model.Id.Substring(2);
decimal y = 0;
for (int i = 0; i < str.Length; i++)
{
y += Convert.ToInt32(str.Substring(i, 1)) * (i + 1);
}
y = y % 10;
this.lblCheckNo.Text = x.ToString() + y.ToString();
}
//if (!string.IsNullOrEmpty(model.Id))
//{
// int x = Convert.ToInt32((Convert.ToInt32(model.Id.Substring(2)) + 84562911).ToString().Substring((Convert.ToInt32(model.Id.Substring(2)) + 84562911).ToString().Length - 8));
// string str = x.ToString();
// int y = Convert.ToInt32(str.Substring(0, 2)) + Convert.ToInt32(str.Substring(2, 2)) + Convert.ToInt32(str.Substring(4, 2)) + Convert.ToInt32(str.Substring(6, 2));
// this.lblCheckNo.Text = (100 - y % 100).ToString();
//}
if (model.CustomerShouPiao != null)
{
this.lblBuyer.Text = model.CustomerShouPiao.CustomerFullName;
this.lblUniteNo.Text = model.CustomerShouPiao.CustomerNumber;
this.lblAddress.Text = model.CustomerShouPiao.CustomerAddress;
}
string s = "";
foreach (var item in model.Details)
{
if (!string.IsNullOrEmpty(item.InvoiceCOIdNote))
{
//string[] str = item.InvoiceCOIdNote.Split(',');
//foreach (var id in str)
//{
if (!s.Contains(item.InvoiceCOIdNote))
{
s += item.InvoiceCOIdNote + ",";
}
//}
}
}
if (s.Length >= 1)
{
this.lblNote.Text = s.Substring(0, s.Length - 1);
}
lblHeji.Text = model.HeJiMoney.HasValue ? model.HeJiMoney.Value.ToString("0.##") : "";
lblTax.Text = model.TaxRateMoney.HasValue ? model.TaxRateMoney.Value.ToString("0.##") : "";
lblTotal.Text = model.ZongMoney.HasValue ? model.ZongMoney.Value.ToString("0.##") : "";
switch (model.TaxRateType)
{
case 0:
this.lblNoTax.Text = "¡Ì";
break;
case 1:
this.lblShouldTax.Text = "¡Ì";
break;
case 2:
this.lblZeroTax.Text = "¡Ì";
break;
}
string totalmoney = (model.ZongMoney.HasValue ? model.ZongMoney.Value : 0).ToString("##########");
string ge = "", shi = "", bai = "", qian = "", wan = "", shiwan = "", baiwan = "", qianwan = "";
//if (totalmoney.Length > 8)
//{
// ge = totalmoney.Substring(totalmoney.Length - 1);
// shi = totalmoney.Substring(totalmoney.Length - 2, 1);
// bai = totalmoney.Substring(totalmoney.Length - 3, 1);
// qian = totalmoney.Substring(totalmoney.Length - 4, 1);
// wan = totalmoney.Substring(totalmoney.Length - 5, 1);
// shiwan = totalmoney.Substring(totalmoney.Length - 6, 1);
// baiwan = totalmoney.Substring(totalmoney.Length - 7, 1);
// qianwan = totalmoney.Substring(0, totalmoney.Length - 8 + 1);
//}
if (totalmoney.Length == 8)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
shi = totalmoney.Substring(totalmoney.Length - 2, 1);
bai = totalmoney.Substring(totalmoney.Length - 3, 1);
qian = totalmoney.Substring(totalmoney.Length - 4, 1);
wan = totalmoney.Substring(totalmoney.Length - 5, 1);
shiwan = totalmoney.Substring(totalmoney.Length - 6, 1);
baiwan = totalmoney.Substring(totalmoney.Length - 7, 1);
qianwan = totalmoney.Substring(totalmoney.Length - 8, 1);
}
else if (totalmoney.Length == 7)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
shi = totalmoney.Substring(totalmoney.Length - 2, 1);
bai = totalmoney.Substring(totalmoney.Length - 3, 1);
qian = totalmoney.Substring(totalmoney.Length - 4, 1);
wan = totalmoney.Substring(totalmoney.Length - 5, 1);
shiwan = totalmoney.Substring(totalmoney.Length - 6, 1);
baiwan = totalmoney.Substring(totalmoney.Length - 7, 1);
}
else if (totalmoney.Length == 6)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
shi = totalmoney.Substring(totalmoney.Length - 2, 1);
bai = totalmoney.Substring(totalmoney.Length - 3, 1);
qian = totalmoney.Substring(totalmoney.Length - 4, 1);
wan = totalmoney.Substring(totalmoney.Length - 5, 1);
shiwan = totalmoney.Substring(totalmoney.Length - 6, 1);
}
else if (totalmoney.Length == 5)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
shi = totalmoney.Substring(totalmoney.Length - 2, 1);
bai = totalmoney.Substring(totalmoney.Length - 3, 1);
qian = totalmoney.Substring(totalmoney.Length - 4, 1);
wan = totalmoney.Substring(totalmoney.Length - 5, 1);
}
else if (totalmoney.Length == 4)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
shi = totalmoney.Substring(totalmoney.Length - 2, 1);
bai = totalmoney.Substring(totalmoney.Length - 3, 1);
qian = totalmoney.Substring(totalmoney.Length - 4, 1);
}
else if (totalmoney.Length == 3)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
shi = totalmoney.Substring(totalmoney.Length - 2, 1);
bai = totalmoney.Substring(totalmoney.Length - 3, 1);
}
else if (totalmoney.Length == 2)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
shi = totalmoney.Substring(totalmoney.Length - 2, 1);
}
else if (totalmoney.Length == 1)
{
ge = totalmoney.Substring(totalmoney.Length - 1);
}
this.lblGe.Text = this.ConvertData(ge);
this.lblShi.Text = this.ConvertData(shi);
this.lblBai.Text = this.ConvertData(bai);
this.lblQian.Text = this.ConvertData(qian);
this.lblWan.Text = this.ConvertData(wan);
this.lblShiwan.Text = this.ConvertData(shiwan);
this.lblBaiwan.Text = this.ConvertData(baiwan);
this.lblQianwan.Text = this.ConvertData(qianwan);
//TCProduct.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
//TCQuantity.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetaiInQuantity, "{0:0.##}");
//TCPrice.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetailPrice, "{0:0.##}");
//TCMoney.DataBindings.Add("Text", this.DataSource, Model.AcInvoiceXOBillDetail.PRO_InvoiceXODetailMoney, "{0:0.##}");
}
public void Insert(Model.AcInvoiceXOBill e)
{
this.Insert <Model.AcInvoiceXOBill>(e);
}
public bool HasRowsBefore(Model.AcInvoiceXOBill e)
{
return(sqlmapper.QueryForObject <bool>("AcInvoiceXOBill.has_rows_before", e));
}
public void Update(Model.AcInvoiceXOBill e)
{
this.Update <Model.AcInvoiceXOBill>(e);
}
public bool HasRowsAfter(Model.AcInvoiceXOBill e)
{
return(sqlmapper.QueryForObject <bool>("AcInvoiceXOBill.has_rows_after", e));
}
protected override void Save()
{
this._acInvoiceXoBill.AcInvoiceXOBillId = this.AcInvoiceXOBillId.Text;
this._acInvoiceXoBill.Id = this.XoId.Text;
this._acInvoiceXoBill.Customer = this.newChooseCustomerId.EditValue as Model.Customer;
if (this._acInvoiceXoBill.Customer != null)
{
this._acInvoiceXoBill.CustomerId = this._acInvoiceXoBill.Customer.CustomerId;
}
this._acInvoiceXoBill.TaxRate = Convert.ToDouble(this.calcTaxRate.Value);
this._acInvoiceXoBill.TaxRateMoney = this.calcTaxRateMoney.Value;
this._acInvoiceXoBill.TaxRateType = this.TaxType.SelectedIndex;
this._acInvoiceXoBill.HeJiMoney = this.calcHeJiMoney.Value;
this._acInvoiceXoBill.ZongMoney = this.calcZongMoney.Value;
this._acInvoiceXoBill.mHeXiaoJingE = this.calcmHeXiaoJingE.Value;
this._acInvoiceXoBill.CustomerShouPiao = this.newChooseCustomer2.EditValue as Model.Customer;
if (this.newChooseCustomer2.EditValue != null)
{
this._acInvoiceXoBill.CustomerShouPiaoId = this._acInvoiceXoBill.CustomerShouPiao.CustomerId;
}
this._acInvoiceXoBill.NoHeXiaoTotal = this.calcNoHeXiaoTotal.Value;
if (global::Helper.DateTimeParse.DateTimeEquls(this.dateAcInvoiceXOBillDate.DateTime, new DateTime()))
{
this._acInvoiceXoBill.AcInvoiceXOBillDate = global::Helper.DateTimeParse.NullDate;
}
else
{
this._acInvoiceXoBill.AcInvoiceXOBillDate = this.dateAcInvoiceXOBillDate.DateTime;
}
if (this.action == "insert")
{
Model.AcInvoiceXOBill last = this._acInvoiceXoBillManager.GetLast();
if (this._acInvoiceXoBill.AcInvoiceXOBillDate < last.AcInvoiceXOBillDate.Value.Date)
{
throw new Helper.MessageValueException("發票日期不能小於上笔日期");
}
}
else if (this.action == "update")
{
if (this._acInvoiceXoBill.AcInvoiceXOBillDate < this._acInvoiceXoBillManager.SelectLastDate(this._acInvoiceXoBill.InsertTime.Value).Date)
{
throw new Helper.MessageValueException("發票日期不能小於上笔日期");
}
}
//if (global::Helper.DateTimeParse.DateTimeEquls(this.dateForYSDate.DateTime, new DateTime()))
// this._acInvoiceXoBill.YSDate = global::Helper.DateTimeParse.NullDate;
//else
// this._acInvoiceXoBill.YSDate = this.dateForYSDate.DateTime;
this._acInvoiceXoBill.AcInvoiceXOBillDesc = this.memoAcInvoiceXOBillDesc.Text;
this._acInvoiceXoBill.Employee = this.newChooseEmployeeId.EditValue as Model.Employee;
if (this._acInvoiceXoBill.Employee != null)
{
this._acInvoiceXoBill.EmployeeId = this._acInvoiceXoBill.Employee.EmployeeId;
}
this._acInvoiceXoBill.Employee0 = this.newChooseEmployee0Id.EditValue as Model.Employee;
if (this._acInvoiceXoBill.Employee0 != null)
{
this._acInvoiceXoBill.Employee0Id = this._acInvoiceXoBill.Employee0.EmployeeId;
}
// this._acInvoiceXoBill.Employee1 = this.newChooseEmployee1Id.EditValue as Model.Employee;
// if (this._acInvoiceXoBill.Employee1 != null)
// this._acInvoiceXoBill.Employee1Id = this._acInvoiceXoBill.Employee1.EmployeeId;
this._acInvoiceXoBill.InvoiceStatus = 1;
if (!this.gridView1.PostEditor() || !this.gridView1.UpdateCurrentRow())
{
return;
}
switch (this.action)
{
case "insert":
this._acInvoiceXoBillManager.Insert(this._acInvoiceXoBill);
break;
case "update":
this._acInvoiceXoBillManager.Update(this._acInvoiceXoBill);
break;
}
}
public void Delete(Model.AcInvoiceXOBill acInvoiceXoBill)
{
sqlmapper.Delete("AcInvoiceXOBillDetail.delete_detail_AcinvoiceXoBilID", acInvoiceXoBill.AcInvoiceXOBillId);
}
public IList <Model.AcInvoiceXOBillDetail> SelectByAcInvoiceXOBill(Model.AcInvoiceXOBill acInvoiceXoBill)
{
return(sqlmapper.QueryForList <Model.AcInvoiceXOBillDetail>("AcInvoiceXOBillDetail.selectByAcInvoiceXOBill", acInvoiceXoBill.AcInvoiceXOBillId));
}
public Model.AcInvoiceXOBill GetPrev(Model.AcInvoiceXOBill e)
{
return(sqlmapper.QueryForObject <Model.AcInvoiceXOBill>("AcInvoiceXOBill.get_prev", e));
}
