public static int Update(EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH obj, IDbTransaction trans) { //平台自动生成代码 #region Parameters Block OracleParameter[] parameters = null; #endregion string sSql = "update MCE_B_ASSETS_WRITE_OFF_ATTACH set "; sSql += PrepareUpdate(obj, out parameters, true); sSql += " where ID = :U_ID "; return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
public static EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH Get(EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH obj) { //平台自动生成代码 string sSql = "select BASE_ID, CREATE_DATE, SAVENAME, USER_ID, FILE_NAME, ID from MCE_B_ASSETS_WRITE_OFF_ATTACH where 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 EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH dataObj = null; ArrayList objArray = new ArrayList(); IDbConnection connection = IDALProvider.IDAL.PopConnection(); IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection); while (sqlReader.Read()) { dataObj = new EntityObject_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); } objArray.Add(dataObj); } sqlReader.Close(); IDALProvider.IDAL.PushConnection(connection); #endregion EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[] objs = new EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH[objArray.Count]; objArray.CopyTo(0, objs, 0, objs.Length); return(objs.Length == 0 ? null:objs[0]); }
public static int Delete(EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH obj, IDbTransaction trans) { //平台自动生成代码 string sSql = "delete from MCE_B_ASSETS_WRITE_OFF_ATTACH where 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 return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
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 static int Save(EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH obj, IDbTransaction trans) { //平台自动生成代码 obj.ID = Guid.NewGuid().ToString(); string sSql = "insert into MCE_B_ASSETS_WRITE_OFF_ATTACH( BASE_ID, CREATE_DATE, SAVENAME, USER_ID, FILE_NAME, ID) values ( :BASE_ID, :CREATE_DATE, :SAVENAME, :USER_ID, :FILE_NAME, :ID)"; #region Parameters Block OracleParameter[] parameters = new OracleParameter[6]; parameters[0] = new OracleParameter(); parameters[0].ParameterName = ":BASE_ID"; parameters[0].Size = 36; parameters[0].OracleType = System.Data.OracleClient.OracleType.Char; parameters[0].Value = obj.BASE_ID == null ? String.Empty:obj.BASE_ID; parameters[1] = new OracleParameter(); parameters[1].ParameterName = ":CREATE_DATE"; parameters[1].Size = 7; parameters[1].OracleType = System.Data.OracleClient.OracleType.DateTime; parameters[1].Value = obj.CREATE_DATE; parameters[2] = new OracleParameter(); parameters[2].ParameterName = ":SAVENAME"; parameters[2].Size = 300; parameters[2].OracleType = System.Data.OracleClient.OracleType.VarChar; parameters[2].Value = obj.SAVENAME == null ? String.Empty:obj.SAVENAME; parameters[3] = new OracleParameter(); parameters[3].ParameterName = ":USER_ID"; parameters[3].Size = 36; parameters[3].OracleType = System.Data.OracleClient.OracleType.Char; parameters[3].Value = obj.USER_ID == null ? String.Empty:obj.USER_ID; parameters[4] = new OracleParameter(); parameters[4].ParameterName = ":FILE_NAME"; parameters[4].Size = 300; parameters[4].OracleType = System.Data.OracleClient.OracleType.VarChar; parameters[4].Value = obj.FILE_NAME == null ? String.Empty:obj.FILE_NAME; parameters[5] = new OracleParameter(); parameters[5].ParameterName = ":ID"; parameters[5].Size = 36; parameters[5].OracleType = System.Data.OracleClient.OracleType.Char; parameters[5].Value = obj.ID == null ? String.Empty:obj.ID; #endregion return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
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 static string PrepareUpdate(EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH obj, out OracleParameter[] parameters, bool appendpk) { //平台自动生成代码 List <string> strBuf = new List <string>(); ArrayList paramList = new ArrayList(); OracleParameter param = null; #region Push Block if (!obj.IsNotUpdate("BASE_ID")) { strBuf.Add(" MCE_B_ASSETS_WRITE_OFF_ATTACH.BASE_ID = :U_BASE_ID"); param = new OracleParameter(); param.ParameterName = ":U_BASE_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = string.IsNullOrEmpty(obj.BASE_ID) ? string.Empty : obj.BASE_ID; paramList.Add(param); } if (!obj.IsNotUpdate("CREATE_DATE")) { strBuf.Add(" MCE_B_ASSETS_WRITE_OFF_ATTACH.CREATE_DATE = :U_CREATE_DATE"); param = new OracleParameter(); param.ParameterName = ":U_CREATE_DATE"; param.OracleType = System.Data.OracleClient.OracleType.DateTime; param.Size = 7; param.Value = obj.CREATE_DATE; paramList.Add(param); } if (!obj.IsNotUpdate("SAVENAME")) { strBuf.Add(" MCE_B_ASSETS_WRITE_OFF_ATTACH.SAVENAME = :U_SAVENAME"); param = new OracleParameter(); param.ParameterName = ":U_SAVENAME"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 300; param.Value = string.IsNullOrEmpty(obj.SAVENAME) ? string.Empty : obj.SAVENAME; paramList.Add(param); } if (!obj.IsNotUpdate("USER_ID")) { strBuf.Add(" MCE_B_ASSETS_WRITE_OFF_ATTACH.USER_ID = :U_USER_ID"); param = new OracleParameter(); param.ParameterName = ":U_USER_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = string.IsNullOrEmpty(obj.USER_ID) ? string.Empty : obj.USER_ID; paramList.Add(param); } if (!obj.IsNotUpdate("FILE_NAME")) { strBuf.Add(" MCE_B_ASSETS_WRITE_OFF_ATTACH.FILE_NAME = :U_FILE_NAME"); param = new OracleParameter(); param.ParameterName = ":U_FILE_NAME"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 300; param.Value = string.IsNullOrEmpty(obj.FILE_NAME) ? string.Empty : obj.FILE_NAME; paramList.Add(param); } //pk here if (appendpk) { param = new OracleParameter(); param.ParameterName = ":U_ID"; param.OracleType = System.Data.OracleClient.OracleType.Char; param.Size = 36; param.Value = obj.ID; paramList.Add(param); } #endregion parameters = new OracleParameter[paramList.Count]; paramList.CopyTo(parameters); return(string.Join(", ", strBuf.ToArray())); }