示例#1
0
        public virtual void StartSessionApi(string clientcode, string clienttypecode, string clientip, string clientmac, string clientSessionAppKey, ref decimal?clientSessionId,
                                            string clientSessionUserDomainName, string clientSessionClientVersion, string clientSessionServiceId, string clientOSVersion)
        {
            decimal?id = clientSessionId;

            id = RunManualDbOperation <decimal?>(db =>
            {
                var ps = new IDbDataParameter[]
                {
                    new OracleParameter("pClientCode", OracleDbType.Varchar2, clientcode, ParameterDirection.Input),
                    new OracleParameter("pClientTypeCode", OracleDbType.Varchar2, clienttypecode, ParameterDirection.Input),
                    new OracleParameter("pClientIP", OracleDbType.Varchar2, clientip, ParameterDirection.Input),
                    new OracleParameter("pClientMAC", OracleDbType.Varchar2, clientmac, ParameterDirection.Input),
                    new OracleParameter("pClientSessionAppKey", OracleDbType.Varchar2, clientSessionAppKey, ParameterDirection.Input),
                    new OracleParameter("pClientSessionID", OracleDbType.Int32, id, ParameterDirection.InputOutput),
                    new OracleParameter("pClientSessionUserDomainName", OracleDbType.Varchar2, clientSessionUserDomainName, ParameterDirection.Input),
                    new OracleParameter("pClientSessionClientVersion", OracleDbType.Varchar2, clientSessionClientVersion, ParameterDirection.Input),
                    new OracleParameter("pClientSessionServiceId", OracleDbType.Varchar2, clientSessionServiceId, ParameterDirection.Input),
                    new OracleParameter("pClientOSVersion", OracleDbType.Varchar2, clientOSVersion, ParameterDirection.Input)
                };
                db.SetCommand(CommandType.StoredProcedure, "pkgBpProcess.startSession", ps).ExecuteNonQuery();
                var result = (OracleParameter)ps.GetValue(5);
                return((result.Value == null) ? (decimal?)null : Convert.ToDecimal(result.Value.ToString()));
            });
            clientSessionId = id;
        }