public static DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] Query(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
#endregion
string sSql = " select MCE_B_ASSETS_WRITE_OFF_ATTACH.BASE_ID, MCE_B_ASSETS_WRITE_OFF_ATTACH.CREATE_DATE, MCE_B_ASSETS_WRITE_OFF_ATTACH.SAVENAME, MCE_B_ASSETS_WRITE_OFF_ATTACH.USER_ID, MCE_B_ASSETS_WRITE_OFF_ATTACH.FILE_NAME, MCE_B_ASSETS_WRITE_OFF_ATTACH.ID, MCE_B_ASSETS_WRITE_OFF_BASE_ID.CODE as BASE_ID_NAME, COM_USER_USER_ID.NAME as USER_ID_NAME from MCE_B_ASSETS_WRITE_OFF_ATTACH left join MCE_B_ASSETS_WRITE_OFF MCE_B_ASSETS_WRITE_OFF_BASE_ID on MCE_B_ASSETS_WRITE_OFF_ATTACH.BASE_ID = MCE_B_ASSETS_WRITE_OFF_BASE_ID.ID left join COM_USER COM_USER_USER_ID on MCE_B_ASSETS_WRITE_OFF_ATTACH.USER_ID = COM_USER_USER_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_WRITE_OFF_ATTACH dataObj = null;
ArrayList objArray = new ArrayList();
IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
if (!sqlReader.IsDBNull(0))
{
dataObj.BASE_ID = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.CREATE_DATE = sqlReader.GetDateTime(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.SAVENAME = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.USER_ID = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.FILE_NAME = sqlReader.GetString(4);
}
if (!sqlReader.IsDBNull(5))
{
dataObj.ID = sqlReader.GetString(5);
}
if (!sqlReader.IsDBNull(6))
{
dataObj.BASE_ID_NAME = sqlReader.GetString(6);
}
if (!sqlReader.IsDBNull(7))
{
dataObj.USER_ID_NAME = sqlReader.GetString(7);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] objs = new DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static int Delete(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
#endregion
string sSql = "delete from MCE_B_ASSETS_WRITE_OFF_ATTACH where (1=1)";
sSql += PrepareCause(cause, out parameters);
return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans));
}
public int DeleteByTrans2(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, IDbTransaction transaction)
{
if (LocalMode)
{
return(HelperObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Delete(cause, transaction));
//平台自动生成代码
}
else
{
throw new InvalidConstraintException();
}
}
public static int Update(EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH obj, CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
List <OracleParameter> list = new List <OracleParameter>();
OracleParameter[] parameters = null;
#endregion
string sSql = "update MCE_B_ASSETS_WRITE_OFF_ATTACH set ";
sSql += PrepareUpdate(obj, out parameters, false);
list.AddRange(parameters);
sSql += " where 1=1 ";
sSql += PrepareCause(cause, out parameters);
list.AddRange(parameters);
parameters = list.ToArray();
return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans));
}
public DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] Query(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, PagingParamter paging, OrderByParameter order)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditQuery(cause);
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Query(cause, paging, order));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF_ATTACH> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF_ATTACH>(ServiceUri))
{
return(smgr.Service.Query(cause, paging, order));
}
}
}
public BizLogicMsg Delete(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
int amount = HelperObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Delete(cause, transaction);
//平台自动生成代码
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF_ATTACH> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF_ATTACH>(ServiceUri))
{
return(smgr.Service.Delete(cause));
}
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
CauseObject_MCE_B_ASSETS_WRITE_OFF p = new CauseObject_MCE_B_ASSETS_WRITE_OFF();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_WRITE_OFF[] listHead = BizLogicObject_MCE_B_ASSETS_WRITE_OFF.Proxy.Query(p);
JSON_PAGER_Write_Off jsonPager = new JSON_PAGER_Write_Off();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
jsonPager.head = listHead[0];
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "ASSETS_CODE";
CauseObject_MCE_B_ASSETS pd = new CauseObject_MCE_B_ASSETS();
pd.SetCustomCondition(" and MCE_B_ASSETS.ID in(select asset_id from MCE_B_ASSETS_WRITE_OFF_D where base_id='" + request["id"].ToString() + "')");
DisplayObject_MCE_B_ASSETS[] listDetail = BizLogicObject_MCE_B_ASSETS.Proxy.Query(pd, null, orderBy);
OrderByParameter orderByAttach = new OrderByParameter();
orderByAttach.Asc = false;
orderByAttach.OrderBy = "CREATE_DATE";
CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH pAttach = new CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
pAttach.BASE_ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] listAttach = BizLogicObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Proxy.Query(pAttach, null, orderByAttach);
jsonPager.total = listDetail.Length;
jsonPager.rows = listDetail;
jsonPager.attach = listAttach;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public BizLogicMsg Save_Ext2(JsonMCE_Write_Off json_Write_Off)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_WRITE_OFF entity = new EntityObject_MCE_B_ASSETS_WRITE_OFF();
if (!string.IsNullOrEmpty(json_Write_Off.ID))
{
entity.ID = json_Write_Off.ID;
entity = HelperObject_MCE_B_ASSETS_WRITE_OFF.Get(entity);
if (entity == null)
{
throw new Exception("获取数据出错.");
}
}
entity.CODE = json_Write_Off.CODE;
if (!string.IsNullOrEmpty(json_Write_Off.CREATE_DATE))
{
entity.CREATE_DATE = DateTime.Parse(json_Write_Off.CREATE_DATE);
}
entity.DEPT_ID = json_Write_Off.DEPT_ID;
entity.USER_ID = json_Write_Off.USER_ID;
entity.FINANCE_CYCLE = json_Write_Off.FINANCE_CYCLE;
entity.WRITE_OFF_TYPE_ID = json_Write_Off.WRITE_OFF_TYPE_ID;
entity.WRITE_OFF_CAUSE_ID = json_Write_Off.WRITE_OFF_CAUSE_ID;
entity.INCOME = json_Write_Off.INCOME;
entity.USAGE = json_Write_Off.USAGE;
entity.COMMENTS = json_Write_Off.COMMENTS;
entity.STATE = 1;
if (string.IsNullOrEmpty(json_Write_Off.ID))
{
entity.CREATE_TIME = DateTime.Now;
entity.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
int amount = HelperObject_MCE_B_ASSETS_WRITE_OFF.Save(entity, transaction);
}
else
{
entity.MODIFY_TIME = DateTime.Now;
entity.MODIFY_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
int amount = HelperObject_MCE_B_ASSETS_WRITE_OFF.Update(entity, transaction);
CauseObject_MCE_B_ASSETS_WRITE_OFF_D pWriteOffDetail = new CauseObject_MCE_B_ASSETS_WRITE_OFF_D();
pWriteOffDetail.BASE_ID = json_Write_Off.ID;
HelperObject_MCE_B_ASSETS_WRITE_OFF_D.Delete(pWriteOffDetail, transaction);
CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH pWriteOffAttach = new CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
pWriteOffAttach.BASE_ID = json_Write_Off.ID;
HelperObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Delete(pWriteOffAttach, transaction);
}
if (json_Write_Off.children != null && json_Write_Off.children.Count > 0)
{
foreach (JsonMCE_Write_Off_D item in json_Write_Off.children)
{
EntityObject_MCE_B_ASSETS_WRITE_OFF_D entity_D = new EntityObject_MCE_B_ASSETS_WRITE_OFF_D();
entity_D.BASE_ID = entity.ID;
entity_D.ASSET_ID = item.ASSET_ID;
HelperObject_MCE_B_ASSETS_WRITE_OFF_D.Save(entity_D, transaction);
}
}
if (json_Write_Off.listAttach != null && json_Write_Off.listAttach.Count > 0)
{
foreach (JsonMCE_Write_Off__ATTACH item in json_Write_Off.listAttach)
{
EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH entity_D = new EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
entity_D.BASE_ID = entity.ID;
entity_D.FILE_NAME = item.FILE_NAME;
entity_D.SAVENAME = item.SAVENAME;
entity_D.USER_ID = item.USER_ID;
entity_D.CREATE_DATE = item.CREATE_DATE;
HelperObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Save(entity_D, transaction);
}
}
msg.Message = entity.ID;
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF>(ServiceUri))
{
return(smgr.Service.Save_Ext2(json_Write_Off));
}
}
}
public void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "CODE";
StringBuilder strCondition = new StringBuilder();
strCondition.Append(" and MCE_B_ASSETS_WRITE_OFF.ID in (select base_id from MCE_B_ASSETS_WRITE_OFF_D where asset_id='" + request["id"] + "')");
CauseObject_MCE_B_ASSETS_WRITE_OFF p = new CauseObject_MCE_B_ASSETS_WRITE_OFF();
p.STATE = 5;
// p.ASSETS_ID = request["id"];
if (!string.IsNullOrEmpty(request["condition"]))//
{
strCondition.Append(" and (MCE_B_ASSETS_WRITE_OFF.CODE like '%" + request["condition"].ToString().Trim() + "%' )");
}
if (!string.IsNullOrEmpty(strCondition.ToString()))
{
p.SetCustomCondition(strCondition.ToString());
}
DisplayObject_MCE_B_ASSETS_WRITE_OFF[] list = BizLogicObject_MCE_B_ASSETS_WRITE_OFF.Proxy.Query(p, null, orderBy);
decimal decOriginal_value = 0;
decimal decNet_value = 0;
decimal decRudimental_value = 0;
EntityObject_MCE_B_ASSETS entitAsset = new EntityObject_MCE_B_ASSETS();
entitAsset.ID = request["id"];
entitAsset = BizLogicObject_MCE_B_ASSETS.Proxy.Get(entitAsset);
if (entitAsset != null)
{
decOriginal_value = entitAsset.ORIGINAL_VALUE;
decNet_value = entitAsset.NET_VALUE;
decRudimental_value = entitAsset.RUDIMENTAL_VALUE;
}
if (list != null && list.Length > 0)
{
foreach (DisplayObject_MCE_B_ASSETS_WRITE_OFF item in list)
{
item.ORIGINAL_VALUE = decOriginal_value;
item.NET_VALUE = decNet_value;
item.RUDIMENTAL_VALUE = decRudimental_value;
string strFiles = "";
CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH pMCE_B_ASSETS_WRITE_OFF_ATTACH = new CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
pMCE_B_ASSETS_WRITE_OFF_ATTACH.BASE_ID = item.ID;
DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] listMCE_B_ASSETS_WRITE_OFF_ATTACH = BizLogicObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Proxy.Query(pMCE_B_ASSETS_WRITE_OFF_ATTACH);
if (listMCE_B_ASSETS_WRITE_OFF_ATTACH != null && listMCE_B_ASSETS_WRITE_OFF_ATTACH.Length > 0)
{
foreach (DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH file in listMCE_B_ASSETS_WRITE_OFF_ATTACH)
{
if (!string.IsNullOrEmpty(file.SAVENAME))
{
strFiles = strFiles + file.SAVENAME + "/" + file.FILE_NAME + ",";
}
}
strFiles = strFiles.TrimEnd(',');
}
item.BACKUP1 = strFiles;
}
}
jsonMsg.Message = list;
jsonMsg.Succeed = 1;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
public static DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] Query(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_WRITE_OFF_ATTACH.BASE_ID, MCE_B_ASSETS_WRITE_OFF_ATTACH.CREATE_DATE, MCE_B_ASSETS_WRITE_OFF_ATTACH.SAVENAME, MCE_B_ASSETS_WRITE_OFF_ATTACH.USER_ID, MCE_B_ASSETS_WRITE_OFF_ATTACH.FILE_NAME, MCE_B_ASSETS_WRITE_OFF_ATTACH.ID, MCE_B_ASSETS_WRITE_OFF_BASE_ID.CODE as BASE_ID_NAME, COM_USER_USER_ID.NAME as USER_ID_NAME from MCE_B_ASSETS_WRITE_OFF_ATTACH left join MCE_B_ASSETS_WRITE_OFF MCE_B_ASSETS_WRITE_OFF_BASE_ID on MCE_B_ASSETS_WRITE_OFF_ATTACH.BASE_ID = MCE_B_ASSETS_WRITE_OFF_BASE_ID.ID left join COM_USER COM_USER_USER_ID on MCE_B_ASSETS_WRITE_OFF_ATTACH.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
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_WRITE_OFF_ATTACH", 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_WRITE_OFF_ATTACH dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
if (!sqlReader.IsDBNull(0))
{
dataObj.BASE_ID = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.CREATE_DATE = sqlReader.GetDateTime(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.SAVENAME = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.USER_ID = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.FILE_NAME = sqlReader.GetString(4);
}
if (!sqlReader.IsDBNull(5))
{
dataObj.ID = sqlReader.GetString(5);
}
if (!sqlReader.IsDBNull(6))
{
dataObj.BASE_ID_NAME = sqlReader.GetString(6);
}
if (!sqlReader.IsDBNull(7))
{
dataObj.USER_ID_NAME = sqlReader.GetString(7);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] objs = new DisplayObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static string PrepareCause(CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH cause, out OracleParameter[] parameters)
{
//平台自动生成代码
System.Text.StringBuilder strBuf = new System.Text.StringBuilder();
ArrayList paramList = new ArrayList();
OracleParameter param = null;
#region Push Block
if (!string.IsNullOrEmpty(cause.BASE_ID))
{
strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.BASE_ID ").Append((cause.BASE_ID.StartsWith("%") || cause.BASE_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_BASE_ID");
param = new OracleParameter();
param.ParameterName = ":C_BASE_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.BASE_ID;
paramList.Add(param);
}
if (cause.HasINValue("BASE_ID"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "BASE_ID"));
}
if (cause.CREATE_DATE != null)
{
if (cause.CREATE_DATE.Begin != null)
{
strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.CREATE_DATE >= :C_CREATE_DATE_BEGIN");
param = new OracleParameter();
param.ParameterName = ":C_CREATE_DATE_BEGIN";
param.OracleType = System.Data.OracleClient.OracleType.DateTime;
param.Size = 7;
param.Value = cause.CREATE_DATE.Begin;
paramList.Add(param);
}
if (cause.CREATE_DATE.End != null)
{
strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.CREATE_DATE < :C_CREATE_DATE_END");
param = new OracleParameter();
param.ParameterName = ":C_CREATE_DATE_END";
param.OracleType = System.Data.OracleClient.OracleType.DateTime;
param.Size = 7;
param.Value = cause.CREATE_DATE.End;
paramList.Add(param);
}
}
if (cause.HasINValue("CREATE_DATE"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "CREATE_DATE"));
}
if (!string.IsNullOrEmpty(cause.SAVENAME))
{
strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.SAVENAME ").Append((cause.SAVENAME.StartsWith("%") || cause.SAVENAME.EndsWith("%")) ? " like " : " = ").Append(" :C_SAVENAME");
param = new OracleParameter();
param.ParameterName = ":C_SAVENAME";
param.OracleType = System.Data.OracleClient.OracleType.VarChar;
param.Size = 300;
param.Value = cause.SAVENAME;
paramList.Add(param);
}
if (cause.HasINValue("SAVENAME"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "SAVENAME"));
}
if (!string.IsNullOrEmpty(cause.USER_ID))
{
strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.USER_ID ").Append((cause.USER_ID.StartsWith("%") || cause.USER_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_USER_ID");
param = new OracleParameter();
param.ParameterName = ":C_USER_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.USER_ID;
paramList.Add(param);
}
if (cause.HasINValue("USER_ID"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "USER_ID"));
}
if (!string.IsNullOrEmpty(cause.FILE_NAME))
{
strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.FILE_NAME ").Append((cause.FILE_NAME.StartsWith("%") || cause.FILE_NAME.EndsWith("%")) ? " like " : " = ").Append(" :C_FILE_NAME");
param = new OracleParameter();
param.ParameterName = ":C_FILE_NAME";
param.OracleType = System.Data.OracleClient.OracleType.VarChar;
param.Size = 300;
param.Value = cause.FILE_NAME;
paramList.Add(param);
}
if (cause.HasINValue("FILE_NAME"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "FILE_NAME"));
}
if (!string.IsNullOrEmpty(cause.ID))
{
strBuf.Append(" And MCE_B_ASSETS_WRITE_OFF_ATTACH.ID ").Append((cause.ID.StartsWith("%") || cause.ID.EndsWith("%")) ? " like " : " = ").Append(" :C_ID");
param = new OracleParameter();
param.ParameterName = ":C_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.ID;
paramList.Add(param);
}
if (cause.HasINValue("ID"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_WRITE_OFF_ATTACH", "ID"));
}
if (!string.IsNullOrEmpty(cause.GetCustomCondition()))
{
strBuf.Append(cause.GetCustomCondition());
}
#endregion
parameters = new OracleParameter[paramList.Count];
paramList.CopyTo(parameters);
return(strBuf.ToString());
}
