如何从 Fluent Nhibernate 传递 sysdate 值

发布于 2024-12-12 13:12:56 字数 967 浏览 0 评论 0原文

我这里有一种情况，我需要使用 Nhibernate 从 .net 代码将日期作为 db 的 sysdate 传递，这里是我的代码，

 OfflineStatusChangeMonitor newstatusobj = new OfflineStatusChangeMonitor
                    {
                        NIK = demoFromDedup.NIK,
                        NIKStatus = new Status { Code = demoFromDedup.CurrentStatus.Code },
                        RegionId = Convert.ToInt16(demoFromDedup.RegionId),
                        LocalId = demoFromDedup.LocalId,
                        Updatedtime = DateTime.Now,
                        ServiceName = "XXXXX"

                    };
                    idmsRepository.Add<OfflineStatusChangeMonitor>(newstatusobj);

其中添加函数代码如下，

 public void Add<ENTITY>(ENTITY entity) where ENTITY : EntityBase
    {
        this.UnitOfWork.CurrentSession.Save(entity);
    }

现在在这种情况下，我如何将 updatetime 的值设置为 SYSDATE Oracle

我无法在数据库中执行此操作，因为我在许多位置都有数据库并且正在从 wcf 服务更新数据

原文

i have a situation here where i need to pass the date as sysdate of db from the .net code using the Nhibernate here goes my code

 OfflineStatusChangeMonitor newstatusobj = new OfflineStatusChangeMonitor
                    {
                        NIK = demoFromDedup.NIK,
                        NIKStatus = new Status { Code = demoFromDedup.CurrentStatus.Code },
                        RegionId = Convert.ToInt16(demoFromDedup.RegionId),
                        LocalId = demoFromDedup.LocalId,
                        Updatedtime = DateTime.Now,
                        ServiceName = "XXXXX"

                    };
                    idmsRepository.Add<OfflineStatusChangeMonitor>(newstatusobj);

where add functions code is as follows

 public void Add<ENTITY>(ENTITY entity) where ENTITY : EntityBase
    {
        this.UnitOfWork.CurrentSession.Save(entity);
    }

now in this situation how can i set the values of updatedtime to SYSDATE of Oracle

i can not do it in the data base as i have the db s in many locations and am updating the data from wcf service

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

复古式 2024-12-19 13:12:56

public DateTime getdbdate()
        {
            var dt = this.UnitOfWork.CurrentSession.CreateSQLQuery("select sysdate from dual where rownum<2").UniqueResult();

            if (dt != null)

                return (DateTime)dt;
            else           

            return DateTime.Now;

        }

然后调用此函数来获取数据库日期，然后将其用作函数中的日期时间

public DateTime getdbdate()
        {
            var dt = this.UnitOfWork.CurrentSession.CreateSQLQuery("select sysdate from dual where rownum<2").UniqueResult();

            if (dt != null)

                return (DateTime)dt;
            else           

            return DateTime.Now;

        }

and then call this function to get the db date and then use this as the date time in your function

回复收藏 0 原文