C# (CSharp) OGen.NTier.UTs.lib.datalayer.DO_UserGroupの例

コード例 #1

ファイル: OGen-NTier__Docs__Develop_HowTo_setobject.cs プロジェクト: katshann/ogen

		public HowTo_setObject () {
//<document>
long _iduser = 1L;
long _idgroup = 1L;

OGen.NTier.UTs.lib.datalayer.DO_UserGroup _usergroup = new OGen.NTier.UTs.lib.datalayer.DO_UserGroup();
_usergroup.Fields.IDUser = _iduser;
_usergroup.Fields.IDGroup = _idgroup;
_usergroup.Fields.Relationdate = DateTime.Now;
_usergroup.Fields.Defaultrelation = false;

// if relation exists, it updates, if not it inserts:
_usergroup.setObject(true);

_usergroup.Dispose(); _usergroup = null;
//</document>
		}

コード例 #2

        public HowTo_setObject()
        {
//<document>
            long _iduser  = 1L;
            long _idgroup = 1L;

            OGen.NTier.UTs.lib.datalayer.DO_UserGroup _usergroup = new OGen.NTier.UTs.lib.datalayer.DO_UserGroup();
            _usergroup.Fields.IDUser          = _iduser;
            _usergroup.Fields.IDGroup         = _idgroup;
            _usergroup.Fields.Relationdate    = DateTime.Now;
            _usergroup.Fields.Defaultrelation = false;

// if relation exists, it updates, if not it inserts:
            _usergroup.setObject(true);

            _usergroup.Dispose(); _usergroup = null;
//</document>
        }

コード例 #3

ファイル: OGen-NTier__Docs__Develop_HowTo_UseTransactions_betweenDOs_operations.cs プロジェクト: katshann/ogen

		public HowTo_UseTransactions_betweenDOs_operations() {
//<document>
string _testid = DateTime.Now.Ticks.ToString();
bool _constraint;
long _iduser;
long _idgroup;

// we need a shared connection between Data Objects
OGen.lib.datalayer.DBConnection _con = OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnection_createInstance(
	OGen.NTier.UTs.lib.datalayer.DO__utils.DBServerType,
	OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnectionstring, 
	string.Empty
);

// before beginning a transaction we need to open the connection
_con.Open();
try {
	// beginning transaction
	_con.Transaction.Begin();

	// sharing connection with User Data Object
	OGen.NTier.UTs.lib.datalayer.DO_User _user 
		= new OGen.NTier.UTs.lib.datalayer.DO_User(_con);
	// performing some operations on User Data Object
	_user.Fields.Login = _testid;
	_user.Fields.Password = _testid;
	_iduser = _user.insObject(true, out _constraint);
	// handling constraint code should be added here
	_user.Dispose(); _user = null;

	// sharing connection with Group Data Object
	OGen.NTier.UTs.lib.datalayer.DO_Group _group 
		= new OGen.NTier.UTs.lib.datalayer.DO_Group(_con);
	// performing some operations on User Data Object
	_group.Fields.Name = _testid;
	_idgroup = _group.insObject(true);
	_group.Dispose(); _group = null;

	// sharing connection with Group Data Object
	OGen.NTier.UTs.lib.datalayer.DO_UserGroup _usergroup
		= new OGen.NTier.UTs.lib.datalayer.DO_UserGroup(_con);
	// performing some operations on User Data Object
	_usergroup.Fields.IDGroup = _idgroup;
	_usergroup.Fields.IDUser = _iduser;
	_usergroup.Fields.Relationdate = DateTime.Now;
	_usergroup.Fields.Defaultrelation = false;
	_usergroup.setObject(false);
	_usergroup.Dispose(); _usergroup = null;

	// commit transaction
	_con.Transaction.Commit();
} catch (Exception _ex) {
	// rollback transaction
	_con.Transaction.Rollback();
} finally {
	// terminate transaction
	_con.Transaction.Terminate();
}
// closing connection
_con.Close();
_con.Dispose(); _con = null;
//</document>
		}

コード例 #4

        public HowTo_UseTransactions_betweenDOs_operations()
        {
//<document>
            string _testid = DateTime.Now.Ticks.ToString();
            bool   _constraint;
            long   _iduser;
            long   _idgroup;

// we need a shared connection between Data Objects
            OGen.lib.datalayer.DBConnection _con = OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnection_createInstance(
                OGen.NTier.UTs.lib.datalayer.DO__utils.DBServerType,
                OGen.NTier.UTs.lib.datalayer.DO__utils.DBConnectionstring,
                string.Empty
                );

// before beginning a transaction we need to open the connection
            _con.Open();
            try {
                // beginning transaction
                _con.Transaction.Begin();

                // sharing connection with User Data Object
                OGen.NTier.UTs.lib.datalayer.DO_User _user
                    = new OGen.NTier.UTs.lib.datalayer.DO_User(_con);
                // performing some operations on User Data Object
                _user.Fields.Login    = _testid;
                _user.Fields.Password = _testid;
                _iduser = _user.insObject(true, out _constraint);
                // handling constraint code should be added here
                _user.Dispose(); _user = null;

                // sharing connection with Group Data Object
                OGen.NTier.UTs.lib.datalayer.DO_Group _group
                    = new OGen.NTier.UTs.lib.datalayer.DO_Group(_con);
                // performing some operations on User Data Object
                _group.Fields.Name       = _testid;
                _idgroup                 = _group.insObject(true);
                _group.Dispose(); _group = null;

                // sharing connection with Group Data Object
                OGen.NTier.UTs.lib.datalayer.DO_UserGroup _usergroup
                    = new OGen.NTier.UTs.lib.datalayer.DO_UserGroup(_con);
                // performing some operations on User Data Object
                _usergroup.Fields.IDGroup         = _idgroup;
                _usergroup.Fields.IDUser          = _iduser;
                _usergroup.Fields.Relationdate    = DateTime.Now;
                _usergroup.Fields.Defaultrelation = false;
                _usergroup.setObject(false);
                _usergroup.Dispose(); _usergroup = null;

                // commit transaction
                _con.Transaction.Commit();
            } catch (Exception _ex) {
                // rollback transaction
                _con.Transaction.Rollback();
            } finally {
                // terminate transaction
                _con.Transaction.Terminate();
            }
// closing connection
            _con.Close();
            _con.Dispose(); _con = null;
//</document>
        }