public ActionResult List(GridCommand command, InspectResultSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (!string.IsNullOrEmpty(((InspectResultSearchModel)(searchCacheModel.SearchObject)).IpNo))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_NeedInputShipOrderToSearch);
}
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult List(GridCommand command, InspectResultSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (!string.IsNullOrEmpty(((InspectResultSearchModel)(searchCacheModel.SearchObject)).IpNo))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage("请根据送货单进行查询！");
}
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
private SearchStatementModel NewPrepareSearchStatement(GridCommand command, InspectResultSearchModel searchModel)
{
string whereStatement = " where i.JudgeQty > i.HandleQty and i.JudgeResult= " + (int)com.Sconit.CodeMaster.JudgeResult.Rejected;
if (searchModel.InspectType != null && searchModel.InspectType.Value == (int)com.Sconit.CodeMaster.InspectType.Barcode)
{
whereStatement += " and i.HuId is not null";
}
else
{
whereStatement += " and i.HuId is null";
}
return InspectResultPrepareSearchStatement(command, searchModel, whereStatement);
//IList<object> param = new List<object>();
//HqlStatementHelper.AddLikeStatement("InspectNo", searchModel.InspectNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
//HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "i", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("ReceiptNo", searchModel.ReceiptNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("WMSNo", searchModel.WMSNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
//HqlStatementHelper.AddEqStatement("CreateUserName", searchModel.CreateUserName,"i", ref whereStatement, param);
//HqlStatementHelper.AddEqStatement("CurrentLocation", searchModel.CurrentLocation, "i", ref whereStatement, param);
//if (searchModel.StartDate != null && searchModel.EndDate != null)
//{
// HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "i", ref whereStatement, param);
//}
//else if (searchModel.StartDate != null && searchModel.EndDate == null)
//{
// HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "i", ref whereStatement, param);
//}
//else if (searchModel.StartDate == null && searchModel.EndDate != null)
//{
// HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "i", ref whereStatement, param);
//}
//if (command.SortDescriptors.Count > 0)
//{
// if (command.SortDescriptors[0].Member == "DefectDescription")
// {
// command.SortDescriptors[0].Member = "Defect";
// }
//}
//string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
//SearchStatementModel searchStatementModel = new SearchStatementModel();
//searchStatementModel.SelectCountStatement = inspectResultSelectCountStatement;
//searchStatementModel.SelectStatement = inspectResultSelectStatement;
//searchStatementModel.WhereStatement = whereStatement;
//searchStatementModel.SortingStatement = sortingStatement;
//searchStatementModel.Parameters = param.ToArray<object>();
//return searchStatementModel;
}
private SearchStatementModel PopPrepareSearchStatement(GridCommand command, InspectResultSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<RejectDetail> listRejectDetail = new List<RejectDetail>();
listRejectDetail = base.genericMgr.FindAll<RejectDetail>("select r from RejectDetail as r where r.RejectNo=?", searchModel.RejectNo);
string strInspResultId = string.Empty;
for (int i = 0; i < listRejectDetail.Count; i++)
{
strInspResultId += "'" + listRejectDetail[i].InspectResultId + "',";
}
whereStatement = " where i.JudgeResult=" + (int)com.Sconit.CodeMaster.JudgeResult.Rejected + " and JudgeQty > HandleQty";
if (strInspResultId != string.Empty)
{
strInspResultId = strInspResultId.Substring(0, strInspResultId.Length - 1);
whereStatement += " and Id not in (" + strInspResultId + ")";
}
else
{
whereStatement = " where i.JudgeQty > i.HandleQty and i.JudgeResult= " + (int)com.Sconit.CodeMaster.JudgeResult.Rejected;
}
if (searchModel.InspectType == (int)com.Sconit.CodeMaster.InspectType.Barcode)
{
whereStatement += " and i.HuId is not null";
}
else
{
whereStatement += " and i.HuId is null";
}
return InspectResultPrepareSearchStatement(command, searchModel, whereStatement);
}
private SearchStatementModel InspectResultPrepareSearchStatement(GridCommand command, InspectResultSearchModel searchModel, string whereStatement)
{
IList<object> param = new List<object>();
HqlStatementHelper.AddLikeStatement("InspectNo", searchModel.InspectNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("ReceiptNo", searchModel.ReceiptNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("WMSNo", searchModel.WMSNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("CreateUserName", searchModel.CreateUserName, "i", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("CurrentLocation", searchModel.CurrentLocation, "i", ref whereStatement, param);
if (searchModel.StartDate != null && searchModel.EndDate != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "i", ref whereStatement, param);
}
else if (searchModel.StartDate != null && searchModel.EndDate == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "i", ref whereStatement, param);
}
else if (searchModel.StartDate == null && searchModel.EndDate != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "i", ref whereStatement, param);
}
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "DefectDescription")
{
command.SortDescriptors[0].Member = "Defect";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = inspectResultSelectCountStatement;
searchStatementModel.SelectStatement = inspectResultSelectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxInspectResultList(GridCommand command, InspectResultSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PopPrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<InspectResult>(searchStatementModel, command));
}
public ActionResult ChooseInspectResult(GridCommand command, InspectResultSearchModel searchModel)
{
TempData["InspectResultSearchModel"] = searchModel;
ViewBag.Status = searchModel.Status;
ViewBag.InspectType = searchModel.InspectType;
ViewBag.RejectNo = searchModel.RejectNo;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return PartialView();
}
public ActionResult New(GridCommand command, InspectResultSearchModel searchModel)
{
this.ProcessSearchModel(command,searchModel);
ViewBag.InspectType = searchModel.InspectType == null ? (int)com.Sconit.CodeMaster.InspectType.Quantity : searchModel.InspectType.Value;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult _AjaxInspectResultNewList(GridCommand command, InspectResultSearchModel searchModel)
{
if (!searchModel.isFromList.HasValue || !searchModel.isFromList.Value)
{
return PartialView(new GridModel(new List<InspectResult>()));
}
var failCodeDic = this.genericMgr.FindAll<FailCode>().ToDictionary(d => d.Code, d => d);
SearchStatementModel searchStatementModel = NewPrepareSearchStatement(command, searchModel);
var data = GetAjaxPageData<InspectResult>(searchStatementModel, command);
foreach (var inspectResult in data.Data)
{
inspectResult.FailCodeDescription = failCodeDic[inspectResult.FailCode].CodeDescription;
}
return PartialView(data);
}
public ActionResult New(GridCommand command, InspectResultSearchModel searchModel)
{
if ((!searchModel.HandleResult.HasValue || searchModel.HandleResult.Value == 0)
&& (searchModel.isFromList.HasValue && searchModel.isFromList.Value))
{
SaveErrorMessage(Resources.EXT.ControllerLan.Con_PleaseChooseProcessMathod);
searchModel.isFromList = false;
}
this.ProcessSearchModel(command, searchModel);
ViewBag.InspectType = searchModel.InspectType == null ? (int)com.Sconit.CodeMaster.InspectType.Quantity : searchModel.InspectType.Value;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
private SearchStatementModel InspectResultPrepareSearchStatement(GridCommand command, InspectResultSearchModel searchModel)
{
string whereStatement = "where i.InspectNo = '" + searchModel.InspectNo + "'";
IList<object> param = new List<object>();
HqlStatementHelper.AddLikeStatement("Item", searchModel.Item, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "JudgeResultDescription")
{
command.SortDescriptors[0].Member = "JudgeResult";
}
else if (command.SortDescriptors[0].Member == "DefectDescription")
{
command.SortDescriptors[0].Member = "Defect";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = InspectResultSelectCountStatement;
searchStatementModel.SelectStatement = InspectResultSelectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxInspectionResultList(GridCommand command, InspectResultSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.InspectResultPrepareSearchStatement(command, searchModel);
GridModel<InspectResult> list = GetAjaxPageData<InspectResult>(searchStatementModel, command);
IList<FailCode> failCodeList = genericMgr.FindAll<FailCode>();
foreach (InspectResult inspectResult in list.Data)
{
foreach (FailCode failCode in failCodeList)
{
if (inspectResult.FailCode == failCode.Code)
{
inspectResult.FailCodeDescription = failCode.CodeDescription;
inspectResult.CurrentFailCode = inspectResult.FailCode;
inspectResult.CurrentIsHandle = inspectResult.IsHandle;
}
}
if (!string.IsNullOrWhiteSpace(inspectResult.HuId))
{
Hu huData = genericMgr.FindById<Hu>(inspectResult.HuId);
inspectResult.ExpireDate = huData.ExpireDate;
inspectResult.SupplierLotNo = huData.SupplierLotNo;
}
}
return PartialView(list);
}
public ActionResult InspectionResult(GridCommand command, InspectResultSearchModel searchModel)
{
ViewBag.Item = searchModel.Item;
TempData["InspectResultSearchModel"] = searchModel;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return PartialView();
}
