private void Login() { List<Express.Model.Sys_User> models = new Express.BLL.Sys_User().GetModelList(string.Format(" username='******'", txtUserName.Text)); if (models.Count <= 0) { MessageBox.Show("该账号系统不存在!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { Express.Model.Sys_User model = models[0]; if (model.pass == Express.Common.DEncrypt.DESEncrypt.Encrypt(txtPass.Text)) { if (model.UState == 0) { ClientInfo.Sys_UserInfo = model; ClientInfo.SysSetInfo.AutoLogin = cbAutoLogin.Checked; ClientInfo.SysSetInfo.RemPass = cbRemPass.Checked; ClientInfo.SysSetInfo.UserName = txtUserName.Text; ClientInfo.SysSetInfo.Pass = txtPass.Text; ClientInfo.SysSetInfo = ClientInfo.SysSetInfo; this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { MessageBox.Show("该账号已经被禁用,不能用于系统登录!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("账号或密码输入有误!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void btnOK_Click(object sender, EventArgs e) { if (ValidateUserInput()) { Express.Model.Sys_User model = new Express.Model.Sys_User(); model.isadmin = cb04.Checked; model.isclerk = cb02.Checked; model.isfinance = cb03.Checked; model.issaleman = cb01.Checked; model.OperUser4 = ClientInfo.Sys_UserInfo.username; model.pass = DESEncrypt.Encrypt(txtPass.Text); model.PerName = txtPerName.Text; model.UserDate4 = DateTime.Now; model.username = txtUserName.Text; model.UState = cbState.SelectedIndex; string msg = ""; if (!btnResetPass.Visible) { bool result = new Express.BLL.Sys_User().Add(model); msg = result ? "添加账户信息成功!" : "添加账户信息失败!"; } else { model.UID = Convert.ToInt32(btnResetPass.Tag); bool result = new Express.BLL.Sys_User().Update(model); msg = result ? "修改账户信息成功!" : "修改账户信息失败!"; } MessageBox.Show(msg, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = System.Windows.Forms.DialogResult.OK; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Express.Model.Sys_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_User set "); strSql.Append("username=@username,"); strSql.Append("pass=@pass,"); strSql.Append("issaleman=@issaleman,"); strSql.Append("isclerk=@isclerk,"); strSql.Append("isfinance=@isfinance,"); strSql.Append("isadmin=@isadmin,"); strSql.Append("PerName=@PerName,"); strSql.Append("UState=@UState,"); strSql.Append("OperUser4=@OperUser4,"); strSql.Append("UserDate4=@UserDate4"); strSql.Append(" where UID=@UID"); OleDbParameter[] parameters = { new OleDbParameter("@username", OleDbType.VarChar, 20), new OleDbParameter("@pass", OleDbType.VarChar, 100), new OleDbParameter("@issaleman", OleDbType.Boolean, 1), new OleDbParameter("@isclerk", OleDbType.Boolean, 1), new OleDbParameter("@isfinance", OleDbType.Boolean, 1), new OleDbParameter("@isadmin", OleDbType.Boolean, 1), new OleDbParameter("@PerName", OleDbType.VarChar, 10), new OleDbParameter("@UState", OleDbType.Integer, 4), new OleDbParameter("@OperUser4", OleDbType.VarChar, 20), new OleDbParameter("@UserDate4", OleDbType.Date), new OleDbParameter("@UID", OleDbType.Integer, 4) }; parameters[0].Value = model.username; parameters[1].Value = model.pass; parameters[2].Value = model.issaleman; parameters[3].Value = model.isclerk; parameters[4].Value = model.isfinance; parameters[5].Value = model.isadmin; parameters[6].Value = model.PerName; parameters[7].Value = model.UState; parameters[8].Value = model.OperUser4; parameters[9].Value = model.UserDate4; parameters[10].Value = model.UID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Express.Model.Sys_User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_User("); strSql.Append("username,pass,issaleman,isclerk,isfinance,isadmin,PerName,UState,OperUser4,UserDate4)"); strSql.Append(" values ("); strSql.Append("@username,@pass,@issaleman,@isclerk,@isfinance,@isadmin,@PerName,@UState,@OperUser4,@UserDate4)"); OleDbParameter[] parameters = { new OleDbParameter("@username", OleDbType.VarChar, 20), new OleDbParameter("@pass", OleDbType.VarChar, 100), new OleDbParameter("@issaleman", OleDbType.Boolean, 1), new OleDbParameter("@isclerk", OleDbType.Boolean, 1), new OleDbParameter("@isfinance", OleDbType.Boolean, 1), new OleDbParameter("@isadmin", OleDbType.Boolean, 1), new OleDbParameter("@PerName", OleDbType.VarChar, 10), new OleDbParameter("@UState", OleDbType.Integer, 4), new OleDbParameter("@OperUser4", OleDbType.VarChar, 20), new OleDbParameter("@UserDate4", OleDbType.Date) }; parameters[0].Value = model.username; parameters[1].Value = model.pass; parameters[2].Value = model.issaleman; parameters[3].Value = model.isclerk; parameters[4].Value = model.isfinance; parameters[5].Value = model.isadmin; parameters[6].Value = model.PerName; parameters[7].Value = model.UState; parameters[8].Value = model.OperUser4; parameters[9].Value = model.UserDate4; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Express.Model.Sys_User GetModel(int UID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select UID,username,pass,issaleman,isclerk,isfinance,isadmin,PerName,UState,OperUser4,UserDate4 from Sys_User "); strSql.Append(" where UID=@UID"); OleDbParameter[] parameters = { new OleDbParameter("@UID", OleDbType.Integer, 4) }; parameters[0].Value = UID; Express.Model.Sys_User model = new Express.Model.Sys_User(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Express.Model.Sys_User DataRowToModel(DataRow row) { Express.Model.Sys_User model = new Express.Model.Sys_User(); if (row != null) { if (row["UID"] != null && row["UID"].ToString() != "") { model.UID = int.Parse(row["UID"].ToString()); } if (row["username"] != null) { model.username = row["username"].ToString(); } if (row["pass"] != null) { model.pass = row["pass"].ToString(); } if (row["issaleman"] != null && row["issaleman"].ToString() != "") { if ((row["issaleman"].ToString() == "1") || (row["issaleman"].ToString().ToLower() == "true")) { model.issaleman = true; } else { model.issaleman = false; } } if (row["isclerk"] != null && row["isclerk"].ToString() != "") { if ((row["isclerk"].ToString() == "1") || (row["isclerk"].ToString().ToLower() == "true")) { model.isclerk = true; } else { model.isclerk = false; } } if (row["isfinance"] != null && row["isfinance"].ToString() != "") { if ((row["isfinance"].ToString() == "1") || (row["isfinance"].ToString().ToLower() == "true")) { model.isfinance = true; } else { model.isfinance = false; } } if (row["isadmin"] != null && row["isadmin"].ToString() != "") { if ((row["isadmin"].ToString() == "1") || (row["isadmin"].ToString().ToLower() == "true")) { model.isadmin = true; } else { model.isadmin = false; } } if (row["PerName"] != null) { model.PerName = row["PerName"].ToString(); } if (row["UState"] != null && row["UState"].ToString() != "") { model.UState = int.Parse(row["UState"].ToString()); } if (row["OperUser4"] != null) { model.OperUser4 = row["OperUser4"].ToString(); } if (row["UserDate4"] != null && row["UserDate4"].ToString() != "") { model.UserDate4 = DateTime.Parse(row["UserDate4"].ToString()); } } return(model); }