public DisplayObject_MCE_B_ASSETS_FILETEMPLATE Get(DisplayObject_MCE_B_ASSETS_FILETEMPLATE obj)
{
if (LocalMode)
{
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_FILETEMPLATE.Get(obj));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_FILETEMPLATE> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_FILETEMPLATE>(ServiceUri))
{
return(smgr.Service.Get(obj));
}
}
}
public static DisplayObject_MCE_B_ASSETS_FILETEMPLATE Get(DisplayObject_MCE_B_ASSETS_FILETEMPLATE obj)
{
//平台自动生成代码
string sSql = " select MCE_B_ASSETS_FILETEMPLATE.COMMENTS, MCE_B_ASSETS_FILETEMPLATE.ID, MCE_B_ASSETS_FILETEMPLATE.NAME from MCE_B_ASSETS_FILETEMPLATE where (1=1) and MCE_B_ASSETS_FILETEMPLATE.ID = :ID ";
#region Parameters Block
OracleParameter[] parameters = new OracleParameter[1];
parameters[0] = new OracleParameter();
parameters[0].ParameterName = ":ID";
parameters[0].Size = 36;
parameters[0].OracleType = System.Data.OracleClient.OracleType.Char;
parameters[0].Value = obj.ID;
#endregion
#region Push Block
DisplayObject_MCE_B_ASSETS_FILETEMPLATE dataObj = null;
ArrayList objArray = new ArrayList();
IDbConnection connection = IDALProvider.IDAL.PopConnection();
IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE();
if (!sqlReader.IsDBNull(0))
{
dataObj.COMMENTS = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.NAME = sqlReader.GetString(2);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
DisplayObject_MCE_B_ASSETS_FILETEMPLATE[] objs = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs.Length == 0 ? null : objs[0]);
}
public static DisplayObject_MCE_B_ASSETS_FILETEMPLATE[] Query(CauseObject_MCE_B_ASSETS_FILETEMPLATE cause)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
#endregion
string sSql = " select MCE_B_ASSETS_FILETEMPLATE.COMMENTS, MCE_B_ASSETS_FILETEMPLATE.ID, MCE_B_ASSETS_FILETEMPLATE.NAME from MCE_B_ASSETS_FILETEMPLATE where (1=1)";
sSql += PrepareCause(cause, out parameters);
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
sSql = "select t.* from (" + sSql + ") t,( select t." + cause.Recursion.TargetKeyFieldName + " from " + cause.Recursion.TargetDataObjectName + " t start with t." + cause.Recursion.TargetKeyFieldName + " = '" + cause.Recursion.RecursionFieldValue + "' connect by t." + cause.Recursion.TargetLevelFieldName + " = PRIOR t." + cause.Recursion.TargetKeyFieldName + " ) t1 where t." + cause.Recursion.RecursionFieldName + " = t1." + cause.Recursion.TargetKeyFieldName;
}
#region Push Block
DisplayObject_MCE_B_ASSETS_FILETEMPLATE dataObj = null;
ArrayList objArray = new ArrayList();
IDbConnection connection = IDALProvider.IDAL.PopConnection();
IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE();
if (!sqlReader.IsDBNull(0))
{
dataObj.COMMENTS = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.NAME = sqlReader.GetString(2);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
DisplayObject_MCE_B_ASSETS_FILETEMPLATE[] objs = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static DisplayObject_MCE_B_ASSETS_FILETEMPLATE[] List()
{
//平台自动生成代码
string sSql = " select MCE_B_ASSETS_FILETEMPLATE.COMMENTS, MCE_B_ASSETS_FILETEMPLATE.ID, MCE_B_ASSETS_FILETEMPLATE.NAME from MCE_B_ASSETS_FILETEMPLATE where (1=1)";
#region Parameters Block
OracleParameter[] parameters = new OracleParameter[0];
#endregion
#region Push Block
DisplayObject_MCE_B_ASSETS_FILETEMPLATE dataObj = null;
ArrayList objArray = new ArrayList();
IDbConnection connection = IDALProvider.IDAL.PopConnection();
IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE();
if (!sqlReader.IsDBNull(0))
{
dataObj.COMMENTS = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.NAME = sqlReader.GetString(2);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
DisplayObject_MCE_B_ASSETS_FILETEMPLATE[] objs = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static DisplayObject_MCE_B_ASSETS_FILETEMPLATE[] Query(CauseObject_MCE_B_ASSETS_FILETEMPLATE cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_FILETEMPLATE.COMMENTS, MCE_B_ASSETS_FILETEMPLATE.ID, MCE_B_ASSETS_FILETEMPLATE.NAME from MCE_B_ASSETS_FILETEMPLATE where (1=1)";
string sCauseSql = PrepareCause(cause, out parameters);
sSql += sCauseSql;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
sSql = "select t.* from (" + sSql + ") t,( select t." + cause.Recursion.TargetKeyFieldName + " from " + cause.Recursion.TargetDataObjectName + " t start with t." + cause.Recursion.TargetKeyFieldName + " = '" + cause.Recursion.RecursionFieldValue + "' connect by t." + cause.Recursion.TargetLevelFieldName + " = PRIOR t." + cause.Recursion.TargetKeyFieldName + " ) t1 where t." + cause.Recursion.RecursionFieldName + " = t1." + cause.Recursion.TargetKeyFieldName;
}
#region Push Block
if (paging != null)
{
string countSql = string.Empty;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
else
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
if (paging.TotalRecords == 0)
{
paging.TotalRecords = IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.SqlServer || IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.Db2? (int)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans) : (int)(decimal)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans);
}
sqlReader = IDALProvider.IDAL.ExecutePagingReader("MCE_B_ASSETS_FILETEMPLATE", paging, order, sSql, parameters, trans);
}
else if (order != null)
{
sSql += order.ToString();
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
else
{
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
DisplayObject_MCE_B_ASSETS_FILETEMPLATE dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE();
if (!sqlReader.IsDBNull(0))
{
dataObj.COMMENTS = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.NAME = sqlReader.GetString(2);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_FILETEMPLATE[] objs = new DisplayObject_MCE_B_ASSETS_FILETEMPLATE[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
