/// <summary> /// 设置表头定义批量公开 /// </summary> /// <param name="KeyValue">主键值</param> /// <param name="MenuId">模块菜单主键</param> /// <returns></returns> public bool BatchIsPublic(string[] KeyValue, string MenuId) { //return dal.BatchIsPublic(KeyValue, MenuId) >= 0 ? true : false; StringBuilder[] sqls = new StringBuilder[KeyValue.Length + 1]; object[] objs = new object[KeyValue.Length + 1]; AMS_TableColumns entity = new AMS_TableColumns(); entity.MenuId = MenuId; entity.IsPublic = 0; sqls[0] = SqlParamHelper.UpdateSql(entity, "MenuId"); objs[0] = SqlParamHelper.GetParameter(entity); int index = 1; foreach (string item in KeyValue) { if (item.Length > 0) { AMS_TableColumns entityitem = new AMS_TableColumns(); entityitem.TableColumnsId = item; entityitem.IsPublic = 1; entityitem.SortCode = index; sqls[index] = SqlParamHelper.UpdateSql(entityitem, "TableColumnsId"); objs[index] = SqlParamHelper.GetParameter(entityitem); index++; } } int IsOK = DbHelper.BatchExecuteBySql(sqls, objs); return IsOK >= 0 ? true : false; }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public bool Update(AMS_TableColumns entity) { //return dal.Update(entity) >= 0 ? true : false; #region 获取旧值 var oldEntity = this.GetEntity(AMS_SysLogBLL.Instance.GetKeyFieldValue<AMS_TableColumns>(entity).ToString()); #endregion int IsOk = DbUtils.Update(entity, "TableColumnsId"); #region 写日操作日志 if (IsOk > 0) { AMS_SysLogBLL.Instance.UpdateTaskLog<AMS_TableColumns>(oldEntity, entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName); } #endregion return IsOk >= 0 ? true : false; }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="entity">实体类</param> /// <returns></returns> public bool Insert(AMS_TableColumns entity) { //return dal.Insert(entity) >= 0 ? true : false; entity.SortCode = CommonHelper.GetInt(this.GetMaxCode()); int IsOk = DbUtils.Insert(entity); #region 写日操作日志 if (IsOk > 0) { AMS_SysLogBLL.Instance.AddTaskLog<AMS_TableColumns>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName); } #endregion return IsOk >= 0 ? true : false; }