/// <summary>
/// 根据蘑菇街列表页面采集商品信息
/// </summary>
/// <param name="urls">列表页网址</param>
/// <param name="type">采集类型 1为单肩包列表页 2为双肩包列表页 </param>
/// <param name="webBrowser1">谷歌浏览器</param>
public static List <aotunew_title> caiji_listpage(string urls, string type, ChromiumWebBrowser webBrowser1)
{
List <aotunew_title> list = new List <aotunew_title>();
//单肩包综合页面
webBrowser1.Load(urls);
try
{
if (Browser.WaitWebPageLoad(webBrowser1))
{
//商品数量iwf goods_item
string temp = Browser.JS_CEFBrowser("getClassName('goods_item').length", webBrowser1);
int count = 0;
if (int.TryParse(temp, out count))
{
List <string> list_str = new List <string>();
for (int i = 0; i < count; i++)
{
string url = Browser.JS_CEFBrowser("getClassName('goods_item')[" + i + "].getElementsByTagName('a')[1].href;", webBrowser1);
list_str.Add(url);
}
foreach (string url in list_str)
{
webBrowser1.Load(url);
if (Browser.WaitWebPageLoad(webBrowser1))
{
string title = Browser.JS_CEFBrowser(" getClassName('goods-title')[0].innerText; ", webBrowser1);
string price = Browser.JS_CEFBrowser(" document.getElementById('J_NowPrice').innerText; ", webBrowser1);
string sells = Browser.JS_CEFBrowser(" getClassName('num J_SaleNum')[0].innerText; ", webBrowser1);
string likes = Browser.JS_CEFBrowser(" getClassName('fav-num')[0].innerText; ", webBrowser1);
string jianshu = Browser.JS_CEFBrowser(" getClassName('graphic-text')[0].innerText; ", webBrowser1);
string dpname = Browser.JS_CEFBrowser(" getClassName('name-wrap')[0].getElementsByTagName('a')[0].title ; ", webBrowser1);
aotunew_title at = new aotunew_title();
at.atdate = DateTime.Now;
at.atjieshao = jianshu;
at.atlike = likes;
at.atprice = price;
at.atsell = sells;
at.aturl = url;
at.attype1 = type;
at.atremark1 = dpname;
at.attitle = title;
list.Add(at);
//BLL2.aotunew_titleManager.Insert(at);
}
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine("采集蘑菇街列表页信息失败：" + ex.ToString());
Debug.WriteLine("网址：" + urls);
Debug.WriteLine(ex.ToString());
}
return(list);
}
/// <summary>
/// 查询全部数据
/// </summary>
/// <returns>IList</returns>
/*查看是否为视图*/
public IList <aotunew_title> SearchAll()
{
DBHelper.sqlstr = "select * from aotunew_title ";
List <aotunew_title> list = new List <aotunew_title>();
MySqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
aotunew_title Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 根据atid,查询一条数据
/// </summary>
/// <param name="atid">编号</param>
/// <returns></returns>
/*查看是否为视图*/
public aotunew_title SearchByID(int atid)
{
DBHelper.sqlstr = "select * from aotunew_title where atid = @atid";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@atid", atid)
};
MySqlDataReader reader = DBHelper.ExecuteReader(param);
aotunew_title Obj = null;
if (reader.Read())
{
Obj = GetByReader(reader);
}
reader.Close();
return(Obj);
}
/// <summary>
/// 从一个MySqlDataReader里读数据
/// </summary>
/// <param name="Reader">MySqlDataReader</param>
/// <returns>aotunew_titleExample</returns>
public static aotunew_title GetByReader(MySqlDataReader Reader)
{
aotunew_title aotunew_titleExample = new aotunew_title();
aotunew_titleExample.atid = Reader["atid"] == DBNull.Value ? 0 : (int)Reader["atid"];
aotunew_titleExample.attitle = Reader["attitle"] == DBNull.Value ? null : Reader["attitle"].ToString();
aotunew_titleExample.atjieshao = Reader["atjieshao"] == DBNull.Value ? null : Reader["atjieshao"].ToString();
aotunew_titleExample.attype1 = Reader["attype1"] == DBNull.Value ? null : Reader["attype1"].ToString();
aotunew_titleExample.attype2 = Reader["attype2"] == DBNull.Value ? null : Reader["attype2"].ToString();
aotunew_titleExample.atremark1 = Reader["atremark1"] == DBNull.Value ? null : Reader["atremark1"].ToString();
aotunew_titleExample.atremark2 = Reader["atremark2"] == DBNull.Value ? null : Reader["atremark2"].ToString();
aotunew_titleExample.atdate = Reader["atdate"] == DBNull.Value ? new DateTime() : Convert.ToDateTime(Reader["atdate"]);
aotunew_titleExample.atprice = Reader["atprice"] == DBNull.Value ? null : Reader["atprice"].ToString();
aotunew_titleExample.atsell = Reader["atsell"] == DBNull.Value ? null : Reader["atsell"].ToString();
aotunew_titleExample.aturl = Reader["aturl"] == DBNull.Value ? null : Reader["aturl"].ToString();
aotunew_titleExample.atlike = Reader["atlike"] == DBNull.Value ? null : Reader["atlike"].ToString();
return(aotunew_titleExample);
}
/// <summary>
/// 条件搜索
/// </summary>
/// <param name="s">起始位置</param>
/// <param name="e">结束位置</param>
/// <param name="key">关键词</param>
/// <param name="gt">商品类型</param>
/// <param name="state">状态 空:不查,1:启用,2:禁用</param>
/// <param name="dt1_add">添加起始时间</param>
/// <param name="dt2_add">添加结束时间</param>
/// <param name="orderby">排序方式,直接输入order by后面的语句</param>
/// <returns>IList<yh_zaoci></returns>
public IList <aotunew_title> Search(int s, int e, string key, string type1, string type2, DateTime dt1_add, DateTime dt2_add, string orderby)
{
string sql1 = "select top " + (e - s + 1).ToString() + " * from aotunew_title where ";
string sql2 = string.IsNullOrEmpty(key) ? " 1=1 " : " ( attitle like '%" + key + "%' or atjieshao like '%" + key + "%' or atremark1 like '%" + key + "%' or atremark2 like '%" + key + "%' or atprice like '%" + key + "%' or atsell like '%" + key + "%' or aturl like '%" + key + "%' or atlike like '%" + key + "%' ) ";
string sql3 = string.IsNullOrEmpty(type1) ? "" : " and attype1=" + type1;
string sql4 = string.IsNullOrEmpty(type2) ? "" : " and attype2= '" + type2 + "' ";
string sql5 = dt1_add == new DateTime() ? "" : " and datediff(d,'" + dt1_add.ToString("yyyy-MM-dd") + "',atdate)>=0 ";
string sql6 = dt2_add == new DateTime() ? "" : " and datediff(d,'" + dt2_add.ToString("yyyy-MM-dd") + "',atdate)<=0 ";
string sql8 = string.IsNullOrEmpty(orderby) ? " order by atdate desc " : " order by " + orderby;
string sql7 = s == 1 ? "" : " and atid not in ( select top " + (s - 1).ToString() + " atid from aotunew_title where " + sql2 + sql3 + sql4 + sql5 + sql6 + sql8 + " ) ";
DBHelper.sqlstr = sql1 + sql2 + sql3 + sql4 + sql5 + sql6 + sql7 + sql8;
List <aotunew_title> list = new List <aotunew_title>();
SqlDataReader reader = DBHelper.ExecuteReader();
while (reader.Read())
{
aotunew_title Obj = GetByReader(reader);
list.Add(Obj);
}
reader.Close();
return(list);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="aotunew_title">aotunew_title表实例</param>
/// <returns>int</returns>
public int Update(aotunew_title aotunew_titleExample)
{
DBHelper.sqlstr = "update aotunew_title set attitle=@attitle,atjieshao=@atjieshao,attype1=@attype1,attype2=@attype2,atremark1=@atremark1,atremark2=@atremark2,atdate=@atdate,atprice=@atprice,atsell=@atsell,aturl=@aturl,atlike=@atlike where atid=" + aotunew_titleExample.atid;
return(DBHelper.ExecuteNonQuery(GetSqlParameters(aotunew_titleExample)));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="aotunew_title">aotunew_title表实例</param>
/// <returns>int</returns>
public int Insert(aotunew_title aotunew_titleExample)
{
DBHelper.sqlstr = "insert into aotunew_title (attitle,atjieshao,attype1,attype2,atremark1,atremark2,atdate,atprice,atsell,aturl,atlike)values(@attitle,@atjieshao,@attype1,@attype2,@atremark1,@atremark2,@atdate,@atprice,@atsell,@aturl,@atlike)";
return(DBHelper.ExecuteNonQuery(GetSqlParameters(aotunew_titleExample)));
}
/// <summary>
/// 根据表,获取一个MySqlParameter数组
/// </summary>
/// <returns>MySqlParameter[]</returns>
public static MySqlParameter[] GetSqlParameters(aotunew_title aotunew_titleExample)
{
List <MySqlParameter> list_param = new List <MySqlParameter>();
if (!string.IsNullOrEmpty(aotunew_titleExample.attitle))
{
list_param.Add(new MySqlParameter("@attitle", aotunew_titleExample.attitle));
}
else
{
list_param.Add(new MySqlParameter("@attitle", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.atjieshao))
{
list_param.Add(new MySqlParameter("@atjieshao", aotunew_titleExample.atjieshao));
}
else
{
list_param.Add(new MySqlParameter("@atjieshao", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.attype1))
{
list_param.Add(new MySqlParameter("@attype1", aotunew_titleExample.attype1));
}
else
{
list_param.Add(new MySqlParameter("@attype1", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.attype2))
{
list_param.Add(new MySqlParameter("@attype2", aotunew_titleExample.attype2));
}
else
{
list_param.Add(new MySqlParameter("@attype2", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.atremark1))
{
list_param.Add(new MySqlParameter("@atremark1", aotunew_titleExample.atremark1));
}
else
{
list_param.Add(new MySqlParameter("@atremark1", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.atremark2))
{
list_param.Add(new MySqlParameter("@atremark2", aotunew_titleExample.atremark2));
}
else
{
list_param.Add(new MySqlParameter("@atremark2", DBNull.Value));
}
if (aotunew_titleExample.atdate != new DateTime() && aotunew_titleExample.atdate != null)
{
list_param.Add(new MySqlParameter("@atdate", aotunew_titleExample.atdate.ToString("yyyy-MM-dd")));
}
else
{
list_param.Add(new MySqlParameter("@atdate", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.atprice))
{
list_param.Add(new MySqlParameter("@atprice", aotunew_titleExample.atprice));
}
else
{
list_param.Add(new MySqlParameter("@atprice", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.atsell))
{
list_param.Add(new MySqlParameter("@atsell", aotunew_titleExample.atsell));
}
else
{
list_param.Add(new MySqlParameter("@atsell", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.aturl))
{
list_param.Add(new MySqlParameter("@aturl", aotunew_titleExample.aturl));
}
else
{
list_param.Add(new MySqlParameter("@aturl", DBNull.Value));
}
if (!string.IsNullOrEmpty(aotunew_titleExample.atlike))
{
list_param.Add(new MySqlParameter("@atlike", aotunew_titleExample.atlike));
}
else
{
list_param.Add(new MySqlParameter("@atlike", DBNull.Value));
}
MySqlParameter[] param = new MySqlParameter[list_param.Count];
int index = 0;
foreach (MySqlParameter p in list_param)
{
param[index] = p;
index++;
}
return(param);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="aotunew_title">aotunew_title表实例</param>
/// <returns>int</returns>
public static int Update(aotunew_title aotunew_titleExample)
{
return(Service.Update(aotunew_titleExample));
}
/// <summary>
/// 插入方法
/// </summary>
/// <param name="aotunew_title">aotunew_title表实例</param>
/// <returns>int</returns>
public static int Insert(aotunew_title aotunew_titleExample)
{
return(Service.Insert(aotunew_titleExample));
}
