コード例 #1
0
        public int Update(List <PROJECT_ATTACHMENTDC> objPROJECT_ATTACHMENTs)
        {
            int                  updatedCount            = 0;
            DBConnection         objConnection           = new DBConnection();
            PROJECT_ATTACHMENTDA objPROJECT_ATTACHMENTDA = new PROJECT_ATTACHMENTDA();

            try
            {
                objConnection.Open(true);
                updatedCount = objPROJECT_ATTACHMENTDA.Update(objConnection, objPROJECT_ATTACHMENTs);
                IsDirty      = objPROJECT_ATTACHMENTDA.IsDirty;
                if (IsDirty)
                {
                    objConnection.Rollback();
                }
                else
                {
                    objConnection.Commit();
                }
            }
            catch (Exception ex)
            {
                objConnection.Rollback();
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(updatedCount);
        }
コード例 #2
0
        public PROJECT_ATTACHMENTDC LoadByPrimaryKey(int PROJECT_ID, int ATTACHMENT_ID)
        {
            DBConnection         objConnection           = new DBConnection();
            PROJECT_ATTACHMENTDA objPROJECT_ATTACHMENTDA = new PROJECT_ATTACHMENTDA();
            PROJECT_ATTACHMENTDC objPROJECT_ATTACHMENTDC = null;

            try
            {
                objConnection.Open(false);
                objPROJECT_ATTACHMENTDC = objPROJECT_ATTACHMENTDA.LoadByPrimaryKey(objConnection, PROJECT_ID, ATTACHMENT_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objPROJECT_ATTACHMENTDC);
        }
コード例 #3
0
        public List <PROJECT_ATTACHMENTDC> LoadAll()
        {
            DBConnection                objConnection           = new DBConnection();
            PROJECT_ATTACHMENTDA        objPROJECT_ATTACHMENTDA = new PROJECT_ATTACHMENTDA();
            List <PROJECT_ATTACHMENTDC> objPROJECT_ATTACHMENTDC = null;

            try
            {
                objConnection.Open(false);
                objPROJECT_ATTACHMENTDC = objPROJECT_ATTACHMENTDA.LoadAll(objConnection);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objPROJECT_ATTACHMENTDC);
        }
コード例 #4
0
        public int Insert(List <PROJECT_ATTACHMENTDC> objPROJECT_ATTACHMENTs)
        {
            int                  insertedCount           = 0;
            DBConnection         objConnection           = new DBConnection();
            PROJECT_ATTACHMENTDA objPROJECT_ATTACHMENTDA = new PROJECT_ATTACHMENTDA();

            try
            {
                objConnection.Open(true);
                insertedCount = objPROJECT_ATTACHMENTDA.Insert(objConnection, objPROJECT_ATTACHMENTs);
                objConnection.Commit();
            }
            catch (Exception ex)
            {
                objConnection.Rollback();
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(insertedCount);
        }