/// <summary>
/// 根据用户ID,获取用户对应的手机报表权限列表
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public DataTable GetPhoneReportListByUserID(string userID)
{
string strSql = string.Format(@"select F.* from WEB_REPORT_INFO F join (select distinct FUNC_ID from
(select ROLE_ID from Web_Login_Role where LOGIN_ID={0}) LR
join Web_Sys_Rolefuncs RF on LR.ROLE_ID=RF.ROLE_ID where FTYPE=6
)A on F.ID = A.FUNC_ID where status=1 and DELETED=0 order by SORT", userID);
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}
/// <summary>
/// 获取所有标注点详细信息
/// </summary>
/// <returns></returns>
public DataTable GetDetailInfo()
{
//暂时取固定的数据，一般取实时的日期时间
//string fdate = "2013-03-18";// DateTime.Now.ToString("yyyy-MM-dd");
//string ftime = "09:10:00";// DateTime.Now.ToString("HH:mm:ss");
string fdate = DateTime.Now.ToString("yyyy-MM-dd");
string ftime = DateTime.Now.ToString("HH:mm:ss");
string strSql = string.Format(@"select A.*, CHECKEDINNUM,CHECKEDOUTNUM,D.PARKFULLNAME from Web_Park_Location A
left join
(select PARKCODE,CHECKEDNUM as CHECKEDINNUM from WEB_PARK_IN where FDATE='{0}' and BEGINTIME<='{1}' and ENDTIME> '{1}')B
on A.PARKCODE = B.PARKCODE
left join
(select PARKCODE,CHECKEDNUM as CHECKEDOUTNUM from WEB_PARK_OUT where FDATE='{0}' and BEGINTIME<='{1}' and ENDTIME> '{1}')C
on A.PARKCODE = C.PARKCODE
left join SYS_PARK D on A.PARKCODE = D.PARKCODE", fdate, ftime);
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}
public DataTable GetAll()
{
string strSql = "select * from SYS_ROLE";
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}
public DataTable GetAll()
{
string strSql = "select * from SYS_PARK where DELETED !=1";
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}
public DataTable GetAll()
{
string strSql = "select * from WEB_REPORT_PARAMETER";
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}
public DataTable GetAll()
{
string strSql = "select * from WEB_LOGIN_ROLE where DELETED !=1";
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}
/// <summary>
/// 执行SQL返回DataSet
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string sql)
{
return(NHelper.ExecuteDataSet(sql));
}
public DataTable GetAll()
{
string strSql = "select * from WEB_PARK_LOCATION ";
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}
public DataTable GetAll()
{
string strSql = "select * from WEB_REPORT_CATEGORY where DELETED !=1";
return(NHelper.ExecuteDataSet(strSql).Tables[0]);
}