private DataTable getjob(string id)
{
ow_jobControl ow_jobControl = new DataBaseControl.ow_jobControl();
DataTable table = null;
table = ow_jobControl.GetTable(1, id);
return(table);
}
private void BindData()
{
ow_jobControl ow_jobControl = new ow_jobControl();
DataTable table = null;
table = ow_jobControl.GetTable(1, "ID");
if (table != null && table.Rows.Count > 0)
{
this.repeaterJob.DataSource = table.DefaultView;
this.repeaterJob.DataBind();
}
}
/// <summary>
/// 增加和修改
/// </summary>
/// <param name="context">HttpContext</param>
/// <param name="tag">0-增加,1-修改</param>
/// <returns></returns>
private DataTable updatejob(HttpContext context, int tag)
{
string JobTitle = context.Request["JobTitle"]; //职位名称
string WorkingAddress = context.Request["WorkingAddress"]; //工作地点
string JobResponsibilities = context.Request["JobResponsibilities"]; //岗位职责
string JobRequirements = context.Request["JobRequirements"]; //岗位要求
string MailBox = context.Request["MailBox"]; //投递邮箱
string ID = context.Request["ID"]; //ID
DataTable table = null;
DataRow dr = null;
ow_jobControl ow_jobcontrol = new DataBaseControl.ow_jobControl();
table = ow_jobcontrol.GetTable(1, ID);
if (table != null)
{
if (table.Rows.Count > 0)
{
dr = table.Rows[0];
}
else
{
dr = table.NewRow();
table.Rows.Add(dr);
}
dr["JobTitle"] = JobTitle;
dr["WorkingAddress"] = WorkingAddress;
dr["JobResponsibilities"] = JobResponsibilities;
dr["JobRequirements"] = JobRequirements;
dr["CreateDate"] = tag == 0 ? DateTime.Now.ToString("f") : dr["CreateDate"];
dr["UpdateDate"] = DateTime.Now.ToString("f");
dr["MailBox"] = MailBox;
table.Columns["ID"].Prefix = "where";
ow_jobcontrol.Update("ID", table, tag);
}
return(table);
}
public void ProcessRequest(HttpContext context)
{
ow_jobControl ow_jobControl = new DataBaseControl.ow_jobControl();
DataTable table = null;
//DataRow dr=null;
string ID = "";
string JobTitle = "";
string WorkingAddress = "";
string JobResponsibilities = "";
string JobRequirements = "";
string MailBox = "";
string Result = "";
if (!string.IsNullOrEmpty(context.Request.QueryString["jobid"]))
{
//此处执行删除
ID = context.Request.QueryString["jobid"];
table = ow_jobControl.GetTable(1, ID);
if (table != null && table.Rows.Count > 0)
{
table.Columns["ID"].Prefix = "where";
ow_jobControl.Update("ID", table, 2);
Result = "yes";
}
else
{
Result = "no";
}
}
else
{
JobTitle = context.Request["JobTitle"]; //职位名称
WorkingAddress = context.Request["WorkingAddress"]; //工作地点
JobResponsibilities = context.Request["JobResponsibilities"]; //岗位职责
JobRequirements = context.Request["JobRequirements"]; //岗位要求
MailBox = context.Request["MailBox"]; //投递邮箱
ID = context.Request["ID"]; //ID
if (string.IsNullOrEmpty(ID))
{
//如果没有id 就是新增
table = this.updatejob(context, 0);
if (table != null && table.Rows.Count > 0)
{
JobTitle = table.Rows[0]["JobTitle"].ToString(); //职位名称
WorkingAddress = table.Rows[0]["WorkingAddress"].ToString(); //工作地点
JobResponsibilities = table.Rows[0]["JobResponsibilities"].ToString(); //岗位职责
JobRequirements = table.Rows[0]["JobRequirements"].ToString(); //岗位要求
MailBox = table.Rows[0]["MailBox"].ToString(); //投递邮箱
Result = "yes";
}
}
else if (!string.IsNullOrEmpty(ID) && string.IsNullOrEmpty(JobTitle) && string.IsNullOrEmpty(WorkingAddress) && string.IsNullOrEmpty(JobResponsibilities) && string.IsNullOrEmpty(JobRequirements) && string.IsNullOrEmpty(MailBox))
{
//有id其他都是空-查询
table = getjob(ID);
if (table != null && table.Rows.Count > 0)
{
JobTitle = table.Rows[0]["JobTitle"].ToString(); //职位名称
WorkingAddress = table.Rows[0]["WorkingAddress"].ToString(); //工作地点
JobResponsibilities = table.Rows[0]["JobResponsibilities"].ToString(); //岗位职责
JobRequirements = table.Rows[0]["JobRequirements"].ToString(); //岗位要求
MailBox = table.Rows[0]["MailBox"].ToString(); //投递邮箱
Result = "yes";
}
}
else if (!string.IsNullOrEmpty(ID) && !string.IsNullOrEmpty(JobTitle) && !string.IsNullOrEmpty(WorkingAddress) && !string.IsNullOrEmpty(JobResponsibilities) && !string.IsNullOrEmpty(JobRequirements) && !string.IsNullOrEmpty(MailBox))
{
//修改
table = this.updatejob(context, 1);
if (table != null && table.Rows.Count > 0)
{
JobTitle = table.Rows[0]["JobTitle"].ToString(); //职位名称
WorkingAddress = table.Rows[0]["WorkingAddress"].ToString(); //工作地点
JobResponsibilities = table.Rows[0]["JobResponsibilities"].ToString(); //岗位职责
JobRequirements = table.Rows[0]["JobRequirements"].ToString(); //岗位要求
MailBox = table.Rows[0]["MailBox"].ToString(); //投递邮箱
Result = "yes";
}
}
}
string json = "";
if (!string.IsNullOrEmpty(context.Request["JobResponsibilitiestext"]))
{
json = JobResponsibilities;
}
else if (!string.IsNullOrEmpty(context.Request["JobRequirementstext"]))
{
json = JobRequirements;
}
else
{
json = "{\"JobTitle\":\"" + JobTitle + "\",\"WorkingAddress\":\"" + WorkingAddress + "\",\"MailBox\":\"" + MailBox + "\",\"Result\":\"" + Result + "\"}";
//json = "{\"JobTitle\":\"" + JobTitle + "\",\"WorkingAddress\":\"" + WorkingAddress + "\",\"JobResponsibilities\":\"" + JobResponsibilities + "\",\"JobRequirements\":\"" + JobRequirements + "\",\"MailBox\":\"" + MailBox + "\",\"Result\":\"" + Result + "\"}";
}
//json = "{\"JobTitle\":\"" + JobTitle + "\",\"WorkingAddress\":\"" + WorkingAddress + "\",\"MailBox\":\"" + MailBox + "\",\"Result\":\"" + Result + "\"}";
context.Response.ContentType = "text/plain";
context.Response.Write(json);
}