public string GetDicCount()
{
SysDic sysDic = new SysDic()
{
Diccode = "1", Dicname = "1", Dickey = "1", Dicvalue = "1", Dicmeno = "1", Dorder = "1"
};
int count = _sysDicBLL.Add(sysDic);
return("ID:" + count);
}
/// <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="model"></param>
/// <returns></returns>
public bool Add(SysDic model)
{
try
{
WriteConcernResult wcr = mc.Insert(model);
return(!wcr.HasLastErrorMessage);
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(SysDic model)
{
try
{
var query = Query.EQ("_id", model.Id);
BsonDocument bd = BsonExtensionMethods.ToBsonDocument(model);
WriteConcernResult wcr = mc.Update(query, new UpdateDocument(bd));
return(!wcr.HasLastErrorMessage);
}
catch (Exception ex)
{
return(false);
}
}
public SysDic CreatOrUpdate(SysDic sysDic)
{
var nSys = _responsitory.Where(p => p.Code == sysDic.Code).First();
if (sysDic.Id >= 0)
{
if (nSys != null && nSys.Id != sysDic.Id)
{
throw new DbException("编码已存在!");
}
}
else if (nSys != null)
{
throw new DbException("编码已存在!");
}
var result = _responsitory.InsertOrUpdate(sysDic);
return(result);
}
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 bool IsExistCategory(SysDic obj)
{
string sql = "";
sql = @"
SELECT * FROM dbo.SysDic WHERE Type='CategoryOfTechnology' AND Name=@Name
";
var cmd = CommandHelper.CreateText <SysDic>(FetchType.Fetch, sql);
cmd.Params.Add("@Name", obj.Name);
var result = DbContext.GetInstance().Execute(cmd);
if (result.Entities.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(SysDic model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Add(SysDic model)
{
dal.Add(model);
return(true);
}
