/// <summary>
/// 根据采购部门,起止日期获取请购单单头数据信息
/// </summary>
/// <param name="department"></param>
/// <returns></returns>
public List <MaterialHaaderModel> FindReqHeaderBy(string orderId)
{
IDModel idm = ErpDbAccessHelper.DecomposeID(orderId);
string sqlWhere = string.Format(" where TA004='{0}' And TA003 ='{1}'", idm.Category, idm.Code);
return(FindHeaderBy(sqlWhere));
}
/// <summary>
/// 获取工单物料列表
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
public List <OrderMaterialModel> GetOrderMaterialListBy(string orderId)
{
var idm = ErpDbAccessHelper.DecomposeID(orderId);
string sqlWhere = string.Format(" where TB001='{0}' and TB002='{1}' ", idm.Category, idm.Code);
return(ErpDbAccessHelper.FindDataBy <OrderMaterialModel>(SqlFields, sqlWhere, (dr, m) =>
{
m.MaterialId = dr["材料品号"].ToString().Trim();
m.MaterialName = dr["品名"].ToString().Trim();
m.MaterialSpecify = dr["规格"].ToString().Trim();
m.Unit = dr["单位"].ToString().Trim();
m.ReceiveCount = dr["需领用量"].ToString().Trim().ToDouble();
}));
}
/// <summary>
/// 获取工单详情
/// </summary>
/// <param name="orderID"></param>
/// <returns></returns>
public OrderModel GetOrderDetailsBy(string orderID)
{
var idm = ErpDbAccessHelper.DecomposeID(orderID);
string sqlWhere = string.Format(" where TA001='{0}' and TA002='{1}'", idm.Category, idm.Code);
var ListModels = ErpDbAccessHelper.FindDataBy <OrderModel>(SqlFields, sqlWhere, (dr, m) =>
{
m.OrderId = string.Format("{0}-{1}", dr["TA001"].ToString().Trim(), dr["TA002"].ToString().Trim());;
m.ProductID = dr["TA006"].ToString().Trim();
m.ProductName = dr["TA034"].ToString().Trim();
m.ProductSpecify = dr["TA035"].ToString().Trim();
m.OrderFinishStatus = OrderFinishStatusConverter(dr["TA011"].ToString().Trim());
m.Count = dr["TA015"].ToString().Trim().ToDouble();
m.InStoreCount = dr["TA017"].ToString().Trim().ToDouble();
m.OrderFinishDate = dr["TA010"].ToString().Trim().ToDate();
m.InStockDate = dr["TA063"].ToString().Trim().ToDate();
});
return(ListModels.FirstOrDefault());
}
/// <summary>
/// 查找该部门的请购单单身信息
/// </summary>
/// <param name="department"></param>
/// <returns></returns>
public List <StockBodyModel> FindStoBodyByDepartment(string department, DateTime dateFrom, DateTime dateTo)
{
List <PurchaseHeaderModel> reqHeaders = this.purDb.FindPurHeaderByDepartment(department, dateFrom, dateTo);
List <StockBodyModel> stoBodys = new List <StockBodyModel>();
if (reqHeaders != null && reqHeaders.Count > 0)
{
List <string> Ids = new List <string>();
reqHeaders.ForEach(req =>
{
if (!Ids.Contains(req.PurchaseID))
{
Ids.Add(req.PurchaseID);
IDModel idm = ErpDbAccessHelper.DecomposeID(req.PurchaseID);
string sqlWhere = string.Format(" where TH011='{0}' and TH012='{1}'", idm.Category, idm.Code);
stoBodys.AddRange(FindStoBodyBy(sqlWhere));
}
});
}
return(stoBodys);
}
/// <summary>
/// 查找该部门的请购单单身信息
/// </summary>
/// <param name="department"></param>
/// <returns></returns>
public List <PurchaseBodyModel> FindPurBodyByDepartment(string department, DateTime dateFrom, DateTime dateTo)
{
List <RequisitionHeaderModel> reqHeaders = this.reqDb.FindReqHeaderBy(department, dateFrom, dateTo);
List <PurchaseBodyModel> purBodys = new List <PurchaseBodyModel>();
if (reqHeaders != null && reqHeaders.Count > 0)
{
List <string> ids = new List <string>();
reqHeaders.ForEach(rh =>
{
if (!ids.Contains(rh.BuyingID))
{
ids.Add(rh.BuyingID);
IDModel idm = ErpDbAccessHelper.DecomposeID(rh.BuyingID);
string sqlWhere = string.Format(" where TD026='{0}' and TD027='{1}'", idm.Category, idm.Code);
purBodys.AddRange(FindPurBodyBy(sqlWhere));
}
});
}
return(purBodys);
}
public List <StockBodyModel> FindStoBodyByID(string id)
{
var idm = ErpDbAccessHelper.DecomposeID(id);
return(FindStoBodyBy(idm.Code, idm.Category));
}
/// <summary>
/// 查询该请购单的单身信息
/// </summary>
/// <param name="reqID"></param>
/// <returns></returns>
public List <RequisitionBodyModel> FindReqBodyByID(string reqID)
{
IDModel idm = ErpDbAccessHelper.DecomposeID(reqID);
return(FindReqBodyBy(idm.Code, idm.Category));
}
public List <CopReturnOrderModel> FindReturnOrderByID(string returnHandleOrderid)
{
var idm = ErpDbAccessHelper.DecomposeID(returnHandleOrderid);
return(FindBodyReturnOrderBy(idm.Category, idm.Code));
}
/// <summary>
/// 由单子 得到单别 单号 (单别为 591 110 (341 342 343 344)和制令单)
/// <param name="id">单号XXX-XXXXXXX</param>
/// <returns></returns>
public List <MaterialModel> FindMaterialBy(string id)
{
var idm = ErpDbAccessHelper.DecomposeID(id);
return(GetMaterialIdBy(idm.Category, idm.Code));
}