protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["JobID"] != null)
{
if (Request.QueryString["JobID"].ToString() != "")
{
int jobid = int.Parse(Request.QueryString["JobID"].ToString());
Maticsoft.BLL.JobInfo jobbll = new Maticsoft.BLL.JobInfo();
Maticsoft.Model.JobInfo jobmodel = jobbll.GetModel(jobid);
lblAge.Text = jobmodel.Age;
lblDuxiang.Text = jobmodel.Duxiang;
lblEndtime.Text = Convert.ToDateTime(jobmodel.Endtime.ToString()).ToString("yyyy-MM-dd");
lblJobTitle.Text = jobmodel.JobTitle;
lblLianxi.Text = jobmodel.Lianxi;
lblMiaoshu.Text = jobmodel.Miaoshu;
lblMonery.Text = jobmodel.Monery;
lblXueli.Text = jobmodel.Xueli;
lblZhuanye.Text = jobmodel.Zhuanye;
}
else
{
Response.Redirect("job.aspx");
}
}
else
{
Response.Redirect("job.aspx");
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.JobInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JobInfo set ");
strSql.Append("JobTitle=@JobTitle,");
strSql.Append("Address=@Address,");
strSql.Append("Nunber=@Nunber,");
strSql.Append("Starttime=@Starttime,");
strSql.Append("Duxiang=@Duxiang,");
strSql.Append("Age=@Age,");
strSql.Append("Xueli=@Xueli,");
strSql.Append("Monery=@Monery,");
strSql.Append("Zhuanye=@Zhuanye,");
strSql.Append("Endtime=@Endtime,");
strSql.Append("Miaoshu=@Miaoshu,");
strSql.Append("Lianxi=@Lianxi");
strSql.Append(" where JobID=@JobID");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.Int, 4),
new SqlParameter("@JobTitle", SqlDbType.VarChar, 200),
new SqlParameter("@Address", SqlDbType.Text),
new SqlParameter("@Nunber", SqlDbType.VarChar, 200),
new SqlParameter("@Starttime", SqlDbType.DateTime),
new SqlParameter("@Duxiang", SqlDbType.VarChar, 200),
new SqlParameter("@Age", SqlDbType.VarChar, 200),
new SqlParameter("@Xueli", SqlDbType.VarChar, 200),
new SqlParameter("@Monery", SqlDbType.VarChar, 200),
new SqlParameter("@Zhuanye", SqlDbType.VarChar, 200),
new SqlParameter("@Endtime", SqlDbType.DateTime),
new SqlParameter("@Miaoshu", SqlDbType.Text),
new SqlParameter("@Lianxi", SqlDbType.Text)
};
parameters[0].Value = model.JobID;
parameters[1].Value = model.JobTitle;
parameters[2].Value = model.Address;
parameters[3].Value = model.Nunber;
parameters[4].Value = model.Starttime;
parameters[5].Value = model.Duxiang;
parameters[6].Value = model.Age;
parameters[7].Value = model.Xueli;
parameters[8].Value = model.Monery;
parameters[9].Value = model.Zhuanye;
parameters[10].Value = model.Endtime;
parameters[11].Value = model.Miaoshu;
parameters[12].Value = model.Lianxi;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.JobInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into JobInfo(");
strSql.Append("JobTitle,Address,Nunber,Starttime,Duxiang,Age,Xueli,Monery,Zhuanye,Endtime,Miaoshu,Lianxi)");
strSql.Append(" values (");
strSql.Append("@JobTitle,@Address,@Nunber,@Starttime,@Duxiang,@Age,@Xueli,@Monery,@Zhuanye,@Endtime,@Miaoshu,@Lianxi)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@JobTitle", SqlDbType.VarChar, 200),
new SqlParameter("@Address", SqlDbType.Text),
new SqlParameter("@Nunber", SqlDbType.VarChar, 200),
new SqlParameter("@Starttime", SqlDbType.DateTime),
new SqlParameter("@Duxiang", SqlDbType.VarChar, 200),
new SqlParameter("@Age", SqlDbType.VarChar, 200),
new SqlParameter("@Xueli", SqlDbType.VarChar, 200),
new SqlParameter("@Monery", SqlDbType.VarChar, 200),
new SqlParameter("@Zhuanye", SqlDbType.VarChar, 200),
new SqlParameter("@Endtime", SqlDbType.DateTime),
new SqlParameter("@Miaoshu", SqlDbType.Text),
new SqlParameter("@Lianxi", SqlDbType.Text)
};
parameters[0].Value = model.JobTitle;
parameters[1].Value = model.Address;
parameters[2].Value = model.Nunber;
parameters[3].Value = model.Starttime;
parameters[4].Value = model.Duxiang;
parameters[5].Value = model.Age;
parameters[6].Value = model.Xueli;
parameters[7].Value = model.Monery;
parameters[8].Value = model.Zhuanye;
parameters[9].Value = model.Endtime;
parameters[10].Value = model.Miaoshu;
parameters[11].Value = model.Lianxi;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.JobInfo GetModel(int JobID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JobID,JobTitle,Address,Nunber,Starttime,Duxiang,Age,Xueli,Monery,Zhuanye,Endtime,Miaoshu,Lianxi from JobInfo ");
strSql.Append(" where JobID=@JobID");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.Int, 4)
};
parameters[0].Value = JobID;
Maticsoft.Model.JobInfo model = new Maticsoft.Model.JobInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["JobID"].ToString() != "")
{
model.JobID = int.Parse(ds.Tables[0].Rows[0]["JobID"].ToString());
}
model.JobTitle = ds.Tables[0].Rows[0]["JobTitle"].ToString();
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
model.Nunber = ds.Tables[0].Rows[0]["Nunber"].ToString();
if (ds.Tables[0].Rows[0]["Starttime"].ToString() != "")
{
model.Starttime = DateTime.Parse(ds.Tables[0].Rows[0]["Starttime"].ToString());
}
model.Duxiang = ds.Tables[0].Rows[0]["Duxiang"].ToString();
model.Age = ds.Tables[0].Rows[0]["Age"].ToString();
model.Xueli = ds.Tables[0].Rows[0]["Xueli"].ToString();
model.Monery = ds.Tables[0].Rows[0]["Monery"].ToString();
model.Zhuanye = ds.Tables[0].Rows[0]["Zhuanye"].ToString();
if (ds.Tables[0].Rows[0]["Endtime"].ToString() != "")
{
model.Endtime = DateTime.Parse(ds.Tables[0].Rows[0]["Endtime"].ToString());
}
model.Miaoshu = ds.Tables[0].Rows[0]["Miaoshu"].ToString();
model.Lianxi = ds.Tables[0].Rows[0]["Lianxi"].ToString();
return(model);
}
else
{
return(null);
}
}
private void ShowInfo(int JobID)
{
Maticsoft.BLL.JobInfo bll = new Maticsoft.BLL.JobInfo();
Maticsoft.Model.JobInfo model = bll.GetModel(JobID);
this.lblJobID.Text = model.JobID.ToString();
this.lblJobTitle.Text = model.JobTitle;
this.lblAddress.Text = model.Address;
this.lblNunber.Text = model.Nunber;
this.lblStarttime.Text = model.Starttime.ToString();
this.lblDuxiang.Text = model.Duxiang;
this.lblAge.Text = model.Age;
this.lblXueli.Text = model.Xueli;
this.lblMonery.Text = model.Monery;
this.lblZhuanye.Text = model.Zhuanye;
this.lblEndtime.Text = model.Endtime.ToString();
this.lblMiaoshu.Text = model.Miaoshu;
this.lblLianxi.Text = model.Lianxi;
}
private void bind()
{
Maticsoft.BLL.JobInfo jobbll = new Maticsoft.BLL.JobInfo();
int jobid = int.Parse(Request.QueryString["JobID"].ToString());
Maticsoft.Model.JobInfo jobmodel = jobbll.GetModel(jobid);
txtAddress.Text = jobmodel.Address;
txtage.Text = jobmodel.Age;
txtduxiang.Text = jobmodel.Duxiang;
txtEndtime.Text = Convert.ToDateTime(jobmodel.Endtime.ToString()).ToString("yyyy-MM-dd");
txtJobTitleName.Text = jobmodel.JobTitle;
txtlink.Text = jobmodel.Lianxi;
txtmiaoshu.Text = jobmodel.Miaoshu;
txtmonery.Text = jobmodel.Monery;
txtNunber.Text = jobmodel.Nunber;
txttime.Text = Convert.ToDateTime(jobmodel.Starttime.ToString()).ToString("yyyy-MM-dd");
txtxueli.Text = jobmodel.Xueli;
txtzhuangye.Text = jobmodel.Zhuanye;
}
private void bind()
{
Maticsoft.BLL.JobInfo jobbll = new Maticsoft.BLL.JobInfo();
int jobid = int.Parse(Request.QueryString["JobID"].ToString());
Maticsoft.Model.JobInfo jobmodel = jobbll.GetModel(jobid);
lbladdress.Text = jobmodel.Address;
lblage.Text = jobmodel.Age;
lblduxiang.Text = jobmodel.Duxiang;
lblendtime.Text = Convert.ToDateTime(jobmodel.Endtime.ToString()).ToString("yyyy-MM-dd");
lblmonery.Text = jobmodel.Monery;
lblnum.Text = jobmodel.Nunber;
lbltime.Text = Convert.ToDateTime(jobmodel.Starttime.ToString()).ToString("yyyy-MM-dd");
lblxueli.Text = jobmodel.Xueli;
lblzhiwei.Text = jobmodel.JobTitle;
lblzhuanye.Text = jobmodel.Zhuanye;
txtlianxi.Text = jobmodel.Lianxi;
txtmiaoshu.Text = jobmodel.Miaoshu;
}
protected void Button1_Click(object sender, EventArgs e)
{
Maticsoft.BLL.JobInfo jobbll = new Maticsoft.BLL.JobInfo();
int jobid = int.Parse(Request.QueryString["JobID"].ToString());
Maticsoft.Model.JobInfo jobmodel = jobbll.GetModel(jobid);
if (txtJobTitleName.Text.Trim() == "")
{
lbljobtitle.Text = "请填写应聘职位";
return;
}
jobmodel.JobTitle = txtJobTitleName.Text.Trim();
lbljobtitle.Text = "";
if (txtAddress.Text.Trim() == "")
{
lblAddress.Text = "请填写工作地址";
return;
}
jobmodel.Address = txtAddress.Text.Trim();
lblAddress.Text = "";
if (txtNunber.Text.Trim() == "")
{
lblNumber.Text = "请填写您招聘人数";
return;
}
jobmodel.Nunber = txtNunber.Text.Trim();
lblNumber.Text = "";
if (txttime.Text.Trim() == "")
{
lblstarttime.Text = "请填写招聘时间";
return;
}
jobmodel.Starttime = Convert.ToDateTime(txttime.Text.Trim());
lblstarttime.Text = "";
if (txtduxiang.Text.Trim() == "")
{
lblduxiang.Text = "填写招聘对象";
return;
}
jobmodel.Duxiang = txtduxiang.Text.Trim();
lblduxiang.Text = "";
if (txtage.Text.Trim() == "")
{
lblage.Text = "请填写应聘者年龄";
return;
}
jobmodel.Age = txtage.Text.Trim();
lblage.Text = "";
if (txtxueli.Text.Trim() == "")
{
lblxueli.Text = "请填写学历要求";
return;
}
jobmodel.Xueli = txtxueli.Text.Trim();
lblxueli.Text = "";
if (txtmonery.Text.Trim() == "")
{
lblmonery.Text = "请填写薪水要求";
return;
}
jobmodel.Monery = txtmonery.Text.Trim();
lblmonery.Text = "";
if (txtzhuangye.Text.Trim() == "")
{
lblzhuanye.Text = "请填写专业要求";
return;
}
jobmodel.Zhuanye = txtzhuangye.Text.Trim();
lblzhuanye.Text = "";
if (txtEndtime.Text.Trim() == "")
{
lblEndtime.Text = "请填写结束时间";
return;
}
jobmodel.Endtime = Convert.ToDateTime(txtEndtime.Text.Trim());
lblEndtime.Text = "";
jobmodel.Miaoshu = txtmiaoshu.Text.Trim();
jobmodel.Lianxi = txtlink.Text.Trim();
jobbll.Update(jobmodel);
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('信息添加成功！')</script>");
bind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtJobTitle.Text.Trim().Length == 0)
{
strErr += "JobTitle不能为空！\\n";
}
if (this.txtAddress.Text.Trim().Length == 0)
{
strErr += "Address不能为空！\\n";
}
if (this.txtNunber.Text.Trim().Length == 0)
{
strErr += "Nunber不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtStarttime.Text))
{
strErr += "Starttime格式错误！\\n";
}
if (this.txtDuxiang.Text.Trim().Length == 0)
{
strErr += "Duxiang不能为空！\\n";
}
if (this.txtAge.Text.Trim().Length == 0)
{
strErr += "Age不能为空！\\n";
}
if (this.txtXueli.Text.Trim().Length == 0)
{
strErr += "Xueli不能为空！\\n";
}
if (this.txtMonery.Text.Trim().Length == 0)
{
strErr += "Monery不能为空！\\n";
}
if (this.txtZhuanye.Text.Trim().Length == 0)
{
strErr += "Zhuanye不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtEndtime.Text))
{
strErr += "Endtime格式错误！\\n";
}
if (this.txtMiaoshu.Text.Trim().Length == 0)
{
strErr += "Miaoshu不能为空！\\n";
}
if (this.txtLianxi.Text.Trim().Length == 0)
{
strErr += "Lianxi不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string JobTitle = this.txtJobTitle.Text;
string Address = this.txtAddress.Text;
string Nunber = this.txtNunber.Text;
DateTime Starttime = DateTime.Parse(this.txtStarttime.Text);
string Duxiang = this.txtDuxiang.Text;
string Age = this.txtAge.Text;
string Xueli = this.txtXueli.Text;
string Monery = this.txtMonery.Text;
string Zhuanye = this.txtZhuanye.Text;
DateTime Endtime = DateTime.Parse(this.txtEndtime.Text);
string Miaoshu = this.txtMiaoshu.Text;
string Lianxi = this.txtLianxi.Text;
Maticsoft.Model.JobInfo model = new Maticsoft.Model.JobInfo();
model.JobTitle = JobTitle;
model.Address = Address;
model.Nunber = Nunber;
model.Starttime = Starttime;
model.Duxiang = Duxiang;
model.Age = Age;
model.Xueli = Xueli;
model.Monery = Monery;
model.Zhuanye = Zhuanye;
model.Endtime = Endtime;
model.Miaoshu = Miaoshu;
model.Lianxi = Lianxi;
Maticsoft.BLL.JobInfo bll = new Maticsoft.BLL.JobInfo();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
