/// <summary>
/// 得到角色菜单信息
/// </summary>
/// <returns></returns>
public static DataTable getMenuInfo(long RoleId)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string sql = "SELECT c.NODEID, c.text FROM ROLE_MENU b,menu c WHERE b.ROLE_ID = " + RoleId + "and b.NODEID = c.NODEID and c.TREELEVEL=2 Order By c.NODEID";
return(dCurService.GetOleTable(sql));
}
public static DataTable gettable(string t)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select * FROM " + t + " ";
return(dCurService.GetOleTable(strSql));
}
public static DataTable GetSBinform2(string SB_ID)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select * FROM SB_INFOR where SB_ID='" + SB_ID + "'";
return(dCurService.GetOleTable(strSql));
}
public static DataTable GetCRKJLinform(string Filter)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select * FROM BJCRJL where (" + Filter + ")";
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 读取用户信息
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public static DataTable getCurUserInfo(string UserName)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select * FROM USER_infor where user_name='" + UserName + "'";
return(dCurService.GetOleTable(strSql));
}
public static DataTable getPJInfo(string KC, string Filter, string PX)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select * FROM 井开次效益汇总 where 开次='" + KC + "' and " + Filter + " order by " + PX + " ";
return(dCurService.GetOleTable(strSql));
}
public static DataTable getPJInfo(string Filter, string PX)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select * FROM 井效益钻速汇总 where (" + Filter + ") order by " + PX + " ";
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 得到角色信息
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static DataTable getDtRoleInfo(long roleid)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = string.Format("select ROLE_ID,role_name from role where ROLE_ID=" + roleid);
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 读取单位信息
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public static DataTable getBMInfo(string BM_Name)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select * FROM department where bm_name='" + BM_Name + "'";
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 得到菜单信息
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static DataTable getMenuInfo()
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "select NODEID,TEXT from menu where TREELEVEL=2 ORDER BY NODEID";
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 得到角色信息
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static DataTable getDtRoleInfo()
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = string.Format("select ROLE_ID,role_name from role order by ROLE_ID");
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 得到当前用户表姓名或用户名相同的记录表
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public static DataTable getUsersInfo(string szFilter)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = "SELECT USER_INFOR.*, USER_ROLE.ROLE_ID, ROLE.ROLE_NAME FROM (USER_INFOR LEFT JOIN USER_ROLE ON USER_INFOR.USER_ID = USER_ROLE.USER_ID) LEFT JOIN ROLE ON USER_ROLE.ROLE_ID = ROLE.ROLE_ID WHERE (" + szFilter + ") ";
return(dCurService.GetOleTable(strSql));
}
public static DataTable GETDCSD(string t)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = string.Format("Select * FROM 井深地层信息 where 井号 in (" + t + " ) ");
return(dCurService.GetOleTable(strSql));
}
public static DataTable GETtableXYk(double x, double Y, int K)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
string strSql = string.Format("Select * FROM 井坐标 where X<" + x + "+" + K + " AND X>" + x + "-" + K + " AND Y<" + Y + "+" + K + " AND Y>" + Y + "-" + K + " ");
return(dCurService.GetOleTable(strSql));
}
public static DataTable getJBBXXInfo(long count, long page, string Filter)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
long count2 = (page - 1) * count;
string strSql = "select top " + count + " * FROM 井漏数据 where (" + Filter + ") order by 编号";
if (page > 1)
{
strSql = "select top " + count + " * FROM 井漏数据 where (" + Filter + ") and 编号>(select max(编号) from(select top " + count2 + " 编号 FROM 井漏数据 where (" + Filter + ") order by 编号)) order by 编号 ";
}
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 读取设备基本信息
/// </summary>
/// <returns></returns>
public static DataTable GetSBinform(long count, long page)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
long count2 = (page - 1) * count;
string strSql = "select top " + count + " * FROM SB_INFOR order by 行号";
if (page > 1)
{
strSql = "select top " + count + " * FROM SB_INFOR where 行号>(select max(行号) from(select top " + count2 + " 行号 FROM SB_INFOR order by 行号)) order by 行号 ";
}
return(dCurService.GetOleTable(strSql));
}
/// <summary>
/// 读取井信息
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public static DataTable getJBBXXInfo(long count, long page)
{
DataService.DataService dCurService = new Jin.DataService.DataService();
long count2 = (page - 1) * count;
string strSql = "select top " + count + " * FROM 井基本数据 order by 井号 ";
if (page > 1)
{
strSql = "select top " + count + " * FROM 井基本数据 where 井号>(select max(井号) from(select top " + count2 + " 井号 FROM 井基本数据 order by 井号)) order by 井号 ";
}
return(dCurService.GetOleTable(strSql));
}
