public int SavetoDb(string url)
{
ecar_content model = new ecar_content();
string source = HtmlHandle.HtmlCode(url);
string data = source.Replace("\n", "").Replace(" ", "").Replace("\r", "");
#region//绑定数据
model.title = title.Match(data).Groups[1].Value;
if (model.title == "")
{
model.title = "微口碑";
}
model.url = url;
model.type = type.Match(data).Groups[1].Value;
model.car = car.Match(data).Groups[1].Value;
model.malladdr = address.Match(data).Groups[1].Value;
model.buydata = buydate.Match(data).Groups[1].Value;
model.price = price.Match(data).Groups[1].Value;
model.oil = oil.Match(data).Groups[1].Value;
model.satisfied = satisfied.Match(data).Groups[1].Value;
model.unsatisfied = unsatisfied.Match(data).Groups[1].Value;
//具体内容
model.oil_star = oilItem.Match(data).Groups[1].Value;
model.oil_sum = oilItem.Match(data).Groups[2].Value;
model.operation_star = operationItem.Match(data).Groups[1].Value;
model.operation = operationItem.Match(data).Groups[2].Value;
model.power_star = powerItem.Match(data).Groups[1].Value;
model.power = powerItem.Match(data).Groups[2].Value;
model.space_star = spaceItem.Match(data).Groups[1].Value;
model.space = spaceItem.Match(data).Groups[2].Value;
if (model.title == "微口碑")
{
model.synthetical_star = syntheticalItem_wkb.Match(data).Groups[1].Value;
model.synthetical = syntheticalItem_wkb.Match(data).Groups[2].Value;
}
else
{
model.synthetical_star = syntheticalItem.Match(data).Groups[1].Value;
model.synthetical = syntheticalItem.Match(data).Groups[2].Value;
}
model.appearance_star = appearanceItem.Match(data).Groups[1].Value;
model.appearance = appearanceItem.Match(data).Groups[2].Value;
model.comfort_star = comfortItem.Match(data).Groups[1].Value;
model.comfort = comfortItem.Match(data).Groups[2].Value;
model.config_star = configItem.Match(data).Groups[1].Value;
model.config = configItem.Match(data).Groups[2].Value;
model.costperfor_star = costperforItem.Match(data).Groups[1].Value;
model.costperfor = costperforItem.Match(data).Groups[2].Value;
model.inside_star = insideItem.Match(data).Groups[1].Value;
model.inside = insideItem.Match(data).Groups[2].Value;
#endregion
return(0);//new Ecar_koubei_Dal().Save(model);//具体存储
}
/// <summary>
/// 保存口碑具体数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Save(ecar_content model)
{
string sql = "insert into Ecar_Koubei (url,title,type,buydata,malladdr,price,oil,satisfied,unsatisfied,operation_star,operation,costperfor_star,costperfor,config_star,config,comfort_star,comfort,space_star,space,power_star,power,appearance_star,appearance,inside_star,inside,synthetical_star,synthetical,Car,oil_star,oil_sumy)values(@url,@title,@type,@buydata,@malladdr,@price,@oil,@satisfied,@unsatisfied,@operation_star,@operation,@costperfor_star,@costperfor,@config_star,@config,@comfort_star,@comfort,@space_star,@space,@power_star,@power,@appearance_star,@appearance,@inside_star,@inside,@synthetical_star,@synthetical,@Car,@oil_star,@oil_sumy);";
SqlParameter[] pars = new SqlParameter[] {
new SqlParameter("@url", model.url),
new SqlParameter("@title", model.title),
new SqlParameter("@type", model.type),
new SqlParameter("@buydata", model.buydata),
new SqlParameter("@malladdr", model.malladdr),
new SqlParameter("@price", model.price),
new SqlParameter("@oil", model.oil),
new SqlParameter("@satisfied", model.satisfied),
new SqlParameter("@unsatisfied", model.unsatisfied),
new SqlParameter("@operation_star", model.operation_star),
new SqlParameter("@operation", model.operation),
new SqlParameter("@costperfor_star", model.costperfor_star),
new SqlParameter("@costperfor", model.costperfor),
new SqlParameter("@config_star", model.config_star),
new SqlParameter("@config", model.config),
new SqlParameter("@comfort_star", model.comfort_star),
new SqlParameter("@comfort", model.comfort),
new SqlParameter("@space_star", model.space_star),
new SqlParameter("@space", model.space),
new SqlParameter("@power_star", model.power_star),
new SqlParameter("@power", model.power),
new SqlParameter("@appearance_star", model.appearance_star),
new SqlParameter("@appearance", model.appearance),
new SqlParameter("@inside_star", model.inside_star),
new SqlParameter("@inside", model.inside),
new SqlParameter("@synthetical_star", model.synthetical_star),
new SqlParameter("@synthetical", model.synthetical),
new SqlParameter("@Car", model.car),
new SqlParameter("@oil_star", model.oil_star),
new SqlParameter("@oil_sumy", model.oil_sum)
};
return(BLL.ExecuteNonQuery(sql, pars));
}
private string GetList(string url)
{
#region//具体业务代码
string showdata = "";
string source = HtmlHandle.HtmlCode(url);
if (source != "")
{
string data = source.Replace("\n", "").Replace(" ", "").Replace("\r", "");
ecar_content model = new ecar_content();
#region//model赋值
model.url = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(url));
model.title = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(title));
model.car = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(car));
model.type = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(type));
model.buydata = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(buydata));
model.malladdr = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(malladdr));//购车地址
model.price = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(price));
model.oil = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(oil));
model.oil_sum = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(oil_sum)); //
model.operation = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(operation)); //操控
model.costperfor = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(costperfor)); //性价比
model.config = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(config));
model.comfort = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(comfort)); //舒适度
model.space = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(space)); //
model.power = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(power)); //
model.appearance = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(appearance));
model.inside = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(inside));
model.synthetical = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(synthetical)); //综合
model.wsynthetical = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(wsynthetical)); //综合
model.oil_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(oil_star));
model.operation_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(operation_star)); //操控
model.costperfor_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(costperfor_star)); //性价比
model.config_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(config_star));
model.comfort_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(comfort_star)); //舒适度
model.space_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(space_star)); //
model.power_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(power_star)); //
model.appearance_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(appearance_star));
model.inside_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(inside_star));
model.synthetical_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(synthetical_star)); //综合
model.wsynthetical_star = RegexBLL.One_Match(data, RegexBLL.GenerateRegex(wsynthetical_star)); //综合
#endregion
#region//数据展示
showdata = "链接：" + model.url + "<br/>" +
"标题：" + model.title + "<br/>" +
"车型：" + model.car + "<br/>" +
"类型：" + model.type + "<br/>" +
"购车日期：" + model.buydata + "<br/>" +
"购车地址：" + model.malladdr + "<br/>" +//购车地址
"购车价格：" + model.price + "<br/>" +
"油耗：" + model.oil + "<br/>" +
"油耗评价：" + model.oil_sum + "<br/>" + //
"油耗评分：" + model.operation + "<br/>" + //操控
"性价比评价：" + model.costperfor + "<br/>" + //性价比
"配置评价：" + model.config + "<br/>" +
"舒适度评价：" + model.comfort + "<br/>" + //舒适度
"空间评价：" + model.space + "<br/>" + //
"动力评价：" + model.power + "<br/>" + //
"外观评价：" + model.appearance + "<br/>" +
"内饰评价：" + model.inside + "<br/>" +
"综合评价：" + model.synthetical + "<br/>" + //综合
"微口碑评价：" + model.wsynthetical + "<br/>" + //综合
"油耗评分：" + model.oil_star + "<br/>" +
"操控评分：" + model.operation_star + "<br/>" + //操控
"性价比评分：" + model.costperfor_star + "<br/>" + //性价比
"配置评分：" + model.config_star + "<br/>" +
"舒适度评分：" + model.comfort_star + "<br/>" + //舒适度
"空间评分：" + model.space_star + "<br/>" + //
"动力评分：" + model.power_star + "<br/>" + //
"外观评分：" + model.appearance_star + "<br/>" +
"内饰评分：" + model.inside_star + "<br/>" +
"综合评分：" + model.synthetical_star + "<br/>" +//综合
"微口碑评分：" + model.wsynthetical_star + "<br/>";
#endregion
}
#endregion
return(showdata);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["url"] != "")
{
url = Request["url"].Trim().ToString();
}
string source = HtmlHandle.HtmlCode(url);
if (source != "")
{
string data = source.Replace("\n", "").Replace(" ", "").Replace("\r", "");
ecar_content model = new ecar_content();
model.car = BLL.One_Match(data, Rule.car);
model.title = BLL.One_Match(data, Rule.title);
model.type = BLL.One_Match(data, Rule.type);
model.malladdr = BLL.One_Match(data, Rule.address);
model.buydata = BLL.One_Match(data, Rule.buydate);
model.price = BLL.One_Match(data, Rule.price);
model.oil = BLL.One_Match(data, Rule.oil);
model.satisfied = BLL.One_Match(data, Rule.satisfied);
model.unsatisfied = BLL.One_Match(data, Rule.unsatisfied);
MatchCollection oilItem = BLL.Matchs(data, Rule.oilItem);
foreach (Match m in oilItem)
{
model.oil_star = m.Groups[1].Value;
model.oil_sum = m.Groups[2].Value;
}
MatchCollection operationItem = BLL.Matchs(data, Rule.operationItem);
foreach (Match m in operationItem)
{
model.operation_star = m.Groups[1].Value;
model.operation = m.Groups[2].Value;
}
MatchCollection costperforItem = BLL.Matchs(data, Rule.costperforItem);
foreach (Match m in costperforItem)
{
model.costperfor_star = m.Groups[1].Value;
model.costperfor = m.Groups[2].Value;
}
MatchCollection configItem = BLL.Matchs(data, Rule.configItem);
foreach (Match m in configItem)
{
model.config = m.Groups[1].Value;
model.config_star = m.Groups[2].Value;
}
MatchCollection comfortItem = BLL.Matchs(data, Rule.comfortItem);
foreach (Match m in comfortItem)
{
model.comfort = m.Groups[1].Value;
model.comfort_star = m.Groups[2].Value;
}
MatchCollection spaceItem = BLL.Matchs(data, Rule.spaceItem);
foreach (Match m in spaceItem)
{
model.space_star = m.Groups[1].Value;
model.space = m.Groups[2].Value;
}
MatchCollection powerItem = BLL.Matchs(data, Rule.powerItem);
foreach (Match m in powerItem)
{
model.operation_star = m.Groups[1].Value;
model.operation = m.Groups[2].Value;
}
MatchCollection appearanceItem = BLL.Matchs(data, Rule.appearanceItem);
foreach (Match m in appearanceItem)
{
model.appearance_star = m.Groups[1].Value;
model.appearance = m.Groups[2].Value;
}
MatchCollection insideItem = BLL.Matchs(data, Rule.insideItem);
foreach (Match m in insideItem)
{
model.inside_star = m.Groups[1].Value;
model.inside = m.Groups[2].Value;
}
MatchCollection syntheticalItem = BLL.Matchs(data, Rule.syntheticalItem);
foreach (Match m in syntheticalItem)
{
model.synthetical_star = m.Groups[1].Value;
model.synthetical = m.Groups[2].Value;
}
string showdata = model.car + "/r/n" + model.url + "/r/n" + model.title + "/r/n" +
model.type + "/r/n" + model.malladdr + "/r/n" + model.buydata + model.price + "/r/n" + model.oil + "/r/n" + model.satisfied + "\n" + model.unsatisfied;
Response.Write(showdata);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["url"] != "")
{
url = Request["url"].Trim().ToString();
}
if (Request["series"] != "")
{
series = Request["series"].Trim().ToString();
}
string source = HtmlHandle.HtmlCode(url);
if (source != "")
{
#region//数据获取
string data = source.Replace("\n", "").Replace(" ", "").Replace("\r", "");
ecar_content model = new ecar_content();
model.car = BLL.One_Match(data, Rule.car);
model.title = BLL.One_Match(data, Rule.title);
model.type = BLL.One_Match(data, Rule.type);
model.malladdr = BLL.One_Match(data, Rule.address);
model.buydata = BLL.One_Match(data, Rule.buydate);
model.price = BLL.One_Match(data, Rule.price);
model.oil = BLL.One_Match(data, Rule.oil);
model.satisfied = BLL.One_Match(data, Rule.satisfied);
model.unsatisfied = BLL.One_Match(data, Rule.unsatisfied);
MatchCollection oilItem = BLL.Matchs(data, Rule.oilItem);
foreach (Match m in oilItem)
{
model.oil_star = m.Groups[1].Value;
model.oil_sum = m.Groups[2].Value;
}
MatchCollection operationItem = BLL.Matchs(data, Rule.operationItem);
foreach (Match m in operationItem)
{
model.operation_star = m.Groups[1].Value;
model.operation = m.Groups[2].Value;
}
MatchCollection costperforItem = BLL.Matchs(data, Rule.costperforItem);
foreach (Match m in costperforItem)
{
model.costperfor_star = m.Groups[1].Value;
model.costperfor = m.Groups[2].Value;
}
MatchCollection configItem = BLL.Matchs(data, Rule.configItem);
foreach (Match m in configItem)
{
model.config_star = m.Groups[1].Value;
model.config = m.Groups[2].Value;
}
MatchCollection comfortItem = BLL.Matchs(data, Rule.comfortItem);
foreach (Match m in comfortItem)
{
model.comfort_star = m.Groups[1].Value;
model.comfort = m.Groups[2].Value;
}
MatchCollection spaceItem = BLL.Matchs(data, Rule.spaceItem);
foreach (Match m in spaceItem)
{
model.space_star = m.Groups[1].Value;
model.space = m.Groups[2].Value;
}
MatchCollection powerItem = BLL.Matchs(data, Rule.powerItem);
foreach (Match m in powerItem)
{
model.operation_star = m.Groups[1].Value;
model.operation = m.Groups[2].Value;
}
MatchCollection appearanceItem = BLL.Matchs(data, Rule.appearanceItem);
foreach (Match m in appearanceItem)
{
model.appearance_star = m.Groups[1].Value;
model.appearance = m.Groups[2].Value;
}
MatchCollection insideItem = BLL.Matchs(data, Rule.insideItem);
foreach (Match m in insideItem)
{
model.inside_star = m.Groups[1].Value;
model.inside = m.Groups[2].Value;
}
MatchCollection syntheticalItem = BLL.Matchs(data, Rule.syntheticalItem);
foreach (Match m in syntheticalItem)
{
model.synthetical_star = m.Groups[1].Value;
model.synthetical = Regex.Replace(m.Groups[2].Value.ToString(), "<[\\S\\s]*?>", "").ToString();
}
#endregion
#region//绑定
lbl_car.InnerText = series + model.car + model.type;
txt_title.Value = model.title;
txt_buydate.Value = model.buydata;
txt_buyprice.Value = model.price;
txt_car_oil.Value = model.oil;
txt_oil_summary.Value = model.oil_sum;
txt_inside_summary.Value = model.inside;
txt_drive_summary.Value = model.operation;
txt_config_summary.Value = model.config;
txt_comfort_summary.Value = model.comfort;
txt_cost_summary.Value = model.costperfor;
txt_power_summary.Value = model.power;
txt_appearance_summary.Value = model.appearance;
txt_space_summary.Value = model.space;
txt_all_summary.Value = model.synthetical;
//type = model.type;//
allstar = model.synthetical_star;
powerstar = model.power_star;
oilstar = model.oil_star;
drivestar = model.operation_star;
configstar = model.config_star;
coststar = model.costperfor_star;
comfortstar = model.comfort_star;
apperstar = model.appearance_star;
spacestar = model.space_star;
insidestar = model.inside_star;
#endregion
rep_type.DataSource = T_BLL.Get_ALL();
rep_type.DataBind();
}
}
