/// <summary>
/// 看是否已经存在该typeid的类别
/// </summary>
/// <param name="typeID"></param>
/// <returns></returns>
public bool IfExists(string typeID)
{
string strSql = "select TypeName from Tab_Nav where TypeParentID=@typeID";
SqlParameter param = new SqlParameter("@typeID", typeID);
object obj = SqlHelps.ExecuteScalar(ConnectionString, CommandType.Text, strSql, param);
if (obj != null && obj.ToString() != "")
{
return(true);
}
return(false);
}
/// <summary>
/// 查询个数
/// </summary>
/// <returns></returns>
public int QueryCheckRolesCount(string RolesName)
{
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" 1=1");
if (string.IsNullOrEmpty(RolesName))
{
strSqlWhere.Append(" and RolesName like '%" + RolesName + "%'");
}
string strSql = "select count(*) from tab_Roles where" + strSqlWhere.ToString() + "";
return(Convert.ToInt32(SqlHelps.ExecuteScalar(ConnectionString, CommandType.Text, strSql)));
}
/// <summary>
/// 查询个数
/// </summary>
/// <returns></returns>
public int QueryCheckUsersCount(int id)
{
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" 1=1");
if (id != null && id != 0)
{
strSqlWhere.Append(" and roseId = " + id);
}
string strSql = "select count(*) from Tab_User where" + strSqlWhere.ToString();
return(Convert.ToInt32(SqlHelps.ExecuteScalar(ConnectionString, CommandType.Text, strSql)));
}
/// <summary>
/// 查询个数
/// </summary>
/// <returns></returns>
public int IsExistCheckRoles(string RolesName)
{
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" 1=1");
if (!string.IsNullOrEmpty(RolesName))
{
strSqlWhere.Append(" and RolesName = '" + RolesName + "'");
}
string strSql = "select count(*) from tab_Roles where" + strSqlWhere.ToString() + "";
return(Convert.ToInt32(SqlHelps.ExecuteScalar(SqlHelps.SQLConnString, CommandType.Text, strSql)));
}
/// <summary>
/// 查询个数
/// </summary>
/// <returns></returns>
public int IsExistCheckRoles(string userNumber)
{
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" 1=1");
if (!string.IsNullOrEmpty(userNumber))
{
strSqlWhere.Append(" and userNumber = '" + userNumber + "'");
}
string strSql = "select count(*) from Tab_User where" + strSqlWhere.ToString() + "";
return(Convert.ToInt32(SqlHelps.ExecuteScalar(ConnectionString, CommandType.Text, strSql)));
}
/// <summary>
/// 获得数据列表个数
/// </summary>
/// <returns></returns>
public int QueryCheckDiaryCount(string Begintime, string EndTimeStr)
{
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" 1=1");
if (Begintime != "" && Begintime != null)
{
strSqlWhere.Append(" and convert(varchar, addtime, 23)>='" + Begintime + "'");
}
if (EndTimeStr != "" && EndTimeStr != null)
{
strSqlWhere.Append(" and convert(varchar, addtime, 23)<='" + EndTimeStr + "'");
}
string strSql = "select count(*) from VIEW_Diary where " + strSqlWhere + "";
return(Convert.ToInt32(SqlHelps.ExecuteScalar(ConnectionString, CommandType.Text, strSql)));
}