/// <summary>
/// Update a ProformaInvoice.
/// </summary>
public void Update(Model.ProformaInvoice proformaInvoice)
{
//
// todo: add other logic here.
//
Validate(proformaInvoice);
try
{
BL.V.BeginTransaction();
proformaInvoice.UpdateTime = DateTime.Now;
accessor.Update(proformaInvoice);
detailAccessor.DeleteByHeader(proformaInvoice.PO);
foreach (var item in proformaInvoice.Details)
{
item.ProformaInvoiceId = proformaInvoice.PO;
detailAccessor.Insert(item);
}
BL.V.CommitTransaction();
}
catch (Exception ex)
{
BL.V.RollbackTransaction();
throw ex;
}
}
/// <summary>
/// Insert a ProformaInvoice.
/// </summary>
public void Insert(Model.ProformaInvoice proformaInvoice)
{
//
// todo:add other logic here
//
Validate(proformaInvoice);
if (ExistsPrimary(proformaInvoice.PO))
{
throw new Helper.MessageValueException(string.Format("已存在相同的PO：{0}", proformaInvoice.PO));
}
try
{
BL.V.BeginTransaction();
proformaInvoice.InsertTime = DateTime.Now;
proformaInvoice.UpdateTime = DateTime.Now;
accessor.Insert(proformaInvoice);
foreach (var item in proformaInvoice.Details)
{
item.ProformaInvoiceId = proformaInvoice.PO;
detailAccessor.Insert(item);
}
BL.V.CommitTransaction();
}
catch (Exception ex)
{
BL.V.RollbackTransaction();
throw ex;
}
}
protected override void AddNew()
{
this.proformaInvoice = new Book.Model.ProformaInvoice();
proformaInvoice.InvoiceDate = DateTime.Now;
this.action = "insert";
}
protected override void MoveLast()
{
if (this.LastFlag == 1)
{
this.LastFlag = 0;
return;
}
this.proformaInvoice = this.proformaInvoiceManager.GetLast();
}
protected override void MoveNext()
{
Model.ProformaInvoice model = this.proformaInvoiceManager.GetNext(this.proformaInvoice);
if (model == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this.proformaInvoice = model;
}
public Model.ProformaInvoice GetDetail(string id)
{
Model.ProformaInvoice model = this.Get(id);
if (model != null)
{
model.Details = detailAccessor.SelectByHeader(id);
}
return(model);
}
protected override Form GetViewForm()
{
Model.ProformaInvoice invoice = this.SelectedItem as Model.ProformaInvoice;
if (invoice != null)
{
return(new EditFormProformaInvoice(invoice.PO));
}
return(null);
}
public ROProformaInvoice(Model.ProformaInvoice invoice)
{
InitializeComponent();
this.DataSource = invoice.Details;
//lbl_CompanyName.Text = BL.Settings.CompanyChineseName;
this.lbl_PO.Text = invoice.PO;
//this.lbl_InvoiceDate.Text = invoice.InvoiceDate.Value.ToString("yyyy-MM-dd");
this.lbl_InvoiceDate.Text = invoice.InvoiceDate.Value.ToString("MMM-dd-yyyy", CultureInfo.CreateSpecificCulture("en-GB"));
this.lbl_CustomerName.Text = invoice.Customer.CustomerFullName;
this.lbl_CustomerAddress.Text = invoice.Customer.CustomerAddress;
this.lbl_CustomerTel.Text = invoice.Customer.CustomerPhone;
this.lbl_PaymentTerm.Text = invoice.Customer.PayCondition;
this.lbl_Attn.Text = invoice.Attn;
this.lbl_CustomerPONo.Text = invoice.CustomerPONo;
this.lbl_SalesRep.Text = invoice.SalesRep;
this.lbl_TotalEnglish.Text = invoice.TotalEnglish;
this.lbl_GoodsReadyDate.Text = invoice.GOODSREADYDATE;
this.lbl_CountryOfOrigin.Text = invoice.COUNTRYOFORIGIN;
if (!string.IsNullOrEmpty(invoice.BankId))
{
Model.Bank bank = new BL.BankManager().Get(invoice.BankId);
if (bank != null)
{
this.lbl_BankName.Text = bank.BankName;
this.lbl_BankAddress.Text = bank.BankAddress;
this.lbl_BankTel.Text = bank.BankPhone;
this.lbl_BankFax.Text = bank.Fax;
this.lbl_SWIFTCode.Text = bank.SWIFTCode;
this.lbl_AccountNo.Text = bank.Id;
}
}
this.lbl_CustomerSign.Text = invoice.Customer.CustomerFullName;
string currencySign = invoice.Currency + Model.ExchangeRate.GetCurrencySignByENName(invoice.Currency);
currencySign = (string.IsNullOrEmpty(currencySign) ? "USD$" : currencySign) + " ";
if (invoice.Details != null && invoice.Details.Count > 0)
{
this.TC_TotalQty.Text = invoice.Details.Sum(P => P.Quantity).Value.ToString("N0");
this.TC_TotalAmount.Text = currencySign + invoice.Details.Sum(D => D.Amount).Value.ToString("N3");
}
TC_ItemCode.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id);
TC_Desc.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
TC_Qty.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_Quantity, "{0:N0}");
TC_UnitPrice.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_UnitPrice, currencySign + "{0:N3}");
TC_Amount.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_Amount, currencySign + "{0:N3}");
}
public ROProformaInvoice(Model.ProformaInvoice invoice)
{
InitializeComponent();
this.DataSource = invoice.Details;
this.lbl_PO.Text = invoice.PO;
//this.lbl_InvoiceDate.Text = invoice.InvoiceDate.Value.ToString("yyyy-MM-dd");
this.lbl_InvoiceDate.Text = invoice.InvoiceDate.Value.ToString("MMM-dd-yyyy", CultureInfo.CreateSpecificCulture("en-GB"));
this.lbl_CustomerName.Text = invoice.Customer.CustomerFullName;
this.lbl_CustomerAddress.Text = invoice.Customer.CustomerAddress;
this.lbl_DeliveryTO.Text = invoice.DeliveryTo;
this.lbl_Tel.Text = invoice.Customer.CustomerPhone;
this.lbl_Attn.Text = invoice.Attn;
this.lbl_Term.Text = invoice.Customer.TradingCondition;
this.lbl_PINO.Text = invoice.PO;
this.lbl_Currency.Text = invoice.Currency;
this.lbl_Remark.Text = invoice.Remark;
this.lbl_DeliveryDate.Text = invoice.DeliveryDate;
this.lbl_PaymentTerm.Text = invoice.Customer.PayCondition;
if (!string.IsNullOrEmpty(invoice.BankId))
{
Model.Bank bank = new BL.BankManager().Get(invoice.BankId);
if (bank != null)
{
this.lbl_AccountName.Text = bank.Description;
this.lbl_AccountNo.Text = bank.Id;
this.lbl_BankName.Text = bank.BankName;
this.lbl_BankAddress.Text = bank.BankAddress;
this.lbl_SWIFTCode.Text = bank.SWIFTCode;
}
}
this.lbl_ShippingMark.Text = invoice.ShippimgMark;
this.lbl_CustomerSign.Text = invoice.Customer.CustomerFullName;
string currencySign = this.GetCurrencyCode(invoice.Currency) + " ";
if (invoice.Details != null && invoice.Details.Count > 0)
{
this.TC_TotalQty.Text = invoice.Details.Sum(P => P.Quantity).Value.ToString("N0");
this.TC_TotalUnit.Text = invoice.Details[0].Unit;
this.TC_TotalAmount.Text = currencySign + invoice.Details.Sum(D => D.Amount).Value.ToString("N2");
}
TC_No.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_Number);
TC_ItemCode.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName);
TC_Desc.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
TC_Qty.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_Quantity, "{0:N0}");
TC_Unit.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_Unit);
TC_UnitPrice.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_UnitPrice, currencySign + "{0:0.00}");
TC_Amount.DataBindings.Add("Text", this.DataSource, Model.ProformaInvoiceDetail.PRO_Amount, currencySign + "{0:N2}");
}
public EditFormProformaInvoice(Model.ProformaInvoice invoice)
: this()
{
if (invoice == null)
{
throw new ArithmeticException("invoiceid");
}
this.proformaInvoice = invoice;
this.action = "view";
if (this.action == "view")
{
LastFlag = 1;
}
}
int LastFlag = 0; //页面载 入时是否执行 last方法
public EditFormProformaInvoice(string invoiceId)
: this()
{
this.proformaInvoice = this.proformaInvoiceManager.Get(invoiceId);
if (this.proformaInvoice == null)
{
throw new ArithmeticException("invoiceid");
}
this.action = "view";
if (this.action == "view")
{
LastFlag = 1;
}
}
private void Validate(Model.ProformaInvoice model)
{
if (string.IsNullOrEmpty(model.PO))
{
throw new Helper.RequireValueException(Model.ProformaInvoice.PRO_PO);
}
if (model.InvoiceDate == null)
{
throw new Helper.RequireValueException(Model.ProformaInvoice.PRO_InvoiceDate);
}
if (string.IsNullOrEmpty(model.CustomerId))
{
throw new Helper.RequireValueException(Model.ProformaInvoice.PRO_CustomerId);
}
}
protected override void TurnNull()
{
if (this.proformaInvoice == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
this.proformaInvoiceManager.Delete(this.proformaInvoice.PO);
this.proformaInvoice = this.proformaInvoiceManager.GetNext(this.proformaInvoice);
if (this.proformaInvoice == null)
{
this.proformaInvoice = this.proformaInvoiceManager.GetLast();
}
}
}
public void Update(Model.ProformaInvoice e)
{
this.Update <Model.ProformaInvoice>(e);
}
public bool HasRowsBefore(Model.ProformaInvoice e)
{
return(accessor.HasRowsBefore(e));
}
protected override void MoveFirst()
{
this.proformaInvoice = this.proformaInvoiceManager.GetFirst();
}
public bool HasRowsAfter(Model.ProformaInvoice e)
{
return(accessor.HasRowsAfter(e));
}
public override void Refresh()
{
if (this.proformaInvoice == null)
{
this.AddNew();
}
else
{
if (this.action == "view") //打印時去掉PLTNO，修改時刷新一下顯示出來
{
this.proformaInvoice = this.proformaInvoiceManager.GetDetail(this.proformaInvoice.PO);
}
}
this.txt_PONo.Text = this.proformaInvoice.PO;
this.Date_InvoiceDate.EditValue = this.proformaInvoice.InvoiceDate;
this.ncc_Customer.EditValue = this.proformaInvoice.Customer;
if (this.ncc_Customer.EditValue != null)
{
this.txt_CustomerAddress.Text = this.proformaInvoice.Customer.CustomerAddress;
this.txt_Tel.Text = this.proformaInvoice.Customer.CustomerPhone;
this.txt_Attn.Text = this.proformaInvoice.Customer.CustomerContact;
this.txt_PaymentTerm.Text = this.proformaInvoice.Customer.PayCondition;
}
else
{
this.txt_CustomerAddress.Text = "";
this.txt_Tel.Text = "";
this.txt_Attn.Text = "";
this.txt_PaymentTerm.Text = "";
}
this.txt_Attn.Text = this.proformaInvoice.Attn;
this.lue_AccountName.EditValue = this.proformaInvoice.BankId;
this.txt_CustomerPONo.Text = this.proformaInvoice.CustomerPONo;
this.txt_SalesRep.Text = this.proformaInvoice.SalesRep;
this.txt_TotalEnglish.Text = this.proformaInvoice.TotalEnglish;
this.txt_GoodsReadyDate.Text = this.proformaInvoice.GOODSREADYDATE;
this.txt_CountryOfOrigin.Text = this.proformaInvoice.COUNTRYOFORIGIN;
switch (this.action)
{
case "insert":
this.gridView3.OptionsBehavior.Editable = true;
break;
case "update":
this.gridView3.OptionsBehavior.Editable = true;
break;
default:
this.gridView3.OptionsBehavior.Editable = false;
break;
}
this.bindingSourceDetail.DataSource = this.proformaInvoice.Details;
base.Refresh();
if (this.action == "update")
{
this.txt_PONo.Properties.ReadOnly = true;
}
}
public Model.ProformaInvoice GetPrev(Model.ProformaInvoice e)
{
return(accessor.GetPrev(e));
}
public Model.ProformaInvoice GetPrev(Model.ProformaInvoice e)
{
return(sqlmapper.QueryForObject <Model.ProformaInvoice>("ProformaInvoice.get_prev", e));
}
public Model.ProformaInvoice GetNext(Model.ProformaInvoice e)
{
return(sqlmapper.QueryForObject <Model.ProformaInvoice>("ProformaInvoice.get_next", e));
}
public bool HasRowsAfter(Model.ProformaInvoice e)
{
return(sqlmapper.QueryForObject <bool>("ProformaInvoice.has_rows_after", e));
}
public bool HasRowsBefore(Model.ProformaInvoice e)
{
return(sqlmapper.QueryForObject <bool>("ProformaInvoice.has_rows_before", e));
}
public Model.ProformaInvoice GetNext(Model.ProformaInvoice e)
{
return(accessor.GetNext(e));
}
public void Insert(Model.ProformaInvoice e)
{
this.Insert <Model.ProformaInvoice>(e);
}
public override void Refresh()
{
if (this.proformaInvoice == null)
{
this.AddNew();
}
else
{
if (this.action == "view") //打印時去掉PLTNO，修改時刷新一下顯示出來
{
this.proformaInvoice = this.proformaInvoiceManager.GetDetail(this.proformaInvoice.PO);
}
}
this.txt_PONo.Text = this.proformaInvoice.PO;
this.Date_InvoiceDate.EditValue = this.proformaInvoice.InvoiceDate;
this.ncc_Customer.EditValue = this.proformaInvoice.Customer;
if (this.ncc_Customer.EditValue != null)
{
this.txt_CustomerAddress.Text = this.proformaInvoice.Customer.CustomerAddress;
this.txt_Tel.Text = this.proformaInvoice.Customer.CustomerPhone;
this.txt_Attn.Text = this.proformaInvoice.Customer.CustomerContact;
this.txt_TERM.Text = this.proformaInvoice.Customer.TradingCondition;
this.txt_PaymentTerm.Text = this.proformaInvoice.Customer.PayCondition;
}
else
{
this.txt_CustomerAddress.Text = "";
this.txt_Tel.Text = "";
this.txt_Attn.Text = "";
this.txt_TERM.Text = "";
this.txt_PaymentTerm.Text = "";
}
this.txt_DeliveryTo.EditValue = this.proformaInvoice.DeliveryTo;
this.txt_Attn.Text = this.proformaInvoice.Attn;
this.cob_Currency.Text = this.proformaInvoice.Currency;
this.txt_Remark.Text = this.proformaInvoice.Remark;
this.txt_Deliverydate.Text = this.proformaInvoice.DeliveryDate;
this.lue_AccountName.EditValue = this.proformaInvoice.BankId;
this.me_ShippimgMark.Text = this.proformaInvoice.ShippimgMark;
switch (this.action)
{
case "insert":
this.gridView3.OptionsBehavior.Editable = true;
break;
case "update":
this.gridView3.OptionsBehavior.Editable = true;
break;
default:
this.gridView3.OptionsBehavior.Editable = false;
break;
}
this.bindingSourceDetail.DataSource = this.proformaInvoice.Details;
base.Refresh();
if (this.action == "update")
{
this.txt_PONo.Properties.ReadOnly = true;
}
}
