public ActionResult List(GridCommand command, ProductLineLocationDetailSearchModel searchModel)
{
this.ProcessSearchModel(command, searchModel);
if (string.IsNullOrEmpty(searchModel.OrderNo))
{
SaveWarningMessage("请输入订单号。");
return View(new List<OrderBomDetail>());
}
else
{
TempData["_AjaxMessage"] = "";
string sql = PrepareSearchStatement(searchModel);
IList<object[]> list = base.genericMgr.FindAllWithNativeSql<object[]>(sql);
IList<OrderBomDetail> OrderBomDetailList = new List<OrderBomDetail>();
OrderBomDetailList = (from tak in list
select new OrderBomDetail
{
OrderNo = (string)tak[0],
Item = (string)tak[1],
ItemDescription = (string)tak[2],
ReferenceItemCode = (string)tak[3],
Uom = (string)tak[4],
ManufactureParty = (string)tak[5],
Operation = (int)tak[6],
OpReference = (string)tak[7],
OrderedQty = (decimal)tak[8],
HuId = (string)tak[9],
FeedQty = (decimal)tak[10],
}).ToList();
return View(OrderBomDetailList);
}
}
public ActionResult List(GridCommand command, ProductLineLocationDetailSearchModel searchModel)
{
this.ProcessSearchModel(command, searchModel);
if (string.IsNullOrEmpty(searchModel.ProductLine) && string.IsNullOrEmpty(searchModel.OrderNo))
{
SaveWarningMessage("请输入生产线代码或订单号。");
}
else
{
TempData["_AjaxMessage"] = "";
}
ViewBag.PageSize = this.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult List(GridCommand command, ProductLineLocationDetailSearchModel searchModel)
{
this.ProcessSearchModel(command, searchModel);
if (string.IsNullOrEmpty(searchModel.ProductLine) && string.IsNullOrEmpty(searchModel.OrderNo))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_PleaseInputProductionLineCodeOrOrderNumber);
}
else
{
TempData["_AjaxMessage"] = "";
}
ViewBag.PageSize = this.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult _AjaxList(GridCommand command, ProductLineLocationDetailSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.ProductLine) && string.IsNullOrEmpty(searchModel.OrderNo))
{
return PartialView(new GridModel(new List<ProductLineLocationDetail>()));
}
string sql = this.PrepareSearchStatement(command, searchModel);
//base.genericMgr.FindAllWithNativeSql<object[]>(sql);
IList<object[]> objectList = base.genericMgr.FindAllWithNativeSql<object[]>(sql + "select * from #temp where ID_Num between " + (command.Page - 1) * command.PageSize + " and " + command.Page* command.PageSize + ";drop table #temp ;");
IList<object> CountList = base.genericMgr.FindAllWithNativeSql<object>(sql + "select count(*) as counts from #temp ;drop table #temp;");
//if (objectList.Count > 0) {
// base.genericMgr.FindAllWithNativeSql<object[]>("drop table #temp ;");
//}
IList<ProductLineLocationDetail> ProductLineLocationDetailList = new List<ProductLineLocationDetail>();
ProductLineLocationDetailList = (from tak in objectList
select new ProductLineLocationDetail
{
ProductLine = (string)tak[1],
OrderNo = (string)tak[2],
Operation = (int?)tak[3],
OpReference = (string)tak[4],
TraceCode = (string)tak[5],
Item = (string)tak[6],
ItemDescription = (string)tak[7],
ReferenceItemCode = (string)tak[8],
HuId = (string)tak[9],
LotNo = (string)tak[10],
Qty = (decimal)tak[11],
BackFlushQty= (decimal)tak[12],
VoidQty = (decimal)tak[13],
CreateUserName = (string)tak[14],
CreateDate = (DateTime)tak[15],
LocationFrom=(string)tak[16],
}).ToList();
GridModel<ProductLineLocationDetail> gridList = new GridModel<ProductLineLocationDetail>();
gridList.Data = ProductLineLocationDetailList;
gridList.Total = Convert.ToInt32(CountList[0]);
return PartialView(gridList);
}
private string PrepareSearchStatement( ProductLineLocationDetailSearchModel searchModel)
{
StringBuilder Sb = new StringBuilder();
string whereStatement = @"select d.orderno,d.item,d.itemdesc,d.refitemcode,d.uom,isnull(d.manufactureparty,'') as manufactureparty,d.op,d.opref,d.orderqty,isnull(p.huid,'') as huid,isnull(p.qty,0) as qty from ord_orderbomdet d
left join PRD_ProdLineLocationDet p
on d.item=p.item and d.orderno=p.orderno
and d.op=p.op and d.opref=p.opref
where d.isscanhu=1 and d.OrderNo='" +searchModel.OrderNo+"'";
Sb.Append(whereStatement);
if (!string.IsNullOrEmpty(searchModel.Item))
{
Sb.Append(string.Format(" and d.Item = '{0}'", searchModel.Item));
}
if (!string.IsNullOrEmpty(searchModel.HuId))
{
Sb.Append(string.Format(" and p.HuId = '{0}'", searchModel.HuId));
}
return Sb.ToString();
}
private string PrepareSearchStatement(GridCommand command, ProductLineLocationDetailSearchModel searchModel)
{
StringBuilder Sb = new StringBuilder();
string whereStatement = @"select identity(int, 1,1) as id_Num,* into #temp from ( select prodline,orderno,op,opref,tracecode,item,itemdesc,refitemcode,huid,lotno,sum(qty) as qty,sum(bfqty) as bfqty,sum(voidqty) as voidqty,createusernm,createdate,LocFrom
from PRD_ProdLineLocationDet where isClose=0 " ;
Sb.Append(whereStatement);
string later="group by prodline,orderno,op,opref,tracecode,item,itemdesc,refitemcode,huid,lotno,createusernm,createdate,LocFrom ) as result;";
if (!string.IsNullOrEmpty(searchModel.ProductLine)) {
Sb.Append(string.Format(" and prodline = '{0}'", searchModel.ProductLine));
}
if (!string.IsNullOrEmpty(searchModel.OrderNo))
{
Sb.Append(string.Format(" and OrderNo = '{0}'", searchModel.OrderNo));
}
if (!string.IsNullOrEmpty(searchModel.Item))
{
Sb.Append(string.Format(" and Item = '{0}'", searchModel.Item));
}
Sb.Append(later);
return Sb.ToString();
}
