public bool Exists(string strvalue, int id)
{
bool blFlag = false;
int num = -1;
string strSql = "select count(*) from bas_org where org_name='{0}' {1} ";
if (id < 1)
{
strSql = string.Format(strSql, strvalue, "");
}
else
{
strSql = string.Format(strSql, strvalue, " and id <>" + id.ToString());
}
try
{
num = int.Parse(DataBase.ExecuteScalarToStr(strSql).ToString());
}
catch (Exception exception)
{
throw exception;
}
blFlag = (num > 0 ? true : false);
return(blFlag);
}
public bool Exists(string strWhere)
{
string strSql = " select count(*) from bas_user where 1=1 " + strWhere;
string strValue = DataBase.ExecuteScalarToStr(strSql);
return(int.Parse(strValue) > 0 ? true : false);
}
public int TotalCount(Dictionary <string, string> hash)
{
try
{
string strSql = " select count(*) from (" + DepartmentSql(hash) + ") a ";
return(int.Parse(DataBase.ExecuteScalarToStr(strSql).ToString()));
}
catch
{
return(0);
}
}
public int RoleTotalCount()
{
try
{
string strSql = " select count(*) from (" + RoleSql() + ") a ";
return(int.Parse(DataBase.ExecuteScalarToStr(strSql).ToString()));
}
catch
{
return(0);
}
}
/// <summary>
/// 一级菜单是否有子菜单
/// </summary>
public bool ExistsChild(string module_father)
{
int num = -1;
bool blFlag = false;
string strSql = "select count(*) from Bas_Module where module_father=" + module_father;
try
{
num = int.Parse(DataBase.ExecuteScalarToStr(strSql));
}
catch (Exception e)
{
throw e;
}
blFlag = (num > 0 ? true : false);
return(blFlag);
}
public bool Delete(string id)
{
bool blFlag = false;
int num = -1;
string sql = "delete from bas_org where id=" + id;
string count = DataBase.ExecuteScalarToStr("select count(*) from bas_user where orgid=" + id);
if (Hi.Common.Utils.StrToInt(count) > 0)
{
return(false);
}
try
{
num = DataBase.ExecuteNonQuery(sql);
}
catch (Exception exception)
{
throw exception;
}
blFlag = (num > 0 ? true : false);
return(blFlag);
}
//ID是否被引用
public bool IsUsing(string department_id)
{
bool InPerson = false;
bool InPlanPerson = false;
string strValue = "";
string strSql = "";
strSql = "select count(*) from bas_user where orgid=" + department_id;
strValue = DataBase.ExecuteScalarToStr(strSql);
if (int.Parse(strValue) > 0)
{
InPerson = true;
}
if (InPlanPerson || InPerson)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获得数据总记录数
/// </summary>
public int TotalCount(Dictionary <string, string> dict)
{
string strSql = "select count(*) from (" + GetSql(dict) + ") t ";
return(int.Parse(DataBase.ExecuteScalarToStr(strSql)));
}
/// <summary>
/// 获得数据总记录数
/// </summary>
public int TotalCount(Hashtable hash)
{
string strSql = "select count(*) from (" + GetSql(hash) + ") a ";
return(int.Parse(DataBase.ExecuteScalarToStr(strSql)));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool ParamExists(string strWhere)
{
string strSql = " select count(*) from bas_param where 1=1 " + strWhere;
return(int.Parse(DataBase.ExecuteScalarToStr(strSql)) > 0 ? true : false);
}