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