private void MapPurBodyRowAndModel(DataRow dr, PurchaseBodyModel m) { m.Code = dr["TD002"].ToString(); m.Category = dr["TD001"].ToString(); m.DeliveredCount = dr["TD015"].ToString().ToDouble(); m.ProductID = dr["TD004"].ToString(); m.ProductName = dr["TD005"].ToString(); m.ProductSpecify = dr["TD006"].ToString(); m.PurchaseAmmount = dr["TD011"].ToString(); m.PurchaseCount = dr["TD008"].ToString().ToDouble(); m.PurchaseUnit = dr["TD010"].ToString(); m.Warehouse = dr["TD007"].ToString(); m.InventoryCount = dr["TD019"].ToString().ToDouble(); m.PlanDeliverDate = dr["TD012"].ToString(); m.BuyingID = ErpDbAccessHelper.ComposeID(dr["TD026"].ToString().Trim(), dr["TD027"].ToString().Trim()); }
private void MapStoBodyRowAndModel(DataRow dr, StockBodyModel m) { m.Code = dr["TH002"].ToString(); m.Category = dr["TH001"].ToString(); m.Auditor = dr["TH038"].ToString(); m.ProductID = dr["TH004"].ToString(); m.ProductName = dr["TH005"].ToString(); m.ProductSpecify = dr["TH006"].ToString(); m.CheckCount = dr["TH015"].ToString().ToDouble(); m.CheckDate = dr["TH014"].ToString(); m.InventoryCount = dr["TH034"].ToString().ToDouble(); m.Warehouse = dr["TH009"].ToString(); m.Memo = dr["TH033"].ToString(); m.PurchaseID = ErpDbAccessHelper.ComposeID(dr["TH011"].ToString().Trim(), dr["TH012"].ToString().Trim()); m.StockAmount = dr["TH019"].ToString().ToDouble(); m.StockCount = Convert.ToInt64(dr["TH007"].ToString().ToDouble()); m.StockUnit = dr["TH018"].ToString().ToDouble(); }
/// <summary> /// 根据采购部门获取进货单单头数据信息 /// </summary> /// <param name="department"></param> /// <returns></returns> public List <StockHeaderModel> FindStoHeaderByDepartment(string department, DateTime dateFrom, DateTime dateTo) { List <StockBodyModel> stoBodys = this.FindStoBodyByDepartment(department, dateFrom, dateTo); List <StockHeaderModel> stoHeaders = new List <StockHeaderModel>(); if (stoBodys != null && stoBodys.Count > 0) { List <string> ids = new List <string>(); stoBodys.ForEach(sto => { string id = ErpDbAccessHelper.ComposeID(sto.Code, sto.Category); if (!ids.Contains(id)) { ids.Add(id); stoHeaders.AddRange(FindStoHeaderBy(sto.Code, sto.Category)); } }); } return(stoHeaders); }
/// <summary> /// 根据采购部门获取采购购单单头数据信息 /// </summary> /// <param name="department"></param> /// <returns></returns> public List <PurchaseHeaderModel> FindPurHeaderByDepartment(string department, DateTime dateFrom, DateTime dateTo) { List <PurchaseBodyModel> reqBodys = this.FindPurBodyByDepartment(department, dateFrom, dateTo); List <PurchaseHeaderModel> purHeaders = new List <PurchaseHeaderModel>(); if (reqBodys != null && reqBodys.Count > 0) { List <string> ids = new List <string>(); reqBodys.ForEach(rb => { string id = ErpDbAccessHelper.ComposeID(rb.Code, rb.Category); if (!ids.Contains(id)) { ids.Add(id); purHeaders.AddRange(FindPurHeaderBy(rb.Code, rb.Category)); } }); } return(purHeaders); }