/// <summary> /// 按用户名查询 /// </summary> /// <param name="sn"></param> /// <returns></returns> public SysDic FindByCode(string code) { IList <SysDic> list = SysDicDao.FindByHql(" and code=?", new Object[] { code }, "id desc"); SysDic dic = null; if (list.Count() > 0) { dic = list[0]; } return(dic); }
/// <summary> /// 验证代码是否存在 /// </summary> /// <param name="code"></param> /// <param name="id"></param> /// <returns></returns> public bool CheckIsExist(string code, Int32?id) { List <object> _listParam = new List <object>(); String _sql = " and code=?"; _listParam.Add(code); if (id != null) { _sql += " and id<>?"; _listParam.Add(id); } int count = SysDicDao.FindCountByHql(_sql, _listParam.ToArray()); return(count > 0 ? true : false); }
public SResult Update(SysDic sysDic) { SResult rst = new SResult(); //验证用户名是否重复 if (this.CheckIsExist(sysDic.Code, sysDic.Id)) { rst.success = false; rst.message = "[" + sysDic.Code + "]已存在!"; } else { SysDicDao.Update(sysDic); rst.success = true; rst.data = sysDic; rst.message = "修改成功!"; } return(rst); }
public SResult Insert(SysDic sysDic) { SResult rst = new SResult(); //验证用户名是否重复 if (this.CheckIsExist(sysDic.Code, null)) { rst.success = false; rst.message = "[" + sysDic.Code + "]已存在!"; } else { SysDicDao.Insert(sysDic); rst.success = true; rst.data = sysDic; rst.message = "新增成功!"; } return(rst); }
public void Delete(int id) { SysDicDao.DeleteById(id); }
/// <summary> /// 按id查询 /// </summary> /// <param name="Id"></param> /// <returns></returns> public SysDic FindById(int Id) { return(SysDicDao.FindById(Id)); }