public static void AddCarInfo(Carinfo Carinfo) { //string query = string.Format(@"Insert into Reviews Values ({0}, {1}, {2}, '{3}', '{4}', '{5}', '{6}')", // Carinfo.carID, Carinfo.garageID, // Carinfo.model, Carinfo.make, Carinfo.milage, Carinfo.engine, Carinfo.condition); string query = string.Format(@"Insert into Car Values ({0}, {1}, '{2}', '{3}', '{4}', '{5}', '{6}')", Carinfo.carID, Carinfo.garageID, Carinfo.model, Carinfo.make, Carinfo.milage, Carinfo.engine, Carinfo.condition); cmd = new SqlCommand(query, cn); try { cn.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { cn.Close(); } }
public ActionResult GetCarList() { List <Carinfo> cars = new List <Carinfo>(); Cparts_Service.CarBll carBll = new Cparts_Service.CarBll(); List <DAO.CarM> carList = carBll.GetList(); List <string> brand = carList.GroupBy(m => m.Brand).Select(g => g.Key).ToList(); foreach (var item in brand) { List <CarModel> cmList = new List <CarModel>(); Carinfo c = new Carinfo(); c.brand = item; List <string> models = carList.Where(m => m.Brand == item).GroupBy(m => m.Model).Select(g => g.Key).ToList(); foreach (var i in models) { CarModel cm = new CarModel(); cm.model = i; //List<string> years = carList.Where(m => m.Brand == item && m.Model == i).Select(g => g.ProYear).ToList(); List <string> years = carList.Where(m => m.Brand == item && m.Model == i).OrderByDescending(g => g.ProYear).Select(g => g.ProYear).ToList(); cm.year = years; cmList.Add(cm); } c.models = cmList; cars.Add(c); } return(Json(cars, JsonRequestBehavior.AllowGet)); }
/// <summary> /// /// </summary> /// <param name="log"></param> /// <param name="firstnum"></param> /// <param name="lengthsearch"></param> /// <param name="tonum"></param> /// <returns></returns> public int Download(ILog log, long firstnum, long lengthsearch, out long tonum) { string tablename = "car_renewal"; tonum = firstnum + lengthsearch + 1; long now = (DateTime.Now.ToUniversalTime().Ticks - 621355968000000000) / 10000000; string urlper = $"Agent=102&TName={tablename}&FromId={firstnum}&ToId={tonum}&UniversalTime={now}"; string securl = $"Agent=102&tNaMe={tablename}&FroMId={firstnum}&toId={tonum}&UniversalTiMe={now}"; string seccode = securl.GetMd5(); string url = $"http://localhost:55211/api/http/BackDbToStatistic?{urlper}&seccode={seccode}"; try { using (var client = new HttpClient()) { var clientResult = client.GetAsync(url).Result; if (clientResult.IsSuccessStatusCode) { var result = clientResult.Content.ReadAsStringAsync().Result; log.Info($"请求串:{url}");//,返回结果:{result} int count = 0; if (tablename.Equals("carinfo")) { Carinfo a = JsonConvert.DeserializeObject <Carinfo>(result); List <bx_carinfo> list = a.Data; DbRepository db = new DbRepository(); count = db.InsertCarinfo(log, list); return(count); } if (tablename.Equals("car_renewal")) { Carrenewal a = JsonConvert.DeserializeObject <Carrenewal>(result); List <bx_car_renewal> list = a.Data; DbRepository db = new DbRepository(); count = db.InsertCarrenewal(log, list); return(count); } if (tablename.Equals("agent")) { Agent a = JsonConvert.DeserializeObject <Agent>(result); List <bx_agent> list = a.Data; DbRepository db = new DbRepository(); count = db.InsertAgent(log, list); return(count); } } return(0); } } catch (Exception ex) { log.Info("发生异常:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException); } return(0); }
protected void btn_submit_Click(object sender, EventArgs e) { try { string CarModel = Txt_Model.Text; string CarMake = Txt_Make.Text; string Engine = Txt_Engine.Text; string Condition = Txt_Condition.Text; string Milage = Txt_Milage.Text; Carinfo infoBin = new Carinfo(CarModel, CarMake, Milage, Engine, Condition); ConnectionClass.AddCarInfo(infoBin); lbl_Confirm.Text = "Entry Success"; } catch (Exception EX) { lbl_Confirm.Text = "Entry Failed" + EX.Message; } }