public IList<KitAssembly> Select(KitAssembly data, int showRegs) { IList<KitAssembly> datos = new List<KitAssembly>(); /* datos = GetHsql(data).List<KitAssembly>(); if (!Factory.IsTransactional) Factory.Commit(); return datos; */ try { if (showRegs > 0) datos = GetHsql(data).SetMaxResults(showRegs).List<KitAssembly>(); else datos = GetHsql(data).List<KitAssembly>(); if (!Factory.IsTransactional) Factory.Commit(); } catch (Exception e) { NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e)); } return datos; }
public void UpdateKitAssembly(KitAssembly data) { Factory.DaoKitAssembly().Update(data); }
public void DeleteKitAssembly(KitAssembly data) { Factory.DaoKitAssembly().Delete(data); }
public KitAssembly SaveKitAssembly(KitAssembly data) { return Factory.DaoKitAssembly().Save(data); }
public IList<KitAssembly> GetKitAssembly(KitAssembly data, int showRegs) { return Factory.DaoKitAssembly().Select(data, showRegs); }
private IList<KitAssembly> GetKitAssembly(string sWhere) { //retorna la lista de Kits Headers try { Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString); Query = " select DISTINCT KIT_CODE 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<KitAssembly> list = new List<KitAssembly>(); Status status = WType.GetStatus(new Status { StatusID = EntityStatus.Active }); KitAssembly tmpData = null; foreach (DataRow dr in ds.Tables[0].Rows) { try { //Map Properties tmpData = new KitAssembly(); tmpData.Product = WType.GetProduct(new Product { Company = CurCompany, ProductCode = dr["KIT_CODE"].ToString() }); ; tmpData.Unit = tmpData.Product.BaseUnit; tmpData.AsmType = 2; tmpData.Status = status; tmpData.EfectiveDate = DateTime.Now; tmpData.ObsoleteDate = DateTime.Now; tmpData.IsFromErp = true; list.Add(tmpData); } catch (Exception ex) { try { ExceptionMngr.WriteEvent("GetKitAssembly:" + tmpData.Product.ProductCode, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); } catch { } //return null; } } return list; } catch (Exception ex) { ExceptionMngr.WriteEvent("GetKitAssembly Connection", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); return null; } }
public Boolean Delete(KitAssembly data) { return base.Delete(data); }
public KitAssembly SelectById(KitAssembly data) { return (KitAssembly)base.SelectById(data); }
public Boolean Update(KitAssembly data) { return base.Update(data); }
public KitAssembly Save(KitAssembly data) { return (KitAssembly)base.Save(data); }
private IList<KitAssembly> GetKitAssembly(string sWhere) { //retorna la lista de Kits Headers try { Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString); // BM00101 - KitAssemblyHeader //DataSet ds = ReturnDataSet("SELECT * FROM BM00101 WHERE Bill_Status = 1 A", sWhere, "BM00101", Command.Connection); DataSet ds = ReturnDataSet("select b.* from BM00101 b LEFT OUTER JOIN SY03900 s ON s.NOTEINDX = b.NOTEINDX WHERE CAST(ISNULL(TXTFIELD,'') AS VARCHAR(50)) <> 'NOTINWMS'", sWhere, "BM00101", Command.Connection); if (ds == null || ds.Tables.Count == 0) return null; List<KitAssembly> list = new List<KitAssembly>(); Status status = WType.GetStatus(new Status { StatusID = EntityStatus.Active }); KitAssembly tmpData = null; foreach (DataRow dr in ds.Tables[0].Rows) { try { //Map Properties tmpData = new KitAssembly(); tmpData.Product = WType.GetProduct(new Product { Company = CurCompany, ProductCode = dr["ITEMNMBR"].ToString() }); ; tmpData.Unit = WType.GetUnit(new Unit { ErpCode = dr["UOFM"].ToString(), ErpCodeGroup = tmpData.Product.BaseUnit.ErpCodeGroup }); tmpData.AsmType = 2; tmpData.Status = status; tmpData.EfectiveDate = DateTime.Parse(dr["Effective_Date"].ToString()); tmpData.ObsoleteDate = DateTime.Parse(dr["Obsolete_Date"].ToString()); tmpData.IsFromErp = true; list.Add(tmpData); } catch (Exception ex) { try { ExceptionMngr.WriteEvent("GetKitAssembly:" + tmpData.Product.ProductCode, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); } catch { } //return null; } } return list; } catch (Exception ex) { ExceptionMngr.WriteEvent("GetKitAssembly Connection", ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); return null; } }
private void ProcessKitAssembly(IList<KitAssembly> list, Company company) { if (list == null) return; KitAssembly curRecord = null; foreach (KitAssembly e in list) { try { curRecord = new KitAssembly(); curRecord.Product = e.Product; //Evalua si el elemento ya existe IList<KitAssembly> exList = Factory.DaoKitAssembly().Select(curRecord,0); e.ModDate = DateTime.Now; e.ModifiedBy = WmsSetupValues.SystemUser; if (exList.Count == 0) { e.CreatedBy = WmsSetupValues.SystemUser; e.CreationDate = DateTime.Now; Factory.DaoKitAssembly().Save(e); } else { e.RowID = exList.First().RowID; e.CreatedBy = exList.First().CreatedBy; e.CreationDate = exList.First().CreationDate; Factory.DaoKitAssembly().Update(e); } //Elimna las formulas para ese producto y las crea de nuevo foreach (KitAssemblyFormula kaf in Factory.DaoKitAssemblyFormula() .Select(new KitAssemblyFormula { KitAssembly = new KitAssembly { Product = new Product { ProductID = e.Product.ProductID } } })) Factory.DaoKitAssemblyFormula().Delete(kaf); //Procesa el assembly Formula que le corresponde // CAA [2010/07/19] // condición busqueda kit padre string query = ""; switch (company.ErpConnection.ConnectionType.RowID) { case CnnType.GPeConnect: query = " ITEMNMBR = '" + e.Product.ProductCode + "' "; break; case CnnType.Everest: query = " KIT_CODE = '" + e.Product.ProductCode + "' "; break; case CnnType.UnoEE: query = " (formula.f134_id_cia = " + e.Product.Company.ErpCode + ") AND itmPadre.f120_id = '" + e.Product.ProductCode + "'"; break; default: query = ""; break; } ProcessKitAssemblyFormula(ErpFactory.References().GetKitAssemblyFormula(query)); } catch (Exception ex) { //Factory.Rollback(); ExceptionMngr.WriteEvent("ProcessKitAssembly:" + curRecord.Product.ProductCode, ListValues.EventType.Fatal, ex, null, ListValues.ErrorCategory.Business); //throw; } } }
public KitAssembly GetKitAssembly(KitAssembly data) { return Factory.DaoKitAssembly().Select(data,0).First(); }