public static DataTable ExecuteSql(SqlTransaction t, InfiChess tableName, string sql, params object[] vals)
{
DataSet ds = SqlHelper.ExecuteSql(t, sql, vals);
DataTable table = null;
if (ds.Tables.Count != 0)
{
table = ds.Tables[0];
table.TableName = tableName.ToString();
}
return(table);
}
public static string ToSql(InfiChess tableName, string filter)
{
return(ToSql(ToSelectAll(tableName), filter));
}
public static string ToSelect(InfiChess tableName, params object[] whereColVals)
{
return(ToSelect(tableName.ToString(), whereColVals));
}
public static string ToSelectAll(InfiChess tableName)
{
return(ToSelectAll(tableName.ToString()));
}
public static DataTable Select(InfiChess tableName, int id)
{
return(Select(tableName, tableName.ToString() + "ID", id));
}
public static DataTable Select(InfiChess tableName)
{
return(Select(tableName.ToString()));
}
public static void Delete(InfiChess tableName, params object[] whereColVals)
{
ExecuteSql(UData.ToDelete(tableName.ToString(), whereColVals));
}
public static void Delete(InfiChess tableName, int id)
{
ExecuteSql(UData.ToDelete(tableName.ToString(), tableName.ToString() + "ID", id));
}
public static DataTable ExecuteSql(InfiChess tableName, string sql, params object[] vals)
{
return(ExecuteSql(tableName.ToString(), sql, vals));
}
public static DataTable ExecuteSql(InfiChess tableName, string sql, SqlParameter[] commandParameters)
{
return(ExecuteSql(tableName.ToString(), sql, commandParameters));
}
public static TC SelectItems2(InfiChess tableName, string sql, params object[] vals)
{
return(SelectItems2(tableName.ToString(), sql, vals));
}
public static TC SelectItems(InfiChess tableName, string sql)
{
TC items = SelectItems(tableName.ToString(), sql);
return(items);
}
public static TC SelectItems(InfiChess tableName, params object[] whereColVals)
{
string s = UData.ToSelect(tableName, whereColVals);
return(SelectItems(tableName.ToString(), s));
}
public static T SelectItem(InfiChess tableName, params object[] whereColVals)
{
TC items = SelectItems(tableName, whereColVals);
return(items.First);
}
public static T SelectItem(InfiChess tableName, int id)
{
return(SelectItem(tableName, tableName.ToString() + "ID", id));
}
