/// <summary>
/// 查询列表数据
/// </summary>
/// <param name="nvc">参数集合</param>
/// <returns></returns>
public SysDictionaryListModel Query(NameValueCollection nvc)
{
SysDictionaryListModel model = new SysDictionaryListModel();
MSysDictionary entity = new MSysDictionary();
model.PageSize = CommFun.ToInt(nvc["ps"],
SettingHelper.Instance.GetInt("PageSize", 10)).Value;
model.PageIndex = CommFun.ToInt(nvc["pi"],
SettingHelper.Instance.GetInt("PageIndex", 0)).Value + 1;
entity.SetData(nvc, false);
entity.TrimEmptyProperty();
entity.AddData(":PS", model.PageSize);
entity.AddData(":PI", model.PageIndex);
if (!string.IsNullOrEmpty(nvc["name"]))
{
entity.AddData(":Name", " t.name like '%" + nvc["name"] + "%'");
}
if (!string.IsNullOrEmpty(nvc["type"]))
{
entity.AddData(":Type", " t.type like '%" + nvc["type"] + "%'");
}
model.TotalCount = CommFun.ToInt(handler.GetScalarByXmlTemplate("getCount", entity), 0).GetValueOrDefault();
if (model.TotalCount > 0)
{
model.List = handler.GetDataListByTemplate("getList", entity);
}
return(model);
}
/// <summary>
/// 根据类型名称获取所有的数据
/// </summary>
/// <param name="TypeName"></param>
/// <returns></returns>
public List <MSysDictionary> GetDataListByTypeName(string TypeName)
{
MSysDictionary dic = new MSysDictionary();
dic.Type = TypeName;
return(dbAccess.GetDataList(dic, "{f:value}", MatchMode.Exact, ConnectMode.And));
}
/// <summary>
/// 添加或修改数据,id为空时为添加，否则为修改
/// </summary>
/// <param name="vo">实体数据</param>
/// <returns></returns>
public IResult Save(MSysDictionary vo)
{
IResult result = new Result(false);
bool status = dbAccess.Save(vo) > 0;
if (status)
{
result = new Result(true);
result["id"] = CommFun.GetString(dbAccess.Builder.ODMapConfig.PrimaryKeyField.GetValue(vo));
}
return(result);
}
public List <MSysDictionary> SDOrder(List <MSysDictionary> list)
{
for (int i = list.Count; i > 0; i--)
{
for (int j = 0; j < i - 1; j++)
{
int firstNum = Convert.ToInt32(list[j].Value);
int lastNum = Convert.ToInt32(list[j + 1].Value);
if (firstNum > lastNum)
{
MSysDictionary temp = list[j];
list[j] = list[j + 1];
list[j + 1] = temp;
}
}
}
return(list);
}
/// <summary>
/// 添加或修改数据,id为空时为添加，否则为修改
/// </summary>
/// <param name="id">主键值</param>
/// <param name="vo">实体数据</param>
/// <returns></returns>
public IResult Save(string id, MSysDictionary vo)
{
bool status = false;
IResult result = new Result(status);
if (string.IsNullOrEmpty(id))
{
status = dbAccess.CreateNew(vo);
}
else
{
status = dbAccess.Update(id, vo);
}
if (status)
{
result = new Result(true);
result["id"] = CommFun.GetString(dbAccess.Builder.ODMapConfig.PrimaryKeyField.GetValue(vo));
}
return(result);
}
public IResult Item()
{
try
{
MSysDictionary entity = new MSysDictionary();
entity.SetData(Request.Form);
entity.TrimEmptyProperty();
string id = Request.Form["__id"];
IResult result = SysDictionaryService.Instance.Save(id, entity);
if (result.Status)
{
result.SetSuccessMessage("保存成功");
}
else
{
result.SetErrorMessage("保存失败");
}
return(result);
}
catch (Exception ex)
{
return(new Result(false, ex.Message));
}
}
/// <summary>
/// 获取指定条件的数据集
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="orderBy">排序字段,{f:属性名} asc</param>
/// <param name="mmode">字符串匹配模式 Exact：精确匹配 Vague：模糊匹配</param>
/// <param name="cmode">条件连接字符串 And 或 OR</param>
/// <returns></returns>
public DataSet GetDataSet(MSysDictionary query, string orderBy = "", MatchMode mmode = MatchMode.Exact,
ConnectMode cmode = ConnectMode.And)
{
return(dbAccess.GetDataSet(query, orderBy, mmode, cmode));
}
/// <summary>
/// 查询单实体信息(单实体数据)
/// </summary>
/// <param name="id">主键编号</param>
/// <returns></returns>
public MSysDictionary GetSingleDataByTemplate(string xmlTemplateName, MSysDictionary vo)
{
return(dbAccess.GetSingleDataByTemplate(xmlTemplateName, vo));
}
/// <summary>
/// 根据模版获取DataSet
/// </summary>
/// <param name="xmlTemplateName">模板名称</param>
/// <param name="vo">实体</param>
/// <returns></returns>
public DataSet GetDataSetByTemplate(string xmlTemplateName, MSysDictionary vo)
{
return(dbAccess.GetDataSetByTemplate(xmlTemplateName, vo));
}
/// <summary>
/// 根据模板获取实体信息
/// </summary>
/// <param name="xmlTemplateName">模板名称</param>
/// <param name="vo">实体</param>
/// <returns></returns>
public List <MSysDictionary> GetDataListByTemplate(string xmlTemplateName, MSysDictionary vo)
{
return(dbAccess.GetDataListByTemplate(xmlTemplateName, vo));
}
/// <summary>
/// 根据模板名称获取第一行一列的值
/// </summary>
/// <param name="xmlTemplateName">模板名称</param>
/// <param name="vo">实体</param>
/// <returns></returns>
public object GetScalarByXmlTemplate(string xmlTemplateName, MSysDictionary vo)
{
return(dbAccess.GetScalarByTemplate(xmlTemplateName, vo));
}
/// <summary>
/// 获取指定条件的记录总数
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="mmode">字符串匹配模式 Exact：精确匹配 Vague：模糊匹配</param>
/// <param name="cmode">条件连接字符串 And 或 OR</param>
/// <returns></returns>
public int GetCount(MSysDictionary query, MatchMode mmode = MatchMode.Exact,
ConnectMode cmode = ConnectMode.And)
{
return(dbAccess.GetCount(query, mmode, cmode));
}
/// <summary>
/// 根据主键值修改实体数据
/// </summary>
/// <param name="vo">实体数据</param>
/// <returns></returns>
public bool Update(MSysDictionary vo)
{
return(dbAccess.Update(vo));
}
/// <summary>
/// 添加新数据
/// </summary>
/// <param name="vo">实体数据</param>
/// <returns></returns>
public bool CreateNew(MSysDictionary vo)
{
return(dbAccess.CreateNew(vo));
}
/// <summary>
/// 获取分页数据集
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="pageSize">分页</param>
/// <param name="pageIndex">页索引从1开始</param>
/// <param name="totalCount">总条数</param>
/// <param name="orderBy">排序字段</param>
/// <param name="mmode">字符串匹配模式 Exact：精确匹配 Vague：模糊匹配</param>
/// <param name="cmode">条件连接字符串 And 或 OR</param>
/// <returns></returns>
public DataSet GetPagerDataSet(MSysDictionary query, int pageSize, int pageIndex, out int totalCount, string orderBy = "", MatchMode mmode = MatchMode.Exact,
ConnectMode cmode = ConnectMode.And)
{
totalCount = dbAccess.GetCount(query, mmode, cmode);
return(dbAccess.GetPagerData(query, pageSize, pageIndex, orderBy, mmode, cmode));
}
/// <summary>
/// 保存实体数据
/// </summary>
/// <param name="id">主键编号</param>
/// <param name="entity">实体数据</param>
/// <returns></returns>
public IResult Save(string id, MSysDictionary entity)
{
return(handler.Save(id, entity));
}
