private SearchStatementModel PrepareSearchStatement(GridCommand command, SMSRecSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Issue", searchModel.Issue, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("MsgID", searchModel.MsgID, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Content", searchModel.Content, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("SrcID", searchModel.SrcID, HqlStatementHelper.LikeMatchMode.Start, "sms", ref whereStatement, param); if (searchModel.DateFrom != null & searchModel.DateTo != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.DateFrom, searchModel.DateTo, "sms", ref whereStatement, param); } else if (searchModel.DateFrom != null & searchModel.DateTo == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.DateFrom, "sms", ref whereStatement, param); } else if (searchModel.DateFrom == null & searchModel.DateTo != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.DateTo, "sms", ref whereStatement, param); } HqlStatementHelper.AddEqStatement("EventHandler", SMSStatus.SMSEventHeadler_MESSAGERECEIVEDINTERFACE, "sms", 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, SearchModel searchModel) { string whereStatement = ""; IList<object> param = new List<object>(); HqlStatementHelper.AddEqStatement("OrderNo", searchModel.OrderNo, "t", ref whereStatement, param); HqlStatementHelper.AddEqStatement("ReceiptNo", searchModel.ReceiptNo, "t", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "t", ref whereStatement, param); if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "t", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "t", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "t", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by t.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; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, PickTaskSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddEqStatement("PickId", searchModel.PickId, "c", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = "select count(*) from PickResult c"; searchStatementModel.SelectStatement = "select c from PickResult as c"; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, GenVanProdOrderSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("ZLINE", searchModel.SearchZLINE, 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; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, OrderMasterSearchModel searchModel ) { string whereStatement = string.Empty; IList<object> param = new List<object>(); if (!string.IsNullOrWhiteSpace(searchModel.TraceCode)) { searchModel.TraceCode = searchModel.TraceCode.PadLeft(10, '0').Substring(2); } HqlStatementHelper.AddLikeStatement("VanCode", searchModel.TraceCode,HqlStatementHelper.LikeMatchMode.End, "p", ref whereStatement, param); HqlStatementHelper.AddEqStatement("OrderNo", searchModel.OrderNo, "p", ref whereStatement, param); HqlStatementHelper.AddEqStatement("ProdLine", searchModel.ProdLine, "p", 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, FlowSearchModel searchModel) { string whereStatement = " where f.Type=2 "; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Anywhere, "f", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Description", searchModel.Description, HqlStatementHelper.LikeMatchMode.Anywhere, "f", ref whereStatement, param); HqlStatementHelper.AddEqStatement("LocationTo", searchModel.LocationTo, "f", ref whereStatement, param); HqlStatementHelper.AddEqStatement("LocationFrom", searchModel.LocationFrom, "f", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "f", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "f", ref whereStatement, param); HqlStatementHelper.AddEqStatement("IsActive", searchModel.IsActive, "f", 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 PrepareDetailSearchStatement(GridCommand command, FlowDetailSearchModel searchModel, string flowCode) { string whereStatement = " where f.Flow='" + flowCode + "'"; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Item", searchModel.Item, HqlStatementHelper.LikeMatchMode.Start, "f", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "f", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by f.Sequence asc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountDetailStatement; searchStatementModel.SelectStatement = selectDetailStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareSearchShipAddressStatement(GridCommand command, PartyAddressSearchModel searchModel, string partyCode) { string whereStatement = " where pa.Party='" + partyCode + "' and pa.Type='0' "; IList<object> param = new List<object>(); //HqlStatementHelper.AddLikeStatement("Party", searchModel.Party, HqlStatementHelper.LikeMatchMode.Start, "pa", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Address.Code", searchModel.AddressCode, HqlStatementHelper.LikeMatchMode.Start, "pa", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Address.AddressContent", searchModel.AddressContent, HqlStatementHelper.LikeMatchMode.Start, "pa", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectShipAddressCountStatement; searchStatementModel.SelectStatement = selectShipAddressStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, UserSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("FirstName", searchModel.FirstName, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("LastName", searchModel.LastName, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Position", searchModel.Position, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Depart", searchModel.Depart, HqlStatementHelper.LikeMatchMode.Anywhere, "u", ref whereStatement, param); HqlStatementHelper.AddEqStatement("IsActive", searchModel.IsActive, "u", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Type", searchModel.Type, "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 _AjaxScheduleLineItem(GridCommand command) { com.Sconit.Entity.ACC.User user = SecurityContextHolder.Get(); string whereStatement = "where exists ("+ " select 1 from UserPermissionView as p where p.UserId =" + user.Id + " and p.PermissionCode=s.Supplier)"; IList<object> param = new List<object>(); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = "select count(*) from ScheduleLineItem as s "; searchStatementModel.SelectStatement = "select s from ScheduleLineItem as s"; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); GridModel<ScheduleLineItem> grid = GetAjaxPageData<ScheduleLineItem>(searchStatementModel, command); if (grid.Data != null && grid.Data.Count() > 0) { var items = grid.Data.Select(o => o.Item).ToArray(); IList<Item> itemList = new List<Item>(); string hql = string.Empty; IList<object> parm = new List<object>(); foreach (string itemCode in items.Distinct()) { if (hql == string.Empty) { hql = "from Item where Code in (?"; } else { hql += ", ?"; } parm.Add(itemCode); } itemList = this.genericMgr.FindAll<Item>(hql+")",parm.ToArray()); if (itemList != null && itemList.Count > 0) { foreach (ScheduleLineItem scheduleLineItem in grid.Data) { foreach (var item in itemList) { if (scheduleLineItem.Item==item.Code) { scheduleLineItem.Description = item.Description; scheduleLineItem.Uom = item.Uom; scheduleLineItem.ReferenceCode = item.ReferenceCode; scheduleLineItem.UnitCount = item.UnitCount; } } } } } return PartialView(grid); }
private SearchStatementModel PrepareSearchStatement(GridCommand command, BillMasterSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); SecurityHelper.AddBillPermissionStatement(ref whereStatement, "b", "Party", com.Sconit.CodeMaster.BillType.Distribution); HqlStatementHelper.AddLikeStatement("ExternalBillNo", searchModel.ExternalBillNo, HqlStatementHelper.LikeMatchMode.Start, "b", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("BillNo", searchModel.BillNo, HqlStatementHelper.LikeMatchMode.Start, "b", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Party", searchModel.Party, "b", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "b", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Type", (int)Sconit.CodeMaster.BillType.Distribution, "b", ref whereStatement, param); if (searchModel.StartTime != null & searchModel.EndTime != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "b", ref whereStatement, param); } else if (searchModel.StartTime != null & searchModel.EndTime == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "b", ref whereStatement, param); } else if (searchModel.StartTime == null & searchModel.EndTime != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "b", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by b.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; }
private SearchStatementModel PreparePickListSearchStatement(GridCommand command, OrderMasterSearchModel searchModel) { string whereStatement = string.Empty; if (searchModel.Type.HasValue && searchModel.Type > 0) { whereStatement = " where o.Type =" + searchModel.Type + " and o.IsShipScanHu = 1 and o.Status in (" + (int)com.Sconit.CodeMaster.OrderStatus.InProcess + "," + (int)com.Sconit.CodeMaster.OrderStatus.Submit + ")" + " and exists (select 1 from OrderDetail as d where d.PickedQty < d.OrderedQty and d.OrderNo = o.OrderNo) "; } else { 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.IsShipScanHu = 1 and o.Status in (" + (int)com.Sconit.CodeMaster.OrderStatus.InProcess + "," + (int)com.Sconit.CodeMaster.OrderStatus.Submit + ")" + " and exists (select 1 from OrderDetail as d where d.PickedQty < d.OrderedQty and d.OrderNo = o.OrderNo) "; } IList<object> param = new List<object>(); if (!string.IsNullOrEmpty(searchModel.OrderNo)) { HqlStatementHelper.AddLikeStatement("OrderNo", searchModel.OrderNo, HqlStatementHelper.LikeMatchMode.Start, "o", ref whereStatement, param); } if (!string.IsNullOrEmpty(searchModel.Flow)) { HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "o", ref whereStatement, param); } if (!string.IsNullOrEmpty(searchModel.PartyFrom)) { HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "o", ref whereStatement, param); } if (!string.IsNullOrEmpty(searchModel.PartyTo)) { HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "o", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by o.CreateDate desc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectOrderCountStatement; searchStatementModel.SelectStatement = selectOrderStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, LocationDetailPrefSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddEqStatement("Item", searchModel.ItemCode, "f", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Location", searchModel.LocationCode, "f", 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, PickListSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "pl", "OrderType", "pl", "PartyFrom", "pl", "PartyTo", com.Sconit.CodeMaster.OrderType.Distribution, false); // It should be logic "and" between checking pemission hql commands and other search condition(PickListNo,Status...etc) //whereStatement = whereStatement.Insert(6, " (") + ")"; HqlStatementHelper.AddLikeStatement("PickListNo", searchModel.PickListNo, HqlStatementHelper.LikeMatchMode.End, "pl", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.End, "pl", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "pl", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "pl", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "pl", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "pl", ref whereStatement, param); if (searchModel.StartTime != null & searchModel.EndTime != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "pl", ref whereStatement, param); } else if (searchModel.StartTime != null & searchModel.EndTime == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "pl", ref whereStatement, param); } else if (searchModel.StartTime == null & searchModel.EndTime != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "pl", ref whereStatement, param); } if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "OrderTypeDescription") { command.SortDescriptors[0].Member = "OrderType"; } else if (command.SortDescriptors[0].Member == "OrderStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by pl.CreateDate desc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = "select count(*) from PickListMaster as pl"; searchStatementModel.SelectStatement = "select pl from PickListMaster as pl"; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareShipSearchStatement(GridCommand command, PickListSearchModel searchModel) { string whereStatement = " where p.Status =" + (int)com.Sconit.CodeMaster.PickListStatus.InProcess; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("PickListNo", searchModel.PickListNo, HqlStatementHelper.LikeMatchMode.Start, "p", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "p", ref whereStatement, param); if (searchModel.StartTime != null & searchModel.EndTime != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "p", ref whereStatement, param); } else if (searchModel.StartTime != null & searchModel.EndTime == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "p", ref whereStatement, param); } else if (searchModel.StartTime == null & searchModel.EndTime != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "p", ref whereStatement, param); } if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "OrderTypeDescription") { command.SortDescriptors[0].Member = "OrderType"; } else if (command.SortDescriptors[0].Member == "OrderStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by p.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; }
/// <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, RoutingMasterSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Name", searchModel.Name, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "RoutingTimeUnitDescription") { command.SortDescriptors[0].Member = "TaktTimeUnit"; } } 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">RoutingDetail Search Model</param> /// <param name="routingMasterCode">routingMaster Code</param> /// <returns>Search Statement</returns> private SearchStatementModel RoutingDetailPrepareSearchStatement(GridCommand command, RoutingDetailSearchModel searchModel, string routingMasterCode) { string whereStatement = "where r.Routing = '" + routingMasterCode + "'"; IList<object> param = new List<object>(); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "TimeUnitDescription") { command.SortDescriptors[0].Member = "TimeUnit"; } } HqlStatementHelper.AddEqStatement("Operation", searchModel.Operation, "r", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = routingDetailSelectCountStatement; searchStatementModel.SelectStatement = routingDetailSelectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel ConcessionMasterPrepareSearchStatement(GridCommand command, ConcessionMasterSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("ConcessionNo", searchModel.ConcessionNo, HqlStatementHelper.LikeMatchMode.Start, "c", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "c", ref whereStatement, param); HqlStatementHelper.AddEqStatement("CreateUserName", searchModel.CreateUserName, "c", ref whereStatement, param); if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "c", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "c", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "c", ref whereStatement, param); } if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "ConcessionStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by c.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; }
private SearchStatementModel PrepareBindSearchStatement(GridCommand command, FlowBindModel searchModel, string id) { string whereStatement = " where mf.Code='" + id + "'"; IList<object> param = new List<object>(); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "BindedFlow.Code") { command.SortDescriptors[0].Member = "bf.Code"; } else if (command.SortDescriptors[0].Member == "BindedFlow.Description") { command.SortDescriptors[0].Member = "bf.Description"; } else if (command.SortDescriptors[0].Member == "BindTypeDescription") { command.SortDescriptors[0].Member = "f.BindType"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountBindStatement; searchStatementModel.SelectStatement = selectBindStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareOrderDetailSearchStatement(GridCommand command, OrderMasterSearchModel searchModel) { IList<object> param = new List<object>(); StringBuilder Sb = new StringBuilder(); string whereStatement = " where exists (select 1 from OrderMaster as o where o.OrderNo=d.OrderNo "; Sb.Append(whereStatement); if (searchModel.Flow != null) { Sb.Append(string.Format(" and o.Flow = '{0}'", searchModel.Flow)); } if (searchModel.OrderNo != null) { Sb.Append(string.Format(" and o.OrderNo like '%{0}'", searchModel.OrderNo)); } if (!string.IsNullOrEmpty(searchModel.PartyFrom)) { Sb.Append(string.Format(" and o.PartyFrom = '{0}'", searchModel.PartyFrom)); } if (!string.IsNullOrEmpty(searchModel.PartyTo)) { Sb.Append(string.Format(" and o.PartyTo = '{0}'", searchModel.PartyTo)); } if (searchModel.Type.HasValue && searchModel.Type > 0) { Sb.Append(string.Format(" and d.OrderType ='{0}' ", searchModel.Type)); } if (searchModel.DateFrom != null & searchModel.DateTo != null) { Sb.Append(string.Format(" and o.CreateDate between '{0}' and '{1}'", searchModel.DateFrom, searchModel.DateTo)); } else if (searchModel.DateFrom != null & searchModel.DateTo == null) { Sb.Append(string.Format(" and o.CreateDate >= '{0}'", searchModel.DateTo)); } else if (searchModel.DateFrom == null & searchModel.DateTo != null) { Sb.Append(string.Format(" and o.CreateDate <= '{0}'", searchModel.DateTo)); } //满足条件1.移库或销售类型订单;2.订单数-已发数-拣货数〉0;3.排序单和分装生产单不能创建拣货单 Sb.Append(" and o.Type in (2,3,7) and (OrderQty-ShipQty-PickQty)>0 "); Sb.Append("and o.Status in (" + (int)com.Sconit.CodeMaster.OrderStatus.Submit + "," + (int)com.Sconit.CodeMaster.OrderStatus.InProcess + "))"); whereStatement = Sb.ToString(); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "d", ref whereStatement, param); if (searchModel.LocationFrom != null && searchModel.LocationFromTo == null) { HqlStatementHelper.AddEqStatement("LocationFrom", searchModel.LocationFrom, "d", ref whereStatement, param); } else if (searchModel.LocationFrom != null && searchModel.LocationFromTo != null) { HqlStatementHelper.AddBetweenStatement("LocationFrom", searchModel.LocationFrom, searchModel.LocationFromTo, "d", ref whereStatement, param); } if (searchModel.LocationTo != null && searchModel.LocationToTo == null) { HqlStatementHelper.AddEqStatement("LocationTo", searchModel.LocationTo, "d", ref whereStatement, param); } else if (searchModel.LocationTo != null && searchModel.LocationToTo != null) { HqlStatementHelper.AddBetweenStatement("LocationTo", searchModel.LocationTo, searchModel.LocationToTo, "d", ref whereStatement, param); } if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "WindowTime") { command.SortDescriptors.Remove(command.SortDescriptors[0]); // command.SortDescriptors[0].Member = "Type"; } else if (command.SortDescriptors[0].Member == "CurrentPickListQty") { command.SortDescriptors.Remove(command.SortDescriptors[0]); } else if (command.SortDescriptors[0].Member == "CurrentPickQty") { command.SortDescriptors.Remove(command.SortDescriptors[0]); } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by d.CreateDate desc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = "select count(*) from OrderDetail as d"; searchStatementModel.SelectStatement = "select d from OrderDetail as d"; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareBindedSearchStatement(GridCommand command, FlowBindModel searchModel, string id) { string whereStatement = " where bf.Code='" + id + "'"; IList<object> param = new List<object>(); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountBindStatement; searchStatementModel.SelectStatement = selectBindStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private GridModel<PlanBill> GetPlanBillGridModel(GridCommand command, PlanBillSearchModel searchModel) { command.PageSize = int.MaxValue; command.Page = 1; string whereStatement = string.Empty; IList<object> param = new List<object>(); SecurityHelper.AddBillPermissionStatement(ref whereStatement, "b", "Party", com.Sconit.CodeMaster.BillType.Distribution); HqlStatementHelper.AddEqStatement("Party", searchModel.Party, "b", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "b", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Currency", searchModel.Currency, "b", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "b", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Type", com.Sconit.CodeMaster.BillType.Distribution, "b", ref whereStatement, param); if (searchModel.StartTime != null & searchModel.EndTime != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "b", ref whereStatement, param); } else if (searchModel.StartTime != null & searchModel.EndTime == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "b", ref whereStatement, param); } else if (searchModel.StartTime == null & searchModel.EndTime != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "b", ref whereStatement, param); } if (whereStatement == string.Empty) { whereStatement += " where b.PlanQty > b.ActingQty"; } else { whereStatement += " and b.PlanQty > b.ActingQty"; } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = "select count(*) from PlanBill as b"; searchStatementModel.SelectStatement = "from PlanBill as b"; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return GetAjaxPageData<PlanBill>(searchStatementModel, command); }
private SearchStatementModel PrepareSearchStatement(GridCommand command, string IpNo) { IList<object> param = new List<object>(); string whereStatement = string.Empty; HqlStatementHelper.AddLikeStatement("IpNo", IpNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by i.CreateDate desc"; } SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = "select count(*) from InspectResult as i"; searchStatementModel.SelectStatement = "select i from InspectResult as i"; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, ReceiptMasterSearchModel searchModel) { string whereStatement = " where r.OrderType =" + (int)com.Sconit.CodeMaster.OrderType.Production + "and exists(select 1 from ReceiptDetail as d where d.ReceiptNo=r.ReceiptNo"; if (!string.IsNullOrEmpty(searchModel.OrderNo)) { whereStatement += " and d.OrderNo='" + searchModel.OrderNo + "'"; } else if (!string.IsNullOrEmpty(searchModel.Item)) whereStatement += " and d.Item = '" + searchModel.Item + "'"; whereStatement += ")"; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("ReceiptNo", searchModel.ReceiptNo, HqlStatementHelper.LikeMatchMode.Anywhere, "r", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "r", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "r", ref whereStatement, param); // HqlStatementHelper.AddLikeStatement("OrderNo", searchModel.OrderNo, HqlStatementHelper.LikeMatchMode.Anywhere, "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 = "select count(*) from ReceiptMaster as r"; searchStatementModel.SelectStatement = "select r from ReceiptMaster as r"; 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">MultiSupplyGroup Search Model</param> /// <returns>return MultiSupplyGroup search model</returns> private SearchStatementModel PrepareSearchStatement(GridCommand command, MultiSupplyGroupSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("GroupNo", searchModel.GroupNo, HqlStatementHelper.LikeMatchMode.Start, "msg", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Supplier", searchModel.Supplier, "msg", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "msg", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("SubstituteGroup", searchModel.SubstituteGroup, HqlStatementHelper.LikeMatchMode.Start, "msg", ref whereStatement, param); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "DisplayGroupNo") { command.SortDescriptors[0].Member = "GroupNo"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectViewCountStatement; searchStatementModel.SelectStatement = selectViewStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
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; }
private SearchStatementModel PrepareActingBillToListSearchStatement(GridCommand command, ActingBillSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("ReceiptNo", searchModel.ReceiptNo, HqlStatementHelper.LikeMatchMode.Start, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Party", searchModel.Party, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Currency", searchModel.Currency, "a", ref whereStatement, param); HqlStatementHelper.AddEqStatement("IsProvisionalEstimate", false, "a", ref whereStatement, param); if (searchModel.StartTime != null & searchModel.EndTime != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartTime, searchModel.EndTime, "a", ref whereStatement, param); } else if (searchModel.StartTime != null & searchModel.EndTime == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartTime, "a", ref whereStatement, param); } else if (searchModel.StartTime == null & searchModel.EndTime != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndTime, "a", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountActingBillStatement; searchStatementModel.SelectStatement = selectActingBillStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, PartySearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("Plant", searchModel.Plant, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Name", searchModel.Name, HqlStatementHelper.LikeMatchMode.Start, "r", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Workshop", searchModel.Workshop, HqlStatementHelper.LikeMatchMode.Start, "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; }
private SearchStatementModel PrepareSearchStatement(GridCommand command, IssueAddressSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); if (!string.IsNullOrWhiteSpace(searchModel.ParentIssueAddressCode)) { HqlStatementHelper.AddEqStatement("Code", searchModel.ParentIssueAddressCode, "pia", ref whereStatement, param); } HqlStatementHelper.AddLikeStatement("Description", searchModel.Description, HqlStatementHelper.LikeMatchMode.Start, "ia", ref whereStatement, param); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "Code") { command.SortDescriptors[0].Member = "ia.Code"; } if (command.SortDescriptors[0].Member == "Description") { command.SortDescriptors[0].Member = "ia.Description"; } if (command.SortDescriptors[0].Member == "Sequence") { command.SortDescriptors[0].Member = "ia.Sequence"; } if (command.SortDescriptors[0].Member == "ParentIssueAddressCode") { command.SortDescriptors[0].Member = "pia.Code"; } if (command.SortDescriptors[0].Member == "ParentIssueAddressDescription") { command.SortDescriptors[0].Member = "pia.Description"; } } 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, KanbanScanSearchModel searchModel) { string whereStatement = string.Empty; IList<object> param = new List<object>(); //if (searchModel.IsTempKanbanCard.HasValue && searchModel.IsTempKanbanCard.Value) //{ // whereStatement += " where TempKanbanCard <> '' and TempKanbanCard is not null "; //} SecurityHelper.AddRegionPermissionStatement(ref whereStatement, "s", "Region"); HqlStatementHelper.AddEqStatement("CardNo", searchModel.CardNo, "s", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Item", searchModel.Item, "s", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Supplier", searchModel.Supplier, "s", ref whereStatement, param); HqlStatementHelper.AddEqStatement("LogisticCenterCode", searchModel.LcCode, "s", ref whereStatement, param); //HqlStatementHelper.AddEqStatement("TempKanbanCard", searchModel.TempKanbanCard, "s", ref whereStatement, param); //HqlStatementHelper.AddGeStatement("ScanTime", searchModel.StartDate, "s", ref whereStatement, param); ////改到当日的最后一秒 //HqlStatementHelper.AddLeStatement("ScanTime", searchModel.EndDate.Add(new TimeSpan(23, 59, 59)), "s", ref whereStatement, param); //if (searchModel.StartDate != null & searchModel.EndDate != null) //{ // HqlStatementHelper.AddBetweenStatement("ScanTime", searchModel.StartDate, searchModel.EndDate, "s", ref whereStatement, param); //} //else if (searchModel.StartDate != null) { HqlStatementHelper.AddGeStatement("ScanTime", searchModel.StartDate, "s", ref whereStatement, param); } if ( searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("ScanTime", searchModel.EndDate, "s", ref whereStatement, param); } if (searchModel.IsNotOrdered) { HqlStatementHelper.AddEqStatement("IsOrdered", false, "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; }