/*
* 由角色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
});
}
}
