/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Model.BlogUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [User] set ");
strSql.Append("[Name]='" + model.Name + "',");
strSql.Append("sex='" + model.sex + "',");
strSql.Append("Birthday='" + model.Birthday + "',");
strSql.Append("Fristaddress='" + model.Fristaddress + "',");
strSql.Append("Secondaddress='" + model.Secondaddress + "',");
strSql.Append("Email='" + model.Email + "'");
strSql.Append(" where ID=" + model.ID + " ");
SQLHelper.ExecuteNonQuery(strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.BlogUser GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" ID,User,Pwd,Name,Img,sex,Birthday,Fristaddress,Secondaddress,Email,date ");
strSql.Append(" from User ");
strSql.Append(" where ID=" + ID + " ");
using (IDataReader dataReader = SQLHelper.ExecuteReader(strSql.ToString()))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.BlogUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into User(");
strSql.Append("User,Pwd,Name,Img,sex,Birthday,Fristaddress,Secondaddress,Email");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'" + model.User + "',");
strSql.Append("'" + model.Pwd + "',");
strSql.Append("'" + model.Name + "',");
strSql.Append("'" + model.Img + "',");
strSql.Append("'" + model.sex + "',");
strSql.Append("'" + model.Birthday + "',");
strSql.Append("'" + model.Fristaddress + "',");
strSql.Append("'" + model.Secondaddress + "',");
strSql.Append("'" + model.Email + "'");
strSql.Append(")");
SQLHelper.ExecuteNonQuery(strSql.ToString());
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Model.BlogUser model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.BlogUser model)
{
dal.Add(model);
}
