目录
1、 CollageController
1.1、 ReceptionID查询CollageID 退料模态框
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 SelectCollageID(int ReceptionID)//ReceptionID查询CollageID 退料模态框
{
Session["receptionID"] = ReceptionID;
var CollageID = 0;
var list = myModels.PW_Collage.Where(m => m.ReceptionID == ReceptionID).Select(m => new { m.CollageID }).SingleOrDefault();
if (list != null)
{
CollageID = list.CollageID;
}
return Json(CollageID, JsonRequestBehavior.AllowGet);
}
public ActionResult SelectTableCollageDetai(BsgridPage bsgridPage, int CollageID)//查询退料明细信息
{
var lingItem = (from tbCollageDetai in myModels.SYS_CollageDetai
join tbMaintainability in myModels.SYS_Maintainability on tbCollageDetai.MaintainabilityID equals tbMaintainability.MaintainabilityID
join tbWarehouse in myModels.SYS_Warehouse on tbCollageDetai.WarehouseID equals tbWarehouse.WarehouseID
join tbCollage in myModels.PW_Collage on tbCollageDetai.CollageID equals tbCollage.CollageID
join tbReception in myModels.PW_Reception on tbCollage.ReceptionID equals tbReception.ReceptionID
where tbCollageDetai.CollageID == CollageID
select new CollageDetaiVo
{
CollageID = tbCollageDetai.CollageID,
CollageDetaiID=tbCollageDetai.CollageDetaiID,
MaintainabilityID = tbCollageDetai.MaintainabilityID,
MaintainabilityName = tbMaintainability.MaintainabilityName.Trim(),
MaintenanceNum=tbReception.MaintenanceNum.Trim(),
WarehouseID = tbCollageDetai.WarehouseID,
WarehouseName = tbWarehouse.WarehouseName.Trim(),
Quantity = tbCollageDetai.Quantity,
UnitPrice = tbCollageDetai.UnitPrice,
Amount = tbCollageDetai.Amount,
Position = tbCollageDetai.Position.Trim(),
VehicleType = tbCollageDetai.VehicleType.Trim(),
FittingsName = tbCollageDetai.FittingsName.Trim(),
FittingsCode = tbCollageDetai.FittingsCode.Trim(),
FittingsSpec = tbCollageDetai.FittingsSpec.Trim(),
SystemUnit = tbCollageDetai.SystemUnit.Trim(),
}).ToList();
int count = lingItem.Count();
List<CollageDetaiVo> listCollageDetai = lingItem.OrderBy(m => m.FittingsCode).Skip(bsgridPage.GetStartIndex()).Take(bsgridPage.pageSize).ToList();
Bsgrid<CollageDetaiVo> bsgrid = new Bsgrid<CollageDetaiVo>()
{
success = true,
totalRows = count,
curPage = bsgridPage.curPage,
data = listCollageDetai
};
return Json(bsgrid, JsonRequestBehavior.AllowGet);
}
public ActionResult SelectRestock(int ReceptionID)//查询退料主信息
{
var list = (from tbReception in myModels.PW_Reception
join tbCollage in myModels.PW_Collage on tbReception.ReceptionID equals tbCollage.ReceptionID
where tbReception.ReceptionID==ReceptionID
select new CollageVo
{
ReceptionID = tbReception.ReceptionID,
Owner = tbReception.Owner.Trim(),
CarNum = tbReception.CarNum.Trim(),
MaintenanceNum = tbReception.MaintenanceNum.Trim(),
CollageID = tbCollage.CollageID,
StrAudit = tbCollage.ToAudit!=true?"未审核": "已审核",
}).SingleOrDefault();
return Json(list, JsonRequestBehavior.AllowGet);
}
public class RestockDetail
{
public int CollageDetaiID { get; set; }
public decimal Quantity { get; set; }
public string FittingsCode { get; set; }
public int WarehouseID { get; set; }
}