private double GetYF(Guid id, int type) { double s = 0; string mouth = DateTime.Now.Month + ""; if (DateTime.Now.Month + 1 < 10) { mouth = "0" + DateTime.Now.Month; } string date = DateTime.Now.Year + "-" + mouth;//本月 using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var qu = cc.GrabageWeightSon.Where(x => x.GrabageRoom.VillageId == id && x.IsDelete != "1" && x.AddTime.Contains(date) && x.GrabageRoomId != null); if (type == 1) { qu = qu.Where(x => x.Type.Contains("1")); } else if (type == 2) { qu = qu.Where(x => !x.Type.Contains("1")); } foreach (var item in qu.ToList()) { s += double.Parse(item.Weight); } return(s); } }
public ShopController(RefuseClassificationContext dbContext, IMapper mapper, IOptions <MdDesEncrypt> mdDesEncrypt, IHostingEnvironment hostingEnvironment) { _dbContext = dbContext; _mapper = mapper; MdDesEncrypt = mdDesEncrypt.Value; _hostingEnvironment = hostingEnvironment; }
/// <summary> /// 获取总服务次数 /// </summary> /// <param name="id"></param> /// <returns></returns> private static int GetAllCount(Guid id) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { //var query = (from a in cc.VolunteerService // where a.SystemUserUuid == id && a.IsDelete != "1" // select a).ToList(); //return query.Count().ToString(); int count = 0;//打卡次数 //搜索志愿者打卡次数 var a = cc.Attendance.Where(x => x.Type == "1" && x.IsDelete != "1" && x.SystemUserUuid == id).ToList(); foreach (var item in a) { //上/下午有一次打卡记录就加1,一天最多2次 if (!string.IsNullOrEmpty(item.AmstartTime) || !string.IsNullOrEmpty(item.AmendTime)) { count++; } if (!string.IsNullOrEmpty(item.PmstartTime) || !string.IsNullOrEmpty(item.PmendTime)) { count++; } } return(count); } }
public RubbishController(RefuseClassificationContext dbContext, IMapper mapper, IOptions <MdDesEncrypt> mdDesEncrypt, IHostingEnvironment hostingEnvironment, ILogger <TestController> logger) { _dbContext = dbContext; _mapper = mapper; _hostingEnvironment = hostingEnvironment; _logger = logger; }
public GlobalController(RefuseClassificationContext dbContext, IMapper mapper, IHostingEnvironment ihhostingEnvironment) { _dbContext = dbContext; _mapper = mapper; _hostEnv = ihhostingEnvironment; }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> /// <param name="mapper"></param> public UserController(RefuseClassificationContext dbContext, IMapper mapper, IOptions <MdDesEncrypt> mdDesEncrypt, IOptions <AppAuthenticationSettings> appSettings) { _appSettings = appSettings.Value; _dbContext = dbContext; _mapper = mapper; MdDesEncrypt = mdDesEncrypt.Value; }
//异常打卡次数 private string GetPeople(Guid id) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = (from a in cc.Attendance where a.GarbageRoomUuid == id && a.IsDelete != "1" && (a.StartState == 0 || a.EndState == 0) select a).ToList(); return(query.Count().ToString()); } }
private static int GetAllzyzScore(Guid id) { int s = 0; using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = cc.Overallsituation.FirstOrDefault(); //string t = GetServiceTime(id); s = query.HourScore * GetAllCount(id); return(s); } }
private static string GraRoom(Guid guid, int type) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { //_logger.LogError(message: "66666666666"); string s = ""; var groom = ""; if (type == 1) { var ddquery = (from a in cc.SystemUser where a.GrabageRoomId == guid select new { a.SystemUserUuid }).ToList(); for (int i = 0; i < ddquery.Count; i++) { groom = cc.SystemUser.FirstOrDefault(x => x.SystemUserUuid == ddquery[i].SystemUserUuid && x.IsDeleted != 1)?.RealName; } } else { var query = (from a in cc.GrabageWeightSon where a.GrabageRoomId == guid group a by a.CarUuid into b select new { b.Key }).ToList(); for (int i = 0; i < query.Count; i++) { groom = cc.Car.FirstOrDefault(x => x.CarUuid == query[i].Key && x.IsDelete != 1)?.CarNum; } } if (s == "") { s = groom; } else { s += "," + groom; } //_logger.LogError(message: "888888888"); return(s); } }
/// <summary> /// 获取总服务时长 /// </summary> /// <param name="id"></param> /// <returns></returns> private static string GetServiceTime(Guid id) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = (from a in cc.Attendance where a.SystemUserUuid == id && a.IsDelete != "1" && a.Type == "1" select a).ToList(); TimeSpan s = new TimeSpan(); foreach (var item in query) { //上午 if (!string.IsNullOrEmpty(item.AmstartTime) || !string.IsNullOrEmpty(item.AmendTime)) { //当天日期 //没有签退时间就默认为12:00 if (!string.IsNullOrEmpty(item.AmendTime)) { s += (DateTime.Parse(item.AmendTime) - DateTime.Parse(item.AmstartTime)); } else { string date = item.AmstartTime.Trim().Split(" ")[0]; s += (DateTime.Parse(date + " 12:00:00") - DateTime.Parse(item.AmstartTime)); } } //下午 if (!string.IsNullOrEmpty(item.PmstartTime) || !string.IsNullOrEmpty(item.PmendTime)) { //没有签退时间就默认为24:00 if (!string.IsNullOrEmpty(item.PmendTime)) { s += (DateTime.Parse(item.PmendTime) - DateTime.Parse(item.PmstartTime)); } else { string date = item.PmstartTime.Trim().Split(" ")[0]; s += (DateTime.Parse(date + " 23:59:59") - DateTime.Parse(item.PmstartTime)); } } //if (!string.IsNullOrEmpty(item.Intime) && !string.IsNullOrEmpty(item.Outtime)) //{ // s += (DateTime.Parse(item.Outtime) - DateTime.Parse(item.Intime)); //} } return(Math.Floor(s.TotalHours).ToString()); } }
private int YHjifen(string id) { string mouth = DateTime.Now.Month + ""; if (DateTime.Now.Month + 1 < 10) { mouth = "0" + DateTime.Now.Month; } string date = DateTime.Now.Year + "-" + mouth;//本月 using (RefuseClassificationContext cc = new RefuseClassificationContext()) { int qu = cc.GrabageDisposal.Where(x => x.HomeAddressUuid == Guid.Parse(id) && x.IsDelete != "1" && x.AddTime.Contains(date)).Select(x => new { Integral = x.ScoreSettingUu.Integral }).Sum(x => x.Integral).Value; return(qu); } }
private string getGoods(Guid id) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { string s = ""; var req = cc.Goods.Where(x => x.ShopId == id && x.State != "1"); if (req == null) { return(""); } foreach (var item in req) { s += item.Gname + ","; } return(s.TrimEnd(',')); } }
//收运垃圾类型 private string GetGarbage(Guid ljid) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = (from a in cc.RubbishSyrecord where a.CarUuid == ljid && a.IsDelete == "0" select a).ToList(); string s = ""; foreach (var item in query) { if (!string.IsNullOrEmpty(item.RubbishType)) { s += item.RubbishType; } } return(s); } }
private double GetUsedScore(Guid ownid) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = (from a in cc.GoodsExchange where a.SystemUserUuid == ownid select a).ToList(); double s = 0; foreach (var item in query) { if (!string.IsNullOrEmpty(item.DeduceScore)) { s += double.Parse(item.DeduceScore); } } return(s); } }
/// <summary> /// 获取单个分数 /// </summary> /// <param name="id"></param> /// <returns></returns> private static int GetSingleScore(Guid id) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { int hs = cc.Overallsituation.FirstOrDefault().HourScore; int s = 0; string t = ""; TimeSpan ts = new TimeSpan(); var query = cc.VolunteerService.FirstOrDefault(x => x.VolunteerServiceUuid == id); if (!string.IsNullOrEmpty(query.Intime) && !string.IsNullOrEmpty(query.Outtime)) { ts = (DateTime.Parse(query.Outtime) - DateTime.Parse(query.Intime)); } t = Math.Floor(ts.TotalHours).ToString(); s = hs * int.Parse(t); return(s); } }
//垃圾房 private string GetLj(Guid ljid) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = (from a in cc.GrabageRoom where a.CarId == ljid && a.IsDelete != "1" select a).ToList(); string s = ""; foreach (var item in query) { if (!string.IsNullOrEmpty(item.Ljname)) { s += item.Ljname + "、"; } } return(s.TrimEnd('、')); } }
private static int score(string name) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var num = (from g in cc.GrabageDisposal join h in cc.HomeAddress on g.HomeAddressUuid equals h.HomeAddressUuid join s in cc.ScoreSetting on g.ScoreSettingUuid equals s.ScoreUuid where h.Ccmmunity == name && g.IsScore == "1" && g.IsDelete != "1" select new { s.Integral }).Sum(x => x.Integral).Value; return(num); } }
//服务积分 private static int GetAllFWScore(Guid id) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = (from a in cc.VolunteerService where a.SystemUserUuid == id && a.IsDelete != "1" select a).ToList(); int s = 0; foreach (var item in query) { if (!string.IsNullOrEmpty(item.Score)) { s += int.Parse(item.Score); } } return(s); } }
public static bool CreateSystemLog(string OperationContent, string Type) { using (var _dbContext = new RefuseClassificationContext()) { var entity = new SystemLog(); entity.AddPeople = AuthContextService.CurrentUser.DisplayName; entity.AddTime = DateTime.Now; entity.OperationTime = DateTime.Now; //entity.Ipaddress = model.Ipaddress; entity.IsDelete = 1; entity.OperationContent = OperationContent; entity.Type = Type; entity.UserId = AuthContextService.CurrentUser.Guid.ToString(); entity.UserName = AuthContextService.CurrentUser.DisplayName; string UserType = AuthContextService.CurrentUser.UserType.ToString(); if (UserType == "SuperAdministrator") { entity.UserIdtype = 0; } else if (UserType == "Admin") { entity.UserIdtype = 1; } else if (UserType == "GeneralUser") { entity.UserIdtype = 2; } else if (UserType == "Parent") { entity.UserIdtype = 3; } else { entity.UserIdtype = 4; } _dbContext.SystemLog.Add(entity); _dbContext.SaveChanges(); return(true); } }
private string GetroleName(string ids) { string s = ""; string[] temp = ids.TrimEnd(',').Split(','); using (RefuseClassificationContext cc = new RefuseClassificationContext()) { for (int i = 0; i < temp.Length; i++) { if (!string.IsNullOrEmpty(temp[i])) { var qu = cc.SystemRole.Where(x => x.SystemRoleUuid == Guid.Parse(temp[i])).Select(x => new { x.RoleName }).ToList(); if (!string.IsNullOrEmpty(qu[0].RoleName)) { s += qu[0].RoleName + ","; } } } return(s.TrimEnd(',')); } }
/// <summary> /// 获取打卡次数 /// </summary> /// <param name="id"></param> /// <returns></returns> private int GetAllCount(Guid id) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { int count = 0;//打卡次数 //搜索志愿者打卡次数 var a = cc.Attendance.Where(x => x.Type == "1" && x.IsDelete != "1" && x.SystemUserUuid == id).ToList(); foreach (var item in a) { //上/下午有一次打卡记录就加1,一天最多2次 if (!string.IsNullOrEmpty(item.AmstartTime) || !string.IsNullOrEmpty(item.AmendTime)) { count++; } if (!string.IsNullOrEmpty(item.PmstartTime) || !string.IsNullOrEmpty(item.PmendTime)) { count++; } } return(count); } }
private double GetAllScore(Guid ownid) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = from a in cc.GrabageDisposal where a.HomeAddressUuid == ownid && a.IsScore == "1" select new { Score = a.ScoreSettingUu.Integral }; double s = 0; foreach (var item in query) { if (!string.IsNullOrEmpty(item.Score.ToString())) { s += (double)item.Score; } } return(s); } }
//投放积分 private static int GetAllTFScore(Guid ownid) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { var query = from a in cc.GrabageDisposal where a.SystemUserUuid == ownid && a.IsDelete != "1" select new { Score = a.ScoreSettingUu.Integral }; int s = 0; foreach (var item in query) { if (!string.IsNullOrEmpty(item.Score.ToString())) { s += (int)item.Score; } } return(s); } }
//单月易腐烂垃圾比例 private string GetRubbishBL(Guid id, int type) { string date = "0"; double s = 0; int month = 0; using (RefuseClassificationContext cc = new RefuseClassificationContext()) { if (month == 0) { //(当月易腐烂垃圾的重量) //var qu = cc.GrabageWeighting.Where(x => x.GrabageRoom.VillageId == id && x.IsDelete != "1"); //if (type == 1) // qu = qu.Where(x => x.Type.Contains("易腐")); //foreach (var item in qu) //{ // s += double.Parse(item.Weight); //} } else if (month == 13) { for (int i = 1; i <= 13; i++) { if (i != 13) { var qu = cc.GrabageWeighting.Where(x => x.GrabageRoom.VillageId == id && x.IsDelete != "1" && x.AddTime.Contains(date)); } else { } } } else { } return(s.ToString()); } }
private static string GraRoom(Guid guid, int type) { using (RefuseClassificationContext cc = new RefuseClassificationContext()) { string s = ""; var groom = ""; var query = (from a in cc.GrabageWeightSon where a.GrabageRoomId != null && a.CarUuid == guid group a by a.GrabageRoomId into b select new { b.Key }).ToList(); for (int i = 0; i < query.Count; i++) { if (type == 1) { groom = cc.GrabageRoom.FirstOrDefault(x => x.GarbageRoomUuid == query[i].Key && x.IsDelete != "1").Ljname; } else { groom = cc.GrabageRoom.FirstOrDefault(x => x.GarbageRoomUuid == query[i].Key && x.IsDelete != "1").WingId; } if (s == "") { s = groom; } else { s += "," + groom; } } return(s); } }
public StatisticsController(RefuseClassificationContext dbContext, IMapper mapper) { _dbContext = dbContext; _mapper = mapper; }
public ResponseController(RefuseClassificationContext dbContext, IMapper mapper) { _dbContext = dbContext; _mapper = mapper; }
public HouseholdController(RefuseClassificationContext dbContext, IMapper mapper) { _dbContext = dbContext; _mapper = mapper; }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> public AccountController(RefuseClassificationContext dbContext) { _dbContext = dbContext; }
public GoodsController(RefuseClassificationContext db) { _dbContext = db; }