/// <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); }