private void button1_Click(object sender, EventArgs e)
{
String username = this.textBox1.Text;
String password = this.textBox2.Text;
Console.WriteLine(username);
Console.WriteLine(password);
User_service userservice = new User_service();
User user = userservice.getUserByName(username);
Console.WriteLine(user.Username);
Console.WriteLine(user.Password);
Console.WriteLine(user.Limit);
if (username.Equals(user.Username) && password.Equals(user.Password))
{
// String username_search = ;
// Console.WriteLine(password);
if (user.Limit == 1)
{
Form mainform = new manage();
this.Visible = false;
mainform.Show();
}
else
{
Form adminform = new AdminForm();
this.Visible = false;
adminform.Show();
}
}
else if (username.Equals(user.Username) && !password.Equals(user.Password))
{
MessageBox.Show("密码错误请重新输入");
}
else
{
if (username.Length == 0)
{
MessageBox.Show("请填写用户名");
}
else
{
MessageBox.Show("系统找不到该用户");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
UserManage adduser = new UserManage();
if (textBox1.Text == null)
{
MessageBox.Show("用户名不能为空！");
return;
}
else if (textBox5.Text == null)
{
MessageBox.Show("用户密码不能为空！");
return;
}
else if (textBox6.Text == null)
{
MessageBox.Show("用户权限不能为空！");
return;
}
String name = textBox1.Text;
String password = textBox5.Text;
int limit = Convert.ToInt32(textBox6.Text);
int test = adduser.testUser(name);
if (test == 1)
{
MessageBox.Show("用户名已经存在！");
return;
}
int tt = adduser.addUser(name, password, limit);
if (tt == 1)
{
MessageBox.Show("添加成功！", "添加成功");
this.Close();
User_service myservice = new User_service();
IList <User> userlist = myservice.getAllUsers();
dataview.Rows.Clear();
for (int i = 0; i < userlist.Count; i++)
{
User user = userlist[i];
String[] row = { user.Userid.ToString(), user.Username, user.Password, user.Limit.ToString() };
dataview.Rows.Add(row);
}
}
}
private void employee_submit_button_Click(object sender, EventArgs e)
{
Employees employ = new Employees();
employ.Id = Convert.ToInt32(employee_id_textBox.Text);
employ.Name = employee_name_textBox.Text;
employ.Phone = employee_phone_textBox.Text;
employ.Salary = employee_salary_textBox.Text;
employ.Email = employee_salary_textBox.Text;
User_service userservice = new User_service();
if (userservice.Addemployee(employ) > 0)
{
messagebox.Text = "Successfully Added";
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
nameTextbox.Text = this.login.Username;
paswordTextbox.Text = this.login.Password;
User_service service = new User_service();
service.Getlogin();
MessageBox.Show("Successfully login");
username = nameTextbox.Text;
User user = new User();
user.Show();
this.Hide();
// Application.Exit();
//Dispose();
//conn.Close();
}
//初始化数据
public void InitialData()
{
User_service myservice = new User_service();
IList <User> userlist = myservice.getAllUsers();
IList <CangKu> cangkulist = myservice.getAllCangku();
// IList<Product> productlist = myservice.getAllProduct();
this.dataGridView1.Rows.Clear();
//this.dataGridView2.Rows.Clear();
this.Userdataview.Rows.Clear();
for (int i = 0; i < userlist.Count; i++)
{
User user = userlist[i];
String[] row = { user.Userid.ToString(), user.Username, user.Password, user.Limit.ToString() };
this.Userdataview.Rows.Add(row);
}
for (int j = 0; j < cangkulist.Count; j++)
{
CangKu cangku = cangkulist[j];
String[] row1 = { cangku.Cangku_id.ToString(), cangku.Cangku_name };
this.dataGridView1.Rows.Add(row1);
}
/* for (int k = 0; k < productlist.Count;k++ )
* {
* Product product = productlist[k];
* String[] row2 = { product.Pro_id.ToString(),product.Pro_name};
* this.dataGridView2.Rows.Add(row2);
* }
*/
/*
* String connectionString = "server = localhost; database = menagesystem; user id = root; password = 123456;";
* MySqlConnection connection = new MySqlConnection(connectionString);
* String sql = "select *from product";
* DataSet ds = new DataSet();
* MySqlDataAdapter da = new MySqlDataAdapter(sql,connection);
* da.Fill(ds, "product");
* dataGridView2.DataSource = ds.DefaultViewManager;
*/
}
private void pictureBox8_Click(object sender, EventArgs e)
{
User_Entity user = new User_Entity();
user.Name = nameTextbox.Text;
user.Email = EmailTextbox.Text;
user.Username = usernametextbox.Text;
user.Phone = phntextbox.Text;
user.Password = paswrdtextbox.Text;
User_service userservice = new User_service();
if (userservice.Add(user) > 0)
{
MessageBox.Show("Registration successfully");
}
User go = new User();
go.Show();
this.Hide();
}
private void submit_Click(object sender, EventArgs e)
{
User_service service = new User_service();
User_Entity passenger = new User_Entity();
Choch set = new Choch();
passenger.Name = nametextbox.Text;
passenger.Phone = phntextbox.Text;
passenger.Choch_No = Coach.Text;
passenger.Seat_no = membertextbox.Text;
User_service userservice = new User_service();
if (userservice.Add_passrnger(passenger) > 0)
{
MessageBox.Show("passenger add successfully");
}
set.Seat_no = seatnotextbox.Text;
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE Choach SET No_Seat=No_Seat+'" + seatnotextbox.Text + "' where Choach_No='" + Coach.Text + "'";
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Succesfully submitted");
passengername = nametextbox.Text;
date = dateTimePicker.Text;
bus_no = Coach.Text;
seat_member = seatnotextbox.Text;
No_of_seat = membertextbox.Text;
source = fromComboBox.SelectedValue.ToString();
destination = toComboBox.SelectedValue.ToString();
Payment pay = new Payment();
pay.Show();
this.Hide();
}
