/// <summary>
/// 根据唯一ID获取对象,返回Hashtable
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="pkName">字段主键</param>
/// <param name="pkVal">字段值</param>
/// <returns>返回Hashtable</returns>
public Hashtable GetHashtableById(string tableName, string pkName, string pkVal)
{
this.GetInstance();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM ").Append(tableName).Append(" Where ").Append(pkName).Append("=" + DbCommon.ParamKey + "ID");
return(DbCommon.DataTableToHashtable(db.GetDataTableBySQL(sb, new SqlParam[] { new SqlParam("" + DbCommon.ParamKey + "ID", pkVal) })));
}
/// <summary>
/// 根据唯一ID获取对象,返回Hashtable
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="where">条件</param>
/// <param name="param">参数化</param>
/// <returns>返回Hashtable</returns>
public Hashtable GetHashtableById(string tableName, StringBuilder where, SqlParam[] param)
{
this.GetInstance();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM " + tableName + " WHERE 1=1");
strSql.Append(where);
return(DbCommon.DataTableToHashtable(db.GetDataTableBySQL(strSql, param)));
}
/// <summary>
/// 根据唯一ID获取对象,返回Hashtable
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="ht">参数</param>
/// <returns>返回Hashtable</returns>
public Hashtable GetHashtableById(string tableName, Hashtable ht)
{
this.GetInstance();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM " + tableName + " WHERE 1=1");
foreach (string key in ht.Keys)
{
strSql.Append(" AND " + key + " = " + DbCommon.ParamKey + "" + key + "");
}
return(DbCommon.DataTableToHashtable(db.GetDataTableBySQL(strSql, DbCommon.GetParameter(ht))));
}
