protected void Page_Load(object sender, EventArgs e)
{
//if (Session["userid"] == null)
//{
// Response.Redirect("Login.aspx");
//}
if (Request.Form["method"] == "gettask")
{
var id = Request.Form["id"];
var item = new prologDb().GetNextlog(id);
if (item == null)
{
Response.Write("error obj is null");
}
else
{
Response.Write(item.proid);
}
return;
}
if (Request.Form["method"] == "proadd")
{
string json = base.Request.Form["json"];
JToken token = JToken.Parse(json);
if (json.Contains("proid"))
{
List <prolog> item = new List <prolog>();
foreach (JToken token2 in token)
{
prolog prolog = new prolog
{
proid = token2["proid"].Value <string>(),
proName = token2["proname"].Value <string>(),
shopNumber = token2["shopid"].Value <string>().Trim(),
state = 0
};
item.Add(prolog);
}
new prologDb().Addprolog(item);
}
else
{
var proid = token["id"].Value <string>();
var content = token["content"].ToString().Replace("\r", "").Replace("\n", "");
new prologDb().Updateprolog(new prolog {
proid = proid, proName = content, state = 1
});
}
}
}
public void Updateprolog(prolog item)
{
int num = 0;
do
{
try
{
using (IDbConnection connection = _dbFactory.OpenDbConnection())
{
connection.Update <prolog>(new { item.proName, item.state }, p => p.proid == item.proid);
}
break;
}
catch (Exception exception)
{
num++;
Thread.Sleep(0x2710);
LogServer.WriteLog(exception.Message, "DBError");
}
} while (num < 4);
}
public void Addprolog(prolog item)
{
int num = 0;
do
{
try
{
using (IDbConnection connection = _dbFactory.OpenDbConnection())
{
connection.Insert <prolog>(item, false);
}
break;
}
catch (Exception exception)
{
num++;
Thread.Sleep(0x2710);
LogServer.WriteLog(exception.Message, "DBError");
}
} while (num < 4);
}
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);
}
