public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (string.IsNullOrEmpty(searchModel.Location))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_LocationCanNotBeEmpty);
return View();
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_FirstBatchNumberCanNotBeEmpty);
return View();
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom) && !string.IsNullOrEmpty(searchModel.LotNoTo))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_FirstBatchNumberBeEmptyCanNotInputSecondBatchNumber);
return View();
}
if (!string.IsNullOrEmpty(searchModel.Location)&&!string.IsNullOrEmpty(searchModel.LotNoFrom))
{
ViewBag.Region = searchModel.Region;
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_SearchConditionNeedLocationAndBatchNo);
}
return View();
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.Location))
{
return PartialView(new GridModel(new List<LocationLotDetail>()));
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom))
{
return PartialView(new GridModel(new List<LocationLotDetail>())); ;
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom) && !string.IsNullOrEmpty(searchModel.LotNoTo))
{
return PartialView(new GridModel(new List<LocationLotDetail>()));
}
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<LocationLotDetail> gridModel = GetAuditInspectionPageData<LocationLotDetail>(reportSearchStatementModel);
foreach (var locationLotDetail in gridModel.Data)
{
locationLotDetail.ItemDescription=genericMgr.FindById<Item>(locationLotDetail.Item).Description;
}
return PartialView(gridModel);
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel)
{
string whereStatement = "where HuId is not Null";
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("Location", searchModel.Location, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("HuId", searchModel.HuId, "l", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by l.CreateDate desc";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountStatement;
searchStatementModel.SelectStatement = selectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.Location))
{
return PartialView(new GridModel(new List<LocationLotDetail>()));
}
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
GridModel<LocationLotDetail> List = GetAjaxPageData<LocationLotDetail>(searchStatementModel, command);
if (List.Data.Count()>0)
{
IList<string> ItemCodes = List.Data.Select(i => i.Item).Distinct().ToList();
//IList<IpMaster> StatusAndIpNo = base.genericMgr.FindAll<IpMaster>("select r from IpMaster as r where IpNo in ()");
string sql = "select Code,Desc1,RefCode from MD_Item where Code in (";
foreach (string ItemCode in ItemCodes)
{
sql += "'" + ItemCode + "',";
}
sql = sql.Substring(0, sql.Length - 1) + ")";
IList<object[]> objectList = base.genericMgr.FindAllWithNativeSql<object[]>(sql);
foreach (var item in objectList)
{
foreach (LocationLotDetail locationLotDetail in List.Data)
{
if ((string)item[0] == locationLotDetail.Item)
{
locationLotDetail.ItemDescription = (string)item[1];
locationLotDetail.ReferenceItemCode = (string)item[2];
}
}
}
}
return PartialView(List);
}
public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
ViewBag.IsFreeze = searchModel.IsFreeze;
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (string.IsNullOrEmpty(searchModel.Location))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_LocationCanNotBeEmpty);
return View();
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom) || string.IsNullOrEmpty(searchModel.LotNoFrom))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_SearchConditionNeedManufactureDateAndBatchNo);
return View();
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom) && !string.IsNullOrEmpty(searchModel.LotNoTo))
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_SearchConditionNeedManufactureDate);
return View();
}
if (!string.IsNullOrEmpty(searchModel.Location)&&!string.IsNullOrEmpty(searchModel.LotNoFrom))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_SearchConditionNeedLocationAndBatchNo);
}
return View();
}
public ActionResult Index()
{
LocationLotDetailSearchModel serch = new LocationLotDetailSearchModel();
serch.TypeLocation = "0";
TempData["Display"] = "0";
TempData["LocationLotDetailSearchModel"] = serch;
return View();
}
public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (searchCacheModel.isBack == true)
{
ViewBag.Page = searchCacheModel.Command.Page == 0 ? 1 : searchCacheModel.Command.Page;
}
ViewBag.PageSize = this.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
if (!string.IsNullOrEmpty(searchModel.Location))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage(Resources.EXT.ControllerLan.Con_LocationSearchConditionCanNotBeEmpty);
}
TempData["LocationLotDetailSearchModel"] = searchModel;
return View();
}
public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
this.ProcessSearchModel(command, searchModel);
if (!string.IsNullOrEmpty(searchModel.Location))
{
TempData["_AjaxMessage"] = "";
}
else
{
SaveWarningMessage("查询条件中库位为必选项。");
}
ViewBag.PageSize = this.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.Location))
{
return PartialView(new GridModel(new List<LocationLotDetail>()));
}
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
var list = GetAjaxPageData<LocationLotDetail>(searchStatementModel, command);
foreach (var data in list.Data)
{
data.ItemDescription = itemMgr.GetCacheItem(data.Item).Deriction;
}
return PartialView(GetAjaxPageData<LocationLotDetail>(searchStatementModel, command));
}
public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
SearchCacheModel model = base.ProcessSearchModel(command, searchModel);
if (model.isBack == true)
{
((dynamic)base.ViewBag).Page = (model.Command.Page == 0) ? 1 : model.Command.Page;
}
if (!string.IsNullOrEmpty(searchModel.Location))
{
base.TempData["_AjaxMessage"] = "";
}
else
{
base.SaveWarningMessage(Resources.EXT.ControllerLan.Con_LocationSearchConditionCanNotBeEmpty);
}
((dynamic)base.ViewBag).PageSize = base.ProcessPageSize(command.PageSize);
return base.View();
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.Location))
{
return PartialView(new GridModel(new List<LocationLotDetail>()));
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom))
{
return PartialView(new GridModel(new List<LocationLotDetail>())); ;
}
if (string.IsNullOrEmpty(searchModel.LotNoFrom) && !string.IsNullOrEmpty(searchModel.LotNoTo))
{
return PartialView(new GridModel(new List<LocationLotDetail>()));
}
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<LocationLotDetail> gridModel = GetAuditInspectionPageData<LocationLotDetail>(reportSearchStatementModel);
IList<FreezeTransaction> freezeTrans = new List<FreezeTransaction>();
if (searchModel.IsFreeze && gridModel.Data.Count() != 0 )
{
freezeTrans = genericMgr.FindAllIn<FreezeTransaction>
("from FreezeTransaction where Freeze=1 and HuId in(? ", gridModel.Data.Select(p => (object)p.HuId));
}
var freezeTransDic = freezeTrans.GroupBy(p => p.HuId, (k, g) => new { k, Code = g.OrderBy(p=>p.Id).First() })
.ToDictionary(d => d.k, d => d);
var itemlist = itemMgr.GetCacheAllItem();
foreach (var locationLotDetail in gridModel.Data)
{
locationLotDetail.ItemDescription = itemlist.ValueOrDefault(locationLotDetail.Item).FullDescription;
if (searchModel.IsFreeze)
{
locationLotDetail.Reason = freezeTransDic.ValueOrDefault(locationLotDetail.HuId).Code.Reason;
}
}
return PartialView(gridModel);
}
private string PrepareSqlSearchStatement(LocationLotDetailSearchModel searchModel)
{
string whereStatement = @"select ld.HuId,ld.LotNo,ld.Location,ld.Bin,ld.Item,i.Desc1,i.RefCode,ld.UC,ld.OccupyType,ld.QualityType,ld.IsCS,ld.IsFreeze,ld.IsATP,ld.HuQty,ld.HuUom,ld.Qty,ld.BaseUom,hu.HuOption,ld.Direction,ht.Desc1 as DirectionDesc,ic.Code as MaterialsGroup,ic.Desc1 as MaterialsGroupDesc,hu.ItemVersion,hu.Remark
from VIEW_LocationLotDet as ld
inner join MD_Item as i on ld.Item=i.Code
inner join INV_Hu as hu on ld.HuId=hu.HuId
left join MRP_HuTo as ht on ld.Direction=ht.Code
left join (select * from MD_ItemCategory where SubCategory=5) as ic on ic.Code=i.MaterialsGroup
where ld.HuId is not null ";
if (!string.IsNullOrEmpty(searchModel.Location))
{
whereStatement += string.Format(" and ld.Location = '{0}'", searchModel.Location);
}
if (!string.IsNullOrEmpty(searchModel.Bin))
{
whereStatement += string.Format(" and ld.Bin = '{0}'", searchModel.Bin);
}
if (!string.IsNullOrEmpty(searchModel.Item))
{
whereStatement += string.Format(" and ld.Item = '{0}'", searchModel.Item);
}
if (!string.IsNullOrEmpty(searchModel.HuId))
{
whereStatement += string.Format(" and ld.HuId like '%{0}%'", searchModel.HuId);
}
if (searchModel.OccupyType != null)
{
whereStatement += string.Format(" and ld.OccupyType ={0}", searchModel.OccupyType);
}
if (searchModel.IsFreeze2 != null)
{
whereStatement += string.Format(" and ld.IsFreeze ={0}", searchModel.IsFreeze2);
}
if (searchModel.IsATP2 != null)
{
whereStatement += string.Format(" and ld.IsATP ={0}", searchModel.IsATP2);
}
if (searchModel.IsConsignment2 != null)
{
whereStatement += string.Format(" and ld.IsCS ={0}", searchModel.IsConsignment2);
}
if (searchModel.QualityType != null)
{
whereStatement += string.Format(" and ld.QualityType ={0}", searchModel.QualityType);
}
if (!string.IsNullOrWhiteSpace(searchModel.HuOptionHuLot))
{
string huOPtionSql = " and hu.HuOption in( ";
string[] huOptionHuLots = searchModel.HuOptionHuLot.Split(',');
for (int ir = 0; ir < huOptionHuLots.Length; ir++)
{
huOPtionSql += "'" + huOptionHuLots[ir] + "',";
}
whereStatement += huOPtionSql.Substring(0, huOPtionSql.Length - 1) + ")";
}
if (!string.IsNullOrWhiteSpace(searchModel.LotNoFrom) && !string.IsNullOrWhiteSpace(searchModel.LotNoTo))
{
whereStatement += string.Format(" and ld.LotNo between '{0}' and '{1}' ", searchModel.LotNoFrom, searchModel.LotNoTo);
}
else if (!string.IsNullOrWhiteSpace(searchModel.LotNoFrom) && string.IsNullOrWhiteSpace(searchModel.LotNoTo))
{
whereStatement += " and ld.LotNo >='" + searchModel.LotNoFrom + "'";
}
else if (string.IsNullOrWhiteSpace(searchModel.LotNoFrom) && !string.IsNullOrWhiteSpace(searchModel.LotNoTo))
{
whereStatement += " and ld.LotNo <= '" + searchModel.LotNoTo + "'";
}
return whereStatement;
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
this.GetCommand(ref command, searchModel);
string sql = PrepareSqlSearchStatement(searchModel);
int total = this.genericMgr.FindAllWithNativeSql<int>("select count(*) from (" + sql + ") as r1").First();
string sortingStatement = string.Empty;
#region
////ld.HuId,ld.LotNo,ld.Location,ld.Bin,ld.Item,i.Desc1,i.RefCode,ld.UC,ld.OccupyType,ld.QualityType,ld.IsCS,
//ld.IsFreeze,ld.IsATP,ld.HuQty,ld.HuUom,ld.Qty,ld.BaseUom,hu.HuOption,ld.Direction,ht.Desc1
if (command.SortDescriptors.Count != 0)
{
if (command.SortDescriptors[0].Member == "UnitCount")
{
command.SortDescriptors[0].Member = "UC";
}
else if (command.SortDescriptors[0].Member == "HuStatusOccupyTypeDescription")
{
command.SortDescriptors[0].Member = "OccupyType";
}
else if (command.SortDescriptors[0].Member == "HuOptionDesc")
{
command.SortDescriptors[0].Member = "HuOption";
}
else if (command.SortDescriptors[0].Member == "QualityTypeDescription")
{
command.SortDescriptors[0].Member = "QualityType";
}
else if (command.SortDescriptors[0].Member == "IsConsignment")
{
command.SortDescriptors[0].Member = "IsCS";
}
sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
TempData["sortingStatement"] = sortingStatement;
}
#endregion
if (string.IsNullOrWhiteSpace(sortingStatement))
{
sortingStatement = " order by Location,Item,LotNo,HuId,Direction";
}
sql = string.Format("select * from (select RowId=ROW_NUMBER()OVER({0}),r1.* from ({1}) as r1 ) as rt where rt.RowId between {2} and {3}", sortingStatement, sql, (command.Page - 1) * command.PageSize + 1, command.PageSize * command.Page);
IList<object[]> searchResult = this.genericMgr.FindAllWithNativeSql<object[]>(sql);
IList<LocationLotDetail> locationLotDetailList = new List<LocationLotDetail>();
if (searchResult != null && searchResult.Count > 0)
{
#region
//var productTypes = genericMgr.FindAll<ProductType>().ToDictionary(d => d.Code, d => d);
//ld.HuId,ld.LotNo,ld.Location,ld.Bin,ld.Item,i.Desc1,i.RefCode,ld.UC,ld.OccupyType,ld.QualityType,ld.IsCS,
//ld.IsFreeze,ld.IsATP,ld.HuQty,ld.HuUom,ld.Qty,ld.BaseUom,hu.HuOption,ld.Direction,ht.Desc1
locationLotDetailList = (from tak in searchResult
select new LocationLotDetail
{
HuId = (string)tak[1],
LotNo = (string)tak[2],
Location = (string)tak[3],
Bin = (string)tak[4],
Item = (string)tak[5],
ItemDescription = (string)tak[6],
ReferenceItemCode = (string)tak[7],
UnitCount = (decimal)tak[8],
//OccupyType = (string)tak[9],
HuStatusOccupyTypeDescription = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OccupyType, int.Parse((tak[9]).ToString())),
//QualityType = (string)tak[10],
QualityTypeDescription = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.QualityType, int.Parse((tak[10]).ToString())),
IsConsignment = (bool)tak[11],
IsFreeze = (bool)tak[12],
IsATP = (bool)tak[13],
HuQty = (decimal)tak[14],
HuUom = (string)tak[15],
Qty = (decimal)tak[16],
BaseUom = (string)tak[17],
HuOptionDesc = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.HuOption, int.Parse((tak[18]).ToString())),
Direction = (string)tak[19],
DirectionDescription = (string)tak[20],
MaterialsGroup = (string)tak[21],
MaterialsGroupDesc = (string)tak[22],
ItemVersion = (string)tak[23], //+ (string.IsNullOrWhiteSpace((string)tak[23]) ? "" : "[" + productTypes.ValueOrDefault((string)tak[23]).Description + "]")
Remark = (string)tak[24]
}).ToList();
#endregion
}
GridModel<LocationLotDetail> gridModel = new GridModel<LocationLotDetail>();
gridModel.Total = total;
gridModel.Data = locationLotDetailList;
return PartialView(gridModel);
}
public void Export(LocationLotDetailSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value;
ReportSearchStatementModel reportSearchStatementModel = PrepareShelfLifeWarningSearchStatement(command, searchModel);
var list = GetHuAjaxPageData<Hu>(reportSearchStatementModel);
var itemCategoryList = this.genericMgr.FindAll<ItemCategory>();
foreach (var listdata in list.Data)
{
listdata.ExpireDateValue = listdata.ExpireDate == null ? "" : listdata.ExpireDate.Value.ToString("yyyy-MM-dd");
listdata.RemindExpireDateValue = listdata.RemindExpireDate == null ? "" : listdata.RemindExpireDate.Value.ToString("yyyy-MM-dd");
listdata.MaterialsGroup = itemMgr.GetCacheItem(listdata.Item).MaterialsGroup;
listdata.MaterialsGroupDesc = GetItemCategory(listdata.MaterialsGroup, Sconit.CodeMaster.SubCategory.MaterialsGroup, itemCategoryList).Description;
}
var filename = "";
if (searchModel.SearchCondition == 1)
{
filename = "OutOfExpireTimeWarning.xls";
}
else if (searchModel.SearchCondition == 3)
{
filename = "ShelfLifeWarningSummary.xls";
}
else
{
filename = "ShelfLifeWarning.xls";
}
ExportToXLS<Hu>(filename, list.Data.ToList());
}
private ReportSearchStatementModel PrepareShelfLifeWarningSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel)
{
ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel();
reportSearchStatementModel.ProcedureName = "USP_Report_ShelfLifeWarning";
SqlParameter[] parameters = new SqlParameter[6];
parameters[0] = new SqlParameter("@Location", SqlDbType.VarChar, 8000);
parameters[0].Value = searchModel.Location;
parameters[1] = new SqlParameter("@Item", SqlDbType.VarChar, 8000);
parameters[1].Value = searchModel.Item;
if (searchModel.SearchCondition == 0)
{
searchModel.GetType = "ByExpireTime";
}
else if (searchModel.SearchCondition == 1)
{
searchModel.GetType = "ByOutOfExpireTime";
}
else if (searchModel.SearchCondition == 2)
{
searchModel.GetType = "ByRemindExpireTime";
}
else
{
searchModel.GetType = "Summary";
}
parameters[2] = new SqlParameter("@Type", SqlDbType.VarChar);
parameters[2].Value = searchModel.GetType;
parameters[3] = new SqlParameter("@PageSize", SqlDbType.VarChar);
parameters[3].Value = command.PageSize;
parameters[4] = new SqlParameter("@Page", SqlDbType.VarChar);
parameters[4].Value = command.Page;
//parameters[5] = new SqlParameter("@IsSumByItem", SqlDbType.VarChar);
//parameters[5].Value = searchModel.IsSumByItem;
reportSearchStatementModel.Parameters = parameters;
return reportSearchStatementModel;
}
public ActionResult _AjaxShelfLifeWarningList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
if (command.Page == null)
{
command.Page = 1;
}
//command.PageSize = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(com.Sconit.Entity.SYS.EntityPreference.CodeEnum.MaxRowSizeOnPage)); ;
ReportSearchStatementModel reportSearchStatementModel = PrepareShelfLifeWarningSearchStatement(command, searchModel);
var list = GetHuAjaxPageData<Hu>(reportSearchStatementModel);
var itemCategoryList = this.genericMgr.FindAll<ItemCategory>();
foreach (var listdata in list.Data)
{
listdata.ExpireDateValue = listdata.ExpireDate == null ? "": listdata.ExpireDate.Value.ToString("yyyy-MM-dd");
listdata.RemindExpireDateValue = listdata.RemindExpireDate == null ? "" : listdata.RemindExpireDate.Value.ToString("yyyy-MM-dd");
listdata.MaterialsGroup = itemMgr.GetCacheItem(listdata.Item).MaterialsGroup;
listdata.MaterialsGroupDesc = GetItemCategory(listdata.MaterialsGroup, Sconit.CodeMaster.SubCategory.MaterialsGroup, itemCategoryList).Description;
}
//foreach (var listData in list.Data)
//{
// if (listData.RemindExpireDate <= DateTime.Now && listData.ExpireDate >= DateTime.Now)
// {
// listData.ExpireStatus = "预警";
// }
// else if (listData.ExpireDate < DateTime.Now)
// {
// listData.ExpireStatus = "过期";
// }
//}
return PartialView(list);
}
private string PrepareSqlSearchStatement(LocationLotDetailSearchModel searchModel)
{
string str = @"Select isnull(a.HuId,'') HuId,isnull(a.LotNo,'') LotNo,a.Location,isnull(a.Bin,'') Bin,
a.Item, c.Desc1,c.RefCode,Isnull(a.UC,0) UC,a.OccupyType,a.QualityType,a.IsCS,
a.IsFreeze,a.IsATP,isnull(a.HuQty,0)HuQty,isnull(a.HuUom,'')HuUom,a.Qty,isnull (a.BaseUom,'')BaseUom, '' As HuOption,a.Direction,'' as DirectionDesc,
'' as MaterialsGroup,'' as MaterialsGroupDesc,'' As ItemVersion,b.Party As Party ,
a.Id from VIEW_LocationLotDet a with(nolock),BIL_PlanBill b
with(nolock), MD_Item c with(nolock),MD_Location d with
(nolock) where a.PlanBill =b.Id and a.Item =c.Code and
a.Location =d.Code and a.IsCS=1 ";
if (!string.IsNullOrEmpty(searchModel.Location))
{
str = str + string.Format(" and d.Code = '{0}'", searchModel.Location);
if (searchModel.Location == "9103")
{
str = str + " and b.Party in ('30003','30037','30029','30038','30023','30010','30224','30008')";
}
}
else
{
str = str + " and 1=2 ";
}
if (!string.IsNullOrEmpty(searchModel.Party))
{
str = str + string.Format(" and b.Party = '{0}'", searchModel.Party);
}
if (!string.IsNullOrEmpty(searchModel.Item))
{
str = str + string.Format(" and c.Code = '{0}'", searchModel.Item);
private SearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel)
{
string whereStatement = "where HuId is not Null";
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("Location", searchModel.Location, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Bin", searchModel.Bin, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("HuId", searchModel.HuId, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("OccupyType", searchModel.OccupyType, "l", ref whereStatement, param);
if (searchModel.LotNo != null & searchModel.LotNoTo != null)
{
HqlStatementHelper.AddBetweenStatement("LotNo", searchModel.LotNo, searchModel.LotNoTo, "l", ref whereStatement, param);
}
else if (searchModel.LotNo != null & searchModel.LotNoTo == null)
{
HqlStatementHelper.AddGeStatement("LotNo", searchModel.LotNo, "l", ref whereStatement, param);
}
else if (searchModel.LotNo == null & searchModel.LotNoTo != null)
{
HqlStatementHelper.AddLeStatement("LotNo", searchModel.LotNoTo, "l", ref whereStatement, param);
}
HqlStatementHelper.AddEqStatement("IsFreeze", searchModel.IsFreeze, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsConsignment", searchModel.IsConsignment, "l", ref whereStatement, param);
//HqlStatementHelper.AddEqStatement("IsATP", searchModel.IsATP, "l", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by l.Location,l.Item,l.LotNo,l.HuId,l.Direction";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountStatement;
searchStatementModel.SelectStatement = selectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
//TempData["Display"] = searchModel.Level;
//TempData["LocationLotDetailSearchModel"] = searchModel;
//ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
//if (searchModel.hideSupper)
// ViewBag.HideParty = false;
//else
// ViewBag.HideParty = true;
//if(searchModel.hideLotNo)
// ViewBag.HideLotNo = false;
//else
// ViewBag.HideLotNo = true;
//IList<Location> locationList = GetReportLocations(searchModel.SAPLocation,searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
//IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
//if (string.IsNullOrEmpty(ViewBag.Location))
// ViewBag.Location = Resources.View.LocationDetailView.LocationDetailView_Location;
//else
//ViewBag.Location = ViewBag.Location;
//if (locationList.Count > 200)
//{
// if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo))
// {
// SaveErrorMessage("物料代码为必选项！");
// return View();
// }
//}
//if (itemList.Count > 200)
//{
// SaveErrorMessage("零件超过200个！");
// return View();
//}
//if (searchModel.TypeLocation == "0")
//{
// if (string.IsNullOrEmpty(searchModel.Level))
// {
// SaveWarningMessage("汇总至为必选项！");
// return View();
// }
// if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo) && string.IsNullOrEmpty(searchModel.locationFrom) && string.IsNullOrEmpty(searchModel.locationTo)
// && string.IsNullOrEmpty(searchModel.plantFrom) && string.IsNullOrEmpty(searchModel.plantTo) && string.IsNullOrEmpty(searchModel.regionFrom) && string.IsNullOrEmpty(searchModel.regionTo)
// && string.IsNullOrEmpty(searchModel.TheFactory) && string.IsNullOrEmpty(searchModel.TheFactoryTo))
// {
// SaveWarningMessage("请根据条件查询！");
// return View();
// }
// if (string.IsNullOrEmpty(searchModel.itemFrom))
// {
// if (!string.IsNullOrEmpty(searchModel.itemTo))
// {
// SaveWarningMessage("错误：第一个物料为空的情况下，不能输入第二个物料！");
// return View();
// }
// }
// if (string.IsNullOrEmpty(searchModel.locationFrom))
// {
// if (!string.IsNullOrEmpty(searchModel.locationTo))
// {
// SaveWarningMessage("错误：第一个库位为空的情况下，不能输入第二个库位！");
// return View();
// }
// }
// if (string.IsNullOrEmpty(searchModel.regionFrom))
// {
// if (!string.IsNullOrEmpty(searchModel.regionTo))
// {
// SaveWarningMessage("错误：第一个区域为空的情况下，不能输入第二个区域！");
// return View();
// }
// }
// if (string.IsNullOrEmpty(searchModel.TheFactory))
// {
// if (!string.IsNullOrEmpty(searchModel.TheFactoryTo))
// {
// SaveWarningMessage("错误：第一个工厂为空的情况下，不能输入第二个工厂！");
// return View();
// }
// }
// if (string.IsNullOrEmpty(searchModel.plantFrom))
// {
// if (!string.IsNullOrEmpty(searchModel.plantTo))
// {
// SaveWarningMessage("错误：第一个分厂为空的情况下，不能输入第二个分厂！");
// return View();
// }
// }
//}
//else
//{
// if (string.IsNullOrEmpty(searchModel.SAPLocation))
// {
// SaveWarningMessage("错误：根据SAP库位查询，SAP库位不能为空！");
// return View();
// }
//}
//string locations = string.Empty;
//string items = string.Empty;
//string[] locationArr = searchModel.locations.Split(',');
//string[] itemArr = searchModel.items.Split(',');
//for (int i = 0; i < locationArr.Length; i++)
//{
// if (!string.IsNullOrWhiteSpace(locationArr[i]) && locationArr[i] != "null" && locationArr[i] != "NULL")
// {
// locations += locationArr[i]+",";
// }
//}
//for (int i = 0; i < itemArr.Length; i++)
//{
// if (!string.IsNullOrWhiteSpace(itemArr[i]) && itemArr[i] != "null" && itemArr[i] != "NULL")
// {
// items += itemArr[i] + ",";
// }
//}
//ViewBag.Locations = locations;
//ViewBag.Items = items;
ViewBag.IsShowCSSupplier = searchModel.IsShowCSSupplier;
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
return View();
}
private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel)
{
ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel();
reportSearchStatementModel.ProcedureName = "USP_Report_RealTimeLocationDet";
IList<Location> locationList = GetReportLocations(searchModel.SAPLocation,searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
string location = string.Empty;
foreach (var lcoList in locationList)
{
if (location == string.Empty)
{
location = lcoList.Code;
}
else
{
location += "," + lcoList.Code;
}
}
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
string item = string.Empty;
foreach (var ite in itemList)
{
if (item == string.Empty)
{
item = ite.Code;
}
else
{
item += "," + ite.Code;
}
}
SqlParameter[] parameters = new SqlParameter[9];
parameters[0] = new SqlParameter("@Locations", SqlDbType.VarChar, 8000);
parameters[0].Value = location;
parameters[1] = new SqlParameter("@Items", SqlDbType.VarChar, 8000);
parameters[1].Value = item;
parameters[2] = new SqlParameter("@SortDesc", SqlDbType.VarChar, 50);
parameters[2].Value = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
parameters[3] = new SqlParameter("@PageSize", SqlDbType.Int);
parameters[3].Value = command.PageSize;
parameters[4] = new SqlParameter("@Page", SqlDbType.Int);
parameters[4].Value = command.Page;
parameters[5] = new SqlParameter("@SummaryLevel", SqlDbType.VarChar, 50);
parameters[5].Value = searchModel.Level;
//逻辑修改，默认按供应商group
parameters[6] = new SqlParameter("@IsGroupByManufactureParty", SqlDbType.Bit);
parameters[6].Value = true;
parameters[7] = new SqlParameter("@IsGroupByLotNo", SqlDbType.Bit);
parameters[7].Value = searchModel.hideLotNo;
parameters[8] = new SqlParameter("@IsSummaryBySAPLoc", SqlDbType.Bit);
parameters[8].Value = searchModel.TypeLocation == "1" ? true : false; ;
reportSearchStatementModel.Parameters = parameters;
return reportSearchStatementModel;
}
public ActionResult _AjaxCopyList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
DataTable locationArrayTable = new DataTable("LocationArrayTable");
locationArrayTable.Columns.Add("Field", typeof(string));
if (!string.IsNullOrEmpty(searchModel.locations))
{
string loctions = searchModel.locations.Replace("\r\n", ",");
loctions = loctions.Replace("\n", ",");
string[] locationArr = loctions.Split(',');
for (int i = 0; i < locationArr.Length; i++)
{
if (!string.IsNullOrWhiteSpace(locationArr[i]) && locationArr[i] != "null" && locationArr[i] != "NULL")
{
locationArrayTable.Rows.Add(locationArr[i]);
}
}
}
DataTable itemArrayTable = new DataTable("ItemArrayTable");
itemArrayTable.Columns.Add("Field", typeof(string));
if (!string.IsNullOrEmpty(searchModel.items))
{
string items = searchModel.items.Replace("\r\n", ",");
items = items.Replace("\n", ",");
string[] itemArr = items.Split(',');
for (int i = 0; i < itemArr.Length; i++)
{
if (!string.IsNullOrWhiteSpace(itemArr[i]) && itemArr[i] != "null" && itemArr[i] != "NULL")
{
itemArrayTable.Rows.Add(itemArr[i]);
}
}
}
SqlParameter[] parameters = new SqlParameter[10];
parameters[0] = new SqlParameter("@LocationArrayTable", System.Data.SqlDbType.Structured);
parameters[0].Value = locationArrayTable;
parameters[1] = new SqlParameter("@IsSapLocation", System.Data.SqlDbType.Bit);
parameters[1].Value = searchModel.IsSapLocation;
parameters[2] = new SqlParameter("@ItemArrayTable", System.Data.SqlDbType.Structured);
parameters[2].Value = itemArrayTable;
parameters[3] = new SqlParameter("@IsShowCSSupplier", System.Data.SqlDbType.Bit);
parameters[3].Value = searchModel.IsShowCSSupplier;
parameters[4] = new SqlParameter("@SortCloumn", System.Data.SqlDbType.VarChar,50);
parameters[4].Value =command.SortDescriptors.Count>0? command.SortDescriptors[0].Member:string.Empty;
parameters[5] = new SqlParameter("@SortRule", System.Data.SqlDbType.VarChar, 50);
parameters[5].Value = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc":string.Empty;
parameters[6] = new SqlParameter("@PageSize", SqlDbType.Int);
parameters[6].Value = command.PageSize;
parameters[7] = new SqlParameter("@Pager", SqlDbType.Int);
parameters[7].Value = command.Page;
parameters[8] = new SqlParameter("@UserId", SqlDbType.Int);
parameters[8].Value = CurrentUser.Id;
parameters[9] = new SqlParameter("@RowCount", System.Data.SqlDbType.VarChar, 50);
parameters[9].Direction = ParameterDirection.Output;
IList<LocationDetailView> locationDetailView = new List<LocationDetailView>();
try
{
DataSet dataSet = sqlDao.GetDatasetByStoredProcedure("USP_Search_LocationLotDet", parameters, false);
//Item, Desc1, RefCode, Uom, Location, Qty, CSQty, QulifiedQty, InspectedQty, RejectedQty
//Item, Desc1, RefCode, Uom, Location, Qty, CSSupplier, QulifiedQty, InspectedQty, RejectedQty
if (dataSet.Tables[0] != null && dataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dataSet.Tables[0].Rows)
{
//row.ItemArray[0].ToString()
LocationDetailView lotDet = new LocationDetailView();
lotDet.Item = row.ItemArray[0].ToString();
lotDet.ItemDescription = row.ItemArray[1].ToString();
lotDet.RefrenceItemCode = row.ItemArray[2].ToString();
lotDet.Uom = row.ItemArray[3].ToString();
lotDet.Location = row.ItemArray[4].ToString();
lotDet.Qty = Convert.ToDecimal(row.ItemArray[5]);
if (searchModel.IsShowCSSupplier)
{
lotDet.suppliers = row.ItemArray[6].ToString();
}
else
{
lotDet.ConsignmentQty = Convert.ToDecimal(row.ItemArray[6]);
}
lotDet.QualifyQty = Convert.ToDecimal(row.ItemArray[7]);
lotDet.InspectQty = Convert.ToDecimal(row.ItemArray[8]);
lotDet.RejectQty = Convert.ToDecimal(row.ItemArray[9]);
locationDetailView.Add(lotDet);
}
}
}
catch (BusinessException be)
{
SaveBusinessExceptionMessage(be);
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
if (ex.InnerException.InnerException != null)
{
SaveErrorMessage(ex.InnerException.InnerException.Message);
}
else
{
SaveErrorMessage(ex.InnerException.Message);
}
}
else
{
SaveErrorMessage(ex.Message);
}
}
GridModel<LocationDetailView> gridModel = new GridModel<LocationDetailView>();
gridModel.Total = string.IsNullOrWhiteSpace(parameters[9].Value.ToString()) ? 0 : Convert.ToInt32(parameters[9].Value);
gridModel.Data = locationDetailView;
return PartialView(gridModel);
}
public void ExportXLS(LocationLotDetailSearchModel searchModel)
{
int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = value;
string sql = PrepareSqlSearchStatement(searchModel);
string sortingStatement = TempData["sortingStatement"] as string;
TempData["sortingStatement"] = sortingStatement;
if (string.IsNullOrWhiteSpace(sortingStatement))
{
sortingStatement = " order by Location,Item,LotNo,HuId,Direction";
}
IList<object[]> searchResult = this.genericMgr.FindAllWithNativeSql<object[]>("select top " + value + " 1,r.* from (" + sql + ") as r ");
IList<LocationLotDetail> locationLotDetailList = new List<LocationLotDetail>();
if (searchResult != null && searchResult.Count > 0)
{
#region
var productTypes = genericMgr.FindAll<ProductType>().ToDictionary(d => d.Code, d => d);
//ld.HuId,ld.LotNo,ld.Location,ld.Bin,ld.Item,i.Desc1,i.RefCode,ld.UC,ld.OccupyType,ld.QualityType,ld.IsCS,
//ld.IsFreeze,ld.IsATP,ld.HuQty,ld.HuUom,ld.Qty,ld.BaseUom,hu.HuOption,ld.Direction,ht.Desc1
locationLotDetailList = (from tak in searchResult
select new LocationLotDetail
{
HuId = (string)tak[1],
LotNo = (string)tak[2],
Location = (string)tak[3],
Bin = (string)tak[4],
Item = (string)tak[5],
ItemDescription = (string)tak[6],
ReferenceItemCode = (string)tak[7],
UnitCount = (decimal)tak[8],
HuStatusOccupyTypeDescription = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OccupyType, int.Parse((tak[9]).ToString())),
QualityTypeDescription = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.QualityType, int.Parse((tak[10]).ToString())),
IsConsignment = (bool)tak[11],
IsFreeze = (bool)tak[12],
IsATP = (bool)tak[13],
HuQty = (decimal)tak[14],
HuUom = (string)tak[15],
Qty = (decimal)tak[16],
BaseUom = (string)tak[17],
HuOptionDesc = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.HuOption, int.Parse((tak[18]).ToString())),
Direction = (string)tak[19],
DirectionDescription = (string)tak[20],
MaterialsGroup = (string)tak[21],
MaterialsGroupDesc = (string)tak[22],
ItemVersion = (string)tak[23] + (string.IsNullOrWhiteSpace((string)tak[23]) ? "" : "[" + productTypes.ValueOrDefault((string)tak[23]).Description + "]")
}).ToList();
#endregion
}
ExportToXLS<LocationLotDetail>("LocationLotDetail.xls", locationLotDetailList);
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
if (searchModel.TypeLocation == "0")
{
if (string.IsNullOrEmpty(searchModel.Level))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo) && string.IsNullOrEmpty(searchModel.locationFrom) && string.IsNullOrEmpty(searchModel.locationTo)
&& string.IsNullOrEmpty(searchModel.plantFrom) && string.IsNullOrEmpty(searchModel.plantTo) && string.IsNullOrEmpty(searchModel.regionFrom) && string.IsNullOrEmpty(searchModel.regionTo))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
if (string.IsNullOrEmpty(searchModel.itemFrom))
{
if (!string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
}
if (string.IsNullOrEmpty(searchModel.locationFrom))
{
if (!string.IsNullOrEmpty(searchModel.locationTo))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
}
if (string.IsNullOrEmpty(searchModel.regionFrom))
{
if (!string.IsNullOrEmpty(searchModel.regionTo))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
}
if (string.IsNullOrEmpty(searchModel.TheFactory))
{
if (!string.IsNullOrEmpty(searchModel.TheFactoryTo))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
}
if (string.IsNullOrEmpty(searchModel.plantFrom))
{
if (!string.IsNullOrEmpty(searchModel.plantTo))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
}
}
else
{
if (string.IsNullOrEmpty(searchModel.SAPLocation))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
}
IList<Location> locationList = GetReportLocations(searchModel.SAPLocation,searchModel.plantFrom, searchModel.plantTo, searchModel.regionFrom, searchModel.regionTo, searchModel.locationFrom, searchModel.locationTo);
IList<Item> itemList = GetReportItems(searchModel.itemFrom, searchModel.itemTo);
if (locationList.Count > 200)
{
if (string.IsNullOrEmpty(searchModel.itemFrom) && string.IsNullOrEmpty(searchModel.itemTo))
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
}
if (itemList.Count > 200)
{
return PartialView(new GridModel(new List<LocationDetailView>()));
}
ReportSearchStatementModel reportSearchStatementModel = PrepareSearchStatement(command, searchModel);
GridModel<LocationDetailView> gridModel = GetReportAjaxPageData<LocationDetailView>(reportSearchStatementModel);
//foreach (LocationDetailView locationDetail in gridModel.Data)
//{
// Item item = base.genericMgr.FindById<Item>(locationDetail.Item);
// locationDetail.ItemDescription = item.Description;
// locationDetail.Uom = item.Uom;
// //locationDetail.Name = base.genericMgr.FindById<Location>(locationDetail.Location).Name; ;
//}
reportSearchStatementModel.Parameters[3].Value = gridModel.Total;
TempData["LocationDetailView"] = reportSearchStatementModel;
return PartialView(gridModel);
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
this.GetCommand(ref command, searchModel);
string sql = PrepareSqlSearchStatement(searchModel);
int num = base.genericMgr.FindAllWithNativeSql<int>("select count(*) from (" + sql + ") as r1").First<int>();
string sortingStatement = string.Empty;
if (command.SortDescriptors.Count != 0)
{
if (command.SortDescriptors[0].Member == "UnitCount")
{
command.SortDescriptors[0].Member = "UC";
}
else if (command.SortDescriptors[0].Member == "HuStatusOccupyTypeDescription")
{
command.SortDescriptors[0].Member = "OccupyType";
}
else if (command.SortDescriptors[0].Member == "HuOptionDesc")
{
command.SortDescriptors[0].Member = "HuOption";
}
else if (command.SortDescriptors[0].Member == "QualityTypeDescription")
{
command.SortDescriptors[0].Member = "QualityType";
}
else if (command.SortDescriptors[0].Member == "IsConsignment")
{
command.SortDescriptors[0].Member = "IsCS";
}
else if (command.SortDescriptors[0].Member == "ManufactureParty")
{
command.SortDescriptors[0].Member = "Party";
}
sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
base.TempData["sortingStatement"] = sortingStatement;
}
if (string.IsNullOrWhiteSpace(sortingStatement))
{
sortingStatement = " order by Location,Item,HuId";
}
sql = string.Format("select * from (select RowId=ROW_NUMBER()OVER({0}),r1.* from ({1}) as r1 ) as rt where rt.RowId between {2} and {3}", new object[] { sortingStatement, sql, ((command.Page - 1) * command.PageSize) + 1, command.PageSize * command.Page });
IList<object[]> list = base.genericMgr.FindAllWithNativeSql<object[]>(sql);
IList<LocationLotDetail> list2 = new List<LocationLotDetail>();
if ((list != null) && (list.Count > 0))
{
list2 = (from tak in list
select new LocationLotDetail
{
HuId = (string)tak[1],
LotNo = (string)tak[2],
Location = (string)tak[3],
Bin = (string)tak[4],
Item = (string)tak[5],
ItemDescription = (string)tak[6],
ReferenceItemCode = (string)tak[7],
UnitCount = (decimal)tak[8],
IsConsignment = (bool)tak[11],
IsFreeze = (bool)tak[12],
IsATP = (bool)tak[13],
HuQty = (decimal)tak[14],
HuUom = (string)tak[15],
Qty = (decimal)tak[16],
BaseUom = (string)tak[17],
ManufactureParty = (string)tak[24],
Id = (int)tak[25]
}).ToList<LocationLotDetail>();
}
GridModel<LocationLotDetail> model = new GridModel<LocationLotDetail>
{
Total = num,
Data = list2
};
return base.PartialView(model);
}
private ReportSearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel)
{
ReportSearchStatementModel reportSearchStatementModel = new ReportSearchStatementModel();
reportSearchStatementModel.ProcedureName = "USP_Busi_GetPlusInventoryHuId";
SqlParameter[] parameters = new SqlParameter[6];
parameters[0] = new SqlParameter("@Location", SqlDbType.VarChar, 50);
parameters[0].Value = searchModel.Location;
parameters[1] = new SqlParameter("@Item", SqlDbType.VarChar, 50);
parameters[1].Value = searchModel.Item;
parameters[2] = new SqlParameter("@LotNoFrom", SqlDbType.VarChar, 50);
parameters[2].Value = searchModel.LotNoFrom;
parameters[3] = new SqlParameter("@LotNoTo", SqlDbType.VarChar,50);
parameters[3].Value = searchModel.LotNoTo;
parameters[4] = new SqlParameter("@IsFrozen", SqlDbType.Bit);
parameters[4].Value = searchModel.IsFreeze;
parameters[5] = new SqlParameter("@IsConsignment", SqlDbType.Bit);
parameters[5].Value = searchModel.IsConsignment;
reportSearchStatementModel.Parameters = parameters;
return reportSearchStatementModel;
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, LocationLotDetailSearchModel searchModel)
{
string whereStatement = " where HuId is not null";
IList<object> param = new List<object>();
SecurityHelper.AddLocationPermissionStatement(ref whereStatement, "l", "Location");
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("LotNo", searchModel.LotNo, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Location", searchModel.Location, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("ManufactureParty", searchModel.ManufactureParty, "l", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsFreeze", searchModel.IsFreeze, "l", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountStatement;
searchStatementModel.SelectStatement = selectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult List(GridCommand command, LocationLotDetailSearchModel searchModel)
{
TempData["LocationLotDetailSearchModel"] = searchModel;
return View();
}
public ActionResult _CopySearchResult(GridCommand command, LocationLotDetailSearchModel searchModel)
{
return PartialView();
}
public ActionResult _AjaxList(GridCommand command, LocationLotDetailSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<LocationLotDetail>(searchStatementModel, command));
}