[H2-commits] r1126 - in humano2/branches/datareader: core/db/mssql web/portal/site

[<sv...@de...>]

Author: marcelo
Date: 2005-05-20 20:14:53 -0400 (Fri, 20 May 2005)
New Revision: 1126

Modified:
   humano2/branches/datareader/core/db/mssql/mssqlConnection.cs
   humano2/branches/datareader/core/db/mssql/mssqlCrud.cs
   humano2/branches/datareader/web/portal/site/viewpertinencelist.aspx.cs
Log:
 * Fixed bugs in creating pertinence and simplyfied isPrimary functions

Modified: humano2/branches/datareader/core/db/mssql/mssqlConnection.cs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/branches/datareader/core/db/mssql/mssqlConnection.cs	2005-05-=
20 23:38:39 UTC (rev 1125)
+++ humano2/branches/datareader/core/db/mssql/mssqlConnection.cs	2005-05-=
21 00:14:53 UTC (rev 1126)
@@ -89,6 +89,10 @@
 			SqlConnection conn =3D ( (SqlConnection) dbCon );
 		=09
 			SqlDataAdapter da =3D new SqlDataAdapter(query,conn);
+			if (dbTransRefCount > 0 )
+			{
+				da.SelectCommand.Transaction =3D ( (SqlTransaction) dbTrans) ;
+			}
 			da.Fill(ds);
 			da.Dispose();
 			Close();

Modified: humano2/branches/datareader/core/db/mssql/mssqlCrud.cs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/branches/datareader/core/db/mssql/mssqlCrud.cs	2005-05-20 23:=
38:39 UTC (rev 1125)
+++ humano2/branches/datareader/core/db/mssql/mssqlCrud.cs	2005-05-21 00:=
14:53 UTC (rev 1126)
@@ -1730,7 +1730,7 @@
 		override protected void createAttributeInDatabase(string tableName, st=
ring columnName, string columnType)
 		{
 			//System.Console.WriteLine(Name + " : " + dataType);
-			string sqlCommand =3D String.Format( "alter table {0} add {1} {2}",
+			string sqlCommand =3D String.Format( "alter table {0} add \"{1}\" {2}=
",
 											  tableName, columnName, columnType );
 			conn.doCommand( sqlCommand );
 		}

Modified: humano2/branches/datareader/web/portal/site/viewpertinencelist.=
aspx.cs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/branches/datareader/web/portal/site/viewpertinencelist.aspx.c=
s	2005-05-20 23:38:39 UTC (rev 1125)
+++ humano2/branches/datareader/web/portal/site/viewpertinencelist.aspx.c=
s	2005-05-21 00:14:53 UTC (rev 1126)
@@ -164,7 +164,7 @@
 			//Explicacion de los filtros...
 			//atributo 67|4|'true' =3D> isPrimary=3D'true'
 			//atributo 40|4|idClass =3D> classId=3DidClass
-			dr["filtros"] =3D "67|4|'true'|1|0;40|4|'"+idClass+"'|0|0";
+			dr["filtros"] =3D "67|4|'1'|1|0;40|4|'"+idClass+"'|0|0";
 		=09
 			dtParam.Rows.Add(dr);
=20