public ActionResult _AjaxList(GridCommand command, IpMasterSearchModel searchModel) { string whereStatement = "where i.OrderType in (" + (int)com.Sconit.CodeMaster.OrderType.Distribution + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")" + " and exists (select 1 from IpDetail as d where i.IpNo = d.IpNo and d.Type = " + (int)com.Sconit.CodeMaster.IpDetailType.Gap + ")"; SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageData<IpMaster>(searchStatementModel, command)); }
public ActionResult List(GridCommand command, IpMasterSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); if (searchCacheModel.isBack == true) { ViewBag.Page = searchCacheModel.Command.Page == 0 ? 1 : searchCacheModel.Command.Page; } ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult List(GridCommand command, IpMasterSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); if (this.CheckSearchModelIsNull(searchCacheModel.SearchObject)) { TempData["_AjaxMessage"] = ""; } else { SaveWarningMessage(Resources.ErrorMessage.Errors_NoConditions); } ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult _AjaxList(GridCommand command, IpMasterSearchModel searchModel) { this.GetCommand(ref command, searchModel); string whereStatement = string.Empty; if (searchModel.IpOrderType.HasValue && searchModel.IpOrderType.Value > 0) { whereStatement = "where i.OrderType =" + searchModel.IpOrderType + " and exists (select 1 from IpDetail as d where i.IpNo = d.IpNo and d.Type = " + searchModel.IpDetailType + ")"; } else { whereStatement = "where i.OrderType in (" + (int)com.Sconit.CodeMaster.OrderType.Distribution + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")" + " and exists (select 1 from IpDetail as d where i.IpNo = d.IpNo and d.Type = " + searchModel.IpDetailType + ")"; } SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageData<IpMaster>(searchStatementModel, command)); }
private ProcedureSearchStatementModel PrepareSearchDetailStatement(GridCommand command, IpMasterSearchModel searchModel, string whereStatement) { if (string.IsNullOrWhiteSpace(whereStatement)) { whereStatement = "and exists(select 1 from IpMaster as i where i.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and i.IpNo=d.IpNo)"; } else { // whereStatement += "and exists(select 1 from IpMaster as i where i.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and i.IpNo=d.IpNo and i.Status in(0,1))"; } if (!string.IsNullOrEmpty(searchModel.ExternalOrderNo)) { whereStatement += " and d.ExtNo='" + searchModel.ExternalOrderNo + "'"; } if (!string.IsNullOrEmpty(searchModel.ExternalSequence)) { whereStatement += " and d.ExtSeq='" + searchModel.ExternalSequence + "'"; } if (searchModel.IsShowGap) { whereStatement += " and d.RecQty <> d.Qty "; } List<ProcedureParameter> paraList = new List<ProcedureParameter>(); List<ProcedureParameter> pageParaList = new List<ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.IpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = (int)(int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine, Type = NHibernate.NHibernateUtil.String // + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Dock, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Item, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WMSNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ManufactureParty, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = true, Type = NHibernate.NHibernateUtil.Int64 }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "ExternalOrderNo") { command.SortDescriptors[0].Member = "ExtNo"; } else if (command.SortDescriptors[0].Member == "ExternalSequence") { command.SortDescriptors[0].Member = "ExtSeq"; } else if (command.SortDescriptors[0].Member == "LocationTo") { command.SortDescriptors[0].Member = "LocTo"; } else if (command.SortDescriptors[0].Member == "ItemDescription") { command.SortDescriptors[0].Member = "Item"; } else if (command.SortDescriptors[0].Member == "ReceivedQty") { command.SortDescriptors[0].Member = "RecQty"; } else if (command.SortDescriptors[0].Member == "UnitCountDescription") { command.SortDescriptors[0].Member = "UCDesc"; } else if (command.SortDescriptors[0].Member == "ContainerDescription") { command.SortDescriptors[0].Member = "ContainerDesc"; } else if (command.SortDescriptors[0].Member == "Sequence") { command.SortDescriptors[0].Member = "Seq"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_IpDetCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_IpDet"; return procedureSearchStatementModel; }
public void ExportMstr(IpMasterSearchModel searchModel) { int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage)); GridCommand command = new GridCommand(); command.Page = 1; command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value; if (!this.CheckSearchModelIsNull(searchModel)) { return; } string whereStatement = " and i.Type=" + (int)com.Sconit.CodeMaster.IpDetailType.Normal; ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareProcedureSearchStatement(command, searchModel, whereStatement); ExportToXLS<IpMaster>("DistributionIpMaster.xls", GetAjaxPageDataProcedure<IpMaster>(procedureSearchStatementModel, command).Data.ToList()); }
public ActionResult _ReceiveAjaxList(GridCommand command, IpMasterSearchModel searchModel) { string replaceFrom = "_ReceiveAjaxList"; string replaceTo = "ReceiveList"; this.GetCommand(ref command, searchModel, replaceFrom, replaceTo); string whereStatement = " and i.Status in (" + (int)com.Sconit.CodeMaster.IpStatus.Submit + "," + (int)com.Sconit.CodeMaster.IpStatus.InProcess + ")" + " and exists (select 1 from IpDetail as d where d.IsClose = 0 and d.Type = 0 and d.IpNo = i.IpNo) "; ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareReceiveProcedureSearchStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageDataProcedure<IpMaster>(procedureSearchStatementModel, command)); }
public ActionResult _AjaxIpDetLists(GridCommand command, IpMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return PartialView(new GridModel(new List<IpDetail>())); } string whereStatement = " and exists (select 1 from IpMaster as i where i.Type = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and i.IpNo=d.IpNo) "; ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageDataProcedure<IpDetail>(procedureSearchStatementModel, command)); }
private SearchStatementModel PrepareSearchStatement(GridCommand command, IpMasterSearchModel searchModel, string whereStatement) { IList<object> param = new List<object>(); //SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "i", "PartyFrom", com.Sconit.CodeMaster.OrderType.Distribution, false); //SecurityHelper.AddPartyToPermissionStatement(ref whereStatement, "i", "PartyTo", com.Sconit.CodeMaster.OrderType.Distribution); SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "i", "OrderType", "i", "PartyFrom", "i", "PartyTo", com.Sconit.CodeMaster.OrderType.Distribution, false); HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "i", ref whereStatement, param); if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "i", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "i", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "i", ref whereStatement, param); } if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "IpMasterStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } 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 _AjaxIpDetList(GridCommand command, IpMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return PartialView(new GridModel(new List<IpDetail>())); } string whereStatement = " and exists (select 1 from IpMaster as i where i.Type = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and i.IpNo=d.IpNo) "; if (!string.IsNullOrEmpty(searchModel.ExternalOrderNo)) { whereStatement += " and d.ExtNo='" + searchModel.ExternalOrderNo + "'"; } if (!string.IsNullOrEmpty(searchModel.ExternalSequence)) { whereStatement += " and d.ExtSeq='" + searchModel.ExternalSequence + "'"; } if (searchModel.IsShowGap) { whereStatement += " and d.RecQty <> d.Qty "; } //ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, whereStatement); //return PartialView(GetAjaxPageDataProcedure<IpDetail>(procedureSearchStatementModel, command)); IList<IpDetail> ipDetList = new List<IpDetail>(); ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, whereStatement); procedureSearchStatementModel.SelectProcedure = "USP_Search_PrintIpDet"; GridModel<object[]> gridModel = GetAjaxPageDataProcedure<object[]>(procedureSearchStatementModel, command); if (gridModel.Data != null && gridModel.Data.Count() > 0) { #region ipDetList = (from tak in gridModel.Data select new IpDetail { Id = (int)tak[0], IpNo = (string)tak[1], OrderNo = (string)tak[2], ExternalOrderNo = (string)tak[3], ExternalSequence = (string)tak[4], Item = (string)tak[5], ReferenceItemCode = (string)tak[6], ItemDescription = (string)tak[7], Uom = (string)tak[8], UnitCount = (decimal)tak[9], Qty = (decimal)tak[10], ReceivedQty = (decimal)tak[11], LocationFrom = (string)tak[12], LocationTo = (string)tak[13], Flow = (string)tak[14], IsClose = (bool)tak[15], IsInspect = (bool)tak[16], MastPartyFrom = (string)tak[17], MastPartyTo = (string)tak[18], MastType = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OrderType, int.Parse((tak[19]).ToString())), MastStatus = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.IpStatus, int.Parse((tak[20]).ToString())), MastCreateDate = (DateTime)tak[21], SAPLocation = (string)tak[22], }).ToList(); #endregion } procedureSearchStatementModel.PageParameters[2].Parameter = gridModel.Total; TempData["IpDetailPrintSearchModel"] = procedureSearchStatementModel; GridModel<IpDetail> gridModelOrderDet = new GridModel<IpDetail>(); gridModelOrderDet.Total = gridModel.Total; gridModelOrderDet.Data = ipDetList; return PartialView(gridModelOrderDet); }
public void ExportMstr(IpMasterSearchModel searchModel) { int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage)); GridCommand command = new GridCommand(); command.Page = 1; command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value; string whereStatement = string.Empty; if (searchModel.IpOrderType.HasValue && searchModel.IpOrderType.Value > 0) { whereStatement = "where i.OrderType =" + searchModel.IpOrderType + " and exists (select 1 from IpDetail as d where i.IpNo = d.IpNo and d.Type = " + searchModel.IpDetailType + ")"; } else { whereStatement = "where i.OrderType in (" + (int)com.Sconit.CodeMaster.OrderType.Distribution + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")" + " and exists (select 1 from IpDetail as d where i.IpNo = d.IpNo and d.Type = " + searchModel.IpDetailType + ")"; } SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel, whereStatement); ExportToXLS<IpMaster>("DistributionIpGapMaster.xls", GetAjaxPageData<IpMaster>(searchStatementModel, command).Data.ToList()); }
public ActionResult _AdjustAjaxList(GridCommand command, IpMasterSearchModel searchModel) { string replaceFrom = "_AdjustAjaxList"; string replaceTo = "AdjustList"; this.GetCommand(ref command, searchModel, replaceFrom, replaceTo); string whereStatement = string.Empty; if (searchModel.IpOrderType.HasValue && searchModel.IpOrderType.Value > 0) { whereStatement = "where i.OrderType =" + searchModel.IpOrderType + " and i.Status in (" + (int)com.Sconit.CodeMaster.IpStatus.Submit + "," + (int)com.Sconit.CodeMaster.IpStatus.InProcess + ")" + " and exists (select 1 from IpDetail as d where d.IsClose = 0 and d.IpNo = i.IpNo and d.Type = " + searchModel.IpDetailType + ") "; } else { whereStatement = "where i.OrderType in (" + (int)com.Sconit.CodeMaster.OrderType.Distribution + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")" + " and i.Status in (" + (int)com.Sconit.CodeMaster.IpStatus.Submit + "," + (int)com.Sconit.CodeMaster.IpStatus.InProcess + ")" + " and exists (select 1 from IpDetail as d where d.IsClose = 0 and d.IpNo = i.IpNo and d.Type = " + searchModel.IpDetailType + ") "; } SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageData<IpMaster>(searchStatementModel, command)); }
public ActionResult _AjaxList(GridCommand command, IpMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return PartialView(new GridModel(new List<IpMaster>())); } //string whereStatement = "where i.OrderType in (" // + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine + "," // + (int)com.Sconit.CodeMaster.OrderType.SubContract + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")"; string whereStatement = string.Empty; if (!string.IsNullOrWhiteSpace(searchModel.Item) && !string.IsNullOrWhiteSpace(searchModel.OrderNo)) { whereStatement = " and exists(select 1 from IpDetail as d where d.IpNo = i.IpNo and d.Item = '" + searchModel.Item + "' and d.OrderNo='"+searchModel.OrderNo+"')"; } else if (!string.IsNullOrWhiteSpace(searchModel.Item) && string.IsNullOrWhiteSpace(searchModel.OrderNo)) { whereStatement += " and exists(select 1 from IpDetail as d where d.IpNo = i.IpNo and d.Item = '" + searchModel.Item + "')"; } else if (string.IsNullOrWhiteSpace(searchModel.Item) && !string.IsNullOrWhiteSpace(searchModel.OrderNo)) { whereStatement = " and exists(select 1 from IpDetail as d where d.IpNo = i.IpNo and d.OrderNo='" + searchModel.OrderNo + "')"; } ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareProcedureSearchStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageDataProcedure<IpMaster>(procedureSearchStatementModel, command)); }
public ActionResult _AjaxIpDetList(GridCommand command, IpMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return PartialView(new GridModel(new List<IpDetail>())); } #region //ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, string.Empty); //GridModel<IpDetail> gridList = GetAjaxPageDataProcedure<IpDetail>(procedureSearchStatementModel, command); //int i = 0; //foreach (IpDetail ipDetail in gridList.Data) //{ // if (i > command.PageSize) // { // break; // } // ipDetail.SAPLocationTo = base.genericMgr.FindById<Location>(ipDetail.LocationTo).SAPLocation; //} //gridList.Data = gridList.Data.Where(o => o.Type == com.Sconit.CodeMaster.IpDetailType.Normal); //return PartialView(gridList); #endregion IList<IpDetail> ipDetList = new List<IpDetail>(); ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, string.Empty); procedureSearchStatementModel.SelectProcedure = "USP_Search_PrintIpDet"; GridModel<object[]> gridModel = GetAjaxPageDataProcedure<object[]>(procedureSearchStatementModel, command); if (gridModel.Data != null && gridModel.Data.Count() > 0) { #region ipDetList = (from tak in gridModel.Data select new IpDetail { Id = (int)tak[0], IpNo = (string)tak[1], OrderNo = (string)tak[2], ExternalOrderNo = (string)tak[3], ExternalSequence = (string)tak[4], Item = (string)tak[5], ReferenceItemCode = (string)tak[6], ItemDescription = (string)tak[7], Uom = (string)tak[8], UnitCount = (decimal)tak[9], Qty = (decimal)tak[10], ReceivedQty = (decimal)tak[11], LocationFrom = (string)tak[12], LocationTo = (string)tak[13], Flow = (string)tak[14], IsClose = (bool)tak[15], IsInspect = (bool)tak[16], MastPartyFrom = (string)tak[17], MastPartyTo = (string)tak[18], MastType = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.OrderType, int.Parse((tak[19]).ToString())), MastStatus = systemMgr.GetCodeDetailDescription(Sconit.CodeMaster.CodeMaster.IpStatus, int.Parse((tak[20]).ToString())), MastCreateDate = (DateTime)tak[21], SAPLocation = (string)tak[22], IsIncludeTax = (bool)tak[23], }).ToList(); #endregion } procedureSearchStatementModel.PageParameters[2].Parameter = gridModel.Total; TempData["IpDetailPrintSearchModel"] = procedureSearchStatementModel; GridModel<IpDetail> gridModelOrderDet = new GridModel<IpDetail>(); gridModelOrderDet.Total = gridModel.Total; gridModelOrderDet.Data = ipDetList; return PartialView(gridModelOrderDet); }
private ProcedureSearchStatementModel PrepareProcedureSearchStatement(GridCommand command, IpMasterSearchModel searchModel, string whereStatement) { List<ProcedureParameter> paraList = new List<ProcedureParameter>(); List<ProcedureParameter> pageParaList = new List<ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.IpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Dock, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Item, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WMSNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ManufactureParty, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = false, Type = NHibernate.NHibernateUtil.Boolean }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "IpMasterStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_IpMstrCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_IpMstr"; return procedureSearchStatementModel; }
public ActionResult _AjaxList(GridCommand command, IpMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return PartialView(new GridModel(new List<IpMaster>())); } string whereStatement = string.Empty; if (searchModel.Item != null && searchModel.Item != string.Empty) whereStatement += " and exists(select 1 from IpDetail as d where d.IpNo = i.IpNo and d.Item = '" + searchModel.Item + "')"; ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareProcedureSearchStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageDataProcedure<IpMaster>(procedureSearchStatementModel, command)); }
public ActionResult DetailList(GridCommand command, IpMasterSearchModel searchModel) { TempData["IpMasterSearchModel"] = searchModel; if (this.CheckSearchModelIsNull(searchModel)) { ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); } else { SaveWarningMessage(Resources.ErrorMessage.Errors_NoConditions); return View(new List<IpDetail>()); } }
public ActionResult CancelList(GridCommand command, IpMasterSearchModel searchModel) { SearchCacheModel searchCacheModel = ProcessSearchModel(command, searchModel); SearchStatementModel searchStatementModel = this.PrepareCancelSearchStatement(command, (IpMasterSearchModel)searchCacheModel.SearchObject); return View(GetPageData<IpMaster>(searchStatementModel, command)); }
private ProcedureSearchStatementModel PrepareSearchDetailStatement(GridCommand command, IpMasterSearchModel searchModel, string whereStatement) { List<ProcedureParameter> paraList = new List<ProcedureParameter>(); List<ProcedureParameter> pageParaList = new List<ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.IpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = +(int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine, //"," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract + "," + (int)com.Sconit.CodeMaster.OrderType.Distribution+ "," + (int)com.Sconit.CodeMaster.OrderType.Production //(int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Dock, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Item, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.WMSNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ManufactureParty, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = false, Type = NHibernate.NHibernateUtil.Int64 }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "ExternalOrderNo") { command.SortDescriptors[0].Member = "ExtNo"; } else if (command.SortDescriptors[0].Member == "ExternalSequence") { command.SortDescriptors[0].Member = "ExtSeq"; } else if (command.SortDescriptors[0].Member == "LocationTo") { command.SortDescriptors[0].Member = "LocTo"; } else if (command.SortDescriptors[0].Member == "ItemDescription") { command.SortDescriptors[0].Member = "Item"; } else if (command.SortDescriptors[0].Member == "ReceivedQty") { command.SortDescriptors[0].Member = "RecQty"; } else if (command.SortDescriptors[0].Member == "UnitCountDescription") { command.SortDescriptors[0].Member = "UCDesc"; } else if (command.SortDescriptors[0].Member == "ContainerDescription") { command.SortDescriptors[0].Member = "ContainerDesc"; } else if (command.SortDescriptors[0].Member == "Sequence") { command.SortDescriptors[0].Member = "Seq"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_IpDetCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_IpDet"; return procedureSearchStatementModel; }
public ActionResult _AjaxIpDetList(GridCommand command, IpMasterSearchModel searchModel) { if (!this.CheckSearchModelIsNull(searchModel)) { return PartialView(new GridModel(new List<IpDetail>())); } ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, string.Empty); return PartialView(GetAjaxPageDataProcedure<IpDetail>(procedureSearchStatementModel, command)); }
public ActionResult List(GridCommand command, IpMasterSearchModel searchModel) { this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult _CancelAjaxList(GridCommand command, IpMasterSearchModel searchModel) { SearchStatementModel searchStatementModel = this.PrepareCancelSearchStatement(command, searchModel); return PartialView(GetAjaxPageData<IpMaster>(searchStatementModel, command)); }
public ActionResult _AjaxList(GridCommand command, IpMasterSearchModel searchModel) { this.GetCommand(ref command, searchModel); if (!this.CheckSearchModelIsNull(searchModel)) { return PartialView(new GridModel(new List<IpMaster>())); } //string whereStatement = " where i.Type=0"; //SearchStatementModel searchStatementModel = this.PrepareSearchStatement(command, searchModel, whereStatement); //return PartialView(GetAjaxPageData<IpMaster>(searchStatementModel, command)); string whereStatement = " and i.Type=" + (int)com.Sconit.CodeMaster.IpDetailType.Normal; ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareProcedureSearchStatement(command, searchModel, whereStatement); return PartialView(GetAjaxPageDataProcedure<IpMaster>(procedureSearchStatementModel, command)); }
private ProcedureSearchStatementModel PrepareSearchDetailStatement(GridCommand command, IpMasterSearchModel searchModel, string whereStatement) { whereStatement = "and exists(select 1 from IpMaster as i where i.OrderSubType = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and i.IpNo=d.IpNo)"; List<ProcedureParameter> paraList = new List<ProcedureParameter>(); List<ProcedureParameter> pageParaList = new List<ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.IpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = (int)(int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderSubType, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Dock, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Item, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ExternalIpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ManufactureParty, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = true, Type = NHibernate.NHibernateUtil.Int64 }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.CreateUserName, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "OrderTypeDescription") { command.SortDescriptors[0].Member = "Type"; } else if (command.SortDescriptors[0].Member == "OrderStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_IpDetCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_IpDet"; return procedureSearchStatementModel; }
public void Export(IpMasterSearchModel searchModel) { int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage)); GridCommand command = new GridCommand(); command.Page = 1; command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value; string whereStatement = " and exists (select 1 from IpMaster as i where i.Type = " + (int)com.Sconit.CodeMaster.OrderSubType.Normal + " and i.IpNo=d.IpNo) "; ProcedureSearchStatementModel procedureSearchStatementModel = PrepareSearchDetailStatement(command, searchModel, whereStatement); var list = GetAjaxPageDataProcedure<IpDetail>(procedureSearchStatementModel, command); ExportToXLS<IpDetail>("DistributionIpDetail.xls", list.Data.ToList()); }
private SearchStatementModel PrepareCancelSearchStatement(GridCommand command, IpMasterSearchModel searchModel) { string whereStatement = "where i.OrderType in (" + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer + ")" + " and i.Status = " + (int)com.Sconit.CodeMaster.IpStatus.Submit; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("OrderType", searchModel.IpOrderType, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "i", ref whereStatement, param); SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "i", "OrderType", "i", "PartyFrom", "i", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true); if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "i", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "i", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "i", ref whereStatement, param); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountStatement; searchStatementModel.SelectStatement = selectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray<object>(); return searchStatementModel; }
private ProcedureSearchStatementModel PrepareSearchDetailStatement(GridCommand command, IpMasterSearchModel searchModel, string whereStatement) { List<ProcedureParameter> paraList = new List<ProcedureParameter>(); List<ProcedureParameter> pageParaList = new List<ProcedureParameter>(); paraList.Add(new ProcedureParameter { Parameter = searchModel.IpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Status, Type = NHibernate.NHibernateUtil.Int16 }); if (searchModel.IpOrderType.HasValue) { paraList.Add(new ProcedureParameter { Parameter = searchModel.IpOrderType, Type = NHibernate.NHibernateUtil.String }); } else { paraList.Add(new ProcedureParameter { Parameter = (int)com.Sconit.CodeMaster.OrderType.Distribution + "," + (int)com.Sconit.CodeMaster.OrderType.Transfer + "," + (int)com.Sconit.CodeMaster.OrderType.SubContractTransfer, Type = NHibernate.NHibernateUtil.String }); } paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderSubType, Type = NHibernate.NHibernateUtil.Int16 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyFrom, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.PartyTo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.StartDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.EndDate, Type = NHibernate.NHibernateUtil.DateTime }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Dock, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Item, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.OrderNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ExternalIpNo, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.ManufactureParty, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = searchModel.Flow, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = false, Type = NHibernate.NHibernateUtil.Int64 }); paraList.Add(new ProcedureParameter { Parameter = CurrentUser.Id, Type = NHibernate.NHibernateUtil.Int32 }); paraList.Add(new ProcedureParameter { Parameter = searchModel.CreateUserName, Type = NHibernate.NHibernateUtil.String }); paraList.Add(new ProcedureParameter { Parameter = whereStatement, Type = NHibernate.NHibernateUtil.String }); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "OrderTypeDescription") { command.SortDescriptors[0].Member = "Type"; } else if (command.SortDescriptors[0].Member == "OrderStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? command.SortDescriptors[0].Member : null, Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.SortDescriptors.Count > 0 ? (command.SortDescriptors[0].SortDirection == ListSortDirection.Descending ? "desc" : "asc") : "asc", Type = NHibernate.NHibernateUtil.String }); pageParaList.Add(new ProcedureParameter { Parameter = command.PageSize, Type = NHibernate.NHibernateUtil.Int32 }); pageParaList.Add(new ProcedureParameter { Parameter = command.Page, Type = NHibernate.NHibernateUtil.Int32 }); var procedureSearchStatementModel = new ProcedureSearchStatementModel(); procedureSearchStatementModel.Parameters = paraList; procedureSearchStatementModel.PageParameters = pageParaList; procedureSearchStatementModel.CountProcedure = "USP_Search_IpDetCount"; procedureSearchStatementModel.SelectProcedure = "USP_Search_IpDet"; return procedureSearchStatementModel; }
public void ExportMstr(IpMasterSearchModel searchModel) { int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage)); GridCommand command = new GridCommand(); command.Page = 1; command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value; if (!this.CheckSearchModelIsNull(searchModel)) { return; } ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareProcedureSearchStatement(command, searchModel, string.Empty); ExportToXLS<IpMaster>("SupplierIpMaster.xls", GetAjaxPageDataProcedure<IpMaster>(procedureSearchStatementModel, command).Data.ToList()); }
public void ExportMstrRec(IpMasterSearchModel searchModel) { int value = Convert.ToInt32(base.systemMgr.GetEntityPreferenceValue(EntityPreference.CodeEnum.MaxRowSizeOnPage)); GridCommand command = new GridCommand(); command.Page = 1; command.PageSize = !this.CheckSearchModelIsNull(searchModel) ? 0 : value; string replaceFrom = "_ReceiveAjaxList"; string replaceTo = "ReceiveList"; this.GetCommand(ref command, searchModel, replaceFrom, replaceTo); string whereStatement = " and i.Status in (" + (int)com.Sconit.CodeMaster.IpStatus.Submit + "," + (int)com.Sconit.CodeMaster.IpStatus.InProcess + ")" + " and exists (select 1 from IpDetail as d where d.IsClose = 0 and d.Type = 0 and d.IpNo = i.IpNo) "; ProcedureSearchStatementModel procedureSearchStatementModel = this.PrepareReceiveProcedureSearchStatement(command, searchModel, whereStatement); ExportToXLS<IpMaster>("DistributionIpGapMaster.xls", GetAjaxPageDataProcedure<IpMaster>(procedureSearchStatementModel, command).Data.ToList()); }
private SearchStatementModel PrepareSearchStatement(GridCommand command, IpMasterSearchModel searchModel) { string whereStatement = " where i.OrderType in (" + (int)com.Sconit.CodeMaster.OrderType.Procurement + "," + (int)com.Sconit.CodeMaster.OrderType.CustomerGoods + "," + (int)com.Sconit.CodeMaster.OrderType.SubContract + "," + (int)com.Sconit.CodeMaster.OrderType.ScheduleLine + ")"; IList<object> param = new List<object>(); HqlStatementHelper.AddLikeStatement("WMSNo", searchModel.WMSNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("Dock", searchModel.Dock, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("IpNo", searchModel.IpNo, HqlStatementHelper.LikeMatchMode.Start, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Status", searchModel.Status, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyFrom", searchModel.PartyFrom, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("PartyTo", searchModel.PartyTo, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("OrderType", searchModel.IpOrderType, "i", ref whereStatement, param); HqlStatementHelper.AddEqStatement("Flow", searchModel.Flow, "i", ref whereStatement, param); SecurityHelper.AddPartyFromPermissionStatement(ref whereStatement, "i", "PartyFrom", com.Sconit.CodeMaster.OrderType.Procurement, true); SecurityHelper.AddPartyFromAndPartyToPermissionStatement(ref whereStatement, "i", "OrderType", "i", "PartyFrom", "i", "PartyTo", com.Sconit.CodeMaster.OrderType.Procurement, true); if (searchModel.StartDate != null & searchModel.EndDate != null) { HqlStatementHelper.AddBetweenStatement("CreateDate", searchModel.StartDate, searchModel.EndDate, "i", ref whereStatement, param); } else if (searchModel.StartDate != null & searchModel.EndDate == null) { HqlStatementHelper.AddGeStatement("CreateDate", searchModel.StartDate, "i", ref whereStatement, param); } else if (searchModel.StartDate == null & searchModel.EndDate != null) { HqlStatementHelper.AddLeStatement("CreateDate", searchModel.EndDate, "i", ref whereStatement, param); } if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "IpMasterStatusDescription") { command.SortDescriptors[0].Member = "Status"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by i.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; }