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;
}