CollageController
目录
1、 CollageController
1.1、 SelectCollageData
1.2、 查询领料导入配件信息
1.3、 查询领料明细信息
using QXQPS.Models;
using QXQPS.Vo;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
namespace QXQPS.Areas.MechanicsManagment.Controllers
{
public class CollageController : Controller
{
// GET: MechanicsManagment/Collage
public ActionResult SelectCollageData(int ReceptionID)//查询领料主信息
{
var list = myModels.PW_Collage.Where(m => m.ReceptionID == ReceptionID).Select(m=>new CollageVo{
CollageID=m.CollageID,
AuditDate = m.AuditDate.ToString(),
ForeMan=m.ForeMan,
CollageDate=m.CollageDate.ToString(),
Amount= m.Amount,
ToAudit= m.ToAudit,
Operator= m.Operator,
Auditor=m.Auditor,
Remark=m.Remark,
}).SingleOrDefault();
return Json(list, JsonRequestBehavior.AllowGet);
}
public ActionResult DaoRuPeiJian(BsgridPage bsgridPage,int ReceptionID)//查询领料导入配件信息
{
var lingItem = (from tbRecProductDetail in myModels.SYS_RecProductDetail
join tbMaintainability in myModels.SYS_Maintainability on tbRecProductDetail.MaintainabilityID equals tbMaintainability.MaintainabilityID
where tbRecProductDetail.ReceptionID== ReceptionID
select new ProductVo
{
ReceptionID = tbRecProductDetail.ReceptionID,
RecProductDetailID =tbRecProductDetail.RecProductDetailID,
MaintainabilityID=tbRecProductDetail.MaintainabilityID,
MaintainabilityName=tbMaintainability.MaintainabilityName,
FittingsCode=tbRecProductDetail.FittingsCode.Trim(),
FittingsName=tbRecProductDetail.FittingsName.Trim(),
SystemUnit=tbRecProductDetail.SystemUnit.Trim(),
Quantity = tbRecProductDetail.Quantity,
UnitPrice = tbRecProductDetail.UnitPrice,
FittingsSpec=tbRecProductDetail.FittingsSpec.Trim()!=null? tbRecProductDetail.FittingsSpec.Trim():"",
Amount =tbRecProductDetail.Amount,
Remark=tbRecProductDetail.Remark.Trim(),
VehicleType=tbRecProductDetail.VehicleType.Trim()
}).ToList();
int count = lingItem.Count();
List<ProductVo> listReception = lingItem.OrderBy(m => m.PreProductDetailID).Skip(bsgridPage.GetStartIndex()).Take(bsgridPage.pageSize).ToList();
Bsgrid<ProductVo> bsgrid = new Bsgrid<ProductVo>()
{
success = true,
totalRows = count,
curPage = bsgridPage.curPage,
data = listReception
};
return Json(bsgrid, JsonRequestBehavior.AllowGet);
}
public ActionResult SelectCollageDetai(int CollageID)//查询领料明细信息
{
try
{
var listCollageDetai = myModels.SYS_CollageDetai.Where(m => m.CollageID == CollageID).ToList();
return Json(listCollageDetai, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
return Json(false, JsonRequestBehavior.AllowGet);
}
}