public ActionResult PrimaryQuery(string Province, string City, string County) { List <PassengerVehicle> list = new List <PassengerVehicle>(); using (WuLinEntities1 db = new WuLinEntities1()) { list = db.PassengerVehicles.Where(x => x.省.Contains(Province)).Take(2).ToList(); } return(Json(list, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 多条件查询,包括分页,采用MvcPager插件 /// </summary> /// <param name="id"> /// 页码 /// </param> /// <returns></returns> public ActionResult MultiQuery(int id = 1) { using (var db = new WuLinEntities1()) { ViewData["info"] = "当前数据为示例数据。。。"; var model = db.PassengerVehicles.Take(1).OrderByDescending(a => a.时间).ToPagedList(id, 1); if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } ViewData["user"] = System.Web.HttpContext.Current.User.Identity.Name; return(View(model)); } }
/// <summary> /// 多条件统计,包括分页,采用MvcPager插件 /// </summary> /// <param name="id"> /// 页码 /// </param> /// <returns></returns> public ActionResult MultiStatistics(int id = 1) { using (var db = new WuLinEntities1()) { ViewData["info"] = "当前数据为示例数据。。。"; var fields = new List <string>(); fields.Add("品牌"); fields.Add("合计"); ViewData["fields"] = fields; var model = new List <MyDynamicType>() { new MyDynamicType { 品牌 = "大众", 合计 = 100 } }.ToPagedList(id, 1); if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } ViewData["user"] = System.Web.HttpContext.Current.User.Identity.Name; return(View(model)); } }
///<summary> /// #region 少量excel数据导入数据库 /// </summary> public static async Task <DataTable> ImExport(DataTable dt, IWorkbook hssfworkbook) { NPOI.SS.UserModel.ISheet sheet = hssfworkbook.GetSheetAt(0); System.Collections.IEnumerator rows = sheet.GetRowEnumerator(); for (int j = 0; j < (sheet.GetRow(0).LastCellNum); j++) { dt.Columns.Add(sheet.GetRow(0).Cells[j].ToString()); } while (rows.MoveNext()) { XSSFRow row = (XSSFRow)rows.Current; DataRow dr = dt.NewRow(); for (int i = 0; i < row.LastCellNum; i++) { NPOI.SS.UserModel.ICell cell = row.GetCell(i); if (cell == null) { dr[i] = null; } else { dr[i] = cell.ToString(); } } dt.Rows.Add(dr); } dt.Rows.RemoveAt(0); #region 往数据库表添加数据 using (WuLinEntities1 db = new WuLinEntities1()) { if (dt != null && dt.Rows.Count != 0) { for (int i = 0; i < dt.Rows.Count; i++) { string 时间 = dt.Rows[i]["时间"].ToString(); string 国产进口 = dt.Rows[i]["国产/进口"].ToString(); string 省 = dt.Rows[i]["省"].ToString(); string 市 = dt.Rows[i]["市"].ToString(); string 县 = dt.Rows[i]["县"].ToString(); string 制造商 = dt.Rows[i]["制造商"].ToString(); string 车辆型号 = dt.Rows[i]["车辆型号"].ToString(); string 品牌 = dt.Rows[i]["品牌"].ToString(); string 车型 = dt.Rows[i]["车型"].ToString(); string 排量 = dt.Rows[i]["排量"].ToString(); string 变速器 = dt.Rows[i]["变速器"].ToString(); string 车辆类型 = dt.Rows[i]["车辆类型"].ToString(); string 车身型式 = dt.Rows[i]["车身型式"].ToString(); string 燃油类型 = dt.Rows[i]["燃油类型"].ToString(); string 使用性质 = dt.Rows[i]["使用性质"].ToString(); string 所有权 = dt.Rows[i]["所有权"].ToString(); string 抵押标记 = dt.Rows[i]["抵押标记"].ToString(); string 性别 = dt.Rows[i]["性别"].ToString(); string 年龄 = dt.Rows[i]["年龄"].ToString(); string 车身颜色 = dt.Rows[i]["车身颜色"].ToString(); string 发动机型号 = dt.Rows[i]["发动机型号"].ToString(); string 功率 = dt.Rows[i]["功率"].ToString(); string 排放标准 = dt.Rows[i]["排放标准"].ToString(); string 轴距 = dt.Rows[i]["轴距"].ToString(); string 轮胎规格 = dt.Rows[i]["轮胎规格"].ToString(); string 车外廓长 = dt.Rows[i]["车外廓长"].ToString(); string 车外廓宽 = dt.Rows[i]["车外廓宽"].ToString(); string 车外廓高 = dt.Rows[i]["车外廓高"].ToString(); string 准确排量 = dt.Rows[i]["准确排量"].ToString(); string 核定载客 = dt.Rows[i]["核定载客"].ToString(); string 总质量 = dt.Rows[i]["总质量"].ToString(); string 整备质量 = dt.Rows[i]["整备质量"].ToString(); string 轴数 = dt.Rows[i]["轴数"].ToString(); string 前轮距 = dt.Rows[i]["前轮距"].ToString(); string 后轮距 = dt.Rows[i]["后轮距"].ToString(); string 保有量 = dt.Rows[i]["保有量"].ToString();; //int.TryParse(dt.Rows[i]["保有量"].ToString(), out 保有量); PassengerVehicle pv = new PassengerVehicle(); pv.Id = Guid.NewGuid(); pv.使用性质 = 使用性质; pv.保有量 = Convert.ToInt32(保有量); pv.准确排量 = (准确排量); pv.制造商 = 制造商; pv.前轮距 = (前轮距); pv.功率 = (功率); pv.县 = 县; pv.发动机型号 = 发动机型号; pv.变速器 = 变速器; pv.后轮距 = (后轮距); pv.品牌 = 品牌; pv.国产_进口 = 国产进口; pv.市 = 市; pv.年龄 = (年龄); pv.性别 = 性别; pv.总质量 = (总质量); pv.所有权 = 所有权; pv.抵押标记 = 抵押标记; pv.排放标准 = 排放标准; pv.排量 = (排量); pv.整备质量 = (整备质量); pv.时间 = 时间; pv.核定载客 = (核定载客); pv.燃油类型 = 燃油类型; pv.省 = 省; pv.车型 = 车型; pv.车外廓宽 = (车外廓宽); pv.车外廓长 = (车外廓长); pv.车外廓高 = (车外廓高); pv.车身型式 = 车身型式; pv.车身颜色 = 车身颜色; pv.车辆型号 = 车辆型号; pv.车辆类型 = 车辆类型; pv.轮胎规格 = 轮胎规格; pv.轴数 = (轴数); pv.轴距 = (轴距); db.PassengerVehicles.Add(pv); try { await db.SaveChangesAsync(); } catch (Exception e) { Console.WriteLine("第" + i + "条:" + e.Message); } } } #endregion } return(dt); }
public async Task <ActionResult> MultiQuery(string Province, string City, string County, int id) { using (var db = new WuLinEntities1()) { var model = db.PassengerVehicles.Take(1).OrderByDescending(a => a.时间).ToPagedList(id, 1);//示例数据 ViewData["user"] = System.Web.HttpContext.Current.User.Identity.Name; string userName = System.Web.HttpContext.Current.User.Identity.Name; if (userName == null || userName == "") { ViewData["info"] = "您没有权限查询该地域的数据!!当前数据为示例数据。。。"; if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } return(View(model)); } AppUser user = await UserManager.FindByNameAsync(userName); List <Address> listAddress = GetUserAddress(user); if (listAddress == null || listAddress.Count == 0) { ViewData["info"] = "您没有权限查询该地域的数据!!当前数据为示例数据。。。"; if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } return(View(model)); } if (AddressListProvinceContainAll(listAddress) == false)//地址列表中没有全部省份 { bool isInProvince = false; foreach (var item in listAddress) { if (item.Province.Contains(Province) || Province.Contains(item.Province) || item.Province.Equals(Province)) { isInProvince = true; break; } } if (isInProvince == false) { ViewData["info"] = "您没有权限查询该地域的数据!!当前数据为示例数据。。。"; if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } return(View(model)); } List <Address> provinceAddressList = new List <Address>();//记录含有本函数Province参数值的地址 foreach (var item in listAddress) { if (item.Province.Contains(Province) || Province.Contains(item.Province) || item.Province.Equals(Province)) { provinceAddressList.Add(item); } } if (AddressListCityContainAll(provinceAddressList) == false)//对应省的地址列表中没有全部市 { bool isInCity = false; foreach (var item in provinceAddressList) { if (item.City.Contains(City) || City.Contains(item.City) || item.City.Equals(City)) { isInCity = true; break; } } if (isInCity == false) { ViewData["info"] = "您没有权限查询该地域的数据!!当前数据为示例数据。。。"; if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } return(View(model)); } List <Address> CityAddressList = new List <Address>();//记录对应省含有本函数City参数值的地址 foreach (var item in provinceAddressList) { if (item.City.Contains(City) || City.Contains(item.City) || item.City.Equals(City)) { CityAddressList.Add(item); } } if (AddressListCountyContainAll(CityAddressList) == false)//地址列表中没有全部区县 { bool isInCounty = false; foreach (var item in CityAddressList) { if (item.County.Contains(County) || County.Contains(item.County) || item.County.Equals(County)) { isInCounty = true; break; } } if (isInCounty == false) { ViewData["info"] = "您没有权限查询该地域的数据!!当前数据为示例数据。。。"; if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } return(View(model)); } } } } var qry = db.PassengerVehicles.AsQueryable(); if (!string.IsNullOrWhiteSpace(Province) && !Province.Contains("全部")) { qry = qry.Where(x => x.省.Contains(Province) || Province.Contains(x.省)); } if (!string.IsNullOrWhiteSpace(City) && !City.Contains("全部")) { qry = qry.Where(x => x.市.Contains(City) || City.Contains(x.市)); } if (!string.IsNullOrWhiteSpace(County) && !County.Contains("全部")) { qry = qry.Where(x => x.县.Contains(County) || County.Contains(x.县)); } model = qry.OrderByDescending(a => a.时间).ToPagedList(id, 7); if (Request.IsAjaxRequest()) { return(PartialView("_AjaxSearchPost", model)); } ViewData["user"] = System.Web.HttpContext.Current.User.Identity.Name; return(View(model)); } }