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