/// <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);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.HoneyInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HoneyInfo(");
strSql.Append("spidername,server,port,user,password,DBname,sqltype)");
strSql.Append(" values (");
string values = "'" + model.spidername + "','" + model.server + "','" + model.port + "','" + model.user + "','" + model.password + "','" + model.dbname + "','" + model.sqltype + "')";
strSql.Append(values);
int rows = mshelper.InsertSQl(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新
/// </summary>
public bool Update(Model.HoneyInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.HoneyInfo model)
{
return(dal.Add(model));
}
