/// <summary>
/// 添加用户角色
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="roleIds">用,分隔的角色ID</param>
/// <returns></returns>
public int Add(int userId, string[] roleIds, Eastcom.Model.v_Sys_User_Info uModel)
{
//先删除该用户的所有角色
this.DelWhere(string.Format("FK_UserID={0}", userId));
int result = 0;
int[] ids = CommonClass.StringHander.Common.GetIntArrayByStringArray(roleIds);
if (ids.Length > 0)
{
Eastcom.Model.Sys_Power_UserRole model = null;
for (int i = 0; i < ids.Length; i++)
{
if (ids[i] == 0)
{
continue;
}
model = new Model.Sys_Power_UserRole();
model.CreateTime = DateTime.Now;
model.FK_CreateID = uModel.UserID;
model.FK_RoleId = ids[i];
model.FK_UserId = userId;
if (this.Add(model) > 0)
{
result++;
}
}
}
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(int userId, int[] rightsID, Eastcom.Model.v_Sys_User_Info uModel)
{
bool flag = true;
Eastcom.Model.Sys_Power_UserRight userRightModel = null;
if (rightsID.Length > 0)
{
if (this.DelWhere(string.Format("FK_UserID={0}", userId)))
{
for (int i = 0; i < rightsID.Length; i++)
{
if (rightsID[i] > 0)
{
userRightModel = new Eastcom.Model.Sys_Power_UserRight();
userRightModel.EditTime = DateTime.Now;
userRightModel.FK_EditID = uModel.UserID;
userRightModel.FK_RightID = rightsID[i];
userRightModel.FK_UserID = userId;
if (this.Add(userRightModel) <= 0)
{
flag = false;
}
}
}
}
}
return(flag);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(int roleID, int[] rightsID, Eastcom.Model.v_Sys_User_Info uModel)
{
Eastcom.Model.Sys_Power_RoleRight roleRightModel = null;
bool flag = true;
if (rightsID.Length > 0)
{
for (int i = 0; i < rightsID.Length; i++)
{
if (rightsID[i] > 0)
{
roleRightModel = new Eastcom.Model.Sys_Power_RoleRight();
roleRightModel.CreateTime = DateTime.Now;
roleRightModel.FK_CreateID = uModel.UserID;
roleRightModel.FK_RightId = rightsID[i];
roleRightModel.FK_RoleId = roleID;
if (this.Add(roleRightModel) <= 0)
{
flag = false;
}
}
}
}
return(flag);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">model</param>
/// <param name="rightIDs">权限ID数组</param>
public int Add(Eastcom.Model.Sys_Power_Role model, int[] rightIDs, Eastcom.Model.v_Sys_User_Info uModel)
{
int result = dal.Add(model);
if (result > 0)
{
Eastcom.BLL.Sys_Power_RoleRight roleRightBLL = new Sys_Power_RoleRight();
roleRightBLL.Add(result, rightIDs, uModel);
}
return(result);
}
public static Eastcom.Model.v_Sys_User_Info GetuModelCookies()
{
Eastcom.Model.v_Sys_User_Info uModel = null;
string userId = CommonClass.StringHander.Common.GetCookies(CookieName);
if (!string.IsNullOrEmpty(userId))
{
uModel = new Eastcom.BLL.v_Sys_User_Info().GetModel(CommonClass.StringHander.Common.GetInt(userId));
}
return(uModel);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 用户登录检测
/// </summary>
/// <param name="pwd">md5</param>
/// <returns>true:匹配成功</returns>
public Eastcom.Model.v_Sys_User_Info GetModel(string userName, string pwd)
{
Eastcom.Model.v_Sys_User_Info model = null;
List <Eastcom.Model.v_Sys_User_Info> lst = new Eastcom.BLL.v_Sys_User_Info().GetModelList(string.Format("UserName='******' and Pwd='{1}'", CommonClass.StringHander.Common.No_SqlHack(userName).ToLower(), CommonClass.StringHander.Common.No_SqlHack(pwd).ToLower()));
if (null != lst && lst.Count > 0)
{
model = lst[0];
}
return(model);
}
// 获取用户地区
public static string GetUserArea()
{
Eastcom.Model.v_Sys_User_Info uModel = GetuModelCookies();
if (uModel == null)
{
return("");
}
else
{
return(uModel.UserMangerArea);
}
}
// 获取用户真实名
public static string GetUserPwd()
{
Eastcom.Model.v_Sys_User_Info uModel = GetuModelCookies();
if (uModel == null)
{
return("");
}
else
{
return(uModel.Pwd);
}
}
// 是否登陆状态
public static bool IsLoginUser()
{
Eastcom.Model.v_Sys_User_Info uModel = GetuModelCookies();
if (uModel != null)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取角色名
/// </summary>
/// <returns></returns>
public static string GetRoleID()
{
Eastcom.Model.v_Sys_User_Info uModel = GetuModelCookies();
if (uModel == null)
{
return("");
}
else
{
return(uModel.角色ID);
}
}
/// <summary>
/// 获取角色ID 编号
/// </summary>
/// <returns></returns>
public static int GetUserID()
{
Eastcom.Model.v_Sys_User_Info uModel = GetuModelCookies();
if (uModel == null)
{
return(-1);
}
else
{
return(uModel.UserID);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">model</param>
/// <param name="rightIDs">权限ID数组</param>
public bool Update(Eastcom.Model.Sys_Power_Role model, int[] rightIDs, Eastcom.Model.v_Sys_User_Info uModel)
{
bool flag = dal.Update(model);
if (flag)
{
Eastcom.BLL.Sys_Power_RoleRight roleRightBLL = new Sys_Power_RoleRight();
//删除角色的所有权限再添加
if (roleRightBLL.DelWhere(string.Format("FK_RoleID={0}", model.RoleID)))
{
roleRightBLL.Add(model.RoleID, rightIDs, uModel);
}
}
return(flag);
}
public static Eastcom.Model.v_Sys_User_Info GetUserInfo()
{
Eastcom.Model.v_Sys_User_Info uModel = GetuModelCookies();
return(uModel);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Eastcom.Model.v_Sys_User_Info model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Eastcom.Model.v_Sys_User_Info model)
{
return(dal.Add(model));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Eastcom.Model.v_Sys_User_Info> DataTableToList(DataTable dt)
{
List <Eastcom.Model.v_Sys_User_Info> modelList = new List <Eastcom.Model.v_Sys_User_Info>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Eastcom.Model.v_Sys_User_Info model;
for (int n = 0; n < rowsCount; n++)
{
model = new Eastcom.Model.v_Sys_User_Info();
if (dt.Rows[n]["UserID"] != null && dt.Rows[n]["UserID"].ToString() != "")
{
model.UserID = int.Parse(dt.Rows[n]["UserID"].ToString());
}
if (dt.Rows[n]["UserName"] != null && dt.Rows[n]["UserName"].ToString() != "")
{
model.UserName = dt.Rows[n]["UserName"].ToString();
}
if (dt.Rows[n]["RealName"] != null && dt.Rows[n]["RealName"].ToString() != "")
{
model.RealName = dt.Rows[n]["RealName"].ToString();
}
if (dt.Rows[n]["NickName"] != null && dt.Rows[n]["NickName"].ToString() != "")
{
model.NickName = dt.Rows[n]["NickName"].ToString();
}
if (dt.Rows[n]["Pwd"] != null && dt.Rows[n]["Pwd"].ToString() != "")
{
model.Pwd = dt.Rows[n]["Pwd"].ToString();
}
if (dt.Rows[n]["FK_UnitID"] != null && dt.Rows[n]["FK_UnitID"].ToString() != "")
{
model.FK_UnitID = int.Parse(dt.Rows[n]["FK_UnitID"].ToString());
}
if (dt.Rows[n]["Sex"] != null && dt.Rows[n]["Sex"].ToString() != "")
{
model.Sex = int.Parse(dt.Rows[n]["Sex"].ToString());
}
if (dt.Rows[n]["Age"] != null && dt.Rows[n]["Age"].ToString() != "")
{
model.Age = int.Parse(dt.Rows[n]["Age"].ToString());
}
if (dt.Rows[n]["Email"] != null && dt.Rows[n]["Email"].ToString() != "")
{
model.Email = dt.Rows[n]["Email"].ToString();
}
if (dt.Rows[n]["Tel"] != null && dt.Rows[n]["Tel"].ToString() != "")
{
model.Tel = dt.Rows[n]["Tel"].ToString();
}
if (dt.Rows[n]["QQ"] != null && dt.Rows[n]["QQ"].ToString() != "")
{
model.QQ = dt.Rows[n]["QQ"].ToString();
}
if (dt.Rows[n]["Address"] != null && dt.Rows[n]["Address"].ToString() != "")
{
model.Address = dt.Rows[n]["Address"].ToString();
}
if (dt.Rows[n]["Birth"] != null && dt.Rows[n]["Birth"].ToString() != "")
{
model.Birth = DateTime.Parse(dt.Rows[n]["Birth"].ToString());
}
if (dt.Rows[n]["Contact"] != null && dt.Rows[n]["Contact"].ToString() != "")
{
model.Contact = dt.Rows[n]["Contact"].ToString();
}
if (dt.Rows[n]["Remark"] != null && dt.Rows[n]["Remark"].ToString() != "")
{
model.Remark = dt.Rows[n]["Remark"].ToString();
}
if (dt.Rows[n]["FK_CreateID"] != null && dt.Rows[n]["FK_CreateID"].ToString() != "")
{
model.FK_CreateID = int.Parse(dt.Rows[n]["FK_CreateID"].ToString());
}
if (dt.Rows[n]["CreateTime"] != null && dt.Rows[n]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(dt.Rows[n]["CreateTime"].ToString());
}
if (dt.Rows[n]["FK_EditID"] != null && dt.Rows[n]["FK_EditID"].ToString() != "")
{
model.FK_EditID = int.Parse(dt.Rows[n]["FK_EditID"].ToString());
}
if (dt.Rows[n]["EditTime"] != null && dt.Rows[n]["EditTime"].ToString() != "")
{
model.EditTime = DateTime.Parse(dt.Rows[n]["EditTime"].ToString());
}
if (dt.Rows[n]["State"] != null && dt.Rows[n]["State"].ToString() != "")
{
model.State = int.Parse(dt.Rows[n]["State"].ToString());
}
if (dt.Rows[n]["IsDel"] != null && dt.Rows[n]["IsDel"].ToString() != "")
{
model.IsDel = int.Parse(dt.Rows[n]["IsDel"].ToString());
}
if (dt.Rows[n]["UserMangerArea"] != null && dt.Rows[n]["UserMangerArea"].ToString() != "")
{
model.UserMangerArea = dt.Rows[n]["UserMangerArea"].ToString();
}
else
{
model.UserMangerArea = "";
}
if (dt.Rows[n]["角色名"] != null && dt.Rows[n]["角色名"].ToString() != "")
{
model.角色名 = dt.Rows[n]["角色名"].ToString();
}
if (dt.Rows[n]["角色ID"] != null && dt.Rows[n]["角色ID"].ToString() != "")
{
model.角色ID = dt.Rows[n]["角色ID"].ToString();
}
if (dt.Rows[n]["最大角色权重"] != null && dt.Rows[n]["最大角色权重"].ToString() != "")
{
model.最大角色权重 = int.Parse(dt.Rows[n]["最大角色权重"].ToString());
}
if (dt.Rows[n]["性别"] != null && dt.Rows[n]["性别"].ToString() != "")
{
model.性别 = dt.Rows[n]["性别"].ToString();
}
if (dt.Rows[n]["创建者名"] != null && dt.Rows[n]["创建者名"].ToString() != "")
{
model.创建者名 = dt.Rows[n]["创建者名"].ToString();
}
if (dt.Rows[n]["修改者名"] != null && dt.Rows[n]["修改者名"].ToString() != "")
{
model.修改者名 = dt.Rows[n]["修改者名"].ToString();
}
if (dt.Rows[n]["账户状态"] != null && dt.Rows[n]["账户状态"].ToString() != "")
{
model.账户状态 = dt.Rows[n]["账户状态"].ToString();
}
modelList.Add(model);
}
}
return(modelList);
}
