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