/// <summary> /// 得到一个对象实体 /// </summary> /// <param name="KeyValue">主键</param> /// <returns></returns> public AMS_DataPermission GetEntity(StringBuilder where, SqlParam[] param) { AMS_DataPermission entity = new AMS_DataPermission(); StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM AMS_DataPermission WHERE 1=1"); strSql.Append(where); DataTable dt = DbHelper.GetDataTableBySQL(strSql, param); if (dt.Rows.Count > 0) { return DbReader.ReaderToModel<AMS_DataPermission>(dt.Rows[0]); } else { return entity; } }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public bool Insert(AMS_DataPermission entity) { int IsOk = DbUtils.Insert(entity); #region 写日操作日志 if (IsOk > 0) { AMS_SysLogBLL.Instance.AddTaskLog<AMS_DataPermission>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName); } #endregion return IsOk >= 0 ? true : false; }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public bool Update(AMS_DataPermission entity) { #region 获取旧值 var oldEntity = this.GetEntity(AMS_SysLogBLL.Instance.GetKeyFieldValue<AMS_DataPermission>(entity).ToString()); #endregion int IsOk = DbUtils.Update(entity, "DataPermissionId"); #region 写日操作日志 if (IsOk > 0) { AMS_SysLogBLL.Instance.UpdateTaskLog<AMS_DataPermission>(oldEntity, entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName); } #endregion return IsOk >= 0 ? true : false; }