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);
}