public static string ConvertToRoleName(object e)
{
string uid = "";
try
{
uid = e.ToString().Trim();
UserrolesModel tmp = new UserrolesModel();
string rid = FGA_BLL.UserrolesBLL.GetUserRolesModelInfo(uid).rid.ToString();
RolesModel tmp2 = new RolesModel();
tmp2.rid = Convert.ToInt32(rid);
tmp2 = FGA_BLL.RolesBLL.GetRolesInfo(tmp2);
string name = string.Empty;
name = tmp2.rname;
if (tmp2.state != 1)
{
name += "<span style='color:red'>(已" + Enum.GetName(typeof(CommonState), tmp2.state) + ")</span>";
}
return(name);
}
catch
{
return("未知");
}
}
/// <summary>
/// 删
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public bool DeleteUserroles(UserrolesModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from Userroles where 1=1 ");
sb.Append("and urid=@urid ");
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("@urid", model.urid));
int res = Base.SQLServerHelper.ExecuteSql(sb.ToString(), pms.ToArray());
return(res > 0);
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public UserrolesModel GetUserrolesInfo(UserrolesModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from Userroles where 1=1 ");
sb.Append("and urid=@urid ");
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("@urid", model.urid));
DataSet ds = Base.SQLServerHelper.Query(sb.ToString(), pms.ToArray());
if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0)
{
return(null);
}
return(new UserrolesModel(ds.Tables[0].Rows[0]));
}
/// <summary>
/// 增
/// </summary>
/// <param name="model">new model</param>
/// <returns></returns>
public bool AddUserroles(UserrolesModel model)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into Userroles ( ");
sb.Append("uid,rid");
sb.Append(") values ( ");
sb.Append("@uid,@rid");
sb.Append(") ");
List <SqlParameter> pms = new List <SqlParameter>();
pms.Add(new SqlParameter("@uid", model.uid));
pms.Add(new SqlParameter("@rid", model.rid));
int res = Base.SQLServerHelper.ExecuteSql(sb.ToString(), pms.ToArray());
return(res > 0);
}
/// <summary>
/// 保存员工信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void OnBtnSaveClick(object sender, EventArgs e)
{
if (Session[SysConst.S_LOGIN_USER] == null)
{
return;
}
try
{
UsersModel tmpModel = new UsersModel();
string strId = string.Empty;
//若不为空，是修改
if (Request.QueryString["id"] != null && Request.QueryString["id"] != string.Empty)
{
strId = Request.QueryString["id"].Trim();
tmpModel.USERID = Convert.ToInt32(strId);
tmpModel = FGA_BLL.UsersBLL.GetUsersInfo(tmpModel);
//当登录名有变化时，要判断登录名和系统中其它的用户名是否有重复
if (tmpModel.USERNAME.Trim() != this.txtLoginId.Text.Trim())
{
//判断新角色名和系统中其它的用户名是否有重复
if (CheckLoginIdExist(this.txtLoginId.Text.Trim()))
{
AutoCloseMessage("txtLoginId", "登录名<font color=red>" + this.txtLoginId.Text + "</font>已存在，请更换登录名！", "bottom left");
// ShowTopMessage(string.Format("登录名<font color=red>{0}</font>已存在，请更换登录名！", this.txtLoginId.Text), "40px", "100%");
//base.ShowBottomMessage(string.Format("登录名<font color=red>{0}</font>已存在，请更换登录名！", this.txtLoginId.Text.Trim()));
//ShowAlert("提示", string.Format("角色名{0}已存在，请更换角色名！", strRoleName));
return;
}
}
tmpModel.USERNAME = FGA_NUtility.SqlCheck.CheckStr(this.txtLoginId.Text.Trim());
tmpModel.STATUS = Convert.ToSByte(this.ddpStatus.SelectedValue).ToString();
if (!string.IsNullOrEmpty(this.txtsendstarttime.Text.Trim()))
{
tmpModel.ACTIVEDATE = Convert.ToDateTime(this.txtsendstarttime.Text);
}
tmpModel.EMAIL = this.txtemail.Text.Trim();
tmpModel.TEL = this.txtPhone1.Text.Trim();
if (FGA_BLL.UsersBLL.UpdateUsers(tmpModel))
{
RolesModel tmp1 = new RolesModel();
// tmp1 = FGA_BLL.RolesBLL.GetRolesModel(ddlRole.SelectedValue);
if (tmp1 != null)
{
FGA_BLL.UserrolesBLL.UpdateUserroles(strId, ddlRole.SelectedValue);
}
//刷新缓存
FGA_BLL.Cache.UsersCache.InitCache();
FGA_BLL.Cache.UserrolesCache.InitCache();
base.DoYmpromptBack(SysConst.ST_OK);
}
else
{
//ShowTopMessage("用户信息修改失败！", "40px", "100%");
AutoCloseMessage("btnSave", "用户信息修改失败！", "bottom right");
}
}
else
{
tmpModel.USERNAME = FGA_NUtility.SqlCheck.CheckStr(this.txtLoginId.Text.Trim());
//判断登录名是否有重复，若重复立刻提示，并中止操作
if (CheckLoginIdExist(this.txtLoginId.Text.Trim()))
{
//ShowTopMessage("用户信息新增失败!", "40px", "100%");
AutoCloseMessage("txtLoginId", "登录名<font color=red>" + this.txtLoginId.Text + "</font>已存在，请更换登录名！", "bottom left");
// ShowTopMessage(string.Format("登录名<font color=red>{0}</font>已存在，请更换登录名！", this.txtLoginId.Text), "40px", "100%");
//ShowAlert("提示", string.Format("登录名{0}已存在，请更换登录名！", this.txtLoginId.Text));
return;
}
tmpModel.STATUS = Convert.ToSByte(this.ddpStatus.SelectedValue).ToString();
if (!string.IsNullOrEmpty(this.txtsendstarttime.Text.Trim()))
{
tmpModel.ACTIVEDATE = Convert.ToDateTime(this.txtsendstarttime.Text);
}
else
{
tmpModel.ACTIVEDATE = DateTime.Now.AddDays(7);
}
tmpModel.CREATEDATE = DateTime.Now;
tmpModel.EMAIL = this.txtemail.Text.Trim();
tmpModel.TEL = this.txtPhone1.Text.Trim();
//MD5三次加密
string psd = FGA_NUtility.ConfigHelper.GetConfigValue("DefaultPSD");
for (int i = 0; i < 3; i++)
{
psd = Encrypt.MD5EnCode(psd);
}
tmpModel.PASSWORD = psd;
if (FGA_BLL.UsersBLL.AddUsers(tmpModel))
{
//向用户角色表中增加新记录
// string rid = FGA_BLL.RolesBLL.GetRolesModel(ddlRole.SelectedValue).rid.ToString();
string uid = FGA_BLL.UsersBLL.GetModelByLoginId(this.txtLoginId.Text).USERID.ToString();
UserrolesModel tmp = new UserrolesModel();
tmp.uid = Convert.ToInt32(uid);
tmp.rid = Convert.ToInt32(ddlRole.SelectedValue);
FGA_BLL.UserrolesBLL.AddUserroles(tmp);
//刷新缓存
FGA_BLL.Cache.UsersCache.InitCache();
FGA_BLL.Cache.UserrolesCache.InitCache();
base.DoYmpromptBack(SysConst.ST_OK);
}
else
{
//ShowBottomMessage("用户信息新增失败！");
//ShowTopMessage("用户信息新增失败!", "40px", "100%");
AutoCloseMessage("btnSave", "用户信息新增失败！", "bottom right");
}
}
}
catch (Exception ex)
{
FGA_NUtility.SysLog.WriteException(this.GetType().Name, ex);
}
}
/// <summary>
/// 查
/// </summary>
/// <param name="model">empty model with key value</param>
/// <returns></returns>
public static UserrolesModel GetUserrolesInfo(UserrolesModel model)
{
return(Common.Instance._Userroles.GetUserrolesInfo(model));
}
/// <summary>
/// 删
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool DeleteUserroles(UserrolesModel model)
{
return(Common.Instance._Userroles.DeleteUserroles(model));
}
/// <summary>
/// 增
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddUserroles(UserrolesModel model)
{
return(Common.Instance._Userroles.AddUserroles(model));
}
