/// <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; }
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); } }