public ProductEditForm(Model.InvoiceXJ invoicecj)
{
if (invoicecj == null)
{
throw new ArithmeticException("invoiceid");
}
this.invoice = invoicecj;
this.action = "update";
}
public Model.InvoiceXJ Get(string invoiceId)
{
Model.InvoiceXJ invoice = accessor.Get(invoiceId);
//invoice.Details = invoiceXJDetailAccessor.Select(invoice);
//invoiceXJDetailAccessor.getRecursiveInvoiceXJDetails(invoiceId);
invoice.DetailsProcess = _invoiceXJProcessManager.Select(invoice);
invoice.DetailPackage = _invoiceXJPackageDetailsManager.SelectByHeaderId(invoiceId);
return(invoice);
}
protected override void MovePrev()
{
Model.InvoiceXJ invoice = this.invoiceManager.GetPrev(this.invoice);
if (invoice == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this.invoice = this.invoiceManager.Get(invoice.InvoiceId);
}
public ProductEditForm(string invoiceId)
: this()
{
this.invoice = this.invoiceManager.Get(invoiceId);
if (this.invoice == null)
{
throw new ArithmeticException("invoiceid");
}
this.action = "update";
}
private void _Insert(Model.InvoiceXJ invoice)
{
_ValidateForInsert(invoice);
invoice.InsertTime = DateTime.Now;
invoice.UpdateTime = DateTime.Now;
invoice.Employee0Id = invoice.Employee0.EmployeeId;
invoice.CustomerId = invoice.Customer.CustomerId;
invoice.Employee1Id = null;
//过账人
invoice.Employee2Id = null;
//过账时间
invoice.InvoiceGZTime = DateTime.Now;
accessor.Insert(invoice);
//报价详细
foreach (Model.InvoiceXJDetail detail in invoice.Details)
{
detail.InvoiceId = invoice.InvoiceId;
detail.Customer = invoice.Customer;
if (detail.Customer != null)
{
detail.CustomerId = detail.Customer.CustomerId;
}
//detail.IsCustomerProduct = detail.Product.IsCustomerProduct;
_invoiceXJDetailManager.Insert(detail);
}
//加工
foreach (Model.InvoiceXJProcess detail in invoice.DetailsProcess)
{
detail.InvoiceXJProcessId = Guid.NewGuid().ToString();
detail.InvoiceXJId = invoice.InvoiceId;
detail.ProcessCategoryId = detail.ProcessCategory == null ? null : detail.ProcessCategory.ProcessCategoryId;
detail.ProductId = detail.Product == null ? null : detail.Product.ProductId;
//detail.SupplierId = detail.Supplier == null ? null : detail.Supplier.SupplierId;
_invoiceXJProcessManager.Insert(detail);
}
//包材
foreach (Model.InvoiceXJPackageDetails d in invoice.DetailPackage)
{
d.InvoiceXJPackageDetailsId = Guid.NewGuid().ToString();
d.InvoiceId = invoice.InvoiceId;
_invoiceXJPackageDetailsManager.Insert(d);
}
}
protected override void TurnNull()
{
if (this.invoice == null)
{
return;
}
if (MessageBox.Show(Properties.Resources.ConfirmToDelete, this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
this.invoiceManager.TurnNull(this.invoice.InvoiceId);
this.invoice = this.invoiceManager.GetNext(this.invoice);
if (this.invoice == null)
{
this.invoice = this.invoiceManager.GetLast();
}
}
protected override void AddNew()
{
this.invoice = new Model.InvoiceXJ();
this.invoice.InvoiceId = this.invoiceManager.GetNewId();
this.invoice.InvoiceDate = DateTime.Now;
this.invoice.Details = new List <Model.InvoiceXJDetail>();
this.invoice.InvoiceYxrq = DateTime.Now;
if (this.action == "insert")
{
Model.InvoiceXJDetail detail = new Model.InvoiceXJDetail();
detail.InvoiceXJDetailId = Guid.NewGuid().ToString();
detail.InvoiceXJDetailMoney = 0;
detail.InvoiceXJDetailNote = "";
detail.InvoiceXJDetailPrice = 0;
detail.InvoiceXJDetailQuantity = 1;
detail.InvoiceProductUnit = "";
detail.Product = new Book.Model.Product();
this.invoice.Details.Add(detail);
this.bindingSource1.Position = this.bindingSource1.IndexOf(detail);
}
}
private void Validate(Model.InvoiceXJ invoice)
{
if (string.IsNullOrEmpty(invoice.InvoiceId))
{
throw new Helper.RequireValueException("Id");
}
if (invoice.Employee0 == null)
{
throw new Helper.RequireValueException("Employee0");
}
if (invoice.Customer == null)
{
throw new Helper.RequireValueException("Company");
}
if (invoice.Details == null)
{
throw new Helper.RequireValueException("Details");
}
}
public IList <Model.InvoiceXJDetail> Select(Model.InvoiceXJ invoiceXJ)
{
return(accessor.Select(invoiceXJ));
}
public void Delete(Model.InvoiceXJ InvoiceXJ)
{
accessor.Delete(InvoiceXJ);
}
public IList <Book.Model.InvoiceXJProcess> Select(Model.InvoiceXJ InvoiceXJ)
{
return(accessor.Select(InvoiceXJ));
}
public Model.InvoiceXJ GetPrev(Model.InvoiceXJ e)
{
return(accessor.GetPrev(e));
}
public bool HasRowsAfter(Model.InvoiceXJ e)
{
return(accessor.HasRowsAfter(e));
}
protected override void gridView1_DoubleClick(object sender, EventArgs e)
{
this._invoicexj = this.bindingSource1.Current as Model.InvoiceXJ;
this.DialogResult = DialogResult.OK;
}
public void Insert(Model.InvoiceXJ e)
{
this.Insert <Model.InvoiceXJ>(e);
}
public void Update(Model.InvoiceXJ e)
{
this.Update <Model.InvoiceXJ>(e);
}
public bool HasRowsBefore(Model.InvoiceXJ e)
{
return(sqlmapper.QueryForObject <bool>("InvoiceXJ.has_rows_before", e));
}
public Model.InvoiceXJ GetPrev(Model.InvoiceXJ e)
{
return(sqlmapper.QueryForObject <Model.InvoiceXJ>("InvoiceXJ.get_prev", e));
}
public Model.InvoiceXJ GetNext(Model.InvoiceXJ e)
{
return(sqlmapper.QueryForObject <Model.InvoiceXJ>("InvoiceXJ.get_next", e));
}
public bool HasRowsAfter(Model.InvoiceXJ e)
{
return(sqlmapper.QueryForObject <bool>("InvoiceXJ.has_rows_after", e));
}
private void _Update(Model.InvoiceXJ invoice)
{
_ValidateForUpdate(invoice);
invoice.UpdateTime = DateTime.Now;
invoice.Employee0Id = invoice.Employee0.EmployeeId;
invoice.CustomerId = invoice.Customer.CustomerId;
Model.InvoiceXJ invoiceOriginal = this.Get(invoice.InvoiceId);
Helper.InvoiceStatus invoiceStatus = (Helper.InvoiceStatus)invoice.InvoiceStatus.Value;
switch ((Helper.InvoiceStatus)invoiceOriginal.InvoiceStatus)
{
case Helper.InvoiceStatus.Draft:
switch (invoiceStatus)
{
case Helper.InvoiceStatus.Draft:
accessor.Update(invoice);
//_invoiceXJDetailManager.Delete(invoice);
foreach (Model.InvoiceXJDetail detail in invoice.Details)
{
// if (detail.PrimaryKey == null || string.IsNullOrEmpty(detail.PrimaryKey.PrimaryKeyId)) continue;
if (detail.Product == null || string.IsNullOrEmpty(detail.Product.ProductId))
{
continue;
}
detail.InvoiceId = invoice.InvoiceId;
detail.InvoiceXJDetailId = Guid.NewGuid().ToString();
if (detail.Customer != null)
{
detail.CustomerId = detail.Customer.CustomerId;
}
detail.IsCustomerProduct = detail.Product.IsCustomerProduct;
_invoiceXJDetailManager.Insert(detail);
}
break;
case Helper.InvoiceStatus.Normal:
//_invoiceXJDetailManager.Delete(invoiceOriginal); //删除详细
_invoiceXJProcessManager.Delete(invoiceOriginal); //删除加工
_invoiceXJPackageDetailsManager.DeleteByHeader(invoiceOriginal.InvoiceId); //删除包材
accessor.Delete(invoiceOriginal.InvoiceId);
invoice.InsertTime = invoiceOriginal.InsertTime;
invoice.UpdateTime = DateTime.Now;
_Insert(invoice);
break;
case Helper.InvoiceStatus.Null:
throw new ArithmeticException();
}
break;
case Helper.InvoiceStatus.Normal:
switch (invoiceStatus)
{
case Helper.InvoiceStatus.Draft:
throw new InvalidOperationException();
case Helper.InvoiceStatus.Normal:
//_invoiceXJDetailManager.Delete(invoiceOriginal); //删除详细
_invoiceXJProcessManager.Delete(invoiceOriginal); //删除加工
_invoiceXJPackageDetailsManager.DeleteByHeader(invoiceOriginal.InvoiceId); //删除包材
accessor.Delete(invoiceOriginal.InvoiceId);
invoice.InsertTime = invoiceOriginal.InsertTime;
invoice.UpdateTime = DateTime.Now;
_Insert(invoice);
break;
case Helper.InvoiceStatus.Null:
break;
}
break;
case Helper.InvoiceStatus.Null:
throw new ArithmeticException();
}
}
private void _TurnNormal(Model.InvoiceXJ invoice)
{
invoice.InvoiceStatus = (int)Helper.InvoiceStatus.Normal;
_Update(invoice);
}
public void Delete(Model.InvoiceXJ InvoiceXJ)
{
sqlmapper.Delete("InvoiceXJProcess.delete_by_invoicexj", InvoiceXJ.InvoiceId);
}
public Model.InvoiceXJ GetNext(Model.InvoiceXJ e)
{
return(accessor.GetNext(e));
}
public IList <Book.Model.InvoiceXJProcess> Select(Model.InvoiceXJ InvoiceXJ)
{
return(sqlmapper.QueryForList <Model.InvoiceXJProcess>("InvoiceXJProcess.select_by_invoicexjid", InvoiceXJ.InvoiceId));
}
protected override void MoveLast()
{
this.invoice = this.invoiceManager.Get(this.invoiceManager.GetLast() == null ? "" : this.invoiceManager.GetLast().InvoiceId);
}
public R01(string invoiceid)
{
InitializeComponent();
this.invoice = this.invoiceCGManager.Get(invoiceid);
if (this.invoice == null)
{
return;
}
this.invoice.Details = this.invoiceCGDetailManager.Select(this.invoice);
this.DataSource = this.invoice.Details;
//CompanyInfo
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelData.Text = Properties.Resources.InvoiceXJ;
this.xrLabelPrintDate.Text += DateTime.Now.ToShortDateString();
Model.Company company = companyManager.Get(invoice.CompanyId);
if (company != null)
{
if (company.CompanyName != BL.Settings.CompanyChineseName)
{
this.xrLabelCompanyInfoName.Text = company.CompanyName;
}
this.xrLabelData.Text = Properties.Resources.InvoiceXJ;
}
//客户信息
this.xrLabelCustomName.Text = this.invoice.Customer.CustomerShortName;
this.xrLabelCustomFax.Text = this.invoice.Customer.CustomerFax;
this.xrLabelCustomTel.Text = string.IsNullOrEmpty(this.invoice.Customer.CustomerPhone) ? this.invoice.Customer.CustomerPhone1 : this.invoice.Customer.CustomerPhone;
this.xrLabelTongYiNo.Text = this.invoice.Customer.CustomerNumber;
//单据信息
this.xrLabelInvoiceDate.Text = this.invoice.InvoiceDate.Value.ToString("yyyy-MM-dd");
this.xrLabelInvoiceId.Text = this.invoice.InvoiceId;
this.xrLabelYeWuName.Text = this.invoice.Employee0.EmployeeName;
this.xrLabelTotal1.Text = this.invoice.InvoiceTotal.Value.ToString("F4");
this.xrLabelNote.Text = this.invoice.InvoiceNote;
if (this.invoice.AuditEmp != null)
{
this.lbl_AuditEmp.Text = this.invoice.AuditEmp.ToString();
}
////明细信息
//this.xrTableCellCustomerProductId.DataBindings.Add("Text", this.DataSource, "PrimaryKey." + Model.CustomerProducts.PROPERTY_CUSTOMERPRODUCTID);
//this.xrTableCellXingHao.DataBindings.Add("Text", this.DataSource, "PrimaryKey.Product." + Model.Product.PRO_ProductSpecification);
//this.xrTableCellProductUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PROPERTY_INVOICEPRODUCTUNIT);
//this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PROPERTY_INVOICEXJDETAILQUANTITY);
//this.xrTableCellUintPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PROPERTY_INVOICEXJDETAILPRICE, "{0:c0}");
//this.xrTableCellMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PROPERTY_INVOICEXJDETAILMONEY, "{0:c0}");
//this.xrTableCellCustomerProductName.DataBindings.Add("Text", this.DataSource, "PrimaryKey." + Model.CustomerProducts.PROPERTY_CUSTOMERPRODUCTNAME);
//this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, "PrimaryKey.Product." + Model.Product.PRO_Id);
//明细信息
this.xrTableCellCustomerProductId.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PRO_Inumber);
// this.xrTableCellXingHao.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification);
this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PRO_InvoiceXJDetailQuantity);
this.xrTableCellProductUnit.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PRO_InvoiceProductUnit);
this.xrTableCellUintPrice.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PRO_InvoiceXJDetailPrice, "{0:0.####}");
this.xrTableCellMoney.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PRO_InvoiceXJDetailMoney, "{0:0.####}");
this.xrTableCellCustomerProductName.DataBindings.Add("Text", this.DataSource, Model.InvoiceXJDetail.PRO_ProductName);
}
public override void Refresh()
{
if (this.invoice == null)
{
this.invoice = new Book.Model.InvoiceXJ();
this.action = "insert";
}
else
{
if (this.action == "view")
{
this.invoice = this.invoiceManager.Get(invoice.InvoiceId);
}
else
{
this.bindingSourceproduct.DataSource = this.ProductsManager.Select();
}
}
//if(tags==1)
//{
// this.colProduct.FieldName = "ProductId";
// DevExpress.XtraEditors.Controls.LookUpColumnInfo a = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Id");
// this.repositoryItemLookUpEdit1.Columns.Add(a);
// DevExpress.XtraEditors.Controls.LookUpColumnInfo a = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ProductName");
// this.repositoryItemLookUpEdit1.Columns.Add(a);
// DevExpress.XtraEditors.Controls.LookUpColumnInfo a=new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ProductId");
// this.repositoryItemLookUpEdit1.Columns.Add(a);
// a.Visible = false;
//}
this.textEditInvoiceId.EditValue = this.invoice.InvoiceId;
this.dateEditInvoiceDate.DateTime = this.invoice.InvoiceDate.Value;
this.buttonEditEmployee.EditValue = this.invoice.Employee0;
this.buttonEditCompany.EditValue = this.invoice.Customer;
//this.textEditAbstract.EditValue = this.invoice.InvoiceAbstract;
this.textEditNote.EditValue = this.invoice.InvoiceNote;
this.calcEditTotal.EditValue = this.invoice.InvoiceTotal;
this.dateEditInvoiceYxrq.EditValue = this.invoice.InvoiceYxrq;
this.bindingSource1.DataSource = this.invoice.Details;
switch (this.action)
{
case "insert":
this.textEditInvoiceId.Properties.ReadOnly = false;
this.dateEditInvoiceDate.Properties.ReadOnly = false;
this.dateEditInvoiceDate.Properties.Buttons[0].Visible = true;
// this.barButtonItemGeneral.Enabled = false;
//this.textEditAbstract.Properties.ReadOnly = false;
this.textEditNote.Properties.ReadOnly = false;
this.buttonEditCompany.ShowButton = true;
this.buttonEditEmployee.ShowButton = true;
this.buttonEditCompany.ButtonReadOnly = false;
this.buttonEditEmployee.ButtonReadOnly = false;
this.gridView1.OptionsBehavior.Editable = true;
this.simpleButtonAppend.Enabled = true;
this.simpleButtonRemove.Enabled = true;
break;
case "update":
this.textEditInvoiceId.Properties.ReadOnly = true;
this.dateEditInvoiceDate.Properties.ReadOnly = true;
this.dateEditInvoiceDate.Properties.Buttons[0].Visible = false;
// this.barButtonItemGeneral.Enabled = false;
//this.textEditAbstract.Properties.ReadOnly = false;
this.textEditNote.Properties.ReadOnly = false;
this.buttonEditCompany.ShowButton = true;
this.buttonEditEmployee.ShowButton = true;
this.buttonEditCompany.ButtonReadOnly = false;
this.buttonEditEmployee.ButtonReadOnly = false;
this.gridView1.OptionsBehavior.Editable = true;
this.simpleButtonAppend.Enabled = true;
this.simpleButtonRemove.Enabled = true;
break;
case "view":
this.textEditInvoiceId.Properties.ReadOnly = true;
this.dateEditInvoiceDate.Properties.ReadOnly = true;
this.dateEditInvoiceDate.Properties.Buttons[0].Visible = false;
//this.barButtonItemGeneral.Enabled = true;
//this.textEditAbstract.Properties.ReadOnly = true;
this.textEditNote.Properties.ReadOnly = true;
this.buttonEditCompany.ShowButton = false;
this.buttonEditEmployee.ShowButton = false;
this.buttonEditCompany.ButtonReadOnly = true;
this.buttonEditEmployee.ButtonReadOnly = true;
this.gridView1.OptionsBehavior.Editable = false;
this.simpleButtonAppend.Enabled = false;
this.simpleButtonRemove.Enabled = false;
break;
default:
break;
}
base.Refresh();
}
public ChooseProcessForm(Model.InvoiceXJDetail InvoiceXJDetail, Model.InvoiceXJ invoiceXJ) : this()
{
this._invoiceXJDetail = InvoiceXJDetail;
this._invoiceXJ = invoiceXJ;
}
public bool HasRowsBefore(Model.InvoiceXJ e)
{
return(accessor.HasRowsBefore(e));
}
