/// <summary>
/// 更新状态
/// </summary>
public bool UpdateStatus(string spiderName, string Status)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Mission set ");
strSql.Append("status='" + Status + "'");
strSql.Append(" where spidername='" + spiderName + "'");
int rows = mshelper.UpdateSQl(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.SpiderInfo model)
{
string startUrl = model.start_urls;
string loginUrl = model.login_url;
string customData = model.customdata;
string ruleData = model.ruledatas;
if (startUrl != "")
{
startUrl = model.start_urls.Replace(@"'", @"\'");
}
if (loginUrl != null)
{
loginUrl = model.login_url.Replace(@"'", @"\'");
}
if (customData != "")
{
customData = model.customdata.Replace(@"'", @"\'");
}
if (ruleData != "")
{
ruleData = model.ruledatas.Replace(@"'", @"\'");
}
StringBuilder strSql = new StringBuilder();
strSql.Append("update SpiderInfo set ");
strSql.Append("website='" + model.website + "',files_store='" + model.file_store + "',start_urls=\"" + model.start_urls + "\",allowed_domains='" + model.allowed_domains + "',Rules='" + model.rules + "',class='" + model._class +
"',loader='" + model.loader + "',away='" + model.away + "',login_url=\"" + model.login_url + "\",_account='" + model.account + "',customdata='" + customData + "',cls='" + model.cls + "',ruledatas='" + ruleData + "',cookies='" + model.cookies + "'");
strSql.Append(" where spiderName='" + model.spidername + "'");
int rows = mshelper.UpdateSQl(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.HoneyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HoneyInfo set ");
strSql.Append("server='" + model.server + "',port='" + model.port + "',DBname='" + model.dbname + "',user='******',password='******',sqltype='" + model.sqltype + "'");
strSql.Append(" where spidername='" + model.spidername + "'");
int rows = mshelper.UpdateSQl(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateStatus(string userStatus, string userID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update user set ");
strSql.Append("UserStatus='" + userStatus + "'");
strSql.Append(" where UserID='" + userID + "'");
int rows = mshelper.UpdateSQl(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}