private void bindDataList()
{
CommonClass cc = new CommonClass();
this.dataGridView2.DataSource = cc.reDt("select applyDate as 宣讲日期,applyTime as 宣讲时间,companyName as 单位名称,"+
"applyAddress as 宣讲会场地,companyAddress as 公司地址,companyCode as 邮政编码,companyContacts as 用人单位联系人,"+
"companyMobile as 手机,companyPhone as 办公电话,companyTax as 传真,companyEmail as 电子邮箱,agentName as 人才中介公司,"+
"agentContacts as 联系人,agentPhone as 联系电话,agentEmail as 电子邮箱,confirmer as 就业中心确认人,"+
"messageStatus as 发布信息状态,supportNeed as 需要支持事项,fareStatus as 收费情况,add_remove as 增加_删除,"+
"remark as 备注 from applyList");
}
private void comfirmSubmit_Click(object sender, EventArgs e)
{
CommonClass cc = new CommonClass();
if (cc.sqlEx("update applyList set confirmer='"+confirmer.Text.Trim()+
"',messageStatus = '"+messageStatus.Text.Trim()+
"',supportNeed='"+supportNeed.Text.Trim()+
"',fareStatus='"+fareStatus.Text.Trim()+
"',add_remove='"+add_remove.Text.Trim()+
"',remark='"+remark.Text.Trim()+
"',status='审核通过' where id='"+index+"' and status='待审核' ") > 0)
{
MessageBox.Show("确认申请成功!");
bind();
}
else
{
MessageBox.Show("糟糕，出错了!");
}
}
private void bind()
{
CommonClass cc = new CommonClass();
this.dataGridView1.DataSource = cc.reDt("select id,applier,submitDate from applyList where status='待审核' order by submitDate desc ");
this.dataGridView1.Columns[0].HeaderText = "编号";
this.dataGridView1.Columns[1].HeaderText = "申请人";
this.dataGridView1.Columns[2].HeaderText = "申请日期";
this.confirmer.Text = "";
this.messageStatus.Text = "";
this.supportNeed.Text = "";
this.fareStatus.Text = "";
this.add_remove.Text = "";
this.remark.Text = "";
}
private void showDetail(string id)
{
CommonClass cc = new CommonClass();
DataTable dt = cc.reDt("select * from applyList where id='"+id+"'");
this.companyName.Text = dt.Rows[0].ItemArray[1].ToString();
this.companyCode.Text = dt.Rows[0].ItemArray[2].ToString();
this.companyAddress.Text = dt.Rows[0].ItemArray[3].ToString();
this.companyContacts.Text = dt.Rows[0].ItemArray[4].ToString();
this.companyDeparture.Text = dt.Rows[0].ItemArray[5].ToString();
this.companyEmail.Text = dt.Rows[0].ItemArray[6].ToString();
this.companyPhone.Text = dt.Rows[0].ItemArray[7].ToString();
this.companyMobile.Text = dt.Rows[0].ItemArray[8].ToString();
this.companyTax.Text = dt.Rows[0].ItemArray[9].ToString();
this.agentContacts.Text = dt.Rows[0].ItemArray[10].ToString();
this.agentName.Text = dt.Rows[0].ItemArray[11].ToString();
this.agentEmail.Text = dt.Rows[0].ItemArray[12].ToString();
this.agentPhone.Text = dt.Rows[0].ItemArray[13].ToString();
this.agentMobile.Text = dt.Rows[0].ItemArray[14].ToString();
this.applyAddress.Text = dt.Rows[0].ItemArray[15].ToString();
this.applyDate.Text = dt.Rows[0].ItemArray[16].ToString();
this.applyTime.Text = dt.Rows[0].ItemArray[17].ToString();
}
private void rejectApply_Click(object sender, EventArgs e)
{
CommonClass cc = new CommonClass();
if (cc.sqlEx("update applyList set status='审核不通过' where id='" + index + "' and status='待审核' ") > 0)
{
MessageBox.Show("拒绝申请成功!");
bind();
}
else
{
MessageBox.Show("糟糕，出错了!");
}
}