private SearchStatementModel PrepareSearchStatement(GridCommand command, UserSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("FirstName", searchModel.FirstName, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("LastName", searchModel.LastName, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsActive", searchModel.IsActive, "u", ref whereStatement, param);
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "LanguageDescription")
{
command.SortDescriptors[0].Member = "Language";
}
}
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 CancelList(GridCommand command, ReceiptMasterSearchModel searchModel)
{
SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel);
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, (ReceiptMasterSearchModel)searchCacheModel.SearchObject);
return(View(GetPageData <ReceiptMaster>(searchStatementModel, command)));
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, ReceiptMasterSearchModel searchModel)
{
string whereStatement = " where r.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Return +
" and r.OrderType in (" + (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.Procurement
+ "," + (int)com.Sconit.CodeMaster.OrderType.SubContract + ")";
IList <object> param = new List <object>();
//SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "r", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true);
SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "r", "OrderType", "r", "PartyTo", "r", "PartyFrom", com.Sconit.CodeMaster.OrderType.Procurement, true);
HqlStatementHelper.AddLikeStatement("WMSNo", searchModel.WMSNo, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("ReceiptNo", searchModel.ReceiptNo, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "r", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "r", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("OrderType", searchModel.GoodsReceiptOrderType, "r", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "r", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "r", ref whereStatement, param);
if (searchModel.StartDate != null & searchModel.EndDate != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "r", ref whereStatement, param);
}
else if (searchModel.StartDate != null & searchModel.EndDate == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "r", ref whereStatement, param);
}
else if (searchModel.StartDate == null & searchModel.EndDate != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "r", ref whereStatement, param);
}
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "ReceiptMasterStatusDescription")
{
command.SortDescriptors[0].Member = "Status";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (command.SortDescriptors.Count == 0)
{
sortingStatement = " order by r.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 _AjaxIndex(GridCommand command, EntityPreferenceSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
GridModel <EntityPreference> list = GetAjaxPageData <EntityPreference>(searchStatementModel, command);
foreach (EntityPreference entityPreference in list.Data)
{
entityPreference.EntityPreferenceDesc = this.systemMgr.TranslateEntityPreferenceDescription(entityPreference.Description.ToString());
}
return(PartialView(list));
}
public ActionResult _AjaxList(GridCommand command, LocationSearchModel searchModel)
{
searchModel.IsActive = true;
if (searchModel.IsIncludeInActive)
{
searchModel.IsActive = false;
}
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
return(PartialView(GetAjaxPageData <Location>(searchStatementModel, command)));
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">GridCommand Telerik</param>
/// <param name="searchModel">UomConversion Search Model</param>
/// <returns>Search Statement</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, UomConversionSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
if (!string.IsNullOrEmpty(searchModel.Uom))
{
whereStatement = " where (u.BaseUom = ? or u.AlterUom = ?)";
param.Add(searchModel.Uom);
param.Add(searchModel.Uom);
}
HqlStatementHelper.AddLikeStatement("Code", searchModel.ItemCode, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "AlterUom")
{
command.SortDescriptors[0].Member = "u.AlterUom";
}
else if (command.SortDescriptors[0].Member == "AlterQty")
{
command.SortDescriptors[0].Member = "u.AlterQty";
}
else if (command.SortDescriptors[0].Member == "BaseUom")
{
command.SortDescriptors[0].Member = "u.BaseUom";
}
else if (command.SortDescriptors[0].Member == "BaseQty")
{
command.SortDescriptors[0].Member = "u.BaseQty";
}
else if (command.SortDescriptors[0].Member == "ItemCode")
{
command.SortDescriptors[0].Member = "u.Item";
}
else if (command.SortDescriptors[0].Member == "ItemDescription")
{
command.SortDescriptors[0].Member = "i.Description";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = uomConvertselectCountStatement;
searchStatementModel.SelectStatement = uomConvertselectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray <object>();
return(searchStatementModel);
}
private SearchStatementModel PrepareShipSearchStatement(GridCommand command, OrderMasterSearchModel searchModel)
{
string whereStatement = " where o.Type in (" + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract + ")"
+ " and o.IsShipScanHu = 0 and o.Status in (" + (int)com.Sconit.CodeMaster.OrderStatus.Submit + "," + (int)com.Sconit.CodeMaster.OrderStatus.InProcess + ")"
+ " and o.SubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal
+ " and exists (select 1 from OrderDetail as d where d.ShippedQty < d.OrderedQty and d.OrderNo = o.OrderNo) ";
//SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "o", "PartyFrom", com.Sconit.CodeMaster.OrderType.Procurement, true);
SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "o", "Type", "o", "PartyFrom", "o", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true);
IList <object> param = new List <object>();
if (!string.IsNullOrEmpty(searchModel.OrderNo))
{
HqlStatementHelper.AddLikeStatement("OrderNo", searchModel.OrderNo, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param);
}
else if (!string.IsNullOrEmpty(searchModel.Flow))
{
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "o", ref whereStatement, param);
}
else if (!string.IsNullOrEmpty(searchModel.PartyFrom) && !string.IsNullOrEmpty(searchModel.PartyTo))
{
HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "o", ref whereStatement, param);
}
else if (!string.IsNullOrEmpty(searchModel.Dock))
{
HqlStatementHelper.AddLikeStatement("Dock", searchModel.Dock, HqlStatementHelper.LikeMatchMode.Start, "o", 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 _AjaxUomConvertList(GridCommand command, UomConversionSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
GridModel <UomConversion> uomConvList = GetAjaxPageData <UomConversion>(searchStatementModel, command);
foreach (var item in uomConvList.Data)
{
if (item.Item != null)
{
item.ItemCode = item.Item.Code;
item.ItemDescription = item.Item.Description;
}
}
return(PartialView(uomConvList));
}
/// <summary>
/// the Prepare Search Statements for PermissionGroup by Some Condition
/// </summary>
/// <param name="command">Grid Command</param>
/// <param name="searchModel">PermissionGroup SearchModel</param>
/// <returns>searchStatementModel of PermissionGroup </returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, PermissionGroupSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "u", 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);
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">LocationArea Search Model</param>
/// <param name="locationCode">location Code</param>
/// <returns>Search Statement</returns>
private SearchStatementModel LocationAreaPrepareSearchStatement(GridCommand command, LocationAreaSearchModel searchModel, string locationCode)
{
string whereLocationStatement = "where l.Location = '" + locationCode + "'";
IList <object> param = new List <object>();
HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "l", ref whereLocationStatement, param);
HqlStatementHelper.AddLikeStatement("Name", searchModel.Name, HqlStatementHelper.LikeMatchMode.Start, "l", ref whereLocationStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = locationAreaselectCountStatement;
searchStatementModel.SelectStatement = locationAreaselectStatement;
searchStatementModel.WhereStatement = whereLocationStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray <object>();
return(searchStatementModel);
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, PlanBillSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "p", "Party", com.Sconit.CodeMaster.OrderType.Procurement, true);
HqlStatementHelper.AddLikeStatement("OrderNo", searchModel.OrderNo, HqlStatementHelper.LikeMatchMode.Start, "p", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("ReceiptNo", searchModel.ReceiptNo, HqlStatementHelper.LikeMatchMode.Start, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "p", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Party", searchModel.Party, "p", ref whereStatement, param);
if (searchModel.CreateDate_start != null & searchModel.CreateDate_End != null)
{
HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.CreateDate_start, searchModel.CreateDate_End, "p", ref whereStatement, param);
}
else if (searchModel.CreateDate_start != null & searchModel.CreateDate_End == null)
{
HqlStatementHelper.AddGeStatement("CreateDate", searchModel.CreateDate_start, "p", ref whereStatement, param);
}
else if (searchModel.CreateDate_start == null & searchModel.CreateDate_End != null)
{
HqlStatementHelper.AddLeStatement("CreateDate", searchModel.CreateDate_End, "p", ref whereStatement, param);
}
if (whereStatement == string.Empty)
{
whereStatement += " where p.PlanQty>p.ActingQty";
}
else
{
whereStatement += " and p.PlanQty>p.ActingQty";
}
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);
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="itemRefsearchModel">ItemPackage Search Model</param>
/// <param name="id">ItemPackage id</param>
/// <returns>return Search Statement</returns>
private SearchStatementModel ItemPackagePrepareSearchStatement(GridCommand command, ItemPackageSearchModel itemPackageSearchModel, string id)
{
string whereStatement = " where i.Item='" + id + "'";
IList <object> param = new List <object>();
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectItemPackageCountStatement;
searchStatementModel.SelectStatement = selectItemPackageStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray <object>();
return(searchStatementModel);
}
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);
}
public ActionResult update(int?id, string value, GridCommand command, EntityPreferenceSearchModel searchModel)
{
if (id.HasValue)
{
EntityPreference entityPreference = base.genericMgr.FindById <EntityPreference>((int)id);
entityPreference.Value = value;
base.genericMgr.Update(entityPreference);
//SaveSuccessMessage(Resources.SYS.EntityPreference.EntityPreference_Updated);
}
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
GridModel <EntityPreference> gridmodel = GetAjaxPageData <EntityPreference>(searchStatementModel, command);
foreach (var item in gridmodel.Data)
{
item.EntityPreferenceDesc = this.systemMgr.TranslateEntityPreferenceDescription(item.Description.ToString());
}
return(PartialView(gridmodel));
}
public ActionResult _AjaxIpDetailList(GridCommand command, IpDetailSearchModel searchModel)
{
if (string.IsNullOrEmpty(searchModel.IpNo))
{
return(PartialView(new GridModel(new List <IpDetail>())));
}
else
{
SearchStatementModel searchStatementModel = PrepareIpDetailSearchStatement(command, searchModel);
GridModel <IpDetail> List = GetAjaxPageData <IpDetail>(searchStatementModel, command);
foreach (IpDetail flow in List.Data)
{
IpMaster item = base.genericMgr.FindById <IpMaster>(flow.IpNo);
flow.ManufactureParty = item.PartyFrom;
flow.LotNo = LotNoHelper.GenerateLotNo();
flow.HuQty = flow.Qty;
}
return(PartialView(List));
}
}
private SearchStatementModel PrepareSearchStatement(GridCommand command, OrderMasterSearchModel searchModel)
{
string whereStatement = " where o.Type in (" + (int)com.Sconit.CodeMaster.OrderType.Distribution + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")"
+ " and o.SubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal;
IList <object> param = new List <object>();
HqlStatementHelper.AddLikeStatement("OrderNo", searchModel.OrderNo, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "o", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("CreateUserName", searchModel.CreateUserName, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "o", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Priority", searchModel.Priority, "o", ref whereStatement, param);
//SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "o", "PartyFrom", com.Sconit.CodeMaster.OrderType.Procurement, true);
SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "o", "Type", "o", "PartyFrom", "o", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true);
if (searchModel.DateFrom != null & searchModel.DateTo != null)
{
HqlStatementHelper.AddBetweenStatement("StartTime", searchModel.DateFrom, searchModel.DateTo, "o", ref whereStatement, param);
}
else if (searchModel.DateFrom != null & searchModel.DateTo == null)
{
HqlStatementHelper.AddGeStatement("StartTime", searchModel.DateFrom, "o", ref whereStatement, param);
}
else if (searchModel.DateFrom == null & searchModel.DateTo != null)
{
HqlStatementHelper.AddLeStatement("StartTime", searchModel.DateTo, "o", 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);
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">Location Search Model</param>
/// <returns>Search Statement</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, LocationSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
HqlStatementHelper.AddLikeStatement("SAPLocation", searchModel.SAPLocation, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("Name", searchModel.Name, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Region", searchModel.Region, "u", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsActive", searchModel.IsActive, "u", ref whereStatement, param);
if (searchModel.AllowNegaInv)
{
HqlStatementHelper.AddEqStatement("AllowNegative", searchModel.AllowNegaInv, "u", ref whereStatement, param);
}
if (searchModel.IsMRP)
{
HqlStatementHelper.AddEqStatement("IsMRP", searchModel.IsMRP, "u", ref whereStatement, param);
}
if (searchModel.AllowNegativeConsignment)
{
HqlStatementHelper.AddEqStatement("AllowNegativeConsignment", searchModel.AllowNegativeConsignment, "u", ref whereStatement, param);
}
if (searchModel.IsSource)
{
HqlStatementHelper.AddEqStatement("IsSource", searchModel.IsSource, "u", 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 PrepareOrderDetailSearchStatement(GridCommand command, OrderMasterSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
HqlStatementHelper.AddEqStatement("OrderNo", searchModel.OrderNo, "o", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectOrderCountStatement;
searchStatementModel.SelectStatement = selectOrderStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray <object>();
return(searchStatementModel);
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">Item Search Model</param>
/// <returns>return Search Statement</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, ItemSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
HqlStatementHelper.AddLikeStatement("ReferenceCode", searchModel.ReferenceCode, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("Description", searchModel.Description, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsActive", searchModel.IsActive, "i", 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 PrepareShortSearchStatement(GridCommand command, ItemSearchModel searchModel)
{
var user = SecurityContextHolder.Get();
string whereStatement = " where 1=1 ";
//whereStatement += @" and exists (select 1 from UserPermissionView as p where p.UserId =" + user.Id + "and p.PermissionCategoryType in (" + (int)com.Sconit.CodeMaster.PermissionCategoryType.Supplier + "," + (int)com.Sconit.CodeMaster.PermissionCategoryType.Customer + "," + (int)com.Sconit.CodeMaster.PermissionCategoryType.Region + ") and (p.PermissionCode = f.PartyFrom or p.PermissionCode = f.PartyTo ))";
IList <object> param = new List <object>();
if (!string.IsNullOrWhiteSpace(searchModel.Flow))
{
whereStatement += @" and exists( select 1 from FlowDetail as f where f.Item=i.Code and f.Flow=? and exists
( select 1 from FlowMaster as fm where fm.Code=f.Flow and fm.Code=? and exists
(select 1 from UserPermissionView as p where p.UserId =" + user.Id +
" and (((fm.PartyFrom=p.PermissionCode or fm.PartyTo=p.PermissionCode ) and p.PermissionCategoryType in (3,4)) or (fm.PartyTo=p.PermissionCode and p.PermissionCategoryType=2 )))))";
param.Add(searchModel.Flow);
param.Add(searchModel.Flow);
}
else
{
whereStatement += @" and exists( select 1 from FlowDetail as f where f.Item=i.Code and exists
( select 1 from FlowMaster as fm where fm.Code=f.Flow and exists
(select 1 from UserPermissionView as p where p.UserId =" + user.Id +
" and (((fm.PartyFrom=p.PermissionCode or fm.PartyTo=p.PermissionCode ) and p.PermissionCategoryType in (3,4)) or (fm.PartyTo=p.PermissionCode and p.PermissionCategoryType=2 )))))";
}
HqlStatementHelper.AddLikeStatement("ReferenceCode", searchModel.ReferenceCode, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Code", searchModel.Code, "i", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsActive", true, "i", 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 _AjaxFlowDetailList(GridCommand command, FlowDetailSearchModel searchModel)
{
SearchStatementModel searchStatementModel = PrepareDetailFlowSearchStatement(command, searchModel);
GridModel <FlowDetail> List = GetAjaxPageData <FlowDetail>(searchStatementModel, command);
if (!string.IsNullOrEmpty(searchModel.Flow))
{
FlowMaster flowMaster = base.genericMgr.FindById <FlowMaster>(searchModel.Flow);
foreach (FlowDetail flowDetail in List.Data)
{
flowDetail.ManufactureParty = flowMaster.PartyFrom;
flowDetail.LotNo = LotNoHelper.GenerateLotNo();
}
foreach (FlowDetail flowDetail in List.Data)
{
Item item = base.genericMgr.FindById <Item>(flowDetail.Item);
flowDetail.ItemDescription = item.Description;
}
}
return(PartialView(List));
}
private SearchStatementModel PrepareDetailFlowSearchStatement(GridCommand command, FlowDetailSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "h", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "h", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectCountFlowStatement;
searchStatementModel.SelectStatement = selectFlowStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray <object>();
return(searchStatementModel);
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">SNRule Search Model</param>
/// <returns>return SNRule search model</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, SNRuleSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
HqlStatementHelper.AddEqStatement("Code", searchModel.Code, "s", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("SNRuleContent", searchModel.SNRuleContent, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("PostCode", searchModel.PostCode, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("TelPhone", searchModel.TelPhone, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("MobilePhone", searchModel.MobilePhone, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("Fax", searchModel.Fax, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("Email", searchModel.Email, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param);
//HqlStatementHelper.AddLikeStatement("ContactPersonName", searchModel.ContactPersonName, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param);
//HqlStatementHelper.AddEqStatement("Type", searchModel.Type, "u", ref whereStatement, param);
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "DocumentsTypeDescription")
{
command.SortDescriptors[0].Member = "Code";
}
}
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 _AjaxOrderDetailList(GridCommand command, OrderMasterSearchModel searchModel)
{
com.Sconit.Entity.ACC.User user = SecurityContextHolder.Get();
IList <OrderMaster> orderMasterList = null;
if (user.Code.Trim().ToLower() != "su")
{
orderMasterList = base.genericMgr.FindAll <OrderMaster>("from OrderMaster as o where o.OrderNo=? and exists (select 1 from UserPermissionView as up where up.UserId =" + user.Id + " and up.PermissionCategoryType = " + (int)com.Sconit.CodeMaster.PermissionCategoryType.Supplier + " and up.PermissionCode = o.PartyFrom)", searchModel.OrderNo);
if (orderMasterList.Count <= 0)
{
return(PartialView(new GridModel(new List <OrderDetail>())));
}
}
SearchStatementModel searchStatementModel = PrepareOrderDetailSearchStatement(command, searchModel);
GridModel <OrderDetail> List = GetAjaxPageData <OrderDetail>(searchStatementModel, command);
try
{
foreach (OrderDetail orderDetail in List.Data)
{
orderDetail.LotNo = LotNoHelper.GenerateLotNo();
}
OrderMaster order = base.genericMgr.FindById <OrderMaster>(searchModel.OrderNo);
foreach (OrderDetail orderDetail in List.Data)
{
orderDetail.ManufactureParty = order.PartyFrom;
orderDetail.HuQty = orderDetail.OrderedQty;
}
return(View(List));
}
catch (Exception)
{
return(PartialView(new GridModel(new List <IpLocationDetail>())));
}
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">Item Search Model</param>
/// <returns>return Search Statement</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, EntityPreferenceSearchModel searchModel)
{
string whereStatement = string.Empty;
IList <object> param = new List <object>();
if (command.SortDescriptors.Count > 0)
{
if (command.SortDescriptors[0].Member == "EntityPreferenceDesc")
{
command.SortDescriptors[0].Member = "Description";
}
}
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = entityPrefSelectCountStatement;
searchStatementModel.SelectStatement = entityPrefSelectStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray <object>();
return(searchStatementModel);
}
public ActionResult _AjaxList(GridCommand command, CodeMasterModel searchModel)
{
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
return(PartialView(GetAjaxPageData <com.Sconit.Entity.SYS.CodeMaster>(searchStatementModel, command)));
}
public ActionResult _AjaxShortList(GridCommand command, ItemSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareShortSearchStatement(command, searchModel);
return(PartialView(GetAjaxPageData <Item>(searchStatementModel, command)));
}
/// Det Search Statement
private SearchStatementModel PrepareDetSearchStatement(GridCommand command, CustReportSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param);
string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors);
if (string.IsNullOrWhiteSpace(sortingStatement))
{
sortingStatement = " order by i.Code ";
}
SearchStatementModel searchStatementModel = new SearchStatementModel();
searchStatementModel.SelectCountStatement = selectDetCountStatement;
searchStatementModel.SelectStatement = selectDetStatement;
searchStatementModel.WhereStatement = whereStatement;
searchStatementModel.SortingStatement = sortingStatement;
searchStatementModel.Parameters = param.ToArray<object>();
return searchStatementModel;
}
public ActionResult _AjaxBatchProcessList(GridCommand command, OrderMasterSearchModel searchModel)
{
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
return(PartialView(GetAjaxPageData <OrderMaster>(searchStatementModel, command)));
}
public ActionResult _AjaxList(GridCommand command, PartySearchModel searchModel)
{
SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel);
return(PartialView(GetAjaxPageData <Plant>(searchStatementModel, command)));
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">RoutingMaster Search Model</param>
/// <returns>Search Statement</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, SequenceGroupSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("ProductLine", searchModel.ProdLine, "s", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsActive", searchModel.IsActive, "s", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "s", 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 _AjaxList(GridCommand command, PermissionGroupSearchModel searchModel)
{
SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel);
return(PartialView(GetAjaxPageData <PermissionGroup>(searchStatementModel, command)));
}
/// <summary>
/// Search Statement
/// </summary>
/// <param name="command">Telerik GridCommand</param>
/// <param name="searchModel">RoutingMaster Search Model</param>
/// <returns>Search Statement</returns>
private SearchStatementModel PrepareSearchStatement(GridCommand command, ProductLineMapSearchModel searchModel)
{
string whereStatement = string.Empty;
IList<object> param = new List<object>();
HqlStatementHelper.AddEqStatement("Type", (int)com.Sconit.CodeMaster.ProductLineMapType.Van, "r", ref whereStatement, param);
HqlStatementHelper.AddLikeStatement("SAPProductLine", searchModel.SAPProductLine, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param);
HqlStatementHelper.AddEqStatement("IsActive", searchModel.SearchIsActive, "r", 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;
}
