/* * 由角色ID得到SysPower */ public Response <SysPower> GetSysPowerByRoleId(decimal id) { var db = new DataWRYJCDataContext(); //获得拥有对应role id的SysRoleAndSysPower项 List <SysRoleAndSysPower> roleAndPowerList = (from item in db.SysRoleAndSysPower where item.SysRoleId == id select item).ToList(); //获取内容转到List<SysPower>当中 List <SysPower> list = new List <SysPower>(); for (int i = 0; i < roleAndPowerList.Count; ++i) { List <SysPower> tempList = (from item in db.SysPower where item.Id == roleAndPowerList[i].SysPowerId select item).ToList(); if (tempList.Count == 1) { list.Add(tempList[0]); } } return(new Response <SysPower> { isSuccess = true, list = list }); }
public Response <SysRole> GetSysRoleBySysUserId(decimal id) { var db = new DataWRYJCDataContext(); List <SysUserAndSysRole> sysUserAndSysRoleList = (from item in db.SysUserAndSysRole where item.SysUserId == id select item).ToList(); List <SysRole> list = new List <SysRole>(); for (int i = 0; i < sysUserAndSysRoleList.Count; ++i) { List <SysRole> tempList = (from item in db.SysRole where item.Id == sysUserAndSysRoleList[i].SysRoleId select item).ToList(); if (tempList.Count == 1) { list.Add(tempList[0]); } } return(new Response <SysRole> { list = list, isSuccess = true }); }
//张雪婷 public Response <GasDayData> GetDayDataByDateRange(DateTime from, DateTime to) { var db = new DataWRYJCDataContext(); //List<GasDayData> list = (from item in db.GasDayData where()) Response <GasDayData> res = null; return(res); }
public Response <Enterprise> GetAllEnterprises() { var db = new DataWRYJCDataContext(); List <Enterprise> list = (from item in db.Enterprise select item).ToList(); return(new Response <Enterprise>() { list = list, isSuccess = true }); }
public Response <PollutionPoint> GetAllPollutionPoints() { var db = new DataWRYJCDataContext(); List <PollutionPoint> list = (from item in db.PollutionPoint select item).ToList(); return(new Response <PollutionPoint>() { list = list, isSuccess = true }); }
public Response <SysPower> GetAllPowers() { List <SysPower> list; var db = new DataWRYJCDataContext(); list = (from item in db.SysPower select item).ToList(); return(new Response <SysPower> { isSuccess = true, list = list }); }
public Response <PollutionPoint> GetPollutionPointByEnterpriseId(decimal id) { var db = new DataWRYJCDataContext(); List <PollutionPoint> list = (from item in db.PollutionPoint where item.EnterpriseId == id select item).ToList(); return(new Response <PollutionPoint>() { list = list, isSuccess = true }); }
/* * 通过用户权利获取用户能够掌控的菜单内容 */ public Response <SysMenu> GetSysMenuByUserPower(List <SysPower> userPowers) { List <SysMenu> menus = new List <SysMenu>(); var db = new DataWRYJCDataContext(); for (int i = 0; i < userPowers.Count; ++i) { SysMenu temp = (from item in db.SysMenu where item.ID == userPowers[i].SysMenuID select item).ToList()[0]; menus.Add(temp); } return(new Response <SysMenu> { isSuccess = true, list = menus }); }
public Response <GasDayData> GetDayDataByID(decimal id) { var db = new DataWRYJCDataContext(); List <GasDayData> list = (from item in db.GasDayData where (id.Equals(item.ID)) select item).ToList(); if (list.Count != 1) { return new Response <GasDayData> { isSuccess = false } } ; else { return new Response <GasDayData> { list = list, isSuccess = true } }; }
//张晗 public Response <GasDayData> getDayDataByPollutionPointID(decimal id) { var db = new DataWRYJCDataContext(); List <GasDayData> list = (from item in db.GasDayData where (id.Equals(item.WasteObjectID)) select item).ToList(); if (list.Count == 0) { return new Response <GasDayData> { isSuccess = false } } ; else { return new Response <GasDayData> { list = list, isSuccess = true } }; } }
public Response <SysUser> GetUserByNameAndPassWord(string loginName, string encryptPwd) { var db = new DataWRYJCDataContext(); List <SysUser> user = (from m in db.SysUser where m.LoginName == loginName && m.Pwd == encryptPwd select m).ToList(); if (user.Count != 1) { return(new Response <SysUser> { isSuccess = false, list = user }); } else { return(new Response <SysUser> { isSuccess = true, list = user }); } }