Example #1
0
        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");
        }
Example #2
0
        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("糟糕,出错了!");
            }
        }
Example #3
0
        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 = "";
        }
Example #4
0
        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();
        }
Example #5
0
        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("糟糕,出错了!");
            }
        }