public IActionResult CreateUser(SystemUser model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
if (_dbContext.SystemUser.Count(x => x.Phone == model.Phone) > 0)
{
response.SetFailed("该手机号已注册");
return(Ok(response));
}
var entity = new SystemUser();
entity.SystemUserUuid = Guid.NewGuid();
entity.RealName = model.RealName;
entity.LoginName = model.RealName;
entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey);
entity.Address = model.Address;
entity.OldCard = model.OldCard;
entity.Phone = model.Phone;
entity.UserType = 2;
entity.SystemRoleUuid = "C6BDB5B3-990B-4943-B2A1-1492044E38B8";//普通用户
entity.AddPeople = "微信自主注册";
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.IsDeleted = 0;
_dbContext.SystemUser.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess("注册成功");
return(Ok(response));
}
}
public IActionResult Create(CollegeViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.Village();
entity.VillageUuid = Guid.NewGuid();
if (_dbContext.Village.Where(x => x.IsDelete == "0").Count(x => x.Vname == model.Vname) > 0)
{
response.SetFailed("社区名已存在");
return(Ok(response));
}
entity.Vname = model.Vname; //社区
entity.Towns = model.Towns; //乡镇
entity.Exchange = model.Exchange;
entity.DisNum = model.DisNum;
//entity.Address = model.Address;//街道
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.Addpeople = AuthContextService.CurrentUser.DisplayName;
entity.IsDelete = "0"; //默认未删除
_dbContext.Village.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess("添加成功");
return(Ok(response));
}
}
public IActionResult Create(Goods model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
Goods g = new Goods();
g.Gname = model.Gname;
if (_dbContext.Goods.Count(x => x.Gname == model.Gname && x.ShopId == model.ShopId) > 0)
{
response.SetFailed("商品名已存在");
return(Ok(response));
}
g.Price = model.Price;
g.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
g.AddPeople = AuthContextService.CurrentUser.LoginName;
g.ShopId = model.ShopId;
g.GoodsId = Guid.NewGuid();
g.State = "0";
_dbContext.Goods.Add(g);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(RoleCreateViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.RoleName.Trim().Length <= 0)
{
response.SetFailed("请输入角色名称");
return(Ok(response));
}
using (_dbContext)
{
if (_dbContext.SystemRole.Count(x => x.RoleName == model.RoleName) > 0)
{
response.SetFailed("角色已存在");
return(Ok(response));
}
var entity = new SystemRole();
entity.SystemRoleUuid = Guid.NewGuid();
entity.RoleName = model.RoleName;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.AddPeople = AuthContextService.CurrentUser.DisplayName;
entity.IsDeleted = 0;
_dbContext.SystemRole.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(WorkTimeCreateViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.StartTime.Trim().Length <= 0 || model.EndTime.Trim().Length <= 0)
{
response.SetFailed("请输入上下班时间");
return(Ok(response));
}
using (_dbContext)
{
if (_dbContext.WorkTime.Count() > 0)
{
response.SetFailed("上下班时间已设置");
return(Ok(response));
}
var entity = new WorkTime();
entity.WorkTimeUuid = Guid.NewGuid();
entity.StartTime = model.StartTime;
entity.EndTime = model.EndTime;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.AddPeople = AuthContextService.CurrentUser.DisplayName;
entity.IsDeleted = 0;
_dbContext.WorkTime.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(RubbishViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.GrabageRoom();
entity.GarbageRoomUuid = Guid.NewGuid();
if (_dbContext.GrabageRoom.Where(x => x.IsDelete == "0").Count(x => x.Ljname == model.Ljname) > 0)
{
response.SetFailed("垃圾箱房名字已存在");
return(Ok(response));
}
//VillageId = _dbContext.Village.FirstOrDefault(x => x.Vname == model.Vname);
entity.VillageId = model.villageUuid; //社区id
entity.Ljname = model.Ljname;
entity.SystemUserUuid = model.SystemUserUuid; //督导员id
entity.StartTime = model.StartTime;
entity.EndTime = model.EndTime;
entity.Lon = model.Lon;
entity.Lat = model.Lat;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.AddPeople = AuthContextService.CurrentUser.DisplayName;
entity.CarId = model.CarId;
entity.IsDelete = "0";
entity.State = "0";
entity.WingId = model.WingId;
entity.Facilityuuid = model.Facilityuuid;
_dbContext.GrabageRoom.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess("添加成功");
return(Ok(response));
}
}
public IActionResult AddGrabageMonit(dynamic model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.GrabageMonitoring();
entity.GrabageMonitoringUuid = Guid.NewGuid();
entity.MonitoringNum = model.monitoringNum;
entity.GarbageRoomUuid = model.garbageRoomUuid;
entity.PalyType = model.palyType;
entity.SvrIp = model.svrIp;
entity.SvrPort = model.svrPort;
entity.Appkey = model.appkey;
entity.AppSecret = model.appSecret;
entity.Time = model.time;
entity.TimeSecret = model.timeSecret;
entity.Httpsflag = model.httpsflag;
entity.CamList = model.camList;
entity.Remark = model.remark;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.IsDelete = 0;
var entity2 = _dbContext.GrabageRoom.FirstOrDefault(x => x.GarbageRoomUuid == entity.GarbageRoomUuid);
entity2.MonitoringNum = entity2.MonitoringNum + "," + entity.MonitoringNum;
_dbContext.GrabageMonitoring.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess("添加成功");
return(Ok(response));
}
}
public IActionResult Create(PermissionCreateViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.Name.Trim().Length <= 0)
{
response.SetFailed("请输入权限名称");
return(Ok(response));
}
using (_dbContext)
{
if (_dbContext.SystemPermission.Count(x => x.ActionCode == model.ActionCode && x.SystemMenuUuid == model.SystemMenuUuid) > 0)
{
response.SetFailed("权限操作码已存在");
return(Ok(response));
}
if (_dbContext.SystemPermission.Count(x => x.Name == model.Name && x.SystemMenuUuid == model.SystemMenuUuid) > 0)
{
response.SetFailed("权限名称已存在");
return(Ok(response));
}
var entity = _mapper.Map <PermissionCreateViewModel, SystemPermission>(model);
entity.CreatedOn = DateTime.Now.ToString("yyyy-MM-dd");
entity.SystemPermissionUuid = Guid.NewGuid();
entity.CreatedByUserGuid = AuthContextService.CurrentUser.Guid;
entity.CreatedByUserName = AuthContextService.CurrentUser.DisplayName;
_dbContext.SystemPermission.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult EditAttend(CensorShowViewModel model)
{
using (_dbContext)
{
var response = ResponseModelFactory.CreateInstance;
var entity = _dbContext.Attendance.FirstOrDefault(x => x.AttendanceUuid == model.AttendanceUuid);
if (model.StartState == "未打卡" && model.satend == "0")
{
if (DateTime.Parse(model.AMEndTime) > DateTime.Parse(model.AMStartTime))
{
if (entity.AmstartTime == null && model.AMStartTime.Length == 5)
{
entity.AmstartTime = DateTime.Now.ToString("yyyy-MM-dd") + " " + model.AMStartTime + ":00";
}
entity.AmstartPlace = model.AMStartPlace;
if (entity.AmstartTime == null && model.AMEndTime.Length == 5)
{
entity.AmendTime = DateTime.Now.ToString("yyyy-MM-dd") + " " + model.AMEndTime + ":00";
}
entity.AmendPlace = model.AMEndPlace;
_dbContext.SaveChanges();
response.SetSuccess("补卡成功");
}
else
{
response.SetFailed("下班时间不能低于上班时间");
}
}
else if (model.EndState == "未打卡" && model.satend == "1")
{
if (DateTime.Parse(model.PMEndTime) > DateTime.Parse(model.PMStartTime))
{
if (entity.PmstartTime == null && model.PMStartTime.Length == 5)
{
entity.PmstartTime = DateTime.Now.ToString("yyyy-MM-dd") + " " + model.PMStartTime + ":00";
}
entity.PmstartPlace = model.PMStartPlace;
if (entity.PmendTime == null && model.PMEndTime.Length == 5)
{
entity.PmendTime = DateTime.Now.ToString("yyyy-MM-dd") + " " + model.PMEndTime + ":00";
}
entity.PmendPlace = model.PMEndPlace;
_dbContext.SaveChanges();
response.SetSuccess("补卡成功");
}
else
{
response.SetFailed("下班时间不能低于上班时间");
}
}
else
{
response.SetFailed("补卡失败");
}
return(Ok(response));
}
}
public IActionResult Create(ResponseViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entitys = _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == model.SystemUserUuid);
if (entitys == null)
{
response.SetFailed("没有此人");
return(Ok(response));
}
var entity = new HaikanRefuseClassification.Api.Entities.QuestionPerson();
entity.QuestionPersonUuid = Guid.NewGuid();
entity.HomeUserUuid = model.SystemUserUuid;
entity.ProblemContent = model.ProblemContent;
entity.ProblemType = model.ProblemType;
entity.Remarks = model.Remarks;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
_dbContext.QuestionPerson.Add(entity);
_dbContext.SaveChanges();
// var entity1 = _dbContext.SystemUser.FirstOrDefault(x => x.RealName == model.RealName && x.SystemRoleUuid == "C6BDB5B3-990B-4943-B2A1-1492044E38B8");
// if (entity1 == null)
// {
// response.SetFailed("此人不是用户");
// return Ok(response);
// }
// entity.RealName = model.RealName;
// entity.ProblemContent = model.ProblemContent;
// entity.ProblemType = model.ProblemType;
// entity.Remarks = model.Remarks;
// _dbContext.SaveChanges();
//var entity = new HaikanRefuseClassification.Api.Entities.SystemUser();
//entity.SystemUserUuid = Guid.NewGuid();
//entity.RealName = model.RealName;
//entity.ProblemContent = model.ProblemContent;
//entity.ProblemType = model.ProblemType;
//entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
//entity.IsDeleted = 0;
//entity.SystemRoleUuid = "C6BDB5B3-990B-4943-B2A1-1492044E38B8";
//_dbContext.SystemUser.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess("成功");
return(Ok(response));
}
}
public IActionResult AddQuestion(Question model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
model.QuestionUuid = Guid.NewGuid();
model.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss");
model.IsDelete = "0";
_dbContext.Question.Add(model);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Edit(GWeightSonModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (ConfigurationManager.AppSettings.IsTrialVersion)
{
response.SetIsTrial();
return(Ok(response));
}
using (_dbContext)
{
var entity = _dbContext.GrabageWeightSon.FirstOrDefault(x => x.GrabageWeighingRecordUuid == model.GrabageWeighingRecordUuid);
if (entity == null)
{
response.SetFailed("数据不存在");
return(Ok(response));
}
entity.Type = model.Type;
entity.Weight = model.Weight.ToString();
_dbContext.SaveChanges();
response = ResponseModelFactory.CreateInstance;
return(Ok(response));
}
}
public IActionResult Create(MenuCreateViewModel model)
{
using (_dbContext)
{
var entity = _mapper.Map <MenuCreateViewModel, SystemMenu>(model);
entity.CreatedOn = DateTime.Now.ToString("yyyy-MM-dd");
entity.SystemMenuUuid = Guid.NewGuid();
entity.CreatedByUserGuid = AuthContextService.CurrentUser.Guid;
entity.CreatedByUserName = AuthContextService.CurrentUser.DisplayName;
entity.IsDeleted = 0;
entity.Icon = string.IsNullOrEmpty(entity.Icon) ? "md-menu" : entity.Icon;
_dbContext.SystemMenu.Add(entity);
_dbContext.SaveChanges();
var response = ResponseModelFactory.CreateInstance;
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(HouseholdViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.SystemUser();
entity.SystemUserUuid = Guid.NewGuid();
entity.RealName = model.RealName;
entity.Phone = model.Phone;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.SystemRoleUuid = "C6BDB5B3-990B-4943-B2A1-1492044E38B8";
entity.IsDeleted = 0;
_dbContext.SystemUser.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(dynamic model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.GrabType();
entity.GrabTypeUuid = Guid.NewGuid();
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
entity.AddPeopel = AuthContextService.CurrentUser.DisplayName;
entity.GrabName = model.name;
entity.Type = model.type;
entity.IsDelete = "0";
_dbContext.GrabType.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(dynamic model)
{
var response = ResponseModelFactory.CreateInstance;
string address = model.address;
string addresscode = model.addresscode;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.HomeAddress();
entity.HomeAddressUuid = Guid.NewGuid();
entity.Address = address;
entity.Addresscode = "T" + addresscode;
entity.Resregion = model.resregion;
entity.Town = model.town;
entity.Ccmmunity = model.ccmmunity;
_dbContext.HomeAddress.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult disUpdate(string guid)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var entity = _dbContext.GrabageDisposal.FirstOrDefault(x => x.GarbageDisposalUuid == Guid.Parse(guid));
//当天赋分次数
var disposal = _dbContext.GrabageDisposal.Count(x => x.HomeAddressUuid == entity.HomeAddressUuid && x.AddTime.Substring(0, 10) == entity.AddTime.Substring(0, 10) && x.IsScore == "1");
//获取设置的评分次数
var num = _dbContext.Overallsituation.First();
if (disposal >= num.SetNumber)
{
response.SetFailed("此日该家庭赋分超过" + num.SetNumber + "次");
return(Ok(response));
}
entity.IsScore = "1";
entity.ScoreAddtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
_dbContext.SaveChanges();
return(Ok(response));
}
}
public IActionResult EditShopScore(dynamic model)
{
var response = ResponseModelFactory.CreateInstance;
var exchageTime = DateTime.Now.ToLocalTime().ToString();
var StoreExchangeUuid = Guid.NewGuid();
var score = "-" + model.score;
Guid uuid = model.shopUuid;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.GoodsExchange();
entity.StoreExchangeUuid = StoreExchangeUuid;
entity.ShopId = uuid;
entity.ExchageTime = exchageTime;
entity.DeduceScore = score;
entity.IsDelete = "0";
_dbContext.GoodsExchange.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(VolunteerViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
//是用户就添加志愿者身份
var entity = _dbContext.SystemUser.FirstOrDefault(x => x.Phone == model.Phone && x.LoginName == model.LoginName && x.IsDeleted == 0);
if (entity == null)
{
response.SetFailed("姓名和手机号码不匹配");
return(Ok(response));
}
entity.SystemRoleUuid = entity.SystemRoleUuid.TrimEnd(',') + "," + AuthContextService.CurrentUser.ZYZ;
_dbContext.SaveChanges();
//var entity = new HaikanRefuseClassification.Api.Entities.SystemUser();
//entity.SystemUserUuid = Guid.NewGuid();
//entity.RealName = model.RealName;
//entity.Phone = model.Phone;
//if (!string.IsNullOrEmpty(entity.AddTime))
//{
// entity.AddTime = DateTime.Parse(model.AddTime).ToString("yyyy-MM-dd");
//}
//else
//{
// entity.AddTime = model.AddTime;
//}
//entity.SystemRoleUuid = "964E6977-5867-4680-A258-B358D5FA1A4B";
//entity.UserType = 2;
//entity.IsDeleted = 0;
//_dbContext.SystemUser.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult EditQuestion(dynamic model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
string guid = model.guid;
var query = _dbContext.Question.FirstOrDefault(x => x.QuestionUuid == Guid.Parse(guid));
query.Estimate = model.estimate;
query.Esttime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
query.Estpeople = AuthContextService.CurrentUser.DisplayName;
_dbContext.SaveChanges();
response.SetSuccess("处理成功");
return(Ok(response));
}
}
public IActionResult Edit(SystemSetting model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var query = _dbContext.SystemSetting.FirstOrDefault(x => x.ClobalUuid == model.ClobalUuid);
query.ClobalName = model.ClobalName;
query.ClobalSuo = model.ClobalSuo;
query.GlobalLogo = model.GlobalLogo;
query.AddTime = DateTime.Now;
query.IsDeleted = 0;
_dbContext.SaveChanges();
response.SetData("True");
return(Ok(response));
}
}
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);
}
}
public IActionResult CreateSupervisor(SupervisorInspectionViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = _mapper.Map <SupervisorInspectionViewModel, Entities.SupervisorInspection>(model);
entity.AuditUuid = Guid.NewGuid(); //添加人Uuid
entity.HomeAddressUuid = Guid.Parse(model.HomeAddressUUID.ToString()); //家庭码
entity.AddTime = (DateTime.Now).ToString(); //添加时间
entity.GarbageSoring = model.GarbageSoring; //垃圾分类列
entity.Picture = model.Picture; //图片
entity.Grade = model.Grade;
entity.AddPeople = model.AddPeople; //添加人
//entity.AddPeople = AuthContextService.CurrentUser.LoginName; //添加人
entity.IsDeleted = 0;
_dbContext.SupervisorInspection.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess();
return(Ok(response));
}
}
public IActionResult Create(UserCreateViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.LoginName.Trim().Length <= 0)
{
response.SetFailed("请输入登录名称");
return(Ok(response));
}
using (_dbContext)
{
if (_dbContext.SystemUser.Count(x => x.LoginName == model.LoginName) > 0)
{
response.SetFailed("登录名已存在");
return(Ok(response));
}
if (_dbContext.SystemUser.Count(x => x.UserIdCard == model.UserIdCard) > 0 && model.UserIdCard != "")
{
response.SetFailed("身份证号已存在");
return(Ok(response));
}
if (model.SystemRoleUuid.Count <= 0)
{
response.SetFailed("请选择角色");
return(Ok(response));
}
var entity = _mapper.Map <UserCreateViewModel, SystemUser>(model);
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
entity.SystemUserUuid = Guid.NewGuid();
var rolename = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "超级管理员");
if (model.SystemRoleUuid.Contains(rolename.SystemRoleUuid.ToString()))
{
entity.UserType = 0;
}
else
{
entity.UserType = 2;
}
entity.SystemRoleUuid = "";
entity.PassWord = Haikan3.Utils.DesEncrypt.Encrypt(model.PassWord.Trim(), MdDesEncrypt.SecretKey);
for (int i = 0; i < model.SystemRoleUuid.Count; i++)
{
entity.SystemRoleUuid += model.SystemRoleUuid[i] + ",";
}
entity.SystemRoleUuid = entity.SystemRoleUuid.TrimEnd(',');
entity.OldCard = model.OldCard;
entity.Phone = model.Phone;
entity.Streets = model.Streets;
entity.Community = model.Community;
entity.Biotope = model.Biotope;
_dbContext.SystemUser.Add(entity);
_dbContext.SaveChanges();
_dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUserRoleMapping WHERE SystemUserUUID={0}", entity.SystemUserUuid);
var success = true;
//循环加权限
for (int i = 0; i < model.SystemRoleUuid.Count; i++)
{
if (model.SystemRoleUuid[i] != "")
{
var roles = new SystemUserRoleMapping();
roles.SystemUserUuid = entity.SystemUserUuid;
roles.SystemRoleUuid = Guid.Parse(model.SystemRoleUuid[i]);
roles.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
roles.AddPeople = AuthContextService.CurrentUser.DisplayName;
_dbContext.SystemUserRoleMapping.Add(roles);
}
}
success = _dbContext.SaveChanges() > 0;
if (success)
{
response.SetSuccess();
}
else
{
_dbContext.Database.ExecuteSqlRaw("DELETE FROM SystemUser WHERE SystemUserUUID={0}", entity.SystemUserUuid);
response.SetFailed("保存用户角色数据失败");
}
return(Ok(response));
}
}
public IActionResult Create(SupervisorViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
if (model.garbageRoomUuid.ToString() == "")
{
response.SetFailed("请选择垃圾厢房");
return(Ok(response));
}
using (_dbContext)
{
//先判断是不是数据库里已经存在的用户
if (_dbContext.SystemUser.Count(x => x.Phone == model.Phone) > 0)
{
//已经是数据库里的用户就添加督导员身份
var ent = _dbContext.SystemUser.FirstOrDefault(x => x.Phone == model.Phone && x.IsDeleted == 0);
ent.SystemRoleUuid = ent.SystemRoleUuid.TrimEnd(',') + ",c678d6e6-1c04-47d3-8660-2e4457504ee9";
ent.RealName = model.RealName;
ent.Sex = model.Sex;
ent.GrabageRoomId = model.garbageRoomUuid;
var entitys = _dbContext.GrabageRoom.FirstOrDefault(x => x.GarbageRoomUuid == model.garbageRoomUuid);
ent.VillageId = entitys.VillageId;
if (model.InTime != "")
{
ent.InTime = DateTime.Parse(model.InTime).ToString("yyyy-MM-dd");//入职时间
}
else
{
ent.InTime = DateTime.Now.ToString("yyyy-MM-dd");
}
ent.ZaiGang = model.ZaiGang;
_dbContext.SaveChanges();
}
else
{
if (_dbContext.SystemUser.Where(x => x.IsDeleted == 0).Count(x => x.Phone == model.Phone) > 0)
{
response.SetFailed("该用户已存在");
return(Ok(response));
}
var entity = new HaikanRefuseClassification.Api.Entities.SystemUser();
entity.SystemUserUuid = Guid.NewGuid();
entity.RealName = model.RealName;//督导员姓名
entity.Sex = model.Sex;
entity.Phone = model.Phone;
entity.GrabageRoomId = model.garbageRoomUuid;
if (model.InTime != "")
{
entity.InTime = DateTime.Parse(model.InTime).ToString("yyyy-MM-dd");//入职时间
}
else
{
entity.InTime = DateTime.Now.ToString("yyyy-MM-dd");
}
entity.AddPeople = AuthContextService.CurrentUser.DisplayName;//添加人
entity.SystemRoleUuid = "c678d6e6-1c04-47d3-8660-2e4457504ee9";
entity.UserType = 5;
entity.ZaiGang = model.ZaiGang;//在职默认1在岗
entity.IsDeleted = 0;
var entitys = _dbContext.GrabageRoom.FirstOrDefault(x => x.GarbageRoomUuid == model.garbageRoomUuid);
entity.VillageId = entitys.VillageId;
entity.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
_dbContext.SystemUser.Add(entity);
_dbContext.SaveChanges();
}
response.SetSuccess("添加成功");
return(Ok(response));
}
}
public IActionResult ClockIn(ClockInViewModel model)
{
using (_dbContext)
{
var response = ResponseModelFactory.CreateInstance;
string today = DateTime.Now.ToString("yyyy-MM-dd");
//var worktime = _dbContext.WorkTime.FirstOrDefault();
//if (worktime == null)
//{
// response.SetFailed("未获取到上下班时间，请通知管理员设置。");
// return Ok(response);
//}
var query = _dbContext.Attendance.FirstOrDefault(x => x.SystemUserUuid == model.UserUUID && x.ColckDate == today);
if (query == null)
{
var entity = new Attendance();
entity.AttendanceUuid = Guid.NewGuid();
entity.SystemUserUuid = model.UserUUID;
entity.ColckDate = today;
entity.StartState = 0;
entity.EndState = 0;
entity.Type = model.Type;
entity.Name = model.UserName;
entity.GarbageRoomUuid = model.GarbageRoomUuid;
//上午
if (DateTime.Now.Hour < 12)
{
if (!string.IsNullOrEmpty(model.AmstartTime))
{
entity.AmstartTime = model.AmstartTime;
entity.AmstartPlace = model.AmstartPlace;
entity.StartState = 1;
//if (Convert.ToDateTime(model.AmstartTime) < Convert.ToDateTime(worktime.StartTime))
//{
// entity.StartState = 1;
//}
//else
//{
// entity.StartState = 2;
//}
}
else
{
response.SetFailed("未获取到上班打卡时间，请重新打卡。");
return(Ok(response));
}
}
//下午
else
{
if (!string.IsNullOrEmpty(model.PmstartTime))
{
entity.PmstartTime = model.PmstartTime;
entity.PmstartPlace = model.PmstartPlace;
entity.StartState = 1;
//if (Convert.ToDateTime(model.PmstartTime) < Convert.ToDateTime(worktime.StartTime))
//{
// entity.StartState = 1;
//}
//else
//{
// entity.StartState = 2;
//}
}
else
{
response.SetFailed("未获取到上班打卡时间，请重新打卡。");
return(Ok(response));
}
}
_dbContext.Attendance.Add(entity);
_dbContext.SaveChanges();
}
else
{
//上午
if (DateTime.Now.Hour < 12)
{
if (string.IsNullOrEmpty(query.AmstartTime))
{
if (!string.IsNullOrEmpty(model.AmstartTime))
{
query.StartState = 1;
//if (Convert.ToDateTime(model.AmstartTime) < Convert.ToDateTime(worktime.StartTime))
//{
// query.StartState = 1;
//}
//else
//{
// query.StartState = 2;
//}
query.AmstartTime = model.AmstartTime;
query.AmstartPlace = model.AmstartPlace;
}
else
{
response.SetFailed("未获取到上班打卡时间，请重新打卡。");
return(Ok(response));
}
}
else
{
response.SetFailed("上班已打卡，无需重复打卡。");
return(Ok(response));
}
}
//下午
else
{
if (string.IsNullOrEmpty(query.PmstartTime))
{
if (!string.IsNullOrEmpty(model.PmstartTime))
{
query.StartState = 1;
//if (Convert.ToDateTime(model.PmstartTime) < Convert.ToDateTime(worktime.StartTime))
//{
// query.StartState = 1;
//}
//else
//{
// query.StartState = 2;
//}
query.PmstartTime = model.PmstartTime;
query.PmstartPlace = model.PmstartPlace;
}
else
{
response.SetFailed("未获取到上班打卡时间，请重新打卡。");
return(Ok(response));
}
}
else
{
response.SetFailed("上班已打卡，无需重复打卡。");
return(Ok(response));
}
}
_dbContext.SaveChanges();
}
response.SetSuccess("打卡成功");
response.SetData(query);
return(Ok(response));
}
}
public IActionResult Create(VehicleViewModel model)
{
var response = ResponseModelFactory.CreateInstance;
using (_dbContext)
{
var entity = new HaikanRefuseClassification.Api.Entities.Car();
Guid cguid = Guid.NewGuid();
entity.CarUuid = cguid;
if (_dbContext.Car.Where(x => x.IsDelete == 0).Count(x => x.CarNum == model.CarNum) > 0)
{
response.SetFailed("车牌号已存在");
return(Ok(response));
}
entity.CarNum = model.CarNum;
entity.CarType = model.CarType;
entity.HolderId = model.HolderId;
entity.HolderPhone = model.HolderPhone;
entity.Brand = model.Brand;
entity.Company = model.Company;
entity.Street = model.Street;
if (!string.IsNullOrEmpty(model.OnlyNum))
{
var device = _dbContext.DeviceToCar.FirstOrDefault(x => x.Imei == model.OnlyNum);
if (device != null)
{
var iscar = _dbContext.Car.FirstOrDefault(x => x.IsDelete != 1 && x.CarUuid == device.CarUuid);
if (iscar != null)
{
response.SetFailed("该车载唯一编码已绑定");
return(Ok(response));
}
}
entity.OnlyNum = model.OnlyNum;
var deviceTo = new DeviceToCar();
deviceTo.DeviceToCarUuid = Guid.NewGuid();
deviceTo.CarUuid = cguid;
deviceTo.Imei = model.OnlyNum;
deviceTo.AddPerson = AuthContextService.CurrentUser.DisplayName;
deviceTo.AddTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
if (!string.IsNullOrEmpty(entity.RegisterTime))
{
entity.RegisterTime = DateTime.Parse(model.RegisterTime).ToString("yyyy-MM-dd");
}
else
{
entity.RegisterTime = model.RegisterTime;
}
if (!string.IsNullOrEmpty(entity.AwardTime))
{
entity.AwardTime = DateTime.Parse(model.AwardTime).ToString("yyyy-MM-dd");
}
else
{
entity.AwardTime = model.RegisterTime;
}
entity.GrabType = model.GrabType;
entity.Weight = model.Weight;
entity.BalanceId = model.BalanceId;
entity.CameraId = model.CameraId;
// entity.RubbishTypeUuid = model.RubbishTypeUuid;
entity.IsDelete = 0;
_dbContext.Car.Add(entity);
_dbContext.SaveChanges();
response.SetSuccess("添加成功");
return(Ok(response));
}
}
public IActionResult getSingleScoreRecord(dynamic model)
{
Guid uid = model.uid;
Guid hid = model.hid;
DateTime time1 = model.time1;
DateTime time2 = model.time2 + " 23:59:59";
var date1 = Convert.ToDateTime(time1).ToString("yyyy-MM-dd HH:mm:ss");
var date2 = Convert.ToDateTime(time2).ToString("yyyy-MM-dd HH:mm:ss");
string MarkType = model.markType;
using (_dbContext)
{
//垃圾投放
var query = (from gr in _dbContext.GrabageDisposal
where gr.HomeAddressUuid == hid && gr.IsDelete != "1" && gr.IsScore == "1" &&
gr.AddTime.CompareTo(date1) >= 0 && gr.AddTime.CompareTo(date2) <= 0
select new
{
gr.GarbageDisposalUuid,
gr.AddTime,
ddName = gr.SupervisorUu.RealName,
gr.ScoreSettingUu.Integral,
gr.ScoreSettingUu.ScoreName,
gr.MarkType
}).OrderByDescending(x => x.AddTime).ToList();
var query1 = (from a in _dbContext.Attendance
where a.SystemUserUuid == uid && a.IsDelete != "1" && a.Type == "1" &&
a.ColckDate.CompareTo(date1) >= 0 && a.ColckDate.CompareTo(date2) <= 0
select new
{
a.AmstartTime,
a.AmendTime,
a.PmstartTime,
a.PmendTime,
}).ToList();
var h = _dbContext.Overallsituation.FirstOrDefault();
//重组数据，分上下午
List <dynamic> temp = new List <dynamic>();
foreach (var item in query1)
{
//上/下午有一次打卡记录就加1，一天最多2次
if (!string.IsNullOrEmpty(item.AmstartTime) || !string.IsNullOrEmpty(item.AmendTime))
{
temp.Add(new
{
score = h.HourScore,
time = item.AmstartTime
});
}
if (!string.IsNullOrEmpty(item.PmstartTime) || !string.IsNullOrEmpty(item.PmendTime))
{
temp.Add(new
{
score = h.HourScore,
time = item.PmstartTime
});
}
}
//商品兑换记录
//var query2 = (from gr in _dbContext.GoodsExchange
// where gr.SystemUserUuid == hid && gr.IsDelete != "1" && DateTime.Parse(gr.ExchageTime) <= time2 && DateTime.Parse(gr.ExchageTime) >= time1
// select new
// {
// gr.StoreExchangeUuid,
// gr.ExchageTime,
// shop = gr.Shop.ShopName,
// goods = gr.Goods.Gname,
// gr.DeduceScore
// }).OrderByDescending(x => x.ExchageTime).ToList();
var query2 = _dbContext.DateScore.Where(x => x.HomeAddressUuid == hid && x.AddTime.Contains(time1.ToString("yyyy"))).Select(x => new {
x.Jan, x.Feb, x.Mar, x.Apr, x.May, x.Jun, x.Jul, x.Aug, x.Sep, x.Oct, x.Nov, x.Dec
}).ToList();
List <dynamic> data = new List <dynamic>()
{
query, temp, query2
};
double can = GetAllScore(hid) - GetUsedScore(hid);//可用积分
if (can < 0)
{
can = 0;
}
var query3 = _dbContext.HomeAddress.FirstOrDefault(x => x.HomeAddressUuid == hid);
query3.Score = can;
_dbContext.SaveChanges();
data.Add(can);
int zyzsc = GetAllzyzScore(uid);//服务积分
data.Add(zyzsc);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(data);
return(Ok(response));
}
}
public IActionResult WXAuth(WXUserInfo info)
{
var response = ResponseModelFactory.CreateInstance;
SystemUser user = new SystemUser();
//string result= EWM.AES_decrypt(info.EncryptedData,info.Session_key,info.Iv);
//return Ok(response);
using (_dbContext)
{
var ddyuuid = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "督导员").SystemRoleUuid.ToString();
var entity = _dbContext.SystemUser.FirstOrDefault(x => x.Wechat == info.Openid);
var ent = _dbContext.SystemUser.FirstOrDefault(x => x.Phone == info.Phone);
var ddyent = _dbContext.SystemUser.FirstOrDefault(x => x.Phone == info.Phone && x.SystemRoleUuid == ddyuuid && x.Wechat == null);
//督导员授权登录
if (ddyent != null)
{
ddyent.Wechat = info.Openid;
ddyent.UserType = 5;
ddyent.LoginName = info.NickName;
if (info.Sex == 0)
{
ddyent.Sex = "未知";
}
if (info.Sex == 1)
{
ddyent.Sex = "男";
}
if (info.Sex == 2)
{
ddyent.Sex = "女";
}
ddyent.Phone = info.Phone;
var jtroleuuid = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "家庭用户").SystemRoleUuid.ToString();
ddyent.SystemRoleUuid = ddyuuid + "," + jtroleuuid;
_dbContext.SaveChanges();
response.SetSuccess("授权成功");
return(Ok(response));
}
if (entity == null && ent == null)
{
user.SystemUserUuid = Guid.NewGuid();
user.LoginName = info.NickName;
user.RealName = "";
user.Wechat = info.Openid;
//授权登录的家庭用户
user.UserType = 5;
user.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
if (info.Sex == 0)
{
user.Sex = "未知";
}
if (info.Sex == 1)
{
user.Sex = "男";
}
if (info.Sex == 2)
{
user.Sex = "女";
}
user.Phone = info.Phone;
user.SystemRoleUuid = _dbContext.SystemRole.FirstOrDefault(x => x.RoleName == "家庭用户").SystemRoleUuid.ToString();
user.IsDeleted = 0;
_dbContext.SystemUser.Add(user);
}
else if (ent != null && entity == null)
{
user.LoginName = info.NickName;
user.Wechat = info.Openid;
//授权登录的家庭用户
user.UserType = 5;
user.Phone = info.Phone;
if (info.Sex == 0)
{
user.Sex = "未知";
}
if (info.Sex == 1)
{
user.Sex = "男";
}
if (info.Sex == 2)
{
user.Sex = "女";
}
user.SystemRoleUuid = AuthContextService.CurrentUser.YH + "," + user.SystemRoleUuid;
_dbContext.SystemUser.Add(user);
}
else
{
entity.LoginName = info.NickName;
//if (info.Sex == 0)
//{
// entity.Sex = "未知";
//}
//if (info.Sex == 1)
//{
// entity.Sex = "男";
//}
//if (info.Sex == 2)
//{
// entity.Sex = "女";
//}
entity.IsDeleted = 0;
}
_dbContext.SaveChanges();
response.SetSuccess("授权成功");
return(Ok(response));
}
}
public IActionResult EditHomeScore(dynamic model)
{
var response = ResponseModelFactory.CreateInstance;
if (ConfigurationManager.AppSettings.IsTrialVersion)
{
response.SetIsTrial();
return(Ok(response));
}
using (_dbContext)
{
Guid guid = model.homeAddressUuid;
int lastDecScore = model.lastDecScore;
int janScore = model.janScore;
int febScore = model.febScore;
int marScore = model.marScore;
int aprScore = model.aprScore;
int mayScore = model.mayScore;
int junScore = model.junScore;
int julScore = model.julScore;
int augScore = model.augScore;
int sepScore = model.sepScore;
int octScore = model.octScore;
int novScore = model.novScore;
int decScore = model.decScore;
string jifen = model.jifen;
var query = _dbContext.HomeAddress.FirstOrDefault(x => x.HomeAddressUuid == guid);
var entity = _dbContext.Village.FirstOrDefault(x => x.IsDelete == "0" && query.Address.Contains(x.Vname) || query.Ccmmunity == x.Vname);
if (entity != null)
{
query.LastDec = lastDecScore;
query.Jan = janScore;
query.Feb = febScore;
query.Mar = marScore;
query.Apr = aprScore;
query.May = mayScore;
query.Jun = junScore;
query.Jul = julScore;
query.Aug = augScore;
query.Sep = sepScore;
query.Oct = octScore;
query.Nov = novScore;
query.Dec = decScore;
var datescore = _dbContext.DateScore.FirstOrDefault(x => x.HomeAddressUuid == query.HomeAddressUuid && x.AddTime.Contains(DateTime.Now.ToString("yyyy")));
if (datescore != null)
{
datescore.Jan = janScore;
datescore.Feb = febScore;
datescore.Mar = marScore;
datescore.Apr = aprScore;
datescore.May = mayScore;
datescore.Jun = junScore;
datescore.Jul = julScore;
datescore.Aug = augScore;
datescore.Sep = sepScore;
datescore.Oct = octScore;
datescore.Nov = novScore;
datescore.Dec = decScore;
}
else
{
var entity1 = new DateScore();
entity1.DateScoreUuid = Guid.NewGuid();
entity1.HomeAddressUuid = query.HomeAddressUuid;
entity1.Jan = janScore;
entity1.Feb = febScore;
entity1.Mar = marScore;
entity1.Apr = aprScore;
entity1.May = mayScore;
entity1.Jun = junScore;
entity1.Jul = julScore;
entity1.Aug = augScore;
entity1.Sep = sepScore;
entity1.Oct = octScore;
entity1.Nov = novScore;
entity1.Dec = decScore;
entity1.AddTime = DateTime.Now.ToString("yyyy-MM-dd");
_dbContext.Add(entity1);
}
_dbContext.SaveChanges();
GoodsExchange gd = new GoodsExchange();
gd.StoreExchangeUuid = Guid.NewGuid();
gd.SystemUserUuid = guid;
gd.ExchageTime = DateTime.Now.ToString("yyyy-MM-dd");
gd.DeduceScore = jifen;
gd.IsDelete = "0";
_dbContext.Add(gd);
_dbContext.SaveChanges();
}
else
{
response.SetFailed("该住户未归属社区");
}
return(Ok(response));
}
}