public ActionResult VehicleLicenseListProvide(VehicleLicenseDTO vehicleLicenseDTO) { if (!base.HasPermission("VehicleLicense", PermissionOperate.manager)) { return(null); } int isAll = 1; if (!base.HasPermission("VehicleLicenseAll", PermissionOperate.manager)) { vehicleLicenseDTO.MpUserId = base.LoginAdmin.MpUserId; isAll = 0; } OceanDynamicList <object> list = _vehicleLicenseService.GetPageDynamicList(PageIndex, PageSize, vehicleLicenseDTO, isAll); if (list != null) { return(Content(list.ToJson(), "text/javascript")); } else { return(Content("{\"rows\":[],\"total\":0}", "text/javascript")); } }
public ActionResult VehicleLicenseListProvide(VehicleLicenseDTO vehicleLicenseDTO) { MpUserID = new Guid("E8325C13-9C76-4B70-911E-57395A2F4D69"); MpUser mpUser = _mpUserService.GetById(MpUserID); if (mpUser == null || mpUser.IsAuth != 1) { return(Json(new { message = "您没有权限,请先申请成为业务员!" })); } vehicleLicenseDTO.MpUserId = MpUserID; //IList<VehicleLicense> vehicleList = _vehicleLicenseService.GetList("from VehicleLicense where MpUserId = '" + mpUser.Id + "'"); OceanDynamicList <object> vehicleList = _vehicleLicenseService.GetPageDynamicList(PageIndex, PageSize, vehicleLicenseDTO, 0); //ViewBag.VehicleList = new JavaScriptSerializer().Serialize(Json(vehicleList).Data); //Json(vehicleList, JsonRequestBehavior.AllowGet); //return View(vehicleList); if (vehicleList != null) { return(Content(vehicleList.ToJson(), "text/javascript")); } else { return(Content("{\"rows\":[],\"total\":0}", "text/javascript")); } }
public OceanDynamicList <object> GetPageDynamicList(int pageIndex, int pageSize, VehicleLicenseDTO vehicleLicenseDTO, int isAll) { string condition = ""; Dictionary <string, object> parms = new Dictionary <string, object>(); if (!string.IsNullOrEmpty(vehicleLicenseDTO.Owner)) { parms.Add("Owner", vehicleLicenseDTO.Owner); if (!string.IsNullOrEmpty(condition)) { condition += " and "; } else { condition += " where "; } condition += "Owner=@Owner"; } if (!string.IsNullOrEmpty(vehicleLicenseDTO.PlateNo)) { parms.Add("PlateNo", vehicleLicenseDTO.PlateNo); if (!string.IsNullOrEmpty(condition)) { condition += " and "; } else { condition += " where "; } condition += "PlateNo like '%'+@PlateNo+'%'"; } if (vehicleLicenseDTO.StartDate.HasValue) { parms.Add("StartDate", vehicleLicenseDTO.StartDate); if (!string.IsNullOrEmpty(condition)) { condition += " and "; } else { condition += " where "; } condition += "f.IssueDate >= @StartDate"; } if (vehicleLicenseDTO.EndDate.HasValue) { parms.Add("EndDate", vehicleLicenseDTO.EndDate); if (!string.IsNullOrEmpty(condition)) { condition += " and "; } else { condition += " where "; } condition += "f.IssueDate <= @EndDate"; } if (!string.IsNullOrEmpty(vehicleLicenseDTO.MpUser)) { parms.Add("Name", vehicleLicenseDTO.MpUser); if (!string.IsNullOrEmpty(condition)) { condition += " and "; } else { condition += " where "; } condition += "Name like '%'+@Name+'%'"; } if (isAll == 0) { parms.Add("MpUserId", vehicleLicenseDTO.MpUserId); if (!string.IsNullOrEmpty(condition)) { condition += " and "; } else { condition += " where "; } condition += "MpUserId = @MpUserId"; } return(this.GetDynamicList("SELECT f.Id,f.MpUserId MpUserId,f.PlateNo,f.VehicleType,f.Owner,f.Address,f.UseCharacter,f.CarModel,f.VIN,f.EngineNo,f.RegisterDate,f.IssueDate,m.Name,f.CreateDate CreateDate FROM VehicleLicense f left join MpUser m on f.MpUserId = m.ID " + condition + " order by f.CreateDate desc", pageIndex, pageSize, parms)); }