public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.hr_post post = new BLL.hr_post();
Model.hr_post model = new Model.hr_post();
BLL.hr_employee emp = new BLL.hr_employee();
Model.hr_employee modelemp = new Model.hr_employee();
int emp_id = int.Parse(request.Cookies["UserID"].Value.ToString());
DataSet dsemp = emp.GetList("id=" + emp_id);
string empname = dsemp.Tables[0].Rows[0]["name"].ToString();
string uid = dsemp.Tables[0].Rows[0]["uid"].ToString();
if (request["Action"] == "grid")
{
int depid = Common.PageValidate.IsNumber(request["depid"]) ? int.Parse(request["depid"]) : 0;
string emps = request["empstatus"];
int empstuats = 0;
if (!string.IsNullOrEmpty(emps))
{
empstuats = Common.PageValidate.IsNumber(request["empstatus"]) ? int.Parse(request["empstatus"]) : 0;
}
string wherestr = " and ";
switch (empstuats)
{
case 0: wherestr += "1=1";
break;
case 1: wherestr += "emp_id=-1";
break;
case 2: wherestr += "emp_id!=-1";
break;
}
DataSet ds = post.GetList(0, " ISNULL(isDelete,0)=0 and dep_id=" + depid + wherestr, " convert(int,isnull(0,[position_order]))");
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
if (request["Action"] == "delgrid")
{
DataSet ds = post.GetList(0, " ISNULL(isDelete,0)=1 ", " convert(int,isnull(0,[position_order]))");
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
if (request["Action"] == "save")
{
//dep
model.dep_id = int.Parse(request["T_depname_val"]);
model.depname = Common.PageValidate.InputText(request["T_depname"], 250);
//name
model.post_name = Common.PageValidate.InputText(request["T_postname"], 250);
//position
model.position_id = int.Parse(request["T_position_val"]);
model.position_name = Common.PageValidate.InputText(request["T_position"], 250);
model.position_order = Common.PageValidate.InputText(request["T_position_leavel"], 50);
//emp
int empid = Common.PageValidate.IsNumber(request["T_emp_val"]) ? int.Parse(request["T_emp_val"]) : -1;
model.emp_id = empid;
model.emp_name = Common.PageValidate.InputText(request["T_emp"], 250);
//note
model.note = Common.PageValidate.InputText(request["T_descript"], 4000);
string postid = request["postid"];
if (!string.IsNullOrEmpty(postid) && postid != "null")
{
model.post_id = int.Parse(postid);
DataSet ds = post.GetList(" post_id=" + int.Parse(postid));
DataRow dr = ds.Tables[0].Rows[0];
post.Update(model);
//日志
C_Sys_log log = new C_Sys_log();
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
string EventTitle = model.position_name;
string EventType = "岗位修改";
int EventID = model.post_id;
if (dr["post_name"].ToString() != request["T_postname"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位名称", dr["post_name"].ToString(), request["T_postname"]);
}
if (dr["position_name"].ToString() != request["T_position"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位级别", dr["position_name"].ToString(), request["T_position"]);
}
if (dr["emp_name"].ToString() != request["T_emp"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位员工", dr["emp_name"].ToString(), request["T_emp"]);
}
if (dr["note"].ToString() != request["T_descript"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "描述", dr["note"].ToString(), request["T_descript"]);
}
}
else
{
post.Add(model);
}
}
//Form JSON
if (request["Action"] == "form")
{
int postid = int.Parse(request["postid"]);
BLL.hr_post hp = new BLL.hr_post();
DataSet ds = hp.GetList("post_id=" + postid);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
//del
if (request["Action"] == "AdvanceDelete")
{
string postid = request["id"];
string EventType = "岗位预删除";
DataSet ds = post.GetList(" post_id=" + int.Parse(postid));
if (emp.GetList(" postid=" + int.Parse(postid)).Tables[0].Rows.Count > 0)
{
//含有员工信息不能删除
context.Response.Write("false:emp");
}
else
{
bool isdel = post.AdvanceDelete(int.Parse(postid), 1, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss));
if (isdel)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(postid);
string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString();
string Original_txt = null;
string Current_txt = null;
C_Sys_log log = new C_Sys_log();
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt);
}
context.Response.Write("true");
}
else
{
context.Response.Write("false");
}
}
}
if (request["Action"] == "regain")
{
string idlist = Common.PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
post.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss));
}
if (true)
{
//日志
string EventType = "恢复删除岗位";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int UserID = emp_id;
string UserName = empname;
int EventID = idlist[i];
string IPStreet = request.UserHostAddress;
string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString();
string Original_txt = null;
string Current_txt = null;
C_Sys_log log = new C_Sys_log();
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt);
}
context.Response.Write("true");
}
}
if (request["Action"] == "del")
{
bool canDel = false;
if (dsemp.Tables[0].Rows.Count > 0)
{
if (dsemp.Tables[0].Rows[0]["uid"].ToString() == "admin")
{
canDel = true;
}
else
{
Data.GetAuthorityByUid getauth = new Data.GetAuthorityByUid();
string delauth = getauth.GetBtnAuthority(request.Cookies["UserID"].Value, "82");
if (delauth == "false")
{
canDel = false;
}
else
{
canDel = true;
}
}
}
if (canDel)
{
string idlist = Common.PageValidate.InputText(request["idlist"], 1000000);
string[] arr = idlist.Split(',');
string EventType = "彻底删除岗位";
DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
post.Delete(int.Parse(arr[i]));
}
if (true)
{
//日志
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = idlist[i];
string EventTitle = ds.Tables[0].Rows[0]["post_name"].ToString();
string Original_txt = null;
string Current_txt = null;
C_Sys_log log = new C_Sys_log();
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt);
}
context.Response.Write("true");
}
}
else
{
context.Response.Write("auth");
}
}
//get post by empid
if (request["Action"] == "getpostbyempid")
{
BLL.hr_post hp = new BLL.hr_post();
int empid = int.Parse(request["empid"]);
DataSet ds = hp.GetList(" ISNULL(isDelete,0)=0 and emp_id=" + empid);
if (ds.Tables[0].Rows.Count > 0)
{
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
}
//serch
if (request["Action"] == "serch")
{
BLL.hr_post hp = new BLL.hr_post();
string serchtxt = Common.PageValidate.InputText(request["Serchtext"], 255);
DataSet ds = hp.GetList(" ISNULL(isDelete,0)=0 and post_name like N'%" + serchtxt + "%'");
if (ds.Tables[0].Rows.Count > 0)
{
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
else
{
context.Response.Write("post_name like N'%" + serchtxt + "%'");
}
}
//post_emp
if (request["Action"] == "postemp")
{
string json = request["PostData"].ToLower();
JavaScriptSerializer js = new JavaScriptSerializer();
PostData[] postdata;
postdata = js.Deserialize <PostData[]>(json);
BLL.hr_post hp = new BLL.hr_post();
string empid = request["empid"];
int Eid = -1;
if (!string.IsNullOrEmpty(empid))
{
Eid = Common.PageValidate.IsNumber(empid) ? int.Parse(empid) : -1;
}
model.emp_id = Eid;
modelemp.ID = Eid;
model.emp_name = Common.PageValidate.InputText(request["emp_name"], 255);
for (int i = 0; i < postdata.Length; i++)
{
model.post_id = postdata[i].Post_id;
model.default_post = postdata[i].Default_post;
if (postdata[i].Default_post == 1)
{
modelemp.d_id = postdata[i].Dep_id;
modelemp.dname = postdata[i].Depname;
modelemp.zhiwuid = postdata[i].Position_id;
modelemp.zhiwu = postdata[i].Position_name;
modelemp.postid = postdata[i].Post_id;
modelemp.post = postdata[i].Post_name;
//context.Response.Write(postdata[i].Depname + "@");
emp.UpdatePost(modelemp);
}
hp.UpdatePostEmp(model);
}
}
//combo
if (request["Action"] == "combo")
{
int postid = int.Parse(request["postid"]);
DataSet ds = post.GetList(" ISNULL(isDelete,0)=0 and dep_id=" + postid);
StringBuilder str = new StringBuilder();
str.Append("[");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
str.Append("{id:" + ds.Tables[0].Rows[i]["post_id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["post_name"] + "'},");
}
str.Replace(",", "", str.Length - 1, 1);
str.Append("]");
context.Response.Write(str);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.hr_post post = new BLL.hr_post();
Model.hr_post model = new Model.hr_post();
BLL.hr_employee emp = new BLL.hr_employee();
Model.hr_employee modelemp = new Model.hr_employee();
int emp_id = int.Parse(request.Cookies["UserID"].Value.ToString());
DataSet dsemp = emp.GetList("id=" + emp_id);
string empname = dsemp.Tables[0].Rows[0]["name"].ToString();
string uid = dsemp.Tables[0].Rows[0]["uid"].ToString();
if (request["Action"] == "grid")
{
string depid = request["depid"];
string emps = request["empstatus"];
int empstuats = 0;
if (!string.IsNullOrEmpty(emps))
{
empstuats = Common.PageValidate.IsNumber(request["empstatus"]) ? int.Parse(request["empstatus"]) : 0;
}
string serchtxt = "";
switch (empstuats)
{
case 0: serchtxt += "1=1 ";
break;
case 1: serchtxt += "emp_id=-1 ";
break;
case 2: serchtxt += "emp_id!=-1 ";
break;
}
if (!string.IsNullOrEmpty(depid) && depid != "null")
serchtxt += " and dep_id=" + int.Parse(depid);
string serchtype = request["isdel"];
if (serchtype == "1")
serchtxt += " and isDelete=1";
else
serchtxt += " and isDelete=0 ";
DataSet ds = post.GetList(0, serchtxt, " convert(int,[position_order])");
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
if (request["Action"] == "save")
{
//dep
model.dep_id = int.Parse(request["T_depname_val"]);
model.depname = Common.PageValidate.InputText(request["T_depname"], 250);
//name
model.post_name = Common.PageValidate.InputText(request["T_postname"], 250);
//position
model.position_id = int.Parse(request["T_position_val"]);
model.position_name = Common.PageValidate.InputText(request["T_position"], 250);
model.position_order = Common.PageValidate.InputText(request["T_position_leavel"], 50);
//emp
int empid = Common.PageValidate.IsNumber(request["T_emp_val"]) ? int.Parse(request["T_emp_val"]) : -1;
model.emp_id = empid;
model.emp_name = Common.PageValidate.InputText(request["T_emp"], 250);
//note
model.note = Common.PageValidate.InputText(request["T_descript"], 4000);
//更新员工岗位
modelemp.d_id = model.dep_id;
modelemp.dname = model.depname;
modelemp.post = model.post_name;
modelemp.zhiwuid = model.position_id;
modelemp.zhiwu = model.position_name;
modelemp.ID = empid;
string postid = request["postid"];
if (!string.IsNullOrEmpty(postid) && postid != "null")
{
model.post_id = int.Parse(postid);
DataSet ds = post.GetList(" post_id=" + int.Parse(postid));
DataRow dr = null;
if (ds.Tables[0].Rows.Count > 0)
{
dr = ds.Tables[0].Rows[0];
//判断默认岗位
if (model.emp_id == -1)
{
model.default_post = 0;
}
else
{
DataSet ds1 = post.GetList(string.Format("default_post=1 and emp_id={0} and post_id!={1}", model.emp_id, int.Parse(postid)));
if (ds1.Tables[0].Rows.Count > 0)
model.default_post = 0; //此员工有默认岗位
else
{
model.default_post = 1; //设置此岗位为此员工默认岗位
//更新员工岗位
modelemp.postid = model.post_id;
emp.UpdatePost(modelemp);
}
}
}
post.Update(model);
//日志
C_Sys_log log = new C_Sys_log();
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
string EventTitle = model.position_name;
string EventType = "岗位修改";
int EventID = model.post_id;
if (dr["post_name"].ToString() != request["T_postname"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位名称", dr["post_name"].ToString(), request["T_postname"]);
}
if (dr["position_name"].ToString() != request["T_position"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位级别", dr["position_name"].ToString(), request["T_position"]);
}
if (dr["emp_name"].ToString() != request["T_emp"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "岗位员工", dr["emp_name"].ToString(), request["T_emp"]);
}
if (dr["note"].ToString() != request["T_descript"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "描述", dr["note"].ToString(), request["T_descript"]);
}
}
else
{
model.isDelete = 0;
postid= post.Add(model).ToString();
//判断默认岗位
if (model.emp_id == -1)
{
model.default_post = 0;
}
else
{
DataSet ds1 = post.GetList(string.Format("default_post=1 and emp_id={0} and post_id!={1}", model.emp_id, int.Parse(postid)));
if (ds1.Tables[0].Rows.Count > 0)
model.default_post = 0; //此员工有默认岗位
else
{
model.default_post = 1; //设置此岗位为此员工默认岗位
//更新员工岗位
modelemp.postid = int.Parse(postid);
emp.UpdatePost(modelemp);
}
}
post.UpdatePostEmp(model);
}
}
//Form JSON
if (request["Action"] == "form")
{
int postid = int.Parse(request["postid"]);
BLL.hr_post hp = new BLL.hr_post();
DataSet ds = hp.GetList("post_id=" + postid);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
//del
if (request["Action"] == "AdvanceDelete")
{
string postid = request["id"];
string EventType = "岗位预删除";
DataSet ds = post.GetList(" post_id=" + int.Parse(postid));
if (ds.Tables[0].Rows[0]["emp_id"].ToString()!="-1")
{
//含有员工信息不能删除
context.Response.Write("false:emp");
}
else
{
bool isdel = post.AdvanceDelete(int.Parse(postid), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
if (isdel)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(postid);
string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString();
string Original_txt = null;
string Current_txt = null;
C_Sys_log log = new C_Sys_log();
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt);
}
context.Response.Write("true");
}
else
{
context.Response.Write("false");
}
}
}
if (request["Action"] == "regain")
{
string idlist = Common.PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
post.AdvanceDelete(int.Parse(arr[i]), 0, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (true)
{
//日志
string EventType = "恢复删除岗位";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int UserID = emp_id;
string UserName = empname;
int EventID = idlist[i];
string IPStreet = request.UserHostAddress;
string EventTitle = ds.Tables[0].Rows[i]["post_name"].ToString();
string Original_txt = null;
string Current_txt = null;
C_Sys_log log = new C_Sys_log();
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt);
}
context.Response.Write("true");
}
}
if (request["Action"] == "del")
{
bool canDel = false;
if (dsemp.Tables[0].Rows.Count > 0)
{
if (dsemp.Tables[0].Rows[0]["uid"].ToString() == "admin")
{
canDel = true;
}
else
{
Data.GetAuthorityByUid getauth = new Data.GetAuthorityByUid();
string delauth = getauth.GetBtnAuthority(request.Cookies["UserID"].Value, "82");
if (delauth == "false")
canDel = false;
else
canDel = true;
}
}
if (canDel)
{
string idlist = Common.PageValidate.InputText(request["idlist"], 1000000);
string[] arr = idlist.Split(',');
string EventType = "彻底删除岗位";
DataSet ds = post.GetList("post_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
post.Delete(int.Parse(arr[i]));
}
if (true)
{
//日志
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = idlist[i];
string EventTitle = ds.Tables[0].Rows[0]["post_name"].ToString();
string Original_txt = null;
string Current_txt = null;
C_Sys_log log = new C_Sys_log();
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, null, Original_txt, Current_txt);
}
context.Response.Write("true");
}
}
else
{
context.Response.Write("auth");
}
}
//get post by empid
if (request["Action"] == "getpostbyempid")
{
BLL.hr_post hp = new BLL.hr_post();
int empid = int.Parse(request["empid"]);
DataSet ds = hp.GetList(" isDelete=0 and emp_id=" + empid);
if (ds.Tables[0].Rows.Count > 0)
{
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
}
//serch
if (request["Action"] == "serch")
{
BLL.hr_post hp = new BLL.hr_post();
string serchtxt = Common.PageValidate.InputText(request["Serchtext"], 255);
DataSet ds = hp.GetList(" isDelete=0 and post_name like N'%" + serchtxt + "%'");
if (ds.Tables[0].Rows.Count > 0)
{
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
else
{
context.Response.Write("post_name like N'%" + serchtxt + "%'");
}
}
//post_emp
if (request["Action"] == "postemp")
{
string json = request["PostData"].ToLower();
JavaScriptSerializer js = new JavaScriptSerializer();
PostData[] postdata;
postdata = js.Deserialize<PostData[]>(json);
BLL.hr_post hp = new BLL.hr_post();
string empid = request["empid"];
int Eid = -1;
if (!string.IsNullOrEmpty(empid))
{
Eid = Common.PageValidate.IsNumber(empid) ? int.Parse(empid) : -1;
}
model.emp_id = Eid;
modelemp.ID = Eid;
model.emp_name = Common.PageValidate.InputText(request["emp_name"], 255);
for (int i = 0; i < postdata.Length; i++)
{
model.post_id = postdata[i].Post_id;
model.default_post = postdata[i].Default_post;
if (postdata[i].Default_post == 1)
{
modelemp.d_id = postdata[i].Dep_id;
modelemp.dname = postdata[i].Depname;
modelemp.zhiwuid = postdata[i].Position_id;
modelemp.zhiwu = postdata[i].Position_name;
modelemp.postid = postdata[i].Post_id;
modelemp.post = postdata[i].Post_name;
//context.Response.Write(postdata[i].Depname + "@");
emp.UpdatePost(modelemp);
}
hp.UpdatePostEmp(model);
}
}
//combo
if (request["Action"] == "combo")
{
int postid = int.Parse(request["postid"]);
DataSet ds = post.GetList(" isDelete=0 and dep_id=" + postid);
StringBuilder str = new StringBuilder();
str.Append("[");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
str.Append("{id:" + ds.Tables[0].Rows[i]["post_id"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["post_name"] + "'},");
}
str.Replace(",", "", str.Length - 1, 1);
str.Append("]");
context.Response.Write(str);
}
}
