/// <summary>
/// 获取数据表
/// </summary>
/// <param name="TargetTable">目标表名</param>
/// <returns>DataTable</returns>
public DataTable GetDataTable(string connectionString, string TargetTable)
{
StringBuilder sql = new StringBuilder();
sql.Append("SELECT * FROM " + TargetTable + "");
return(MySqlHelper.ExecuteDataSet(connectionString, CommandType.Text, null).Tables[0]);
}
/// <summary>
/// 根据唯一ID获取Dictionary<string,string>
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="pkName">字段主键</param>
/// <param name="pkVal">字段值</param>
/// <returns></returns>
public Dictionary <string, string> GetHashtableById(string connectionString, string tableName, string pkName, string pkVal)
{
StringBuilder sb = new StringBuilder();
sb.Append("Select * From ").Append(tableName).Append(" Where ").Append(pkName).Append("=?ID");
DataTable dt = MySqlHelper.ExecuteDataSet(connectionString, CommandType.Text, sb.ToString(), new MySqlParameter[] { new MySqlParameter("?ID", pkVal) }).Tables[0];
return(DataTableHelper.DataTableToHashtable(dt));
}