public static string GetCode(int num)
{
return(DBH.GetString(QA.DBCS_STATIC, CommandType.Text, "SELECT code FROM uid WHERE id=@id", new SqlParameter("@id", num)));
}
public static string GetSetting(string name)
{
return(DBH.GetString(QA.DBCS_MAIN, CommandType.Text, "SELECT svalue FROM setting WHERE skey=@name", new SqlParameter("@name", name)));
}
internal static string GetFilePhysicalPath(int type, int uid)
{
return(DBH.GetString(QA.DBCS_MAIN, CommandType.Text, "SELECT TOP 1 physicalpath FROM attachment WHERE type=@type AND uid=@uid ORDER BY created DESC", new SqlParameter("@type", type), new SqlParameter("@uid", uid)));
}
internal static string GetUrl(int id)
{
return(DBH.GetString(QA.DBCS_MAIN, CommandType.Text, "SELECT www FROM user_account WHERE id=@id", new SqlParameter("@id", id)));
}
internal static string GetDisplayName(int roleid)
{
return(DBH.GetString(QA.DBCS_MAIN, CommandType.Text, "SELECT displayname FROM role WHERE id=@id", new SqlParameter("@id", roleid)));
}
public static string GetUrl(string tableName, string name)
{
return(DBH.GetString(QA.DBCS_MAIN, CommandType.Text, "SELECT url FROM " + tableName + " WHERE name=@name", new SqlParameter("@name", name)));
}
internal static string GetTemplate(string templateName)
{
return(DBH.GetString(QA.DBCS_MAIN, CommandType.Text, "SELECT tmpl FROM template WHERE name=@name", new SqlParameter("@name", templateName)));
}