private void button1_Click(object sender, EventArgs e)
{
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = "server=localhost;uid=root;pwd=12345;database=db",
DbType = SqlSugar.DbType.MySql, //设置数据库类型
IsAutoCloseConnection = true, //自动释放数据务，如果存在事务，在事务结束后释放
InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息
});
var result = db.Updateable <merchants>().SetColumns(it => it.m_catalog == comboBox1.SelectedItem)
.Where(it => it.m_id == current_id)
.ExecuteCommand();
var result1 = db.Updateable <merchants>().SetColumns(it => it.m_name == textBox1.Text)
.Where(it => it.m_id == current_id)
.ExecuteCommand();
var result2 = db.Updateable <merchants>().SetColumns(it => it.m_address == textBox2.Text)
.Where(it => it.m_id == current_id)
.ExecuteCommand();
var result3 = db.Updateable <merchants>().SetColumns(it => it.m_describe == textBox3.Text)
.Where(it => it.m_id == current_id)
.ExecuteCommand();
this.Hide();
Merchant_sys merchant = new Merchant_sys(login_window, current_id);
merchant.Show();
this.Hide();
}
private void Denglu_Click(object sender, EventArgs e) // 按下登陆键
{
string id = id_shuru.Text; // 获取用户输入的账号
int option = option_list.SelectedIndex; // 用户选择
switch (option)
{
case 0: // 用户端
SqlSugarClient db_login = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = "server=localhost;uid=root;pwd=12345;database=db",
DbType = SqlSugar.DbType.MySql, //设置数据库类型
IsAutoCloseConnection = true, //自动释放数据务，如果存在事务，在事务结束后释放
InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息
});
string correct_password = "******";
try
{
var getByWhere = db_login.Queryable <users>().Where(it => it.u_zhanghao == id).ToList(); //根据条件查询
correct_password = getByWhere[0].u_passwd;
}
catch (Exception)
{
MessageBox.Show("输入的账号或密码有误");
}
if (password_shuru.Text == correct_password) //密码正确
{
User_sys user = new User_sys(this); // 打开用户界面
this.Hide();
user.Show();
}
break;
case 1: // 商家端
SqlSugarClient db_login1 = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = "server=localhost;uid=root;pwd=12345;database=db",
DbType = SqlSugar.DbType.MySql, //设置数据库类型
IsAutoCloseConnection = true, //自动释放数据务，如果存在事务，在事务结束后释放
InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息
});
string correct_password1 = "-1";
try
{
var getByWhere1 = db_login1.Queryable <merchants>().Where(it => it.m_identity == id).ToList(); //根据条件查询
correct_password1 = getByWhere1[0].m_password;
}
catch (Exception)
{
MessageBox.Show("输入的账号或密码有误");
}
if (password_shuru.Text == correct_password1) //密码正确
{
Merchant_sys merchant = new Merchant_sys(this, id_shuru.Text); // 打开用户界面
this.Hide();
merchant.Show();
}
break;
case 2: // 管理端
string correct_password2 = "1234567"; // 管理端admin，密码1234567
if (password_shuru.Text == correct_password2 && id == "admin") //密码正确
{
admin admin = new admin(this);
this.Hide();
admin.Show();
}
else
{
MessageBox.Show("输入的账号或密码有误");
}
break;
}
}
