public static int Save(EntityObject_MCE_B_ASSETS_FILETEMPLATE obj, IDbTransaction trans) { //平台自动生成代码 obj.ID = Guid.NewGuid().ToString(); string sSql = "insert into MCE_B_ASSETS_FILETEMPLATE( COMMENTS, ID, NAME) values ( :COMMENTS, :ID, :NAME)"; #region Parameters Block OracleParameter[] parameters = new OracleParameter[3]; parameters[0] = new OracleParameter(); parameters[0].ParameterName = ":COMMENTS"; parameters[0].Size = 200; parameters[0].OracleType = System.Data.OracleClient.OracleType.VarChar; parameters[0].Value = obj.COMMENTS == null ? String.Empty:obj.COMMENTS; parameters[1] = new OracleParameter(); parameters[1].ParameterName = ":ID"; parameters[1].Size = 36; parameters[1].OracleType = System.Data.OracleClient.OracleType.Char; parameters[1].Value = obj.ID == null ? String.Empty:obj.ID; parameters[2] = new OracleParameter(); parameters[2].ParameterName = ":NAME"; parameters[2].Size = 100; parameters[2].OracleType = System.Data.OracleClient.OracleType.VarChar; parameters[2].Value = obj.NAME == null ? String.Empty:obj.NAME; #endregion return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
public BizLogicMsg Save_RollFileAsTemplate(JsonMceAssetsRollFileTemplate item) { if (LocalMode) { BizLogicMsg msg = new BizLogicMsg(); using (IDbConnection connection = IDALProvider.IDAL.PopConnection()) { using (IDbTransaction transaction = connection.BeginTransaction()) { try { CauseObject_MCE_B_ASSETS_ROLLFILE pMCE_B_ASSETS_ROLLFILE = new CauseObject_MCE_B_ASSETS_ROLLFILE(); pMCE_B_ASSETS_ROLLFILE.BASE_ID = item.rollid; DisplayObject_MCE_B_ASSETS_ROLLFILE[] listMCE_B_ASSETS_ROLLFILE = BizLogicObject_MCE_B_ASSETS_ROLLFILE.Proxy.Query(pMCE_B_ASSETS_ROLLFILE); if (listMCE_B_ASSETS_ROLLFILE != null && listMCE_B_ASSETS_ROLLFILE.Length > 0) { EntityObject_MCE_B_ASSETS_FILETEMPLATE objTemplate = new EntityObject_MCE_B_ASSETS_FILETEMPLATE(); objTemplate.NAME = item.name; objTemplate.COMMENTS = item.comments; HelperObject_MCE_B_ASSETS_FILETEMPLATE.Save(objTemplate, transaction); foreach (DisplayObject_MCE_B_ASSETS_ROLLFILE displayObject_MCE_B_ASSETS_ROLLFILE in listMCE_B_ASSETS_ROLLFILE) { EntityObject_MCE_B_ASSETS_FILETEMPLATE_D objTemplate_D = new EntityObject_MCE_B_ASSETS_FILETEMPLATE_D(); objTemplate_D.CODE = displayObject_MCE_B_ASSETS_ROLLFILE.CODE; objTemplate_D.NAME = displayObject_MCE_B_ASSETS_ROLLFILE.NAME; objTemplate_D.BASE_ID = objTemplate.ID; HelperObject_MCE_B_ASSETS_FILETEMPLATE_D.Save(objTemplate_D, transaction); } } else { throw new Exception("另存为文件数不能为0."); } 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_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri)) { return(smgr.Service.Save_RollFileAsTemplate(item)); } } }
public static int Update(EntityObject_MCE_B_ASSETS_FILETEMPLATE obj, IDbTransaction trans) { //平台自动生成代码 #region Parameters Block OracleParameter[] parameters = null; #endregion string sSql = "update MCE_B_ASSETS_FILETEMPLATE set "; sSql += PrepareUpdate(obj, out parameters, true); sSql += " where ID = :U_ID "; return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans)); }
public static int Delete(EntityObject_MCE_B_ASSETS_FILETEMPLATE obj, IDbTransaction trans) { //平台自动生成代码 string sSql = "delete from MCE_B_ASSETS_FILETEMPLATE 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_FILETEMPLATE obj, CauseObject_MCE_B_ASSETS_FILETEMPLATE cause, IDbTransaction trans) { //平台自动生成代码 #region Parameters Block List <OracleParameter> list = new List <OracleParameter>(); OracleParameter[] parameters = null; #endregion string sSql = "update MCE_B_ASSETS_FILETEMPLATE 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 string PrepareUpdate(EntityObject_MCE_B_ASSETS_FILETEMPLATE 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("COMMENTS")) { strBuf.Add(" MCE_B_ASSETS_FILETEMPLATE.COMMENTS = :U_COMMENTS"); param = new OracleParameter(); param.ParameterName = ":U_COMMENTS"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 200; param.Value = string.IsNullOrEmpty(obj.COMMENTS) ? string.Empty : obj.COMMENTS; paramList.Add(param); } if (!obj.IsNotUpdate("NAME")) { strBuf.Add(" MCE_B_ASSETS_FILETEMPLATE.NAME = :U_NAME"); param = new OracleParameter(); param.ParameterName = ":U_NAME"; param.OracleType = System.Data.OracleClient.OracleType.VarChar; param.Size = 100; param.Value = string.IsNullOrEmpty(obj.NAME) ? string.Empty : obj.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())); }
public static EntityObject_MCE_B_ASSETS_FILETEMPLATE Get(EntityObject_MCE_B_ASSETS_FILETEMPLATE obj) { //平台自动生成代码 string sSql = "select COMMENTS, ID, NAME from MCE_B_ASSETS_FILETEMPLATE 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_FILETEMPLATE 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_FILETEMPLATE(); if (!sqlReader.IsDBNull(0)) { dataObj.COMMENTS = sqlReader.GetString(0); } if (!sqlReader.IsDBNull(1)) { dataObj.ID = sqlReader.GetString(1); } if (!sqlReader.IsDBNull(2)) { dataObj.NAME = sqlReader.GetString(2); } objArray.Add(dataObj); } sqlReader.Close(); IDALProvider.IDAL.PushConnection(connection); #endregion EntityObject_MCE_B_ASSETS_FILETEMPLATE[] objs = new EntityObject_MCE_B_ASSETS_FILETEMPLATE[objArray.Count]; objArray.CopyTo(0, objs, 0, objs.Length); return(objs.Length == 0 ? null:objs[0]); }
public EntityObject_MCE_B_ASSETS_FILETEMPLATE_D Load(string id, out EntityObject_MCE_B_ASSETS_FILETEMPLATE base_id) { if (LocalMode) { EntityObject_MCE_B_ASSETS_FILETEMPLATE_D obj = new EntityObject_MCE_B_ASSETS_FILETEMPLATE_D(); //平台自动生成代码 base_id = new EntityObject_MCE_B_ASSETS_FILETEMPLATE(); using (IDbConnection connection = IDALProvider.IDAL.PopConnection()) { using (IDbTransaction transaction = connection.BeginTransaction()) { try { obj = Load(transaction, id, out base_id); transaction.Commit(); } catch (Exception expt) { transaction.Rollback(); Error(expt); } finally { IDALProvider.IDAL.PushConnection(connection); } } } return(obj); } else { using (ServiceManager <ServiceContract_MCE_B_ASSETS_FILETEMPLATE_D> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_FILETEMPLATE_D>(ServiceUri)) { return(smgr.Service.Load(id, out base_id)); } } }
public EntityObject_MCE_B_ASSETS_FILETEMPLATE_D Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS_FILETEMPLATE base_id) { if (LocalMode) { EntityObject_MCE_B_ASSETS_FILETEMPLATE_D obj = new EntityObject_MCE_B_ASSETS_FILETEMPLATE_D(); //平台自动生成代码 base_id = new EntityObject_MCE_B_ASSETS_FILETEMPLATE(); obj.ID = id; obj = HelperObject_MCE_B_ASSETS_FILETEMPLATE_D.Get(obj, transaction); if (!string.IsNullOrEmpty(obj.BASE_ID)) { base_id.ID = obj.BASE_ID; base_id = HelperObject_MCE_B_ASSETS_FILETEMPLATE.Get(base_id, transaction); } return(obj); } else { throw new InvalidConstraintException(); } }