public void Copy(JobDangerousEntity model)
{
var set1 = _context.Set <JobDangerousEntity>();
var set2 = _context.Set <JobMeasureEntity>();
var danger = set1.Find(model.JobDangerousId);
var measures = (from q in set2
where q.JobDangerousId == model.JobDangerousId
select q).ToList();
var newdanger = new JobDangerousEntity()
{
JobDangerousId = Guid.NewGuid().ToString(),
Content = danger.Content,
CreateTime = DateTime.Now,
JobId = model.JobId
};
var newmeasures = measures.Select(x => new JobMeasureEntity {
JobDangerousId = newdanger.JobDangerousId, Content = x.Content, CreateTime = x.CreateTime, JobMeasureId = Guid.NewGuid().ToString()
}).ToList();
set1.Add(newdanger);
set2.AddRange(newmeasures);
_context.SaveChanges();
}
public void Remove(string id)
{
var entity = _context.Set <DistrictPersonEntity>().Find(id);
if (entity != null)
{
_context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
_context.SaveChanges();
}
}
public void Delete(string id)
{
var entity = _context.Set <CheckTemplateEntity>().Find(id);
if (entity != null)
{
_context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
_context.SaveChanges();
}
}
public void DeleteSubject(string id)
{
var set = _context.Set <ActivitySubjectEntity>();
var entity = set.Find(id);
if (entity != null)
{
set.Remove(entity);
_context.SaveChanges();
}
}
public void Edit(CheckCategoryEntity checkCategoryEntity)
{
var entity = _context.Set <CheckCategoryEntity>().Find(checkCategoryEntity.CategoryId);
if (entity == null)
{
_context.Set <CheckCategoryEntity>().Add(checkCategoryEntity);
}
else
{
_context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
entity.CategoryName = checkCategoryEntity.CategoryName;
entity.ParentId = checkCategoryEntity.ParentId;
}
_context.SaveChanges();
}
/// <summary>
/// 统计未签到记录
/// </summary>
/// <param name="cycle"></param>
/// <param name="date"></param>
public void CalculateUnSignin(string cycle, DateTime date)
{
DateTime from;
DateTime to;
if (cycle == "每天")
{
from = date.AddDays(-1);
to = from.AddDays(1).AddSeconds(-1);
}
else if (cycle == "每周")
{
from = date.AddDays(7);
to = from.AddDays(7).AddSeconds(-1);
}
else if (cycle == "每月")
{
from = date.AddMonths(-1);
to = from.AddMonths(1).AddSeconds(-1);
}
else
{
return;
}
var districtPersons = _context.Set <DistrictPersonEntity>().Where(x => x.Cycle == cycle).ToList();
var signins = _context.Set <DistrictSignInEntity>().Where(x => x.SigninDate >= @from && x.SigninDate < to).ToList();
var unsignin = districtPersons.Where(x => !signins.Any(y => y.DutyDepartmentId == x.DutyDepartmentId)).Select(x => new UnSigninEntity
{
UnSigninId = Guid.NewGuid().ToString(),
CategoryId = x.CategoryId,
CategoryName = x.CategoryName,
DutyDepartmentId = x.DutyDepartmentId,
DutyDepartmentName = x.DutyDepartmentName,
UnSigninDate = date.AddDays(-1),
UserId = x.DutyUserId,
UserName = x.DutyUser,
DistrictId = x.DistrictId,
DistrictName = x.DistrictName
}).ToList();
if (unsignin.Count > 0)
{
_context.Set <UnSigninEntity>().AddRange(unsignin);
_context.SaveChanges();
}
}
/// <summary>
/// Drop a plugin table
/// </summary>
/// <param name="context">Context</param>
/// <param name="tableName">Table name</param>
public static void DropPluginTable(this System.Data.Entity.DbContext context, string tableName)
{
if (context == null)
{
throw new ArgumentNullException("context");
}
if (String.IsNullOrEmpty(tableName))
{
throw new ArgumentNullException("tableName");
}
//drop the table
if (context.Database.SqlQuery <int>("SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = {0}", tableName).Any <int>())
{
var dbScript = "DROP TABLE [" + tableName + "]";
context.Database.ExecuteSqlCommand(dbScript);
}
context.SaveChanges();
}
public void EditReport(ReportEntity data)
{
var reportset = _context.Set <ReportEntity>();
var taskset = _context.Set <TaskEntity>();
var entity = reportset.Find(data.ReportId);
if (entity != null)
{
_context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
entity.Undo = data.Undo;
entity.Plan = data.Plan;
entity.ReportContent = data.ReportContent;
var tasks = taskset.Where(x => x.ReportId == data.ReportId).ToList();
var newtasks = data.TaskList.Where(x => !tasks.Any(y => y.ReportTaskId == x.ReportTaskId)).ToList();
taskset.AddRange(newtasks);
foreach (var item in tasks)
{
var task = data.TaskList.Find(x => x.ReportTaskId == item.ReportTaskId);
if (task == null)
{
_context.Entry(item).State = System.Data.Entity.EntityState.Deleted;
}
else
{
_context.Entry(item).State = System.Data.Entity.EntityState.Modified;
item.StartTime = task.StartTime;
item.EndTime = task.EndTime;
item.Photo = task.Photo;
item.TaskContent = task.TaskContent;
item.TaskPerson = task.TaskPerson;
item.TaskPersonId = task.TaskPersonId;
}
}
_context.SaveChanges();
}
}
public void Save(List <PersonDoshboardEntity> settings)
{
var keys = settings.Select(x => x.PersonDoshboardId).ToArray();
var exists = _context.Set <PersonDoshboardEntity>().Where(x => keys.Contains(x.PersonDoshboardId)).ToList();
foreach (var item in settings)
{
var exist = exists.Find(x => x.PersonDoshboardId == item.PersonDoshboardId);
if (exist == null)
{
_context.Set <PersonDoshboardEntity>().Add(item);
}
else
{
_context.Entry(exist).State = System.Data.Entity.EntityState.Modified;
exist.SettingId = item.SettingId;
exist.Enabled = item.Enabled;
exist.Seq = item.Seq;
exist.Url = item.Url;
}
}
_context.SaveChanges();
}
public Club EditClub(ClubViewModel editClubView)
{
int countryId = 0;
if (!String.IsNullOrEmpty(editClubView.Country.Trim()))
{
countryId = AddCountry(editClubView.Country);
}
int stateId = 0;
if (!String.IsNullOrEmpty(editClubView.State.Trim()))
{
stateId = AddState(editClubView.State, countryId);
}
int cityId = 0;
if (!String.IsNullOrEmpty(editClubView.City.Trim()))
{
cityId = AddCity(editClubView.City, stateId);
}
editClubView.Club.CityID = cityId;
System.Data.Entity.DbContext dbContext = new System.Data.Entity.DbContext(entities,true);
dbContext.Entry(editClubView.Club).State = System.Data.EntityState.Modified;
dbContext.SaveChanges();
return editClubView.Club;
}
protected void Save()
{
dbContext.SaveChanges();
}
public void Save()
{
_context.SaveChanges();
}
/// <summary>
/// 处理文字请求
/// </summary>
/// <returns></returns>
public override IResponseMessageBase OnTextRequest(RequestMessageText requestMessage)
{
var defaultMessage = DefaultResponseMessage(requestMessage);
if (string.IsNullOrEmpty(requestMessage.Content))
{
return(defaultMessage);
}
#region 记录日志
try
{
var opid = requestMessage.FromUserName;
var entitymsg = new MpEventRequestMsgLog();
entitymsg.ID = Formula.FormulaHelper.CreateGuid();
entitymsg.MpID = account.ID;
entitymsg.OpenID = opid;
entitymsg.MsgType = requestMessage.MsgType.ToString();
entitymsg.MsgId = requestMessage.MsgId.ToString();
entitymsg.Content = requestMessage.Content;
entitymsg.CreateDate = System.DateTime.Now;
entities.Set <MpEventRequestMsgLog>().Add(entitymsg);
entities.SaveChanges();
}
catch (Exception ex)
{
LogWriter.Info(string.Format("MPID{0}记录文本回复信息出错：原因{1}", account.ID, ex.Message));
}
#endregion
var rs = CacheHelper.Get(string.Format("TextRequest_{0}_{1}", account.AppID, requestMessage.Content));
var rstype = CacheHelper.Get(string.Format("TextRequest_{0}_{1}_Type", account.AppID, requestMessage.Content));
if (rs == null || rstype == null)
{
//关键字回复
var entity = entities.Set <MpKeyWordReply>().Where(c => c.MpID == account.ID && c.IsDelete == 0 && c.KeyWord == requestMessage.Content).FirstOrDefault();
if (entity != null)
{
CacheHelper.Set(string.Format("TextRequest_{0}_{1}_Type", account.AppID, requestMessage.Content), entity.ReplyType, cachesecond);
if (entity.ReplyType == MpMessageType.none.ToString())
{
return(defaultMessage);
}
else if (entity.ReplyType == MpMessageType.image.ToString())
{
var responseMessage = base.CreateResponseMessage <ResponseMessageImage>();
responseMessage.Image.MediaId = entity.ImageMediaID;
CacheHelper.Set(string.Format("TextRequest_{0}_{1}", account.AppID, requestMessage.Content), responseMessage, cachesecond);
return(responseMessage);
}
else if (entity.ReplyType == MpMessageType.text.ToString())
{
var responseMessage = base.CreateResponseMessage <ResponseMessageText>();
responseMessage.Content = entity.Content;
CacheHelper.Set(string.Format("TextRequest_{0}_{1}", account.AppID, requestMessage.Content), responseMessage, cachesecond);
return(responseMessage);
}
else if (entity.ReplyType == MpMessageType.voice.ToString())
{
var responseMessage = base.CreateResponseMessage <ResponseMessageVoice>();
responseMessage.Voice.MediaId = entity.VoiceMediaID;
CacheHelper.Set(string.Format("TextRequest_{0}_{1}", account.AppID, requestMessage.Content), responseMessage, cachesecond);
return(responseMessage);
}
else if (entity.ReplyType == MpMessageType.video.ToString())
{
var responseMessage = base.CreateResponseMessage <ResponseMessageVideo>();
var video = entities.Set <MpMediaVideo>().Where(c => c.MpID == account.ID && c.IsDelete == 0 && c.ID == entity.VideoID).FirstOrDefault();
if (video == null)
{
return(defaultMessage);
}
responseMessage.Video.MediaId = video.MediaID;
responseMessage.Video.Title = video.Title;
responseMessage.Video.Description = video.Description;
CacheHelper.Set(string.Format("TextRequest_{0}_{1}", account.AppID, requestMessage.Content), responseMessage, cachesecond);
return(responseMessage);
}
else if (entity.ReplyType == MpMessageType.mpnews.ToString())
{
var responseMessage = base.CreateResponseMessage <ResponseMessageNews>();
var article = entities.Set <MpSelfArticle>().Where(c => c.MpID == account.ID && c.IsDelete == 0 && c.ID == entity.ArticleID).FirstOrDefault();
if (article == null)
{
return(defaultMessage);
}
responseMessage.Articles.Add(new Article()
{
Title = article.Title,
Description = article.Description,
Url = article.Url,
PicUrl = string.Format("http://{0}/wechatservice/api/Image/Get/{1}", domain, article.PicFileID),
});
CacheHelper.Set(string.Format("TextRequest_{0}_{1}", account.AppID, requestMessage.Content), responseMessage, cachesecond);
return(responseMessage);
}
else if (entity.ReplyType == MpMessageType.mpmultinews.ToString())
{
var responseMessage = base.CreateResponseMessage <ResponseMessageNews>();
var article = entities.Set <MpSelfArticleGroup>().Where(c => c.MpID == account.ID && c.IsDelete == 0 && c.ID == entity.ArticleGroupID).FirstOrDefault();
if (article == null || article.MpSelfArticleGroupItem == null || article.MpSelfArticleGroupItem.Count(c => c.MpSelfArticle != null) < 2)
{
return(defaultMessage);
}
foreach (var item in article.MpSelfArticleGroupItem.Where(c => c.MpSelfArticle != null))
{
responseMessage.Articles.Add(new Article()
{
Title = item.MpSelfArticle.Title,
Description = item.MpSelfArticle.Description,
Url = item.MpSelfArticle.Url,
PicUrl = string.Format("http://{0}/wechatservice/api/Image/Get/{1}", domain, item.MpSelfArticle.PicFileID),
});
}
CacheHelper.Set(string.Format("TextRequest_{0}_{1}", account.AppID, requestMessage.Content), responseMessage, cachesecond);
return(responseMessage);
}
else
{
return(defaultMessage);
}
}
//其他回复
else
{
return(defaultMessage);
}
}
else
{
var rstp = rstype.ToString();
if (rstp == MpMessageType.image.ToString())
{
return(rs as ResponseMessageImage);
}
else if (rstp == MpMessageType.mpmultinews.ToString())
{
return(rs as ResponseMessageNews);
}
else if (rstp == MpMessageType.mpnews.ToString())
{
return(rs as ResponseMessageNews);
}
else if (rstp == MpMessageType.text.ToString())
{
return(rs as ResponseMessageText);
}
else if (rstp == MpMessageType.video.ToString())
{
return(rs as ResponseMessageVideo);
}
else if (rstp == MpMessageType.voice.ToString())
{
return(rs as ResponseMessageVoice);
}
return(rs as IResponseMessageBase);
}
}