/// <summary>
/// 检测顶级企业的登陆用户是否存在
/// </summary>
/// <param name="userName">登陆名</param>
/// <param name="password">登陆密码</param>
/// <returns></returns>
public static Model_Customer CheckCustomerUser(string userName, string password)
{
string sql = "select * from customer where role = 1 and actived = 0 limit 1;";
Model_Customer customer = _SqlHelp.ExecuteObject <Model_Customer>(sql);
if (customer == null)
{
throw new Exception("顶级企业不存在!");
}
sql = "select * from customer_users where userName=?p1 and customerId = ?p2 limit 1;";
MySqlParameter[] p = new MySqlParameter[2];
p[0] = new MySqlParameter("p1", userName);
p[1] = new MySqlParameter("p2", customer.Id);
Model_CustomerUser user = _SqlHelp.ExecuteObject <Model_CustomerUser>(sql, p);
if (user == null)
{
throw new Exception(string.Format("用户名'{0}'不存在!", userName));
}
if (user.Password.ToUpper() != MyTool.UserMd5(password).ToUpper())
{
throw new Exception("密码不正确!");
}
if (user.Actived == Model.MyEnum.Enum_Active.Disable)
{
throw new Exception("用户已停用");
}
return(customer);
}
private void contextMenuStrip1_Opening(object sender, CancelEventArgs e)
{
ResultModelOfArrayOfModel_CustomerUserd4FqxSXX count = cs.GetCustomerUserList(Customers.Idk__BackingField, true, null);
if (count.Data.Count <Model_CustomerUser>() <= 0)
{
contextMenuStrip1.Enabled = false;
return;
}
else
{
contextMenuStrip1.Enabled = true;
}
Model_CustomerUser mctu = dataGridView1.SelectedRows[0].Tag as Model_CustomerUser;
if (mctu.Activedk__BackingField == Enum_Active.Enabled)
{
tsmEnable.Enabled = false;
tsmDisable.Enabled = true;
}
else
{
tsmEnable.Enabled = true;
tsmDisable.Enabled = false;
}
}
/// <summary>
/// 查询密码
/// </summary>
/// <param name="customerUser"></param>
/// <returns></returns>
public static Model_CustomerUser GetPassword(Model_CustomerUser customerUser)
{
string sql = "select * from customer_users where id=?id ;";
MySqlParameter[] paid = new MySqlParameter[1];
paid[0] = new MySqlParameter("id", customerUser.Id);
Model_CustomerUser use = _SqlHelp.ExecuteObject <Model_CustomerUser>(sql, paid);
return(use);
}
/// <summary>
/// 查询管理员账号是否存在一个启用
/// </summary>
/// <param name="customerUser"></param>
/// <returns></returns>
public static List <Model_CustomerUser> GetActived(Model_CustomerUser customerUser)
{
string sql = "select * from customer_users where customerId=?customerId and actived=?actived";
MySqlParameter[] count = new MySqlParameter[2];
count[0] = new MySqlParameter("customerId", customerUser.CustomerId);
count[1] = new MySqlParameter("actived", Enum_Active.Enabled);
List <Model_CustomerUser> counts = _SqlHelp.ExecuteObjects <Model_CustomerUser>(sql, count);
return(counts);
}
/// <summary>
/// //查询用户是否存在
/// </summary>
/// <param name="customerUser"></param>
/// <returns></returns>
public static Model_CustomerUser GetUserName(Model_CustomerUser customerUser)
{
string sql = "select * from customer_users where customerId=?customerId and username=?username ;";
MySqlParameter[] pa = new MySqlParameter[2];
pa[0] = new MySqlParameter("customerId", customerUser.CustomerId);
pa[1] = new MySqlParameter("username", customerUser.UserName);
Model_CustomerUser user = _SqlHelp.ExecuteObject <Model_CustomerUser>(sql, pa);
return(user);
}
/// <summary>
/// 判断状态显示停用/启用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void contextMenuStrip1_Opening(object sender, CancelEventArgs e)
{
Model_CustomerUser editcususer = dataGridView1.SelectedRows[0].Tag as Model_CustomerUser;
if (editcususer.Activedk__BackingField == Enum_Active.Enabled)
{
tsmEnable.Enabled = false;
tsmDisable.Enabled = true;
}
else
{
tsmEnable.Enabled = true;
tsmDisable.Enabled = false;
}
}
/// <summary>
/// 编辑指定用户信息
/// </summary>
/// <param name="customerUserInfo">用户信息</param>
/// <returns></returns>
public ResultModel <Model_CustomerUser> EditCustomerUser(Model_CustomerUser customerUserInfo)
{
ResultModel <Model_CustomerUser> reslut = new ResultModel <Model_CustomerUser>();
try
{
reslut.Data = CustomerUsersServer.ChangePassWord(customerUserInfo);
}
catch (Exception ex)
{
reslut.Code = 1;
reslut.Message = ex.Message;
}
return(reslut);
}
/// <summary>
/// 启用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmEnable_Click(object sender, EventArgs e)
{
Model_CustomerUser editcususer = dataGridView1.SelectedRows[0].Tag as Model_CustomerUser;
editcususer.Activedk__BackingField = Enum_Active.Enabled;
ResultModelOfModel_CustomerUserd4FqxSXX edituser = cs.EditCustomerUser(editcususer);
if (edituser.Code != 0)
{
MessageBox.Show(edituser.Message);
}
else
{
MessageBox.Show("操作成功");
getCustomerLoad();
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmEdit_Click(object sender, EventArgs e)
{
Model_Customer mcust = new Model_Customer();
mcust.Rolek__BackingField = Enum_Role.Administrator;
//
mcust.Idk__BackingField = cus.Idk__BackingField;
mcust.FullNamek__BackingField = cus.FullNamek__BackingField;
//
Model_CustomerUser cususer = dataGridView1.SelectedRows[0].Tag as Model_CustomerUser;
FrmAccountsEdit edit = new FrmAccountsEdit();
edit._ParentFrm = this;
edit.customeruser = cususer;
//edit.ID = cumerid.ToString();
//edit.UserName = cumername;
edit.mcust = mcust;
edit.ShowDialog();
getCustomerLoad();
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmEdit_Click(object sender, EventArgs e)
{
Model_Customer mcust = new Model_Customer();
mcust.Rolek__BackingField = Customers.Rolek__BackingField;
//
mcust.FullNamek__BackingField = Customers.FullNamek__BackingField;
mcust.Idk__BackingField = Customers.Idk__BackingField;
//
Model_CustomerUser custuser = dataGridView1.SelectedRows[0].Tag as Model_CustomerUser;
FrmAccountsEdit edit = new FrmAccountsEdit();
edit._ParentMaint = this;
edit.customeruser = custuser;
//edit.UserName = Customers.FullNamek__BackingField;
//edit.ID = Customers.Idk__BackingField.ToString();
edit.mcust = mcust;
edit.ShowDialog();
CoumterUserLoad();
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmEdit_Click(object sender, EventArgs e)
{
Model_CustomerUser customeruser = dataGridView1.SelectedRows[0].Tag as Model_CustomerUser;
Model_Customer mcus = new Model_Customer();
mcus.Rolek__BackingField = customs.Rolek__BackingField;
//
mcus.Idk__BackingField = customs.Idk__BackingField;
mcus.FullNamek__BackingField = customs.FullNamek__BackingField;
//
FrmAccountsEdit edit = new FrmAccountsEdit();
edit._ParentClient = this;
edit.customeruser = customeruser;
//edit.UserName = fullName;
//edit.ID = ID;
edit.mcust = mcus;
edit.ShowDialog();
CustomerUserLoad();
}
/// <summary>
/// 停用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmDisable_Click(object sender, EventArgs e)
{
try
{
Model_CustomerUser custuser = dataGridView1.SelectedRows[0].Tag as Model_CustomerUser;
custuser.Activedk__BackingField = Enum_Active.Disable;
ResultModelOfModel_CustomerUserd4FqxSXX editcustuser = cs.EditCustomerUser(custuser);
if (editcustuser.Code != 0)
{
MessageBox.Show(editcustuser.Message);
}
else
{
MessageBox.Show("操作成功");
CoumterUserLoad();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (txtDisplayName.Text.Trim() == string.Empty)
{
MessageBox.Show("显示名称不能为空");
return;
}
if (Encoding.Default.GetBytes(txtDisplayName.Text.Trim()).Length > 100)
{
MessageBox.Show("显示名称长度不能超过100");
return;
}
if (txtUserName.Text.Trim() == string.Empty)
{
MessageBox.Show("用户名称不能为空");
return;
}
if (Encoding.Default.GetBytes(txtUserName.Text.Trim()).Length > 50)
{
MessageBox.Show("用户名称长度不能超过50");
return;
}
if (txtPassWord.Text.Trim() == string.Empty)
{
MessageBox.Show("用户密码不能为空");
return;
}
if (Encoding.Default.GetBytes(txtPassWord.Text.Trim()).Length > 200)
{
MessageBox.Show("用户密码不能超过200");
return;
}
Model_CustomerUser user = new Model_CustomerUser();
if (customeruser == null)
{
user.Idk__BackingField = 0;
}
else
{
user.Idk__BackingField = Convert.ToInt32(customeruser.Idk__BackingField.ToString().Trim());
}
user.DisplayNamek__BackingField = txtDisplayName.Text.Trim();
user.UserNamek__BackingField = txtUserName.Text.Trim();
user.Passwordk__BackingField = txtPassWord.Text.Trim();
if (rdbEnabled.Checked == true)
{
user.Activedk__BackingField = Enum_Active.Enabled;
}
else
{
user.Activedk__BackingField = Enum_Active.Disable;
}
if (customeruser == null)
{
user.CreateAtk__BackingField = DateTime.Now;
}
else
{
user.CreateAtk__BackingField = customeruser.CreateAtk__BackingField;
}
//user.CustomerIdk__BackingField = Convert.ToInt32(ID.ToString().Trim());
user.CustomerIdk__BackingField = mcust.Idk__BackingField;
ResultModelOfModel_CustomerUserd4FqxSXX edituser = cs.EditCustomerUser(user);
if (edituser.Code != 0)
{
MessageBox.Show(edituser.Message);
}
else
{
MessageBox.Show("操作成功");
if (mcust.Rolek__BackingField == Enum_Role.Administrator)
{
_ParentFrm.getRenew();
}
else if (mcust.Rolek__BackingField == Enum_Role.Sender)
{
_ParentClient.getRenew();
}
else
{
_ParentMaint.getRenew();
}
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static Model_CustomerUser ChangePassWord(Model_CustomerUser customerUser)
{
string sql = "";
if (customerUser.Id == 0)
{
//查询用户是否存在
Model_CustomerUser user = GetUserName(customerUser);
if (user != null)
{
throw new Exception("用户已存在");
}
}
if (customerUser.Id != 0)
{
//查询管理员账号是否存在一个
Model_Customer custmer = CustomerServer.GetQueryCustomer(customerUser.CustomerId);
if (custmer.Role == Enum_Role.Administrator && customerUser.Actived == Enum_Active.Disable)
{
List <Model_CustomerUser> counts = GetActived(customerUser);
if (counts.Count <= 1)
{
throw new Exception("不能全部停用，至少要存在一个启用账号");
}
}
Model_CustomerUser use = GetPassword(customerUser);
//if (use.CustomerId== customerUser.CustomerId && use.DisplayName== customerUser.DisplayName && use.UserName== customerUser.UserName && use.Password== customerUser.Password && use.CreateAt== customerUser.CreateAt && use.Actived== customerUser.Actived)
// throw new Exception("密码相同，请修改密码");
if (use.UserName != customerUser.UserName)
{
Model_CustomerUser user = GetUserName(customerUser);
if (user != null)
{
throw new Exception("用户已存在");
}
}
if (use.Password.ToUpper() == MyTool.UserMd5(customerUser.Password).ToUpper())
{
throw new Exception("用户密码已存在，请修改密码");
}
}
if (customerUser.Id == 0)
{
sql = "insert into customer_users(customerId,username,password,displayName,createAt,actived) values(?customerId,?username,?password,?displayName,?createAt,?actived)";
}
else
{
sql = "update customer_users set displayName=?displayName,username=?username,password=?password,actived=?actived where id=?id";
}
MySqlParameter[] para = new MySqlParameter[7];
para[0] = new MySqlParameter("customerId", customerUser.CustomerId);
para[1] = new MySqlParameter("username", customerUser.UserName);
if (customerUser.Id != 0)
{
//判断是否修改过密码
Model_CustomerUser use = GetPassword(customerUser);
if (use.Password.ToUpper() == customerUser.Password.ToUpper())
{
para[2] = new MySqlParameter("password", customerUser.Password.ToUpper());
}
else
{
para[2] = new MySqlParameter("password", MyTool.UserMd5(customerUser.Password).ToUpper());
}
}
else
{
para[2] = new MySqlParameter("password", MyTool.UserMd5(customerUser.Password).ToUpper());
}
para[3] = new MySqlParameter("displayName", customerUser.DisplayName);
para[4] = new MySqlParameter("createAt", customerUser.CreateAt);
para[5] = new MySqlParameter("actived", customerUser.Actived);
para[6] = new MySqlParameter("id", customerUser.Id);
int result = 0;
if (customerUser.Id == 0)
{
result = _SqlHelp.ExecuteNonQuery(sql, para);
}
else
{
result = _SqlHelp.ExecuteNonQuery(sql, para);
}
if (result != 1)
{
throw new Exception("操作失败");
}
return(customerUser);
}
