版权声明:本文为博主原创文章,未经博主允许不得转载。https://blog.csdn.net/qq_37144354/article/details/80107672
public JsonResult QingSuan()
{
string pdid = Request["pdid"] ?? "";
try
{
//数据库读取 费用项目
var _fyxm = ServiceFactory.base_feiyongxmservice.LoadEntities(p => p.IsDelete == false).ToList();
//获取满足条件(YSID)的信息
var paidan = ServiceFactory.fast_paidanysservice.LoadSortEntities(p => p.YSID == int.Parse(pdid) && p.IsDelete == false, false, fast_paidanys => fast_paidanys.ID);
//根据fast_feiyongpdViewModel类新建一个 fypd对象数组
List fypd = new List();
foreach (var pd in paidan)
{
var _fypd = ServiceFactory.fast_feiyongpdservice.LoadSortEntities(p => p.PDID == pd.ID && p.IsDelete == false, false, p => p.FMID);
foreach (var item in _fypd)
{
fast_feiyongpdViewModel newpdfy = new fast_feiyongpdViewModel();
newpdfy.DJ = item.DJ;
newpdfy.FM = _fyxm.Find(p => p.ID == item.FMID).Mingcheng ?? "";
newpdfy.FMID = item.FMID;
newpdfy.ID = item.ID;
newpdfy.JE = item.JE;
newpdfy.JSSF = item.JSSF;
newpdfy.PDID = item.PDID;
newpdfy.QRSF = item.QRSF;
newpdfy.SL = item.SL;
//向对象数组添加对象
fypd.Add(newpdfy);
}
}
var fywtdata = ServiceFactory.fast_feiyongwtservice.LoadSortEntities(p => p.YSID == int.Parse(pdid) && p.IsDelete == false, false, fast_feiyongwt => fast_feiyongwt.ID);
List fywt = new List();
foreach (var item in fywtdata)
{
fast_feiyongwtViewModel _fywt = new fast_feiyongwtViewModel();
_fywt.DJ = item.DJ;
_fywt.FM = _fyxm.Find(p => p.ID == item.FMID).Mingcheng ?? "";
_fywt.FMID = item.FMID;
_fywt.ID = item.ID;
_fywt.JE = item.JE;
_fywt.JSSF = item.JSSF;
_fywt.YSID = item.YSID;
_fywt.QRSF = item.QRSF;
_fywt.SL = item.SL;
//向对象数组添加对象
fywt.Add(_fywt);
}
return Json(new { wtfy = fywt, pdfy = fypd });
}catch
{
return Json(-1);
}
}
阅读更多