public static DataTable ListDataTable(string sql) { return(DaoBase.getInstance().QueryForDataTable("ExecuteForQuery", new { sql })); }
public static IList <StrObjectDict> SelectAsync(string conn, string sql) { return(DaoBase.getInstance(conn).ExecuteQueryForListAsync <StrObjectDict>("ExecuteForQuery", new { sql })); }
public static DataTable SelectDataTable(string conn, string sql) { return(DaoBase.getInstance(conn).QueryForDataTable("ExecuteForQuery", new { sql })); }
public static IList <StrObjectDict> List2 <T>(IDictionary <string, object> dictionary, string sendNullIsOK) where T : BaseModel, new() { DaoBase arg_1B_0 = DaoBase.getInstance(null); T t = System.Activator.CreateInstance <T>(); return(arg_1B_0.ExecuteQueryForList <StrObjectDict>(t.MAP_LIST2, dictionary)); }
public static IList <T> List <T>(string conn, IDictionary <string, object> dictionary) where T : BaseModel, new() { DaoBase arg_1B_0 = DaoBase.getInstance(conn); T t = System.Activator.CreateInstance <T>(); return(arg_1B_0.ExecuteQueryForList <T>(t.MAP_LIST, dictionary)); }
public static object SelectFirst(string sql) { return(DaoBase.getInstance().ExecuteScalar("ExecuteForQuery", new { sql })); }
public static T LoadSodAsync <T, V>(string mapID, V v) where T : BaseModel, new() { T t = System.Activator.CreateInstance <T>(); T arg_2E_0; if ((arg_2E_0 = DaoBase.getInstance().ExecuteQueryForObjectAsync <T>(mapID, v)) == null) { //arg_2E_0 = t; } return(arg_2E_0); }
public static T Load <T, V>(V v) where T : BaseModel, new() { T t = System.Activator.CreateInstance <T>(); T arg_2E_0; if ((arg_2E_0 = DaoBase.getInstance().ExecuteQueryForObject <T>(t.MAP_LOAD, v)) == null) { //arg_2E_0 = t; } return(arg_2E_0); }
public static string GetSql(string mapid, object obj) { string sql; if (obj is StrObjectDict) { sql = DaoBase.getInstance(null).GetSql(mapid, obj, false); } else { sql = DaoBase.getInstance(null).GetSql(mapid, obj.toStrObjDict(false), false); } return(sql); }
public static int Execute(IList <string> sqls) { List <DBState> list = new List <DBState>(); foreach (string current in sqls) { list.Add(new DBState { Name = "ExecuteNoneQuery", Param = new { sql = current } }); } return(DaoBase.getInstance().Execute(list)); }
public static DBSERVER_TYPE GetDbtype(string conn) { DBSERVER_TYPE result; if (DaoBase.getInstance(conn).GetDbtype().IndexOf("sqlServer") != -1) { result = DBSERVER_TYPE.MSSQL; } else { if (DaoBase.getInstance(conn).GetDbtype().IndexOf("oracle") != -1) { result = DBSERVER_TYPE.ORACLE; } else { result = DBSERVER_TYPE.MSSQL; } } return(result); }
public static object Scalar(string mapId, StrObjectDict obj) { return(DaoBase.getInstance().ExecuteScalar(mapId, obj)); }
public static void ExecuteOracleStoredProcedureWithOutputCursor(string mapid, IDictionary <string, object> dictionary) { DaoBase.getInstance().ExecuteOracleStoredProcedureWithOutputCursor(mapid, dictionary); }
public static DataTable ExecuteMsSqlStoredProcedureWithOutputCursor(string mapid, StrObjectDict dictionary, IDictionary <string, System.Data.ParameterDirection> dict2, out Hashtable ht) { return(DaoBase.getInstance().QueryForDataTable(mapid, dictionary, dictionary, dict2, out ht)); }
public static int ExecuteWithOutTransaction(IEnumerable <DBState> batchStates) { return(DaoBase.getInstance().ExecuteWithTransaction(batchStates)); }
public static int ExecuteWithTransaction(ISqlMapper sqlmapper, IEnumerable <DBState> batchStates) { return(DaoBase.getInstance().ExecuteWithTransaction(sqlmapper, batchStates)); }
public static int Count <T>(object param) where T : BaseModel, new() { T t = System.Activator.CreateInstance <T>(); return(DaoBase.getInstance().ExecuteQueryForObject <int>(t.MAP_COUNT, param)); }
public static DataTable Meta(string conn, IDictionary <string, object> obj) { return(DaoBase.getInstance(conn).QueryForDataTable("PubSql_GetMeta", obj)); }
public static int ExecuteWithOutTransaction(ISqlMapper sqlMap, DBState state) { return(DaoBase.getInstance().Execute(sqlMap, state)); }
public static IList <T> List <T>(IDictionary <string, object> dictionary, int pageNum, int pageSize) where T : BaseModel, new() { T t = System.Activator.CreateInstance <T>(); return(DaoBase.getInstance().GetSqlMap().QueryForList <T>(t.MAP_LIST, dictionary, (pageNum - 1) * pageSize, pageSize)); }
public static IList <StrObjectDict> ListSod(string conn, string mapid, IDictionary <string, object> dictionary) { return(DaoBase.getInstance(conn).ExecuteQueryForList <StrObjectDict>(mapid, dictionary)); }
public static int Execute(string sql) { return(DaoBase.getInstance().Execute(sql)); }
public static void Execute(string conn, string sql) { DaoBase.getInstance(conn).Execute(sql); }
public static ISqlMapper getSqlMap() { return(DaoBase.getInstance().GetSqlMap()); }
public static int Execute(DBState state) { return(DaoBase.getInstance().Execute(state)); }
public static DaoBase GetDbBase() { return(DaoBase.getInstance(null)); }
public static int ExecuteAsync(IEnumerable <DBState> batchStates) { return(DaoBase.getInstance().ExecuteAsync(batchStates)); }
public static int BatchExecuteWithOutTransaction(ISqlMapper sqlMap, IList <string> sqls) { return(DaoBase.getInstance().Execute(sqlMap, sqls, true)); }
public static IList <StrObjectDict> ListSod(string conn, string mapid, IDictionary <string, object> dictionary, int pageNum, int pageSize) { return(DaoBase.getInstance(conn).ExecuteQueryForList <StrObjectDict>(mapid, dictionary, (pageNum - 1) * pageSize, pageSize)); }