/// <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);
