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