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);
}
