public int GetCountByChart(string trendid)
{
int count = 0;
string sql = "";
//this.init();
sql = "SELECT count(*) FROM T_CHART_CHARTPARA WHERE CHARTID = " + trendid;
count = dl.RunRowCount(sql, out errMsg);
return(count);
}
public int GetCountByChart(string trendid)
{
int count = 0;
string sql = "";
sql = "SELECT count(*) FROM T_CHART_CHARTPARA WHERE CHARTID = " + trendid;
//if (rlDBType == "SQL")
// count = DBsql.RunRowCount(sql, out errMsg);
//else if (rlDBType == "DB2")
// count = DBdb2.RunRowCount(sql, out errMsg);
count = dl.RunRowCount(sql, out errMsg);
return(count);
}
/// <summary>
/// 判断某个岗位下面是否存在人员
/// </summary>
/// <param name="name">人员ID</param>
/// <returns></returns>
public bool JudgMemberByORGId(string id)
{
bool result = false;
string errMsg = "";
string sql = "select count(*) from Administrator.T_SYS_MEMBERGRP where T_GRPID='" + id + "'";
int count = dl.RunRowCount(sql, out errMsg);
if (count > 0)
{
result = true;
}
else
{
result = false;
}
return(result);
}
/// <summary>
/// 根据角色ID返回所有用户信息的条数
/// 创建：李东峰 日期：2014-03-11
/// </summary>
/// <returns>返回该角色下用户的数量</returns>
public int GetUserCountByRole()
{
string rlDBType = dl.init();
string sql = "select COUNT(*) from(select T_SYS_MEMBERINFO.ID_KEY,T_SYS_MEMBERINFO.T_USERID,T_SYS_MEMBERINFO.T_USERNAME,T_SYS_MEMBERGRP.T_GRPID from T_SYS_MEMBERINFO left JOIN T_SYS_MEMBERGRP ON T_SYS_MEMBERGRP.T_USERID=T_SYS_MEMBERINFO.T_USERID)as a where a.T_GRPID='" + RoleId + "'";
string sql1 = "select count(*) from ( select a.ID_KEY,a.T_USERID,a.T_USERNAME from (select T_SYS_MEMBERINFO.ID_KEY,T_SYS_MEMBERINFO.T_USERID,T_SYS_MEMBERINFO.T_USERNAME,T_SYS_MEMBERGRP.T_GRPID from T_SYS_MEMBERINFO left JOIN T_SYS_MEMBERGRP ON T_SYS_MEMBERGRP.T_USERID=T_SYS_MEMBERINFO.T_USERID ORDER BY T_SYS_MEMBERINFO.ID_KEY)as a where a.T_GRPID='" + RoleId + "')as b";
string sql2 = "select count(*) from ( select ID_KEY,T_USERID,T_USERNAME from (select T_SYS_MEMBERINFO.ID_KEY,T_SYS_MEMBERINFO.T_USERID,T_SYS_MEMBERINFO.T_USERNAME,T_SYS_MEMBERGRP.T_GRPID from T_SYS_MEMBERINFO left JOIN T_SYS_MEMBERGRP ON T_SYS_MEMBERGRP.T_USERID=T_SYS_MEMBERINFO.T_USERID ORDER BY T_SYS_MEMBERINFO.ID_KEY) where T_GRPID='" + RoleId + "')";
string errMsg;
int count = 0;
if (rlDBType == "SQL")
{
try
{
count = dl.RunRowCount(sql, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
}
else if (rlDBType == "DB2")
{
try
{
count = dl.RunRowCount(sql1, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
}
else if (rlDBType == "ORACLE")
{
try
{
DataTable dt = dl.RunDataTable(sql, out errMsg);
count = int.Parse(dt.Rows[0]["COUNT(*)"].ToString());
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
}
return(count);
}
