public ActionResult SprayPaintVehicle()
{
var manager = new SprayPaintVehicleManager();
var model = manager.SelectSprayPaintVehicle();
return(View(model));
}
public JsonResult UpdatePaintVehicleCache(string type, string data)
{
var manager = new SprayPaintVehicleManager();
var result = manager.UpdatePaintVehicleCache(type, data);
return(Json(new { Status = result.Item1, Msg = result.Item2 }));
}
public ActionResult EditSprayPaintVehicle(string vehicleLevel)
{
var manager = new SprayPaintVehicleManager();
ViewBag.VehicleLevel = vehicleLevel;
ViewBag.ServiceInfo = manager.GetPaintServiceInfo();
var model = manager.SelectSprayPaintVehicle().FirstOrDefault(p => p.VehicleLevel.Equals(vehicleLevel)) ?? new VehicleLevelModel();
return(View(model));
}
public ActionResult SprayPaintVehicle()
{
var manager = new SprayPaintVehicleManager();
var allConfigs = manager.GetVehicleLevelsForAll();
var model = allConfigs.Item1;
var offline = allConfigs.Item2;
ViewBag.offline = offline;
return(View(model));
}
public JsonResult UpdatePaintService(string vehicleLevel, string paintService)
{
var manager = new SprayPaintVehicleManager();
var operateUser = User.Identity.Name;
if (string.IsNullOrWhiteSpace(vehicleLevel))
{
return(Json(new { Status = false }));
}
var result = manager.UpdatePaintVehicleService(vehicleLevel,
paintService, operateUser);
return(Json(new { Status = result }));
}
public JsonResult UpdatePaintVehicleLevel(string vehicleLevel, string initalWord, string vehicleIds)
{
var manager = new SprayPaintVehicleManager();
var operateUser = User.Identity.Name;
if (string.IsNullOrWhiteSpace(vehicleLevel) || string.IsNullOrWhiteSpace(initalWord))
{
return(Json(new { Status = false }));
}
var result = manager.UpdatePaintVehicleLevel(vehicleLevel, vehicleIds, initalWord,
operateUser);
return(Json(new { Status = result }));
}
public JsonResult GetVehicleInfo(string vehicleLevel, string initalWord)
{
var manager = new SprayPaintVehicleManager();
if (string.IsNullOrWhiteSpace(initalWord))
{
initalWord = "A";
}
var vehicleInfo = manager.SelectVehicleInfo(initalWord);
var VehicleLevels = manager.SelectSprayPaintVehicle().Where(t => !t.VehicleLevel.Equals("不支持喷漆"));
var currentVehicleLevel = VehicleLevels.FirstOrDefault(p => p.VehicleLevel.Equals(vehicleLevel)) ?? new VehicleLevelModel();
var CheckedVehicles = currentVehicleLevel.VehicleInfo;
if (!vehicleInfo.Any())
{
return(Json(new { Status = false }, JsonRequestBehavior.AllowGet));
}
foreach (var item in vehicleInfo)
{
foreach (var vehicle in item.children)
{
//设置选中状态
if (CheckedVehicles.Count(p => p.VehicleId.Equals(vehicle.id)) > 0)
{
vehicle.check = "true";
}
foreach (var level in VehicleLevels.Where(p => !p.VehicleLevel.Equals(vehicleLevel)))
{
//如果在其他车型档次中已经选中该车型，则当前档次中该车型不可选
if (level.VehicleInfo.Count(p => p.VehicleId.Equals(vehicle.id)) > 0)
{
vehicle.disabled = "true";
}
}
}
//如果二级均为选中，则一级也设置为选中
if (item.children.Count(p => p.check.Equals("true")) == item.children.Count)
{
item.check = "true";
}
//如果二级均为不可选，则一级也设置为不可选
if (item.children.Count(p => p.disabled.Equals("true")) == item.children.Count)
{
item.disabled = "true";
}
}
return(Json(new { Status = true, items = vehicleInfo }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetVehicleInfo(string vehicleLevel, string initalWord, string type)
{
var manager = new SprayPaintVehicleManager();
if (string.IsNullOrWhiteSpace(initalWord))
{
initalWord = "A";
}
if (string.IsNullOrWhiteSpace(type))
{
type = PaintVehicleLevelTypeEnum.Online.ToString();
}
var vehicleInfo = manager.GetVehicleInfo(type, initalWord, vehicleLevel);
return(Json(new { Status = true, items = vehicleInfo }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改喷漆车型档次分类
/// </summary>
/// <param name="vehicleLevel"></param>
/// <param name="type"></param>
/// <returns></returns>
public ActionResult EditSprayPaintVehicle(string vehicleLevel, string type)
{
if (string.IsNullOrWhiteSpace(vehicleLevel))
{
vehicleLevel = "A类";
}
if (string.IsNullOrWhiteSpace(type))
{
type = PaintVehicleLevelTypeEnum.Online.ToString();
}
var manager = new SprayPaintVehicleManager();
ViewBag.VehicleLevel = vehicleLevel;
ViewBag.ServiceInfo = manager.GetPaintServiceInfo();
var model = new VehicleLevelModel();
ViewBag.type = type;
model = manager.SelectSprayPaintVehicleByLevel(type, vehicleLevel);
return(View(model));
}
public async Task <ActionResult> SearchByExcel()
{
if (Request.Files.Count <= 0)
{
return(Json(new { Status = false, Msg = "未选择文件, 请先上传文件" }));
}
var file = Request.Files[0];
if (file.ContentType != "application/vnd.ms-excel" &&
file.ContentType != "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
{
return(Json(new { Status = false, Msg = "文件格式不正确, 请上传Excel文件" }));
}
byte[] buffer = null;
using (var stream = file.InputStream)
{
buffer = new byte[stream.Length];
stream.Read(buffer, 0, buffer.Length);
}
var list = ConvertToList(buffer, array => new { Mobile = array[0], Vin = array[1] });
var vins = list.Select(x => x.Vin);
var manager = new SprayPaintVehicleManager();
var result = await manager.GetVinSprayPaintRelationResult(vins);
result = (from x in list
join y in result on x.Vin equals y.Vin into temp
from z in temp.DefaultIfEmpty()
select new VinSprayPaintRelationship
{
Mobile = x.Mobile,
Vin = x.Vin,
SprayPaintLevel = z?.SprayPaintLevel?.OrderBy(x => x.VehicleLevel)?.ToList() ?? new List <VehicleSprayPaintLevel>(),
}).ToList();
return(Json(new { Status = true, Data = result }));
}
public JsonResult IsVehicleExistsInAnotherLevel(string vehicleLevel, string vehicleIds)
{
var result = new List <Tuple <string, string> >();
var manager = new SprayPaintVehicleManager();
var VehicleLevel = manager.SelectSprayPaintVehicle().Where(t => !t.VehicleLevel.Equals("不支持喷漆"));
var currentVehicles = vehicleIds.Split(';');
foreach (var item in VehicleLevel)
{
if (!item.VehicleInfo.Any())
{
continue;
}
foreach (var vehicleId in currentVehicles)
{
if (item.VehicleInfo.Any(p => p.VehicleId.Equals(vehicleId)) && !item.VehicleLevel.Equals(vehicleLevel))
{
result.Add(new Tuple <string, string>(item.VehicleLevel, item.VehicleInfo.FirstOrDefault(p => p.VehicleId.Equals(vehicleId)).VehicleSeries));
}
}
}
return(Json(new { data = result }, JsonRequestBehavior.AllowGet));
}
