/// <summary> /// 根据主键ID更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>执行结果受影响行数</returns> public int Update(UserStates model) { #region SQL语句 const string sql = @" UPDATE [dbo].[UserStates] SET [Name] = @Name WHERE [Id] = @Id"; #endregion return(SqlHelper.ExecuteNonQuery(sql, new SqlParameter("@Id", model.Id), new SqlParameter("@Name", model.Name) )); }
/// <summary> /// 向数据库中添加一条记录 /// </summary> /// <param name="model">要添加的实体</param> /// <returns>插入数据的ID</returns> public int Insert(UserStates model) { #region SQL语句 const string sql = @" INSERT INTO [dbo].[UserStates] ( [Name] ) VALUES ( @Name );select @@IDENTITY"; #endregion var res = SqlHelper.ExecuteScalar(sql, new SqlParameter("@Name", model.Name) ); return(res == null ? 0 : Convert.ToInt32(res)); }
/// <summary> /// 得到一个对象实体 /// </summary> public BookShop.Model.Users DataRowToModel(DataRow row) { BookShop.Model.Users model = new BookShop.Model.Users(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["LoginId"] != null) { model.LoginId = row["LoginId"].ToString(); } if (row["LoginPwd"] != null) { model.LoginPwd = row["LoginPwd"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["Mail"] != null) { model.Mail = row["Mail"].ToString(); } if (row["UserStateId"] != null && row["UserStateId"].ToString() != "") { DAL.UserStates stateDal = new UserStates(); int Id = int.Parse(row["UserStateId"].ToString()); model.UserStateId = stateDal.GetModel(Id); } } return(model); }
/// <summary> /// 更改会员状态 /// </summary> /// <param name="id"></param> /// <param name="status"></param> public bool ModifyUserState(int id, UserStates state) { string sql = "Update users SET userstateid =" + Convert.ToByte(state) + " WHERE Id = @UserId"; return(SqlHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, new SqlParameter("@UserId", id)) > 0); }