public ActionResult GetMyList(FormCollection collection, Common.PagingModels paging, string Search)
{
var CarType = Common.ToolHelper.ConvertToLong(collection["CarType"]);
if (CarType == Common.Constant.LONG_DEFAULT)
{
CarType = 0;
}
var list = provider.GetList(paging, CarType, Search);
var str = new System.Text.StringBuilder();
foreach (var item in list)
{
str.Append("<li>");
str.Append("<table>");
str.Append("<tr>");
str.Append("<th><img src=" + new Common.FileHelper().GetFileUrl(item.PhotoURL, Common.FileConfig.CarPhotoPath, this.HttpContext) + " /></th>");
str.Append("<td style='width:62%;'>");
str.Append("<h1>车辆型号：" + item.BrandName + item.SeriesName + item.CarName + "</h1><br /><span>" + item.Odometer + " / " + item.LicenseTime.ToString("yyyy-M") + "</span><br /><label>￥" + item.RetailPrice + "万元</label>");
if (item.AuditStatus == 0)
{
str.Append("<a href='~/Home/Create?id=" + item.Id + "' style='display: inline-block;margin-left: 30px;'>修改</a>");
}
str.Append("<a href='~/Mobile/Delete?checkedId=" + item.Id + "'>删除</a>");
str.Append("</td>");
str.Append("</tr>");
str.Append("</table>");
str.Append("</li>");
}
return(Content(str.ToString()));
}
public ActionResult GetList(Common.PagingModels paging, string search = "")
{
var list = provider.GetList(search, paging);
var model = new List <Models.UserBasisModels.UserBasisModel>();
foreach (var item in list)
{
model.Add(new Models.UserBasisModels.UserBasisModel
{
Id = item.Id.ToString(),
Sex = item.Sex,
LoginCode = item.LoginCode,
Mobile = item.Mobile,
Passwords = item.Passwords,
RealName = item.RealName,
LastTime = item.LastTime,
QQ = item.QQ.ToString(),
Weixin = item.Weixin,
CreateTime = item.CreateTime
});
}
var json = new
{
Data = model,
RowCount = paging.totalrows
};
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(json)));
}
public ActionResult GetList(Common.PagingModels paging, string Search)
{
var model = new List <Models.CarInfoModels.CarInfoModel>();
var list = provider.GetAuditList(paging, Search);
foreach (var item in list)
{
model.Add(new Models.CarInfoModels.CarInfoModel
{
Id = item.Id.ToString(),
SeriesName = item.SeriesName,
CarNo = item.CarNo,
TypeName = item.TypeName,
BrandName = item.BrandName,
RetailPrice = item.RetailPrice,
LicenseTime = item.LicenseTime,
AuditStatus = item.AuditStatus,
Remark = item.Remark,
CreateTime = item.CreateTime,
CarName = item.CarName,
CarStatus = item.CarStatus,
});
}
var json = new
{
Data = model,
RowCount = paging.totalrows
};
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(json)));
}
public ActionResult GetList(Common.PagingModels paging, string search = "")
{
var list = provider.GetMenuList(search, paging);
var model = new List <Models.MenuBasisModels.MenuBasisModel>();
foreach (var item in list)
{
model.Add(new Models.MenuBasisModels.MenuBasisModel
{
Id = item.Id.ToString(),
MenuName = item.MenuName,
ActionName = item.ActionName,
ControllerName = item.ControllerName,
MenuIcon = item.MenuIcon,
MenuSort = item.MenuSort,
ParentId = item.ParentId.ToString()
});
}
var json = new
{
Data = model,
RowCount = paging.totalrows
};
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(json)));
}
public ActionResult MyCar(string CarType, string Search)
{
SetUser();
var userId = Common.FormsTicket.UserId;
if (userId > 0)
{
}
else
{
return(RedirectToAction("Index"));
}
var paging = new Common.PagingModels();
var list = provider.GetList(paging, Common.ToolHelper.ConvertToLong(CarType), Search).ToList();
foreach (var item in list)
{
item.PhotoURL = new Common.FileHelper().GetFileUrl(item.PhotoURL, Common.FileConfig.CarPhotoPath, this.HttpContext);
}
var TypeItem = CarTypeItem(Common.ToolHelper.ConvertToLong(CarType), true);
ViewBag.TypeItem = TypeItem;
ViewBag.Search = Search;
return(View(list));
}
public IQueryable <SysMenuBasis> GetMenuList(string search, Common.PagingModels paging)
{
IQueryable <SysMenuBasis> model = db.SysMenuBasis.Where(c => c.IsDelete == 0 && c.MenuName.Contains(search)).OrderBy(c => c.MenuSort);
paging.totalrows = model.Count();
model = model.Skip((paging.page - 1) * paging.rows).Take(paging.rows);
return(model);
}
public IQueryable <SysUserBasis> GetList(string search, Common.PagingModels paging)
{
IQueryable <SysUserBasis> model = db.SysUserBasis.Where(c => c.IsDelete == (int)Common.EnumModel.EIsDelete.NotDelete && c.RealName.Contains(search)).OrderBy(c => c.Id);
paging.totalrows = model.Count();
model = model.Skip((paging.page - 1) * paging.rows).Take(paging.rows);
return(model);
}
/// <summary>
/// 我的车源
/// </summary>
/// <param name="paging"></param>
/// <param name="TypeId"></param>
/// <param name="Search"></param>
/// <returns></returns>
public IEnumerable <CarInfo> GetList(Common.PagingModels paging, long TypeId, string Search)
{
var query = from a in db.CarInfo
where a.IsDelete == (int)Common.EnumModel.EIsDelete.NotDelete && a.UserId == Common.FormsTicket.UserId &&
(TypeId > 0 ? a.TypeId == TypeId : true) && (string.IsNullOrEmpty(Search) ? 1 == 1 : (a.BrandName.Contains(Search) || a.TypeName.Contains(Search) || a.SeriesName.Contains(Search)))
select a;
paging.totalrows = query.Count();
query = query.OrderByDescending(c => c.CreateTime).Skip((paging.page - 1) * paging.rows).Take(paging.rows);
return(query);
}
public IQueryable <CarInfo> GetAuditList(Common.PagingModels paging, string Search)
{
var query = from a in db.CarInfo
where a.IsDelete == (int)Common.EnumModel.EIsDelete.NotDelete && a.AuditStatus == (int)Common.EnumModel.EAuditStatus.Normal &&
(string.IsNullOrEmpty(Search) ? true : (a.BrandName.Contains(Search) || a.TypeName.Contains(Search) || a.SeriesName.Contains(Search)))
select a;
paging.totalrows = query.Count();
query = query.OrderByDescending(c => c.CreateTime).Skip((paging.page - 1) * paging.rows).Take(paging.rows);
return(query);
}
public IQueryable <CarInfo> GetList(Common.PagingModels paging, long UserId, long?TypeId, string Search)
{
var query = from a in db.CarInfo
where a.IsDelete == (int)Common.EnumModel.EIsDelete.NotDelete &&
(TypeId != null ? a.TypeId == TypeId.Value : true) && (UserId == 0 ? true : a.UserId == UserId) && (string.IsNullOrEmpty(Search) ? true : (a.BrandName.Contains(Search) || a.TypeName.Contains(Search) || a.SeriesName.Contains(Search)))
select a;
paging.totalrows = query.Count();
query = query.OrderByDescending(c => c.CreateTime).Skip((paging.page - 1) * paging.rows).Take(paging.rows);
return(query);
}
public IQueryable <CarBrand> GetList(Common.PagingModels paging, string Search)
{
var query = from a in db.CarBrand
where a.IsDelete == (int)Common.EnumModel.EIsDelete.NotDelete &&
(string.IsNullOrEmpty(Search) ? true : a.BrandName.Contains(Search))
select a;
paging.totalrows = query.Count();
query = query.OrderBy(c => c.BrandSort).Skip((paging.page - 1) * paging.rows).Take(paging.rows);
return(query);
}
public ActionResult GetMyCar(FormCollection collecton, Common.PagingModels paging)
{
var cList = new List <Models.CarInfoModels.CarInfoModel>();
var userId = Common.FormsTicket.UserId;
if (userId > 0)
{
var TypeId = Common.ToolHelper.ConvertToLong(collecton["TypeId"]);
if (TypeId == Common.Constant.LONG_DEFAULT)
{
TypeId = 0;
}
var Search = collecton["Search"];
foreach (var item in provider.GetList(paging, TypeId, Search))
{
cList.Add(new Models.CarInfoModels.CarInfoModel
{
Id = item.Id.ToString(),
CarNo = item.CarNo,
CreateTime = item.CreateTime,
SweptVolume = item.SweptVolume,
CarColor = item.CarColor,
CarName = item.CarName,
LicenseTime = item.LicenseTime,
Odometer = item.Odometer,
Remark = item.Remark,
RetailPrice = item.RetailPrice,
BrandName = item.BrandName,
SeriesName = item.SeriesName,
TypeName = item.TypeName,
Transmission = item.Transmission,
Fuel = item.Fuel,
EmissionStandards = item.EmissionStandards,
ProductAddress = item.ProductAddress,
AuditStatus = item.AuditStatus,
});
}
}
else
{
return(RedirectToAction("Index"));
}
var json = new
{
Data = cList,
RowCount = paging.totalrows
};
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(json)));
}
public ActionResult AuditList()
{
if (Common.FormsTicket.UserType != 1)
{
return(RedirectToAction("Index"));
}
SetUser();
var paging = new Common.PagingModels();
var list = provider.GetAuditList(paging, "").ToList();
foreach (var item in list)
{
item.PhotoURL = new Common.FileHelper().GetFileUrl(item.PhotoURL, Common.FileConfig.CarPhotoPath, this.HttpContext);
}
return(View(list));
}
/// <summary>
/// List 分页查询
/// </summary>
/// <param name="collecton"></param>
/// <param name="paging"></param>
/// <returns></returns>
public ActionResult CarList(FormCollection collecton, Common.PagingModels paging)
{
var model = new Provider.CarInfoProvider.ListModel()
{
TypeId = Common.ToolHelper.ConvertToLong(collecton["TypeId"]),
CarNo = collecton["CarNo"],
RetailPrice1 = Common.ToolHelper.ConvertToDecimal(collecton["RetailPrice1"]),
RetailPrice2 = Common.ToolHelper.ConvertToDecimal(collecton["RetailPrice2"]),
Transmission = collecton["Transmission"],
BrandId = Common.ToolHelper.ConvertToLong(collecton["BrandId"]),
SeriesId = Common.ToolHelper.ConvertToLong(collecton["SeriesId"]),
LicenseTime1 = Common.ToolHelper.ConvertToDateTime(collecton["LicenseTime1"]),
LicenseTime2 = Common.ToolHelper.ConvertToDateTime(collecton["LicenseTime2"]),
Search = collecton["Search"]
};
var cList = new List <Models.CarInfoModels.CarInfoModel>();
foreach (var item in provider.GetList(model, paging))
{
cList.Add(new Models.CarInfoModels.CarInfoModel {
Id = item.Id.ToString(),
CarNo = item.CarNo,
CreateTime = item.CreateTime,
SweptVolume = item.SweptVolume,
CarColor = item.CarColor,
CarName = item.CarName,
LicenseTime = item.LicenseTime,
Odometer = item.Odometer,
Remark = item.Remark,
RetailPrice = item.RetailPrice,
BrandName = item.BrandName,
SeriesName = item.SeriesName,
TypeName = item.TypeName,
Transmission = item.Transmission,
Fuel = item.Fuel,
EmissionStandards = item.EmissionStandards,
ProductAddress = item.ProductAddress,
});
}
var json = new
{
Data = cList,
RowCount = paging.totalrows
};
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(json)));
}
public ActionResult GetList(Common.PagingModels paging, long?TypeId, string Search)
{
if (TypeId == Common.Constant.LONG_DEFAULT)
{
TypeId = null;
}
long userId = 0;
if (Common.FormsTicket.UserType == 1)
{
}
else
{
//不是超级管理员只能看自己数据
userId = Common.FormsTicket.UserId;
}
var model = new List <Models.CarInfoModels.CarInfoModel>();
var list = provider.GetList(paging, userId, TypeId, Search);
foreach (var item in list)
{
model.Add(new Models.CarInfoModels.CarInfoModel
{
Id = item.Id.ToString(),
SeriesName = item.SeriesName,
CarNo = item.CarNo,
TypeName = item.TypeName,
BrandName = item.BrandName,
RetailPrice = item.RetailPrice,
LicenseTime = item.LicenseTime,
AuditStatus = item.AuditStatus,
Remark = item.Remark,
CreateTime = item.CreateTime,
CarName = item.CarName,
CarStatus = item.CarStatus,
});
}
var json = new
{
Data = model,
RowCount = paging.totalrows
};
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(json)));
}
public ActionResult GetAuditList(Common.PagingModels paging)
{
var model = new List <Models.CarInfoModels.CarInfoModel>();
var list = provider.GetAuditList(paging, "");
var str = new System.Text.StringBuilder();
foreach (var item in list)
{
str.Append("<li>");
str.Append("<table>");
str.Append("<tr>");
str.Append("<th><img src=" + new Common.FileHelper().GetFileUrl(item.PhotoURL, Common.FileConfig.CarPhotoPath, this.HttpContext) + " /></th>");
str.Append("<td style='width:62%;'>");
str.Append("<h1>车辆型号：" + item.BrandName + item.SeriesName + item.CarName + "</h1><br /><span>" + item.Odometer + " / " + item.LicenseTime.ToString("yyyy-M") + "</span><br /><label>￥" + item.RetailPrice + "万元</label>");
str.Append("<a href='~/Mobile/AuditInfo?id=" + item.Id + "'>删除</a>");
str.Append("</td>");
str.Append("</tr>");
str.Append("</table>");
str.Append("</li>");
}
return(Content(str.ToString()));
}
public ActionResult GetList(Common.PagingModels paging, string Search)
{
var model = new List <Models.CarBrandModels.CarBrandModel>();
var list = provider.GetList(paging, Search);
foreach (var item in list)
{
model.Add(new Models.CarBrandModels.CarBrandModel
{
Id = item.Id.ToString(),
BrandSort = item.BrandSort,
BrandName = item.BrandName,
Initial = item.Initial
});
}
var json = new
{
Data = model,
RowCount = paging.totalrows
};
return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(json)));
}
/// <summary>
/// 前台查询
/// </summary>
/// <param name="model"></param>
/// <param name="paging"></param>
/// <returns></returns>
public IEnumerable <CarInfo> GetList(ListModel model, Common.PagingModels paging)
{
//明明已经提供了参数还报错 是因为0比较特殊需要加‘’
//参数化查询 '(@XX)select * from XX where XX=XX' 需要参数 '@XX'，但未提供该参数。
var param = new List <SqlParameter>();
var param1 = new List <SqlParameter>();
var sql = " and AuditStatus=1";
if (model.TypeId > 0 && model.TypeId != Common.Constant.LONG_DEFAULT)
{
sql += " and TypeId=" + model.TypeId;
}
if (!string.IsNullOrEmpty(model.CarNo))
{
sql += " and CarNo=@CarNo";
param.Add(new SqlParameter("CarNo", model.CarNo));
param1.Add(new SqlParameter("CarNo", model.CarNo));
}
if (model.RetailPrice1 > 0)
{
sql += " and RetailPrice>=" + model.RetailPrice1;
}
if (model.RetailPrice2 > 0)
{
sql += " and RetailPrice<=" + model.RetailPrice2;
}
if (!string.IsNullOrEmpty(model.Transmission) && model.Transmission != "-1")
{
sql += " and Transmission=" + model.Transmission;
}
if (model.BrandId > 0 && model.BrandId != Common.Constant.LONG_DEFAULT)
{
sql += " and BrandId=" + model.BrandId;
}
if (model.SeriesId > 0 && model.SeriesId != Common.Constant.LONG_DEFAULT)
{
sql += " and SeriesId=" + model.SeriesId;
}
if (model.LicenseTime1 != Common.ToolHelper.MinDateTime)
{
sql += " and LicenseTime>='" + model.LicenseTime1 + "'";
}
if (model.LicenseTime2 != Common.ToolHelper.MinDateTime)
{
sql += " and LicenseTime<='" + model.LicenseTime2 + "'";
}
if (!string.IsNullOrEmpty(model.Search))
{
sql += " and (BrandName like @Search or SeriesName like @Search)";
param.Add(new SqlParameter("Search", "%" + model.Search + "%"));
param1.Add(new SqlParameter("Search", "%" + model.Search + "%"));
}
var cd = db.Database.SqlQuery <int>("select count(*) from CarInfo where IsDelete=0" + sql, param1.ToArray());
paging.totalrows = cd.FirstOrDefault();
var str = "select*from(select row_number()";
switch (paging.sort)
{
case 1:
str += " over(order by RetailPrice)";
break;
case 2:
str += " over(order by RetailPrice desc)";
break;
case 3:
str += " over(order by CreateTime)";
break;
case 4:
str += " over(order by CreateTime desc)";
break;
default:
str += " over(order by CreateTime desc)";
break;
}
str += "row_num,* from CarInfo where IsDelete=0" + sql + ") as list where list.row_num>" + ((paging.page - 1) * 50) + " and list.row_num<=" + (paging.page * 50) + " ";
var query = db.Database.SqlQuery <CarInfo>(str, param.ToArray());
return(query);
}
