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