/// <summary>
/// 添加管理员
/// </summary>
/// <param name="model">后台用户实体类</param>
/// <returns>添加成功返回ID</returns>
public override int AddAdmin(AdminInfo model)
{
SerializerData data = model.GetSerializerData();
string sql = @"
INSERT INTO ComOpp_AdminUser(UserName,Password,Administrator,LastLoginIP,LastLoginTime,[PropertyNames],[PropertyValues],[UserRole],[PowerGroupID])
VALUES (@UserName,@Password,@Administrator,@LastLoginIP,@LastLoginTime,@PropertyNames,@PropertyValues,@UserRole,@PowerGroupID)
;SELECT @@IDENTITY";
SqlParameter[] p =
{
new SqlParameter("@UserName",model.UserName),
new SqlParameter("@Password",model.Password),
new SqlParameter("@Administrator",model.Administrator),
new SqlParameter("@LastLoginIP",model.LastLoginIP),
new SqlParameter("@LastLoginTime",model.LastLoginTime),
new SqlParameter("@UserRole",model.UserRole),
new SqlParameter("@PowerGroupID",model.PowerGroupID),
new SqlParameter("@PropertyNames",data.Keys),
new SqlParameter("@PropertyValues",data.Values)
};
model.ID = DataConvert.SafeInt(SqlHelper.ExecuteScalar(_con, CommandType.Text, sql, p));
return model.ID;
}
/// <summary>
/// 更新管理员
/// </summary>
/// <param name="model">后台用户实体类</param>
/// <returns>修改是否成功</returns>
public override bool UpdateAdmin(AdminInfo model)
{
SerializerData data = model.GetSerializerData();
string sql = @"UPDATE ComOpp_AdminUser SET
UserName = @UserName
,Password = @Password
,Administrator = @Administrator
,LastLoginIP = @LastLoginIP
,LastLoginTime = @LastLoginTime
,UserRole = @UserRole
,PowerGroupID = @PowerGroupID
,[PropertyNames] = @PropertyNames
,[PropertyValues] = @PropertyValues
WHERE ID = @ID
";
SqlParameter[] p =
{
new SqlParameter("@UserName",model.UserName),
new SqlParameter("@Password",model.Password),
new SqlParameter("@Administrator",model.Administrator),
new SqlParameter("@LastLoginIP",model.LastLoginIP),
new SqlParameter("@LastLoginTime",model.LastLoginTime),
new SqlParameter("@UserRole",(int)model.UserRole),
new SqlParameter("@PowerGroupID",model.PowerGroupID),
new SqlParameter("@PropertyNames",data.Keys),
new SqlParameter("@PropertyValues",data.Values),
new SqlParameter("@ID",model.ID)
};
int result = SqlHelper.ExecuteNonQuery(_con, CommandType.Text, sql, p);
if (result > 0)
{
return true;
}
return false;
}
