/// <summary> /// 保存软件下载信息,添加或修改 /// </summary> /// <param name="model">软件下载实体数据</param> /// <param name="list">软件列表</param> /// <returns>保存结果对象</returns> /// <remarks>2014-01-17 唐永勤 创建</remarks> public Result Save(FeSoftware model, IList <FeSoftwareList> list) { Result result = new Result(); if (string.IsNullOrEmpty(model.Title)) { result.StatusCode = -1; } else { //数据重复性检测 bool isExists = IFeSoftwareDao.Instance.IsExists(model); if (isExists) { result.StatusCode = -2; result.Message = "软件下载标题已存在"; return(result); } if (list.Count < 1) { result.StatusCode = -3; result.Message = "未上传软件"; return(result); } //使用事务保存数据一致性 //数据操作 if (model.SysNo > 0) { result.Status = IFeSoftwareDao.Instance.Update(model); } else { model.Status = (int)Hyt.Model.WorkflowStatus.ForeStatus.软件下载状态.待审; model.SysNo = IFeSoftwareDao.Instance.Create(model); if (model.SysNo > 0) { result.Status = true; } } if (result.Status) { result.Status = IFeSoftwareListDao.Instance.SaveList(model.SysNo, list); if (result.Status) { result.StatusCode = 1; result.Message = "软件信息保存成功"; } else { result.Message = "软件列表保存失败"; } } } return(result); }
/// <summary> /// 添加软件 /// </summary> /// <param name="model">软件实体信息</param> /// <returns>返回新建记录的sysNo</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public override int Create(FeSoftware model) { int sysno = 0; sysno = Context.Insert <FeSoftware>("FeSoftware", model) .AutoMap(x => x.SysNo) .ExecuteReturnLastId <int>("Sysno"); return(sysno); }
/// <summary> /// 根据软件编号更新软件信息 /// </summary> /// <param name="model">软件实体信息</param> /// <returns>成功返回true,失败返回false</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public override bool Update(FeSoftware model) { int effect = Context.Update <FeSoftware>("FeSoftware", model) .AutoMap(x => x.SysNo, x => x.Status) .Where("sysno", model.SysNo) .Execute(); return(effect > 0); }
/// <summary> /// 获取指定编号的软件信息 /// </summary> /// <param name="sysNo">软件编号</param> /// <returns>软件实体信息</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public override FeSoftware GetEntity(int sysNo) { FeSoftware entity = Context.Select <FeSoftware>("*") .From("FeSoftware") .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(FeSoftware model) { bool result = false; FeSoftware entity = Context.Select <FeSoftware>("*") .From("FeSoftware") .Where("Title= @Title and Sysno != @Sysno") .Parameter("Name", model.Title) .Parameter("Sysno", model.SysNo) .QuerySingle(); if (entity != null && entity.SysNo > 0) { result = true; } return(result); }
/// <summary> /// 根据软件编号更新软件信息 /// </summary> /// <param name="model">软件实体信息</param> /// <returns>成功返回true,失败返回false</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public abstract bool Update(FeSoftware model);
/// <summary> /// 判断重复数据 /// </summary> /// <param name="model">软件实体信息</param> /// <returns>存在返回true,不存在返回flase</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public abstract bool IsExists(FeSoftware model);
/// <summary> /// 添加软件 /// </summary> /// <param name="model">软件实体信息</param> /// <returns>返回新建记录的sysno</returns> /// <remarks>2014-01-15 唐永勤 创建</remarks> public abstract int Create(FeSoftware model);