public static DataTable GetTable(string servername, string databasename, string userid, string password)
{
using (IDbProvider provider = new SqlProvider())
{
if (string.IsNullOrEmpty(userid) && string.IsNullOrEmpty(password))
{
provider.ConnectionString = "server=" + servername + ";database=" + databasename + ";Integrated Security=true";
}
else
{
provider.ConnectionString = "server=" + servername + ";database=" + databasename + ";uid=" + userid + ";pwd=" + password;
}
IBaseHelper baseHelper = new BaseHelper();
string sql = "select name from sysobjects where type='U'";
return(baseHelper.ExecuteTable(provider, sql));
}
}
/// <summary>
/// 根据表名查询列表
/// </summary>
/// <param name="iTop">返回个数 ：0 全部返回</param>
/// <param name="fieldShow">表名</param>
/// <param name="strTableName">条件</param>
/// <param name="component">排序</param>
/// <returns></returns>
public DataTable GetListTop(int iTop, string fieldShow, string strTableName, ConditionComponent component)
{
string strWhere = " 1=1 ";
if (iTop > 0)
{
strWhere += " and rownum<=" + iTop.ToString();
}
if (component != null && component.sbComponent.Length > 0)
{
strWhere += " and " + component.sbComponent.ToString();
}
//string sql = Factory.CreateQuerySql(typeof(T), strWhere);
if (strOrderString != null && strOrderString.Trim() != "")
{
strWhere = strWhere + " order by " + strOrderString;
}
return(BaseHelper.ExecuteTable(string.Format(" select {2} from {0} where {1}",
strTableName, strWhere, fieldShow)));
}
/// <summary>
/// 根据表名查询列表（分页）
/// </summary>
/// <param name="strTableName">返回个数 ：0 全部返回</param>
/// <param name="fieldShow">表名</param>
/// <param name="pageSize">条件</param>
/// <param name="currentPageIndex">表名</param>
/// <param name="intCountPage">表名</param>
/// <param name="component">表名</param>
/// <param name="isDel">表名</param>
/// <returns></returns>
public DataTable GetList(string strTableName, string fieldShow, int pageSize,
int currentPageIndex, int intCountPage, ConditionComponent component, int isDel)
{
StringBuilder sbSQL = new StringBuilder();
sbSQL.Append(" select ");
sbSQL.Append(fieldShow);
sbSQL.Append(" from ");
sbSQL.Append(strTableName);
if (component != null && component.sbComponent.Length > 0)
{
sbSQL.Append(" where ");
sbSQL.Append(component.sbComponent.ToString());
}
intRowCount_ = int.Parse(BaseHelper.ExecuteScalar(sbSQL.ToString().Replace(fieldShow, "count(*)")).ToString());
intPageNum_ = pageSize;
string strSql = Factory.CreatePageSql(pageSize, currentPageIndex, intCountPage, sbSQL.ToString(), isDel);
return(BaseHelper.ExecuteTable(strSql));
}
public DataTable ExecuteSqlDatatable(string sql)
{
return(BaseHelper.ExecuteTable(sql));
}
