public void UpdateDepotOutState(Model.ProduceMaterial produceMaterial)
{
//
// todo: add other logic here.
//
accessor.Update(produceMaterial);
}
public void Delete(Model.ProduceMaterial produceMaterial)
{
//
// todo:add other logic here
//
//已分配
try
{
BL.V.BeginTransaction();
Model.ProduceMaterial produceMaterialOld = this.GetDetails(produceMaterial.ProduceMaterialID);
foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterialOld.Details)
{
produceMaterialdetails.Product = productManager.Get(produceMaterialdetails.ProductId);
produceMaterialdetails.Product.ProduceMaterialDistributioned = (produceMaterialdetails.Product.ProduceMaterialDistributioned == null ? 0 : produceMaterialdetails.Product.ProduceMaterialDistributioned) - (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum) + (produceMaterialdetails.Materialprocesedsum == null ? 0 : produceMaterialdetails.Materialprocesedsum);
productManager.update(produceMaterialdetails.Product);
}
this.Delete(produceMaterial.ProduceMaterialID);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public void Insert(Model.ProduceMaterial produceMaterial)
{
//
// todo:add other logic here
//
Validate(produceMaterial);
try
{
BL.V.BeginTransaction();
produceMaterial.InsertTime = produceMaterial.InsertTime == null ? DateTime.Now : produceMaterial.InsertTime;
produceMaterial.UpdateTime = DateTime.Now;
TiGuiExists(produceMaterial);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceMaterial.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceMaterial.InsertTime.Value.Year, produceMaterial.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceMaterial.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(produceMaterial);
foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterial.Details)
{
if (produceMaterialdetails.Product == null || string.IsNullOrEmpty(produceMaterialdetails.Product.ProductId))
{
throw new Exception("Product can not be empty");
}
produceMaterialdetails.ProduceMaterialID = produceMaterial.ProduceMaterialID;
Model.Product product = productManager.Get(produceMaterialdetails.ProductId);
//已分配
produceMaterialdetails.Distributioned = (product.OtherMaterialDistributioned == null ? 0 : product.OtherMaterialDistributioned) + (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + Convert.ToDouble(produceMaterialdetails.Materialprocessum);
// produceMaterialdetails.Materialprocesedsum = produceMaterialdetails.Materialprocessum + produceMaterialdetails.Materialprocessum;
ProduceMaterialdetailsAccessor.Insert(produceMaterialdetails);
product.ProduceMaterialDistributioned = (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum);
productManager.update(product);
//物料需求领料描述
Model.MRSdetails mrsdetail;
if (produceMaterialdetails.MRSdetailsId != null)
{
mrsdetail = new BL.MRSdetailsManager().Get(produceMaterialdetails.MRSdetailsId);
if (mrsdetail != null)
{
mrsdetail.MaterialDesc = "Generated material requisition";
new BL.MRSdetailsManager().Update(mrsdetail);
}
}
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
protected override Book.UI.Settings.BasicData.BaseEditForm GetEditForm(object[] args)
{
Type type = typeof(EditForm);
Model.ProduceMaterial model = (this.manager as BL.ProduceMaterialManager).Get((args[0] as Model.ProduceMaterialdetails) == null ? null : (args[0] as Model.ProduceMaterialdetails).ProduceMaterialID);
args[0] = model;
return((EditForm)type.Assembly.CreateInstance(type.FullName, false, System.Reflection.BindingFlags.CreateInstance, null, args, null, null));
}
public Model.ProduceMaterial GetDetails(string produceMaterialID)
{
Model.ProduceMaterial produceMaterial = accessor.Get(produceMaterialID);
if (produceMaterial != null)
{
produceMaterial.Details = ProduceMaterialdetailsAccessor.Select(produceMaterial);
}
return(produceMaterial);
}
private void xrSubreport1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
Q50_1 reportProducts = this.xrSubreport1.ReportSource as Q50_1;
Model.ProduceMaterial material = this.GetCurrentRow() as Model.ProduceMaterial;
if (material != null)
{
material.Details = this.detailManager.SelectByProductIdAndHeadId(this.MaterialCondidtion.Product0, this.MaterialCondidtion.Product1, material.ProduceMaterialID);
reportProducts.ProduceMaterial = material;
}
}
private void Validate(Model.ProduceMaterial produceMaterial)
{
if (string.IsNullOrEmpty(produceMaterial.ProduceMaterialID))
{
throw new Helper.RequireValueException(Model.ProduceMaterial.PRO_ProduceMaterialID);
}
if (string.IsNullOrEmpty(produceMaterial.WorkHouseId))
{
throw new Helper.RequireValueException(Model.ProduceMaterial.PRO_WorkHouseId);
}
}
public void Insert(Model.ProduceMaterial produceMaterial)
{
//
// todo:add other logic here
//
Validate(produceMaterial);
try
{
BL.V.BeginTransaction();
produceMaterial.InsertTime = produceMaterial.InsertTime == null ? DateTime.Now : produceMaterial.InsertTime;
produceMaterial.UpdateTime = DateTime.Now;
TiGuiExists(produceMaterial);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceMaterial.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceMaterial.InsertTime.Value.Year, produceMaterial.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceMaterial.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(produceMaterial);
foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterial.Details)
{
if (produceMaterialdetails.Product == null || string.IsNullOrEmpty(produceMaterialdetails.Product.ProductId))
{
throw new Exception("貨品不為空");
}
produceMaterialdetails.ProduceMaterialID = produceMaterial.ProduceMaterialID;
Model.Product product = productManager.Get(produceMaterialdetails.ProductId);
//已分配
produceMaterialdetails.Distributioned = (product.OtherMaterialDistributioned == null ? 0 : product.OtherMaterialDistributioned) + (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + produceMaterialdetails.Materialprocessum;
// produceMaterialdetails.Materialprocesedsum = produceMaterialdetails.Materialprocessum + produceMaterialdetails.Materialprocessum;
ProduceMaterialdetailsAccessor.Insert(produceMaterialdetails);
product.ProduceMaterialDistributioned = (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum);
productManager.update(product);
//if (product.ProduceMaterialDistributioned + product.OtherMaterialDistributioned > product.StocksQuantity)
//{
// throw new Helper.MessageValueException(product.ProductName + " ," + "領料數量大於未分配數量");
//}
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
this._produceMaterial = this.bindingSourceProduceMaterial.Current as Model.ProduceMaterial;
if (this._produceMaterial != null)
{
list = this._produceMaterialdetailsManager.SelectByState(this._produceMaterial);
this.bindingSourceProduceMaterialDetails.DataSource = list;
}
else
{
this.bindingSourceProduceMaterialDetails.DataSource = null;
}
}
private void gridView1_ColumnFilterChanged(object sender, EventArgs e)
{
this._produceMaterial = this.bindingSourceProduceMaterial.Current as Model.ProduceMaterial;
if (this._produceMaterial != null)
{
list = this._produceMaterialdetailsManager.SelectByState(this._produceMaterial);
this.bindingSourceProduceMaterialDetails.DataSource = list;
}
else
{
this.bindingSourceProduceMaterialDetails.DataSource = null;
}
}
public void Update(Model.ProduceMaterial produceMaterial)
{
//
// todo: add other logic here.
//
Validate(produceMaterial);
if (produceMaterial != null)
{
//this.Delete(produceMaterial);
//produceMaterial.UpdateTime = DateTime.Now;
//this.Insert(produceMaterial);
UpdateAndInsert(produceMaterial);
}
}
public void Delete(string produceMaterialID)
{
//
// todo:add other logic here
//
Model.ProduceMaterial model = this.Get(produceMaterialID);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, model.InsertTime.Value.ToString("yyyy-MM-dd"));
SequenceManager.Decrement(sequencekey_d);
accessor.Delete(produceMaterialID);
}
public void Update(Model.ProduceMaterial produceMaterial)
{
//
// todo: add other logic here.
//
Validate(produceMaterial);
if (produceMaterial != null)
{
//this.Delete(produceMaterial);
////produceMaterial.UpdateTime = DateTime.Now;
//this.Insert(produceMaterial);
//旧方法会导致在修改的时候如果先删除了旧单据新增新单据时出错，旧单据则无法找回
UpdateAndInsert(produceMaterial);
}
}
private void TiGuiExists(Model.ProduceMaterial model)
{
if (this.ExistsPrimary(model.ProduceMaterialID))
{
//设置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.ProduceMaterialID = this.GetId(model.InsertTime.Value);
TiGuiExists(model);
//throw new Helper.InvalidValueException(Model.Product.PRO_Id);
}
}
public void Delete(Model.ProduceMaterial produceMaterial)
{
//
// todo:add other logic here
//
//已分配
try
{
BL.V.BeginTransaction();
Model.ProduceMaterial produceMaterialOld = this.GetDetails(produceMaterial.ProduceMaterialID);
foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterialOld.Details)
{
produceMaterialdetails.Product = productManager.Get(produceMaterialdetails.ProductId);
produceMaterialdetails.Product.ProduceMaterialDistributioned = (produceMaterialdetails.Product.ProduceMaterialDistributioned == null ? 0 : produceMaterialdetails.Product.ProduceMaterialDistributioned) - (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum) + (produceMaterialdetails.Materialprocesedsum == null ? 0 : produceMaterialdetails.Materialprocesedsum);
productManager.update(produceMaterialdetails.Product);
//更新该单据之后单据的已分配量
IList <Model.ProduceMaterialdetails> pdlist = ProduceMaterialdetailsAccessor.SelectForDistributioned(produceMaterialdetails.ProductId, produceMaterialdetails.ProduceMaterial.InsertTime.Value);
foreach (var item in pdlist)
{
item.Distributioned = Convert.ToDouble(item.Distributioned) - Convert.ToDouble(produceMaterialdetails.Materialprocessum) + Convert.ToDouble(produceMaterialdetails.Materialprocesedsum);
item.Distributioned = item.Distributioned < 0 ? 0 : item.Distributioned;
ProduceMaterialdetailsAccessor.Update(item);
}
}
this.Delete(produceMaterial.ProduceMaterialID);
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public void _Update(Model.ProduceMaterial produceMaterial)
{
accessor.Update(produceMaterial);
}
private void UpdateAndInsert(Model.ProduceMaterial produceMaterial)
{
try
{
BL.V.BeginTransaction();
//删除旧单据
Model.ProduceMaterial produceMaterialOld = this.GetDetails(produceMaterial.ProduceMaterialID);
foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterialOld.Details)
{
produceMaterialdetails.Product = productManager.Get(produceMaterialdetails.ProductId);
produceMaterialdetails.Product.ProduceMaterialDistributioned = (produceMaterialdetails.Product.ProduceMaterialDistributioned == null ? 0 : produceMaterialdetails.Product.ProduceMaterialDistributioned) - (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum) + (produceMaterialdetails.Materialprocesedsum == null ? 0 : produceMaterialdetails.Materialprocesedsum);
productManager.update(produceMaterialdetails.Product);
}
this.Delete(produceMaterial.ProduceMaterialID);
//新增单据
produceMaterial.InsertTime = produceMaterial.InsertTime == null ? DateTime.Now : produceMaterial.InsertTime;
produceMaterial.UpdateTime = DateTime.Now;
TiGuiExists(produceMaterial);
string invoiceKind = this.GetInvoiceKind().ToLower();
string sequencekey_y = string.Format("{0}-y-{1}", invoiceKind, produceMaterial.InsertTime.Value.Year);
string sequencekey_m = string.Format("{0}-m-{1}-{2}", invoiceKind, produceMaterial.InsertTime.Value.Year, produceMaterial.InsertTime.Value.Month);
string sequencekey_d = string.Format("{0}-d-{1}", invoiceKind, produceMaterial.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(produceMaterial);
foreach (Model.ProduceMaterialdetails produceMaterialdetails in produceMaterial.Details)
{
if (produceMaterialdetails.Product == null || string.IsNullOrEmpty(produceMaterialdetails.Product.ProductId))
{
throw new Exception("貨品不為空");
}
produceMaterialdetails.ProduceMaterialID = produceMaterial.ProduceMaterialID;
Model.Product product = productManager.Get(produceMaterialdetails.ProductId);
//已分配
produceMaterialdetails.Distributioned = (product.OtherMaterialDistributioned == null ? 0 : product.OtherMaterialDistributioned) + (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + Convert.ToDouble(produceMaterialdetails.Materialprocessum);
// produceMaterialdetails.Materialprocesedsum = produceMaterialdetails.Materialprocessum + produceMaterialdetails.Materialprocessum;
ProduceMaterialdetailsAccessor.Insert(produceMaterialdetails);
product.ProduceMaterialDistributioned = (product.ProduceMaterialDistributioned == null ? 0 : product.ProduceMaterialDistributioned) + (produceMaterialdetails.Materialprocessum == null ? 0 : produceMaterialdetails.Materialprocessum);
productManager.update(product);
////物料需求领料描述
//Model.MRSdetails mrsdetail;
//if (produceMaterialdetails.MRSdetailsId != null)
//{
// mrsdetail = new BL.MRSdetailsManager().Get(produceMaterialdetails.MRSdetailsId);
// if (mrsdetail != null)
// {
// mrsdetail.MaterialDesc = "已生成領料單";
// new BL.MRSdetailsManager().Update(mrsdetail);
// }
//}
//if (product.ProduceMaterialDistributioned + product.OtherMaterialDistributioned > product.StocksQuantity)
//{
// throw new Helper.MessageValueException(product.ProductName + " ," + "領料數量大於未分配數量");
//}
}
BL.V.CommitTransaction();
}
catch
{
BL.V.RollbackTransaction();
throw;
}
}
public IList <Book.Model.ProduceMaterialdetails> SelectByState(Model.ProduceMaterial produceMaterial)
{
return(sqlmapper.QueryForList <Model.ProduceMaterialdetails>("ProduceMaterialdetails.select_byState", produceMaterial.ProduceMaterialID));
}
public RO(string produceMaterialID)
{
InitializeComponent();
this.produceMaterial = this.produceMaterialManager.Get(produceMaterialID);
if (this.produceMaterial == null)
{
return;
}
if (this.produceMaterial.SourceType == 0)
{
Model.PronoteHeader pheader = ph.Get(produceMaterial.InvoiceId);
if (pheader != null)
{
this.xrLabelProduct.Text = string.IsNullOrEmpty(pheader.Product.CustomerProductName) ? pheader.Product.ProductName : pheader.Product.ProductName + "{" + pheader.Product.CustomerProductName + "}";
this.xrLabelInvoiceSum.Text = pheader.InvoiceXODetailQuantity == null ? null : pheader.InvoiceXODetailQuantity.ToString();
}
}
this.produceMaterial.Details = this.produceMaterialdetailsManager.Select(this.produceMaterial);
this.DataSource = this.produceMaterial.Details;
//CompanyInfo
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelDataName.Text = Properties.Resources.ProduceMaterialdetails;
//加工领料
this.xrLabelProduceMaterialDate.Text = this.produceMaterial.ProduceMaterialDate.Value.ToString("yyyy-MM-dd");
this.xrBarCodeProduceMaterialID.Text = this.produceMaterial.ProduceMaterialID;
this.xrLabelInsertTime.Text = DateTime.Now.ToString("yyyy-MM-dd");
if (this.produceMaterial.SourceType == 1)
{
this.xrLabelSourceType.Text = "需求計劃";
}
else
{
this.xrLabelSourceType.Text = "生產加工";
}
this.xrLabelPronoteHeaderID.Text = this.produceMaterial.InvoiceId;
// this.xrLabelMRP.Text=this.produceMaterial.
//if (this.produceMaterial.Employee1 != null)
//{
// this.xrLabelEmployee1.Text = this.produceMaterial.Employee1.EmployeeName;
//}
if (this.produceMaterial.Employee0 != null)
{
this.xrLabelEmployee0.Text = this.produceMaterial.Employee0.EmployeeName;
}
if (this.produceMaterial.AuditEmp != null)
{
this.xrLabelEmployee2.Text = this.produceMaterial.AuditEmp.EmployeeName;
}
if (this.produceMaterial.WorkHouse != null)
{
this.xrLabelDepartment.Text = this.produceMaterial.WorkHouse.Workhousename;
}
this.xrLabel1ProduceMaterialdesc.Text = this.produceMaterial.ProduceMaterialdesc;
this.xrLabelProduceMaterialId.Text = this.produceMaterial.ProduceMaterialID;
//if (this.produceMaterial.InvoiceXO != null)
//{
// this.xrLabelXOId.Text = invoiceXoManager.Get(this.produceMaterial.InvoiceXO)==null?"":invoiceXoManager.Get(this.produceMaterial.InvoiceXO).CustomerInvoiceXOId;
//}
//if (this.produceMaterial.SourceType != 1 && !string.IsNullOrEmpty(this.produceMaterial.InvoiceId))
//{
// Model.MRSdetails mrsdetail = new Book.Model.MRSdetails();
// Model.PronoteHeader pronoteHeader = new BL.PronoteHeaderManager().Get(this.produceMaterial.InvoiceId);
// if (pronoteHeader != null)
// {
// mrsdetail = new BL.MRSdetailsManager().Get(pronoteHeader.MRSdetailsId);
// }
//Model.InvoiceXO invoiceXO = new BL.InvoiceXOManager().Get(produceMaterial.InvoiceXOId);
//if (invoiceXO != null)
//{
// this.xrLabelPiHao.Text = invoiceXO.CustomerLotNumber;
//}
//}
if (!string.IsNullOrEmpty(this.produceMaterial.InvoiceXOId))
{
Model.InvoiceXO invoiceXO = new BL.InvoiceXOManager().Get(produceMaterial.InvoiceXOId);
if (invoiceXO != null)
{
this.xrLabelXOId.Text = invoiceXO.CustomerInvoiceXOId;
this.xrLabelCustomer.Text = invoiceXO.xocustomer == null ? null : invoiceXO.xocustomer.ToString();
this.lblCustomerPH.Text = invoiceXO.CustomerLotNumber;
}
}
//明细
this.xrTableCell5.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Inumber);
//this.xrTableCell1ProductId.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_Id);
//this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.Pro_ProductNameWithVersion);
this.xrTableCusProName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName);
this.xrTableCellQuantity.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Materialprocessum);
//this.xrTableHasOutDepot.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Distributioned, "{0:0.####}");
// this.xrTableMPSSum.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_MPSDetailsSum, "{0:0.####}");
this.xrTableCellUnit.DataBindings.Add("Text", this.DataSource, "ProductUnit");
this.xrTableCellProductSpecification.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_StocksQuantity, "{0:0.####}");
this.xrTableCellPihao.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_Pihao);
// this.xrTableMRP.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_MRSHeaderId);
// this.xrTableCusXOID.DataBindings.Add("Text", this.DataSource, Model.ProduceMaterialdetails.PRO_CustomerInvoiceXOId);
this.TCNextWorkstation.DataBindings.Add("Text", this.DataSource, "NextWorkHouse." + Model.WorkHouse.PROPERTY_WORKHOUSENAME);
this.xrRichText1.DataBindings.Add("Rtf", this.DataSource, "ProductDescription");
}
public bool HasRowsAfter(Model.ProduceMaterial e)
{
return(accessor.HasRowsAfter(e));
}
public Model.ProduceMaterial GetNext(Model.ProduceMaterial e)
{
return(accessor.GetNext(e));
}
public Model.ProduceMaterial GetPrev(Model.ProduceMaterial e)
{
return(accessor.GetPrev(e));
}
public bool HasRowsAfter(Model.ProduceMaterial e)
{
return(sqlmapper.QueryForObject <bool>("ProduceMaterial.has_rows_after", e));
}
public Model.ProduceMaterial GetPrev(Model.ProduceMaterial e)
{
return(sqlmapper.QueryForObject <Model.ProduceMaterial>("ProduceMaterial.get_prev", e));
}
public bool HasRowsBefore(Model.ProduceMaterial e)
{
return(sqlmapper.QueryForObject <bool>("ProduceMaterial.has_rows_before", e));
}
public IList <Book.Model.ProduceMaterialdetails> SelectByState(Model.ProduceMaterial produceMaterial)
{
return(accessor.SelectByState(produceMaterial));
}
public void Update(Model.ProduceMaterial e)
{
this.Update <Model.ProduceMaterial>(e);
}
public Model.ProduceMaterial GetNext(Model.ProduceMaterial e)
{
return(sqlmapper.QueryForObject <Model.ProduceMaterial>("ProduceMaterial.get_next", e));
}
public OutStockReport(string DepotOutId)
{
InitializeComponent();
this.DepotOut = this.DepotOutManager.Get(DepotOutId);
if (this.DepotOut == null)
{
return;
}
this.DepotOut.Details = this.DepotOutDetailManager.GetDepotOutDetailByDepotOutId(this.DepotOut.DepotOutId);
this.DataSource = this.DepotOut.Details;
//CompanyInfo
this.xrLabelCompanyInfoName.Text = BL.Settings.CompanyChineseName;
this.xrLabelDataName.Text = Properties.Resources.DepotOut;
this.xrLabelPrintDate.Text = "列表日期：" + DateTime.Now.ToShortDateString();
this.xrLabelDepotOutId.Text = this.DepotOut.DepotOutId;
this.xrLabelDepotOutDate.Text = this.DepotOut.DepotOutDate.Value.ToString("yyyy-MM-dd");
if (this.DepotOut.Employee != null)
{
this.xrLabelEmployeeId.Text = this.DepotOut.Employee.EmployeeName;
}
if (this.DepotOut.InvioiceEmployee0 != null)
{
this.xrLabelInvoiceEmp0.Text = this.DepotOut.InvioiceEmployee0.EmployeeName;
}
if (DepotOut.Depot != null)
{
this.xrLabelProduceInDepotId.Text = DepotOut.Depot.DepotName;
}
if (this.DepotOut.SourceType == "領料單")
{
Model.ProduceMaterial ProduceMaterial = this.produceMaterialManager.Get(this.DepotOut.InvioiceId);
if (ProduceMaterial != null)
{
//Model.PronoteHeader PronoteHeader = this.pronoteHeaderManager.Get(ProduceMaterial.InvoiceId);
//if (PronoteHeader != null)
//{
Model.InvoiceXO InvoiceXO = this.invoiceXOManager.Get(ProduceMaterial.InvoiceXOId);
if (InvoiceXO != null)
{
this.xrLabelCustomXoId.Text = InvoiceXO.CustomerInvoiceXOId;
this.lblPiHao.Text = InvoiceXO.CustomerLotNumber;
this.lblXOCustomer.Text = InvoiceXO.xocustomer == null ? null : InvoiceXO.xocustomer.ToString();
}
//if (ProduceMaterial.Employee0 != null)
// this.xrLabelInvoiceEmp0.Text = ProduceMaterial.Employee0.ToString();
if (ProduceMaterial.WorkHouse != null)
{
this.xrLabelWorkHouse.Text = ProduceMaterial.WorkHouse.ToString();
}
// }
}
}
else if (this.DepotOut.SourceType == "委外領料單")
{
Model.ProduceOtherMaterial ProduceOtherMaterial = new BL.ProduceOtherMaterialManager().Get(this.DepotOut.InvioiceId);
if (ProduceOtherMaterial != null)
{
Model.ProduceOtherCompact ProduceOtherCompact = this.produceOtherCompactManager.Get(ProduceOtherMaterial.ProduceOtherCompactId);
if (ProduceOtherCompact != null)
{
if (!string.IsNullOrEmpty(ProduceOtherCompact.MRSHeaderId))
{
Model.MRSHeader mRSHeader = this.mRSHeaderManager.Get(ProduceOtherCompact.MRSHeaderId);
if (mRSHeader != null)
{
Model.MPSheader mPSheader = this.mPSheaderManager.Get(mRSHeader.MPSheaderId);
if (mPSheader != null)
{
Model.InvoiceXO InvoiceXO = this.invoiceXOManager.Get(mPSheader.InvoiceXOId);
if (InvoiceXO != null)
{
this.xrLabelCustomXoId.Text = InvoiceXO.CustomerInvoiceXOId;
this.lblPiHao.Text = InvoiceXO.CustomerLotNumber;
this.lblXOCustomer.Text = InvoiceXO.xocustomer == null ? null : InvoiceXO.xocustomer.ToString();
}
}
}
}
}
if (ProduceOtherMaterial.WorkHouse != null)
{
this.xrLabelWorkHouse.Text = ProduceOtherMaterial.WorkHouse.ToString();
}
}
}
this.txt_ParentProduct.Text = DepotOut.ParentProduct;
this.xrLabelXqlu.Text = DepotOut.SourceType;
this.xrLabeldescription.Text = DepotOut.description;
this.xrLabelXgdj.Text = DepotOut.InvioiceId;
this.xrTableCellProductId.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_Inumber);
this.xrTableCellProductName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductName);
//this.xrTableCellXH.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_ProductSpecification);
this.xrTableCellCount.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_DepotOutDetailQuantity);
this.xrTableCellUnit.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_ProductUnit);
this.xrTableCurrentDepotStock.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_CurrentDepotQuantity);
this.xrTableCell_CurrentStock.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_CurrentStockQuantity);
this.xrTableCellDepotId.DataBindings.Add("Text", this.DataSource, "DepotPosition." + Model.DepotPosition.PROPERTY_ID);
//this.xrTableCellSafeStockQuantity.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.Pro_SafeStockQuantity);
this.TCPihao.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_Pihao);
this.xrRichText1.DataBindings.Add("Rtf", this.DataSource, Model.DepotOutDetail.Pro_ProductDescription);
//this.TCPihao.DataBindings.Add("Text", this.DataSource, Model.DepotOutDetail.PRO_Pihao);
this.TCProductCustomerName.DataBindings.Add("Text", this.DataSource, "Product." + Model.Product.PRO_CustomerProductName);
}
public bool HasRowsBefore(Model.ProduceMaterial e)
{
return(accessor.HasRowsBefore(e));
}
