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