private void frmCorView_Load(object sender, EventArgs e)
{
string str = "select * from corInfo where corID='" + corID + "'";
DataSet ds = operate.getTable(str);
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();
label1.Text = ds.Tables[0].Rows[0][10].ToString();
operate.getCorImage(corID, pictureBox1);
}
private void frmCorEdit_Load(object sender, EventArgs e)
{
DialogResult = DialogResult.OK;
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();
operate.getCorImage(corID, pictureBox1);
}
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);
}
