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