private void frmStudent_Load(object sender, EventArgs e)
{
operate.getImage(stuID, pictureBox1);
stuIDValue.Text = stuID;
DataSet ds = operate.getTable("select * from stuInfo where stuID='" + stuID + "'");
ds.Dispose();
stuNameValue.Text = ds.Tables[0].Rows[0][1].ToString();
stuFmrNameValue.Text = ds.Tables[0].Rows[0][3].ToString();
stuSexValue.Text = ds.Tables[0].Rows[0][4].ToString();
stuBirthValue.Text = ds.Tables[0].Rows[0][5].ToString();
stuNationValue.Text = ds.Tables[0].Rows[0][6].ToString();
stuPoliValue.Text = ds.Tables[0].Rows[0][7].ToString();
stuResValue.Text = ds.Tables[0].Rows[0][8].ToString();
stuIDCValue.Text = ds.Tables[0].Rows[0][9].ToString();
stuWorkPlaceValue.Text = ds.Tables[0].Rows[0][10].ToString();
stuPCValue.Text = ds.Tables[0].Rows[0][11].ToString();
stuWorkTelValue.Text = ds.Tables[0].Rows[0][12].ToString();
stuAddValue.Text = ds.Tables[0].Rows[0][13].ToString();
stuTelValue.Text = ds.Tables[0].Rows[0][14].ToString();
stuExpValue.Text = ds.Tables[0].Rows[0][15].ToString();
stuPrzCrtValue.Text = ds.Tables[0].Rows[0][16].ToString();
string dgvs = "select id as '编号',reqType as '申请类型',reqDate as '申请日期',reqResult as '申请结果',conDate as '申核日期' from requestInfo where reqPeople='" + stuNameValue.Text + "'";
operate.bindDataGridView(dataGridView1, dgvs);
dgvs = "select corID as '企业编号',corName as '企业名',corTel as '企业电话',corAdd as '企业地址' from corInfo";
operate.bindDataGridView(dataGridView2, dgvs);
label3.Text = ds.Tables[0].Rows[0][2].ToString();
}
private void frmTeacher_Load(object sender, EventArgs e)
{
string str = "select stuID as '学号',stuName as '姓名',stuSex as '性别',stuNation as '民族',stuTel as '联系电话',stuAdd as '家庭住址' from stuInfo";
operate.bindDataGridView(dataGridView1, str);
str = "select id as '编号', reqType as '申请类型',reqDate as '提交日期',reqResult as '申核结果' from requestInfo where reqContent like '%" + name + "%'";
operate.bindDataGridView(dataGridView2, str);
}
private void frmCorporation_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = operate.getTable("select * from corInfo where corID='" + corID + "'");
ds.Dispose();
corIDValue.Text = corID;
corNameValue.Text = ds.Tables[0].Rows[0][1].ToString();
corResPersonValue.Text = ds.Tables[0].Rows[0][2].ToString();
corRegAddValue.Text = ds.Tables[0].Rows[0][3].ToString();
corTelValue.Text = ds.Tables[0].Rows[0][4].ToString();
corPersonValue.Text = ds.Tables[0].Rows[0][5].ToString();
corPersonTelValue.Text = ds.Tables[0].Rows[0][6].ToString();
corPersonEmailValue.Text = ds.Tables[0].Rows[0][7].ToString();
corConValue.Text = ds.Tables[0].Rows[0][8].ToString();
corAddValue.Text = ds.Tables[0].Rows[0][9].ToString();
corAuthValue.Text = ds.Tables[0].Rows[0][11].ToString();
operate.getCorImage(corID, pictureBox1);
if (corAuthValue.Text == "否")
{
reqContentKey.Text = "申请内容";
reqIDValue.Visible = false;
reqContentValue.Visible = true;
reqTypeValue.Items.Add("认证申请");
}
else
{
reqIDValue.Visible = true;
reqTypeValue.Items.Add("申请查看学生");
reqContentKey.Text = "学号";
reqContentValue.Visible = false;
reqTypeValue.Items.Remove("认证申请");
}
string str = "select id as '编号',reqType as '申请类型',reqDate as '申请日期',reqResult as '申请结果'from requestInfo where reqPeople='" + corNameValue.Text + "'";
operate.bindDataGridView(dataGridView1, str);
}
private void frmAdmin_Load(object sender, EventArgs e)
{
string str = "select id as '编号',userID as '用户编号',userName as '用户名',userAuth as '用户权限',lastLogin as '上次登陆时间'from userInfo";
operate.bindDataGridView(dataGridView1, str);
}