public IDataReader GetDataReader(string sql) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text); return(scm.ExecuteReader(CommandBehavior.CloseConnection)); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLDBOPERATE, sql, this.ToString()); return(null); } }
public IDataReader GetDataReader(string sql, IMyDbParameter[] prams) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text, prams); return(scm.ExecuteReader(CommandBehavior.CloseConnection)); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLPRAMSDBOPERATE, sql, GetParametersInfo(prams), this.ToString()); return(null); } }
private static void CreateTableTypeHandle(Type pType, DataTypeAttribute dataTypeAttribute, ref StringBuilder sql) { if (pType == INTTYPE) { sql.Append(" int "); CreateTableCommSetting(dataTypeAttribute, ref sql); } else if (pType == BOOLTYPE) { sql.Append(" bit "); CreateTableCommSetting(dataTypeAttribute, ref sql); } else if (pType == STRINGTYPE) { CreateTableWithAttributeOfString(dataTypeAttribute, ref sql); } else if (pType == DATETIMETYPE) { sql.Append(" datetime "); CreateTableCommSetting(dataTypeAttribute, ref sql); } else if (pType == DECIMALTYPE) { sql.Append(" decimal "); CreateTableWithAttributeOfDecimal(dataTypeAttribute, ref sql); } else if (pType.IsEnum) { sql.Append(" int "); CreateTableCommSetting(dataTypeAttribute, ref sql); } else if (pType == LONGTYPE) { sql.Append(" bigint "); CreateTableCommSetting(dataTypeAttribute, ref sql); } else if (pType == BYTESTYPE) { sql.Append(" image "); CreateTableCommSetting(dataTypeAttribute, ref sql); } else { LogProxy.ErrorFormat(true, DATATYPEERROR, pType.ToString()); } }
public void RunProcedure(string procName, out IDataReader dataReader) { dataReader = null; try { Open(); SqlCommand scm = CreateCommand(procName, CommandType.StoredProcedure); dataReader = scm.ExecuteReader(CommandBehavior.CloseConnection); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLDBOPERATE, procName, this.ToString()); } }
public int ExecuteNonQuery(string sql) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text); return(scm.ExecuteNonQuery()); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLDBOPERATE, sql, this.ToString()); return(0); } finally { Close(); } }
public int RunProcedure(string procName) { try { Open(); SqlCommand scm = CreateCommand(procName, CommandType.StoredProcedure); return(scm.ExecuteNonQuery()); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLDBOPERATE, procName, this.ToString()); return(0); } finally { Close(); } }
//public void RunProcedure(string procName, IMyDbParameter[] prams, out IDataReader dataReader, out Dictionary<string, object> returnValue) //{ // dataReader = null; // returnValue = null; // try // { // Open(); // SqlCommand scm = CreateCommand(procName, CommandType.StoredProcedure, prams); // dataReader = scm.ExecuteReader(CommandBehavior.CloseConnection); // dataReader.Close(); // FillValueContainer(prams, scm, out returnValue); // } // catch (Exception ex) // { // LogProxy.ErrorFormat(ex, true, SQLPRAMSDBOPERATE, procName, GetParametersInfo(prams), this.ToString()); // } //} public int RunProcedure(string procName, IMyDbParameter[] prams) { try { Open(); SqlCommand scm = CreateCommand(procName, CommandType.StoredProcedure, prams); return(scm.ExecuteNonQuery()); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLPRAMSDBOPERATE, procName, GetParametersInfo(prams), this.ToString()); return(0); } finally { Close(); } }
public void RunProcedure(string procName, out DataSet dataSet) { dataSet = null; try { Open(); SqlCommand scm = CreateCommand(procName, CommandType.StoredProcedure); FillDataSet(out dataSet, scm); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLDBOPERATE, procName, this.ToString()); } finally { Close(); } }
internal static StorageContext GetStorageContext(string name) { if (StorageContexts == null || StorageContexts.Count == 0) { LogProxy.Error(STORAGECONTEXTSISNULL, true); return(null); } if (string.IsNullOrEmpty(name)) { return(DefaultStorageContext); } if (StorageContexts.ContainsKey(name) == false) { LogProxy.ErrorFormat(true, STORAGECONTEXTISNULL, name); return(null); } return(StorageContexts[name]); }
public object ExecuteScalar(string sql) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text); object obj = scm.ExecuteScalar(); return(obj); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLDBOPERATE, sql, this.ToString()); return(null); } finally { Close(); } }
public object ExecuteScalar(string sql, IMyDbParameter[] prams) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text, prams); object obj = scm.ExecuteScalar(); return(obj); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLPRAMSDBOPERATE, sql, GetParametersInfo(prams), this.ToString()); return(null); } finally { Close(); } }
public void RunProcedure(string procName, IMyDbParameter[] prams, out Dictionary <string, object> returnValue) { returnValue = null; try { Open(); SqlCommand scm = CreateCommand(procName, CommandType.StoredProcedure, prams); scm.ExecuteNonQuery(); FillValueContainer(prams, scm, out returnValue); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLPRAMSDBOPERATE, procName, GetParametersInfo(prams), this.ToString()); } finally { Close(); } }
public int ExecuteNonQuery(string sql, IMyDbParameter[] prams) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text, prams); int i = scm.ExecuteNonQuery(); scm.Parameters.Clear(); return(i); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLPRAMSDBOPERATE, sql, GetParametersInfo(prams), this.ToString()); return(0); } finally { Close(); } }
public DataSet GetDataSet(string sql, IMyDbParameter[] prams) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text, prams); DataSet dataSet; FillDataSet(out dataSet, scm); return(dataSet); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLPRAMSDBOPERATE, sql, GetParametersInfo(prams), this.ToString()); return(null); } finally { Close(); } }
public DataSet GetDataSet(string sql) { try { Open(); SqlCommand scm = CreateCommand(sql, CommandType.Text); DataSet dataSet; FillDataSet(out dataSet, scm); return(dataSet); } catch (Exception ex) { LogProxy.ErrorFormat(ex, true, SQLDBOPERATE, sql, this.ToString()); return(null); } finally { Close(); } }
public static IDbOperate Create(string alias, Type type) { StorageContext storageContext = MappingService.GetStorageContext(alias, type); if (storageContext == null) { LogProxy.ErrorFormat(true, GETSTORAGECONTEXTNULL, type.FullName, alias); return(null); } if (storageContext.Enabled == false) { LogProxy.ErrorFormat(true, STORAGECONTEXTUNABLED, storageContext.Name); return(null); } DbProxy proxy = new DbProxy(alias, type); proxy.Context = storageContext; proxy.DbServer = new SQLServer(storageContext); proxy.DbServer.Alias = proxy.Alias; proxy.DbServer.ObjType = proxy.ObjType; return(proxy); }
private static IMyDbParameter ParameterBuilder(IMyPropertyInfo property, object pValue) { #region 构造 IMyDbParameter 开始 Type pType = property.PropertyType; if (pType == INTTYPE) { return(DbParameterProxy.Create(property.Name, SqlDbType.Int, pValue)); } else if (pType == BOOLTYPE) { return(DbParameterProxy.Create(property.Name, SqlDbType.Bit, pValue)); } else if (pType == STRINGTYPE) { if (property.StringDataType.Type == StringType.NVarchar) { if (property.StringDataType.IsMaxLength) { return(DbParameterProxy.Create(property.Name, SqlDbType.NVarChar, pValue)); } else { string val = pValue as string; if (!string.IsNullOrEmpty(val) && val.Length > property.StringDataType.Length) { LogProxy.Error(string.Format(LENGTHGAUGE, property.Name, val), true); } return(DbParameterProxy.Create(property.Name, SqlDbType.NVarChar, property.StringDataType.Length, pValue)); } } else { return(DbParameterProxy.Create(property.Name, SqlDbType.NText, pValue)); } } else if (pType == DATETIMETYPE) { if ((DateTime)pValue == DateTime.MinValue) { return(DbParameterProxy.Create(property.Name, SqlDbType.DateTime, DBNull.Value)); } else { return(DbParameterProxy.Create(property.Name, SqlDbType.DateTime, pValue)); } } else if (pType == DECIMALTYPE) { return(DbParameterProxy.Create(property.Name, SqlDbType.Decimal, pValue)); } else if (pType.IsEnum) { return(DbParameterProxy.Create(property.Name, SqlDbType.Int, (int)pValue)); } else if (pType == LONGTYPE) { return(DbParameterProxy.Create(property.Name, SqlDbType.BigInt, pValue)); } else if (pType == BYTESTYPE) { return(DbParameterProxy.Create(property.Name, SqlDbType.Image, pValue)); } else { LogProxy.ErrorFormat(true, DATATYPEERROR, pType.ToString()); return(null); } #endregion 构造 IMyDbParameter 结束 }