private void ShowInfo(int Id)
{
Cms.DAL.JobInfo dal = new Cms.DAL.JobInfo();
Cms.Model.JobInfo model = dal.GetModel(Id);
this.position.Text = Cms.Common.Utils.ToTxt(model.Position);
this.headCount.Text = model.HeadCount.ToString();
this.requirement.Text = Cms.Common.Utils.ToTxt(model.Requirement);
this.responsibility.Text = Cms.Common.Utils.ToTxt(model.Responsibility);
this.jobOrder.Text = model.JobOrder.ToString();
jobIsLock.SelectedValue = model.IsLock.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Cms.Model.JobInfo GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JobID,Position,Requirement,Responsibility,HeadCount,IsLock,JobOrder from JobList ");
strSql.Append(" where JobID=@JobID");
SqlParameter[] parameters =
{
new SqlParameter("@JobID", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Cms.Model.JobInfo model = new Cms.Model.JobInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["JobID"] != null && ds.Tables[0].Rows[0]["JobID"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["JobID"].ToString());
}
if (ds.Tables[0].Rows[0]["Position"] != null && ds.Tables[0].Rows[0]["Position"].ToString() != "")
{
model.Position = ds.Tables[0].Rows[0]["Position"].ToString();
}
if (ds.Tables[0].Rows[0]["Requirement"] != null && ds.Tables[0].Rows[0]["Requirement"].ToString() != "")
{
model.Requirement = ds.Tables[0].Rows[0]["Requirement"].ToString();
}
if (ds.Tables[0].Rows[0]["Responsibility"] != null && ds.Tables[0].Rows[0]["Responsibility"].ToString() != "")
{
model.Responsibility = ds.Tables[0].Rows[0]["Responsibility"].ToString();
}
if (ds.Tables[0].Rows[0]["HeadCount"] != null && ds.Tables[0].Rows[0]["HeadCount"].ToString() != "")
{
model.HeadCount = int.Parse(ds.Tables[0].Rows[0]["HeadCount"].ToString());
}
if (ds.Tables[0].Rows[0]["IsLock"] != null && ds.Tables[0].Rows[0]["IsLock"].ToString() != "")
{
model.IsLock = int.Parse(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
if (ds.Tables[0].Rows[0]["JobOrder"] != null && ds.Tables[0].Rows[0]["JobOrder"].ToString() != "")
{
model.JobOrder = int.Parse(ds.Tables[0].Rows[0]["JobOrder"].ToString());
}
return(model);
}
else
{
return(null);
}
}
//编辑操作
protected void btnSave_Click(object sender, EventArgs e)
{
Cms.Model.JobInfo model = new Cms.Model.JobInfo();
model.Id = this.JobID;
model.Position = Cms.Common.Utils.ToHtml(this.position.Text);
model.Responsibility = Cms.Common.Utils.ToHtml(this.responsibility.Text);
model.HeadCount = int.Parse(this.headCount.Text);
model.Requirement = Cms.Common.Utils.ToHtml(this.requirement.Text);
model.IsLock = Convert.ToInt32(jobIsLock.SelectedValue);
model.JobOrder = int.Parse(this.jobOrder.Text);
Cms.DAL.JobInfo dal = new Cms.DAL.JobInfo();
dal.Update(model);
////保存日志
MessageBox.Show(this, "招聘编辑成功！");
}
//编辑操作
protected void btnSave_Click(object sender, EventArgs e)
{
Cms.Model.JobInfo model = new Cms.Model.JobInfo();
model.Id = this.JobID;
model.Position = Cms.Common.Utils.ToHtml(this.position.Text);
model.Responsibility = Cms.Common.Utils.ToHtml(this.responsibility.Text);
model.HeadCount = int.Parse(this.headCount.Text);
model.Requirement = Cms.Common.Utils.ToHtml(this.requirement.Text);
model.IsLock = Convert.ToInt32(jobIsLock.SelectedValue);
model.JobOrder = int.Parse(this.jobOrder.Text);
Cms.DAL.JobInfo dal = new Cms.DAL.JobInfo();
dal.Update(model);
////保存日志
MessageBox.Show(this, "招聘编辑成功！");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Cms.Model.JobInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update JobList set ");
strSql.Append("Position=@Position,");
strSql.Append("Requirement=@Requirement,");
strSql.Append("Responsibility=@Responsibility,");
strSql.Append("HeadCount=@HeadCount,");
strSql.Append("IsLock=@IsLock,");
strSql.Append("JobOrder=@JobOrder");
strSql.Append(" where JobID=@JobID");
SqlParameter[] parameters =
{
new SqlParameter("@Position", SqlDbType.NVarChar, 50),
new SqlParameter("@Requirement", SqlDbType.NText),
new SqlParameter("@Responsibility", SqlDbType.NText),
new SqlParameter("@HeadCount", SqlDbType.Int, 4),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@JobOrder", SqlDbType.Int, 4),
new SqlParameter("@JobID", SqlDbType.Int, 4)
};
parameters[0].Value = model.Position;
parameters[1].Value = model.Requirement;
parameters[2].Value = model.Responsibility;
parameters[3].Value = model.HeadCount;
parameters[4].Value = model.IsLock;
parameters[5].Value = model.JobOrder;
parameters[6].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(((Label)e.Item.FindControl("lb_id")).Text);
Cms.DAL.JobInfo dal = new Cms.DAL.JobInfo();
Cms.Model.JobInfo model = dal.GetModel(id);
switch (e.CommandName.ToLower())
{
case "ibtnlock":
if (model.IsLock == 1)
{
dal.UpdateField(id, "IsLock=0");
}
else
{
dal.UpdateField(id, "IsLock=1");
}
break;
}
RptBind("");
}
//添加招聘
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.position.Text.Trim().Length == 0)
{
strErr += "岗位职称不能为空！\\n";
}
if (this.headCount.Text.Trim().Length == 0)
{
strErr += "招聘人数不能为空！\\n";
}
if (this.requirement.Text.Trim().Length == 0)
{
strErr += "招聘要求不能为空！\\n";
}
if (this.responsibility.Text.Trim().Length == 0)
{
strErr += "岗位职责不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
Cms.Model.JobInfo model = new Cms.Model.JobInfo();
model.Position = Cms.Common.Utils.ToHtml(this.position.Text);
model.Responsibility = Cms.Common.Utils.ToHtml(this.responsibility.Text);
model.HeadCount = int.Parse(this.headCount.Text);
model.Requirement = Cms.Common.Utils.ToHtml(this.requirement.Text);
model.JobOrder = Convert.ToInt32(jobOrder.Text);;
model.IsLock = Convert.ToInt32(jobIsLock.SelectedValue);
Cms.DAL.JobInfo dal = new Cms.DAL.JobInfo();
dal.Add(model);
//保存日志
MessageBox.Show(this, "招聘增加成功！");
}
//添加招聘
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.position.Text.Trim().Length == 0)
{
strErr += "岗位职称不能为空！\\n";
}
if (this.headCount.Text.Trim().Length == 0)
{
strErr += "招聘人数不能为空！\\n";
}
if (this.requirement.Text.Trim().Length == 0)
{
strErr += "招聘要求不能为空！\\n";
}
if (this.responsibility.Text.Trim().Length == 0)
{
strErr += "岗位职责不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
Cms.Model.JobInfo model = new Cms.Model.JobInfo();
model.Position = Cms.Common.Utils.ToHtml(this.position.Text);
model.Responsibility = Cms.Common.Utils.ToHtml(this.responsibility.Text);
model.HeadCount = int.Parse(this.headCount.Text);
model.Requirement = Cms.Common.Utils.ToHtml(this.requirement.Text);
model.JobOrder = Convert.ToInt32(jobOrder.Text); ;
model.IsLock = Convert.ToInt32(jobIsLock.SelectedValue);
Cms.DAL.JobInfo dal = new Cms.DAL.JobInfo();
dal.Add(model);
//保存日志
MessageBox.Show(this, "招聘增加成功！");
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Cms.Model.JobInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into JobList(");
strSql.Append("Position,Requirement,Responsibility,HeadCount,IsLock,JobOrder)");
strSql.Append(" values (");
strSql.Append("@Position,@Requirement,@Responsibility,@HeadCount,@IsLock,@JobOrder)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Position", SqlDbType.NVarChar, 50),
new SqlParameter("@Requirement", SqlDbType.NText),
new SqlParameter("@Responsibility", SqlDbType.NText),
new SqlParameter("@HeadCount", SqlDbType.Int, 4),
new SqlParameter("@IsLock", SqlDbType.Int, 4),
new SqlParameter("@JobOrder", SqlDbType.Int, 4)
};
parameters[0].Value = model.Position;
parameters[1].Value = model.Requirement;
parameters[2].Value = model.Responsibility;
parameters[3].Value = model.HeadCount;
parameters[4].Value = model.IsLock;
parameters[5].Value = model.JobOrder;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Cms.Model.JobInfo GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 JobID,Position,Requirement,Responsibility,HeadCount,IsLock,JobOrder from JobList ");
strSql.Append(" where JobID=@JobID");
SqlParameter[] parameters = {
new SqlParameter("@JobID", SqlDbType.Int,4)
};
parameters[0].Value = Id;
Cms.Model.JobInfo model = new Cms.Model.JobInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["JobID"] != null && ds.Tables[0].Rows[0]["JobID"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["JobID"].ToString());
}
if (ds.Tables[0].Rows[0]["Position"] != null && ds.Tables[0].Rows[0]["Position"].ToString() != "")
{
model.Position = ds.Tables[0].Rows[0]["Position"].ToString();
}
if (ds.Tables[0].Rows[0]["Requirement"] != null && ds.Tables[0].Rows[0]["Requirement"].ToString() != "")
{
model.Requirement = ds.Tables[0].Rows[0]["Requirement"].ToString();
}
if (ds.Tables[0].Rows[0]["Responsibility"] != null && ds.Tables[0].Rows[0]["Responsibility"].ToString() != "")
{
model.Responsibility = ds.Tables[0].Rows[0]["Responsibility"].ToString();
}
if (ds.Tables[0].Rows[0]["HeadCount"] != null && ds.Tables[0].Rows[0]["HeadCount"].ToString() != "")
{
model.HeadCount = int.Parse(ds.Tables[0].Rows[0]["HeadCount"].ToString());
}
if (ds.Tables[0].Rows[0]["IsLock"] != null && ds.Tables[0].Rows[0]["IsLock"].ToString() != "")
{
model.IsLock = int.Parse(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
if (ds.Tables[0].Rows[0]["JobOrder"] != null && ds.Tables[0].Rows[0]["JobOrder"].ToString() != "")
{
model.JobOrder = int.Parse(ds.Tables[0].Rows[0]["JobOrder"].ToString());
}
return model;
}
else
{
return null;
}
}
