// ------------------------------------------------------- // 查询 // ------------------------------------------------------- #region 函数:FindAllByEntityId(XmlDocument doc) /// <summary>获取列表信息</summary> /// <param name="doc">Xml 文档对象</param> /// <returns>返回操作结果</returns> public string FindAllByEntityId(XmlDocument doc) { StringBuilder outString = new StringBuilder(); string customTableName = XmlHelper.Fetch("customTableName", doc); string entityId = XmlHelper.Fetch("entityId", doc); string entityClassName = XmlHelper.Fetch("entityClassName", doc); DataResultMapper mapper = DataResultMapper.CreateMapper(doc.DocumentElement); IList <IEntityClickInfo> list = null; if (mapper.Count == 0) { list = this.service.FindAllByEntityId(customTableName, entityId, entityClassName); } else { list = this.service.FindAllByEntityId(customTableName, entityId, entityClassName, mapper); } outString.Append("{\"data\":" + AjaxUtil.Parse <IEntityClickInfo>(list) + ","); outString.Append("\"message\":{\"returnCode\":0,\"value\":\"查询成功.\"}}"); return(outString.ToString()); }
// ------------------------------------------------------- // 查询 // ------------------------------------------------------- #region 函数:FindAllByDocToken(XmlDocument doc) /// <summary>获取列表信息</summary> /// <param name="doc">Xml 文档对象</param> /// <returns>返回操作结果</returns> public string FindAllByDocToken(XmlDocument doc) { StringBuilder outString = new StringBuilder(); string customTableName = XmlHelper.Fetch("customTableName", doc); string docToken = XmlHelper.Fetch("docToken", doc); DataResultMapper mapper = DataResultMapper.CreateMapper(doc.DocumentElement); IList <IEntityDocObjectInfo> list = null; if (mapper.Count == 0) { list = this.service.FindAllByDocToken(customTableName, docToken); } else { list = this.service.FindAllByDocToken(customTableName, docToken, mapper); } outString.Append("{\"data\":" + AjaxUtil.Parse <IEntityDocObjectInfo>(list) + ","); outString.Append(MessageObject.Stringify("0", I18n.Strings["msg_query_success"], true) + "}"); return(outString.ToString()); }
/// <summary>查询所有相关记录</summary> /// <param name="customTableName">自定义数据表名称</param> /// <param name="entityId">实体类标识</param> /// <param name="entityClassName">实体类名称</param> /// <returns>返回所有实例<see cref="IEntityClickInfo"/>的详细信息</returns> public IList <IEntityClickInfo> FindAllByEntityId(string customTableName, string entityId, string entityClassName, DataResultMapper mapper) { string whereClause = string.Format(" {0} = ##{1}## AND {2} = ##{3}## ORDER BY {4} DESC ", mapper["EntityId"].DataColumnName, entityId, mapper["EntityClassName"].DataColumnName, entityClassName, mapper["ModifiedDate"].DataColumnName); Dictionary <string, object> args = new Dictionary <string, object>(); args.Add("CustomTableName", StringHelper.ToSafeSQL(customTableName)); args.Add("DataColumnSql", StringHelper.ToSafeSQL(mapper.GetDataColumnSql())); args.Add("WhereClause", StringHelper.ToSafeSQL(whereClause)); args.Add("Length", 0); return(this.ibatisMapper.QueryForList <IEntityClickInfo>(StringHelper.ToProcedurePrefix(string.Format("{0}_FindAll", tableName)), args)); }
/// <summary>查询所有相关记录</summary> /// <param name="customTableName">自定义数据表名称</param> /// <param name="docToken">文档全局标识</param> /// <param name="mapper">数据结果映射器</param> /// <returns>返回所有实例<see cref="IEntityDocObjectInfo"/>的详细信息</returns> public IList <IEntityDocObjectInfo> FindAllByDocToken(string customTableName, string docToken, DataResultMapper mapper) { string whereClause = string.Format(" {0} = ##{1}## ORDER BY CreatedDate ", mapper["DocToken"].DataColumnName, docToken); Dictionary <string, object> args = new Dictionary <string, object>(); args.Add("CustomTableName", StringHelper.ToSafeSQL(customTableName)); args.Add("DataColumnSql", StringHelper.ToSafeSQL(mapper.GetDataColumnSql())); args.Add("WhereClause", StringHelper.ToSafeSQL(whereClause)); args.Add("Length", 0); return(ibatisMapper.QueryForList <IEntityDocObjectInfo>(StringHelper.ToProcedurePrefix(string.Format("{0}_FindAll", tableName)), args)); }
/// <summary>查询所有相关记录</summary> /// <param name="customTableName">自定义数据表名称</param> /// <param name="entityId">实体类标识</param> /// <param name="entityClassName">实体类名称</param> /// <param name="mapper">数据结果映射器</param> /// <returns>返回所有实例<see cref="IEntityClickInfo"/>的详细信息</returns> public IList <IEntityClickInfo> FindAllByEntityId(string customTableName, string entityId, string entityClassName, DataResultMapper mapper) { return(this.provider.FindAllByEntityId(customTableName, entityId, entityClassName, mapper)); }
/// <summary>查询所有相关记录</summary> /// <param name="customTableName">自定义数据表名称</param> /// <param name="docToken">文档全局标识</param> /// <param name="mapper">数据结果映射器</param> /// <returns>返回所有实例<see cref="IEntityDocObjectInfo"/>的详细信息</returns> public IList <IEntityDocObjectInfo> FindAllByDocToken(string customTableName, string docToken, DataResultMapper mapper) { return(this.provider.FindAllByDocToken(customTableName, docToken, mapper)); }