更新部分字段 NHibernate

来源:互联网 发布:win10 无法连接到网络 编辑:程序博客网 时间:2024/06/02 09:20
 public static bool UpdateIsBrowse(decimal id)
        {
            
bool IsSuccess = false;

            ITransaction trans 
= session.BeginTransaction();
            
try
            {
                
//2 修改记录
                string sql = " update jkpt_oaxt_weatherforecast set Isbrowse=1 where Weatherforecastid=" + id;           

                ISQLQuery Query 
= session.CreateSQLQuery(sql).AddEntity(typeof(JkptOaxtWeatherforecast));
                Query.ExecuteUpdate();             
                session.Flush();
                trans.Commit();
                
//写日志
                Helpers.SaveInfo("Update weatherforecast 's isbrowse Success!");
                IsSuccess 
= true;
            }
            
catch (Exception ex)
            {
                IsSuccess 
= false;
                trans.Rollback();
                
//写日志
                Helpers.SaveInfo("更新是否浏览失败!错误提示如下:" + ex.Message);
            }
            
finally
            {
                
if (session != null)
                {
                    session.Clear();
                }
            }
            
return IsSuccess;
        }
原创粉丝点击