public IList <KitAssemblyFormula> Select(KitAssemblyFormula data) { IList <KitAssemblyFormula> datos = new List <KitAssemblyFormula>(); datos = GetHsql(data).List <KitAssemblyFormula>(); if (!Factory.IsTransactional) { Factory.Commit(); } return(datos); }
private void OnSaveComponent(object sender, EventArgs e) { string message = ""; if (View.TxtComponent.Product.ProductID == 0 || string.IsNullOrEmpty(View.TxtQty.Text) || string.IsNullOrEmpty(View.TxtOrder.Text)) { Util.ShowError("Product, Quantity and Order are required."); return; } else // valida que ya no exista como componente del KIT. { // if (View.Model.Record.ProductFormula.Where(f => f.Component.ProductID == View.TxtComponent.Product.ProductID).Count() >0) if (service.GetKitAssemblyFormula(new KitAssemblyFormula { KitAssembly = new KitAssembly { Product = View.Model.Record.Product } }).Where(f => f.Component.ProductID == View.TxtComponent.Product.ProductID).Count() > 0) { Util.ShowError("Component is already in the kit."); return; } } try { KitAssemblyFormula kaf = new KitAssemblyFormula(); kaf.KitAssembly = View.Model.Record; kaf.Component = View.TxtComponent.Product; kaf.DirectProduct = View.Model.Record.Product; kaf.Unit = View.TxtComponent.Product.BaseUnit; kaf.Ord = int.Parse(View.TxtOrder.Text); kaf.Status = new Status { StatusID = EntityStatus.Active }; kaf.FormulaQty = float.Parse(View.TxtQty.Text); kaf.ScrapPercent = 0; kaf.EfectiveDate = DateTime.Now; kaf.ObsoleteDate = DateTime.Now; kaf.CreationDate = DateTime.Now; kaf.CreatedBy = App.curUser.UserName; message = "Record created."; View.Model.FormulaList.Add(service.SaveKitAssemblyFormula(kaf)); // View.Model.Record.ProductFormula.Add View.LvFormula.Items.Refresh(); CleanComponentSection(); Util.ShowMessage(message); } catch (Exception ex) { Util.ShowError(ex.Message); } }
private void ProcessKitAssemblyFormula(IList <KitAssemblyFormula> list) { if (list == null) { return; } KitAssemblyFormula curRecord = null; foreach (KitAssemblyFormula e in list) { try { curRecord = e; //Evalua si el elemento ya existe IList <KitAssemblyFormula> exList = Factory.DaoKitAssemblyFormula().Select(e); e.ModDate = DateTime.Now; e.ModifiedBy = WmsSetupValues.SystemUser; if (exList.Count == 0) { e.CreatedBy = WmsSetupValues.SystemUser; e.CreationDate = DateTime.Now; Factory.DaoKitAssemblyFormula().Save(e); } else { e.RowID = exList.First().RowID; e.CreatedBy = exList.First().CreatedBy; e.CreationDate = exList.First().CreationDate; Factory.DaoKitAssemblyFormula().Update(e); } } catch (Exception ex) { Factory.Rollback(); ExceptionMngr.WriteEvent("ProcessKitAssemblyFormula:" + curRecord.KitAssembly.Product.ProductCode, ListValues.EventType.Fatal, ex, null, ListValues.ErrorCategory.Business); //throw; } } }
public override IQuery GetHsql(Object data) { StringBuilder sql = new StringBuilder("select a from KitAssemblyFormula a where "); KitAssemblyFormula kitasm = (KitAssemblyFormula)data; if (kitasm != null) { Parms = new List <Object[]>(); if (kitasm.RowID != 0) { sql.Append(" a.RowID = :id and "); Parms.Add(new Object[] { "id", kitasm.RowID }); } if (kitasm.KitAssembly != null) { if (kitasm.KitAssembly.RowID != 0) { sql.Append(" a.KitAssembly.RowID = :id1 and "); Parms.Add(new Object[] { "id1", kitasm.KitAssembly.RowID }); } if (kitasm.KitAssembly.Product != null && kitasm.KitAssembly.Product.ProductID != 0) { sql.Append(" a.KitAssembly.Product.ProductID = :idp1 and "); Parms.Add(new Object[] { "idp1", kitasm.KitAssembly.Product.ProductID }); } if (kitasm.KitAssembly.Product != null && !string.IsNullOrEmpty(kitasm.KitAssembly.Product.ProductCode)) { sql.Append(" a.KitAssembly.Product.ProductCode = :idpc and "); Parms.Add(new Object[] { "idpc", kitasm.KitAssembly.Product.ProductCode }); } } if (kitasm.DirectProduct != null) { if (kitasm.DirectProduct.ProductID != 0) { sql.Append(" a.DirectProduct.ProductID = :ipz1 and "); Parms.Add(new Object[] { "ipz1", kitasm.DirectProduct.ProductID }); } if (kitasm.DirectProduct.Category != null && kitasm.DirectProduct.Category.ExplodeKit != 0) { sql.Append(" a.DirectProduct.Category.ExplodeKit = :ih1 and "); Parms.Add(new Object[] { "ih1", kitasm.DirectProduct.Category.ExplodeKit }); } } if (kitasm.Component != null && kitasm.Component.ProductID != 0) { sql.Append(" a.Component.ProductID = :id2 and "); Parms.Add(new Object[] { "id2", kitasm.Component.ProductID }); } if (kitasm.Status != null && kitasm.Status.StatusID != 0) { sql.Append(" a.Status.StatusID = :id3 and "); Parms.Add(new Object[] { "id3", kitasm.Status.StatusID }); } if (kitasm.Unit != null && kitasm.Unit.UnitID != 0) { sql.Append(" a.Unit.UnitID = :id4 and "); Parms.Add(new Object[] { "id4", kitasm.Unit.UnitID }); } if (kitasm.ObsoleteDate != null) { sql.Append(" a.ObsoleteDate = :id5 and "); Parms.Add(new Object[] { "id5", kitasm.ObsoleteDate }); } if (kitasm.EfectiveDate != null) { sql.Append(" a.EfectiveDate = :id6 and "); Parms.Add(new Object[] { "id6", kitasm.EfectiveDate }); } } sql = new StringBuilder(sql.ToString()); sql.Append(" 1=1 order by a.RowID asc "); IQuery query = Factory.Session.CreateQuery(sql.ToString()); SetParameters(query); return(query); }
public KitAssemblyFormula SelectById(KitAssemblyFormula data) { return((KitAssemblyFormula)base.SelectById(data)); }
public Boolean Delete(KitAssemblyFormula data) { return(base.Delete(data)); }
public Boolean Update(KitAssemblyFormula data) { return(base.Update(data)); }
public KitAssemblyFormula Save(KitAssemblyFormula data) { return((KitAssemblyFormula)base.Save(data)); }
public void DeleteKitAssemblyFormula(KitAssemblyFormula data) { try { SetService(); SerClient.DeleteKitAssemblyFormula(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public KitAssemblyFormula SaveKitAssemblyFormula(KitAssemblyFormula data) { try { SetService(); return SerClient.SaveKitAssemblyFormula(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public IList <KitAssemblyFormula> GetKitAssemblyFormula(string sWhere) { //retorna la lista de Formulas. KitAssemblyFormula tmpData = null; try { Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString); // BM00101 - KitAssemblyHeader DataSet ds = ReturnDataSet("SELECT * FROM BM00111 WHERE Bill_Status = 1 AND Component_Status=1 ", sWhere, "BM00111", Command.Connection); if (ds == null || ds.Tables.Count == 0) { return(null); } List <KitAssemblyFormula> list = new List <KitAssemblyFormula>(); Status statusOK = WType.GetStatus(new Status { StatusID = EntityStatus.Active }); Status statusInactive = WType.GetStatus(new Status { StatusID = EntityStatus.Inactive }); foreach (DataRow dr in ds.Tables[0].Rows) { try { //Map Properties tmpData = new KitAssemblyFormula(); tmpData.KitAssembly = WType.GetKitAssembly(new KitAssembly { Product = new Product { Company = CurCompany, ProductCode = dr["ITEMNMBR"].ToString() } }); tmpData.Status = (dr["Component_Status"].ToString() == "1") ? statusOK : statusInactive; tmpData.EfectiveDate = DateTime.Parse(dr["Effective_Date"].ToString()); tmpData.ObsoleteDate = DateTime.Parse(dr["Obsolete_Date"].ToString()); tmpData.Component = WType.GetProduct(new Product { Company = CurCompany, ProductCode = dr["CMPTITNM"].ToString() }); tmpData.Unit = WType.GetUnit(new Unit { ErpCode = dr["UOFM"].ToString(), ErpCodeGroup = tmpData.Component.BaseUnit.ErpCodeGroup }); tmpData.FormulaQty = Double.Parse(dr["Design_Qty"].ToString());; tmpData.Ord = int.Parse(dr["ORD"].ToString());; tmpData.ScrapPercent = Double.Parse(dr["Scrap_Percentage"].ToString()); tmpData.DirectProduct = WType.GetProduct(new Product { Company = CurCompany, ProductCode = dr["ITEMNMBR"].ToString() }); list.Add(tmpData); } catch (Exception ex) { ExceptionMngr.WriteEvent("GetKitAssemblyFormula:" + tmpData.KitAssembly.Product.ProductCode + ", " + tmpData.Component.ProductCode, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); return(null); } } return(list); } catch (Exception ex) { ExceptionMngr.WriteEvent("GetKitAssemblyFormula:", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); return(null); } }
public IList <KitAssemblyFormula> GetKitAssemblyFormula(string sWhere) { //retorna la lista de Formulas. KitAssemblyFormula tmpData = null; try { Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString); Query = "select KIT_CODE, ITEM_CODE, ITEM_QTY from X_KIT WHERE DESC_TYPE=1 "; DataSet ds = ReturnDataSet(Query, sWhere, "X_KIT", Command.Connection); if (ds == null || ds.Tables.Count == 0) { return(null); } List <KitAssemblyFormula> list = new List <KitAssemblyFormula>(); Status statusOK = WType.GetStatus(new Status { StatusID = EntityStatus.Active }); Status statusInactive = WType.GetStatus(new Status { StatusID = EntityStatus.Inactive }); foreach (DataRow dr in ds.Tables[0].Rows) { try { //Map Properties tmpData = new KitAssemblyFormula(); tmpData.KitAssembly = WType.GetKitAssembly(new KitAssembly { Product = new Product { Company = CurCompany, ProductCode = dr["KIT_CODE"].ToString() } }); tmpData.Status = statusOK; tmpData.EfectiveDate = DateTime.Now; tmpData.ObsoleteDate = DateTime.Now; tmpData.Component = WType.GetProduct(new Product { Company = CurCompany, ProductCode = dr["ITEM_CODE"].ToString() }); tmpData.Unit = tmpData.Component.BaseUnit; tmpData.FormulaQty = Double.Parse(dr["ITEM_QTY"].ToString());; tmpData.Ord = 1; tmpData.ScrapPercent = 0; tmpData.DirectProduct = WType.GetProduct(new Product { Company = CurCompany, ProductCode = dr["KIT_CODE"].ToString() }); list.Add(tmpData); } catch (Exception ex) { ExceptionMngr.WriteEvent("GetKitAssemblyFormula:" + tmpData.KitAssembly.Product.ProductCode + ", " + tmpData.Component.ProductCode, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); return(null); } } return(list); } catch (Exception ex) { ExceptionMngr.WriteEvent("GetKitAssemblyFormula:", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); return(null); } }