public static int CustomerExecuteNonQuery(string dbName, string sql, Dictionary <string, CustomerParam> paras, IDictionary hints = null, bool isWrite = true) { var baseDao = DaoCache.GetOrAdd(dbName, BaseDaoFactory.CreateBaseDao(dbName)); var dic = ConvertStatement(paras); if (dic != null && dic.Count > 0) { if (hints != null && hints.Count > 0) { return(baseDao.ExecNonQuery(sql, dic, hints, isWrite)); } return(baseDao.ExecNonQuery(sql, dic, isWrite)); } if (hints != null && hints.Count > 0) { return(baseDao.ExecNonQuery(sql, null, hints, isWrite)); } return(baseDao.ExecNonQuery(sql, isWrite)); }
public static IList <IDataReader> CustomerExecuteQuery(string dbName, string sql, Dictionary <string, CustomerParam> paras, IDictionary hints = null, bool isWrite = false) { var baseDao = DaoCache.GetOrAdd(dbName, BaseDaoFactory.CreateBaseDao(dbName)); var isNonQuery = false; var dic = ConvertStatement(paras, out isNonQuery); if (dic != null && dic.Count > 0) { if (hints != null && hints.Count > 0) { return(baseDao.SelectDataReader(sql, dic, hints, isWrite)); } return(baseDao.SelectDataReader(sql, dic, isWrite)); } if (hints != null && hints.Count > 0) { return(baseDao.SelectDataReader(sql, null, hints, isWrite)); } return(baseDao.SelectDataReader(sql, isWrite)); }
public static object CustomerExecuteScalar(string dbName, string sql, Dictionary <string, CustomerParam> paras, IDictionary hints = null, bool isWrite = false) { var baseDao = DaoCache.GetOrAdd(dbName, BaseDaoFactory.CreateBaseDao(dbName)); var isNonQuery = false; var dic = ConvertStatement(paras, out isNonQuery); if (dic != null && dic.Count > 0) { if (hints != null && hints.Count > 0) { if (isNonQuery) { baseDao.ExecNonQuery(sql, dic, hints, isWrite); var rq = dic.First(r => r.Direction.Equals(ParameterDirection.Output)); return(rq.Value); } else { return(baseDao.ExecScalar(sql, dic, hints, isWrite)); } } if (isNonQuery) { baseDao.ExecNonQuery(sql, dic, isWrite); var rq = dic.First(r => r.Direction.Equals(ParameterDirection.Output)); return(rq.Value); } else { return(baseDao.ExecScalar(sql, dic, isWrite)); } } if (hints != null && hints.Count > 0) { return(isNonQuery ? baseDao.ExecNonQuery(sql, null, hints, isWrite) : baseDao.ExecScalar(sql, null, hints, isWrite)); } return(isNonQuery ? baseDao.ExecNonQuery(sql, isWrite) : baseDao.ExecScalar(sql, isWrite)); }
public static DataTable CustomerExecuteQueryTable(string dbName, string sql, Dictionary <string, CustomerParam> paras, IDictionary hints = null, bool isWrite = false) { #if !NETSTANDARD var baseDao = DaoCache.GetOrAdd(dbName, BaseDaoFactory.CreateBaseDao(dbName)); var isNonQuery = false; var dic = ConvertStatement(paras, out isNonQuery); if (dic != null && dic.Count > 0) { if (hints != null && hints.Count > 0) { return(baseDao.SelectDataTable(sql, dic, hints, isWrite)); } return(baseDao.SelectDataTable(sql, dic, isWrite)); } if (hints != null && hints.Count > 0) { return(baseDao.SelectDataTable(sql, null, hints, isWrite)); } return(baseDao.SelectDataTable(sql, isWrite)); #else throw new NotSupportedException("not support in dotnet core"); #endif }
/// <summary> /// 开启事物 /// </summary> /// <param name="dbName"></param> /// <param name="hints"></param> /// <returns></returns> public static DataConnectionTransaction CustomerBeginTransaction(string dbName, IDictionary hints = null) { var baseDao = DaoCache.GetOrAdd(dbName, BaseDaoFactory.CreateBaseDao(dbName)); return(baseDao.BeginTransaction(hints)); }