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