public static T SelectOne <T>(string tableName, string fields, string condition, params SqlParameter[] sqlParams)
{
if (string.IsNullOrEmpty(tableName))
{
throw new ArgumentNullException("tableName");
}
condition = condition.Trim();
if (!string.IsNullOrEmpty(condition) && !condition.StartsWith("WHERE", true, null))
{
condition = "WHERE " + condition;
}
fields = fields.Trim();
if (string.IsNullOrEmpty(fields))
{
fields = "*";
}
string commandText = "SELECT " + fields + " FROM [" + tableName + "] " + condition;
using (DataSet set = DataBase.ExecuteDataset(CommandType.Text, commandText, sqlParams))
{
if ((set.Tables.Count < 1) || (set.Tables[0].Rows.Count < 1))
{
return(default(T));
}
return(DataBinding.LoadFromDataRow <T>(set.Tables[0].Rows[0]));
}
}
