/// <summary>
/// 添加车辆
/// </summary>
public int AddCar(QW_CarsModel model)
{
using (Entities db = new Entities())
{
qw_cars qcmodel = db.qw_cars.FirstOrDefault(a => a.carnumber == model.carnumber || a.code == model.code);
if (qcmodel != null)
{
return(-1);
}
else
{
qw_cars cmodel = new qw_cars();
cmodel.carid = model.carid;
cmodel.code = model.code;
cmodel.carstatus = model.carstatus;
cmodel.cartypeid = model.cartypeid;
cmodel.unitid = model.unitid;
cmodel.carnumber = model.carnumber;
cmodel.cartel = model.cartel;
cmodel.isonline = model.isonline;
cmodel.createuserid = model.createuserid;
cmodel.createtime = DateTime.Now;
cmodel.status = model.status;
cmodel.ssbc = model.ssbc;
db.qw_cars.Add(cmodel);
db.SaveChanges();
return(cmodel.carid);
}
}
}
/// <summary>
/// 修改车辆
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditCar(QW_CarsModel model)
{
using (Entities db = new Entities())
{
IQueryable <qw_cars> qcoldmodel = db.qw_cars.Where(a => a.carnumber == model.carnumber || a.code == model.code);
int count = qcoldmodel.Where(a => a.carid != model.carid).Count();
if (count != 0)
{
return(-1);
}
else
{
qw_cars qcmodel = db.qw_cars.FirstOrDefault(a => a.carid == model.carid);
if (qcmodel != null)
{
qcmodel.code = model.code;
qcmodel.carstatus = model.carstatus;
qcmodel.cartypeid = model.cartypeid;
qcmodel.unitid = model.unitid;
qcmodel.carnumber = model.carnumber;
qcmodel.cartel = model.cartel;
qcmodel.createuserid = model.createuserid;
qcmodel.ssbc = model.ssbc;
}
}
return(db.SaveChanges());
}
}
public HttpResponseMessage EditCar(QW_CarsModel model)
{
int success = bll.EditCar(model);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
if (success > 0)
{
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
}
else if (success == -1)
{
response.Content = new StringContent("{\"success\":false}", Encoding.GetEncoding("UTF-8"), "text/html");
}
return(response);
}
/// <summary>
/// 获取车辆详情
/// </summary>
/// <param name="carid"></param>
/// <returns></returns>
public QW_CarsModel GetCarInfo(int carid)
{
QW_CarsModel model = new QW_CarsModel();
using (Entities db = new Entities())
{
IQueryable <QW_CarsModel> queryable = from a in db.qw_cars
join b_join in db.base_units on a.unitid equals b_join.id into bTmp
from b in bTmp.DefaultIfEmpty()
join c_join in db.base_units on a.ssbc equals c_join.id into cTmp
from c in cTmp.DefaultIfEmpty()
join d_join in db.base_zds on a.cartypeid equals d_join.zd_id into dTmp
from d in dTmp.DefaultIfEmpty()
join e_join in db.qw_carlastpositions on a.carid equals e_join.carid into eTemp
from e in eTemp.DefaultIfEmpty()
where d.zd_type == "type_car" && a.carid == carid
select new QW_CarsModel
{
carid = a.carid,
code = a.code,
cartypeid = a.cartypeid,
unitid = a.unitid,
carstatus = a.carstatus,
carnumber = a.carnumber,
cartel = a.cartel,
isonline = a.isonline,
createuserid = a.createuserid,
createtime = a.createtime,
status = a.status,
ssbc = a.ssbc,
unitname = b == null ? "" : b.name,
ssbcname = c == null ? "" : c.name,
cartypename = d == null ? "" : d.zd_name,
remarks = a.remarks,
x84 = e.x84,
y84 = e.y84,
positiontime = e.positiontime
};
model = queryable.FirstOrDefault();
}
return(model);
}
/// <summary>
/// 修改车辆
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditCar(QW_CarsModel model)
{
return(dal.EditCar(model));
}
/// <summary>
/// 添加车辆
/// </summary>
public int AddCar(QW_CarsModel model)
{
return(dal.AddCar(model));
}
public void GetAllListEvent()
{
try
{
while (true)
{
QW_CarsDAL cardal = new QW_CarsDAL();
string url = "http://116.247.83.157/StandardApiAction_queryUserVehicle.action?jsession=" + jsession;
string Tracking = HttpWebPost.Request(url, false, "");
// 反序列化json
JavaScriptSerializer jss = new JavaScriptSerializer();
JObject Trackingjson = (JObject)JsonConvert.DeserializeObject(Tracking);
if (Trackingjson["result"].ToString() == "7")
{
GetPassWord();
}
else if (Trackingjson["result"].ToString() == "3")
{
GetPassWord();
}
else if (Trackingjson["result"].ToString() == "4")
{
GetPassWord();
}
else
{
List <CarSynchronizeModel> TrackingList = jss.Deserialize <List <CarSynchronizeModel> >(Trackingjson["vehicles"].ToString());
foreach (CarSynchronizeModel item in TrackingList)
{
QW_CarsModel qcar = new QW_CarsModel();
if (!string.IsNullOrEmpty(item.nm))
{
string[] nms = item.nm.Split('-');
switch (nms[0])
{
case "高":
qcar.unitid = 12;
break;
}
switch (nms[1])
{
case "扫":
qcar.cartypeid = "4";
break;
case "洒":
qcar.cartypeid = "5";
break;
case "压":
qcar.cartypeid = "3";
break;
}
qcar.carnumber = nms[2];
}
qcar.code = item.id.ToString();
qcar.cartel = item.dl[0].id;
qcar.isonline = 1;
qcar.createuserid = 1;
qcar.createtime = DateTime.Now;
qcar.status = 0;
qcar.carstatus = 0;
qcar.remarks = item.nm;
cardal.AddCar(qcar);
}
}
}
}
catch (Exception)
{
throw;
}
}
