/// <summary> /// 获取请购计划数据 /// </summary> /// <param name="icprbillid"></param> /// <returns></returns> public V_ICPRBILLMODEL GetPurchasePlanModel(string icprbillid) { try { V_ICPRBILLMODEL icprModel = V_ICPRBILLDAL.Instance.Get(icprbillid); return(icprModel); } catch (Exception ex) { LogHelper.WriteLog(ex); return(null); } }
/// <summary> /// 单据详情查询接口 /// </summary> /// <returns></returns> public string GetBillInfo() { try { //用户编号 string user = Request["user"]; //单据ID string billid = Request["billid"]; //页码 string page = Request["page"]; //每页显示行数 int pagesize = Request["pagesize"].ToInt(10); V_ICPRBILLMODEL model = V_ICPRBILLDAL.Instance.Get(billid); if (model != null) { var entry = V_ICPRBILLENTRYDAL.Instance.GetWhere(new { FPLANID = billid }).ToList(); //分页 var pagedata = entry.Skip((page.ToInt() - 1) * pagesize).Take(pagesize).ToList(); var entrylist = new List <object>(); foreach (V_ICPRBILLENTRYMODEL entryModel in pagedata) { entrylist.Add(new { FID = entryModel.FID, FENTRYID = entryModel.FENTRYID, //行号 FPRODUCTCODE = entryModel.FPRODUCTCODE, //商品代码 FPRODUCTNAME = entryModel.FPRODUCTNAME, //商品名称 FMODEL = entryModel.FMODEL, //规格型号 FCOLORNO = entryModel.FCOLORNO, //色号 FASKQTY = entryModel.FASKQTY, //主单位申请数量 FUNITNAME = entryModel.FUNITNAME, //主单位 FORDERUNITQTY = entryModel.FORDERUNITQTY, //采购单位申请数量 FORDERUNIT = entryModel.FORDERUNIT, //采购单位 FNEEDDATE = entryModel.FNEEDDATESTR, //要求发货时间 FREMARK = entryModel.FREMARK, //销区备注 FSTATUS = entryModel.FSTATUS //单据状态 }); } var auditdata = ICPRBILLAUDITDal.Instance.GetWhere(new { FBILLID = billid, FAUDITOR = user }).ToList(); if (auditdata.Count > 0) { return(JSONhelper.ToJson(new ResultClass() { errCode = 0, data = new { FID = model.FID, //单据ID FBILLNO = model.FBILLNO, //单据编号 FBILLERNAME = model.FBILLERNAME, //申请人 FBILLDATE = model.FBILLDATE, //申请日期 FPREMISENAME = model.FPREMISENAME, //经营场所 FTYPENAME = model.FTYPENAME, //计划类型 FRECEIVINGADDR = model.FRECEIVINGADDR, //收货方地址 FDELIVERYADDR = model.FDELIVERYADDR, //发货地点 FTRANSNAME = model.FTRANSNAME, //运输方式 FSIGN_MAIN = model.SIGN_MAIN, //签约主体 FPROJECTNAME = model.FPROJECTNAME, //工程名称 FWEIGHT = model.FWEIGHT, //重量合计 FSTATUS = model.FSTATUS, //单据状态 FAUDITSTATUS = auditdata[0].FSTATUS, //审核状态 FENTRYCOUNT = entry.Count, //明细记录总数 Entrys = entrylist } })); } } return(JSONhelper.ToJson(new ResultClass() { errCode = -1, errMsg = "数据不存在!" })); } catch (Exception ex) { LogHelper.WriteLog(ex); return(JSONhelper.ToJson(new ResultClass() { errCode = -1, errMsg = ex.Message })); } }