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