public void AddCarinfo(CarDetialInfo item) { int error = 0; do { try { using (var db = _dbFactory.OpenDbConnection()) { if (item.Id == 0) { item.CreateTime = DateTime.Now; db.Insert(item); } else { var old = db.SingleById <CarDetialInfo>(item.Id); item.CreateTime = old.CreateTime; db.Update(item); } } break; } catch (Exception ex1) { error++; Thread.Sleep(10000); LogServer.WriteLog(ex1.Message, "DBError"); } } while (error < 4); }
private void disp(CarDetialInfo c) { var carlist = new CarTypeInfoDb().GetCarinfoList("0"); title.Text = c.ProTitle; Literal1.Text = c.baojia.ToString("#0.00"); huanjia.Text = "(还价不多)"; sellnumber.Text = c.SellerNumber; ProNum.Text = c.ProNum?.Replace(c.SellerNumber, "") ?? ""; shangpaiym.Text = c.ShangPaiYear + "年" + c.ShangPaiMonth + "月"; var ct = carlist.FirstOrDefault(x => x.CarTypeKey == c.CarType); cartype.Text = ct.DisplayName; country.Text = c.country; CarColor.Text = c.CarColor; PaiLiang.Text = c.PaiLiang; BianShuQi.Text = c.BianShuQi; LiCheng.Text = c.LiCheng.ToString("0.00"); PaiFangBiaoZhun.Text = c.PaiFangBiaoZhun; RanYou.Text = c.RanYou; cdate.Text = c.CreateTime.ToShortDateString(); yangqing.Text = c.Remark.Replace("\\n", ""); SellerName.Text = c.SellerName; tel.Text = c.SellerPhone; Address.Text = c.CarSellAddress; }
protected void Page_Load(object sender, EventArgs e) { var id = Request["id"]; var ids = 0; int.TryParse(id, out ids); cinfo = new CarDetialInfoDb().GetCarinfo(ids); if (cinfo == null) { Response.Redirect("Searchs.aspx"); } piclist = cinfo.Images.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries).ToList(); disp(cinfo); }
protected void Page_Load(object sender, EventArgs e) { var id = Request["id"]; var ids = 0; int.TryParse(id, out ids); cinfo = new CarDetialInfoDb().GetCarinfo(ids); if (cinfo != null) { piclist = cinfo.Images.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries).ToList(); } else { cinfo = new CarDetialInfo(); piclist = new List <string>(); } disp(cinfo); }
public ActionResult Index(string TerNo) { CarDetialInfo cdi = null; if (TerNo == "null") { TerNo = ""; } cdi = carInfoBll.GetCarDetial(TerNo); //cdi.InstallInfo = this.GetFiledsInfo(CarId, TerNo, "1"); //安装信息 //cdi.CreditInfo = this.GetFiledsInfo(CarId, TerNo, "2"); //信贷信息 //cdi.CarOwnerInfo = this.GetFiledsInfo(CarId, TerNo, "3"); //车主信息 return(View(cdi)); }
public CarDetialInfo GetCarDetial(string TerNo) { CarDetialInfo cdi = new CarDetialInfo(); TerminalInfo ti = (TerminalInfo)ExecuteQueryForObject("TerminalInfo.SelectTerminalInfoByTerNo", TerNo); if (ti != null && ti.CarId != null && ti.CarId != "") { CarInfo ci = (CarInfo)ExecuteQueryForObject("CarInfo.SelectCarByCarId", ti.CarId); cdi.CarInfoData = ci; RegistrationInfo reg = (RegistrationInfo)ExecuteQueryForObject("RegistrationInfo.SelectRegistrationInfo", ci.CarNo); if (reg != null) { cdi.Register = reg; } } else { CarInfo ci = new CarInfo(); cdi.CarInfoData = ci; RegistrationInfo ri = new RegistrationInfo(); cdi.Register = ri; } if (ti != null && ti.CarId != null && ti.CarId != "") { IList <GetterpositionView> ici = ExecuteQueryForList <GetterpositionView>("TerminalInfo.SelectTerminalByCarId", ti.CarId); if (ici != null) { cdi.terminalInfo = ici; } } if (TerNo != "") { IList <GetterpositionView> ici = ExecuteQueryForList <GetterpositionView>("TerminalInfo.SelectTerminalByTerNo", TerNo); if (ici != null) { cdi.terminalInfo = ici; } } return(cdi); }
private void addCar(prolog item) { string detial = item.proName.TrimStart('[').TrimEnd(']').Replace("\"", ""); var prolist = detial.Split(','); var spri = prolist[2].Substring(prolist[2].IndexOf(":") + 1).Replace("年", "-").Replace("月", ""); var Cartype = prolist[3].Substring(prolist[3].IndexOf(":") + 1); var typeitem = new CarTypeInfoDb().GetCarinfo(new CarTypeInfo { DisplayName = Cartype }); var p_sort = typeitem.CarTypeKey; //Request.Form["p_sort"]; var title = prolist[23]; title = title.Substring(title.IndexOf(":") + 1); var bramdName = Regex.Match(title, brandReg, RegexOptions.IgnoreCase).Value; var brand = brandList.FirstOrDefault(c => c.BrandName == bramdName); var catxinghao = new BandInfoDb().GetBandInfoByParentNum(brand.BrandNum); string xhReg = ""; foreach (var xh in catxinghao) { xhReg += xh.BrandName + "|"; } xhReg = xhReg.TrimEnd('|'); var tempxinghao = Regex.Match(title, xhReg, RegexOptions.IgnoreCase).Value; var tempbrandtype = catxinghao.FirstOrDefault(c => c.DisplayName == tempxinghao); var temppic = ""; foreach (var propic in prolist) { if (propic.Contains(".jpg")) { temppic += propic.Trim(' ') + ";"; } } var p_price = Regex.Match(prolist[0], ":(?<x>.*?)万元", RegexOptions.IgnoreCase).Groups["x"].Value; var p_color = prolist[5].Substring(prolist[5].IndexOf(":") + 1); var p_kilometre = prolist[8].Substring(prolist[8].IndexOf(":") + 1).Replace("万", ""); var p_gas = prolist[6].Substring(prolist[6].IndexOf(":") + 1); var p_country = prolist[4].Substring(prolist[4].IndexOf(":") + 1); var p_transmission = prolist[7].Substring(prolist[7].IndexOf(":") + 1); var p_fuel = prolist[10].Substring(prolist[10].IndexOf(":") + 1); var p_emissionstandards = prolist[9].Substring(prolist[9].IndexOf(":") + 1); var p_details = Regex.Match(detial, "车况说明:(?<x>.*?)$", RegexOptions.IgnoreCase).Groups["x"].Value; var seller = prolist[12].Substring(prolist[12].IndexOf(":") + 1); var sellerphone = prolist[14].Substring(prolist[14].IndexOf(":") + 1); var selleradress = prolist[13].Substring(prolist[13].IndexOf(":") + 1); var proNum = prolist[1].Substring(prolist[1].IndexOf(":") + 1); CarDetialInfo pro = new CarDetialInfo(); pro.ProTitle = title; pro.CarType = p_sort; pro.BrandInfo = bramdName; pro.BrandType = tempxinghao; pro.ProNum = proNum; pro.OtherParam = ""; pro.ShangPaiTime = spri; //p_year + "-" + p_month; if (brand.BrandNum != null) { pro.BrandInfoKey = brand.BrandNum; } if (tempbrandtype != null) { pro.BrandTypeKey = tempbrandtype.BrandNum; } pro.ShangPaiMonth = int.Parse(spri.Split('-')[1]); pro.ShangPaiYear = int.Parse(spri.Split('-')[0]); pro.Images = temppic; pro.mianimg = "1"; pro.baojia = decimal.Parse(p_price); pro.CarColor = p_color; pro.LiCheng = decimal.Parse(p_kilometre); pro.PaiLiang = p_gas; pro.country = p_country; pro.BianShuQi = p_transmission; pro.RanYou = p_fuel; pro.Remark = p_details; pro.PaiFangBiaoZhun = p_emissionstandards; pro.SellerName = seller; pro.SellerPhone = sellerphone; pro.SellerName = proNum.Split(' ')[0]; pro.CarSellAddress = selleradress; new CarDetialInfoDb().AddCarinfo(pro); }
public CarDetialInfo GetCarDetial(string TerNo) { CarDetialInfo cdi = _iCarInfoDao.GetCarDetial(TerNo); return(cdi); }
private void addCar(int id = 0) { ///static/carImg/load var p_sort = Request.Form["p_sort"]; var p_brand = Request.Form["p_brand"]; var p_brandName = ""; var probrand = new BandInfoDb().getBrandByKey(p_brand); if (probrand != null) { p_brandName = probrand.BrandName; } var p_name = HttpUtility.UrlDecode(Request.Form["p_name"]); var uptype = Request.Form["uptype"]; var pic = Request.Form["imgs"]; var piclist = pic.Split(','); var priallimg = ""; foreach (var tempimg in piclist) { priallimg = priallimg + string.Format("/carimg/small/{0}.jpg;", pic); } var mainpic = Request.Form["p_mainpic"]; var p_color = Request.Form["p_color"]; var p_price = Request.Form["p_price"]; var isfixprice = Request.Form["isfixprice"]; var p_year = Request.Form["p_year"]; var p_month = Request.Form["p_month"]; var p_kilometre = Request.Form["p_kilometre"]; var p_gas = Request.Form["p_gas"]; var p_country = Request.Form["p_country"]; var p_transmission = Request.Form["p_transmission"]; var p_emissionstandards = Request.Form["p_emissionstandards"]; var p_fuel = Request.Form["p_fuel"]; var p_details = Request.Form["p_details"]; var p_img = Request.Form[""]; var ac = Request.Form["ac"]; var pstate = Request.Form["pstate"]; var page = Request.Form["page"]; var subbrand2 = Request.Form["p_subbrand"]; string subbrandName = ""; var prosubbrand = new BandInfoDb().getBrandByKey(subbrand2); if (prosubbrand != null) { subbrandName = prosubbrand.BrandName; } CarDetialInfo pro = new CarDetialInfo(); pro.Id = id; pro.CarType = p_sort; pro.BrandInfo = p_brandName; pro.BrandInfoKey = p_brand; pro.BrandType = subbrandName; pro.BrandTypeKey = subbrand2; pro.OtherParam = p_name; pro.ShangPaiTime = p_year + "-" + p_month; pro.ShangPaiYear = int.Parse(p_year); pro.ShangPaiMonth = int.Parse(p_month); pro.Images = priallimg; pro.mianimg = mainpic; pro.baojia = decimal.Parse(p_price); pro.CarColor = p_color; pro.LiCheng = p_kilometre; pro.PaiLiang = p_gas; pro.country = p_country; pro.BianShuQi = p_transmission; pro.RanYou = p_fuel; pro.Remark = p_details; pro.ProTitle = pro.BrandInfo + " " + pro.BrandType + " " + pro.OtherParam; pro.PaiFangBiaoZhun = p_emissionstandards; if (Session["userid"] == null) { Response.Redirect("Login.aspx"); return; } string shopid = Session["userid"].ToString(); var shopinfo = new ShopInfoDb().getShopinfo(int.Parse(shopid)); if (shopid != null) { pro.SellerName = shopinfo.CompanyName; pro.SellerNumber = shopinfo.ShopNum; pro.SellerPhone = shopinfo.PhoneNumber; pro.CarSellAddress = shopinfo.CompanyAddress; } new CarDetialInfoDb().AddCarinfo(pro); Response.Redirect("UserCarList.aspx"); }