private static Response Excute(List <GameGroup> gplist)
{
if (gplist.IsNullOrEmpty())
{
return(ResultHelper.Fail("无数据。"));
}
//检查比赛状态，比赛准备才允许小组抽签
var firstGroup = gplist.First();
var game = GameHelper.GetGame(firstGroup.GameId);
if (game.State != GameState.PREPARE.Id)
{
return(ResultHelper.Fail("比赛准备才能进行小组抽签。"));
}
bool isRoundThenKnock = game.KnockoutOption == KnockoutOption.ROUND_KNOCKOUT.Id;
//先循环后淘汰，验证组成员
if (isRoundThenKnock)
{
var firstOrder = GameHelper.GetGameOrder(firstGroup.OrderId);
//根据OrderNo排序
foreach (var group in gplist)
{
//验证小组人数不足出线人数
if (group.MemberList.Count < firstOrder.KnockoutCountAB)
{
return(ResultHelper.Fail(string.Format("{0}人数不足要求出线人数{1}个，无法保存。", group.Name, firstOrder.KnockoutCount)));
}
group.MemberList = group.MemberList.OrderBy(p => p.OrderNo).ToList();
}
}
var memberEntities = new List <EntityBase>();
var loopEntities = new List <EntityBase>();
foreach (var group in gplist)
{
if (group.MemberList.IsNotNullOrEmpty())
{
//先循环后淘汰，创建组成员
if (isRoundThenKnock)
{
CreateOneGroupMembers(memberEntities, group);
}
//创建组循环赛
CreateOneGroupLoops(loopEntities, group);
}
}
//合并数据
var entities = new List <EntityBase>();
//先循环后淘汰，保存组成员
if (isRoundThenKnock && memberEntities.IsNotNullOrEmpty())
{
entities.AddRange(memberEntities);
}
if (loopEntities.IsNotNullOrEmpty())
{
entities.AddRange(loopEntities);
}
var cmdSave = CommandHelper.CreateSave(entities);
//删除原来生成的小组赛轮次表，后面重新生成
var cmdDelete = CommandHelper.CreateProcedure(FetchType.Execute, "sp_DeleteGameGroup");
cmdDelete.Params.Add("@GameId", gplist.First().GameId);
cmdDelete.Params.Add("@GroupIdString", GetGroupIdString(gplist));
cmdSave.PreCommands.Add(cmdDelete);
return(DbContext.GetInstance().Execute(cmdSave));
}
public ActionResult Delete(string SubjectIDs)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"UPDATE GroupUser SET IsDel = 1 WHERE Id IN ({0})", SubjectIDs);
if (db.Database.ExecuteSqlCommand(strSql.ToString()) > 0)
{
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = SubjectIDs,
Msg = "Delete Success!",
Desc = "Delete Success!"
};
}
else
{
objResult = new ResultHelper()
{
Desc = "Delete Faile,please try again.",
Msg = "Delete Faile,please try again.",
Obj = null,
Ret = -1,
Status = false
};
}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}
/// <summary>
/// 团体比赛结束一次对决
/// </summary>
/// <param name="currentUser">忽略</param>
/// <param name="request">Request.GameLoop.Entities</param>
/// <returns>Response.EmptyEntity</returns>
public Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <GameLoop> >(request);
var temp = req.FirstEntity();
//非轮空，非双方弃权，需要胜方签名
if (!temp.IsBye && temp.WaiverOption != WaiverOption.AB && Ext.IsNullOrEmpty(temp.WinSign))
{
return(ResultHelper.Fail("非轮空，非双方弃权，需要胜方签名。"));
}
var loop = GameHelper.GetLoop(temp.Id);
//从数据库取出，重新赋值
loop.IsBye = req.Entities.First().IsBye;
loop.State = GameLoopState.FINISH.Id;
loop.WaiverOption = temp.WaiverOption.GetId();
loop.WinSign = temp.WinSign;
loop.JudgeSign = temp.JudgeSign;
//更新结束时间
loop.EndTime = DateTime.Now;
if (loop.StartTime == null)
{
loop.StartTime = loop.EndTime;
}
loop.SetRowModified();
loop.Team1Id = loop.Team1Id.GetId();
loop.Team2Id = loop.Team2Id.GetId();
IWaiver waiver = new TeamWaiver();
if (loop.WaiverOption.IsNotNullOrEmpty())
{
waiver.SetWaiver(loop);
}
else
{
waiver.SetScore(loop);
var order = GameHelper.GetGameOrder(loop.OrderId.GetId());
//验证爱猕模式需要打完所有对阵
if (order.TeamScoreMode == TeamScoreMode.SINGLE_RACE.Id)
{
if (loop.Team1 + loop.Team2 != order.WinTeam * 2 - 1)
{
return(ResultHelper.Fail(string.Format("需要打满{0}场。", order.WinTeam * 2 - 1)));
}
}
else
{
int max = loop.Team1 > loop.Team2 ? loop.Team1 : loop.Team2;
if (max < order.WinTeam)
{
//团队比赛胜场检查
return(ResultHelper.Fail(string.Format("胜方需要赢{0}场。", order.WinTeam)));
}
}
}
List <EntityBase> entities = new List <EntityBase>();
entities.Add(loop);
SetNextLoop(loop, entities);
var cmdSave = CommandHelper.CreateSave(entities);
//更新个人积分
var cmdUpdateScore = CommandHelper.CreateProcedure(FetchType.Execute, "sp_UpdateGameSportScoreForTeam");
cmdUpdateScore.Params.Add("@GameId", loop.GameId);
cmdUpdateScore.Params.Add("@LoopId", loop.Id.GetId());
cmdSave.AfterCommands = new List <Command> {
cmdUpdateScore
};
return(DbContext.GetInstance().Execute(cmdSave));
}
/// <summary>
/// 处理传感器采集数据
/// </summary>
/// <param name="sensorDatas"></param>
public static XResponseMessage ProcessSensorData(IEnumerable <SensorData> sensorDatas)
{
if (sensorDatas == null)
{
throw new ArgumentNullException("sensorDatas");
}
var enumerable = sensorDatas as SensorData[] ?? sensorDatas.ToArray();
if (enumerable.Any())
{
//首先检查是否有不在Redis缓存中的设备
// enumerable.Where(sd =>
// _redis.GetVals<DeviceDto>("device", DataType.Protobuf).Where(device =>
// device.Serialnum.EqualIgnoreCase(sd.DeviceCode)
// });
//);
//检查是否有不在数据库中的设备
var deviceNotInDb = enumerable.Where(sd => _deviceService.GetDeviceByIdAsny(sd.DeviceCode) == null);
var notInDb = deviceNotInDb as IList <SensorData> ?? deviceNotInDb.ToList();
if (notInDb.Any())
{
return(ResultHelper.CreateMessage(notInDb.Select(sd => sd.DeviceCode).Join(","), ErrorType.DeviceNotExists));
}
enumerable.ForEach(async sd =>
{
var device = _redis.Smember <DeviceDto>("device", DataType.Protobuf).Find(d => d.Serialnum.EqualIgnoreCase(sd.DeviceCode));
DeviceDto dev = device != null ? device : await _deviceService.GetDeviceByIdAsny(sd.DeviceCode);
dev.Remark = sd.BatchNum;
if (dev != null)
{
if (device == null)
{
_redis.Sadd("device", dev, DataType.Protobuf);//加入到缓存中去
}
//更新设备实时数据
ProcessDevice(sd.Value, sd.ShowValue, sd.Time);
// 数据分析、统计、存储
//实时数据处理
//dev.ProcessDeviceDataInfo();
_dataInfoQueue.Enqueue(dev);
//添加数据异常记录
//dev.ProcessDeviceDataExceptionLog();
_deviceDataExceptionLogQueue.Enqueue(dev);
//添加设备运行记录
_deviceRunLogQueue.Enqueue(dev);
//诊断信息
//dev.ProcessDiagnotics();
//_processDiagnoticsQueue.Enqueue(dev);
//分时数据处理
//dev.ProcessStatistics(15);
//dev.ProcessStatistics(60);
_processStatisticsQueue.Enqueue(dev);
//设备统计
_deviceRunningStatisticsQueue.Enqueue(dev);
}
});
}
return(ResultHelper.CreateMessage("无传感器数据需要处理", ErrorType.NoError));
}
public bool SetDefault(string id)
{
//更新所有为不默认0
ExecuteSqlCommand(@"update [dbo].[WC_OfficalAccounts] set IsDefault=0");
//设置当前为默认1
return(ExecuteSqlCommand(@"update [dbo].[WC_OfficalAccounts] set IsDefault=1 where id='" + ResultHelper.Formatstr(id) + "'") > 0);
}
public JsonResult Login(string UserName, string Password, string Code)
{
if (Session["Code"] == null)
{
return(Json(JsonHandler.CreateMessage(0, "请重新刷新验证码"), JsonRequestBehavior.AllowGet));
}
if (Session["Code"].ToString().ToLower() != Code.ToLower())
{
return(Json(JsonHandler.CreateMessage(0, "验证码错误"), JsonRequestBehavior.AllowGet));
}
SysUser user = accountBLL.Login(UserName, ValueConvert.MD5(Password));
if (user == null)
{
LogHandler.WriteServiceLog(UserName, ResultHelper.NowTime + "登录系统,IP:" + ResultHelper.GetUserIP() + "账户或密码错误", "失败", "登录", "系统入口");
return(Json(JsonHandler.CreateMessage(0, "用户名或密码错误"), JsonRequestBehavior.AllowGet));
}
else if (!Convert.ToBoolean(user.State))//被禁用
{
return(Json(JsonHandler.CreateMessage(0, "账户被系统禁用"), JsonRequestBehavior.AllowGet));
}
AccountModel account = new AccountModel();
account.Id = user.Id;
account.TrueName = user.TrueName;
account.Photo = string.IsNullOrEmpty(user.Photo)?"/Images/Photo.jpg":user.Photo;
account.UserName = user.UserName;
Session["Account"] = account;
GetThemes(user.Id);
LoginUserManage.Add(Session.SessionID, account.Id);
//在线用户统计
//OnlineHttpModule.ProcessRequest();
LogHandler.WriteServiceLog(UserName, ResultHelper.NowTime + "登录系统,IP:" + ResultHelper.GetUserIP(), "成功", "登录", "系统入口");
return(Json(JsonHandler.CreateMessage(1, ""), JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage ExportStuExcel([FromBody] ExportStuInfo m)
{
var eInfo = MongoDbHelper.FindOne <E_Info>(m.ExamID, DbName.E_Info);
if (eInfo == null)
{
return(ResultHelper.Failed("未查到当前考试"));
}
var filter = new BsonDocument();
filter.Add("eid", eInfo._id);
if (!string.IsNullOrEmpty(m.School))
{
int id = -1;
if (int.TryParse(m.School, out id))
{
filter.Add("sid", m.School);
}
else
{
filter.Add("snm", m.School);
}
}
if (!string.IsNullOrEmpty(m.StudentID))
{
filter.Add("stid", m.StudentID);
}
if (!string.IsNullOrEmpty(m.StudentName))
{
filter.Add("nm", m.StudentName);
}
var sts = MongoDbHelper.GetPagedList1 <St_Info, string>(DbName.St_Info, 0, 0, filter, w => w.stid);
List <string> data = ExcelBLL.GetStuColumn(eInfo);
DataTable dt = new DataTable();
for (int j = 0; j < data.Count; j++)
{
dt.Columns.Add(data[j]);
}
for (int i = 0; i < sts.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = sts[i].sid;
dr[1] = sts[i].snm;
dr[2] = sts[i].stid;
dr[3] = sts[i].cls;
dr[4] = sts[i].nm;
for (int j = 0; j < eInfo.sbs.Count; j++)
{
var sb = sts[i].subEs.Where(w => w.sbnm == eInfo.sbs[j].sbnm).FirstOrDefault();
if (sb != null)
{
dr[5 + j * 3] = sb.sbrm;
dr[6 + j * 3] = sb.sbst;
dr[7 + j * 3] = sb.sbtch;
}
else
{
dr[5 + j * 3] = null;
dr[6 + j * 3] = null;
dr[7 + j * 3] = null;
}
}
dr[5 + eInfo.sbs.Count * 3] = sts[i].idcd;
dr[6 + eInfo.sbs.Count * 3] = sts[i].tp;
dt.Rows.Add(dr);
}
string file = ExcelBLL.BuildExcel1(data.ToArray(), dt);
string url = RequestContext.Url.Request.RequestUri.Authority + "\\" + file;
return(ResultHelper.OK(url));
}
public ActionResult Delete(string ProjectIds)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
string[] Id = ProjectIds.Split(',');
string strMsg = string.Empty;
for (int i = 0; i < Id.Length; i++)
{
ProjectBll.DeleteAProject(int.Parse(Id[i]), out strMsg);
}
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = ProjectIds,
Msg = strMsg,
Desc = strMsg
};
//StringBuilder strSql = new StringBuilder();
//strSql.AppendFormat(@"UPDATE ProjectInfo SET IsDel = 1 WHERE Id IN ({0})", ProjectIds);
//if (db.Database.ExecuteSqlCommand(strSql.ToString()) > 0)
//{
// objResult = new ResultHelper()
// {
// Status = true,
// Ret = 0,
// Obj = ProjectIds,
// Msg = "Delete Success!",
// Desc = "Delete Success!"
// };
//}
//else
//{
// objResult = new ResultHelper()
// {
// Desc = "Delete Faile,please try again.",
// Msg = "Delete Faile,please try again.",
// Obj = null,
// Ret = -1,
// Status = false
// };
//}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}
public ActionResult List(string Method, string Key)
{
object objResult = null;
try
{
using (LedDb db = new LedDb())
{
List <ModelForProjectUser> list = new List <ModelForProjectUser>();
if (Method == "FirstLoad")
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select
p.*,
p.Name MgrProjectName,
g.Name RefGroupName,
o.Name RefOrgName
from ProjectUser p
left join GroupUser g on g.Id=p.RefGroupId
left join OrgUser o on g.Id=p.RefOrgId
where g.IsDel!=1 or g.IsDel is null");
list = db.Database.SqlQuery <ModelForProjectUser>(strSql.ToString()).ToList();
}
else if (Method == "SearchLoad")
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"select
p.*,
p.Name MgrProjectName,
g.Name RefGroupName,
o.Name RefOrgName
from ProjectUser p
left join GroupUser g on g.Id=p.RefGroupId
left join OrgUser o on g.Id=p.RefOrgId
where (g.IsDel!=1 or g.IsDel is null)
and p.Name like '%{0}%'", Key);
list = db.Database.SqlQuery <ModelForProjectUser>(strSql.ToString()).ToList();
}
int page = string.IsNullOrWhiteSpace(Request["page"]) ? 1 : Int32.Parse(Request["page"]);
int rows = string.IsNullOrWhiteSpace(Request["rows"]) ? 1 : Int32.Parse(Request["rows"]);
string order = string.IsNullOrWhiteSpace(Request["order"]) ? "DESC" : Request["order"].ToUpper();
string sort = string.IsNullOrWhiteSpace(Request["sort"]) ? "Id" : Request["sort"];
IQueryable <ModelForProjectUser> query = CommonTools.DataSorting <ModelForProjectUser>(list.AsQueryable(), sort, order).Skip((page - 1) * rows).Take(rows);
objResult = new { total = list.Count, rows = query };
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
//throw;
}
return(Json(objResult));
}
public ActionResult Add(GlareSysEfDbAndModels.ProjectInfo subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
subject.UpdateDt = DateTime.Now;
subject.CreateDt = DateTime.Now;
subject.IsDel = 0;
subject.UpdateDt = DateTime.Now;
subject.CreateDt = DateTime.Now;
subject.IsDel = 0;
string strMsg = string.Empty;
bool b = ProjectBll.AddAProject(ref subject, out strMsg);
if (b)
{
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = subject,
Msg = strMsg,
Desc = strMsg
};
}
else
{
objResult = new ResultHelper()
{
Desc = strMsg,
Msg = strMsg,
Obj = null,
Ret = -1,
Status = false
};
}
//db.ProjectInfo.Add(subject);
//if (db.SaveChanges() > 0)
//{
// objResult = new ResultHelper()
// {
// Status = true,
// Ret = 0,
// Obj = subject,
// Msg = "Add Success!",
// Desc = "Add Success!"
// };
//}
//else
//{
// objResult = new ResultHelper()
// {
// Desc = "Add Faile,please try again.",
// Msg = "Add Faile,please try again.",
// Obj = null,
// Ret = -1,
// Status = false
// };
//}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}
public ActionResult Modify(GlareSysEfDbAndModels.ProjectInfo subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
ProjectInfo aSubject = db.ProjectInfo.Where(p => p.Id == subject.Id).FirstOrDefault();
aSubject.ProjectName = subject.ProjectName;
aSubject.ManagerName = subject.ManagerName;
aSubject.Address = subject.Address;
aSubject.ManagerTel = subject.ManagerTel;
aSubject.OrgId = subject.OrgId;
aSubject.GroupId = subject.GroupId;
aSubject.UpdateDt = DateTime.Now;
string strMsg = string.Empty;
bool b = ProjectBll.UpdateProejct(ref subject, out strMsg);
if (b)
{
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = subject,
Msg = strMsg,
Desc = strMsg
};
}
else
{
objResult = new ResultHelper()
{
Desc = strMsg,
Msg = strMsg,
Obj = null,
Ret = -1,
Status = false
};
}
//if (db.SaveChanges() > 0)
//{
// objResult = new ResultHelper()
// {
// Status = true,
// Ret = 0,
// Obj = subject,
// Msg = "Edit Success!",
// Desc = "Edit Success!"
// };
//}
//else
//{
// objResult = new ResultHelper()
// {
// Desc = "Edit Faile,please try again.",
// Msg = "Edit Faile,please try again.",
// Obj = null,
// Ret = -1,
// Status = false
// };
//}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}
public IActionResult Run([FromBody] CodeParameter parameter)
{
return(new JsonResult(ResultHelper.GetOkResult(new { result = CodeRun.Start(parameter.Lang, parameter.Language, parameter.Code, parameter.Classname) })));
}
public ActionResult Details(string id)
{
ViewBag.Perm = GetPermission();
SysUserModel entity = m_BLL.GetById(id);
//防止读取错误
string CityName, ProvinceName, VillageName, DepName, PosName;
try
{
CityName = !string.IsNullOrEmpty(entity.City) ? areasBLL.GetById(entity.City).Name : "";
ProvinceName = !string.IsNullOrEmpty(entity.Province) ? areasBLL.GetById(entity.Province).Name : "";
VillageName = !string.IsNullOrEmpty(entity.Village) ? areasBLL.GetById(entity.Village).Name : "";
DepName = !string.IsNullOrEmpty(entity.DepId) ? structBLL.GetById(entity.DepId).Name : "";
PosName = !string.IsNullOrEmpty(entity.PosId) ? structBLL.GetById(entity.PosId).Name : "";
}
catch
{
CityName = "";
ProvinceName = "";
VillageName = "";
DepName = "";
PosName = "";
}
SysUserEditModel info = new SysUserEditModel()
{
Id = entity.Id,
UserName = entity.UserName,
TrueName = entity.TrueName,
Card = entity.Card,
MobileNumber = entity.MobileNumber,
PhoneNumber = entity.PhoneNumber,
QQ = entity.QQ,
EmailAddress = entity.EmailAddress,
OtherContact = entity.OtherContact,
Province = entity.Province,
City = entity.City,
Village = entity.Village,
Address = entity.Address,
State = entity.State,
CreateTime = entity.CreateTime,
CreatePerson = entity.CreatePerson,
Sex = entity.Sex,
Birthday = ResultHelper.DateTimeConvertString(entity.Birthday),
JoinDate = ResultHelper.DateTimeConvertString(entity.JoinDate),
Marital = entity.Marital,
Political = entity.Political,
Nationality = entity.Nationality,
Native = entity.Native,
School = entity.School,
Professional = entity.Professional,
Degree = entity.Degree,
DepId = entity.DepId,
PosId = entity.PosId,
Expertise = entity.Expertise,
JobState = entity.JobState,
Photo = entity.Photo,
Attach = entity.Attach,
RoleName = m_BLL.GetRefSysRole(id),
CityName = CityName,
ProvinceName = ProvinceName,
VillageName = VillageName,
DepName = DepName,
PosName = PosName
};
return(View(info));
}
private async Task <Subscription> ExecuteAsync(
string id,
OperationMessagePayload payload,
MessageHandlingContext context)
{
var writer = context.Writer;
_logger.LogDebug("Executing operation: {operationName} query: {query}",
payload.OperationName,
payload.Query);
var result = await _executer.ExecuteAsync(
payload.OperationName,
payload.Query,
payload.Variables?.ToInputs(),
context,
null // TODO: find later a better way to specify services
).ConfigureAwait(false);
if (result.Errors != null && result.Errors.Any())
{
_logger.LogError("Execution errors: {errors}", ResultHelper.GetErrorString(result));
await writer.SendAsync(new OperationMessage
{
Type = MessageType.GQL_ERROR,
Id = id,
Payload = result
}).ConfigureAwait(false);
return(null);
}
// is sub
if (result is SubscriptionExecutionResult subscriptionExecutionResult)
{
using (_logger.BeginScope("Subscribing to: {subscriptionId}", id))
{
if (subscriptionExecutionResult.Streams?.Values.SingleOrDefault() == null)
{
_logger.LogError("Cannot subscribe as no result stream available");
await writer.SendAsync(new OperationMessage
{
Type = MessageType.GQL_ERROR,
Id = id,
Payload = result
}).ConfigureAwait(false);
return(null);
}
_logger.LogDebug("Creating subscription");
return(new Subscription(
id,
payload,
subscriptionExecutionResult,
writer,
sub => _subscriptions.TryRemove(id, out _),
_loggerFactory.CreateLogger <Subscription>()));
}
}
//is query or mutation
await writer.SendAsync(new OperationMessage
{
Type = MessageType.GQL_DATA,
Id = id,
Payload = result
}).ConfigureAwait(false);
await writer.SendAsync(new OperationMessage
{
Type = MessageType.GQL_COMPLETE,
Id = id
}).ConfigureAwait(false);
return(null);
}
public ActionResult ExportStudentResult(Guid?key)
{
if (key == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Lecture lecture = _lectureService.GetLecture((Guid)key);
if (lecture == null)
{
return(HttpNotFound());
}
ResultHelper resultHelper = new ResultHelper();
IEnumerable <ExportResult_View> results = resultHelper.ExportGetByLecture(lecture);
var 學生列表 = results.Select(d => new
{
d.Employee_ID,
d.Compeny,
d.Student_Name,
Gender = (GenderEnum)d.Gender,
d.Birthday,
d.Email,
d.Phone_Number,
d.Goal_Name,
d.D,
d.I,
d.S,
d.C,
d.Ability,
d.Horizontal_Score,
d.Vertical_Score,
d.T1_Name,
d.T2_Name,
d.T3_Name
});
XLWorkbook 活頁簿 = new XLWorkbook();
IXLWorksheet 工作表1 = 活頁簿.Worksheets.Add("自訂工作表名稱");
工作表1.Cell(1, 1).Value = "學號";
工作表1.Cell(1, 2).Value = "系所";
工作表1.Cell(1, 3).Value = "姓名";
工作表1.Cell(1, 4).Value = "性別";
工作表1.Cell(1, 5).Value = "生日";
工作表1.Cell(1, 6).Value = "電子信箱";
工作表1.Cell(1, 7).Value = "手機";
工作表1.Cell(1, 8).Value = "圓夢新思維工作首要條件";
工作表1.Cell(1, 9).Value = "D";
工作表1.Cell(1, 10).Value = "I";
工作表1.Cell(1, 11).Value = "S";
工作表1.Cell(1, 12).Value = "C";
工作表1.Cell(1, 13).Value = "業務能力";
工作表1.Cell(1, 14).Value = "橫座標";
工作表1.Cell(1, 15).Value = "縱座標";
工作表1.Cell(1, 16).Value = "最重要";
工作表1.Cell(1, 17).Value = "次重要";
工作表1.Cell(1, 18).Value = "重要";
工作表1.Cell(2, 1).InsertData(學生列表);
string FileName = "StudentResult.xlsx";
string FileUrl = Server.MapPath("~/XML/" + FileName);
活頁簿.SaveAs(FileUrl);
return(File(FileUrl, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", $"{lecture.Name}學生資料.xlsx"));
}
public HttpResponseMessage StaStudentNum([FromBody] SelPaper m)
{
var filter = new BsonDocument();
ObjectId objectId = new ObjectId();
if (ObjectId.TryParse(m.ExamID, out objectId))
{
filter.Add("eid", objectId);
if (!string.IsNullOrEmpty(m.School))
{
int id = -1;
if (int.TryParse(m.School, out id))
{
filter.Add("sid", m.School);
}
else
{
filter.Add("snm", m.School);
}
}
var data = MongoDbHelper.GetPagedList1 <Pp_Nm, string>(DbName.Pp_Nm, m.Skip, m.Limit, filter, w => w.sid);
int Count = MongoDbHelper.GetCount <Pp_Nm>(DbName.Pp_Nm, filter);
List <PaperNum> lm = new List <PaperNum>();
if (Count == 0)
{
var ppp = new List <PaperNum>();
PaperNum pn = new PaperNum();
ppp.Add(pn);
var exam1 = MongoDbHelper.FindOne <E_Info>(m.ExamID, DbName.E_Info);
for (int i = 0; i < exam1.sbs.Count; i++)
{
SubNum sub = new SubNum();
sub.SubName = exam1.sbs[i].sbnm;
sub.SubID = exam1.sbs[i]._id.ToString();
pn.Subs.Add(sub);
}
return(ResultHelper.OK(new { Data = ppp, Count = Count }));
}
var exam = MongoDbHelper.FindOne <E_Info>(m.ExamID, DbName.E_Info);
for (int i = 0; i < data.Count; i++)
{
PaperNum t = new PaperNum();
t.ID = data[i]._id.ToString();
t.SchoolID = data[i].sid;
t.SchoolName = data[i].snm;
t.IsSure = data[i].iss;
for (int j = 0; j < exam.sbs.Count; j++)
{
SubNum sub = new SubNum();
sub.SubID = exam.sbs[j]._id.ToString();
sub.SubName = exam.sbs[j].sbnm;
sub.SubCount = data[i].sbnms.Where(w => w.sbid == exam.sbs[j]._id).FirstOrDefault() == null ? 0 : data[i].sbnms.Where(w => w.sbid == exam.sbs[j]._id).FirstOrDefault().sct;
sub.AcCount = data[i].sbnms.Where(w => w.sbid == exam.sbs[j]._id).FirstOrDefault() == null ? 0 : data[i].sbnms.Where(w => w.sbid == exam.sbs[j]._id).FirstOrDefault().ac;
t.Subs.Add(sub);
}
lm.Add(t);
}
return(ResultHelper.OK(new { Data = lm, Count = Count }));
}
return(ResultHelper.Failed("未找到该次考试"));
}
/// <summary>
/// 订阅（关注）事件
/// </summary>
/// <returns></returns>
public override IResponseMessageBase OnEvent_SubscribeRequest(RequestMessageEvent_Subscribe requestMessage)
{
ValidationErrors errors = new ValidationErrors();
using (DBContainer db = new DBContainer())
{
IWC_OfficalAccountsBLL account_BLL = new WC_OfficalAccountsBLL()
{
m_Rep = new WC_OfficalAccountsRepository(db)
};
//获得当前公众号
WC_OfficalAccountsModel account = account_BLL.GetById(Id);
//将用户提取到本地数据库
WC_UserModel userModel = new WC_UserModel();
IWC_UserBLL user_BLL = new WC_UserBLL()
{
m_Rep = new WC_UserRepository(db)
};
UserInfoJson userJson = UserApi.Info(account.AccessToken, requestMessage.FromUserName);
userModel.Id = ResultHelper.NewId;
userModel.OpenId = userJson.openid;
userModel.NickName = userJson.nickname;
userModel.Sex = userJson.sex;
userModel.Language = userJson.language;
userModel.City = userJson.city;
userModel.Province = userJson.province;
userModel.Country = userJson.country;
userModel.HeadImgUrl = userJson.headimgurl;
userModel.SubscribeTime = ResultHelper.GetTimeByLong(userJson.subscribe_time);
userModel.UnionId = userJson.unionid;
userModel.Remark = userJson.remark;
userModel.GroupId = userJson.groupid.ToString();
userModel.TagidList = string.Join(",", userJson.tagid_list.ToArray());
userModel.Subscribe = userJson.subscribe;
userModel.OfficalAccountId = account.Id;
user_BLL.Create(ref errors, userModel);
IWC_MessageResponseRepository m_Rep = new WC_MessageResponseRepository(db);
//订阅回复
List <WC_MessageResponse> messageList = m_Rep.GetSubscribeResponseContent(account.Id);
if (messageList.Count() > 0)
{
if (messageList[0].Category == (int)WeChatReplyCategory.Text)
{
var responseMessage = base.CreateResponseMessage <ResponseMessageText>();
responseMessage.CreateTime = ResultHelper.NowTime;
responseMessage.ToUserName = requestMessage.FromUserName;
responseMessage.FromUserName = account.OfficalId;
responseMessage.Content = messageList[0].TextContent;
return(responseMessage);
}
//图文方式
else if (messageList[0].Category == (int)WeChatReplyCategory.Image)
{
var responseMessage = CreateResponseMessage <ResponseMessageNews>();
foreach (var model in messageList)
{
responseMessage.Articles.Add(new Article()
{
Title = model.TextContent,
Description = model.ImgTextContext,
PicUrl = WebChatPara.SiteUrl + model.ImgTextUrl,
Url = model.ImgTextLink
});
}
return(responseMessage);
} //一般很少用到
else if (messageList[0].Category == (int)WeChatReplyCategory.Voice)
{
var responseMessage = base.CreateResponseMessage <ResponseMessageMusic>();
responseMessage.Music.MusicUrl = WebChatPara.SiteUrl + messageList[0].MeidaUrl;
responseMessage.Music.Title = messageList[0].TextContent;
responseMessage.Music.Description = messageList[0].Remark;
return(responseMessage);
}
}
var errorResponseMessage = requestMessage.CreateResponseMessage <ResponseMessageText>();
return(errorResponseMessage);
}
}
public Response Execute(string request)
{
var req = JsonConvert.DeserializeObject <Request <LimitModelFilter> >(request);
var obj = req.Filter;
List <LimitBaseData> list = LimitName.LimitList;
Response res = ResultHelper.Success();
//foreach (var item in list)
//{
// if (item.Type == obj.Type)
// {
// res.Entities.Add(item);
// }
//}
//var ownLimit = GetOwnLimit(obj.RoleId, obj.Type);
//if (ownLimit != null && ownLimit.Count > 0)
//{
// List<LimitBaseData> OwnLimitList = new List<LimitBaseData>();
// foreach (var item in ownLimit)
// {
// LimitBaseData data = new LimitBaseData { Range = (item as Limit).LimitDetail, NameId = (item as Limit).LimitName };
// OwnLimitList.Add(data);
// }
// res.Tag = OwnLimitList;
//}
//获取所有列表
foreach (var item in list)
{
if (item.Type == obj.Type)
{
res.Entities.Add(item);
}
}
var ownLimitList = GetOwnLimit(obj.RoleId, obj.Type);//获取拥有的权限列表
foreach (var item in res.Entities)
{
if ((item as LimitBaseData).Type != 1)//针对权限值只有0或1的情况
{
(item as LimitBaseData).IsSelected = false;
(item as LimitBaseData).Range = 0;
}
(item as LimitBaseData).DetailLimit = LimitHelper.GetLimitDetailList(item as LimitBaseData);
foreach (var item1 in ownLimitList)
{
if ((item as LimitBaseData).NameId == (item1 as Limit).LimitName)
{
if ((item as LimitBaseData).Type != 1)//针对权限值只有0或1的情况
{
(item as LimitBaseData).Range = (item1 as Limit).LimitDetail;
if ((item1 as Limit).LimitDetail == 1)
{
(item as LimitBaseData).IsSelected = true;
}
else
{
(item as LimitBaseData).IsSelected = false;
}
}
HashSet <int> rangeSet = new HashSet <int>();
LimitHelper.GetLimitRangeList((item1 as Limit).LimitDetail, rangeSet);
foreach (int k in rangeSet)
{
(item as LimitBaseData).DetailLimit.AsParallel().ForAll((j) =>
{
if (j.Range == k)
{
j.IsSelected = true;
}
});
}
}
}
}
return(res);
}
/// <summary>
/// 工序调整（返工）
/// </summary>
/// <param name="context"></param>
void ProcessAdjustion(HttpContext context)
{
string _service = "ProcessHandler/OperationAdjustion";
Result rs = new Result();
ResultHelper rh = new ResultHelper();
DbHelper db = new DbHelper();
Log log = new Log();
string strUserName = HttpContext.Current.Request["user_name"];
string strSubOrders = HttpContext.Current.Request["sub_orders"];
string strReworkNote = HttpContext.Current.Request["rwk_note"];
string strReceiver = HttpContext.Current.Request["receiver"];
string strReworkUser = HttpContext.Current.Request["rwk_user"];
string strIssProcess = HttpContext.Current.Request["issue_process"];
string strToProcess = HttpContext.Current.Request["to_process"];
string strReasonCate = HttpContext.Current.Request["reason_cate"];
var json = HttpContext.Current.Request["json"];
var jsetting = new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
};
Rework rework = (Rework)JsonConvert.DeserializeObject <Rework>(json, jsetting);//反序列化
string sql_insert_rework = @"insert into hrework
(wo_number,
from_process,
to_process,
issue_process,
receiver,
rwk_user,
reason_cate,
reason_sub_cate,
branch_type,
rwk_note,
creation_date,
created_by)
values(
'#wo_number',
(select cur_process from horder where sub_order='#wo_number'),
'{0}',
'{1}',
'{2}',
'{3}',
'{4}',
'{5}',
'{6}',
'{7}',
getdate(),
'{8}');" ;
sql_insert_rework = string.Format(sql_insert_rework,
rework.to_process,
rework.issue_process,
rework.receiver,
rework.rwk_user,
rework.reason_cate,
rework.reason_sub_cate,
rework.branch_type,
rework.rwk_note,
strUserName);
sql_insert_rework = sql_insert_rework.Replace("#wo_number", "{0}");
//string sql_update_order = @"updade horder
// set next_process=(select cur_process from horder where sub_order='{0}')
// where sub_order='{0}';";
string sql_update_order = @"update horder set cur_process='',next_process=(select process_name from hprocess where process_id={0}),
status='WAIT' where sub_order='{1}';";
string sql_insert_prdroute = @"insert into hprdroute
(wo_number,
process_id,
process_name,
sequence,
creation_date,
created_by)
select '{0}',
process_id,
process_name,
(select sequence + 0.1
from dbo.hprdroute
where wo_number = '{0}'
and process_name = (select case cur_process when null then next_process when '' then next_process else cur_process end
from horder
where sub_order = '{0}')),
Getdate(),
'ProcessHandler/ProcessAdjustion'
from hprocess
where process_id = '{1}';";
//而然要求按需作业（条码采集、检验等），暂时注释代码
//string sql_insert_task = @"insert into htasks
// (wo_number
// ,parts_no
// ,process_name
// ,process_step
// ,task_type
// ,task
// ,perform_type
// ,creation_date
// ,created_by)
// select
// {0},
// '-1',
// '{1}',
// '',
// 'NOTE',
// '{2}',
// 'MANUAL',
// getdate(),
// 'ProcessHandler/OperationAdjustion'
// from htasks where wo_number='{0}' and process_name in (
// select process_name from hprdroute where wo_number='{0}' and sequence>=(
// select sequence from hprdroute where wo_number='{0}' and process_name='{1}')
// );";
StringReader sr = new StringReader(strSubOrders);
string strSubOrder = string.Empty;
string sql_insert_rework_t = string.Empty;
string sql_update_order_t = string.Empty;
string sql_insert_task_t = string.Empty;
string sql_insert_prdroute_t = string.Empty;
while ((strSubOrder = sr.ReadLine()) != null)
{
//查看目标工序是否在订单的工艺路线中
DataTable dt = db.ExecuteDataTable("select 1 from hprdroute where wo_number='" + strSubOrder + "' and process_id=" + rework.to_process + ";");
if (dt.Rows.Count == 0)
{
sql_insert_prdroute_t += string.Format(sql_insert_prdroute, strSubOrder, rework.to_process);
db.ExecuteNonQuery(sql_insert_prdroute_t);
}
sql_insert_rework_t += string.Format(sql_insert_rework, strSubOrder) + "\r\n";
sql_update_order_t += string.Format(sql_update_order, rework.to_process, strSubOrder) + "\r\n";
//sql_insert_task_t += string.Format(sql_insert_task, strSubOrder, rework.to_process, strReworkNote);
}
//if (db.ExecuteNonQuery(sql_insert_prdroute_t) == -1) {
// rs.status = 0;
// rs.msg = rh.GenMsg(_service, rs.msg, sql_insert_rework_t);
// rs.item = rh.GenItem(strSubOrder);
// //rh.Response(context, rs);
//} else
if (db.ExecuteNonQuery(sql_update_order_t) == -1)
{
rs.status = 0;
rs.msg = rh.GenMsg(_service, rs.msg, sql_update_order_t);
rs.item = rh.GenItem(strSubOrder);
//rh.Response(context, rs);
}
else if (db.ExecuteNonQuery(sql_insert_rework_t) == -1)
{
rs.status = 0;
rs.msg = rh.GenMsg(_service, rs.msg, sql_insert_task_t);
rs.item = rh.GenItem(strSubOrder);
//rh.Response(context, rs);
}
else
{
rs.status = 1;
rs.msg = "";
rh.Response(context, rs);
}
string strJson = JsonConvert.SerializeObject(rs);
strJson = JsonConvert.SerializeObject(rs);
context.Response.Clear();
context.Response.ContentEncoding = Encoding.UTF8;
context.Response.ContentType = "application/json";
context.Response.Write(strJson);
context.Response.Flush();
context.Response.End();
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
//base.OnActionExecuting(filterContext);
//读取请求上下文中的Controller,Action,Id
var routes = new RouteCollection();
RouteConfig.RegisterRoutes(routes);
RouteData routeData = routes.GetRouteData(filterContext.HttpContext);
//取出区域的控制器Action,id
string ctlName = filterContext.Controller.ToString();
string[] routeInfo = ctlName.Split('.');
string controller = null;
string action = null;
string id = null;
int iAreas = Array.IndexOf(routeInfo, "Areas");
if (iAreas > 0)
{
Area = routeInfo[iAreas + 1];//取区域及控制器
}
int ctlIndex = Array.IndexOf(routeInfo, "Controllers");
ctlIndex++;
controller = routeInfo[ctlIndex].Replace("Controller", "").ToLower();
string url = HttpContext.Current.Request.Url.ToString().ToLower();
string[] urlArray = url.Split('/');
int urlCtlIndex = Array.IndexOf(urlArray, controller);
urlCtlIndex++;
if (urlArray.Count() > urlCtlIndex)
{
action = urlArray[urlCtlIndex];
}
urlCtlIndex++;
if (urlArray.Count() > urlCtlIndex)
{
id = urlArray[urlCtlIndex];
}
//url
action = string.IsNullOrEmpty(action) ? "index" : action;
int actionIndex = action.IndexOf("?", 0);
if (actionIndex > 1)
{
action = action.Substring(0, actionIndex);
}
id = string.IsNullOrEmpty(id) ? "" : id;
#region wechat project add
var actionParameters = filterContext.ActionDescriptor.GetParameters();
foreach (var p in actionParameters)
{
if (p.ParameterType == typeof(string))
{
if (filterContext.ActionParameters[p.ParameterName] != null)
{
filterContext.ActionParameters[p.ParameterName] = ResultHelper.FormatStr(filterContext.ActionParameters[p.ParameterName].ToString());
}
}
}
#endregion
//URL路径
string filePath = HttpContext.Current.Request.FilePath;
AccountModel account = filterContext.HttpContext.Session["Account"] as AccountModel;
if (ValidDataPermission(account, controller, action, filePath))
{
return;
}
else
{
filterContext.Result = new EmptyResult();
return;
}
}
public HttpResponseMessage SelStudent([FromBody] SelStuInfo m)
{
var filter = new BsonDocument();
ObjectId objectid = new ObjectId();
if (ObjectId.TryParse(m.ExamID, out objectid))
{
filter.Add("eid", objectid);
int AllCount = MongoDbHelper.GetCount <St_Info>(DbName.St_Info, filter);
if (!string.IsNullOrEmpty(m.School))
{
int id = -1;
if (int.TryParse(m.School, out id))
{
filter.Add("sid", m.School);
}
else
{
filter.Add("snm", m.School);
}
}
if (!string.IsNullOrEmpty(m.StudentID))
{
filter.Add("stid", m.StudentID);
}
if (!string.IsNullOrEmpty(m.StudentName))
{
filter.Add("nm", m.StudentName);
}
var data = MongoDbHelper.GetPagedList1 <St_Info, string>(DbName.St_Info, m.Skip, m.Limit, filter, w => w.stid);
int Count = MongoDbHelper.GetCount <St_Info>(DbName.St_Info, filter);
if (Count == 0)
{
return(ResultHelper.OK(new List <string>()));
}
var exam = MongoDbHelper.FindOne <E_Info>(m.ExamID, DbName.E_Info);
List <SubInfo> lsub = new List <SubInfo>();
if (m.Area != 0)//前台查询
{
var ppnm = MongoDbHelper.QueryOne <Pp_Nm>(DbName.Pp_Nm, w => w.sid == m.School && w.eid == exam._id);
AllCount = ppnm.ct;
for (int i = 0; i < exam.sbs.Count; i++)
{
SubInfo sb = new SubInfo();
sb.SubName = exam.sbs[i].sbnm;
sb.StuCount = ppnm.sbnms.Where(w => w.sbid == exam.sbs[i]._id).FirstOrDefault() == null ? 0 : ppnm.sbnms.Where(w => w.sbid == exam.sbs[i]._id).FirstOrDefault().sct;
lsub.Add(sb);
}
}
else
{
for (int i = 0; i < exam.sbs.Count; i++)
{
SubInfo sb = new SubInfo();
sb.SubName = exam.sbs[i].sbnm;
sb.StuCount = exam.sbs[i].stct;
lsub.Add(sb);
}
}
List <StudentInfo> lst = new List <StudentInfo>();
for (int i = 0; i < data.Count; i++)
{
StudentInfo s = new StudentInfo();
s.ID = data[i]._id.ToString();
s.ExamID = data[i].eid.ToString();
s.Class = data[i].cls;
s.IdCard = data[i].idcd;
s.Name = data[i].nm;
s.SchoolID = data[i].sid;
s.SchoolName = data[i].snm;
s.StudentID = data[i].stid;
s.Type = data[i].tp;
for (int j = 0; j < data[i].subEs.Count; j++)
{
SubInfo sub = new SubInfo();
sub.SubID = data[i].subEs[j].sbid.ToString();
sub.SubName = data[i].subEs[j].sbnm;
sub.SubRoom = data[i].subEs[j].sbrm;
sub.SubSite = data[i].subEs[j].sbst;
sub.SubTeacher = data[i].subEs[j].sbtch;
s.Subs.Add(sub);
}
lst.Add(s);
}
return(ResultHelper.OK(new { Data = lst, Count = Count, SubCount = lsub, AllCount = AllCount }));
}
return(ResultHelper.Failed("未找到该次考试信息"));
}
public async Task <IActionResult> SearchForRestaurantAsync(string search)
{
var queryResult = await queryDispatcher.PostAsync <OrderSearchForRestaurantsQuery, ICollection <RestaurantViewModel> >(new OrderSearchForRestaurantsQuery(search), null);
return(ResultHelper.HandleResult(queryResult, failureMessageService));
}
/// <summary>
/// 更新设备数据
/// </summary>
/// <param name="update"></param>
/// <returns></returns>
public static async Task <XResponseMessage> ProcessDeviceUpdate(DeviceUpdateData update)
{
if (update == null)
{
throw new ArgumentNullException("update");
}
//更新设备
if (update.Devices != null && update.Devices.Any())
{
var updateList = new List <DeviceDto>();
var setList = new List <DeviceExceptionSetDto>();
//foreach (var deviceModel in update.Facility.Where(d => d != null))
update.Devices.Where(d => d != null).ForEach(async deviceModel =>
{
var devDb = await _deviceService.GetDeviceByIdAsny(deviceModel.Serialnum);
//if (devDb == null)
//{
devDb.Serialnum = deviceModel.Serialnum;
devDb.Name = deviceModel.Name;
devDb.FacilitySerialnum = deviceModel.FacilitySerialnum;
devDb.DeviceTypeSerialnum = deviceModel.DeviceTypeSerialnum;
devDb.Unit = deviceModel.Unit;
devDb.ProcessedValue = deviceModel.ProcessedValue;
devDb.ShowValue = deviceModel.ShowValue;
devDb.CreateTime = devDb.UpdateTime = deviceModel.UpdateTime;
//devDb.Save();
updateList.Add(devDb);
var set = await _deviceExceptionSetService.GetDeviceExceptionSetByDeviceIdAsny(devDb.Serialnum) ??
new DeviceExceptionSetDto()
{
DeviceSerialnum = devDb.Serialnum
};
if (deviceModel.Max != null)
{
set.Max = deviceModel.Max.Value;
}
if (deviceModel.Min != null)
{
set.Min = deviceModel.Min.Value;
}
setList.Add(set);
//}
});
try
{
if (updateList.Count() > 0 && updateList != null)
{
updateList.ForEach(dev =>
{
DeviceDto device = null;
if (_redis.Exists("device") == 1)
{
device = _redis.Smember <DeviceDto>("device", DataType.Protobuf).Find(d => d.Serialnum.EqualIgnoreCase(dev.Serialnum));
}
if (device != null)
{
_redis.Srem("device", dev, DataType.Protobuf);
}
//await _deviceService.AddDevice(dev);//保存设备
_redis.Sadd("device", dev, DataType.Protobuf);
});
}
if (setList.Count() > 0 && setList != null)
{
setList.ForEach(async set =>
{
await _deviceExceptionSetService.AddDeviceExceptionSet(set); //保存设备异常区间
});
}
}
catch (Exception ex)
{
return(ResultHelper.CreateMessage("", ErrorType.InternalError, null, ex));
}
}
//更新音视频设备
//var cameraDb = FacilityCamera.FindAllWithCache().ToList();
if (update.Cameras != null && update.Cameras.Any())
{
var cameraDb = new List <FacilityCameraDto>();
update.Cameras.ForEach(async mediaData =>
{
if (mediaData != null)
{
var cam = await _facilityCameraService.GetFacilityCameraByIdAsny(mediaData.DeviceCode);
if (cam != null)
{
cam.FacilitySerialnum = mediaData.FacilityCode;
cam.IP = mediaData.Url;
cam.HttpPort = mediaData.MediaPort;
cam.DataPort = mediaData.ContrPort;
cam.UserID = mediaData.User;
cam.UserPwd = mediaData.Pwd;
cam.Channel = mediaData.Channel;
cameraDb.Add(cam);
}
}
});
try
{
//保存设施摄像机
cameraDb.ForEach(c =>
{
//await _facilityCameraService.AddFacilityCamera(c);
FacilityCameraDto camera = null;
if (_redis.Exists("facilityCamera") == 1)
{
camera = _redis.Smember <FacilityCameraDto>("facilityCamera", DataType.Protobuf).Find(fc => fc.Serialnum.EqualIgnoreCase(c.Serialnum));
}
if (camera != null)
{
_redis.Srem("facilityCamera", camera, DataType.Protobuf);
}
_redis.Sadd("facilityCamera", camera, DataType.Protobuf);
});
}
catch (Exception ex)
{
return(ResultHelper.CreateMessage("", ErrorType.InternalError, null, ex));
}
}
return(null);
}
public async Task <IActionResult> GetRestaurantAsync(Guid restaurantId)
{
var queryResult = await queryDispatcher.PostAsync <GetRestaurantByIdQuery, RestaurantViewModel>(new GetRestaurantByIdQuery(new RestaurantId(restaurantId)), null);
return(ResultHelper.HandleResult(queryResult, failureMessageService));
}
public ActionResult Modify(GroupUser subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
GroupUser aSubject = db.GroupUser.Where(p => p.Id == subject.Id).FirstOrDefault();
//aSubject.CardName = subject.CardName;
//aSubject.CardModel = subject.CardModel;
//aSubject.ScreenCount = subject.ScreenCount;
//aSubject.ScreenNams = subject.ScreenNams;
aSubject = subject;
aSubject.UpdateDt = DateTime.Now;
if (db.SaveChanges() > 0)
{
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = subject,
Msg = "Edit Success!",
Desc = "Edit Success!"
};
}
else
{
objResult = new ResultHelper()
{
Desc = "Edit Faile,please try again.",
Msg = "Edit Faile,please try again.",
Obj = null,
Ret = -1,
Status = false
};
}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}
/// <summary>
/// 处理设备更新数据
/// </summary>
/// <param name="device">设备更新数据</param>
/// <returns></returns>
public async Task <XResponseMessage> ProcessAsync(DeviceModel device)
{
var d = await _deviceService.GetDeviceByIdAsny(device.Serialnum);
if (d == null)
{
return(ResultHelper.CreateMessage("设备不存在", ErrorType.DeviceNotExists));
}
var deviceType = await _deviceTypeService.GetByIdAsync(device.DeviceTypeSerialnum);
if (deviceType == null)
{
return(ResultHelper.CreateMessage("设备类型不存在", ErrorType.DeviceTypeNotExists));
}
var item = await _deviceService.GetDeviceByIdAsny(device.Serialnum);
//数据库中不存在该设备并且更新时间大于最新的更新时间
if (item == null || device.UpdateTime < item.UpdateTime)
{
return(null);
}
item.Serialnum = device.Serialnum;
item.Name = device.Name;
item.DeviceTypeSerialnum = device.DeviceTypeSerialnum;
item.FacilitySerialnum = device.FacilitySerialnum;
item.UpdateTime = device.UpdateTime;
item.Unit = device.Unit;
item.ProcessedValue = device.ProcessedValue;
item.ShowValue = device.ShowValue;
item.RelayType = device.RelayType;
var deviceset = await _deviceExceptionSet.GetDeviceExceptionSetByDeviceIdAsny(device.Serialnum);
//创建设备异常区间
var set = new DeviceExceptionSetDto
{
Max = device.Max,
Min = device.Min,
DeviceSerialnum = device.Serialnum,
Status = true,
CreateTime = device.UpdateTime,
UpdateTime = device.UpdateTime
};
if (deviceset == null)
{
set.Serialnum = Guid.NewGuid().ToString();
await _deviceExceptionSet.AddDeviceExceptionSet(set);
}
else
{
set.Serialnum = deviceset.Serialnum;
await _deviceExceptionSet.UpdateAsny(set);
}
try
{
var result = await _deviceService.UpdateDevice(item);
LogHelper.Trace("[设备]设备{0}{1}更新{2}", device.Name, device.Serialnum, result);
return(ResultHelper.CreateMessage($"更新设备{(result ? "成功" : "失败")}",
result ? ErrorType.NoError : ErrorType.InternalError));
}
catch (AggregateException ex)
{
LogHelper.Error(ex.ToString());
return(ResultHelper.CreateExceptionMessage(ex, "更新设备失败"));
}
}
public ActionResult Add(GroupUser subject)
{
ResultHelper objResult = null;
try
{
using (LedDb db = new LedDb())
{
if (ModelState.IsValid)
{
subject.UpdateDt = DateTime.Now;
subject.CreateDt = DateTime.Now;
subject.IsDel = 0;
db.GroupUser.Add(subject);
if (db.SaveChanges() > 0)
{
objResult = new ResultHelper()
{
Status = true,
Ret = 0,
Obj = subject,
Msg = "Add Success!",
Desc = "Add Success!"
};
}
else
{
objResult = new ResultHelper()
{
Desc = "Add Faile,please try again.",
Msg = "Add Faile,please try again.",
Obj = null,
Ret = -1,
Status = false
};
}
}
else
{
objResult = new ResultHelper()
{
Desc = " Faile,please try again",
Msg = " Faile,please try again",
Obj = null,
Ret = -1,
Status = false
};
}
}
}
catch (Exception ex)
{
objResult = new ResultHelper()
{
Desc = ex.Message,
Msg = ex.Message,
Obj = null,
Ret = -1,
Status = false
};
}
return(Json(objResult));
}
public bool Edit(ref ValidationErrors errors, SysUserEditModel model)
{
try
{
SysUser entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.Add(Resource.Disable);
return(false);
}
entity.TrueName = model.TrueName;
entity.Card = model.Card;
entity.MobileNumber = model.MobileNumber;
entity.PhoneNumber = model.PhoneNumber;
entity.QQ = model.QQ;
entity.EmailAddress = model.EmailAddress;
entity.OtherContact = model.OtherContact;
entity.Province = model.Province;
entity.City = model.City;
entity.Village = model.Village;
entity.Address = model.Address;
entity.State = model.State;
entity.CreateTime = model.CreateTime;
entity.CreatePerson = model.CreatePerson;
entity.Sex = model.Sex;
entity.Birthday = ResultHelper.StringConvertDatetime(model.Birthday);
entity.JoinDate = ResultHelper.StringConvertDatetime(model.JoinDate);
entity.Marital = model.Marital;
entity.Political = model.Political;
entity.Nationality = model.Nationality;
entity.Native = model.Native;
entity.School = model.School;
entity.Professional = model.Professional;
entity.Degree = model.Degree;
entity.DepId = model.DepId;
entity.PosId = model.PosId;
entity.Expertise = model.Expertise;
entity.JobState = model.JobState;
entity.Photo = model.Photo;
entity.Attach = model.Attach;
entity.Lead = model.Lead;
entity.LeadName = model.LeadName;
entity.IsSelLead = model.IsSelLead;
entity.IsReportCalendar = model.IsReportCalendar;
entity.IsSecretary = model.IsSecretary;
if (m_Rep.Edit(entity))
{
return(true);
}
else
{
errors.Add(Resource.NoDataChange);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public virtual object Execute(ExecutionInformation info, IReadOnlyList <ICommand> arguments, IReadOnlyList <Type> returnTypes)
{
// Make arguments lazy, we only want to execute them once
arguments = arguments.Select(c => new LazyCommand(c)).ToArray();
var parameters = FitArguments(info, arguments, returnTypes, out int availableArguments);
// Check if we were able to set enough arguments
int wantArgumentCount = Math.Min(parameters.Length, RequiredParameters);
if (availableArguments < wantArgumentCount)
{
if (returnTypes.Contains(typeof(ICommand)))
{
return(arguments.Count > 0
? (object)new AppliedCommand(this, arguments)
: this);
}
throw ThrowAtLeastNArguments(wantArgumentCount);
}
if (returnTypes[0] == null)
{
// Evaluate
ExecuteFunction(parameters);
return(null);
}
if (returnTypes[0] == typeof(ICommand))
{
// Return a command if we can take more arguments
if (CommandParameter.Any(p => p.Type == typeof(string[])) || availableArguments < NormalParameters)
{
return(new AppliedCommand(this, arguments));
}
}
Log.Debug("Iterating over return types [{@returnTypes}]", returnTypes);
var result = ExecuteFunction(parameters);
if (ResultHelper.IsValidResult(result, returnTypes))
{
Log.Debug("{0} can be directly returned", result);
return(result);
}
if (result == null)
{
throw new CommandException("Couldn't find a proper command result for function " + internCommand.Name, CommandExceptionReason.NoReturnMatch);
}
var unwrapedResult = UnwrapReturn(result);
var resultType = result.GetType();
var unwrapedResultType = unwrapedResult.GetType();
// Take first fitting command result
foreach (var returnType in returnTypes)
{
if (returnType == null)
{
return(null);
}
if (returnType.IsAssignableFrom(resultType))
{
return(ResultHelper.ToResult(returnType, result));
}
else if (returnType.IsAssignableFrom(unwrapedResultType))
{
return(ResultHelper.ToResult(returnType, unwrapedResult));
}
else if (returnType == typeof(string))
{
Log.Debug("Convert result to a string");
var resultStr = result.ToString();
if (!string.IsNullOrEmpty(resultStr))
{
return(new PrimitiveResult <string>(resultStr));
}
}
else if (BasicTypes.Contains(returnType))
{
if (BasicTypes.Contains(unwrapedResultType) && unwrapedResultType != typeof(string))
{
// Automatically try to convert between primitive types
try
{
return(ResultHelper.ToResult(resultType,
Convert.ChangeType(unwrapedResult, returnType, CultureInfo.InvariantCulture)));
}
catch
{
}
}
}
else if (returnType == typeof(JsonObject))
{
if (result is JsonObject jsonResult)
{
return(jsonResult);
}
else
{
return(Activator.CreateInstance(typeof(JsonValue <>).MakeGenericType(result.GetType()), result));
}
}
// Ignore unknown types
}
throw new CommandException("Couldn't find a proper command result for function " + internCommand.Name, CommandExceptionReason.NoReturnMatch);
}
public Response Execute(User currentUser, string request)
{
var req = JsonConvert.DeserializeObject <Request <CoachStudent> >(request);
//实体转换
List <CoachBootcampStudent> studentList = new List <CoachBootcampStudent>();
foreach (var item in req.Entities)
{
CoachBootcampStudent student = new CoachBootcampStudent();
var coachStudent = item as CoachStudent;
student.CoachBootcampId = coachStudent.CoachBootcampId;
student.StudentId = coachStudent.UserId;
student.RowState = coachStudent.RowState;
studentList.Add(student);
}
//开始业务逻辑操作
Response rsp = ResultHelper.CreateResponse();
var studentObj = req.FirstEntity();
if (studentObj.RowState == RowState.Added)//添加
{
foreach (var obj in studentList)
{
//先检查是否已添加
var student = GetCoachBootcampStudent(obj);
if (student != null)
{
return(ResultHelper.Fail("学员:[ " + student.StudentName + " ]已添加,不能再添加"));
}
//再添加
var bootcamp = CoachHelper.Instance.GetCoachBootcampById(obj.CoachBootcampId);
if (bootcamp != null)
{
obj.SealedOrganizationId = bootcamp.SealedOrganizationId;
}
else
{
return(ResultHelper.Fail("封闭机构Id获取失败"));
}
List <EntityBase> entites = new List <EntityBase>();
if (obj.RowState == RowState.Added)
{
obj.TrySetNewEntity();
}
entites.Add(obj);
rsp = DbContext.GetInstance().Execute(CommandHelper.CreateSave(entites));
SystemHelper.CheckResponseIfError(rsp);
//为学员充值集训余额次数
SaveSealedCoachStudentMoney(obj, bootcamp);
}
}
else if (studentObj.RowState == RowState.Deleted) //删除
{
CoachBootcampStudent coachBootcampStudent = new CoachBootcampStudent();
//删除学员的余额信息
coachBootcampStudent = CoachHelper.Instance.GetBootcampStudentById(studentObj.Id);
DeleteStudentBalance(coachBootcampStudent);
//删除学员
SystemHelper.Instance.DeleteEntity(coachBootcampStudent);
}
return(rsp);
}
