public static DisplayObject_MCE_B_ASSETS_CHECK_TYPE[] Query(CauseObject_MCE_B_ASSETS_CHECK_TYPE cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_CHECK_TYPE.TYPE_ID, MCE_B_ASSETS_CHECK_TYPE.BASE_ID, MCE_B_ASSETS_CHECK_TYPE.ID, MCE_D_MCE_TYPE_TYPE_ID.NAME as TYPE_ID_NAME from MCE_B_ASSETS_CHECK_TYPE left join MCE_D_MCE_TYPE MCE_D_MCE_TYPE_TYPE_ID on MCE_B_ASSETS_CHECK_TYPE.TYPE_ID = MCE_D_MCE_TYPE_TYPE_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_CHECK_TYPE", 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_CHECK_TYPE dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_CHECK_TYPE();
if (!sqlReader.IsDBNull(0))
{
dataObj.TYPE_ID = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.ID = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.TYPE_ID_NAME = sqlReader.GetString(3);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_CHECK_TYPE[] objs = new DisplayObject_MCE_B_ASSETS_CHECK_TYPE[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static DisplayObject_MCE_B_ASSETS_MT_APPLY_EN[] Query(CauseObject_MCE_B_ASSETS_MT_APPLY_EN cause, PagingParamter paging, OrderByParameter order)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_MT_APPLY_EN.ADVISE, MCE_B_ASSETS_MT_APPLY_EN.BASE_ID, MCE_B_ASSETS_MT_APPLY_EN.RESULT, MCE_B_ASSETS_MT_APPLY_EN.COMMENTS, MCE_B_ASSETS_MT_APPLY_EN.USER_ID, MCE_B_ASSETS_MT_APPLY_EN.COMPLETE_TIME, MCE_B_ASSETS_MT_APPLY_EN.ID, MCE_B_ASSETS_MT_APPLY_EN.HOURS, MCE_B_ASSETS_MT_APPLY_EN.IS_CLOSE, MCE_B_ASSETS_MT_APPLY_BASE_ID.CODE as BASE_ID_NAME, COM_USER_USER_ID.NAME as USER_ID_NAME from MCE_B_ASSETS_MT_APPLY_EN left join MCE_B_ASSETS_MT_APPLY MCE_B_ASSETS_MT_APPLY_BASE_ID on MCE_B_ASSETS_MT_APPLY_EN.BASE_ID = MCE_B_ASSETS_MT_APPLY_BASE_ID.ID left join COM_USER COM_USER_USER_ID on MCE_B_ASSETS_MT_APPLY_EN.USER_ID = COM_USER_USER_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
IDbConnection connection = IDALProvider.IDAL.PopConnection();
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 ? (int)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, connection) : (int)(decimal)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, connection);
}
sqlReader = IDALProvider.IDAL.ExecutePagingReader("MCE_B_ASSETS_MT_APPLY_EN", paging, order, sSql, parameters, connection);
}
else if (order != null)
{
sSql += order.ToString();
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
}
else
{
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
}
DisplayObject_MCE_B_ASSETS_MT_APPLY_EN dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_MT_APPLY_EN();
if (!sqlReader.IsDBNull(0))
{
dataObj.ADVISE = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.RESULT = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.COMMENTS = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.USER_ID = sqlReader.GetString(4);
}
if (!sqlReader.IsDBNull(5))
{
dataObj.COMPLETE_TIME = sqlReader.GetDateTime(5);
}
if (!sqlReader.IsDBNull(6))
{
dataObj.ID = sqlReader.GetString(6);
}
if (!sqlReader.IsDBNull(7))
{
dataObj.HOURS = sqlReader.GetDecimal(7);
}
if (!sqlReader.IsDBNull(8))
{
dataObj.IS_CLOSE = sqlReader.GetDecimal(8);
}
if (!sqlReader.IsDBNull(9))
{
dataObj.BASE_ID_NAME = sqlReader.GetString(9);
}
if (!sqlReader.IsDBNull(10))
{
dataObj.USER_ID_NAME = sqlReader.GetString(10);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
DisplayObject_MCE_B_ASSETS_MT_APPLY_EN[] objs = new DisplayObject_MCE_B_ASSETS_MT_APPLY_EN[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] Query(CauseObject_MCE_B_ASSETS_CONTRACT_PAY cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_CONTRACT_PAY.PERIODS, MCE_B_ASSETS_CONTRACT_PAY.BASE_ID, MCE_B_ASSETS_CONTRACT_PAY.PLAN_PAY_DATE, MCE_B_ASSETS_CONTRACT_PAY.COMMENTS, MCE_B_ASSETS_CONTRACT_PAY.STATE, MCE_B_ASSETS_CONTRACT_PAY.MONEY, MCE_B_ASSETS_CONTRACT_PAY.ID, MCE_B_ASSETS_CONTRACT_PAY.ACTUAL_PAY_DATE, MCE_B_ASSETS_CONTRACT_BASE_ID.NAME as BASE_ID_NAME, (case when MCE_B_ASSETS_CONTRACT_PAY.STATE = 1 then '已付款' when MCE_B_ASSETS_CONTRACT_PAY.STATE = 2 then '未付款' else '' end ) as STATE_NAME from MCE_B_ASSETS_CONTRACT_PAY left join MCE_B_ASSETS_CONTRACT MCE_B_ASSETS_CONTRACT_BASE_ID on MCE_B_ASSETS_CONTRACT_PAY.BASE_ID = MCE_B_ASSETS_CONTRACT_BASE_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_CONTRACT_PAY", 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_CONTRACT_PAY dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_CONTRACT_PAY();
if (!sqlReader.IsDBNull(0))
{
dataObj.PERIODS = sqlReader.GetDecimal(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.PLAN_PAY_DATE = sqlReader.GetDateTime(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.COMMENTS = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.STATE = sqlReader.GetDecimal(4);
}
if (!sqlReader.IsDBNull(5))
{
dataObj.MONEY = sqlReader.GetDecimal(5);
}
if (!sqlReader.IsDBNull(6))
{
dataObj.ID = sqlReader.GetString(6);
}
if (!sqlReader.IsDBNull(7))
{
dataObj.ACTUAL_PAY_DATE = sqlReader.GetDateTime(7);
}
if (!sqlReader.IsDBNull(8))
{
dataObj.BASE_ID_NAME = sqlReader.GetString(8);
}
if (!sqlReader.IsDBNull(9))
{
dataObj.STATE_NAME = sqlReader.GetString(9);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] objs = new DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static DisplayObject_V_MCE_ASSET_OUTSTOCK_BACK[] Query(CauseObject_V_MCE_ASSET_OUTSTOCK_BACK cause, PagingParamter paging, OrderByParameter order)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select V_MCE_ASSET_OUTSTOCK_BACK.ASSETS_CODE, V_MCE_ASSET_OUTSTOCK_BACK.BASE_ID, V_MCE_ASSET_OUTSTOCK_BACK.CARD_CODE, V_MCE_ASSET_OUTSTOCK_BACK.OUT_D_ID, V_MCE_ASSET_OUTSTOCK_BACK.SPEC, V_MCE_ASSET_OUTSTOCK_BACK.ID, V_MCE_ASSET_OUTSTOCK_BACK.ASSETS_NAME from V_MCE_ASSET_OUTSTOCK_BACK 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
IDbConnection connection = IDALProvider.IDAL.PopConnection();
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 ? (int)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, connection) : (int)(decimal)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, connection);
}
sqlReader = IDALProvider.IDAL.ExecutePagingReader("V_MCE_ASSET_OUTSTOCK_BACK", paging, order, sSql, parameters, connection);
}
else if (order != null)
{
sSql += order.ToString();
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
}
else
{
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
}
DisplayObject_V_MCE_ASSET_OUTSTOCK_BACK dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_V_MCE_ASSET_OUTSTOCK_BACK();
if (!sqlReader.IsDBNull(0))
{
dataObj.ASSETS_CODE = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.CARD_CODE = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.OUT_D_ID = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.SPEC = sqlReader.GetString(4);
}
if (!sqlReader.IsDBNull(5))
{
dataObj.ID = sqlReader.GetString(5);
}
if (!sqlReader.IsDBNull(6))
{
dataObj.ASSETS_NAME = sqlReader.GetString(6);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
DisplayObject_V_MCE_ASSET_OUTSTOCK_BACK[] objs = new DisplayObject_V_MCE_ASSET_OUTSTOCK_BACK[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
