public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (request["Action"] == "grid")
{
BLL.CRM_order_details cod = new BLL.CRM_order_details();
string orderid = request["orderid"];
DataSet ds = cod.GetList(" order_id=" + int.Parse( orderid));
context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0]));
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (request["Action"] == "grid")
{
BLL.CRM_order_details cod = new BLL.CRM_order_details();
string orderid = request["orderid"];
DataSet ds = cod.GetList(" order_id=" + int.Parse(orderid));
context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0]));
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
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"] == "grid")
{
BLL.CRM_order_details cod = new BLL.CRM_order_details();
string orderid = request["orderid"];
DataSet ds = cod.GetList(" order_id=" + int.Parse(orderid));
context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0]));
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.CRM_product ccp = new BLL.CRM_product();
Model.CRM_product model = new Model.CRM_product();
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.category_id = int.Parse(request["T_product_category_val"]);
model.category_name = PageValidate.InputText(request["T_product_category"], 255);
model.product_name = PageValidate.InputText(request["T_product_name"], 255);
model.specifications = PageValidate.InputText(request["T_specifications"], 255);
model.unit = PageValidate.InputText(request["T_product_unit"], 255);
model.remarks = PageValidate.InputText(request["T_remarks"], 255);
model.pway_content = PageValidate.InputText(request["T_pway_content"], 255);
model.price = decimal.Parse(request["T_price"].ToString());
model.base_price = decimal.Parse(request["T_base_price"].ToString());
string pid = request["pid"];
if (!string.IsNullOrEmpty(pid) && pid != "null")
{
model.product_id = int.Parse(PageValidate.IsNumber(pid) ? pid : "-1");
DataSet ds = ccp.GetList(" product_id=" + int.Parse(pid));
DataRow dr = ds.Tables[0].Rows[0];
ccp.Update(model);
//日志
C_Sys_log log = new C_Sys_log();
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
string EventTitle = model.product_name;
string EventType = "产品修改";
int EventID = model.product_id;
if (dr["category_name"].ToString() != request["T_product_category"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品类别", dr["category_name"].ToString(), request["T_product_category"]);
}
if (dr["product_name"].ToString() != request["T_product_name"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品名字", dr["product_name"].ToString(), request["T_product_name"]);
}
if (dr["specifications"].ToString() != request["T_specifications"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品规格", dr["specifications"].ToString(), request["T_specifications"]);
}
if (dr["unit"].ToString() != request["T_product_unit"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "单位", dr["unit"].ToString(), request["T_product_unit"]);
}
if (dr["remarks"].ToString() != request["T_remarks"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "备注", dr["remarks"].ToString(), request["T_remarks"]);
}
if (dr["price"].ToString() != request["T_price"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "价格", dr["price"].ToString(), request["T_price"]);
}
if (dr["base_price"].ToString() != request["T_base_price"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "底价", dr["base_price"].ToString(), request["T_base_price"]);
}
}
else
{
model.isDelete = 0;
ccp.Add(model);
}
}
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 = " category_id";
if (string.IsNullOrEmpty(sortorder))
sortorder = "desc";
string sorttext = " " + sortname + " " + sortorder;
string Total;
string serchtxt = null;
string serchtype = request["isdel"];
if (serchtype == "1")
{
serchtxt += " isDelete=1 ";
}
else
{
serchtxt += " isDelete=0 ";
}
string categoryid = request["categoryid"];
if (!string.IsNullOrEmpty(categoryid) && categoryid != "null")
{
serchtxt += " and category_id=" + (PageValidate.IsNumber(categoryid) ? categoryid : "-1");
}
if (!string.IsNullOrEmpty(request["company"]))
serchtxt += " and product_name like N'%" + PageValidate.InputText( request["company"],255) + "%'";
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 + "'";
}
//权限
DataSet ds = ccp.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total);
string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total);
context.Response.Write(dt);
}
if (request["Action"] == "gridmode")
{
int pid = int.Parse(request["pid"]);
DataSet ds = ccp.GetModeList(" product_id=" + pid);
/*
//string dt = Common.DataToJson.DataToJSON(ds);
string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], "0");
context.Response.Write(dt);
*/
string modescript = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
modescript += "{";
modescript += "id: '" + ds.Tables[0].Rows[i]["mode_name"].ToString() + "',";
modescript += "text: '" + ds.Tables[0].Rows[i]["mode_name"].ToString() + "'";
modescript += "},";
}
if (modescript != "")
modescript = modescript.Substring(0, modescript.Length - 1);
modescript = "{Rows:[" + modescript;
modescript += "]}";
context.Response.Write(modescript);
}
if (request["Action"] == "form")
{
int pid = int.Parse(request["pid"]);
DataSet ds = ccp.GetList(" product_id=" + pid);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
//del
if (request["Action"] == "AdvanceDelete")
{
//参数安全过滤
string c_id = request["id"];
DataSet ds = ccp.GetList(" product_id=" + int.Parse( c_id));
BLL.CRM_order_details ccod = new BLL.CRM_order_details();
if (ccod.GetList("product_id=" + c_id).Tables[0].Rows.Count > 0)
{
//order
context.Response.Write("false:order");
}
else
{
bool isdel = ccp.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
if (isdel)
{
//日志
string EventType = "产品预删除";
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(c_id);
string EventTitle = ds.Tables[0].Rows[0]["product_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");
}
}
}
//regain
if (request["Action"] == "regain")
{
string idlist = PageValidate.InputText( request["idlist"],100000);
string[] arr = idlist.Split(',');
DataSet ds = ccp.GetList("product_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
ccp.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]["product_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");
}
}
////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, "76");
if (delauth == "false")
canDel = false;
else
canDel = true;
}
}
if (canDel)
{
string idlist = PageValidate.InputText( request["idlist"],100000);
string[] arr = idlist.Split(',');
string EventType = "彻底删除产品";
DataSet ds = ccp.GetList(" product_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
ccp.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[i]["product_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("auth");
}
}
//serch
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.CRM_product ccp = new BLL.CRM_product();
Model.CRM_product model = new Model.CRM_product();
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.category_id = int.Parse(request["T_product_category_val"]);
model.category_name = PageValidate.InputText(request["T_product_category"], 255);
model.product_name = PageValidate.InputText(request["T_product_name"], 255);
model.specifications = PageValidate.InputText(request["T_specifications"], 255);
model.unit = PageValidate.InputText(request["T_product_unit"], 255);
model.remarks = PageValidate.InputText(request["T_remarks"], 255);
model.price = decimal.Parse(request["T_price"].ToString());
string pid = request["pid"];
if (!string.IsNullOrEmpty(pid) && pid != "null")
{
model.product_id = int.Parse(PageValidate.IsNumber(pid) ? pid : "-1");
DataSet ds = ccp.GetList(" product_id=" + int.Parse(pid));
DataRow dr = ds.Tables[0].Rows[0];
ccp.Update(model);
//日志
C_Sys_log log = new C_Sys_log();
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
string EventTitle = model.product_name;
string EventType = "产品修改";
int EventID = model.product_id;
if (dr["category_name"].ToString() != request["T_product_category"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品类别", dr["category_name"].ToString(), request["T_product_category"]);
}
if (dr["product_name"].ToString() != request["T_product_name"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品名字", dr["product_name"].ToString(), request["T_product_name"]);
}
if (dr["specifications"].ToString() != request["T_specifications"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品规格", dr["specifications"].ToString(), request["T_specifications"]);
}
if (dr["unit"].ToString() != request["T_product_unit"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "单位", dr["unit"].ToString(), request["T_product_unit"]);
}
if (dr["remarks"].ToString() != request["T_remarks"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "备注", dr["remarks"].ToString(), request["T_remarks"]);
}
if (dr["price"].ToString() != request["T_price"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "价格", dr["price"].ToString(), request["T_price"]);
}
}
else
{
ccp.Add(model);
}
}
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 = " product_name";
}
if (string.IsNullOrEmpty(sortorder))
{
sortorder = "desc";
}
string sorttext = " " + sortname + " " + sortorder;
string Total;
string serchtxt = null;
string serchtype = request["isdel"];
if (serchtype == "1")
{
serchtxt += " ISNULL(isDelete,0)=1 ";
}
else
{
serchtxt += "ISNULL(isDelete,0)=0 ";
}
string categoryid = request["categoryid"];
if (!string.IsNullOrEmpty(categoryid) && categoryid != "null")
{
serchtxt += " and category_id=" + (PageValidate.IsNumber(categoryid) ? categoryid : "-1");
}
if (!string.IsNullOrEmpty(request["company"]))
{
serchtxt += " and product_name like N'%" + PageValidate.InputText(request["company"], 255) + "%'";
}
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 + "'";
}
//权限
DataSet ds = ccp.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total);
string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total);
context.Response.Write(dt);
}
if (request["Action"] == "form")
{
int pid = int.Parse(request["pid"]);
DataSet ds = ccp.GetList(" product_id=" + pid);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
//del
if (request["Action"] == "AdvanceDelete")
{
//参数安全过滤
string c_id = request["id"];
DataSet ds = ccp.GetList(" product_id=" + int.Parse(c_id));
BLL.CRM_order_details ccod = new BLL.CRM_order_details();
if (ccod.GetList("product_id=" + c_id).Tables[0].Rows.Count > 0)
{
//order
context.Response.Write("false:order");
}
else
{
bool isdel = ccp.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss));
if (isdel)
{
//日志
string EventType = "产品预删除";
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(c_id);
string EventTitle = ds.Tables[0].Rows[0]["product_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");
}
}
}
//regain
if (request["Action"] == "regain")
{
string idlist = PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
DataSet ds = ccp.GetList("product_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
ccp.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]["product_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");
}
}
////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, "76");
if (delauth == "false")
{
canDel = false;
}
else
{
canDel = true;
}
}
}
if (canDel)
{
string idlist = PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
string EventType = "彻底删除产品";
DataSet ds = ccp.GetList(" product_id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
ccp.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[i]["product_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("auth");
}
}
//serch
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.CRM_product ccp = new BLL.CRM_product();
Model.CRM_product model = new Model.CRM_product();
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.category_id = int.Parse(request["T_product_category_val"]);
model.category_name = PageValidate.InputText(request["T_product_category"], 255);
model.product_name = PageValidate.InputText(request["T_product_name"], 255);
model.specifications = PageValidate.InputText(request["T_specifications"], 255);
model.unit = PageValidate.InputText(request["T_product_unit"], 255);
model.remarks = PageValidate.InputText(request["T_remarks"], 255);
model.price = decimal.Parse(request["T_price"].ToString());
string pid = PageValidate.InputText(request["pid"], 50);
if (!string.IsNullOrEmpty(pid) && pid != "null")
{
model.product_id = int.Parse(PageValidate.IsNumber(pid) ? pid : "-1");
DataSet ds = ccp.GetList(" product_id=" + int.Parse(pid));
DataRow dr = ds.Tables[0].Rows[0];
ccp.Update(model);
//日志
C_Sys_log log = new C_Sys_log();
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
string EventTitle = model.product_name;
string EventType = "产品修改";
int EventID = model.product_id;
if (dr["category_name"].ToString() != request["T_product_category"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品类别", dr["category_name"].ToString(), request["T_product_category"]);
}
if (dr["product_name"].ToString() != request["T_product_name"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品名字", dr["product_name"].ToString(), request["T_product_name"]);
}
if (dr["specifications"].ToString() != request["T_specifications"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "产品规格", dr["specifications"].ToString(), request["T_specifications"]);
}
if (dr["unit"].ToString() != request["T_product_unit"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "单位", dr["unit"].ToString(), request["T_product_unit"]);
}
if (dr["remarks"].ToString() != request["T_remarks"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "备注", dr["remarks"].ToString(), request["T_remarks"]);
}
if (dr["price"].ToString() != request["T_price"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "价格", dr["price"].ToString(), request["T_price"]);
}
}
else
{
model.isDelete = 0;
ccp.Add(model);
}
}
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 = " category_id";
}
if (string.IsNullOrEmpty(sortorder))
{
sortorder = "desc";
}
string sorttext = " " + sortname + " " + sortorder;
string Total;
string serchtxt = "1=1";
if (!string.IsNullOrEmpty(request["categoryid"]))
{
serchtxt += string.Format(" and category_id={0}", int.Parse(request["categoryid"]));
}
if (!string.IsNullOrEmpty(request["stext"]))
{
serchtxt += " and product_name like N'%" + PageValidate.InputText(request["stext"], 255) + "%'";
}
//权限
DataSet ds = ccp.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total);
string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total);
context.Response.Write(dt);
}
if (request["Action"] == "form")
{
int pid = int.Parse(request["pid"]);
DataSet ds = ccp.GetList(" product_id=" + pid);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
//del
if (request["Action"] == "del")
{
//参数安全过滤
string c_id = PageValidate.InputText(request["id"], 50);
DataSet ds = ccp.GetList(" product_id=" + int.Parse(c_id));
BLL.CRM_order_details ccod = new BLL.CRM_order_details();
if (ccod.GetList("product_id=" + int.Parse(c_id)).Tables[0].Rows.Count > 0)
{
//order
context.Response.Write("false:order");
}
else
{
bool isdel = ccp.Delete(int.Parse(c_id));
if (isdel)
{
//日志
string EventType = "产品删除";
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(c_id);
string EventTitle = ds.Tables[0].Rows[0]["product_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");
}
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.CRM_order order = new BLL.CRM_order();
Model.CRM_order model = new Model.CRM_order();
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")
{
DataRow dremp = dsemp.Tables[0].Rows[0];
model.Customer_id = int.Parse(request["T_Customer_val"]);
model.Customer_name = PageValidate.InputText(request["T_Customer"], 255);
model.Order_date = DateTime.Parse(request["T_date"]);
model.pay_type_id = int.Parse(request["T_paytype_val"]);
model.pay_type = PageValidate.InputText(request["T_paytype"], 255);
model.Order_details = PageValidate.InputText(request["T_details"].ToString(), 4000);
model.Order_status_id = int.Parse(request["T_status_val"]);
model.Order_status = PageValidate.InputText(request["T_status"], 255);
model.Order_amount = decimal.Parse(request["T_amount"]);
model.create_id = int.Parse(dremp["ID"].ToString());
model.create_date = DateTime.Now;
model.C_dep_id = int.Parse(request["T_department_val"]);
model.C_dep_name = PageValidate.InputText(request["T_department"], 255);
model.C_emp_id = int.Parse(request["T_employee_val"]);
model.C_emp_name = PageValidate.InputText(request["T_employee"], 255);
model.F_dep_id = int.Parse(request["T_department1_val"]);
model.F_dep_name = PageValidate.InputText(request["T_department1"], 255);
model.F_emp_id = int.Parse(request["T_employee1_val"]);
model.F_emp_name = PageValidate.InputText(request["T_employee1"], 255);
int orderid;
string pid = request["orderid"];
if (!string.IsNullOrEmpty(pid) && pid != "null")
{
model.id = int.Parse(PageValidate.IsNumber(pid) ? pid : "-1");
DataSet ds = order.GetList("id=" + model.id);
DataRow dr = ds.Tables[0].Rows[0];
orderid = model.id;
order.Update(model);
//context.Response.Write(model.id );
context.Response.Write("{success:success}");
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["Customer_name"].ToString() != request["T_Customer"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "客户", dr["Customer_name"].ToString(), request["T_Customer"]);
}
if (dr["Order_details"].ToString() != request["T_details"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单详情", "原内容被修改", "原内容被修改");
}
if (dr["Order_date"].ToString() != request["T_date"].ToString() + " 0:00:00")
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "成交时间", dr["Order_date"].ToString(), request["T_date"].ToString() + " 0:00:00");
}
if (dr["Order_amount"].ToString() != request["T_amount"].Replace(",", "").Replace(".00", ""))
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单总额", dr["Order_amount"].ToString(), request["T_amount"].Replace(",", "").Replace(".00", ""));
}
if (dr["Order_status"].ToString() != request["T_status"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单状态", dr["Order_status"].ToString(), request["T_status"]);
}
if (dr["F_dep_name"].ToString() != request["T_department1"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员部门", dr["F_dep_name"].ToString(), request["T_department1"]);
}
if (dr["F_emp_name"].ToString() != request["T_employee1"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员", dr["F_emp_name"].ToString(), request["T_employee1"]);
}
if (dr["pay_type"].ToString() != request["T_paytype"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "支付方式", dr["pay_type"].ToString(), request["T_paytype"]);
}
}
else
{
model.Serialnumber = DateTime.Now.AddMilliseconds(3).ToString("yyyyMMddHHmmssfff").Trim();
//model.arrears_invoice = decimal.Parse(request["T_amount"]);
orderid = order.Add(model);
context.Response.Write("{success:success}");
}
//更新订单收款金额
order.UpdateReceive(orderid.ToString());
//更新订单发票金额
order.UpdateInvoice(orderid.ToString());
string json = request["PostData"].ToLower();
JavaScriptSerializer js = new JavaScriptSerializer();
PostData[] postdata;
postdata = js.Deserialize <PostData[]>(json);
BLL.CRM_order_details cod = new BLL.CRM_order_details();
Model.CRM_order_details modeldel = new Model.CRM_order_details();
modeldel.order_id = orderid;
cod.Delete(" order_id=" + modeldel.order_id);
for (int i = 0; i < postdata.Length; i++)
{
modeldel.product_id = postdata[i].Product_id;
modeldel.product_name = postdata[i].Product_name;
modeldel.quantity = postdata[i].Quantity;
modeldel.unit = postdata[i].Unit;
modeldel.price = postdata[i].Price;
modeldel.amount = postdata[i].Amount;
cod.Add(modeldel);
}
}
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 = " Create_date";
}
if (string.IsNullOrEmpty(sortorder))
{
sortorder = "desc";
}
string sorttext = " " + sortname + " " + sortorder;
string Total;
string serchtxt = null;
string serchtype = request["isdel"];
if (serchtype == "1")
{
serchtxt += " ISNULL(isDelete,0)=1 ";
}
else
{
serchtxt += "ISNULL(isDelete,0)=0 ";
}
string issar = request["issarr"];
if (issar == "1")
{
serchtxt += " and isnull( arrears_money,0)>0";
}
if (!string.IsNullOrEmpty(request["company"]))
{
serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 100) + "%'";
}
if (!string.IsNullOrEmpty(request["contact"]))
{
serchtxt += " and Order_status_id = " + int.Parse(request["contact_val"]);
}
if (!string.IsNullOrEmpty(request["department"]))
{
serchtxt += " and F_dep_id = " + int.Parse(request["department_val"]);
}
if (!string.IsNullOrEmpty(request["employee"]))
{
serchtxt += " and F_emp_id = " + int.Parse(request["employee_val"]);
}
if (!string.IsNullOrEmpty(request["startdate"]))
{
serchtxt += " and Order_date >= '" + PageValidate.InputText(request["startdate"], 255) + "'";
}
if (!string.IsNullOrEmpty(request["enddate"]))
{
DateTime enddate = DateTime.Parse(request["enddate"]);
serchtxt += " and Order_date <= '" + DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59) + "'";
}
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 + "'";
}
//权限
DataSet ds = order.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total);
DataSet dsauth = DataAuth(ds, request.Cookies["UserID"].Value);
string dt = Common.GetGridJSON.DataTableToJSON1(dsauth.Tables[0], Total);
context.Response.Write(dt);
}
if (request["Action"] == "gridbycustomerid")
{
string customerid = request["customerid"];
DataSet ds = order.GetList(0, " ISNULL(isDelete,0)=0 and Customer_id =" + int.Parse(customerid), " Order_date desc");
context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0]));
}
if (request["Action"] == "form")
{
int pid = int.Parse(request["orderid"]);
DataSet ds = order.GetList("id=" + pid);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
if (request["Action"] == "AdvanceDelete")
{
//参数安全过滤
string c_id = request["id"];
DataSet ds = order.GetList("id=" + c_id);
BLL.CRM_contract contract = new BLL.CRM_contract();
BLL.CRM_invoice invoice = new BLL.CRM_invoice();
BLL.CRM_receive receive = new BLL.CRM_receive();
if (invoice.GetList("order_id=" + c_id).Tables[0].Rows.Count > 0)
{
//invoice
context.Response.Write("false:invoice");
}
else if (receive.GetList("order_id=" + c_id).Tables[0].Rows.Count > 0)
{
//receive
context.Response.Write("false:receive");
}
else
{
bool canedel = true;
if (uid != "admin")
{
Data.GetDataAuth dataauth = new Data.GetDataAuth();
string txt = dataauth.GetDataAuthByid("3", "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]["C_emp_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]["C_dep_id"].ToString() == arr[1])
{
canedel = true;
}
else
{
canedel = false;
}
}
break;
case "all":
canedel = true;
break;
}
}
if (canedel)
{
bool isdel = order.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString(StaticStr.yyyy_MM_dd_HH_mm_ss));
if (isdel)
{
//日志
string EventType = "订单预删除";
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(c_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");
}
}
}
//regain
if (request["Action"] == "regain")
{
string idlist = PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
DataSet ds = order.GetList("id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
order.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]["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");
}
}
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, "66");
if (delauth == "false")
{
canDel = false;
}
else
{
canDel = true;
}
}
}
if (canDel)
{
string idlist = PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
string EventType = "彻底删除订单";
DataSet ds = order.GetList("id in (" + idlist.Trim() + ")");
bool cando = true;
for (int i = 0; i < arr.Length; i++)
{
bool deleted = order.Delete(int.Parse(arr[i]));
if (!deleted)
{
cando = false;
}
}
if (cando)
{
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[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("false");
}
}
else
{
context.Response.Write("auth");
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
BLL.CRM_order order = new BLL.CRM_order();
Model.CRM_order model = new Model.CRM_order();
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")
{
DataRow dremp = dsemp.Tables[0].Rows[0];
model.Customer_id = int.Parse(request["T_Customer_val"]);
model.Customer_name = PageValidate.InputText(request["T_Customer"], 255);
model.Order_date = DateTime.Parse(request["T_date"]);
model.pay_type_id = int.Parse(request["T_paytype_val"]);
model.pay_type = PageValidate.InputText(request["T_paytype"], 255);
model.Order_details = PageValidate.InputText(request["T_details"].ToString(), 4000);
model.Order_status_id = int.Parse(request["T_status_val"]);
model.Order_status = PageValidate.InputText(request["T_status"], 255);
model.Order_amount = decimal.Parse(request["T_amount"]);
model.create_id = int.Parse(dremp["ID"].ToString());
model.create_date = DateTime.Now;
model.C_dep_id = int.Parse(request["T_department_val"]);
model.C_dep_name = PageValidate.InputText(request["T_department"], 255);
model.C_emp_id = int.Parse(request["T_employee_val"]);
model.C_emp_name = PageValidate.InputText(request["T_employee"], 255);
model.F_dep_id = int.Parse(request["T_department1_val"]);
model.F_dep_name = PageValidate.InputText(request["T_department1"], 255);
model.F_emp_id = int.Parse(request["T_employee1_val"]);
model.F_emp_name = PageValidate.InputText(request["T_employee1"], 255);
int orderid;
string pid = request["orderid"];
if (!string.IsNullOrEmpty(pid) && pid != "null")
{
model.id = int.Parse(PageValidate.IsNumber(pid) ? pid : "-1");
DataSet ds = order.GetList("id=" + model.id);
DataRow dr = ds.Tables[0].Rows[0];
orderid = model.id;
order.Update(model);
//context.Response.Write(model.id );
context.Response.Write("{success:success}");
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["Customer_name"].ToString() != request["T_Customer"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "客户", dr["Customer_name"].ToString(), request["T_Customer"]);
}
if (dr["Order_details"].ToString() != request["T_details"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单详情", "原内容被修改", "原内容被修改");
}
if (dr["Order_date"].ToString() != request["T_date"].ToString() + " 0:00:00")
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "成交时间", dr["Order_date"].ToString(), request["T_date"].ToString() + " 0:00:00");
}
if (dr["Order_amount"].ToString() != request["T_amount"].Replace(",", "").Replace(".00", ""))
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单总额", dr["Order_amount"].ToString(), request["T_amount"].Replace(",", "").Replace(".00", ""));
}
if (dr["Order_status"].ToString() != request["T_status"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "订单状态", dr["Order_status"].ToString(), request["T_status"]);
}
if (dr["F_dep_name"].ToString() != request["T_department1"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员部门", dr["F_dep_name"].ToString(), request["T_department1"]);
}
if (dr["F_emp_name"].ToString() != request["T_employee1"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "促成人员", dr["F_emp_name"].ToString(), request["T_employee1"]);
}
if (dr["pay_type"].ToString() != request["T_paytype"])
{
log.Add_log(UserID, UserName, IPStreet, EventTitle, EventType, EventID, "支付方式", dr["pay_type"].ToString(), request["T_paytype"]);
}
}
else
{
model.isDelete = 0;
model.Serialnumber = DateTime.Now.AddMilliseconds(3).ToString("yyyyMMddHHmmssfff").Trim();
//model.arrears_invoice = decimal.Parse(request["T_amount"]);
orderid = order.Add(model);
context.Response.Write("{success:success}");
}
//更新订单收款金额
order.UpdateReceive(orderid.ToString());
//更新订单发票金额
order.UpdateInvoice(orderid.ToString());
string json = request["PostData"].ToLower();
JavaScriptSerializer js = new JavaScriptSerializer();
PostData[] postdata;
postdata = js.Deserialize<PostData[]>(json);
BLL.CRM_order_details cod = new BLL.CRM_order_details();
Model.CRM_order_details modeldel = new Model.CRM_order_details();
modeldel.order_id = orderid;
cod.Delete(" order_id=" + modeldel.order_id);
for (int i = 0; i < postdata.Length; i++)
{
modeldel.product_id = postdata[i].Product_id;
modeldel.product_name = postdata[i].Product_name;
modeldel.quantity = postdata[i].Quantity;
modeldel.unit = postdata[i].Unit;
modeldel.price = postdata[i].Price;
modeldel.amount = postdata[i].Amount;
cod.Add(modeldel);
}
}
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;
string serchtype = request["isdel"];
if (serchtype == "1")
{
serchtxt += " isDelete=1 ";
}
else
{
serchtxt += " isDelete=0 ";
}
string issar = request["issarr"];
if (issar == "1")
{
serchtxt += " and isnull( arrears_money,0)>0";
}
if (!string.IsNullOrEmpty(request["company"]))
serchtxt += " and Customer_name like N'%" + PageValidate.InputText(request["company"], 100) + "%'";
if (!string.IsNullOrEmpty(request["contact"]))
serchtxt += " and Order_status_id = " + int.Parse(request["contact_val"]);
if (!string.IsNullOrEmpty(request["department"]))
serchtxt += " and F_dep_id = " + int.Parse(request["department_val"]);
if (!string.IsNullOrEmpty(request["employee"]))
serchtxt += " and F_emp_id = " + int.Parse(request["employee_val"]);
if (!string.IsNullOrEmpty(request["startdate"]))
serchtxt += " and Order_date >= '" + PageValidate.InputText(request["startdate"], 255) + "'";
if (!string.IsNullOrEmpty(request["enddate"]))
{
DateTime enddate = DateTime.Parse(request["enddate"]);
serchtxt += " and Order_date <= '" + DateTime.Parse(request["enddate"]).AddHours(23).AddMinutes(59).AddSeconds(59) + "'";
}
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 + "'";
}
//权限
serchtxt += DataAuth(request.Cookies["UserID"].Value);
DataSet ds = order.GetList(PageSize, PageIndex, serchtxt, sorttext, out Total);
string dt = Common.GetGridJSON.DataTableToJSON1(ds.Tables[0], Total);
context.Response.Write(dt);
}
if (request["Action"] == "gridbycustomerid")
{
string customerid = request["customerid"];
DataSet ds = order.GetList(0, " isDelete=0 and Customer_id =" + int.Parse(customerid), " Order_date desc");
context.Response.Write(Common.GetGridJSON.DataTableToJSON(ds.Tables[0]));
}
if (request["Action"] == "form")
{
int pid = int.Parse(request["orderid"]);
DataSet ds = order.GetList("id=" + pid);
string dt = Common.DataToJson.DataToJSON(ds);
context.Response.Write(dt);
}
if (request["Action"] == "AdvanceDelete")
{
//参数安全过滤
string c_id = request["id"];
DataSet ds = order.GetList("id=" + c_id);
BLL.CRM_contract contract = new BLL.CRM_contract();
BLL.CRM_invoice invoice = new BLL.CRM_invoice();
BLL.CRM_receive receive = new BLL.CRM_receive();
if (invoice.GetList("order_id=" + c_id).Tables[0].Rows.Count > 0)
{
//invoice
context.Response.Write("false:invoice");
}
else if (receive.GetList("order_id=" + c_id).Tables[0].Rows.Count > 0)
{
//receive
context.Response.Write("false:receive");
}
else
{
bool canedel = true;
if (uid != "admin")
{
Data.GetDataAuth dataauth = new Data.GetDataAuth();
string txt = dataauth.GetDataAuthByid("3", "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]["C_emp_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]["C_dep_id"].ToString() == arr[1])
canedel = true;
else
canedel = false;
}
break;
case "all":
canedel = true;
break;
}
}
if (canedel)
{
bool isdel = order.AdvanceDelete(int.Parse(c_id), 1, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
if (isdel)
{
//日志
string EventType = "订单预删除";
int UserID = emp_id;
string UserName = empname;
string IPStreet = request.UserHostAddress;
int EventID = int.Parse(c_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");
}
}
}
//regain
if (request["Action"] == "regain")
{
string idlist = PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
DataSet ds = order.GetList("id in (" + idlist.Trim() + ")");
for (int i = 0; i < arr.Length; i++)
{
order.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("false");
}
}
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, "66");
if (delauth == "false")
canDel = false;
else
canDel = true;
}
}
if (canDel)
{
string idlist = PageValidate.InputText(request["idlist"], 100000);
string[] arr = idlist.Split(',');
string EventType = "彻底删除订单";
DataSet ds = order.GetList("id in (" + idlist.Trim() + ")");
bool cando = true;
for (int i = 0; i < arr.Length; i++)
{
bool deleted = order.Delete(int.Parse(arr[i]));
if (!deleted)
cando = false;
}
if (cando)
{
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[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("false");
}
}
else
{
context.Response.Write("auth");
}
}
}
