/// <summary>
/// 添加和修改
/// </summary>
/// <param name="updateDel"></param>
/// <param name="curPage"></param>
/// <param name="is4Modify"></param>
/// <param name="model"></param>
public FrmAddAuthUser(Action <int> updateDel, int curPage, bool is4Modify = false, SteelManagement.Model.AuthUser model = null)
{
this.StartPosition = FormStartPosition.CenterParent;
InitializeComponent();
_updateDel = updateDel;
_curPage = curPage;
_is4Modify = is4Modify;
_model = model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SteelManagement.Model.AuthUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AuthUser set ");
strSql.Append("UserName=@UserName,");
strSql.Append("Account=@Account,");
strSql.Append("Password=@Password,");
strSql.Append("UserMobile=@UserMobile,");
strSql.Append("DepartmentId=@DepartmentId,");
strSql.Append("UserLevel=@UserLevel,");
strSql.Append("Privilege=@Privilege");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@Account", SqlDbType.VarChar, 20),
new SqlParameter("@Password", SqlDbType.VarChar, 100),
new SqlParameter("@UserMobile", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentId", SqlDbType.Int, 4),
new SqlParameter("@UserLevel", SqlDbType.Int, 4),
new SqlParameter("@Privilege", SqlDbType.Int, 4),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Account;
parameters[2].Value = model.Password;
parameters[3].Value = model.UserMobile;
parameters[4].Value = model.DepartmentId;
parameters[5].Value = model.UserLevel;
parameters[6].Value = model.Privilege;
parameters[7].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SteelManagement.Model.AuthUser DataRowToModel(DataRow row)
{
SteelManagement.Model.AuthUser model = new SteelManagement.Model.AuthUser();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["Account"] != null)
{
model.Account = row["Account"].ToString();
}
if (row["Password"] != null)
{
model.Password = row["Password"].ToString();
}
if (row["UserMobile"] != null)
{
model.UserMobile = row["UserMobile"].ToString();
}
if (row["DepartmentId"] != null && row["DepartmentId"].ToString() != "")
{
model.DepartmentId = int.Parse(row["DepartmentId"].ToString());
}
if (row["UserLevel"] != null && row["UserLevel"].ToString() != "")
{
model.UserLevel = int.Parse(row["UserLevel"].ToString());
}
if (row["Privilege"] != null && row["Privilege"].ToString() != "")
{
model.Privilege = int.Parse(row["Privilege"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SteelManagement.Model.AuthUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AuthUser(");
strSql.Append("UserName,Account,Password,UserMobile,DepartmentId,UserLevel,Privilege)");
strSql.Append(" values (");
strSql.Append("@UserName,@Account,@Password,@UserMobile,@DepartmentId,@UserLevel,@Privilege)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.VarChar, 100),
new SqlParameter("@Account", SqlDbType.VarChar, 20),
new SqlParameter("@Password", SqlDbType.VarChar, 100),
new SqlParameter("@UserMobile", SqlDbType.VarChar, 50),
new SqlParameter("@DepartmentId", SqlDbType.Int, 4),
new SqlParameter("@UserLevel", SqlDbType.Int, 4),
new SqlParameter("@Privilege", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Account;
parameters[2].Value = model.Password;
parameters[3].Value = model.UserMobile;
parameters[4].Value = model.DepartmentId;
parameters[5].Value = model.UserLevel;
parameters[6].Value = model.Privilege;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SteelManagement.Model.AuthUser GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,UserName,Account,Password,UserMobile,DepartmentId,UserLevel,Privilege from AuthUser ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
SteelManagement.Model.AuthUser model = new SteelManagement.Model.AuthUser();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtUserName.Text) ||
string.IsNullOrEmpty(txtAccount.Text) ||
string.IsNullOrEmpty(txtPassword.Text)
)
{
MessageBoxEx.Show("除手机号外都必须填写!");
return;
}
if (_is4Modify)
{
_model.UserName = txtUserName.Text;
_model.Account = txtAccount.Text;
_model.Password = txtPassword.Text;
_model.UserMobile = txtUserMobile.Text;
if ((ChkBoxsToPrevilege() != _model.Privilege ||
(GetUserLevelByRbtns()) != _model.UserLevel) &&
GlobalUtils.LoginUser.UserLevel != 0)
{
MessageBoxEx.Show("不能修改自己的权限信息，请联系管理员!");
return;
}
_model.Privilege = ChkBoxsToPrevilege();
_model.UserLevel = GetUserLevelByRbtns();
//执行负责项目更改
var userChecked = _bllProjectChecker.GetUserCheckProjects(_model.UserName);
foreach (var item in chkProjects.CheckBoxItems)
{
if (
(item.Checked && (userChecked == null || userChecked.Count <= 0)) ||
(item.Checked && !userChecked.Contains(item.Text))) //原来没有现在有
{
Model.ProjectChecker model = new Model.ProjectChecker();
model.EntryTime = DateTime.Now;
model.Project = item.Text;
model.UserName = _model.UserName;
model.UserId = _model.Id;
if (_bllProjectChecker.Add(model) < 1)
{
MessageBoxEx.Show(text: "修改失败!");
return;
}
}
if (userChecked == null || userChecked.Count <= 0)
{
continue;
}
if (!item.Checked && userChecked.Contains(item.Text)) //原来有现在没有
{
if (!_bllProjectChecker.Delete(_model.UserName, item.Text))
{
MessageBoxEx.Show(text: "修改失败!");
return;
}
}
}
if (!_bllAuthUser.Update(_model))
{
MessageBoxEx.Show("更新失败，请稍后重试!");
return;
}
MessageBoxEx.Show("更新成功!");
_updateDel(_curPage);
this.DialogResult = DialogResult.OK;
this.Close();
if (GlobalUtils.LoginUser.Account == _model.Account) //修改的自己的账号重启程序
{
MessageBoxEx.Show("修改了自己的信息，即将重启系统!");
GlobalUtils.StartExe(Application.ExecutablePath);
Application.ExitThread();
}
}
else //新增
{
if (GlobalUtils.LoginUser.UserLevel != 0)
{
MessageBoxEx.Show("只有管理员才有权限添加用户!");
return;
}
var existedModel = _bllAuthUser.GetModelList(string.Format(" UserName='******' or Account='{1}' ", txtUserName.Text, txtAccount.Text));
if (existedModel != null && existedModel.Count > 0)
{
MessageBoxEx.Show("用户名或登陆账号重复!");
return;
}
SteelManagement.Model.AuthUser model = new SteelManagement.Model.AuthUser();
try
{
model.UserName = txtUserName.Text;
model.Account = txtAccount.Text;
model.Password = txtPassword.Text;
model.UserMobile = txtUserMobile.Text;
model.Privilege = ChkBoxsToPrevilege();
model.UserLevel = GetUserLevelByRbtns();
//新增的时候不让修改审核项目
if (_bllAuthUser.Add(model) <= 0)
{
MessageBoxEx.Show("添加失败，请稍后重试!");
return;
}
MessageBoxEx.Show("添加成功");
_updateDel(_curPage);
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception)
{
MessageBoxEx.Show("请检查输入是否有误!");
//throw;
}
}
}
