public ActionResult _AjaxList(GridCommand command, SearchModel searchModel) { SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); GridModel<PostDO> gridlist = GetAjaxPageData<PostDO>(searchStatementModel, command); return PartialView(gridlist); }
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; }
public ActionResult List(GridCommand command, SearchModel searchModel) { ViewBag.Status = searchModel.Status; SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return View(); }
public ActionResult _AjaxList(GridCommand command, SearchModel searchModel) { SearchStatementModel searchStatementModel = PrepareSearchStatement(command, searchModel); GridModel<CancelProdOpReport> gridlist = GetAjaxPageData<CancelProdOpReport>(searchStatementModel, command); return PartialView(gridlist); //return PartialView(GetAjaxPageData<ReceiptMaster>(searchStatementModel, command)); }
public ActionResult Index(SearchModel searchModel) { SqlParameter[] sqlParam = new SqlParameter[1]; string sql = @"select e.* from SI_EntityPreference e "; DataSet entity = genericMgr.GetDatasetBySql(sql, sqlParam); ViewModel model = new ViewModel(); model.Data = entity.Tables[0]; model.Columns = IListHelper.GetColumns(entity.Tables[0]); return View(model); }
public ActionResult Index(SearchModel searchModel) { TempData["SearchModel"] = searchModel; SqlParameter[] sqlParam = new SqlParameter[4]; string sql = @"select top " + MaxRowSize + @" e.* from SI_SAP_TransCallBack e where e.CreateDate > @p1 and e.CreateDate < @p2 "; string mType = string.Empty; if (!searchModel.Status.HasValue || searchModel.Status.Value == 2) { sql += " and e.MTYPE = @p0 "; sqlParam[0] = new SqlParameter("@p0", string.Empty); } else if (searchModel.Status.Value ==1) { sql += " and e.MTYPE = @p0 "; sqlParam[0] = new SqlParameter("@p0", "T"); } if (searchModel.StartDate.HasValue) { sqlParam[1] = new SqlParameter("@p1", searchModel.StartDate); } else { sqlParam[1] = new SqlParameter("@p1", DateTime.Now.AddDays(-1)); } if (searchModel.EndDate.HasValue) { sqlParam[2] = new SqlParameter("@p2", searchModel.EndDate); } else { sqlParam[2] = new SqlParameter("@p2", DateTime.Now); } if (searchModel.Id.HasValue) { sql += " and e.Id = @p3 "; sqlParam[3] = new SqlParameter("@p3", searchModel.Id); } sql += " order by e.Id desc "; DataSet entity = siMgr.GetDatasetBySql(sql, sqlParam); ViewModel model = new ViewModel(); model.Data = entity.Tables[0]; model.Columns = IListHelper.GetColumns(entity.Tables[0]); return View(model); }
public ActionResult Index(GridCommand command, SearchModel searchModel) { return View(); // TempData["SearchModel"] = searchModel; // //command.PageSize = 100; // int startSize = command.Page == 0 ? 0 : (command.Page - 1) * command.PageSize; // int endSize = command.Page == 0 ? command.PageSize : command.Page * command.PageSize; // SqlParameter[] sqlParam = new SqlParameter[5]; // //string sql = @"select top " + MaxRowSize + // // @" e.* from SAP_ProdOpReport e where e.Status = @p0 and e.CreateDate > @p1 and e.CreateDate < @p2 "; // string sql = @"select RowId=ROW_NUMBER()OVER(order by e.CreateDate asc),* from SAP_ProdOpReport as e where // e.Status = @p0 and e.CreateDate > @p1 and e.CreateDate < @p2 "; // sqlParam[0] = new SqlParameter("@p0", searchModel.Status.HasValue ? searchModel.Status.Value : 2); // if (searchModel.StartDate.HasValue) // { // sqlParam[1] = new SqlParameter("@p1", searchModel.StartDate); // } // else // { // sqlParam[1] = new SqlParameter("@p1", "1900-1-1"); // } // if (searchModel.EndDate.HasValue) // { // sqlParam[2] = new SqlParameter("@p2", searchModel.EndDate); // } // else // { // sqlParam[2] = new SqlParameter("@p2", DateTime.Now); // } // sqlParam[3] = new SqlParameter("@p3", startSize); // sqlParam[4] = new SqlParameter("@p4", endSize); // string execSql = " select t1.* from (" + sql + ") as t1 where RowId between @p3 and @p4"; // DataSet entity = genericMgr.GetDatasetBySql(execSql, sqlParam); // sqlParam[3].Value = 0; // sqlParam[4].Value = 999999999999999; // DataSet countEntity = genericMgr.GetDatasetBySql(" select isnull(count(*),0) as count from (" + sql + ") as t1 where RowId between @p3 and @p4", sqlParam); // ViewModel model = new ViewModel(); // model.Data = entity.Tables[0]; // model.Columns = IListHelper.GetColumns(entity.Tables[0]); // ViewBag.Total = int.Parse((countEntity.Tables[0].Rows[0].ItemArray[0]).ToString()); // return View(model); }
public ActionResult _AjaxList(GridCommand command, SearchModel searchModel) { #region string hql = @"select sp.* from SAP_ProdOpBackflush as sp with(nolock) inner join ORD_OrderMstr_4 as o with(nolock) on sp.OrderNo=o.OrderNo where o.ProdLineType not in (1 , 2 , 3 , 4 , 9) "; IList<object> paramArr = new List<object>(); if (!string.IsNullOrWhiteSpace(searchModel.OrderNo)) { hql += " and o.OrderNo = ? "; paramArr.Add(searchModel.OrderNo); } if (!string.IsNullOrWhiteSpace(searchModel.AUFNR)) { hql += " and sp.AUFNR = ? "; paramArr.Add(searchModel.AUFNR); } if (searchModel.Status != null) { hql += " and sp.Status = ? "; paramArr.Add(searchModel.Status); } if (searchModel.StartDate != null) { hql += " and sp.CreateDate >= ? "; paramArr.Add(searchModel.StartDate.Value); } if (searchModel.EndDate != null) { hql += " and sp.CreateDate <= ? "; paramArr.Add(searchModel.EndDate); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by CreateDate desc "; } #endregion IList<object> countList = this.genericMgr.FindAllWithNativeSql<object>("select count(*) from (" + hql + ") as tt3", paramArr.ToArray()); IList<ProdOpBackflush> searchResultList = this.genericMgr.FindEntityWithNativeSql<ProdOpBackflush>("select * from ( select RowId=ROW_NUMBER()OVER(" + sortingStatement + "),* from (" + hql + " ) as tt2 ) as tt3 where tt3.RowId between " + (command.Page - 1) * command.PageSize + " and " + command.Page * command.PageSize + "", paramArr.ToArray()); ViewBag.Total = Convert.ToInt32(countList[0]); GridModel<ProdOpBackflush> gridModel = new GridModel<ProdOpBackflush>(); gridModel.Total = Convert.ToInt32(countList[0]); gridModel.Data = searchResultList; return PartialView(gridModel); }
//[SconitAuthorize(Permissions = "Url_SI_SAP_Item_View")] public ActionResult Index(SearchModel searchModel) { TempData["SearchModel"] = searchModel; SqlParameter[] sqlParam = new SqlParameter[1]; string sql = @"select e.* from SAP_MapMoveTypeTCode e "; if (!string.IsNullOrWhiteSpace(searchModel.Code)) { sql += " where e.BWART = @p0 "; sqlParam[0] = new SqlParameter("@p0", searchModel.Code); } DataSet entity = genericMgr.GetDatasetBySql(sql, sqlParam); ViewModel model = new ViewModel(); model.Data = entity.Tables[0]; model.Columns = IListHelper.GetColumns(entity.Tables[0]); return View(model); }
//[SconitAuthorize(Permissions = "Url_SI_SAP_Supplier_View")] public ActionResult Index(SearchModel searchModel) { TempData["SearchModel"] = searchModel; SqlParameter[] sqlParam = new SqlParameter[4]; string sql = @"select top " + MaxRowSize + " e.* from SI_SAP_Supplier e where e.IOStatus = @p0 and e.InboundDate > @p1 and e.InboundDate < @p2 "; sqlParam[0] = new SqlParameter("@p0", searchModel.Status.HasValue ? searchModel.Status.Value : 2); if (searchModel.StartDate.HasValue) { sqlParam[1] = new SqlParameter("@p1", searchModel.StartDate); } else { sqlParam[1] = new SqlParameter("@p1", DateTime.Now.AddDays(-1)); } if (searchModel.EndDate.HasValue) { sqlParam[2] = new SqlParameter("@p2", searchModel.EndDate); } else { sqlParam[2] = new SqlParameter("@p2", DateTime.Now); } if (searchModel.Id.HasValue) { sql += " and e.Id = @p3 "; sqlParam[3] = new SqlParameter("@p3", searchModel.Id); } sql += " order by e.Id desc "; DataSet entity = siMgr.GetDatasetBySql(sql, sqlParam); ViewModel model = new ViewModel(); model.Data = entity.Tables[0]; model.Columns = IListHelper.GetColumns(entity.Tables[0]); return View(model); }
public ActionResult Index(SearchModel searchModel) { TempData["SearchModel"] = searchModel; SqlParameter[] sqlParam = new SqlParameter[4]; string sql = @"select top " + MaxRowSize + @" c.* from SAP_CancelProdOpReport c where c.Status = @p0 and c.CreateDate > @p1 and c.CreateDate < @p2 "; sqlParam[0] = new SqlParameter("@p0", searchModel.Status.HasValue ? searchModel.Status.Value : 2); if (searchModel.StartDate.HasValue) { sqlParam[1] = new SqlParameter("@p1", searchModel.StartDate); } else { sqlParam[1] = new SqlParameter("@p1", "1900-1-1"); } if (searchModel.EndDate.HasValue) { sqlParam[2] = new SqlParameter("@p2", searchModel.EndDate); } else { sqlParam[2] = new SqlParameter("@p2", DateTime.Now); } sql += " order by c.CreateDate desc "; DataSet entity = genericMgr.GetDatasetBySql(sql, sqlParam); ViewModel model = new ViewModel(); model.Data = entity.Tables[0]; model.Columns = IListHelper.GetColumns(entity.Tables[0]); return View(model); }
public ActionResult Index(GridCommand command, SearchModel searchModel) { return View(); }
//[SconitAuthorize(Permissions = "Url_SI_SAP_Supplier_View")] public ActionResult Index(SearchModel searchModel) { TempData["SearchModel"] = searchModel; return View(); }
public void ExportXLS(SearchModel searchModel) { string hql = @"select sp.* from SAP_ProdOpBackflush as sp with(nolock) inner join ORD_OrderMstr_4 as o with(nolock) on sp.OrderNo=o.OrderNo where o.ProdLineType not in (1 , 2 , 3 , 4 , 9) "; IList<object> paramArr = new List<object>(); if (!string.IsNullOrWhiteSpace(searchModel.OrderNo)) { hql += " and o.OrderNo = ? "; paramArr.Add(searchModel.OrderNo); } if (!string.IsNullOrWhiteSpace(searchModel.AUFNR)) { hql += " and sp.AUFNR = ? "; paramArr.Add(searchModel.AUFNR); } if (searchModel.Status!=null) { hql += " and sp.Status = ? "; paramArr.Add(searchModel.Status); } if (searchModel.StartDate!=null) { hql += " and sp.CreateDate >= ? "; paramArr.Add(searchModel.StartDate.Value); } if (searchModel.EndDate!=null ) { hql += " and sp.CreateDate <= ? "; paramArr.Add(searchModel.EndDate); } hql += " order by sp.CreateDate desc "; IList<ProdOpBackflush> exportList = this.genericMgr.FindEntityWithNativeSql<ProdOpBackflush>(hql, paramArr.ToArray()); ExportToXLS<ProdOpBackflush>("ExportProdOpBackflush", "xls", exportList); }
private string PrepareSearchStatement(GridCommand command, SearchModel searchModel) { string hql = @"select sp.* from SAP_ProdOpBackflush as sp with(nolock) inner join ORD_OrderMstr_4 as o with(nolock) on sp.OrderNo=o.OrderNo where o.ProdLineType not in (1 , 2 , 3 , 4 , 9) "; IList<object> paramArr = new List<object>(); if (!string.IsNullOrWhiteSpace(searchModel.OrderNo)) { hql += " and o.OrderNo = ? "; paramArr.Add(searchModel.OrderNo); } if (!string.IsNullOrWhiteSpace(searchModel.AUFNR)) { hql += " and sp.AUFNR = ? "; paramArr.Add(searchModel.AUFNR); } if (searchModel.Status != null) { hql += " and sp.Status = ? "; paramArr.Add(searchModel.Status); } if (searchModel.StartDate != null) { hql += " and sp.CreateDate >= ? "; paramArr.Add(searchModel.StartDate.Value); } if (searchModel.EndDate != null) { hql += " and sp.CreateDate <= ? "; paramArr.Add(searchModel.EndDate); } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); if (command.SortDescriptors.Count == 0) { sortingStatement = " order by sp.CreateDate desc "; } return hql; }