public static DisplayObject_MCE_B_ASSETS_ROLLEQUIP Get(DisplayObject_MCE_B_ASSETS_ROLLEQUIP obj) { //平台自动生成代码 string sSql = " select MCE_B_ASSETS_ROLLEQUIP.ROLL_ID, MCE_B_ASSETS_ROLLEQUIP.ID, MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID, MCE_B_ASSETS_ROLL_ROLL_ID.NAME as ROLL_ID_NAME, MCE_B_ASSETS_ASSETS_ID.ASSETS_NAME as ASSETS_ID_NAME from MCE_B_ASSETS_ROLLEQUIP left join MCE_B_ASSETS_ROLL MCE_B_ASSETS_ROLL_ROLL_ID on MCE_B_ASSETS_ROLLEQUIP.ROLL_ID = MCE_B_ASSETS_ROLL_ROLL_ID.ID left join MCE_B_ASSETS MCE_B_ASSETS_ASSETS_ID on MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID = MCE_B_ASSETS_ASSETS_ID.ID where (1=1) and MCE_B_ASSETS_ROLLEQUIP.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_ROLLEQUIP 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_ROLLEQUIP(); if (!sqlReader.IsDBNull(0)) { dataObj.ROLL_ID = sqlReader.GetString(0); } if (!sqlReader.IsDBNull(1)) { dataObj.ID = sqlReader.GetString(1); } if (!sqlReader.IsDBNull(2)) { dataObj.ASSETS_ID = sqlReader.GetString(2); } if (!sqlReader.IsDBNull(3)) { dataObj.ROLL_ID_NAME = sqlReader.GetString(3); } if (!sqlReader.IsDBNull(4)) { dataObj.ASSETS_ID_NAME = sqlReader.GetString(4); } objArray.Add(dataObj); } sqlReader.Close(); IDALProvider.IDAL.PushConnection(connection); #endregion DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] objs = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP[objArray.Count]; objArray.CopyTo(0, objs, 0, objs.Length); return(objs.Length == 0 ? null : objs[0]); }
public static DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] Query(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause) { //平台自动生成代码 #region Parameters Block OracleParameter[] parameters = null; #endregion string sSql = " select MCE_B_ASSETS_ROLLEQUIP.ROLL_ID, MCE_B_ASSETS_ROLLEQUIP.ID, MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID, MCE_B_ASSETS_ROLL_ROLL_ID.NAME as ROLL_ID_NAME, MCE_B_ASSETS_ASSETS_ID.ASSETS_NAME as ASSETS_ID_NAME from MCE_B_ASSETS_ROLLEQUIP left join MCE_B_ASSETS_ROLL MCE_B_ASSETS_ROLL_ROLL_ID on MCE_B_ASSETS_ROLLEQUIP.ROLL_ID = MCE_B_ASSETS_ROLL_ROLL_ID.ID left join MCE_B_ASSETS MCE_B_ASSETS_ASSETS_ID on MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID = MCE_B_ASSETS_ASSETS_ID.ID 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_ROLLEQUIP 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_ROLLEQUIP(); if (!sqlReader.IsDBNull(0)) { dataObj.ROLL_ID = sqlReader.GetString(0); } if (!sqlReader.IsDBNull(1)) { dataObj.ID = sqlReader.GetString(1); } if (!sqlReader.IsDBNull(2)) { dataObj.ASSETS_ID = sqlReader.GetString(2); } if (!sqlReader.IsDBNull(3)) { dataObj.ROLL_ID_NAME = sqlReader.GetString(3); } if (!sqlReader.IsDBNull(4)) { dataObj.ASSETS_ID_NAME = sqlReader.GetString(4); } objArray.Add(dataObj); } sqlReader.Close(); IDALProvider.IDAL.PushConnection(connection); #endregion DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] objs = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP[objArray.Count]; objArray.CopyTo(0, objs, 0, objs.Length); return(objs); }
public DisplayObject_MCE_B_ASSETS_ROLLEQUIP Get(DisplayObject_MCE_B_ASSETS_ROLLEQUIP obj) { if (LocalMode) { //平台自动生成代码 return(HelperObject_MCE_B_ASSETS_ROLLEQUIP.Get(obj)); } else { using (ServiceManager <ServiceContract_MCE_B_ASSETS_ROLLEQUIP> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLLEQUIP>(ServiceUri)) { return(smgr.Service.Get(obj)); } } }
public static DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] Query(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans) { //平台自动生成代码 #region Parameters Block OracleParameter[] parameters = null; IDataReader sqlReader = null; #endregion string sSql = " select MCE_B_ASSETS_ROLLEQUIP.ROLL_ID, MCE_B_ASSETS_ROLLEQUIP.ID, MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID, MCE_B_ASSETS_ROLL_ROLL_ID.NAME as ROLL_ID_NAME, MCE_B_ASSETS_ASSETS_ID.ASSETS_NAME as ASSETS_ID_NAME from MCE_B_ASSETS_ROLLEQUIP left join MCE_B_ASSETS_ROLL MCE_B_ASSETS_ROLL_ROLL_ID on MCE_B_ASSETS_ROLLEQUIP.ROLL_ID = MCE_B_ASSETS_ROLL_ROLL_ID.ID left join MCE_B_ASSETS MCE_B_ASSETS_ASSETS_ID on MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID = MCE_B_ASSETS_ASSETS_ID.ID 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_ROLLEQUIP", 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_ROLLEQUIP dataObj = null; ArrayList objArray = new ArrayList(); while (sqlReader.Read()) { dataObj = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP(); if (!sqlReader.IsDBNull(0)) { dataObj.ROLL_ID = sqlReader.GetString(0); } if (!sqlReader.IsDBNull(1)) { dataObj.ID = sqlReader.GetString(1); } if (!sqlReader.IsDBNull(2)) { dataObj.ASSETS_ID = sqlReader.GetString(2); } if (!sqlReader.IsDBNull(3)) { dataObj.ROLL_ID_NAME = sqlReader.GetString(3); } if (!sqlReader.IsDBNull(4)) { dataObj.ASSETS_ID_NAME = sqlReader.GetString(4); } objArray.Add(dataObj); } sqlReader.Close(); #endregion DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] objs = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP[objArray.Count]; objArray.CopyTo(0, objs, 0, objs.Length); return(objs); }