public string Edit(Modules.Entity.HRJob mode)
{
string reMsg = string.Empty;
string sql = @"UPDATE K_HRJob Set
Title=@Title,
JobType=@JobType,
WorkUnit=@WorkUnit,
WorkPlace=@WorkPlace,
Salary=@Salary,
Degree=@Degree,
Age=@Age,
Experience=@Experience,
Number=@Number,
EMail=@EMail,
PublishDate=@PublishDate,
EndDate=@EndDate,
WorkDuty=@WorkDuty,
Qualifications=@Qualifications,
Welfare=@Welfare,
PageTitle=@PageTitle,
MetaKeyword=@MetaKeyword,
MetaDescript=@MetaDescript
WHERE ID=@ID";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Title", mode.Title),
new SqlParameter("@JobType", mode.JobType),
new SqlParameter("@WorkUnit", mode.WorkUnit),
new SqlParameter("@WorkPlace", mode.WorkPlace),
new SqlParameter("@Salary", mode.Salary),
new SqlParameter("@Degree", mode.Degree),
new SqlParameter("@Age", mode.Age),
new SqlParameter("@Experience", mode.Experience),
new SqlParameter("@Number", mode.Number),
new SqlParameter("@EMail", mode.EMail),
new SqlParameter("@PublishDate", mode.PublishDate),
new SqlParameter("@EndDate", mode.EndDate),
new SqlParameter("@WorkDuty", mode.WorkDuty),
new SqlParameter("@Qualifications", mode.Qualifications),
new SqlParameter("@Welfare", mode.Welfare),
new SqlParameter("@PageTitle", mode.PageTitle),
new SqlParameter("@MetaKeyword", mode.MetaKeyword),
new SqlParameter("@MetaDescript", mode.MetaDescript),
new SqlParameter("@ID", mode.ID),
};
try
{
reMsg = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, param).ToString();
}
catch (Exception e)
{
reMsg = e.Message;
}
return(reMsg);
}
private void PageInit()
{
if (this.Action == "EDIT")
{
KingTop.Modules.Entity.HRJob model = new Modules.Entity.HRJob();
model = objBll.GetItemByID(Utils.ParseInt(this.ID, 0));
BtnSave.Text = Utils.GetResourcesValue("Common", "Update");
txtTitle.Value = model.Title;
hidLogTitle.Value = model.Title;
ddlJobType.SelectedValue = model.JobType;
ddlWorkPlace.SelectedValue = model.WorkPlace;
ddlWorkUnit.SelectedValue = model.WorkUnit;
txtSalary.Value = model.Salary;
ddlDegreeFrom.SelectedValue = model.Degree;
txtAge.Value = model.Age.ToString();
txtExperience.Value = model.Experience;
txtNumber.Value = model.Number.Trim();
txtEMail.Value = model.EMail;
txtPublishDate.Value = string.IsNullOrEmpty(model.PublishDate.ToString()) == true ? "" : DateTime.Parse(model.PublishDate.ToString()).ToString("yyyy-MM-dd");
txtEndDate.Value = string.IsNullOrEmpty(model.EndDate.ToString()) == true ? "" : DateTime.Parse(model.EndDate.ToString()).ToString("yyyy-MM-dd");
Editor1.Content = model.WorkDuty;
Editor2.Content = model.Qualifications;
Editor3.Content = model.Welfare;
hidID.Value = this.ID;
txtPageTitle.Text = model.PageTitle;
txtMetaDesc.Text = model.MetaDescript;
txtKeyWords.Text = model.MetaKeyword;
}
}
