public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.Personal_Calendar calendar = new BLL.Personal_Calendar();
Model.Personal_Calendar model = new Model.Personal_Calendar();
if (request["Action"] == "get")
{
CalendarViewType viewType = (CalendarViewType)Enum.Parse(typeof(CalendarViewType), request["viewtype"]);
string strshowday = request["showdate"];
int clientzone = Convert.ToInt32(request["timezone"]);
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
var format = new CalendarViewFormat(viewType, DateTime.Parse(strshowday), DayOfWeek.Monday);
DataSet ds = calendar.GetList("emp_id=" + int.Parse(context.Request.Cookies["UserID"].Value) + " and StartTime>='" + format.StartDate + "' and EndTime<='" + format.EndDate + "'");
string dt = DataToJSON(ds);
var data = new JsonCalendarViewData(calendar.DataTableToList(ds.Tables[0]), format.StartDate, format.EndDate);
context.Response.Write("{\"start\":\"\\/Date(" + MilliTimeStamp(format.StartDate) + ")\\/\",\"end\":\"\\/Date(" + MilliTimeStamp(format.EndDate) + ")\\/\",\"error\":null,\"issort\":true,\"events\":[" + dt + "]}");
//context.Response.Write(dt);
}
if (request["Action"] == "quickadd")
{
int clientzone = Convert.ToInt32(request["timezone"]);
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
model.Subject = PageValidate.InputText(request["CalendarTitle"], 4000);
model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff);
model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff);
model.IsAllDayEvent = PageValidate.InputText(request["IsAllDayEvent"], 255) == "1" ? true : false;
model.CalendarType = 1;
model.InstanceType = 0;
model.UPAccount = context.Request.Cookies["UserID"].Value;
model.UPTime = DateTime.Now;
model.MasterId = clientzone;
model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value);
model.Category = PageValidate.InputText(context.Request.Cookies["UserID"].Value, 50);
int n = calendar.Add(model);
context.Response.Write("{\"IsSuccess\":true,\"Msg\":\"\u64cd\u4f5c\u6210\u529f!\",\"Data\":\"" + n + "\"}");
}
if (request["Action"] == "quickupdate")
{
string Id = request["calendarId"];
int clientzone = Convert.ToInt32(request["timezone"]);
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff);
model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff);
model.UPAccount = context.Request.Cookies["UserID"].Value;
model.UPTime = DateTime.Now;
model.MasterId = clientzone;
model.Id = int.Parse(Id);
calendar.quickUpdate(model);
context.Response.Write("{IsSuccess:true}");
}
if (request["Action"] == "quickdel")
{
int id = Convert.ToInt32(request["calendarId"]);
calendar.Delete(id);
context.Response.Write("{IsSuccess:true}");
}
if (request["Action"] == "form")
{
int id = Convert.ToInt32(request["calendarid"]);
DataSet ds = calendar.GetList("Id=" + id);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
if (request["Action"] == "save")
{
string Id = request["calendarid"];
int clientzone = 8;
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
model.StartTime = DateTime.Parse(request["T_starttime"]).AddHours(zonediff);
model.EndTime = DateTime.Parse(request["T_endtime"]).AddHours(zonediff);
model.Subject = Common.PageValidate.InputText(request["T_content"], 4000);
model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value);
model.UPAccount = context.Request.Cookies["UserID"].Value;
model.UPTime = DateTime.Now;
model.MasterId = clientzone;
model.CalendarType = 1;
model.InstanceType = 0;
model.IsAllDayEvent = PageValidate.InputText(request["allday"], 255) == "True" ? true : false;
model.Id = int.Parse(Id);
calendar.Update(model);
context.Response.Write("{IsSuccess:true}");
}
if (request["Action"] == "Today")
{
DateTime starttime = DateTime.Parse(DateTime.Now.ToShortDateString() + " 00:00:00");
DateTime endtime = DateTime.Parse(DateTime.Now.AddDays(1).ToShortDateString() + " 00:00:00");
DataSet ds = calendar.GetList(0, "datediff(day,[StartTime],getdate())=0 and datediff(day,[EndTime],getdate())=0 and emp_id=" + int.Parse(request.Cookies["UserID"].Value), "[StartTime] desc");
context.Response.Write(GetGridJSON.DataTableToJSON(ds.Tables[0]));
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.CRM_Follow follow = new BLL.CRM_Follow();
Model.CRM_Follow model = new Model.CRM_Follow();
BLL.hr_employee emp = new BLL.hr_employee();
int emp_id = int.Parse(request.Cookies["UserID"].Value);
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"] == "save")
{
model.Customer_id = int.Parse(request["cid"]);
BLL.CRM_Customer ccc = new BLL.CRM_Customer();
string cname = ccc.GetList("id=" + model.Customer_id).Tables[0].Rows[0]["Customer"].ToString();
model.Customer_name = PageValidate.InputText(cname, 250);
model.Follow = PageValidate.InputText(request["T_follow"], 4000);
model.Follow_Type_id = int.Parse(request["T_followtype_val"]);
model.Follow_Type = PageValidate.InputText(request["T_followtype"], 255);
string fid = request["fid"];
if (!string.IsNullOrEmpty(fid) && fid != "null")
{
DataSet ds = follow.GetList("id=" + int.Parse(fid));
DataRow dr = ds.Tables[0].Rows[0];
model.employee_id = int.Parse(dr["employee_id"].ToString());
model.employee_name = dr["employee_name"].ToString();
model.department_id = int.Parse(dr["department_id"].ToString());
model.department_name = dr["department_name"].ToString();
model.Follow_date = DateTime.Parse(dr["Follow_date"].ToString());
model.id = int.Parse(fid);
follow.Update(model);
//最后跟进
ccc.UpdateLastFollow(model.Customer_id.ToString());
//日志
C_Sys_log log = new C_Sys_log();
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
string EventTitle = model.Customer_name;
string EventType = "客户跟进修改";
int EventID = model.id;
if (dr["Follow"].ToString() != request["T_follow"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进内容", "跟进内容被修改", "跟进内容被修改");
}
if (dr["Follow_Type"].ToString() != request["T_followtype"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进类型", dr["Follow_Type"].ToString(), request["T_followtype"]);
}
}
else
{
model.isDelete = 0;
DataRow dr1 = dsemp.Tables[0].Rows[0];
model.employee_id = int.Parse(dr1["ID"].ToString());
model.employee_name = dr1["name"].ToString();
string depid = dr1["d_id"].ToString();
if (string.IsNullOrEmpty(depid))
depid = "0";
model.department_id = int.Parse(depid);
model.department_name = dr1["dname"].ToString();
model.Follow_date = DateTime.Now;
int customerid = follow.Add(model);
//最后跟进
ccc.UpdateLastFollow(model.Customer_id.ToString());
}
if (!string.IsNullOrEmpty(request["T_content"]))
{
BLL.Personal_Calendar calendar = new BLL.Personal_Calendar();
Model.Personal_Calendar modelcalendar = new Model.Personal_Calendar();
int clientzone = 8;
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
modelcalendar.StartTime = DateTime.Parse(request["T_starttime"]).AddHours(zonediff);
modelcalendar.EndTime = DateTime.Parse(request["T_endtime"]).AddHours(zonediff);
modelcalendar.Subject = PageValidate.InputText("【" + cname + "】" + request["T_content"], 4000);
modelcalendar.emp_id = int.Parse(request.Cookies["UserID"].Value);
modelcalendar.UPAccount = request.Cookies["UserID"].Value;
modelcalendar.UPTime = DateTime.Now;
modelcalendar.MasterId = clientzone;
modelcalendar.CalendarType = 1;
modelcalendar.Category = "4";//跟进提醒
modelcalendar.companyid = model.Customer_id;
modelcalendar.InstanceType = 0;
modelcalendar.IsAllDayEvent = PageValidate.InputText(request["allday"], 255) == "True" ? true : false;
calendar.Add(modelcalendar);
}
}
if (request["Action"] == "form")
{
DataSet ds = follow.GetList("id=" + int.Parse(request["fid"]) + DataAuth(request.Cookies["UserID"].Value));
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
//del
if (request["Action"] == "AdvanceDelete")
{
string id = request["id"];
DataSet ds = follow.GetList("id=" + int.Parse(id));
bool canedel = true;
if (uid != "admin")
{
Data.GetDataAuth dataauth = new Data.GetDataAuth();
string txt = dataauth.GetDataAuthByid("2", "Sys_del", emp_id.ToString());
string[] arr = txt.Split(':');
switch (arr[0])
{
case "none":
canedel = false;
break;
case "my":
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["employee_id"].ToString() == arr[1])
canedel = true;
else
canedel = false;
}
break;
case "dep":
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["dep_id"].ToString() == arr[1])
canedel = true;
else
canedel = false;
}
break;
case "all":
canedel = true;
break;
}
}
if (canedel)
{
bool isdel = follow.AdvanceDelete(int.Parse(request["id"]), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
//context.Response.Write("{success:success}");
if (isdel)
{
//日志
string EventType = "跟进预删除";
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(id);
string EventTitle = ds.Tables[0].Rows[0]["Customer_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");
}
}
else
{
context.Response.Write("delfalse");
}
}
//del
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, "64");
if (delauth == "false")
canDel = false;
else
canDel = true;
}
}
if (canDel)
{
string idlist = PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
DataSet ds = follow.GetList("id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
follow.Delete(int.Parse(arr[i]));
}
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]["Customer_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");
}
}
//regain
//需要加2
if (request["Action"] == "regain")
{
string idlist = PageValidate.InputText(request["idlist"], 10000);
string[] arr = idlist.Split(',');
DataSet ds = follow.GetList("id in (" + idlist.Trim() + ")");
bool canedel = true;
if (uid != "admin")
{
Data.GetDataAuth dataauth = new Data.GetDataAuth();
string txt = dataauth.GetDataAuthByid("2", "Sys_del", emp_id.ToString());
string[] arr1 = txt.Split(':');
switch (arr1[0])
{
case "none":
canedel = false;
break;
case "my":
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["employee_id"].ToString() == arr1[1])
canedel = true;
else
canedel = false;
}
break;
case "dep":
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["department_id"].ToString() == arr1[1])
canedel = true;
else
canedel = false;
}
break;
case "all":
canedel = true;
break;
}
}
if (canedel)
{
for (int i = 0; i < arr.Length; i++)
{
follow.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]["Customer_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("delfalse");
}
}
//serch
if (request["Action"] == "grid")
{
int PageIndex = int.Parse(request["page"] == null ? "1" : request["page"]);
int PageSize = int.Parse(request["pagesize"] == null ? "30" : request["pagesize"]);
string sortname = request["sortname"];
string sortorder = request["sortorder"];
if (string.IsNullOrEmpty(sortname))
sortname = " id ";
if (string.IsNullOrEmpty(sortorder))
sortorder = " desc";
string sorttext = " " + sortname + " " + sortorder;
string Total;
string serchtxt = null;
//is delete ?
if (request["isdel"] == "1")
serchtxt += " isDelete=1 ";
else
serchtxt += " isDelete=0 ";
if (!string.IsNullOrEmpty(request["customer_id"]))
serchtxt += " and Customer_id=" + int.Parse(request["customer_id"]);
if (!string.IsNullOrEmpty(request["company"]))
serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 255) + "%'";
if (!string.IsNullOrEmpty(request["department"]))
serchtxt += " and department_id = " + int.Parse(request["department_val"]);
if (!string.IsNullOrEmpty(request["employee"]))
serchtxt += " and employee_id = " + int.Parse(request["employee_val"]);
if (!string.IsNullOrEmpty(request["followtype"]))
serchtxt += " and Follow_Type_id = " + int.Parse(request["followtype_val"]);
if (!string.IsNullOrEmpty(request["startdate"]))
serchtxt += " and Follow_date >= '" + PageValidate.InputText(request["startdate"], 255) + "'";
if (!string.IsNullOrEmpty(request["enddate"]))
{
DateTime enddate = DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59);
serchtxt += " and Follow_date <= '" + enddate + "'";
}
if (!string.IsNullOrEmpty(request["startdate_del"]))
serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 255) + "'";
if (!string.IsNullOrEmpty(request["enddate_del"]))
{
DateTime enddate = DateTime.Parse(request["enddate_del"]).AddHours(23).AddMinutes(59).AddSeconds(59);
serchtxt += " and Delete_time <= '" + enddate + "'";
}
if (!string.IsNullOrEmpty(request["T_smart"]))
{
if (request["T_smart"] != "输入关键词智能搜索跟进内容")
serchtxt += " and Follow like N'%" + PageValidate.InputText(request["T_smart"], 255) + "%'";
}
//权限
//serchtxt += DataAuth(request.Cookies["UserID"].Value);
DataSet ds = follow.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total);
string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total);
context.Response.Write(dt);
}
if (request["Action"] == "Compared_follow")
{
string dt1 = request["date1"];
string dt2 = request["date2"];
DataSet ds = follow.Compared_follow(DateTime.Parse(dt1), DateTime.Parse(dt2));
string dt = GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
if (request["Action"] == "Compared_empcusfollow")
{
var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), 100000);
string dt1 = request["date1"];
string dt2 = request["date2"];
BLL.hr_post post = new BLL.hr_post();
DataSet dspost = post.GetList("post_id in(" + idlist + ")");
string emplist = "(";
for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++)
{
emplist += dspost.Tables[0].Rows[i]["emp_id"] + ",";
}
emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")";
//context.Response.Write(emplist);
DataSet ds = follow.Compared_empcusfollow(DateTime.Parse(dt1), DateTime.Parse(dt2), emplist);
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
if (request["Action"] == "emp_cusfollow")
{
var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), 1000000);
var syear = request["syear"];
BLL.hr_post post = new BLL.hr_post();
DataSet dspost = post.GetList("post_id in(" + idlist + ")");
string emplist = "(";
for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++)
{
emplist += dspost.Tables[0].Rows[i]["emp_id"] + ",";
}
emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")";
//context.Response.Write(emplist);
DataSet ds = follow.report_empfollow(int.Parse(syear), emplist);
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.CRM_Follow follow = new BLL.CRM_Follow();
Model.CRM_Follow model = new Model.CRM_Follow();
var cookie = context.Request.Cookies[FormsAuthentication.FormsCookieName];
var ticket = FormsAuthentication.Decrypt(cookie.Value);
string CoockiesID = ticket.UserData;
BLL.hr_employee emp = new BLL.hr_employee();
int emp_id = int.Parse(CoockiesID);
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"] == "save")
{
model.Customer_id = int.Parse(request["cid"]);
BLL.CRM_Customer ccc = new BLL.CRM_Customer();
string cname = ccc.GetList("id=" + model.Customer_id).Tables[0].Rows[0]["Customer"].ToString();
model.Customer_name = PageValidate.InputText(cname, 250);
model.Follow = PageValidate.InputText(request["T_follow"], 4000);
model.Follow_Type_id = int.Parse(request["T_followtype_val"]);
model.Follow_Type = PageValidate.InputText(request["T_followtype"], 255);
string fid = PageValidate.InputText(request["fid"], 50);
if (!string.IsNullOrEmpty(fid) && fid != "null")
{
DataSet ds = follow.GetList("id=" + int.Parse(fid));
DataRow dr = ds.Tables[0].Rows[0];
model.id = int.Parse(fid);
follow.Update(model);
//最后跟进
ccc.UpdateLastFollow(model.Customer_id.ToString());
//日志
C_Sys_log log = new C_Sys_log();
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
string EventTitle = model.Customer_name;
string EventType = "客户跟进修改";
int EventID = model.id;
if (dr["Follow"].ToString() != request["T_follow"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进内容", "跟进内容被修改", "跟进内容被修改");
}
if (dr["Follow_Type"].ToString() != request["T_followtype"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进类型", dr["Follow_Type"].ToString(), request["T_followtype"]);
}
}
else
{
model.isDelete = 0;
DataRow dr1 = dsemp.Tables[0].Rows[0];
model.employee_id = int.Parse(dr1["ID"].ToString());
model.employee_name = dr1["name"].ToString();
string depid = dr1["d_id"].ToString();
if (string.IsNullOrEmpty(depid))
{
depid = "0";
}
model.department_id = int.Parse(depid);
model.department_name = dr1["dname"].ToString();
model.Follow_date = DateTime.Now;
int customerid = follow.Add(model);
//最后跟进
ccc.UpdateLastFollow(model.Customer_id.ToString());
}
if (!string.IsNullOrEmpty(request["T_content"]))
{
BLL.Personal_Calendar calendar = new BLL.Personal_Calendar();
Model.Personal_Calendar modelcalendar = new Model.Personal_Calendar();
int clientzone = 8;
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
modelcalendar.StartTime = DateTime.Parse(request["T_starttime"]).AddHours(zonediff);
modelcalendar.EndTime = DateTime.Parse(request["T_endtime"]).AddHours(zonediff);
modelcalendar.Subject = PageValidate.InputText("【" + cname + "】" + request["T_content"], 4000);
modelcalendar.emp_id = emp_id;
modelcalendar.UPAccount = emp_id.ToString();
modelcalendar.UPTime = DateTime.Now;
modelcalendar.MasterId = clientzone;
modelcalendar.CalendarType = 1;
modelcalendar.Category = "4";//跟进提醒
modelcalendar.companyid = model.Customer_id;
modelcalendar.InstanceType = 0;
modelcalendar.IsAllDayEvent = PageValidate.InputText(request["allday"], 255) == "True" ? true : false;
calendar.Add(modelcalendar);
}
}
if (request["Action"] == "form")
{
DataSet ds = follow.GetList("id=" + int.Parse(request["fid"]) + DataAuth(emp_id.ToString()));
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
//del
if (request["Action"] == "del")
{
string id = request["id"];
DataSet ds = follow.GetList("id=" + int.Parse(id));
bool canedel = true;
if (uid != "admin")
{
Data.GetDataAuth dataauth = new Data.GetDataAuth();
string txt = dataauth.GetDataAuthByid("2", "Sys_del", emp_id.ToString());
string[] arr = txt.Split(':');
switch (arr[0])
{
case "none":
canedel = false;
break;
case "my":
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["employee_id"].ToString() == arr[1])
{
canedel = true;
}
else
{
canedel = false;
}
}
break;
case "dep":
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["dep_id"].ToString() == arr[1])
{
canedel = true;
}
else
{
canedel = false;
}
}
break;
case "all":
canedel = true;
break;
}
}
if (canedel)
{
bool isdel = follow.Delete(int.Parse(request["id"]));
//context.Response.Write("{success:success}");
if (isdel)
{
//日志
string EventType = "跟进删除";
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(id);
string EventTitle = ds.Tables[0].Rows[0]["Customer_name"].ToString();
string Original_txt = ds.Tables[0].Rows[0]["Follow"].ToString();
string Current_txt = null;
C_Sys_log log = new C_Sys_log();
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "跟进", Original_txt, Current_txt);
context.Response.Write("true");
}
else
{
context.Response.Write("false");
}
}
else
{
context.Response.Write("delfalse");
}
}
//serch
if (request["Action"] == "grid")
{
int PageIndex = int.Parse(request["page"] == null ? "1" : request["page"]);
int PageSize = int.Parse(request["pagesize"] == null ? "30" : request["pagesize"]);
string sortname = request["sortname"];
string sortorder = request["sortorder"];
if (string.IsNullOrEmpty(sortname))
{
sortname = " id ";
}
if (string.IsNullOrEmpty(sortorder))
{
sortorder = " desc";
}
string sorttext = " " + sortname + " " + sortorder;
string Total;
string serchtxt = "1=1";
if (!string.IsNullOrEmpty(request["customer_id"]))
{
serchtxt += " and Customer_id=" + int.Parse(request["customer_id"]);
}
if (!string.IsNullOrEmpty(request["company"]))
{
serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 255) + "%'";
}
if (!string.IsNullOrEmpty(request["department"]))
{
serchtxt += " and department_id = " + int.Parse(request["department_val"]);
}
if (!string.IsNullOrEmpty(request["employee"]))
{
serchtxt += " and employee_id = " + int.Parse(request["employee_val"]);
}
if (!string.IsNullOrEmpty(request["followtype"]))
{
serchtxt += " and Follow_Type_id = " + int.Parse(request["followtype_val"]);
}
if (!string.IsNullOrEmpty(request["startdate"]))
{
serchtxt += " and Follow_date >= '" + PageValidate.InputText(request["startdate"], 255) + "'";
}
if (!string.IsNullOrEmpty(request["enddate"]))
{
DateTime enddate = DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59);
serchtxt += " and Follow_date <= '" + enddate + "'";
}
if (!string.IsNullOrEmpty(request["startdate_del"]))
{
serchtxt += " and Delete_time >= '" + PageValidate.InputText(request["startdate_del"], 255) + "'";
}
if (!string.IsNullOrEmpty(request["enddate_del"]))
{
DateTime enddate = DateTime.Parse(request["enddate_del"]).AddHours(23).AddMinutes(59).AddSeconds(59);
serchtxt += " and Delete_time <= '" + enddate + "'";
}
if (!string.IsNullOrEmpty(request["T_smart"]))
{
if (request["T_smart"] != "输入关键词智能搜索跟进内容")
{
serchtxt += " and Follow like N'%" + PageValidate.InputText(request["T_smart"], 255) + "%'";
}
}
//权限
serchtxt += DataAuth(emp_id.ToString());
DataSet ds = follow.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total);
string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total);
context.Response.Write(dt);
}
if (request["Action"] == "Compared_follow")
{
string dt1 = request["date1"];
string dt2 = request["date2"];
DataSet ds = follow.Compared_follow(DateTime.Parse(dt1), DateTime.Parse(dt2));
string dt = GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
if (request["Action"] == "Compared_empcusfollow")
{
var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), int.MaxValue);
string dt1 = request["date1"];
string dt2 = request["date2"];
BLL.hr_post post = new BLL.hr_post();
DataSet dspost = post.GetList("post_id in(" + idlist + ")");
string emplist = "(";
for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++)
{
emplist += dspost.Tables[0].Rows[i]["emp_id"] + ",";
}
emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")";
//context.Response.Write(emplist);
DataSet ds = follow.Compared_empcusfollow(DateTime.Parse(dt1), DateTime.Parse(dt2), emplist);
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
if (request["Action"] == "emp_cusfollow")
{
var idlist = PageValidate.InputText(request["idlist"].Replace(";", ",").Replace("-", ""), int.MaxValue);
var syear = request["syear"];
BLL.hr_post post = new BLL.hr_post();
DataSet dspost = post.GetList("post_id in(" + idlist + ")");
string emplist = "(";
for (int i = 0; i < dspost.Tables[0].Rows.Count - 1; i++)
{
emplist += dspost.Tables[0].Rows[i]["emp_id"] + ",";
}
emplist += dspost.Tables[0].Rows[dspost.Tables[0].Rows.Count - 1]["emp_id"] + ")";
//context.Response.Write(emplist);
DataSet ds = follow.report_empfollow(int.Parse(syear), emplist);
string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]);
context.Response.Write(dt);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.Personal_Calendar calendar = new BLL.Personal_Calendar();
Model.Personal_Calendar model = new Model.Personal_Calendar();
if (request["Action"] == "get")
{
CalendarViewType viewType = (CalendarViewType)Enum.Parse(typeof(CalendarViewType), request["viewtype"]);
string strshowday = request["showdate"];
int clientzone = Convert.ToInt32(request["timezone"]);
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
var format = new CalendarViewFormat(viewType, DateTime.Parse(strshowday), DayOfWeek.Monday);
DataSet ds = calendar.GetList("emp_id=" + int.Parse(context.Request.Cookies["UserID"].Value) + " and StartTime>='" + format.StartDate.ToString("yyyy-MM-dd hh:mm:ss") + "' and EndTime<='" + format.EndDate.ToString("yyyy-MM-dd hh:mm:ss") + "'");
string dt = DataToJSON(ds);
var data = new JsonCalendarViewData(calendar.DataTableToList(ds.Tables[0]), format.StartDate, format.EndDate);
context.Response.Write("{\"start\":\"\\/Date(" + MilliTimeStamp(format.StartDate) + ")\\/\",\"end\":\"\\/Date(" + MilliTimeStamp(format.EndDate) + ")\\/\",\"error\":null,\"issort\":true,\"events\":[" + dt + "]}");
//context.Response.Write(dt);
}
if (request["Action"] == "quickadd")
{
int clientzone = Convert.ToInt32(request["timezone"]);
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
model.Subject = PageValidate.InputText(request["CalendarTitle"], 4000);
model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff);
model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff);
model.IsAllDayEvent = PageValidate.InputText(request["IsAllDayEvent"], 255) == "1" ? true : false;
model.CalendarType = 1;
model.InstanceType = 0;
model.UPAccount = context.Request.Cookies["UserID"].Value;
model.UPTime = DateTime.Now;
model.MasterId = clientzone;
model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value);
model.Category = PageValidate.InputText(context.Request.Cookies["UserID"].Value, 50);
int n = calendar.Add(model);
context.Response.Write("{\"IsSuccess\":true,\"Msg\":\"\u64cd\u4f5c\u6210\u529f!\",\"Data\":\"" + n + "\"}");
}
if (request["Action"] == "quickupdate")
{
string Id = request["calendarId"];
int clientzone = Convert.ToInt32(request["timezone"]);
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
model.StartTime = DateTime.Parse(request["CalendarStartTime"]).AddHours(zonediff);
model.EndTime = DateTime.Parse(request["CalendarEndTime"]).AddHours(zonediff);
model.UPAccount = context.Request.Cookies["UserID"].Value;
model.UPTime = DateTime.Now;
model.MasterId = clientzone;
model.Id = int.Parse(Id);
calendar.quickUpdate(model);
context.Response.Write("{IsSuccess:true}");
}
if (request["Action"] == "quickdel")
{
int id = Convert.ToInt32(request["calendarId"]);
calendar.Delete(id);
context.Response.Write("{IsSuccess:true}");
}
if (request["Action"] == "form")
{
int id = Convert.ToInt32(request["calendarid"]);
DataSet ds = calendar.GetList("Id=" + id);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
if (request["Action"] == "save")
{
string Id = request["calendarid"];
int clientzone = 8;
int serverzone = GetTimeZone();
var zonediff = serverzone - clientzone;
model.StartTime = DateTime.Parse(request["T_starttime"]).AddHours(zonediff);
model.EndTime = DateTime.Parse(request["T_endtime"]).AddHours(zonediff);
model.Subject = Common.PageValidate.InputText(request["T_content"], 4000);
model.emp_id = int.Parse(context.Request.Cookies["UserID"].Value);
model.UPAccount = context.Request.Cookies["UserID"].Value;
model.UPTime = DateTime.Now;
model.MasterId = clientzone;
model.CalendarType = 1;
model.InstanceType = 0;
model.IsAllDayEvent = PageValidate.InputText(request["allday"], 255) == "True" ? true : false;
model.Id = int.Parse(Id);
calendar.Update(model);
context.Response.Write("{IsSuccess:true}");
}
if (request["Action"] == "Today")
{
DateTime starttime = DateTime.Parse(DateTime.Now.ToShortDateString() + " 00:00:00");
DateTime endtime = DateTime.Parse(DateTime.Now.AddDays(1).ToShortDateString() + " 00:00:00");
//DataSet ds = calendar.GetList(0, "datediff(day,[StartTime],getdate())=0 and datediff(day,[EndTime],getdate())=0 and emp_id=" + int.Parse(request.Cookies["UserID"].Value), "[StartTime] desc");
DataSet ds = calendar.GetList(0, "'" + DateTime.Now.ToShortDateString() + "' between [StartTime] and [EndTime] and emp_id=" + int.Parse(request.Cookies["UserID"].Value), "[StartTime] desc");
context.Response.Write(GetGridJSON.DataTableToJSON(ds.Tables[0]));
}
}