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()); }