public bool IsExistsItemClass(string FNumber)
{
string sql = "select count(*) from t_ItemClass where FNumber='" + FNumber + "'";
object x = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return(int.Parse(x.ToString()) > 0);
}
/// <summary>
/// 检查用户组是否存在
/// </summary>
/// <param name="groupCode">用户组编号</param>
/// <returns></returns>
public bool CheckNoExists(string groupCode)
{
string sql = "select count(*) from sys_UserGroup where FNumber='" + groupCode + "'";
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return int.Parse(o.ToString()) > 0;
}
/// <summary>
/// 判断是否存在
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public bool IsExistsCommonType(string code)
{
string sql = "select count(*) from t_CommDataDictType where FDataType='" + code + "'";
object x = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return(int.Parse(x.ToString()) > 0);
}
public bool DeleteItemDesc(string fid)
{
string sql = "delete from t_ItemPropDesc where fid=" + fid;
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return int.Parse(o.ToString()) > 0;
}
public int GetMenuShow(string account, int moduleID)
{
string sql = "SELECT FIsShow FROM sys_UG_Auth_Menu WHERE (FUserType = 1) AND (FUGID = '" + account + "') AND (FMainInterfacesID = '" + moduleID.ToString() + "')";
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql); //DataProvider.Instance.ExecuteNoQuery(_Loginer.DBName, cmd.SqlCommand);
return(int.Parse(o.ToString()));
}
/// <summary>
/// 检查用户组是否存在
/// </summary>
/// <param name="groupCode">用户组编号</param>
/// <returns></returns>
public bool CheckNoExists(string groupCode)
{
string sql = "select count(*) from sys_UserGroup where FNumber='" + groupCode + "'";
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return(int.Parse(o.ToString()) > 0);
}
public bool ModifyPwdDirect(string account, string pwd, string DBName)
{
string sql = "update sys_User set Fpassword='******' where Faccount='" + account + "'";
object o = new DataBaseLayer(DBName).ExecuteSql(sql); //DataProvider.Instance.ExecuteNoQuery(DBName, cmd.SqlCommand);
return(int.Parse(o.ToString()) != 0);
}
/// <summary>
/// 添加一个类型
/// </summary>
/// <param name="fid"></param>
/// <param name="code"></param>
/// <param name="name"></param>
/// <returns></returns>
public bool AddCommonType(string fid, string code, string name)
{
string sql = "insert into t_CommDataDictType(Fid, FDataType, FTypeName, FIssys) values(" + fid.ToString() + ",'" + code + "','" + name + "',0)";
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return(int.Parse(o.ToString()) > 0);
}
public bool DeleteItemDesc(string fid)
{
string sql = "delete from t_ItemPropDesc where fid=" + fid;
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return(int.Parse(o.ToString()) > 0);
}
/// <summary>
/// 获取窗体的可用权限值
/// </summary>
/// <param name="account"></param>
/// <param name="moduleID"></param>
/// <returns></returns>
public int GetFormAuthority(string account, int moduleID)
{
string sql = "SELECT UA.FAuths FROM sys_UG_Auth UA INNER JOIN sys_UserGroup U ON UA.FUGID = U.FID INNER JOIN sys_Function F ON UA.FunctionID = F.FID " +
" where UA.FUGID in (SELECT UG.FUserGroupID FROM sys_User_Group UG INNER JOIN sys_User U ON UG.FUserID = U.FID WHERE (U.FAccount = '" + account + "') ) and f.fid=" + moduleID.ToString();
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql); //DataProvider.Instance.ExecuteNoQuery(_Loginer.DBName, cmd.SqlCommand);
return(int.Parse(o.ToString()));
}
/// <summary>
/// 删除一个类型
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public bool DeleteCommonType(string code)
{
string sql = "select FIssys from t_CommDataDictType where FDataType=" + code;
object x = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
if (x.ToString() == "1")
{
throw new CustomException("不能删除系统的数据！"); //抛出异常
}
sql = "delete from t_CommDataDictType where FDataType='" + code + "'";
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return(int.Parse(o.ToString()) > 0);
}
/// <summary>
/// 返回表字段的值，根据条件SCon返回sTableName的字段sFieldID的值
/// </summary>
/// <param name="sTableName"></param>
/// <param name="sFieldID"></param>
/// <returns></returns>
public string GetTableFieldValue(string sTableName, string sField, string SCon)
{
string sql = "";
if (_Loginer.DbType == DbAcessTyp.SQLServer)
{
sql = string.Format("SELECT isnull({0},'') FROM {1} where 1=1 " + SCon, sField, sTableName);
}
else
{
sql = string.Format("SELECT nvl({0},'') FROM {1} where 1=1 " + SCon, sField, sTableName);
}
object o = new DataBaseLayer(_Loginer.DBName).GetSingle(sql);
return(o == null?"":o.ToString());
}
/// <summary>
/// 检查用户是否存在
/// </summary>
/// <param name="userid">用户编号</param>
/// <returns></returns>
public bool ExistsUser(string account)
{
string sql = "";
IDbDataParameter[] sPara = new IDbDataParameter[1];
if (_Loginer.DbType == DbAcessTyp.SQLServer)
{
sql = "select count(*) from sys_User where FAccount=@Account";
sPara[0] = DataConverter.GetSqlPara("@Account", DataConverter.SqlTypeToString(SqlDbType.VarChar));
}
else
{
sql = "select count(*) from sys_User where FAccount=:Account";
sPara[0] = DataConverter.GetOraclePara("Account", DataConverter.SqlTypeToString(SqlDbType.VarChar));
}
sPara[0].Value = account;
object o = new DataBaseLayer(_Loginer.DBName).GetSingle(sql, sPara);
return(int.Parse(o.ToString()) > 0);
}
public int GetMenuShow(string account, int moduleID)
{
string sql = "SELECT FIsShow FROM sys_UG_Auth_Menu WHERE (FUserType = 1) AND (FUGID = '" + account + "') AND (FMainInterfacesID = '" + moduleID.ToString() + "')";
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql); //DataProvider.Instance.ExecuteNoQuery(_Loginer.DBName, cmd.SqlCommand);
return int.Parse(o.ToString());
}
public bool ModifyPwdDirect(string account, string pwd, string DBName)
{
string sql = "update sys_User set Fpassword='******' where Faccount='" + account + "'";
object o = new DataBaseLayer(DBName).ExecuteSql(sql); //DataProvider.Instance.ExecuteNoQuery(DBName, cmd.SqlCommand);
return int.Parse(o.ToString()) != 0;
}
/// <summary>
/// 检查用户是否存在
/// </summary>
/// <param name="userid">用户编号</param>
/// <returns></returns>
public bool ExistsUser(string account)
{
string sql = "";
IDbDataParameter[] sPara = new IDbDataParameter[1];
if (_Loginer.DbType == DbAcessTyp.SQLServer)
{
sql = "select count(*) from sys_User where FAccount=@Account";
sPara[0] = DataConverter.GetSqlPara("@Account", DataConverter.SqlTypeToString(SqlDbType.VarChar));
}
else
{
sql = "select count(*) from sys_User where FAccount=:Account";
sPara[0] = DataConverter.GetOraclePara("Account", DataConverter.SqlTypeToString(SqlDbType.VarChar));
}
sPara[0].Value = account;
object o = new DataBaseLayer(_Loginer.DBName).GetSingle(sql, sPara);
return int.Parse(o.ToString()) > 0;
}
public bool IsExistsItemClass(string FNumber)
{
string sql = "select count(*) from t_ItemClass where FNumber='" + FNumber + "'";
object x = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql);
return int.Parse(x.ToString()) > 0;
}
/// <summary>
/// 返回表字段的值，根据条件SCon返回sTableName的字段sFieldID的值
/// </summary>
/// <param name="sTableName"></param>
/// <param name="sFieldID"></param>
/// <returns></returns>
public string GetTableFieldValue(string sTableName, string sField,string SCon)
{
string sql="";
if (_Loginer.DbType == DbAcessTyp.SQLServer)
sql = string.Format("SELECT isnull({0},'') FROM {1} where 1=1 " + SCon, sField, sTableName);
else
sql = string.Format("SELECT nvl({0},'') FROM {1} where 1=1 " + SCon, sField, sTableName);
object o=new DataBaseLayer(_Loginer.DBName).GetSingle(sql);
return o==null?"":o.ToString();
}
/// <summary>
/// 获取窗体的可用权限值
/// </summary>
/// <param name="account"></param>
/// <param name="moduleID"></param>
/// <returns></returns>
public int GetFormAuthority(string account, int moduleID)
{
string sql = "SELECT UA.FAuths FROM sys_UG_Auth UA INNER JOIN sys_UserGroup U ON UA.FUGID = U.FID INNER JOIN sys_Function F ON UA.FunctionID = F.FID " +
" where UA.FUGID in (SELECT UG.FUserGroupID FROM sys_User_Group UG INNER JOIN sys_User U ON UG.FUserID = U.FID WHERE (U.FAccount = '" + account + "') ) and f.fid=" + moduleID.ToString();
object o = new DataBaseLayer(_Loginer.DBName).ExecuteSql(sql); //DataProvider.Instance.ExecuteNoQuery(_Loginer.DBName, cmd.SqlCommand);
return int.Parse(o.ToString()) ;
}
