public string[] CreateItem(Entity.HRJob model)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
string orders = Tools.Orders("K_HRJob").ToString();
dic.Add("AddDate", DateTime.Now.ToString());
dic.Add("AddMan", model.AddMan.ToString());
dic.Add("Age", model.Age.ToString());
dic.Add("Degree", model.Degree.ToString());
dic.Add("EMail", model.EMail.ToString());
dic.Add("EndDate", model.EndDate.ToString());
dic.Add("Experience", model.Experience.ToString());
dic.Add("FlowState", model.FlowState.ToString());
dic.Add("IsDel", "0");
dic.Add("IsHtml", "0");
dic.Add("JobType", model.JobType.ToString());
dic.Add("MetaDescript", model.MetaDescript.ToString());
dic.Add("MetaKeyword", model.MetaKeyword.ToString());
dic.Add("NodeCode", model.NodeCode.ToString());
dic.Add("Number", model.Number.ToString());
dic.Add("Orders", orders);
dic.Add("PageTitle", model.PageTitle.ToString());
dic.Add("PublishDate", model.PublishDate.ToString());
dic.Add("Qualifications", model.Qualifications.ToString());
dic.Add("Salary", model.Salary.ToString());
dic.Add("SiteID", model.SiteID.ToString());
dic.Add("Title", model.Title.ToString());
dic.Add("Welfare", model.Welfare.ToString());
dic.Add("WorkDuty", model.WorkDuty.ToString());
dic.Add("WorkPlace", model.WorkPlace.ToString());
dic.Add("WorkUnit", model.WorkUnit.ToString());
return(InfoHelper.Add("K_HRJob", dic));
}
public Entity.HRJob GetItemByID(int ID)
{
string sSql = "select AddDate,AddMan,Age,DelTime,Degree,EMail,EndDate,Experience,FlowState,ID,IsDel,IsHtml,JobType,MetaDescript,MetaKeyword,NodeCode,Number,Orders,PageTitle,PublishDate,Qualifications,Salary,SiteID,Title,Welfare,WorkDuty,WorkPlace,WorkUnit from K_HRJob where ID=" + ID;
Entity.HRJob model = new Entity.HRJob();
using (DbDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, sSql, null))
{
while (dr.Read())
{
model.AddDate = Utils.StrToDate(dr["AddDate"].ToString());
model.AddMan = dr["AddMan"].ToString();
model.Age = Utils.ParseInt(dr["Age"].ToString(), 0);
model.DelTime = Utils.StrToDate(dr["DelTime"].ToString());
model.Degree = dr["Degree"].ToString();
model.EMail = dr["EMail"].ToString();
model.EndDate = Utils.StrToDate(dr["EndDate"].ToString());
model.Experience = dr["Experience"].ToString();
model.FlowState = Utils.ParseInt(dr["FlowState"].ToString(), 0);
model.IsDel = Utils.ParseInt(dr["IsDel"].ToString(), 0);
model.IsHtml = Utils.ParseBool(dr["IsHtml"].ToString());
model.JobType = dr["JobType"].ToString();
model.MetaDescript = dr["MetaDescript"].ToString();
model.MetaKeyword = dr["MetaKeyword"].ToString();
model.NodeCode = dr["NodeCode"].ToString();
model.Number = dr["Number"].ToString();
model.Orders = Utils.ParseInt(dr["Orders"].ToString(), 0);
model.PageTitle = dr["PageTitle"].ToString();
model.PublishDate = Utils.StrToDate(dr["PublishDate"].ToString());
model.Qualifications = dr["Qualifications"].ToString();
model.Salary = dr["Salary"].ToString();
model.SiteID = Utils.ParseInt(dr["SiteID"].ToString(), 0);
model.Title = dr["Title"].ToString();
model.Welfare = dr["Welfare"].ToString();
model.WorkDuty = dr["WorkDuty"].ToString();
model.WorkPlace = dr["WorkPlace"].ToString();
model.WorkUnit = dr["WorkUnit"].ToString();
}
}
return(model);
}
