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