예제 #1
0
        public ActionResult GetCLCS_ReturnOrder(CLCS_ReturnOrderSearchModel model, int searchPage)
        {
            SearchDataWithPagedDatas <CLCS_ReturnOrderSearchModel, CLCS_ReturnOrderListModel> result = new SearchDataWithPagedDatas <CLCS_ReturnOrderSearchModel, CLCS_ReturnOrderListModel>();

            result.SearchModel = model;
            result.PagedDatas  = CLCS_ReturnOrderManageBLL.GetPagedCLCS_ReturnOrder(result.SearchModel, searchPage, this.PageSize, base.CurrentStrucID);
            return(PartialView("CLCS_ReturnOrderPagedGrid", result));
        }
예제 #2
0
        public static AsiatekPagedList <CLCS_ReturnOrderListModel> GetPagedCLCS_ReturnOrder(CLCS_ReturnOrderSearchModel model, int searchPage, int pageSize, int strucID)
        {
            List <SqlParameter> paras = new List <SqlParameter>()
            {
                new SqlParameter("@tableName", " [dbo].[CLCS_MileageManage] "),
                new SqlParameter("@pageSize", pageSize),
                new SqlParameter("@currentPage", searchPage),
                new SqlParameter("@orderBy", " CreateTime DESC "),
                new SqlParameter("@showColumns", @"[ID]
      ,[PlateNum]
      ,[StartTime]
      ,[EndTime]
      ,[ReturnMileage]
      ,[Remark]
      ,[CreateTime]
      ,[CreateUserID] "),
            };

            string conditionStr = "";

            #region 筛选条件
            if (!string.IsNullOrWhiteSpace(model.PlateNum))
            {
                conditionStr += " PlateNum LIKE '%" + model.PlateNum + "%'";
            }
            if (!string.IsNullOrWhiteSpace(conditionStr))
            {
                paras.Add(new SqlParameter("@conditionStr", conditionStr));
            }
            #endregion

            paras.Add(new SqlParameter()
            {
                ParameterName = "@totalItemCount",
                Direction     = ParameterDirection.Output,
                SqlDbType     = SqlDbType.Int
            });
            paras.Add(new SqlParameter()
            {
                ParameterName = "@newCurrentPage",
                Direction     = ParameterDirection.Output,
                SqlDbType     = SqlDbType.Int
            });
            var rs = MSSQLHelper.ExecuteDataTable(CommandType.StoredProcedure, "Proc_GetPagedDatas", paras.ToArray());
            List <CLCS_ReturnOrderListModel> list = ConvertToList <CLCS_ReturnOrderListModel> .Convert(rs);

            int totalItemCount = Convert.ToInt32(paras[paras.Count - 2].Value);
            int newCurrentPage = Convert.ToInt32(paras[paras.Count - 1].Value);
            return(list.ToPagedList(newCurrentPage, pageSize, totalItemCount));
        }