コード例 #1
0
        /// <summary>
        /// 添加一行再就业招聘公司发布工作的信息
        /// </summary>
        /// <param name="provideJob">公司发布工作信息实体</param>
        /// <returns>成功返回刚刚插入信息的主键id 否则返回0</returns>
        public static int AddProvideJob(ProvideJob provideJob)
        {
            int iExecute = 0;
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into T_ProvJob (");
                strSql.Append(" CompanyId,JobId,Nums,Salary,Request,AddTime,State");
                strSql.Append(") values(");
                strSql.Append("@CompanyId,@JobId,@Nums,@Salary,@Request,@AddTime,@State");
                strSql.Append(");select @@IDENTITY");
                SqlParameter[] para = new SqlParameter[]
                {
                new SqlParameter("@CompanyId",SqlDbType.Int),
                new SqlParameter("@JobId",SqlDbType.Int),
                new SqlParameter("@Nums",SqlDbType.Int),
                new SqlParameter("@Salary",SqlDbType.Int),
                new SqlParameter("@Request",SqlDbType.NVarChar,200),
                new SqlParameter("@AddTime",SqlDbType.NVarChar,50),
                new SqlParameter("@State",SqlDbType.Int),

                };
                para[0].Value = provideJob.CompanyId;
                para[1].Value = provideJob.JobId;
                para[2].Value = provideJob.Nums;
                para[3].Value = provideJob.Salary;
                para[4].Value = provideJob.Request;
                para[5].Value = provideJob.AddTime;
                para[6].Value = provideJob.State;

                object obj = DbHelperSQL.GetSingle(strSql.ToString(), para);
                if (obj != null)
                {
                    iExecute = Convert.ToInt32(obj);
                }

            }
            catch (Exception e)
            {
                Log4Net.LogWrite("err", "Ctrl_Ass_CompanyAndJob:AddProvideJob" + e.Message);
            }
            return iExecute;
        }
コード例 #2
0
ファイル: Job_Admin.aspx.cs プロジェクト: wawa0210/jgq
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            ProvideJob provideJob = new ProvideJob();
            provideJob.JobId = int.Parse(drpJob.SelectedValue);
            if (int.Parse(drpJob.SelectedValue) == 0)
            {
                MessageBox.Show(this, "请选择岗位类别");
                return;
            }
            provideJob.CompanyId = companyId;
            provideJob.Salary = this.txtSalary.Text.Trim();
            provideJob.Nums = int.Parse(this.txtNums.Text.Trim());
            provideJob.Request = this.txtRequest.Value.Trim();
            provideJob.AddTime = DateTime.Now.ToString();
            provideJob.State = 0;

            if (Ctrl_Ass_CompanyAndJob.AddProvideJob(provideJob) != 0)
            {
                MessageBox.Show(this, "新增工作成功");
                BindJobInfo(companyId);
            }
        }