/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/18 16:58:57</remarks> public bool Update(AllDatabaseEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_AllDatabase_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx); database.AddInParameter(commandWrapper, "@ZoneName", DbType.AnsiString, entity.ZoneName); database.AddInParameter(commandWrapper, "@DBType", DbType.AnsiString, entity.DBType); database.AddInParameter(commandWrapper, "@DBServerName", DbType.AnsiString, entity.DBServerName); database.AddInParameter(commandWrapper, "@DBName", DbType.AnsiString, entity.DBName); database.AddInParameter(commandWrapper, "@UserId", DbType.AnsiString, entity.UserId); database.AddInParameter(commandWrapper, "@Password", DbType.AnsiString, entity.Password); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Idx = (System.Int32)database.GetParameterValue(commandWrapper, "@Idx"); return(Convert.ToBoolean(results)); }
/// <summary> /// 将IDataReader的当前记录读取到AllDatabaseEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public AllDatabaseEntity LoadSingleRow(IDataReader reader) { var obj = new AllDatabaseEntity(); obj.Idx = (System.Int32)reader["Idx"]; obj.ZoneName = (System.String)reader["ZoneName"]; obj.DBType = (System.String)reader["DBType"]; obj.DBServerName = (System.String)reader["DBServerName"]; obj.DBName = (System.String)reader["DBName"]; obj.UserId = (System.String)reader["UserId"]; obj.Password = (System.String)reader["Password"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>AllDatabaseEntity</returns> /// <remarks>2015/10/18 16:58:57</remarks> public AllDatabaseEntity GetById(System.Int32 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_AllDatabase_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx); AllDatabaseEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
public static bool Update(AllDatabaseEntity allDatabaseEntity, DbTransaction trans = null, string zoneId = "") { var provider = new AllDatabaseProvider(zoneId); return(provider.Update(allDatabaseEntity, trans)); }
private string BuildConnectString(AllDatabaseEntity entity) { return (string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}", entity.DBServerName, entity.DBName, entity.UserId, entity.Password)); }
private string BuildKey(AllDatabaseEntity entity) { return(BuildKey(entity.ZoneName, entity.DBType)); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2015/10/18 16:58:57</remarks> public bool Update(AllDatabaseEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/18 16:58:57</remarks> public bool Insert(AllDatabaseEntity entity) { return(Insert(entity, null)); }