public List<ShowRestPace> Get(int pageNum)
{
List<ShowRestPace> showRestPace;
using (var restContext = new DefaultContext())
{
var restPaces = from restPace in restContext.RestPaces
let rest = restContext.MonitorRestaurants.FirstOrDefault(x => x.ID == restPace.RestaurantId)
orderby rest.Name
select new
{
restPace,
rest
};
showRestPace =
restPaces.AsNoTracking().Pageing(pageNum, PageSize, ref _pageCount).ToList().Select(x => new ShowRestPace()
{
ID = x.restPace.ID,
RestaurantName = x.rest.Name,
SqlCommand = x.restPace.SqlCommand,
SendTime = x.restPace.SendTime,
ReceiptText = x.restPace.ReceiptText,
ReceiveTime = x.restPace.ReceiveTime,
}).ToList();
}
return showRestPace;
}
public List<IShowBranch> GetBranches()
{
Dictionary<Guid, List<Branch>> allBranch;
using (var context = new DefaultContext())
{
allBranch = context.Branches.AsNoTracking().Where(x => x.Enble).GroupBy(x => x.PreBranch).ToDictionary(x => x.Key, x => x.OrderBy(y => y.SortID).ToList());
}
if (!allBranch.Any() || !allBranch.ContainsKey(Guid.Empty))
{
return new List<IShowBranch>();
}
var firstBranch = allBranch[Guid.Empty].ToList();
var resultBranch = new List<IShowBranch>();
foreach (var branch in firstBranch)
{
var dataBranch = ShowBranch.CreateShowBranch(branch);
if (allBranch.ContainsKey(branch.ID))
{
dataBranch.Branches = new List<ShowBranch>();
foreach (var branch1 in allBranch[branch.ID])
{
dataBranch.Branches.Add(ShowBranch.CreateShowBranch(branch1));
}
}
else
{
dataBranch.Branches = new List<ShowBranch>();
}
resultBranch.Add(dataBranch);
}
Flag = true;
return resultBranch;
}
public void Execution()
{
var letter = updateLetter.CreateLetter();
letter.CreateTime = ReceiveTime;
letter.ReplyTime = DateTime.Now;
using (var content = new DefaultContext())
{
content.Letters.Add(letter);
content.SaveChanges();
}
updateLetter.Message = $"CreateTime:{letter.CreateTime},ReplyTime:{letter.ReplyTime}";
var resString = HttpWebResponseUtility.CreatePostHttpResponse(string.Format("http://{0}/Message/Letter/Reply", SystemConst.PirateAddress), updateLetter.ToJson(), 30000);
var result = resString.ToDeserialize<Cells>();
if (!result.Flag)
{
Flag = false;
Message = result.Message;
return;
}
Flag = true;
}
public List<ShowWorkRecord> GetAllRecords(DateTime selectTime, Guid departmentId)
{
var showWorkRecords = new List<ShowWorkRecord>();
using (var workContext = new DefaultContext())
{
var beginTime = selectTime.Date;
var endTime = selectTime.Date.AddDays(1);
var workRecords = (
from workRecord in workContext.WorkRecords.Where(x => x.CreateTime > beginTime && x.CreateTime < endTime)
join account1 in workContext.Accounts on workRecord.AccountId equals account1.ID
join workCard in workContext.WorkCards on workRecord.AccountId equals workCard.AccountId
where departmentId == Guid.Empty || workCard.DepartmentId == departmentId
orderby workRecord.CreateTime descending
select new
{
workRecord,
account1
}).AsNoTracking();
showWorkRecords.AddRange(workRecords.ToList().Select(x => ShowWorkRecord.CreateWorkRecord(x.workRecord, x.account1)));
}
return showWorkRecords;
}
public void SendLetter(UpdateLetter updateLetter)
{
var letter = updateLetter.CreateLetter();
letter.ReplyTime = SqlDateTime.MinValue.Value;
using (var content = new DefaultContext())
{
content.Letters.Add(letter);
content.SaveChanges();
}
var dic = new Dictionary<string, string>();
dic.Add("ActionName", "Reply");
dic.Add("letter", letter.ToJson());
var resString = HttpWebResponseUtility.CreatePostHttpResponse("http://second.eagle.com/api/Message", dic.ToJson(), 30000);
if (string.IsNullOrEmpty(resString) || resString == "0")
{
Flag = false;
Message = "消息无响应";
return;
}
var result = resString.ToDeserialize<Cells>();
if (!result.Flag)
{
Flag = false;
Message = result.Message;
return;
}
Flag = true;
}
public List<ShowRestaurant> GetAll(Guid cityId, string restName, int pageNum)
{
Expression<Func<MonitorRestaurant, bool>> restaurantExpression = x => true;
Expression<Func<MonitorRestaurant, bool>> restaurantNameExpression = x => true;
if (Guid.Empty != cityId)
{
restaurantExpression = x => x.City == cityId;
}
Guid restaurant;
if (!string.IsNullOrEmpty(restName))
{
if (Guid.TryParse(restName, out restaurant))
{
restaurantNameExpression = x => x.ID == restaurant;
}
else
{
restaurantNameExpression = x => x.Name.Contains(restName) || x.SubName.Contains(restName);
}
}
var showRests = new List<ShowRestaurant>();
using (var restContext = new DefaultContext())
{
var restLists =
(from monitorRestaurant in restContext.MonitorRestaurants
.Where(restaurantExpression).Where(restaurantNameExpression)
orderby monitorRestaurant.SubName
orderby monitorRestaurant.Name
select monitorRestaurant).AsNoTracking().Pageing(pageNum, PageSize, ref _pageCount).ToList();
showRests.AddRange(restLists.Select(ShowRestaurant.CreateShowRestaurant));
}
return showRests;
}
public List<ShowAccount> GetAccounts(int pageNum, Guid accountId)
{
var accounts = new List<ShowAccount>();
using (var defaultContent = new DefaultContext())
{
var account = defaultContent.Accounts.SingleOrDefault(x => x.ID == accountId);
if (account.Null())
{
return new List<ShowAccount>();
}
var accountList = new List<Account>();
if ((account.AccountType & AccountType.Admin) != 0)
{
accountList = defaultContent.Accounts.OrderByDescending(x => x.CreateTime)
.Pageing(pageNum, PageSize, ref _pageCount).ToList();
}
else
{
accountList = defaultContent.Accounts.Where(x => (x.AccountType & AccountType.Admin) == 0).OrderByDescending(x => x.CreateTime)
.Pageing(pageNum, PageSize, ref _pageCount).ToList();
}
accounts.AddRange(accountList.Select(ShowAccount.CreateShowAccount));
}
return accounts;
}
/// <summary>
/// 分配页面权限
/// </summary>
/// <param name="accountId"></param>
/// <param name="addList"></param>
/// <param name="delList"></param>
public void Distribution(Guid accountId, List<Guid> addList, List<Guid> delList)
{
using (var defaultContent = new DefaultContext())
{
var account = defaultContent.Accounts.FirstOrDefault(x => x.ID == accountId);
if (account.Null())
{
Message = "分配账号不存在";
return;
}
if (delList.Any())
{
var delBranch = defaultContent.Jurisdictions.Where(x => delList.Contains(x.BranchId) && x.AccountID == accountId).ToList();
defaultContent.Jurisdictions.RemoveRange(delBranch);
}
if (addList.Any())
{
foreach (var guid in addList)
{
var jurisdiction = new Jurisdiction();
jurisdiction.ID = Guid.NewGuid();
jurisdiction.AccountID = accountId;
jurisdiction.BranchId = guid;
defaultContent.Jurisdictions.Add(jurisdiction);
}
}
defaultContent.SaveChanges();
Flag = true;
}
}
public List<ShowWeeklyPlan> Get(Guid accountId, int pageNum)
{
var showWeeklyPlans = new List<ShowWeeklyPlan>();
using (var workContext = new DefaultContext())
{
var workCard = (
from card in workContext.WorkCards
join department in workContext.Departments on card.DepartmentId equals department.ID
where card.AccountId == accountId
select new
{
card,
department
}).FirstOrDefault();
if (workCard.Null())
{
return new List<ShowWeeklyPlan>();
}
var preWeeklyPalns = (from target in workContext.WeekTargets
let summ = workContext.WeekSummaries.FirstOrDefault(x => x.ID == target.ID)
where target.DepartmentId == workCard.card.DepartmentId
orderby target.WeekNum descending
select new
{
target,
summ
}).Pageing(pageNum, PageSize, ref _pageCount);
showWeeklyPlans.AddRange(preWeeklyPalns.Select(x => ShowWeeklyPlan.CreateShowWeeklyPlan(x?.summ, x?.target, workCard?.department)));
}
return showWeeklyPlans;
}
public void Add(List<HeartbeatBody> heartbeatBodys, Guid machineId)
{
var oldHeartbeatIDs = heartbeatBodys.Select(x => x.LogTime);
using (var monitorContext = new DefaultContext())
{
var oldHeartbeats = monitorContext.Heartbeats.Where(x => oldHeartbeatIDs.Contains(x.LogTime) && x.MachineId == machineId);
if (oldHeartbeats.Any())
{
monitorContext.Heartbeats.RemoveRange(oldHeartbeats);
}
foreach (var heartbeatBody in heartbeatBodys)
{
var heartbeat = new Heartbeat();
heartbeat.ID = Guid.NewGuid();
heartbeat.CreateTime = DateTime.Now;
heartbeat.LogTime = heartbeatBody.LogTime;
heartbeat.MachineId = machineId;
heartbeat.AvgNum = heartbeatBody.AvgNum;
heartbeat.MaxNum = heartbeatBody.MaxNum;
heartbeat.HourTime = heartbeatBody.HourTime;
heartbeat.AvgMemory = heartbeatBody.AvgMemory;
heartbeat.MaxMemory = heartbeatBody.MaxMemory;
monitorContext.Heartbeats.Add(heartbeat);
}
monitorContext.SaveChanges();
}
Flag = true;
}
public UpdateTrackPlan Get(Guid trackPlanId)
{
using (var defaultContext = new DefaultContext())
{
var trackPlan = defaultContext.TrackPlans.SingleOrDefault(x => x.ID == trackPlanId);
return UpdateTrackPlan.CreateUpdateTrackPlan(trackPlan);
}
}
/// <summary>
/// 获取用户的权限
/// </summary>
/// <param name="accountId"></param>
/// <returns></returns>
public List<Guid> GetJurisdiction(Guid accountId)
{
Flag = true;
using (var defaultContext = new DefaultContext())
{
var jurisdictions = defaultContext.Jurisdictions.Where(x => x.AccountID == accountId).AsNoTracking().ToList();
return jurisdictions.Select(x => x.BranchId).ToList();
}
}
public UpdateTrackTarget Get(Guid trackTargetId)
{
using (var defaultContext = new DefaultContext())
{
var trackTarget = defaultContext.TrackTargets.SingleOrDefault(x => x.ID == trackTargetId);
return UpdateTrackTarget.CreateUpdateTrackTarget(trackTarget);
}
}
private void Add(UpdateTrackPlan updateTrackPlan)
{
using (var defaultContext = new DefaultContext())
{
defaultContext.TrackPlans.Add(updateTrackPlan.Create());
defaultContext.SaveChanges();
}
Flag = true;
}
private void Add(UpdateCard updateCard)
{
var systemCard = updateCard.CreateSystemCard();
using (var defaultContext = new DefaultContext())
{
defaultContext.SystemCards.Add(systemCard);
defaultContext.SaveChanges();
}
Flag = true;
}
private void Add(UpdateTrackTarget updateTrackTarget)
{
using (var defaultContext = new DefaultContext())
{
defaultContext.TrackTargets.Add(updateTrackTarget.Create());
defaultContext.SaveChanges();
}
Flag = true;
}
public List<ShowDepartment> Get()
{
var showDepartments = new List<ShowDepartment>();
using (var accountContext = new DefaultContext())
{
var departments = accountContext.Departments.OrderByDescending(x => x.CreateTime).ToList();
showDepartments.AddRange(departments.Select(ShowDepartment.CreateShowDepartment));
}
Flag = true;
return showDepartments;
}
public void Execution()
{
using (var content = new DefaultContext())
{
var letterList = content.Letters.Where(x => x.CreateTime >= BeginTime && x.CreateTime < EndTime).AsNoTracking().ToList();
foreach (var letter in letterList)
{
showLetters.Add(ShowLetter.CreateShowLetter(letter));
}
}
Flag = true;
}
public List<ISelectTrackPlan> Get()
{
var showTrackPlans = new List<ISelectTrackPlan>();
using (var defaultContext = new DefaultContext())
{
//.Where(x => x.BeginTime < DateTime.Now && x.EndTime > DateTime.Now)
var trackPlans = defaultContext.TrackPlans.OrderByDescending(x => x.CreateTime).AsNoTracking();
showTrackPlans.AddRange(trackPlans.Select(ShowTrackPlan.CreateShowTrackPlan));
}
return showTrackPlans;
}
public List<ShowTrackPlan> Get(int pageNum)
{
var showTrackPlans = new List<ShowTrackPlan>();
using (var defaultContext = new DefaultContext())
{
var trackPlans = defaultContext.TrackPlans.OrderByDescending(x => x.CreateTime).AsNoTracking()
.Pageing(pageNum, PageSize, ref _pageCount);
showTrackPlans.AddRange(trackPlans.Select(ShowTrackPlan.CreateShowTrackPlan));
}
return showTrackPlans;
}
public int Clear()
{
int result = 0;
using (var defaultContext = new DefaultContext())
{
var monitorDbName = defaultContext.Database.Connection.Database;
string sql = $"DELETE [{monitorDbName}].dbo.MonitorRestaurants";
result = defaultContext.Database.ExecuteSqlCommand(sql);
}
Flag = true;
return result;
}
public ShowLetter GetLetter(Guid id)
{
Flag = true;
using (var content = new DefaultContext())
{
var letter = content.Letters.AsNoTracking().FirstOrDefault(x => x.ID == id);
if (letter == null)
{
return new ShowLetter();
}
return ShowLetter.CreateShowLetter(letter);
}
}
private void Edit(UpdateTrackPlan updateTrackPlan)
{
using (var defaultContext = new DefaultContext())
{
var trackPlan = defaultContext.TrackPlans.SingleOrDefault(x => x.ID == updateTrackPlan.ID);
if (trackPlan.Null())
{
return;
}
defaultContext.TrackPlans.Add(updateTrackPlan.Create());
defaultContext.SaveChanges();
}
Flag = true;
}
private void Add(UpdateJournal updateJournal)
{
var journal = new Journal();
journal.ID = Guid.NewGuid();
journal.ProjectName = updateJournal.ProjectName;
journal.Path = updateJournal.Path;
journal.CreateTime = DateTime.Now;
using (var monitorContext = new DefaultContext())
{
monitorContext.Journals.Add(journal);
monitorContext.SaveChanges();
}
Flag = true;
}
public List<ShowJournal> GetJournals(int pageNum)
{
var showJournals = new List<ShowJournal>();
using (var content = new DefaultContext())
{
var journals = content.Journals.AsNoTracking().OrderByDescending(x => x.CreateTime).Pageing(pageNum, PageSize, ref _pageCount).ToList();
foreach (var journal in journals)
{
showJournals.Add(ShowJournal.CreateShowJournal(journal));
}
}
return showJournals;
}
public List<ShowTrackTarget> Get(int pageNum)
{
var showTrackPlans = new List<ShowTrackTarget>();
using (var defaultContext = new DefaultContext())
{
var trackTargets = defaultContext.TrackTargets.OrderByDescending(x => x.PlanId).ThenByDescending(x => x.CreateTime).AsNoTracking()
.Pageing(pageNum, PageSize, ref _pageCount);
var trackPlanIds = trackTargets.Select(x => x.PlanId).Distinct().ToList();
var trackPlan = defaultContext.TrackPlans.Where(x => trackPlanIds.Contains(x.ID));
showTrackPlans.AddRange(trackTargets.Select(x => ShowTrackTarget.CreateShowTrackTarget(x, trackPlan.ToList())));
}
return showTrackPlans;
}
public List<ShowAccount> GetAccountsByDepartment(Guid departmentId)
{
var showAccounts = new List<ShowAccount>();
using (var defaultContent = new DefaultContext())
{
var accountList = from account in defaultContent.Accounts
join workCard in defaultContent.WorkCards on account.ID equals workCard.AccountId
where workCard.DepartmentId == departmentId
select account;
showAccounts.AddRange(accountList.ToList().Select(ShowAccount.CreateShowAccount));
}
return showAccounts;
}
public void Init()
{
var monitorDbName = string.Empty;
int result = 0;
using (var restContext = new DefaultContext())
{
monitorDbName = restContext.Database.Connection.Database;
string sql = string.Format("DELETE [{0}].dbo.MonitorCities", monitorDbName);
result = restContext.Database.ExecuteSqlCommand(sql);
sql = string.Format("INSERT INTO [{1}].dbo.MonitorCities (ID,Name) SELECT a.ID,a.Name from {0}.dbo.Cities a ", AuspiciousCache.MonitorDatabase, monitorDbName);
result = restContext.Database.ExecuteSqlCommand(sql);
}
Flag = true;
}
public ShowDepartment Get(Guid departmentId)
{
using (var accountContext = new DefaultContext())
{
var department = accountContext.Departments.SingleOrDefault(x => x.ID == departmentId);
if (department == null)
{
return null;
}
var showDepartments = ShowDepartment.CreateShowDepartment(department);
Flag = true;
return showDepartments;
}
}
public UpdateCard GetCard(int cardId)
{
var updateCard = new UpdateCard();
using (var defaultContext = new DefaultContext())
{
var systemCard = defaultContext.SystemCards.FirstOrDefault(x => x.ID == cardId);
if (systemCard.Null())
{
Message = "未找到要修改的配置";
return updateCard;
}
updateCard = UpdateCard.CreateUpdateCard(systemCard);
Flag = true;
return updateCard;
}
}
