public ActionResult GetVehicleMaintenanceSchedule(MSBindVehicleSearchModel model, int searchPage)
{
SearchDataWithPagedDatas <MSBindVehicleSearchModel, MSBindVehicleListModel> result = new SearchDataWithPagedDatas <MSBindVehicleSearchModel, MSBindVehicleListModel>();
result.SearchModel = model;
ViewData["ScheduleID"] = model.id;
result.PagedDatas = MaintenanceScheduleBLL.GetPagedCustomerVehicle(model.id, result.SearchModel, searchPage, this.PageSize, base.CurrentStrucID);
return(PartialView("_BindVehiclePagedGrid", result));
}
/// <summary>
/// 获取用户分配的车辆信息 获取其自己和自己子单位的所有车辆
/// </summary>
public static AsiatekPagedList <MSBindVehicleListModel> GetPagedCustomerVehicle(int id, MSBindVehicleSearchModel model, int searchPage, int pageSize, int strucID)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@tableName", "dbo.Vehicles ve "),
new SqlParameter("@joinStr", @"INNER JOIN dbo.Structures st ON ve.StrucID = st.ID
INNER JOIN Func_GetAllTheSubsetOfVehiclesByStrucID(" + strucID + ") AS vt ON ve.ID=vt.VID "),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@currentPage", searchPage),
new SqlParameter("@orderBy", "ve.ID DESC"),
new SqlParameter("@showColumns", @"ve.ID AS VehicleID,ve.PlateNum,ve.VIN,ve.VehicleName,ve.StrucID,st.StrucName "),
};
StringBuilder sbWhere = new StringBuilder("ve.Status<>9 AND st.Status<>9 AND ve.ID NOT IN (SELECT VehicleID FROM dbo.VehicleMaintenance WHERE ScheduleID=" + id + ")");
if (!string.IsNullOrWhiteSpace(model.VehicleName))
{
sbWhere.Append(" AND ve.VehicleName LIKE '%" + model.VehicleName + "%'");
}
if (!string.IsNullOrEmpty(sbWhere.ToString()))
{
paras.Add(new SqlParameter("@conditionStr", sbWhere.ToString()));
}
paras.Add(new SqlParameter()
{
ParameterName = "@totalItemCount",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
paras.Add(new SqlParameter()
{
ParameterName = "@newCurrentPage",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
List <MSBindVehicleListModel> list = ConvertToList <MSBindVehicleListModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.StoredProcedure, "Proc_GetPagedDatas", paras.ToArray()));
int totalItemCount = Convert.ToInt32(paras[paras.Count - 2].Value);
int newCurrentPage = Convert.ToInt32(paras[paras.Count - 1].Value);
return(list.ToPagedList(newCurrentPage, pageSize, totalItemCount));
}
