private void Btn_Cancel_Click(object sender, RoutedEventArgs e)
{
getTableData();
TBid.Clear();
TBname.Clear();
TBPass.Clear();
Region.SelectedItem = new KeyValuePair <int, string>(0, "请选择仓库");
}
private void BOK_Click(object sender, EventArgs e)
{
string Password = null;
if (TBLog.Text.Length == 0 || TBPass.Text.Length == 0)
{
MessageBox.Show("Заполните поля", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (File.Exists("../../UsrList.sys"))
{
FileStream UsrList = new FileStream("../../UsrList.sys", FileMode.Open, FileAccess.Read);
StreamReader reader = new StreamReader(UsrList);
do
{
if (reader.ReadLine() == "[" + TBLog.Text + "]")
{
Password = reader.ReadLine();
break;
}
} while (!reader.EndOfStream);
if (Password == null)
{
MessageBox.Show("Такого пользователя не существует", "Ошибка авторизации", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (Password == TBPass.Text)
{
reader.Close();
MainWindow MW = new MainWindow(this, TBLog.Text);
Visible = false;
TBPass.Clear();
MW.Show();//Вход выполнен
}
else
{
MessageBox.Show("Неверный пароль", "Ошибка авторизации", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
else
{
MessageBox.Show("Не найден файл базы данных пользоватлей", "Критическая ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
}
}
/// <summary>
/// 写入数据库
/// </summary>
public void inputDB()
{
try
{
string sql = "";
string id_staff, name_staff, pass_staff, role_staff, Region_staff;
DataSet ds = new DataSet();
Region_staff = Region.SelectedValue.ToString();
if (Region_staff.Equals("0"))
{
MessageBox.Show("请选择所在网点");
return;
}
//Id = BaseClass.getInsertMaxId("T_Weight", "Id", "000001");
if (TBid.Text != "")
{
id_staff = TBid.Text;
}
else
{
id_staff = "";
MessageBox.Show("请输入员工编号");
return;
}
if (TBname.Text != "")
{
name_staff = TBname.Text;
}
else
{
name_staff = "";
MessageBox.Show("请输入员工姓名");
return;
}
if (TBPass.Text != "")
{
pass_staff = TBPass.Text;
}
else
{
pass_staff = "";
MessageBox.Show("请输入密码");
return;
}
sql = "select * from t_staff as t1 where t1.id_staff = '" + id_staff + "'";
ds = DBClass.execQuery(sql);
if (ds.Tables[0].Rows.Count > 0)
{
sql = "update T_Staff set name_staff = '{1}', pass_staff = '{2}', " +
"role_staff = '{3}', region_staff = '{4}' " +
"where id_staff = '{0}'";
}
else
{
sql = "insert into T_Staff " +
"(id_staff, name_staff, pass_staff, role_staff, Region_staff) " +
"values ('{0}','{1}','{2}','{3}','{4}')";
}
role_staff = "1";
sql = string.Format(sql, id_staff, name_staff, pass_staff, role_staff, Region_staff);
int n = DBClass.execUpdate(sql);
if (n > 0)
{
MessageBox.Show("保存成功！");
TBid.Clear();
TBname.Clear();
TBPass.Clear();
}
}
catch (Exception e)
{
MessageBox.Show("操作失败。请重试" + e.Message);
}
}
private void TBPass_Click(object sender, EventArgs e)
{
TBPass.Clear();
}
