public IList<ProductAccountRelation> Select(ProductAccountRelation data) { IList<ProductAccountRelation> datos = new List<ProductAccountRelation>(); datos = GetHsql(data).List<ProductAccountRelation>(); if (!Factory.IsTransactional) Factory.Commit(); return datos; }
public override Boolean Equals(object obj) { if ((obj == null) || (obj.GetType() != this.GetType())) { return(false); } ProductAccountRelation castObj = (ProductAccountRelation)obj; return((castObj != null) && (this.RowID == castObj.RowID)); }
public void UpdateIsMainProductAccount(ProductAccountRelation data) { ProductAccountRelation pa = Factory.DaoProductAccountRelation().Select(data).First(); pa.IsDefault = data.IsDefault; if (data.IsDefault == true) { IList<ProductAccountRelation> list = Factory.DaoProductAccountRelation().Select( new ProductAccountRelation { Product = pa.Product }); foreach (ProductAccountRelation r in list.Where(f => f.RowID != pa.RowID)) { r.IsDefault = false; Factory.DaoProductAccountRelation().Update(r); } //Actulizando el Default del Producto Product p = Factory.DaoProduct().Select(new Product {ProductID = pa.Product.ProductID } ,0).First(); p.UpcCode = pa.Code1; p.DefVendorNumber = pa.ItemNumber; Factory.DaoProduct().Update(p); } Factory.DaoProductAccountRelation().Update(pa); }
public void UpdateIsMainProductAccount(ProductAccountRelation data) { BasicMngr.UpdateIsMainProductAccount(data); }
public void UpdateProductAccountRelation(ProductAccountRelation data) { Factory.DaoProductAccountRelation().Update(data); }
public void DeleteProductAccountRelation(ProductAccountRelation data) { Factory.DaoProductAccountRelation().Delete(data); }
public ProductAccountRelation SaveProductAccountRelation(ProductAccountRelation data) { return Factory.DaoProductAccountRelation().Save(data); }
public IList<ProductAccountRelation> GetProductAccountRelation(ProductAccountRelation data) { return Factory.DaoProductAccountRelation().Select(data); }
private IList<ProductAccountRelation> GetProductVendors(Product product) { IList<ProductAccountRelation> productVendor = new List<ProductAccountRelation>(); ProductAccountRelation curId = null; AccountType accType = WType.GetAccountType(new AccountType { AccountTypeID = AccntType.Vendor }); string curItemVendor = ""; try { Command.Connection = new SqlConnection(CurCompany.ErpConnection.CnnString); Query = "SELECT VEND_CODE,VENDOR_PART_NO " + " FROM ITEM_REPLENISH_VENDOR WHERE ITEM_CODE = '" + product.ProductCode+"' "; ds = ReturnDataSet(Query, null, "ITEM_REPLENISH_VENDOR", Command.Connection); if (ds == null || ds.Tables.Count == 0) return null; foreach (DataRow dr in ds.Tables[0].Rows) { curId = new ProductAccountRelation(); curId.ItemNumber = dr["VENDOR_PART_NO"].ToString(); //Si esta vacio se sale al proximo if (string.IsNullOrEmpty(curId.ItemNumber)) continue; curItemVendor = dr["VEND_CODE"].ToString() + ":" + curId.ItemNumber; curId.IsFromErp = true; curId.AccountType = accType; curId.Account = WType.GetAccount(new Account { AccountCode = dr["VEND_CODE"].ToString(), BaseType = new AccountType { AccountTypeID = AccntType.Vendor } }); curId.Product = product; curId.CreatedBy = WmsSetupValues.SystemUser; curId.CreationDate = DateTime.Now; productVendor.Add(curId); } return productVendor; } catch (Exception ex) { ExceptionMngr.WriteEvent("GetProductVendors:" + curItemVendor, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); //throw; return null; } }
private IList<ProductAccountRelation> GetProductVendors(Product product) { IList<ProductAccountRelation> productVendor = new List<ProductAccountRelation>(); ProductAccountRelation curId = null; AccountType accType = WType.GetAccountType(new AccountType { AccountTypeID = 2 }); string curItemVendor = ""; try { //Ask for the vendor Item record string sWhere = " ITEMNMBR = '" + product.ProductCode + "'"; ds = DynamicsGP_ec.GetDataSet(DynamicsGP_ec.RetreiveData("VendorItem", false, 2, 0, sWhere, true)); if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[1].Rows) { curId = new ProductAccountRelation(); curId.ItemNumber = dr["VNDITNUM"].ToString(); //Si esta vacio se sale al proximo if (string.IsNullOrEmpty(curId.ItemNumber)) continue; curItemVendor = dr["VENDORID"].ToString() + ":" + curId.ItemNumber; curId.IsFromErp = true; curId.AccountType = accType; curId.Account = WType.GetAccount(new Account { AccountCode = dr["VENDORID"].ToString(), BaseType = new AccountType { AccountTypeID = AccntType.Vendor } }); curId.Product = product; curId.CreatedBy = WmsSetupValues.SystemUser; curId.CreationDate = DateTime.Now; productVendor.Add(curId); } } return productVendor; } catch (Exception ex) { ExceptionMngr.WriteEvent("GetProductVendors:" + curItemVendor, ListValues.EventType.Error, ex, null, ListValues.ErrorCategory.ErpConnection); //throw; return null; } }
private void ProcessProducts(IList<Product> list) { if (list == null) return; Product qProd = null; UnitProductRelation curUnit; ProductTrackRelation curRecord; ProductAccountRelation curPvendor; foreach (Product e in list) { try { qProd = new Product(); qProd.Company = e.Company; qProd.ProductCode = e.ProductCode; //Evalua si el elemento ya existe IList<Product> exList = Factory.DaoProduct().Select(qProd,0); e.ModDate = DateTime.Now; e.ModifiedBy = WmsSetupValues.SystemUser; if (exList.Count == 0) { e.CreationDate = DateTime.Now; e.CreatedBy = WmsSetupValues.SystemUser; Factory.DaoProduct().Save(e); } else { e.ProductID = exList.First().ProductID; e.CreatedBy = exList.First().CreatedBy; e.CreationDate = exList.First().CreationDate; //Otros datos del producto que deben preservarse e.UpcCode = exList.First().UpcCode; e.Reference = exList.First().Reference; e.Manufacturer = exList.First().Manufacturer; e.IsBinRestricted = exList.First().IsBinRestricted; e.Comment = exList.First().Comment; //e.AlternateCode1 = exList.First().AlternateCode1; //e.AlternateCode2 = exList.First().AlternateCode2; e.PrintLabel = exList.First().PrintLabel; e.UnitsPerPack = exList.First().UnitsPerPack; e.PickMethod = exList.First().PickMethod; e.DefaultTemplate = exList.First().DefaultTemplate; e.DefVendorNumber = exList.First().DefVendorNumber; //Evaluar los UnitRelations int i = 0; foreach (UnitProductRelation line in e.ProductUnits) { curUnit = new UnitProductRelation(); curUnit.Product = line.Product; curUnit.UnitErpCode = line.UnitErpCode; curUnit.Unit = line.Unit; IList<UnitProductRelation> listLines = Factory.DaoUnitProductRelation().Select(curUnit); if (listLines.Count > 0) { e.ProductUnits[i].RowID = listLines.First().RowID; e.ProductUnits[i].CreationDate = listLines.First().CreationDate; e.ProductUnits[i].CreatedBy = listLines.First().CreatedBy; e.ProductUnits[i].ModDate = DateTime.Now; e.ProductUnits[i].ModifiedBy = WmsSetupValues.SystemUser; } else { e.ProductUnits[i].CreationDate = DateTime.Now; e.ProductUnits[i].CreatedBy = WmsSetupValues.SystemUser; } i++; } //Evaluar los ProductTrackOptions if (e.ProductTrack != null) { int y = 0; foreach (ProductTrackRelation line in e.ProductTrack) { curRecord = new ProductTrackRelation(); curRecord.Product = line.Product; curRecord.TrackOption = line.TrackOption; IList<ProductTrackRelation> trackLines = Factory.DaoProductTrackRelation().Select(curRecord); if (trackLines.Count > 0) { e.ProductTrack[y].RowID = trackLines.First().RowID; e.ProductTrack[y].CreationDate = trackLines.First().CreationDate; e.ProductTrack[y].CreatedBy = trackLines.First().CreatedBy; e.ProductTrack[y].ModDate = DateTime.Now; e.ProductTrack[y].ModifiedBy = WmsSetupValues.SystemUser; } else { e.ProductTrack[y].CreationDate = DateTime.Now; e.ProductTrack[y].CreatedBy = WmsSetupValues.SystemUser; } y++; } } //Evaluar los ProductVendor try { IList<ProductAccountRelation> pAlt = Factory.DaoProductAccountRelation() .Select(new ProductAccountRelation { IsFromErp = true, Product = new Product { ProductID = e.ProductID } }); ; if (pAlt != null && pAlt.Count > 0) foreach (ProductAccountRelation pax in pAlt) Factory.DaoProductAccountRelation().Delete(pax); } catch { } if (e.ProductAccounts != null) { int y = 0; foreach (ProductAccountRelation line in e.ProductAccounts) { curPvendor = new ProductAccountRelation(); curPvendor.Product = line.Product; curPvendor.Account = line.Account; curPvendor.ItemNumber = line.ItemNumber; IList<ProductAccountRelation> pVendLines = Factory.DaoProductAccountRelation().Select(curPvendor); if (pVendLines.Count > 0) { e.ProductAccounts[y].RowID = pVendLines.First().RowID; e.ProductAccounts[y].CreationDate = pVendLines.First().CreationDate; e.ProductAccounts[y].CreatedBy = pVendLines.First().CreatedBy; e.ProductAccounts[y].ModDate = DateTime.Now; e.ProductAccounts[y].ModifiedBy = WmsSetupValues.SystemUser; } else { e.ProductAccounts[y].CreationDate = DateTime.Now; e.ProductAccounts[y].CreatedBy = WmsSetupValues.SystemUser; } y++; } } //Evaluar los ProductAlternate //ProductAlternate curAlt; /* try { IList<ProductAlternate> pAlt = Factory.DaoProductAlternate() .Select(new ProductAlternate { IsFromErp = true, Product = new Product { ProductID = e.ProductID } }); if (pAlt != null && pAlt.Count > 0) foreach (ProductAlternate pax in pAlt) try { Factory.DaoProductAlternate().Delete(pax); } catch (Exception ex) { Console.WriteLine("PA:" + ex.Message); } } catch { } */ if (e.AlternProducts != null) { int y = 0; foreach (ProductAlternate line in e.AlternProducts) { e.AlternProducts[y].CreationDate = DateTime.Now; e.AlternProducts[y].CreatedBy = WmsSetupValues.SystemUser; y++; try { ProductAlternate exist = Factory.DaoProductAlternate() .Select(new ProductAlternate { AlternProduct = new Product { ProductID = line.AlternProduct.ProductID }, Product = new Product { ProductID = e.ProductID } }).First(); Factory.DaoProductAlternate().Delete(exist); } catch { } //curAlt = new ProductAlternate(); //curAlt.Product = line.Product; //curAlt.AlternProduct = line.AlternProduct; } } Factory.DaoProduct().Update(e); } } catch (Exception ex) { //Factory.Rollback(); ExceptionMngr.WriteEvent("ProcessProducts:" + qProd.ProductCode, ListValues.EventType.Fatal, ex, null, ListValues.ErrorCategory.Business); ////throw; } } }
public ProductAccountRelation SelectById(ProductAccountRelation data) { return (ProductAccountRelation)base.SelectById(data); }
public Boolean Delete(ProductAccountRelation data) { return base.Delete(data); }
public Boolean Update(ProductAccountRelation data) { return base.Update(data); }
public ProductAccountRelation Save(ProductAccountRelation data) { return (ProductAccountRelation)base.Save(data); }