|
From: <sv...@de...> - 2005-05-21 20:02:22
|
Author: marcelo
Date: 2005-05-21 16:02:10 -0400 (Sat, 21 May 2005)
New Revision: 1127
Modified:
humano2/branches/datareader/core/db/pgsql/pgsqlComplex.cs
Log:
* changes in pgsql/pgsqlComplex.cs to make merge less painfull
Modified: humano2/branches/datareader/core/db/pgsql/pgsqlComplex.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/pgsql/pgsqlComplex.cs 2005-05-21 =
00:14:53 UTC (rev 1126)
+++ humano2/branches/datareader/core/db/pgsql/pgsqlComplex.cs 2005-05-21 =
20:02:10 UTC (rev 1127)
@@ -16,12 +16,12 @@
using System.Data;
using System.Text;
=20
-
-
namespace Humano2.Core.Db {
public class pgsqlComplex: absComplex
{
+
public pgsqlComplex(Core c):base(c) { }
+
/// <summary>
/// Entrega un DataTable con los atributos de una clase
/// </summary>
@@ -71,7 +71,7 @@
return res;
}
=20
- public override DataTable getColsforView(int classId)
+ public override DataTable getColsforView(int classId)
{
string query =3D @"select ""id_entity"", ""columns"" from ""view"" wh=
ere ""idClassView"" =3D "+classId+" order by id_entity limit 1";
return doSelect(query);
@@ -98,6 +98,7 @@
return res; =09
}
=09
+
/// <summary>
/// Cambia variables de una clase.
/// </summary>
@@ -610,6 +611,7 @@
{
string query =3D String.Format("select * from \"{0}\" x, entity e whe=
re \"{1}\" =3D {2} and x.id_entity =3D e.id_entity and e.\"delDate\" is n=
ull", tableSysName,
colSysName, valor); =09
+
return doSelect(query);
}
=09
@@ -737,6 +739,7 @@
conn.doCommand(sql);
}
=20
+
/// <summary>
/// Method dumpImportTable
/// </summary>
@@ -953,7 +956,6 @@
=20
return isPrimary;
}
-
override public bool IsSelfLookUp(string sysAttName)
{
string req =3D "select \"isSelfLookup\" from attribute where \"sysAtt=
Name\" =3D '" + sysAttName + "'";
@@ -973,7 +975,6 @@
=20
return IsSelfLookUp;
} =20
-
/// <summary>
/// Get the params (where, orderby etc...) of a view
/// </summary>
@@ -981,6 +982,7 @@
/// <return>params of view in a array</returns>
override public string [] GetParamsView(int id)
{ =20
+
string idStr =3D Convert.ToString(id);
string req =3D "select \"groupby\", \"columns\",\"where\",\"=
order\" from view where id_entity=3D" + idStr;
string [] res =3D new string[4];
@@ -1001,6 +1003,7 @@
return res;
}
=20
+
/// <summary>
/// Get the params (where, orderby etc...) of a report
/// </summary>
@@ -1147,6 +1150,7 @@
=20
public override int ConvertSysAttNameToIdAttName(string sysAttName)
{ =09
+
string req =3D "select \"id_entity\" from attribute where \"sysAttNam=
e\" =3D '" + sysAttName +"'";
int res =3D -1;
DataTable dt =3D doSelect(req);
@@ -1159,6 +1163,7 @@
Logger.Log("ConvertSysAttName: there is no userAttName for sysAttNam=
e: " + sysAttName,LogLevel.Trace);
}
return res; =09
+
}
=20
}
|