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