public IList<KitAssemblyFormula> Select(KitAssemblyFormula data) { IList<KitAssemblyFormula> datos = new List<KitAssemblyFormula>(); datos = GetHsql(data).List<KitAssemblyFormula>(); if (!Factory.IsTransactional) Factory.Commit(); return datos; }
public void UpdateKitAssemblyFormula(KitAssemblyFormula data) { Factory.DaoKitAssemblyFormula().Update(data); }
public void DeleteKitAssemblyFormula(KitAssemblyFormula data) { Factory.DaoKitAssemblyFormula().Delete(data); }
public KitAssemblyFormula SaveKitAssemblyFormula(KitAssemblyFormula data) { return Factory.DaoKitAssemblyFormula().Save(data); }
public IList<KitAssemblyFormula> GetKitAssemblyFormula(KitAssemblyFormula data) { return Factory.DaoKitAssemblyFormula().Select(data); }
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; } }
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 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); }