/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SMT_USER_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMT_USER_INFO set ");
strSql.Append("PASS_WORD=@PASS_WORD,");
strSql.Append("IS_ENABLE=@IS_ENABLE,");
strSql.Append("ORDER_VALUE=@ORDER_VALUE,");
strSql.Append("REAL_NAME=@REAL_NAME,");
strSql.Append("ORG_ID=@ORG_ID,");
strSql.Append("TELEPHONE=@TELEPHONE,");
strSql.Append("ADDRESS=@ADDRESS,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("QQ=@QQ,");
strSql.Append("ROLE_ID=@ROLE_ID,");
strSql.Append("KEY_VAL=@KEY_VAL");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@PASS_WORD", SqlDbType.NVarChar, 100),
new SqlParameter("@IS_ENABLE", SqlDbType.Bit, 1),
new SqlParameter("@ORDER_VALUE", SqlDbType.Int, 4),
new SqlParameter("@REAL_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ORG_ID", SqlDbType.Decimal, 9),
new SqlParameter("@TELEPHONE", SqlDbType.NVarChar, 50),
new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 100),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 100),
new SqlParameter("@QQ", SqlDbType.NVarChar, 50),
new SqlParameter("@ROLE_ID", SqlDbType.Decimal, 9),
new SqlParameter("@KEY_VAL", SqlDbType.VarChar, 200),
new SqlParameter("@ID", SqlDbType.Decimal, 9),
new SqlParameter("@USER_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@IS_DELETE", SqlDbType.Bit, 1)
};
parameters[0].Value = model.PASS_WORD;
parameters[1].Value = model.IS_ENABLE;
parameters[2].Value = model.ORDER_VALUE;
parameters[3].Value = model.REAL_NAME;
parameters[4].Value = model.ORG_ID;
parameters[5].Value = model.TELEPHONE;
parameters[6].Value = model.ADDRESS;
parameters[7].Value = model.EMAIL;
parameters[8].Value = model.QQ;
parameters[9].Value = model.ROLE_ID;
parameters[10].Value = model.KEY_VAL;
parameters[11].Value = model.ID;
parameters[12].Value = model.USER_NAME;
parameters[13].Value = model.IS_DELETE;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.SMT_USER_INFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMT_USER_INFO(");
strSql.Append("USER_NAME,PASS_WORD,IS_ENABLE,IS_DELETE,ORDER_VALUE,REAL_NAME,ORG_ID,TELEPHONE,ADDRESS,EMAIL,QQ,ROLE_ID,KEY_VAL)");
strSql.Append(" values (");
strSql.Append("@USER_NAME,@PASS_WORD,@IS_ENABLE,@IS_DELETE,@ORDER_VALUE,@REAL_NAME,@ORG_ID,@TELEPHONE,@ADDRESS,@EMAIL,@QQ,@ROLE_ID,@KEY_VAL)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@USER_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@PASS_WORD", SqlDbType.NVarChar, 100),
new SqlParameter("@IS_ENABLE", SqlDbType.Bit, 1),
new SqlParameter("@IS_DELETE", SqlDbType.Bit, 1),
new SqlParameter("@ORDER_VALUE", SqlDbType.Int, 4),
new SqlParameter("@REAL_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ORG_ID", SqlDbType.Decimal, 9),
new SqlParameter("@TELEPHONE", SqlDbType.NVarChar, 50),
new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 100),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 100),
new SqlParameter("@QQ", SqlDbType.NVarChar, 50),
new SqlParameter("@ROLE_ID", SqlDbType.Decimal, 9),
new SqlParameter("@KEY_VAL", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.USER_NAME;
parameters[1].Value = model.PASS_WORD;
parameters[2].Value = model.IS_ENABLE;
parameters[3].Value = model.IS_DELETE;
parameters[4].Value = model.ORDER_VALUE;
parameters[5].Value = model.REAL_NAME;
parameters[6].Value = model.ORG_ID;
parameters[7].Value = model.TELEPHONE;
parameters[8].Value = model.ADDRESS;
parameters[9].Value = model.EMAIL;
parameters[10].Value = model.QQ;
parameters[11].Value = model.ROLE_ID;
parameters[12].Value = model.KEY_VAL;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
private void btnOk_Click(object sender, EventArgs e)
{
List <Node> nodes = advTree.GetNodeList(true, typeof(Maticsoft.Model.SMT_USER_INFO));
SelectedUsers = new List <Maticsoft.Model.SMT_DEPT_USER>();
foreach (var item in nodes)
{
Maticsoft.Model.SMT_USER_INFO user = (Maticsoft.Model.SMT_USER_INFO)item.Tag;
Maticsoft.Model.SMT_DEPT_USER du = new Maticsoft.Model.SMT_DEPT_USER();
du.DEPT_ID = _orgId;
du.USER_ID = user.ID;
du.USER_INFO = user;
SelectedUsers.Add(du);
}
Maticsoft.BLL.SMT_DEPT_USER duBll = new Maticsoft.BLL.SMT_DEPT_USER();
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
foreach (var item in SelectedUsers)
{
if (_selectUserIds.Contains(item.USER_ID))
{
continue;
}
else
{
duBll.Add(item);
}
}
this.BeginInvoke(new Action(() =>
{
this.DialogResult = DialogResult.OK;
}));
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存异常！" + ex.Message);
}
});
waiting.Show(this);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_USER_INFO GetModel(decimal ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,USER_NAME,PASS_WORD,IS_ENABLE,IS_DELETE,ORDER_VALUE,REAL_NAME,ORG_ID,TELEPHONE,ADDRESS,EMAIL,QQ,ROLE_ID,KEY_VAL from SMT_USER_INFO ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Decimal)
};
parameters[0].Value = ID;
Maticsoft.Model.SMT_USER_INFO model = new Maticsoft.Model.SMT_USER_INFO();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SMT_USER_INFO DataRowToModel(DataRow row)
{
Maticsoft.Model.SMT_USER_INFO model = new Maticsoft.Model.SMT_USER_INFO();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = decimal.Parse(row["ID"].ToString());
}
if (row["USER_NAME"] != null)
{
model.USER_NAME = row["USER_NAME"].ToString();
}
if (row["PASS_WORD"] != null)
{
model.PASS_WORD = row["PASS_WORD"].ToString();
}
if (row["IS_ENABLE"] != null && row["IS_ENABLE"].ToString() != "")
{
if ((row["IS_ENABLE"].ToString() == "1") || (row["IS_ENABLE"].ToString().ToLower() == "true"))
{
model.IS_ENABLE = true;
}
else
{
model.IS_ENABLE = false;
}
}
if (row["IS_DELETE"] != null && row["IS_DELETE"].ToString() != "")
{
if ((row["IS_DELETE"].ToString() == "1") || (row["IS_DELETE"].ToString().ToLower() == "true"))
{
model.IS_DELETE = true;
}
else
{
model.IS_DELETE = false;
}
}
if (row["ORDER_VALUE"] != null && row["ORDER_VALUE"].ToString() != "")
{
model.ORDER_VALUE = int.Parse(row["ORDER_VALUE"].ToString());
}
if (row["REAL_NAME"] != null)
{
model.REAL_NAME = row["REAL_NAME"].ToString();
}
if (row["ORG_ID"] != null && row["ORG_ID"].ToString() != "")
{
model.ORG_ID = decimal.Parse(row["ORG_ID"].ToString());
}
if (row["TELEPHONE"] != null)
{
model.TELEPHONE = row["TELEPHONE"].ToString();
}
if (row["ADDRESS"] != null)
{
model.ADDRESS = row["ADDRESS"].ToString();
}
if (row["EMAIL"] != null)
{
model.EMAIL = row["EMAIL"].ToString();
}
if (row["QQ"] != null)
{
model.QQ = row["QQ"].ToString();
}
if (row["ROLE_ID"] != null && row["ROLE_ID"].ToString() != "")
{
model.ROLE_ID = decimal.Parse(row["ROLE_ID"].ToString());
}
if (row["KEY_VAL"] != null)
{
model.KEY_VAL = row["KEY_VAL"].ToString();
}
}
return(model);
}
public FrmRoleSelect(Maticsoft.Model.SMT_USER_INFO user)
{
InitializeComponent();
_userInfo = user;
}
public FrmEditorUser(Maticsoft.Model.SMT_USER_INFO userInfo = null)
{
InitializeComponent();
_userInfo = userInfo;
}
private void btnOk_Click(object sender, EventArgs e)
{
if (tbUserName.Text.Trim() == "")
{
MessageBox.Show("用户名不能为空！");
return;
}
if (_userInfo == null)
{
_userInfo = new Maticsoft.Model.SMT_USER_INFO();
_userInfo.ID = -1;
}
string oldUser = _userInfo.USER_NAME;
_userInfo.USER_NAME = tbUserName.Text.Trim();
_userInfo.PASS_WORD = tbPwd.Text;
if (_userInfo.PASS_WORD == "123456")
{
_userInfo.PASS_WORD = "e10adc3949ba59abbe56e057f20f883e";
}
_userInfo.REAL_NAME = tbRealName.Text.Trim();
_userInfo.IS_ENABLE = cbEnable.Checked;
_userInfo.TELEPHONE = tbTel.Text.Trim();
_userInfo.ADDRESS = tbAddress.Text.Trim();
_userInfo.EMAIL = tbEmail.Text.Trim();
_userInfo.QQ = tbQQ.Text.Trim();
_userInfo.KEY_VAL = "";
_userInfo.IS_DELETE = false;
if (cboRole.SelectedItem != null)
{
ComboItem cboItem = (ComboItem)cboRole.SelectedItem;
Maticsoft.Model.SMT_ROLE_INFO roleInfo = (Maticsoft.Model.SMT_ROLE_INFO)cboItem.Tag;
_userInfo.ROLE_ID = roleInfo.ID;
_userInfo.ROLE_NAME = roleInfo.ROLE_NAME;
}
else
{
_userInfo.ROLE_ID = -1;
}
if (cbtDept.SelectedNode != null)
{
Maticsoft.Model.SMT_ORG_INFO orgInfo = (Maticsoft.Model.SMT_ORG_INFO)cbtDept.SelectedNode.Tag;
_userInfo.ORG_ID = orgInfo.ID;
_userInfo.DEPT_NAME = orgInfo.ORG_NAME;
}
else
{
_userInfo.ORG_ID = -1;
}
CtrlWaiting waiting = new CtrlWaiting(() =>
{
try
{
Maticsoft.BLL.SMT_USER_INFO userBll = new Maticsoft.BLL.SMT_USER_INFO();
if (_userInfo.ID == -1)
{
userBll.Add(_userInfo);
SmtLog.InfoFormat("用户", "添加用户：用户名={0}，状态={1}", _userInfo.USER_NAME, _userInfo.IS_ENABLE);
}
else
{
userBll.Update(_userInfo);
SmtLog.InfoFormat("用户", "更新用户：用户名={0}，状态={1},原始用户名={2}", _userInfo.USER_NAME, _userInfo.IS_ENABLE, oldUser);
}
this.BeginInvoke(new Action(() =>
{
this.DialogResult = DialogResult.OK;
this.Close();
}));
}
catch (Exception ex)
{
WinInfoHelper.ShowInfoWindow(this, "保存用户异常：" + ex.Message);
log.Error("保存用户异常：", ex);
}
});
waiting.Show(this);
}
