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); }