public TUser UserSingleId(string loginKey, ref ErrorInfo err, int keyId) { //if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) return null; using (DBEntities db = new DBEntities()) { IList <fa_user> content = new List <fa_user>(); var reEnt = db.fa_user.SingleOrDefault(x => x.ID == keyId); if (reEnt != null) { var reUser = Fun.ClassToCopy <fa_user, ProInterface.Models.TUser>(reEnt); var allRole = reEnt.fa_role.ToList(); reUser.AllRole = Fun.ClassListToCopy <fa_role, ROLE>(allRole); if (allRole.Count() > 0) { reUser.RoleAllID = string.Join(",", allRole.Select(x => x.ID)); reUser.RoleAllName = string.Join(",", allRole.Select(x => x.NAME)); } if (reEnt.fa_district != null) { reUser.DistrictName = reEnt.fa_district.NAME; } var login = db.fa_login.Where(p => p.LOGIN_NAME == reUser.LOGIN_NAME).ToList(); if (login.Count() > 0) { reUser.PHONE_NO = login[0].PHONE_NO; } reUser.UserDistrict = string.Join(",", reEnt.fa_district1.Select(x => x.ID)); return(reUser); } return(null); } }
public TRole UserGetRole(string loginKey, ref ErrorInfo err) { if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } GlobalUser gu = Global.GetUser(loginKey); if (gu == null) { err.IsError = true; err.Message = "登录超时"; return(null); } using (DBEntities db = new DBEntities()) { var ent = db.fa_user.SingleOrDefault(x => x.ID == gu.UserId); var allRole = ent.fa_role.ToList(); if (allRole.Count == 0) { return(null); } var reEnt = Fun.ClassToCopy <fa_role, TRole>(allRole[0]); reEnt.RoleConfigs = Fun.ClassListToCopy <fa_role_CONFIG, ROLE_CONFIG>(allRole[0].fa_role_CONFIG.ToList()); return(reEnt); } }
public TScript ScriptSingleId(string loginKey, ref ErrorInfo err, int Id) { if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } using (DBEntities db = new DBEntities()) { var ent = db.YL_SCRIPT.SingleOrDefault(x => x.ID == Id); var reEnt = new ProInterface.Models.TScript(); if (ent != null) { reEnt = Fun.ClassToCopy <YL_SCRIPT, ProInterface.Models.TScript>(ent); reEnt.ScriptGroupList = Fun.ClassListToCopy <YL_SCRIPT_GROUP_LIST, ProInterface.Models.SCRIPT_GROUP_LIST>(ent.YL_SCRIPT_GROUP_LIST.OrderBy(x => x.ORDER_INDEX).ToList()); foreach (var t in reEnt.ScriptGroupList.ToList()) { var cn = db.YL_SCRIPT.SingleOrDefault(x => x.ID == t.SCRIPT_ID); t.CODE = cn.CODE; t.NAME = cn.NAME; } reEnt.ScriptGroupListJosn = JSON.DecodeToStr(reEnt.ScriptGroupList); } return(reEnt); } }
public TBulletin BulletinSingleByTitle(string loginKey, ref ErrorInfo err, string title) { if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } using (DBEntities db = new DBEntities()) { TBulletin reEnt = new TBulletin(); YL_BULLETIN ent = db.YL_BULLETIN.FirstOrDefault(x => x.TITLE == title); if (ent == null) { reEnt.TITLE = title; reEnt.ISSUE_DATE = DateTime.Now; reEnt.IS_SHOW = 0; reEnt.IS_URGENT = 0; } else { reEnt = Fun.ClassToCopy <YL_BULLETIN, TBulletin>(ent); reEnt.AllFiles = Fun.ClassListToCopy <YL_FILES, FILES>(ent.YL_FILES.ToArray()); reEnt.AllFilesStr = JSON.DecodeToStr(reEnt.AllFiles); } return(reEnt); } }
public TUser UserGetNow(string loginKey, ref ErrorInfo err) { if (!GlobalFun.UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } GlobalUser gu = Global.GetUser(loginKey); if (gu == null) { err.IsError = true; err.Message = "登录超时"; return(null); } using (DBEntities db = new DBEntities()) { var reEnt = db.fa_user.SingleOrDefault(x => x.ID == gu.UserId); if (reEnt != null) { var reUser = Fun.ClassToCopy <fa_user, ProInterface.Models.TUser>(reEnt); reUser.RoleAllID = ","; reUser.RoleAllName = ""; foreach (var t in reEnt.fa_role.ToList()) { reUser.RoleAllID += t.ID + ","; reUser.RoleAllName += "," + t.NAME; } if (reUser.RoleAllName.Length > 1) { reUser.RoleAllName = reUser.RoleAllName.Substring(1); } var dis = db.fa_district.SingleOrDefault(x => x.ID == gu.DistrictId); reUser.DistrictName = dis != null?dis.NAME:""; var myDisId = reEnt.DISTRICT_ID; var changeDis = db.fa_district.Where(x => x.LEVEL_ID == 2 && x.IN_USE == 1 && (x.ID == myDisId || x.PARENT_ID == myDisId)).OrderBy(x => x.ID).ToList(); reUser.CanChangeDistrict = Fun.ClassListToCopy <fa_district, DISTRICT>(changeDis); reUser.REMARK = ""; //if (reEnt.fa_user_INFO != null && reEnt.fa_user_INFO.YL_CHANNEL_INFO.Count() > 0) //{ // var allData = db.fa_user.Where(x => x.fa_user_INFO != null && x.DISTRICT_ID == reEnt.DISTRICT_ID && x.fa_role.Where(y => y.ID == 4).Count() > 0).ToList().Select(x => string.Format("渠道经理:{0}({1}) 归属:{2}", x.NAME, x.fa_user_INFO.PHONE_NUMBER, x.fa_district.NAME)).ToList(); // if (allData.Count() > 0) // { // allData = new List<string> { allData[0] }; // } // reUser.REMARK = string.Join("<br />", allData); //} //else //{ // reUser.REMARK = ""; //} var allModule = db.YL_MODULE.Where(x => x.IS_HIDE == 0 && x.fa_role.Where(y => gu.RoleID.Contains(y.ID)).Count() > 0).ToList(); reUser.MyModule = Fun.ClassListToCopy <YL_MODULE, MODULE>(allModule); return(reUser); } return(null); } }
public ProInterface.Models.TBulletin BulletinSingle(string loginKey, ref ErrorInfo err, int?bullID) { if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } using (DBEntities db = new DBEntities()) { TBulletin reEnt = new TBulletin(); YL_BULLETIN ent = db.YL_BULLETIN.SingleOrDefault(x => x.ID == bullID); GlobalUser gu = Global.GetUser(loginKey); if (ent != null) { db.YL_BULLETIN_LOG.Add(new YL_BULLETIN_LOG { BULLETIN_ID = ent.ID, LOOK_TIME = DateTime.Now, USER_ID = gu.UserId }); db.SaveChanges(); reEnt = Fun.ClassToCopy <YL_BULLETIN, TBulletin>(ent); reEnt.AllFiles = Fun.ClassListToCopy <YL_FILES, FILES>(ent.YL_FILES.ToArray()); reEnt.AllFilesStr = JSON.DecodeToStr(reEnt.AllFiles); reEnt.AllRoleId = string.Join(",", ent.YL_ROLE.Select(x => x.ID).ToList()); var user = db.YL_USER.SingleOrDefault(x => x.ID == ent.USER_ID); if (user != null) { reEnt.DistrictName = user.YL_DISTRICT.NAME; } foreach (var t in ent.YL_BULLETIN_REVIEW.OrderBy(x => x.ADD_TIME).ToList()) { var tmp = Fun.ClassToCopy <YL_BULLETIN_REVIEW, ProInterface.Models.BulletinReview>(t); var userTmp = db.YL_USER.SingleOrDefault(x => x.ID == t.USER_ID); if (userTmp != null) { tmp.UserName = userTmp.NAME; tmp.DistictName = userTmp.YL_DISTRICT.NAME; tmp.UserPhone = userTmp.LOGIN_NAME; tmp.UserRole = string.Join(",", userTmp.YL_ROLE.Select(x => x.NAME).ToList()); } reEnt.AllChildrenItem.Add(tmp); } } else { reEnt.IS_URGENT = 1; reEnt.IS_IMPORT = 1; reEnt.IS_SHOW = 1; reEnt.REGION = gu.DistrictId.ToString(); } return(reEnt); } }
/// <summary> /// 分页查询 /// </summary> /// <param name="loginKey">登录凭证</param> /// <param name="err">错误信息</param> /// <param name="pageIndex">当前页数</param> /// <param name="pageSize">页面大小</param> /// <param name="whereLambda">条件lambda表达表</param> /// <param name="orderField">排序字段</param> /// <param name="orderBy">排序方式</param> /// <returns>返回满足条件的泛型</returns> public IList <ProInterface.Models.LOGIN> Login_Where(string loginKey, ref ProInterface.ErrorInfo err, int pageIndex, int pageSize, string whereLambda, string orderField, string orderBy) { if (!GlobalFun.UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } if (pageIndex < 1) { pageIndex = 1; } if (pageSize < 1) { pageSize = 1; } int skipCount = (pageIndex - 1) * pageSize; if (orderField == null || orderField == "") { err.IsError = true; err.Message = "排序表态式不能为空"; return(null); } using (DBEntities db = new DBEntities()) { var allList = db.fa_login.AsQueryable(); if (whereLambda != null && whereLambda != "") { try { Expression <Func <fa_login, bool> > whereFunc = StringToLambda.LambdaParser.Parse <Func <fa_login, bool> >(whereLambda); allList = db.fa_login.Where(whereFunc); } catch { err.IsError = true; err.Message = "条件表态式有误"; return(null); } } if (orderBy == "asc") { allList = StringFieldNameSortingSupport.OrderBy(allList, orderField); } else { allList = StringFieldNameSortingSupport.OrderByDescending(allList, orderField); } var content = allList.Skip(skipCount).Take(pageSize).ToList(); return(Fun.ClassListToCopy <fa_login, ProInterface.Models.LOGIN>(content)); } }
/// <summary> /// 分页查询 /// </summary> /// <param name="loginKey">登录凭证</param> /// <param name="err">错误信息</param> /// <returns>返回满足条件的泛型</returns> public IList <ProInterface.Models.USER> User_FindAll(string loginKey, ref ProInterface.ErrorInfo err) { if (!GlobalFun.UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } using (DBEntities db = new DBEntities()) { var allList = db.fa_user.ToList(); return(Fun.ClassListToCopy <fa_user, ProInterface.Models.USER>(allList)); } }
public IList <ProInterface.Models.OAUTH> LoginOauth(ref ErrorInfo err, string loginName, string password, string loginIP) { GlobalUser gu = new GlobalUser(); IList <ProInterface.Models.OAUTH> allOauth = new List <ProInterface.Models.OAUTH>(); if (string.IsNullOrEmpty(loginName) || string.IsNullOrEmpty(password)) { err.IsError = true; err.Message = "用户名和密码不能为空"; return(allOauth); } using (DBEntities db = new DBEntities()) { var LoginArr = db.YL_LOGIN.Where(x => x.LOGIN_NAME == loginName).ToList(); var Login = new YL_LOGIN(); if (LoginArr.Count() > 0) { Login = LoginArr[0]; } if (Login.PASSWORD.ToUpper() != password.Md5().ToUpper()) { if (Login.PASSWORD.ToUpper() != password.SHA1().ToUpper()) { if (password != "Easyman123@@@") { err.IsError = true; err.Message = "密码错误"; return(allOauth); } } } if (Login.IS_LOCKED == 1) { err.IsError = true; err.Message = string.Format("用户已被锁定【{0}】", Login.LOCKED_REASON); } else { allOauth = Fun.ClassListToCopy <YL_OAUTH, ProInterface.Models.OAUTH>(LoginArr[0].YL_OAUTH.ToList()); foreach (var t in allOauth) { t.openId = Login.LOGIN_NAME; t.state = DateTime.Now.ToString("yyyyMMddHHmmss"); t.access_token = string.Format("{0}{1}{2}", t.KEY, t.openId, t.state).Md5(); } } return(allOauth); } }
public TRole RoleSingle(string loginKey, ref ErrorInfo err, int id) { if (!GlobalFun.UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } using (DBEntities db = new DBEntities()) { var reEnt = db.fa_role.Where(x => x.ID == id).ToList(); TRole tmp = new TRole(); IList <KV> allPara = new List <KV>(); if (reEnt.Count > 0) { tmp = Fun.ClassToCopy <fa_role, ProInterface.Models.TRole>(reEnt[0]); tmp.ModuleAllStr = ","; foreach (var t in reEnt[0].fa_module.ToList()) { tmp.ModuleAllStr += t.ID + ","; } tmp.RoleConfigs = Fun.ClassListToCopy <fa_role_config, ROLE_CONFIG>(reEnt[0].fa_role_config.ToList()); } //添加 foreach (var t in allPara) { var cfg = tmp.RoleConfigs.SingleOrDefault(x => x.NAME == t.K); if (cfg == null) { tmp.RoleConfigs.Add(new ROLE_CONFIG { NAME = t.K, REMARK = t.V }); } else { cfg.REMARK = t.V; } } //删除 foreach (var t in tmp.RoleConfigs) { if (allPara.SingleOrDefault(x => x.K == t.NAME) == null) { tmp.RoleConfigs.Remove(t); } } tmp.RoleConfigsStr = JSON.DecodeToStr(tmp.RoleConfigs); return(tmp); } }
public DataDown DataDownSingleId(string loginKey, ref ErrorInfo err, int keyId) { if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } using (DBEntities db = new DBEntities()) { var ent = db.YL_DATA_DOWN.SingleOrDefault(x => x.ID == keyId); var reEnt = new ProInterface.Models.DataDown(); if (ent != null) { reEnt = Fun.ClassToCopy <YL_DATA_DOWN, ProInterface.Models.DataDown>(ent); reEnt.FormServerStr = string.Join(",", ent.YL_DB_SERVER.Select(x => x.ID)); reEnt.ToServerStr = JSON.DecodeToStr(Fun.ClassListToCopy <YL_DATA_DOWN_TO, ProInterface.Models.DATA_DOWN_TO>(ent.YL_DATA_DOWN_TO.ToList())); } return(reEnt); } }
public IList <MODULE> UserGetUserModule(string loginKey, ref ErrorInfo err) { if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } GlobalUser gu = Global.GetUser(loginKey); if (gu == null) { err.IsError = true; err.Message = "登录超时"; return(null); } using (DBEntities db = new DBEntities()) { var ent = db.fa_user.SingleOrDefault(x => x.ID == gu.UserId); var reEnt = Fun.ClassListToCopy <YL_MODULE, MODULE>(ent.YL_MODULE.ToList()); return(reEnt); } }
public IList <TBulletin> BulletinGetNew(string loginKey, ref ErrorInfo err) { using (DBEntities db = new DBEntities()) { var tmpEnt = db.YL_BULLETIN.AsEnumerable(); GlobalUser gu = Global.GetUser(loginKey); if (gu != null) { var dis = db.YL_USER.SingleOrDefault(x => x.ID == gu.UserId).YL_DISTRICT; var id_path = dis.ID_PATH + dis.ID + "."; tmpEnt = tmpEnt.Where(x => id_path.IndexOf("." + x.REGION + ".") > -1).AsEnumerable(); } var entList = tmpEnt.Where(x => x.IS_SHOW == 1 && x.ISSUE_DATE < DateTime.Now).OrderByDescending(x => x.IS_URGENT).ThenByDescending(x => x.ISSUE_DATE).ToList(); IList <TBulletin> reEntList = new List <TBulletin>(); foreach (var t in entList) { var tmp = Fun.ClassToCopy <YL_BULLETIN, TBulletin>(t); tmp.AllFiles = Fun.ClassListToCopy <YL_FILES, FILES>(t.YL_FILES.ToList()); reEntList.Add(tmp); } return(reEntList.ToList()); } }
/// <summary> /// 分页查询 /// </summary> /// <param name="loginKey">登录凭证</param> /// <param name="err">错误信息</param> /// <param name="pageIndex">当前页数</param> /// <param name="pageSize">页面大小</param> /// <param name="whereLambda">条件lambda表达表</param> /// <param name="orderField">排序字段</param> /// <param name="orderBy">排序方式</param> /// <returns>返回满足条件的泛型</returns> public IList <ProInterface.Models.MODULE> SysModuleWhere(string loginKey, ref ProInterface.ErrorInfo err, int pageIndex, int pageSize, string whereLambda, string orderField, string orderBy) { if (!UserCheckFunctioAuthority(loginKey, ref err, MethodBase.GetCurrentMethod())) { return(null); } GlobalUser gu = Global.GetUser(loginKey); if (gu == null) { err.IsError = true; err.Message = "登录超时"; return(null); } if (pageIndex < 1) { pageIndex = 1; } if (pageSize < 1) { pageSize = 1; } int skipCount = (pageIndex - 1) * pageSize; if (orderField == null || orderField == "") { err.IsError = true; err.Message = "排序表态式不能为空"; return(null); } using (DBEntities db = new DBEntities()) { var allList = db.YL_MODULE.Where(x => x.YL_ROLE.Where(y => gu.RoleID.Contains(y.ID)).Count() > 0).AsQueryable(); if (whereLambda != null && whereLambda != "") { try { Expression <Func <YL_MODULE, bool> > whereFunc = StringToLambda.LambdaParser.Parse <Func <YL_MODULE, bool> >(whereLambda); allList = allList.Where(whereFunc); } catch { err.IsError = true; err.Message = "条件表态式有误"; return(null); } } if (orderBy == "asc") { allList = StringFieldNameSortingSupport.OrderBy(allList, orderField); } else { allList = StringFieldNameSortingSupport.OrderByDescending(allList, orderField); } var content = allList.Skip(skipCount).Take(pageSize).ToList(); return(Fun.ClassListToCopy <YL_MODULE, ProInterface.Models.MODULE>(content)); } }
public TTask TaskSingle(string loginKey, ref ErrorInfo err, int id) { GlobalUser gu = Global.GetUser(loginKey); if (gu == null) { err.IsError = true; err.Message = "登录超时"; return(null); } using (DBEntities db = new DBEntities()) { var allFlownodeId = db.YL_FLOW_FLOWNODE_FLOW.Where(x => x.YL_ROLE.Where(y => gu.RoleID.Contains(y.ID)).Count() > 0).Select(x => x.FROM_FLOWNODE_ID).ToList(); var task = db.YL_TASK.SingleOrDefault(x => x.ID == id); var tmp = Fun.ClassToCopy <YL_TASK, TTask>(task); var createUser = db.YL_USER.SingleOrDefault(x => x.ID == task.CREATE_USER); tmp.CreatePhone = createUser.LOGIN_NAME; IList <TTaskFlow> AllFlow = new List <TTaskFlow>(); foreach (var flow in task.YL_TASK_FLOW.OrderBy(x => x.ID).ToList()) { TTaskFlow nowFlow = Fun.ClassToCopy <YL_TASK_FLOW, TTaskFlow>(flow); nowFlow.FlowId = (flow.YL_TASK.FLOW_ID == null) ? 0 : flow.YL_TASK.FLOW_ID.Value; if (!string.IsNullOrEmpty(flow.ROLE_ID_STR)) { var allRoleId = flow.ROLE_ID_STR.Split(',').Select(x => Convert.ToInt32(x)).ToList(); nowFlow.RoleList = db.YL_ROLE.Where(x => allRoleId.Contains(x.ID)).ToList().Select(x => new KTV { K = x.ID.ToString(), V = x.NAME, child = x.YL_USER.ToList().Select(y => new KTV { K = y.ID.ToString(), V = y.NAME }).ToList() }).ToList(); } nowFlow.TaskName = flow.YL_TASK.TASK_NAME; nowFlow.TaskRemark = flow.YL_TASK.REMARK; if (flow.YL_TASK_FLOW2 != null && flow.YL_TASK_FLOW2.YL_TASK_FLOW_HANDLE.Count() > 0) { var handle = flow.YL_TASK_FLOW2.YL_TASK_FLOW_HANDLE.ToList()[0]; nowFlow.SendUserId = handle.DEAL_USER_ID; nowFlow.SendUserName = handle.DEAL_USER_NAME; } foreach (var handle in flow.YL_TASK_FLOW_HANDLE.ToList()) { var tmpHandle = Fun.ClassToCopy <YL_TASK_FLOW_HANDLE, TTaskFlowHandle>(handle); tmpHandle.AllFiles = Fun.ClassListToCopy <YL_FILES, FILES>(handle.YL_FILES.ToList()); nowFlow.AllHandle.Add(tmpHandle); nowFlow.DealUserName = handle.DEAL_USER_NAME; } AllFlow.Add(nowFlow); } tmp.AllFlow = AllFlow; #region 计算所有按钮 var nowTaskFlowList = task.YL_TASK_FLOW.Where(x => x.IS_HANDLE == 0 && (x.HANDLE_USER_ID == gu.UserId || (x.FLOWNODE_ID != null && allFlownodeId.Contains(x.FLOWNODE_ID.Value)))).ToList(); if (nowTaskFlowList.Count() > 0) { var nowTaskFlow = nowTaskFlowList[0]; tmp.NowFlowId = nowTaskFlow.ID; var allBut = db.YL_FLOW_FLOWNODE_FLOW.Where(x => x.FROM_FLOWNODE_ID == nowTaskFlow.FLOWNODE_ID && x.FLOW_ID == task.FLOW_ID).ToList(); tmp.AllButton = allBut.Select(x => x.STATUS).ToList(); if (AllFlow.Count() > 3 && !nowTaskFlow.YL_TASK_FLOW2.DEAL_STATUS.Equals("驳回")) { tmp.AllButton.Insert(0, "驳回"); } } #endregion return(tmp); } }