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