/// <summary> /// 根据软件分类编号更新软件分类信息 /// </summary> /// <param name="model">软件分类实体信息</param> /// <returns>成功返回true,失败返回false</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public override bool Update(FeSoftCategory model) { int effect = Context.Update <FeSoftCategory>("FeSoftCategory", model) .AutoMap(x => x.SysNo, x => x.Status) .Where("sysno", model.SysNo) .Execute(); return(effect > 0); }
/// <summary> /// 添加软件分类 /// </summary> /// <param name="model">分类实体信息</param> /// <returns>返回新建记录的sysno</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public override int Create(FeSoftCategory model) { int sysno = 0; sysno = Context.Insert <FeSoftCategory>("FeSoftCategory", model) .AutoMap(x => x.SysNo) .ExecuteReturnLastId <int>("Sysno"); return(sysno); }
/// <summary> /// 获取指定软件分类信息 /// </summary> /// <param name="sysno">软件分类编号</param> /// <returns>软件分类实体信息</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public override FeSoftCategory GetEntity(int sysno) { FeSoftCategory entity = Context.Select <FeSoftCategory>("*") .From("FeSoftCategory") .Where("sysno = @sysno") .Parameter("sysno", sysno) .QuerySingle(); return(entity); }
/// <summary> /// 判断重复数据 /// </summary> /// <param name="model">分类实体信息</param> /// <returns>存在返回true,不存在返回flase</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public override bool IsExists(FeSoftCategory model) { bool result = false; FeSoftCategory entity = Context.Select <FeSoftCategory>("*") .From("FeSoftCategory") .Where("Name= @Name and Sysno != @Sysno") .Parameter("Name", model.Name) .Parameter("Sysno", model.SysNo) .QuerySingle(); if (entity != null && entity.SysNo > 0) { result = true; } return(result); }
/// <summary> /// 保存软件分类信息,添加或修改 /// </summary> /// <param name="model">软件分类实体数据</param> /// <returns>保存结果对象</returns> /// <remarks>2014-01-16 唐永勤 创建</remarks> public Result FeSoftCategorySave(FeSoftCategory model) { Result result = new Result(); if (string.IsNullOrEmpty(model.Name)) { result.StatusCode = -1; } else { //数据重复性检测 bool isExists = IFeSoftCategoryDao.Instance.IsExists(model); if (isExists) { result.StatusCode = -2; result.Message = "软件分类名称已存在"; return(result); } //数据操作 if (model.SysNo > 0) { result.Status = IFeSoftCategoryDao.Instance.Update(model); } else { model.SysNo = IFeSoftCategoryDao.Instance.Create(model); if (model.SysNo > 0) { result.Status = true; } } if (result.Status) { result.StatusCode = 1; result.Message = "软件分类信息保存成功"; } } return(result); }
/// <summary> /// 根据软件分类编号更新软件分类信息 /// </summary> /// <param name="model">软件分类实体信息</param> /// <returns>成功返回true,失败返回false</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public abstract bool Update(FeSoftCategory model);
/// <summary> /// 判断重复数据 /// </summary> /// <param name="model">分类实体信息</param> /// <returns>存在返回true,不存在返回flase</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public abstract bool IsExists(FeSoftCategory model);
/// <summary> /// 添加软件分类 /// </summary> /// <param name="model">分类实体信息</param> /// <returns>返回新建记录的sysno</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public abstract int Create(FeSoftCategory model);