/// <summary>
/// 修改密码
/// </summary>
/// <returns></returns>
public static string ModifyPwd(string pwd, string oldpwd)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
//string currentpwd = HttpContext.Current.Session["CurrentPwd"].ToString();//获取当前用户登陆密码
//var newpwditem = db.Users.FirstOrDefault(x => x.Pwd == currentpwd);
var user = db.Users.FirstOrDefault(x => x.ID.Equals(int.Parse(Common.TCContext.Current.OnlineUserID)));
var result = "";
if (user != null)
{
if (Interface.Comm.MD5.Encrypt(oldpwd, 32) != user.Pwd)
{
result = JsonConvert.SerializeObject(new { msg = "旧密码输入错误", state = 2 });
}
else
{
user.Pwd = Interface.Comm.MD5.Encrypt(pwd, 32);//md5加密
db.SubmitChanges();
result = JsonConvert.SerializeObject(new { msg = "修改成功", state = 1 });
//HttpContext.Current.Session["CurrentPwd"] = newpwditem.Pwd;//修改完存session
}
}
else
{
result = JsonConvert.SerializeObject(new { msg = "修改失败", state = 0 });
}
return(result);
}
}
public static string GetInfo(int ID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
string[] imgNULL = { };
var list = db.Store.Where(x => x.ID == ID).Select(x => new
{
Areas = x.Users.Areas,
x.Broadband,
x.StoreAddress,
x.Price,
x.OverTime,
CusManage = x.Users.Name,
x.ContactName,
x.ContactTel,
x.StoreName,
x.LastTime,
Img = x.Img != null ? x.Img.Split(';') : imgNULL,
x.State,
RemindID = x.StoreRemind.Where(y => y.Type == 1 && y.State == 0).OrderByDescending(y => y.ID).Select(y => new { RemindID = y.ID, y.AddTime, }).FirstOrDefault() != null ?
x.StoreRemind.Where(y => y.Type == 1 && y.State == 0).OrderByDescending(y => y.ID).Select(y => new { RemindID = y.ID, y.AddTime, }).FirstOrDefault().RemindID
: 0,//宽带到期提醒
}).FirstOrDefault();
var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" });
return(result);
}
}
public static string BalanceStatic()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var user = db.Users.Where(x => x.ID == int.Parse(Common.TCContext.Current.OnlineUserID)).FirstOrDefault();
var banacelist = db.SmallBalance.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString());
if (user.Roles.RoleName == "公司领导" || user.Roles.RoleName == "政企部主管")
{
banacelist = banacelist.Where(x => 1 == 1); //公司领导、政企部主管,都能看
}
else if (user.Roles.RoleName == "区县经理") //区县经理，能看本区县
{
banacelist = banacelist.Where(x => x.Users.Areas == user.Areas);
}
else if (user.Roles.RoleName == "客户经理" || user.Roles.RoleName == "网格助理" || user.Roles.RoleName == "行业经理")//客户经理、网格助理、行业经理，能看自己的
{
banacelist = banacelist.Where(x => x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID));
}
var banacereport = banacelist.Select(y => new
{
num = y.SmaBaRead.Where(x => x.IsRead == 1 && x.UserID == y.UserID).Count()
});
double banacecount = banacelist.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count(); //派单数量
double reportcount = banacereport.Count() <= 0 ? 0 : banacereport.Sum(t => t.num); //当月已读
var list = new { Procount = banacecount, Reportcount = reportcount, Reportrate = banacecount - reportcount };
string list1 = new JavaScriptSerializer().Serialize(list);
return(list1);
}
}
public static string MonthlySpecil()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var user = db.Users.Where(x => x.ID == int.Parse(Common.TCContext.Current.OnlineUserID)).FirstOrDefault();
//实际拍单数
var specillist = db.PrivateLine.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString() && x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID));
//回执数
var specilreport = specillist.Select(y => new
{
num = y.PlRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString() && x.State == 1).Count()
});
//总提醒量
var count = specillist.Select(y => new
{
num = y.PlRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count()
});
var no = specillist.Select(y => new
{
num = y.PlRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString() && x.State != 1).Count()
});
double specilcount = specillist.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count(); //派单数量
double reportcount = specilreport.Count() <= 0 ? 0 : specilreport.Sum(x => x.num); //当月回执数量（处理数量）
double counreport = count.Count() <= 0 ? 0 : count.Sum(x => x.num); //总的提醒量
//double nonereport = counreport - reportcount;//未处理
double nonereport = no.Count() == 0 ? 0 : no.Sum(x => x.num);
var list = new { Name = "专线派单", Specilcount = specilcount, Reportcount = reportcount, NoneReport = nonereport, CounReport = counreport };
string list1 = new JavaScriptSerializer().Serialize(list);
return(list1);
}
}
public static string GetZxRemind()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.PlRemind.Where(x => x.PrivateLine.UserID == int.Parse(Common.TCContext.Current.OnlineUserID) && x.State == 0).Select(x => new
{
x.PlID,
CompanyName = x.PrivateLine.CompanyName,
x.Type,
x.AddTime
}).OrderByDescending(x => x.AddTime).Take(5).ToList();
var list1 = list.Select(x => new
{ //1宽带到期 2拜访预约
x.PlID,
x.CompanyName,
Type = x.Type == 1 ? "专线" : x.Type == 2 ? "走访" : "",
AddTime = string.IsNullOrEmpty(x.AddTime) ? "" : Convert.ToDateTime(x.AddTime).ToString("yyyy-MM-dd HH:mm:ss"),
Number = list.Count()
});
var result = new { state = 1, data = list1 };
string list2 = new JavaScriptSerializer().Serialize(result);
return(list2);
}
}
public static string MonthlyBusiness()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var user = db.Users.Where(x => x.ID == int.Parse(Common.TCContext.Current.OnlineUserID)).FirstOrDefault();
var buslist = db.Business.Where(x => x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID));
var busreport = buslist.Select(y => new
{
num = y.BusRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString() && x.State == 1).Count()
});
var count = buslist.Select(y => new
{
num = y.BusRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count()
});
double buscount = buslist.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count(); //派单数量
double reportcount = busreport.Count() <= 0 ? 0 : busreport.Sum(x => x.num); //当月回执数量（处理数量）
double counreport = count.Count() <= 0 ? 0 : count.Sum(x => x.num); //总的提醒量
double nonereport = counreport - reportcount; //未处理
var list = new { Name = "商机派单", Buscount = buscount, Reportcount = reportcount, NoneReport = nonereport, CounReport = counreport };
string list1 = new JavaScriptSerializer().Serialize(list);
return(list1);
}
}
public static string Read(int SmBaID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
if (Common.TCContext.Current.OnlineUserID != "")
{
var UserID = Convert.ToInt32(Common.TCContext.Current.OnlineUserID);//用户ID
var list = db.SmaBaRead.Where(x => x.SmBaID == SmBaID && x.UserID == UserID).FirstOrDefault();
if (list == null)
{
SmaBaRead read = new SmaBaRead();
read.UserID = UserID;
read.SmBaID = SmBaID;
read.IsRead = 1;
db.SmaBaRead.InsertOnSubmit(read);
}
else
{
list.IsRead = 1;
}
db.SubmitChanges();
return(JsonConvert.SerializeObject(new { state = 1, msg = "请求成功" }));
}
return(JsonConvert.SerializeObject(new { state = 0, msg = "已读出错，请重新登录" }));
}
}
public static string ProjectAss()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var user = db.Users.Where(x => x.ID == int.Parse(Common.TCContext.Current.OnlineUserID)).FirstOrDefault();
var prolist = db.Project.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString());
//var proreport = db.ProRemind.Where(x => Convert.ToDateTime(x.ReceiptTime).Month.ToString() == DateTime.Now.Month.ToString() && x.State == 1);//当月的回执记录
if (user.Roles.RoleName == "公司领导" || user.Roles.RoleName == "政企部主管")
{
prolist = prolist.Where(x => 1 == 1); //公司领导、政企部主管,都能看
}
else if (user.Roles.RoleName == "区县经理") //区县经理，能看本区县
{
prolist = prolist.Where(x => x.Areas == user.Areas);
}
else if (user.Roles.RoleName == "客户经理" || user.Roles.RoleName == "网格助理" || user.Roles.RoleName == "行业经理")//客户经理、网格助理、行业经理，能看自己的
{
prolist = prolist.Where(x => x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID));
}
var proreport = prolist.Select(y => new
{
num = y.ProRemind.Where(x => Convert.ToDateTime(x.ReceiptTime).Month.ToString() == DateTime.Now.Month.ToString() && x.State == 1).Count()
});
double procount = prolist.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count(); //派单数量
double reportcount = proreport.Count() <= 0 ? 0 : proreport.Sum(x => x.num); //当月回执数量
var reportrate = procount == 0 ? "0" : Convert.ToDouble(reportcount / procount).ToString("0.00%");
var list = new { Procount = procount, Reportcount = reportcount, Reportrate = reportrate };
string list1 = new JavaScriptSerializer().Serialize(list);
return(list1);
}
}
public static string GetRegion1(int countyid)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Region.Where(x => x.Pid == countyid).Select(x => new { x.ID, x.Name });
return(new JavaScriptSerializer().Serialize(list));
}
}
public static string GetReminder()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Config.Where(x => 1 == 1).ToList();
return(new JavaScriptSerializer().Serialize(list));
}
}
public static string GetRole()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Roles.Where(x => 1 == 1).Select(x => new { x.RoleName });
return(new JavaScriptSerializer().Serialize(list));
}
}
public static string GetOne(int ID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Store.Where(x => x.ID == ID).Select(x => new { x.StoreName, x.StoreAddress, x.Broadband, x.Price, x.OverTime, x.ContactName, x.ContactTel }).FirstOrDefault();
string list1 = new JavaScriptSerializer().Serialize(list);
return(list1);
}
}
public static string GetRegion1()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Region.Where(x => x.Pid == 0).Select(x => new { x.ID }).FirstOrDefault();
var list1 = db.Region.Where(x => x.Pid == list.ID).Select(x => new { x.ID, x.Name });
return(new JavaScriptSerializer().Serialize(list1));
}
}
public static string GetFOthorYW()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Dic.Where(x => x.Name == "固网其他业务").Select(x => new { x.ID }).FirstOrDefault();
var list1 = db.Dic.Where(x => x.PID == list.ID).Select(x => new { x.ID, x.Name });
return(new JavaScriptSerializer().Serialize(list1));
}
}
/// <summary>
/// 登陆
/// </summary>
/// <returns></returns>
public static string Login1(string UserName, string Password, string code)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var result = "";
//var pwd = Interface.Comm.MD5.Encrypt(Password, 32);
var loginuser = db.Users.FirstOrDefault(x => x.Mobile == UserName && x.Pwd == Password);
var exitlogin = db.Users.FirstOrDefault(x => x.Mobile == UserName);
if (!code.ToUpper().Equals(HttpContext.Current.Request.Cookies["yzm"].Value))
{
result = JsonConvert.SerializeObject(new { msg = "验证码错误", state = 4 });
//return;
return(result);
}
if (loginuser != null)
{
result = JsonConvert.SerializeObject(new { msg = "登陆成功", state = 1 });
OperateLog opermodel = new OperateLog(); //日志记录
opermodel.Operator = loginuser.Name; //操作人
opermodel.OperTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //操作时间
opermodel.OperType = "登陆"; //操作类型
opermodel.Operdescribe = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + loginuser.Name + "登陆该系统"; //操作描述
db.OperateLog.InsertOnSubmit(opermodel);
db.SubmitChanges();
//HttpContext.Current.Session["CurrentUerName"] = loginuser.Name;
//HttpContext.Current.Session["CurrentPwd"] = loginuser.Pwd;
//HttpContext.Current.Session["CurrentUer"] = loginuser;//登陆信息存入session
FormsAuthentication.SetAuthCookie(loginuser.ID.ToString(), false);
Common.TCContext.Current.OnlineUserNickName = loginuser.Mobile;
Common.TCContext.Current.OnlineRealName = loginuser.Name;
Common.TCContext.Current.OnlineUserID = loginuser.ID.ToString();
Common.TCContext.Current.OnlineUserType = loginuser.Roles.RoleName.ToString();
Common.TCContext.Current.OnlineArea = loginuser.Areas.ToString();
if (loginuser.Pwd == "123456")
{
result = JsonConvert.SerializeObject(new { msg = "请修改密码", state = 2 });
}
}
else
{
if (exitlogin == null)
{
result = JsonConvert.SerializeObject(new { msg = "用户名不存在", state = 3 });
}
else
{
result = JsonConvert.SerializeObject(new { msg = "用户名或密码错误", state = 0 });
}
}
return(result);
}
}
public static string Get(string Areas, string State, string UpdateStartTime, string UpdateEndTime, string pageIndex)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var user = db.Users.Where(x => x.ID == int.Parse(Common.TCContext.Current.OnlineUserID)).FirstOrDefault();
int pageSize = 10;
var list = db.Project.Where(x => 1 == 1).Select(x => new
{
x.ID,
x.Areas,
x.Introduce,
x.AddTime,
x.LastTime,
x.State,
x.UserID,
UserAreas = x.Users.Areas,
UserName = x.Users.Name,
x.Type,
});
if (user.Roles.RoleName == "公司领导" || user.Roles.RoleName == "政企部主管")
{
list = list.Where(x => 1 == 1);//公司领导、政企部主管、行业经理,都能看
}
if (user.Roles.RoleName == "区县经理")//区县经理看自己
{
list = list.Where(x => x.UserAreas == user.Areas);
//list = list.Where(x => x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID));
}
if (user.Roles.RoleName == "客户经理" || user.Roles.RoleName == "网格助理" || user.Roles.RoleName == "行业经理")//客户经理、网格助理、行业经理，能看自己的
{
list = list.Where(x => x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID));
}
if (!string.IsNullOrEmpty(Areas))
{
list = list.Where(x => x.UserAreas == Areas);
}
if (State != "")
{
list = list.Where(x => x.State == int.Parse(State));
}
if (!string.IsNullOrEmpty(UpdateStartTime) && !string.IsNullOrEmpty(UpdateEndTime))
{
list = list.Where(x => Convert.ToDateTime(x.LastTime) >= Convert.ToDateTime(UpdateStartTime) && Convert.ToDateTime(x.LastTime) < Convert.ToDateTime(UpdateEndTime).AddDays(1));
}
var list1 = list.OrderByDescending(x => x.LastTime).Skip((int.Parse(pageIndex) - 1) * pageSize).Take(pageSize).ToList();
var result = new { status = "1", data = list1, pagecount = list.Count().ToString(), pagesize = pageSize.ToString() };
string list2 = new JavaScriptSerializer().Serialize(result);
return(list2);
}
}
public static string GetRemind(int BaID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.SmaBaRemind.Where(x => x.SmBaID == BaID).Select(x => new
{
x.ReceiptTime,
x.ReceiptContent
}).FirstOrDefault();
var result = JsonConvert.SerializeObject(new { data = list });
return(result);
}
}
public static string Edit(int ID, string StoreName, string Broadband, string Price, string OverTime, string ContactName, string ContactTel, string StoreAddress, string OtherNeeds)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var item = db.Store.FirstOrDefault(x => x.ID == ID);
var result = "";
if (item != null)
{
item.ID = ID;
item.StoreName = StoreName;
item.Broadband = Broadband;
item.Price = Price;
item.OverTime = OverTime;
item.ContactName = ContactName;
item.ContactTel = ContactTel;
item.StoreAddress = StoreAddress;
item.OtherNeeds = OtherNeeds;
item.LastTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
#region 状态判断
if (item.State == 0)//正常
{
//正常修改不处理
}
else if (item.State == 1)//已派单
{
item.State = 0;
var sr = item.StoreRemind.Where(x => x.Type == 1).OrderByDescending(x => x.AddTime).FirstOrDefault();//最新提醒
if (sr != null)
{
sr.State = 2;//未处理
}
}
else if (item.State == 2) //已回执
{
item.State = 0; //正常
}
#endregion
db.SubmitChanges();
result = JsonConvert.SerializeObject(new { msg = "修改成功", state = 1 });
}
else
{
result = JsonConvert.SerializeObject(new { msg = "修改失败", state = 0 });
}
return(result);
}
}
public static string GetDic(string DicName)
{
string[] nullList = { };//空数组
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Dic.Where(x => x.Name == DicName).Select(x => new { x.ID }).FirstOrDefault();
if (list != null)
{
var list1 = db.Dic.Where(x => x.PID == list.ID).Select(x => new { x.ID, x.Name }).ToList();
return(new JavaScriptSerializer().Serialize(list1));
}
return(new JavaScriptSerializer().Serialize(nullList));
}
}
public void Export(string Areas, string Industry, string Operator, string Scale, string starttime, string endtime, string Search)
{
dbDataContext db = new HsBusiness.dbDataContext();
var list = db.Business.Where(x => 1 == 1).Select(x => new
{
x.Areas,
x.ID,
x.UserID,
x.Industry,
x.IsFixed,
x.IsMove,
x.AddTime,
x.CompanyName,
x.CustomerScale,
x.MOperator,
x.FOperator,
x.FScale,
x.FUseScale,
x.LastTime,
x.MState,
x.FState,
UserName = x.Users.Name,
VisitNum = x.Visit.Count
});
if (Areas != "")
{
list = list.Where(x => x.Areas == Areas);
}
if (Industry != "")
{
list = list.Where(x => x.Industry == Industry);
}
if (Operator != "")
{
list = list.Where(x => x.FOperator == Operator);
}
if (Scale != "")
{
list = list.Where(x => x.CustomerScale == Scale);
}
if (starttime != "" && endtime != "")
{
list = list.Where(x => Convert.ToDateTime(x.LastTime) > Convert.ToDateTime(starttime) && Convert.ToDateTime(x.LastTime) < Convert.ToDateTime(endtime));
}
if (!string.IsNullOrEmpty(Search))
{
list = list.Where(x => x.CompanyName.Contains(Search) || x.Areas.Contains(Search));
}
}
public static string GetBasisInfo(int PLID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.PrivateLine.Where(x => x.ID == PLID).Select(x => new
{
x.ID,
x.CompanyName,
x.CompanyAddress,
x.Remark,
x.AddTime
});
var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" });
return(result);
}
}
public static string GetInfo(int ID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Project.Where(x => x.ID == ID).Select(x => new
{
x.AddTime,
x.Introduce,
x.Instruction,
x.Areas,
x.LastTime
});
var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" });
return(result);
}
}
public static string MonthlyStock()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
//var user = db.Users.Where(x => x.ID == int.Parse(Common.TCContext.Current.OnlineUserID)).FirstOrDefault();
//var bancelist = db.SmallBalance.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString()&& Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString() && x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID));
//var bancereport = bancelist.Select(y => new
//{
// num = y.SmaBaRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString()&& Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString() && x.State == 1).Count()
//});
//var count = bancelist.Select(y => new
//{
// num = y.SmaBaRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString()&& Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count()
//});
//double bancecount = bancelist.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString()&& Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count();//实际派单数量
//double counreport = count.Count() <= 0 ? 0 : count.Sum(x => x.num);//总的回执量
//double reportcount = bancereport.Count() <= 0 ? 0 : bancereport.Sum(x => x.num);//当月回执数量（处理数量）
//double nonereport = counreport - reportcount;//未处理
//var list = new { Name = "存量派单", Bancecount = bancecount, Reportcount = reportcount, NoneReport = nonereport, CounReport = counreport };
//string list1 = new JavaScriptSerializer().Serialize(list);
//return list1;
var banacelist = db.SmallBalance.Where(x => x.UserID == int.Parse(Common.TCContext.Current.OnlineUserID)).Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString());
var banacereport = banacelist.Select(y => new
{
num = y.SmaBaRead.Where(x => x.IsRead == 1 && x.UserID == y.UserID).Count()
});
var allremind = banacelist.Select(y => new
{
num = y.SmaBaRemind.Where(x => Convert.ToDateTime(x.AddTime).Year.ToString() == DateTime.Now.Year.ToString() && Convert.ToDateTime(x.AddTime).Month.ToString() == DateTime.Now.Month.ToString()).Count()
});
double countremind = allremind.Count() <= 0 ? 0 : allremind.Sum(t => t.num); //总提醒
double banacecount = banacelist.Count(); //派单数量
double reportcount = banacereport.Count() <= 0 ? 0 : banacereport.Sum(t => t.num); //当月已读(已处理)
double noneread = banacecount - reportcount; //未读
var list = new { Name = "到期派单", Procount = banacecount, Reportcount = countremind, IsRead = reportcount, NoneRead = noneread };
string list1 = new JavaScriptSerializer().Serialize(list);
return(list1);
}
}
public static string DeleteAll()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
string result = "";
var item = db.SmallBalance.Where(x => true).ToList();
db.SmallBalance.DeleteAllOnSubmit(item);
OperateLog opermodel = new OperateLog();
opermodel.Operator = Common.TCContext.Current.OnlineRealName.ToString(); //操作人
opermodel.OperTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //操作时间
opermodel.OperType = "全部删除"; //操作类型
opermodel.Operdescribe = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + Common.TCContext.Current.OnlineRealName + "进行了批量删除操作";
db.SubmitChanges();
result = JsonConvert.SerializeObject(new { msg = "删除成功", stste = 1 });
return(result);
}
}
public static string GetVistInfo(int ID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
string[] imgNULL = { };
var list = db.ProVisit.Where(x => x.ProID == ID).Select(x => new
{
x.AddTime,
x.VisitContents,
Img = x.Img != null ? x.Img.Split(';') : imgNULL,
FzrName = x.Users.Name,
x.NextTime,
State = x.State == 0?"正常":x.State == 1?"已派单":x.State == 2?"已回执":""
}).OrderByDescending(x => x.AddTime).ToList();
var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" });
return(result);
}
}
public static string GetRemind(int ID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Project.Where(x => x.ID == ID).Select(x => new
{
Remind = x.ProRemind.Where(y => y.State == 1).Select(y => new
{
y.RemindContents, //回执内容
y.ReceiptTime, //回执时间
Areas = y.Project.Areas, //回执区县
UserName = y.Project.Users.Name //回执人
}).OrderByDescending(y => y.ReceiptTime)
}).FirstOrDefault();
var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" });
return(result);
}
}
public static string SpecialInfo(int PLID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.PlInfo.Where(x => x.PlID == PLID && x.Type != 3).Select(x => new
{
x.ID,
x.Operator,
x.WeekPrice,
x.BandWidth,
x.PayType,
x.OverTime,
State = x.State == 0?"正常":x.State == 1?"已提醒":x.State == 2?"已回执":"",
Type = x.Type == 1?"专线":"电路"
}).OrderByDescending(x => x.OverTime);
var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" });
return(result);
}
}
public static string GetInfo(string Areas, string Post, string Search, string starttime, string endtime, string pageIndex)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
int pageSize = 10;
var list = db.Users.Where(x => x.Name != "admin").Select(x => new
{
x.Areas,
x.Post,
x.Name,
x.Mobile,
AppLogCount = db.ApiLog.Where(y => y.UserID == x.ID && y.RequestName == "/Users/Login").Count(), //app登陆次数
AppLogTime = db.ApiLog.Where(y => y.UserID == x.ID && y.RequestName == "/Users/Login").OrderByDescending(y => y.AddTime).Select(y => new { y.AddTime }).FirstOrDefault().AddTime, //app最近登陆时间
WebLogCount = db.OperateLog.Where(t => t.Operator == x.Name).Count(), //web登陆次数
WebLogTime = db.OperateLog.Where(t => t.Operator == x.Name).OrderByDescending(y => y.OperTime).Select(t => new { t.OperTime }).FirstOrDefault().OperTime, //web最近登陆时间
});
if (!string.IsNullOrEmpty(Areas))
{
list = list.Where(x => x.Areas == Areas);
}
if (!string.IsNullOrEmpty(Post))
{
list = list.Where(x => x.Post == Post);
}
if (!string.IsNullOrEmpty(starttime) && !string.IsNullOrEmpty(endtime))
{
list = list.Where(x => (Convert.ToDateTime(x.AppLogTime) >= Convert.ToDateTime(starttime) && Convert.ToDateTime(x.AppLogTime) <= Convert.ToDateTime(endtime).AddDays(1)) ||
(Convert.ToDateTime(x.WebLogTime) >= Convert.ToDateTime(starttime) && Convert.ToDateTime(x.WebLogTime) <= Convert.ToDateTime(endtime).AddDays(1)));
}
if (!string.IsNullOrEmpty(Search))
{
list = list.Where(x => x.Name.Contains(Search) || x.Mobile.Contains(Search));
}
var list1 = list.Skip((int.Parse(pageIndex) - 1) * pageSize).Take(pageSize);
var result = new { status = "1", data = list1, pagecount = list.Count().ToString(), pagesize = pageSize.ToString() };
string list2 = new JavaScriptSerializer().Serialize(result);
return(list2);
}
}
public static string Report()
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.Reports.Where(x => x.Month == DateTime.Now.ToString("yyyyMM").Substring(0, 6));//当月报表
var resultList = list
.OrderBy(x => x.Rank).Take(3)
.Select(x => new
{
x.Month,
x.Name,
x.Rank,
x.NewIncome,
x.R0Aims,
x.R0CompleteRate,
x.R2Aims,
x.R2CompleteRate,
x.StockIncome,
x.StockIncomeRate,
x.TotalIncome,
}).ToList()
.Select(x => new
{
x.Month,
x.Name,
x.Rank,
NewIncome = Convert.ToDouble(x.NewIncome).ToString("0.00"),
R0Aims = Convert.ToDouble(x.R0Aims).ToString("0.00"),
R0CompleteRate = (Convert.ToDouble(x.R0CompleteRate) * 100).ToString("0.00"),
R2Aims = Convert.ToDouble(x.R2Aims).ToString("0.00"),
R2CompleteRate = (Convert.ToDouble(x.R2CompleteRate) * 100).ToString("0.00"),
StockIncome = Convert.ToDouble(x.StockIncome).ToString("0.00"),
StockIncomeRate = (Convert.ToDouble(x.StockIncomeRate) * 100).ToString("0.00"),
TotalIncome = Convert.ToDouble(x.TotalIncome).ToString("0.00"),
});
var result = new { status = "1", data = resultList };
string list2 = new JavaScriptSerializer().Serialize(result);
return(list2);
}
}
public static string BasicInfo(int PLID)
{
using (dbDataContext db = new HsBusiness.dbDataContext())
{
var list = db.PrivateLine.Where(x => x.ID == PLID).Select(x => new
{
Contacts = x.PlContacts.Where(y => y.PlID == x.ID).Select(y => new
{
CompanyName = y.PrivateLine.CompanyName,
CompanyAddress = y.PrivateLine.CompanyAddress,
LastTime = y.PrivateLine.LastTime,
x.Remark,//备注
y.ID,
y.Name,
y.Post,
y.Tel
}).ToList()
}).FirstOrDefault();
var result = JsonConvert.SerializeObject(new { data = list, stste = 1, msg = "成功" });
return(result);
}
}
