private void ManagerSystem_Load(object sender, EventArgs e)
{
this.tabControl1.SelectedIndex = 1;
string getUsers = "select * from users";
string getMachines = "select * from machines";
//显示管理员信息
DataSet dsUser = DataBaseSys.GetDataSetValue(getUsers, "Tables");
userDataView.DataSource = dsUser.Tables[0];
userDataView.Columns[0].HeaderText = "编号";
userDataView.Columns[1].HeaderText = "管理员";
userDataView.Columns[2].HeaderText = "密码";
userDataView.ReadOnly = true;
dsUser.Dispose();
//显示机种信息
DataSet dsMac = DataBaseSys.GetDataSetValue(getMachines, "Tables");
dsMac.Tables[0].Columns[3].ReadOnly = false;
adressDataView.DataSource = dsMac.Tables[0];
adressDataView.Columns[0].HeaderText = "编号";
adressDataView.Columns[1].HeaderText = "机种号";
adressDataView.Columns[2].HeaderText = "点数";
adressDataView.Columns[3].HeaderText = "坐标";
adressDataView.ReadOnly = true;
dsMac.Dispose();
}
private void buttonSerach_Click(object sender, EventArgs e)
{
string machineGet = textMessage.Text;
string sql = "select * from machines where machineId like'" + machineGet + "%'";
DataSet dsMoHu = DataBaseSys.GetDataSetValue(sql, "Tables");
adressDataView.DataSource = dsMoHu.Tables[0];
if (machineGet == "" || textMessage.ForeColor == SystemColors.InactiveCaption)
{
ManagerSystem_Load(null, null);
}
if (adressDataView.Rows.Count == 0)
{
MessageBox.Show("无类似机种！");
}
}