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