public ActionResult List(GridCommand command, HuSearchModel searchModel)
{
TempData["HuSearchModel"] = searchModel;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult ShelfLifeWarningList(GridCommand command, HuSearchModel searchModel)
{
TempData["HuSearchModel"] = searchModel;
ViewBag.SearchCondition = searchModel.SearchCondition;
ViewBag.IsSumByItem = searchModel.IsSumByItem;
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult List(GridCommand command, HuSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
if (searchCacheModel.isBack == true)
{
ViewBag.Page = searchCacheModel.Command.Page == 0 ? 1 : searchCacheModel.Command.Page;
}
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public ActionResult _AjaxList(GridCommand command, HuSearchModel searchModel)
{
TempData["HuSearchModel"] = searchModel;
this.GetCommand(ref command, searchModel);
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
var list = GetAjaxPageData<Hu>(searchStatementModel, command);
foreach (var data in list.Data)
{
data.HuStatus = huMgr.GetHuStatus(data.HuId);
data.ItemDescription = string.IsNullOrWhiteSpace(data.ReferenceItemCode) ? data.ItemDescription : data.ItemDescription + "[" + data.ReferenceItemCode + "]";
}
return PartialView(list);
}
private SearchStatementModel PrepareSearchStatementTime(GridCommand command, HuSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("Item", searchModel.HuId, "h", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("LocTo", searchModel.Location, "h", ref whereStatement, param);
//if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End != null)
//{
// HqlStatementHelper.AddBetweenStatement("RemindExpireDate", searchModel.RemindExpireDate_start, searchModel.RemindExpireDate_End, "h", ref whereStatement, param);
//}
//else if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End == null)
//{
// HqlStatementHelper.AddGeStatement("RemindExpireDate", searchModel.RemindExpireDate_start, "h", ref whereStatement, param);
//}
//else if (searchModel.RemindExpireDate_start == null & searchModel.RemindExpireDate_End != null)
//{
// HqlStatementHelper.AddLeStatement("RemindExpireDate", searchModel.RemindExpireDate_End, "h", ref whereStatement, param);
//}
//else
//{
//HqlStatementHelper.AddLeStatement("RemindExpireDate", DateTime.Now, "h", ref whereStatement, param);
//}
if (searchModel.StartDate != null & searchModel.EndDate != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "h", ref whereStatement, param);
}
else if (searchModel.StartDate != null & searchModel.EndDate == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "h", ref whereStatement, param);
}
else if (searchModel.StartDate == null & searchModel.EndDate != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "h", 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;
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, HuSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddLikeStatement("HuId", searchModel.HuId, HqlStatementHelper.LikeMatchMode.Anywhere, "h", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("CreateUserName", searchModel.CreateUserName, HqlStatementHelper.LikeMatchMode.Start, "h", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "h", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("SupplierLotNo", searchModel.SupplierLotNo, "h", ref whereStatement, param);
if (searchModel.LotNo != null & searchModel.LotNoTo != null)
{
HqlStatementHelper.AddBetweenStatement("LotNo", searchModel.LotNo, searchModel.LotNoTo, "h", ref whereStatement, param);
}
else if (searchModel.LotNo != null & searchModel.LotNoTo == null)
{
HqlStatementHelper.AddGeStatement("LotNo", searchModel.LotNo, "h", ref whereStatement, param);
}
else if (searchModel.LotNo == null & searchModel.LotNoTo != null)
{
HqlStatementHelper.AddLeStatement("LotNo", searchModel.LotNoTo, "h", ref whereStatement, param);
}
if (searchModel.StartDate != null & searchModel.EndDate != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "h", ref whereStatement, param);
}
else if (searchModel.StartDate != null & searchModel.EndDate == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "h", ref whereStatement, param);
}
else if (searchModel.StartDate == null & searchModel.EndDate != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "h", ref whereStatement, param);
}
if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End != null)
{
HqlStatementHelper.AddBetweenStatement("RemindExpireDate", searchModel.RemindExpireDate_start, searchModel.RemindExpireDate_End, "h", ref whereStatement, param);
}
else if (searchModel.RemindExpireDate_start != null & searchModel.RemindExpireDate_End == null)
{
HqlStatementHelper.AddGeStatement("RemindExpireDate", searchModel.RemindExpireDate_start, "h", ref whereStatement, param);
}
else if (searchModel.RemindExpireDate_start == null & searchModel.RemindExpireDate_End != null)
{
HqlStatementHelper.AddLeStatement("RemindExpireDate", searchModel.RemindExpireDate_End, "h", ref whereStatement, param);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by 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, HuSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<SmallSparePartChk>(searchStatementModel, command));
}
public ActionResult List(GridCommand command, HuSearchModel searchModel)
{
SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel);
ViewBag.PageSize = base.ProcessPageSize(command.PageSize);
return View();
}
public void ExportXLS(HuSearchModel searchModel)
{
int value = System.Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage));
GridCommand command = new GridCommand();
command.Page = 1;
command.PageSize = value;
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
GridModel<SmallSparePartChk> gridModel = GetAjaxPageData<SmallSparePartChk>(searchStatementModel, command);
var fileName = string.Format("SmallMatchSparePartCheck.xls");
ExportToXLS<SmallSparePartChk>(fileName, gridModel.Data.ToList());
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">SmallSparePartChk Search Model</param>
/// <returns>return Search Statement</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, HuSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddLikeStatement("Huid", searchModel.HuId, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("SpareItem", searchModel.SpareItem, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("HuItem", searchModel.HuItem, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("CreateUserName", searchModel.CreateUserName, HqlStatementHelper.LikeMatchMode.Start, "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);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (string.IsNullOrWhiteSpace(sortingStatement))
{
sortingStatement = " order by i.CreateDate ";
}
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, HuSearchModel searchModel)
{
TempData["HuSearchModel"] = searchModel;
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
return PartialView(GetAjaxPageData<Hu>(searchStatementModel, command));
}
public ActionResult _AjaxShelfLifeWarningList(GridCommand command, HuSearchModel searchModel)
{
SearchStatementModel searchStatementModel = PrepareSearchStatementTime(command, searchModel);
return PartialView(GetAjaxPageData<Hu>(searchStatementModel, command));
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, HuSearchModel searchModel)
{
string whereStatement = string.Empty;
com.Sconit.Entity.ACC.User user = SecurityContextHolder.Get();
IList<object> param = new List<object>();
HqlStatementHelper.AddLikeStatement("HuId", searchModel.HuId, HqlStatementHelper.LikeMatchMode.Start, "h", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "h", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("LotNo", searchModel.lotNo, HqlStatementHelper.LikeMatchMode.Start, "h", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("ManufactureParty", searchModel.ManufactureParty, "h", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("CreateUserId", user.Id, "h", ref whereStatement, param);
if (searchModel.StartDate != null & searchModel.EndDate != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "h", ref whereStatement, param);
}
else if (searchModel.StartDate != null & searchModel.EndDate == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "h", ref whereStatement, param);
}
else if (searchModel.StartDate == null & searchModel.EndDate != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "h", ref whereStatement, param);
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by 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;
}
