//------------------------------------------------------------------------------------------
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity"></param>
public bool Append(User_info entity)
{
string sqlCmd = "insert into mp_user_info (DeptID ,UserLoginName ,UserPassword ,UserName ,IsAdmin ,Description ,CreateTime ,LastModifyTime ,ModifiedUserID ,MobliePhone ,WorkPhone ,Email ,Status ,Address ,Deleted ,Groups ,Level ,MaxCreateNumber ,ExpireTime ,Province ,City ,GroupNames ,MakeRate ,NotMakeRate ,AgentRate ,CreateUser) values (@DeptID ,@UserLoginName ,@UserPassword ,@UserName ,@IsAdmin ,@Description ,@CreateTime ,@LastModifyTime ,@ModifiedUserID ,@MobliePhone ,@WorkPhone ,@Email ,@Status ,@Address ,@Deleted ,@Groups ,@Level ,@MaxCreateNumber ,@ExpireTime ,@Province ,@City ,@GroupNames ,@MakeRate ,@NotMakeRate ,@AgentRate ,@CreateUser);SELECT LAST_INSERT_ID();";
MySqlParameter[] pars = new MySqlParameter[26];
pars[0] = new MySqlParameter("@DeptID",entity.DeptID);
pars[1] = new MySqlParameter("@UserLoginName",entity.UserLoginName);
pars[2] = new MySqlParameter("@UserPassword",entity.UserPassword);
pars[3] = new MySqlParameter("@UserName",entity.UserName);
pars[4] = new MySqlParameter("@IsAdmin",entity.IsAdmin);
pars[5] = new MySqlParameter("@Description",entity.Description);
pars[6] = new MySqlParameter("@CreateTime",entity.CreateTime);
pars[7] = new MySqlParameter("@LastModifyTime",entity.LastModifyTime);
pars[8] = new MySqlParameter("@ModifiedUserID",entity.ModifiedUserID);
pars[9] = new MySqlParameter("@MobliePhone",entity.MobliePhone);
pars[10] = new MySqlParameter("@WorkPhone",entity.WorkPhone);
pars[11] = new MySqlParameter("@Email",entity.Email);
pars[12] = new MySqlParameter("@Status",entity.Status);
pars[13] = new MySqlParameter("@Address",entity.Address);
pars[14] = new MySqlParameter("@Deleted",entity.Deleted);
pars[15] = new MySqlParameter("@Groups",entity.Groups);
pars[16] = new MySqlParameter("@Level",entity.Level);
pars[17] = new MySqlParameter("@MaxCreateNumber",entity.MaxCreateNumber);
pars[18] = new MySqlParameter("@ExpireTime",entity.ExpireTime);
pars[19] = new MySqlParameter("@Province",entity.Province);
pars[20] = new MySqlParameter("@City",entity.City);
pars[21] = new MySqlParameter("@GroupNames",entity.GroupNames);
pars[22] = new MySqlParameter("@MakeRate",entity.MakeRate);
pars[23] = new MySqlParameter("@NotMakeRate",entity.NotMakeRate);
pars[24] = new MySqlParameter("@AgentRate",entity.AgentRate);
pars[25] = new MySqlParameter("@CreateUser",entity.CreateUser);
entity.UserID = Convert.ToInt32(MySqlHelper.ExecuteScalar(CommandType.Text, sqlCmd,pars));
return true;
}
//------------------------------------------------------------------------------------------
/// <summary>
/// 新增一条记录
/// </summary>
/// <param name="entity"></param>
public bool Append(User_info entity)
{
try
{
bool result = _User_infoDal.Append(entity);
ClearCacheData();
return result;
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult SaveAdmin(int? UserID)
{
string backUrl = Url.Action("adminlist");
User_info entity = new User_info();
string[] allowProperty = new string[] { "UserName", "UserLoginName", "Level", "Status", "MobliePhone", "Email", "MaxCreateNumber", "ExpireTime", "Province", "City", "MakeRate", "NotMakeRate" };
PageCommandType type = PageCommandType.增加;
if (UserID.HasValue)
{
type = PageCommandType.更新;
//目前只考虑主键只有一个，且为自增长
entity = User_infoBLL.Current.GetByID(UserID.Value);
}
TryUpdateModel(entity, allowProperty);
entity.LastModifyTime = DateTime.Now;
//end
User_info checkNameStore = User_infoBLL.Current.GetByUserLoginName(entity.UserLoginName);
//验证
if (string.IsNullOrEmpty(entity.UserLoginName))
{
return CommonResult.ShowMessage("登陆名不能为空！", backUrl);
}
var groupsID = DTLRequest.GetRequestIntList("groups").Distinct();
entity.GroupNames = string.Join(",", Role_groupBLL.Current.CacheAllDataList().Where(item => groupsID.Contains(item.GroupID)));
entity.Groups = string.Join(",", groupsID);
entity.GroupNames = string.Join(",", Role_groupBLL.Current.CacheAllDataList().Where(item => entity.UsersGroupsList.Contains(item.GroupID)).Select(item => item.GroupName));
string passwrod = DTLRequest.GetString("UserPassword");
int? createUserID = null;// CurrentUserInfo.CurrentUser.UserID;
//增加操作
if (type == PageCommandType.增加)
{
if (string.IsNullOrEmpty(passwrod))
{
return CommonResult.ShowMessage("登陆密码不能空！", backUrl);
}
if (checkNameStore != null)
{
return CommonResult.ShowMessage("已经存在账号登陆名", backUrl);
}
entity.CreateTime = DateTime.Now;
entity.UserPassword = Utils.MD5(passwrod);
entity.CreateUser = createUserID ?? CurrentUserInfo.CurrentUser.UserID;
if (User_infoBLL.Current.Append(entity))
{
return CommonResult.ShowMessage("增加成功", backUrl);
}
}
else if (type == PageCommandType.更新)
{
if (createUserID.HasValue)
{
entity.CreateUser = createUserID.Value;
}
if (!string.IsNullOrEmpty(passwrod))
{
entity.UserPassword = Utils.MD5(passwrod);
}
if (checkNameStore != null && entity.UserID != checkNameStore.UserID)
{
return CommonResult.ShowMessage("已经存在账号登陆名", backUrl);
}
if (User_infoBLL.Current.Update(entity))
{
return CommonResult.ShowMessage("更新成功", backUrl);
}
}
return CommonResult.ShowMessage("保存失败", backUrl);
}
public void SetUserAuthInfo(User_info userinfo)
{
//设置用户分组
userinfo.UserGroup = Role_groupBLL.Current.CacheAllDataList().Where(item => userinfo.UsersGroupsList.Contains(item.GroupID)).ToList();
//调用用户资源
//先获取去重复的资源ID列表
var resids = new List<int>();
userinfo.UserGroup.ForEach(item => resids.AddRange(item.Auth_ResourceList));
resids = resids.Distinct().ToList();
userinfo.UserResource = Role_resourceBLL.Current.CacheAllDataList().Where(item => resids.Contains(item.ResourceID)).OrderByDescending(item => item.Sort).ToList();
//设置用户actions
var actionIDs = new List<int>();
userinfo.UserGroup.ForEach(item => actionIDs.AddRange(item.Auth_ActionList));
actionIDs = actionIDs.Distinct().ToList();
userinfo.UserAction = Role_actionBLL.Current.CacheAllDataList().Where(item => actionIDs.Contains(item.ActionID)).OrderByDescending(item => item.Sort).ToList();
}
/// <summary>
/// 判断当前用户是否拥有某个功能的权限
/// </summary>
/// <param name="cotrollerName">控制器名</param>
/// <param name="actionName">功能名</param>
/// <returns>如果有权限就返回True，如果相应的控制器不存在，或者已经被禁用，或者无权限则返回False</returns>
public bool HasActionAuth(User_info info, string cotrollerName, string actionName)
{
return info.UserAction.Where(item => item.ControllerName.Equals(cotrollerName, StringComparison.InvariantCultureIgnoreCase) &&
item.ActionName.Equals(actionName, StringComparison.InvariantCultureIgnoreCase) &&
item.Status == 1).FirstOrDefault() != null;
}
//------------------------------------------------------------------------------------------
/// <summary>
/// 把reader转换成Entity
/// </summary>
/// <param name="table">表数据</param>
/// <returns></returns>
private User_info DataReaderToEntity(IDataReader reader)
{
User_info entity= new User_info();
entity.UserID = Convert.ToInt32(reader["UserID"]) ;
entity.DeptID = Convert.ToInt32(reader["DeptID"]) ;
entity.UserLoginName = Convert.ToString(reader["UserLoginName"]) ;
entity.UserPassword = Convert.ToString(reader["UserPassword"]) ;
entity.UserName = Convert.ToString(reader["UserName"]) ;
entity.IsAdmin = Convert.ToString(reader["IsAdmin"]) ;
entity.Description = Convert.ToString(reader["Description"]) ;
entity.CreateTime = Convert.ToDateTime(reader["CreateTime"]) ;
entity.LastModifyTime = Convert.ToDateTime(reader["LastModifyTime"]) ;
entity.ModifiedUserID = Convert.ToString(reader["ModifiedUserID"]) ;
entity.MobliePhone = Convert.ToString(reader["MobliePhone"]) ;
entity.WorkPhone = Convert.ToString(reader["WorkPhone"]) ;
entity.Email = Convert.ToString(reader["Email"]) ;
entity.Status = Convert.ToInt32(reader["Status"]) ;
entity.Address = Convert.ToString(reader["Address"]) ;
entity.Deleted = Convert.ToInt32(reader["Deleted"]) ;
entity.Groups = Convert.ToString(reader["Groups"]) ;
entity.Level = Convert.ToInt32(reader["Level"]) ;
entity.MaxCreateNumber = Convert.ToInt32(reader["MaxCreateNumber"]) ;
entity.ExpireTime = Convert.ToDateTime(reader["ExpireTime"]) ;
entity.Province = Convert.ToString(reader["Province"]) ;
entity.City = Convert.ToString(reader["City"]) ;
entity.GroupNames = Convert.ToString(reader["GroupNames"]) ;
entity.MakeRate = Convert.ToDecimal(reader["MakeRate"]) ;
entity.NotMakeRate = Convert.ToDecimal(reader["NotMakeRate"]) ;
entity.AgentRate = Convert.ToDecimal(reader["AgentRate"]) ;
entity.CreateUser = Convert.ToInt32(reader["CreateUser"]) ;
return entity;
}
//------------------------------------------------------------------------------------------
/// <summary>
/// 更新一条记录
/// </summary>
/// <param name="entity"></param>
public bool Update(User_info entity)
{
string sqlCmd = "update mp_user_info set DeptID = @DeptID, UserLoginName = @UserLoginName, UserPassword = @UserPassword, UserName = @UserName, IsAdmin = @IsAdmin, Description = @Description, CreateTime = @CreateTime, LastModifyTime = @LastModifyTime, ModifiedUserID = @ModifiedUserID, MobliePhone = @MobliePhone, WorkPhone = @WorkPhone, Email = @Email, Status = @Status, Address = @Address, Deleted = @Deleted, Groups = @Groups, Level = @Level, MaxCreateNumber = @MaxCreateNumber, ExpireTime = @ExpireTime, Province = @Province, City = @City, GroupNames = @GroupNames, MakeRate = @MakeRate, NotMakeRate = @NotMakeRate, AgentRate = @AgentRate, CreateUser = @CreateUser where UserID = @UserID ";
MySqlParameter[] pars = new MySqlParameter[27];
pars[0] = new MySqlParameter("@UserID",entity.UserID);
pars[1] = new MySqlParameter("@DeptID",entity.DeptID);
pars[2] = new MySqlParameter("@UserLoginName",entity.UserLoginName);
pars[3] = new MySqlParameter("@UserPassword",entity.UserPassword);
pars[4] = new MySqlParameter("@UserName",entity.UserName);
pars[5] = new MySqlParameter("@IsAdmin",entity.IsAdmin);
pars[6] = new MySqlParameter("@Description",entity.Description);
pars[7] = new MySqlParameter("@CreateTime",entity.CreateTime);
pars[8] = new MySqlParameter("@LastModifyTime",System.DateTime.Now);
pars[9] = new MySqlParameter("@ModifiedUserID",entity.ModifiedUserID);
pars[10] = new MySqlParameter("@MobliePhone",entity.MobliePhone);
pars[11] = new MySqlParameter("@WorkPhone",entity.WorkPhone);
pars[12] = new MySqlParameter("@Email",entity.Email);
pars[13] = new MySqlParameter("@Status",entity.Status);
pars[14] = new MySqlParameter("@Address",entity.Address);
pars[15] = new MySqlParameter("@Deleted",entity.Deleted);
pars[16] = new MySqlParameter("@Groups",entity.Groups);
pars[17] = new MySqlParameter("@Level",entity.Level);
pars[18] = new MySqlParameter("@MaxCreateNumber",entity.MaxCreateNumber);
pars[19] = new MySqlParameter("@ExpireTime",entity.ExpireTime);
pars[20] = new MySqlParameter("@Province",entity.Province);
pars[21] = new MySqlParameter("@City",entity.City);
pars[22] = new MySqlParameter("@GroupNames",entity.GroupNames);
pars[23] = new MySqlParameter("@MakeRate",entity.MakeRate);
pars[24] = new MySqlParameter("@NotMakeRate",entity.NotMakeRate);
pars[25] = new MySqlParameter("@AgentRate",entity.AgentRate);
pars[26] = new MySqlParameter("@CreateUser",entity.CreateUser);
return MySqlHelper.ExecuteNonQuery(CommandType.Text,sqlCmd, pars);
}