public List <TextInfoBean> QueryDataByMarkId(TextEnum textEnum, long[] markIds)
{
InitTableByTextType(textEnum);
string values = TypeConversionUtil.ArrayToStringBySplit(markIds, ",");
return(BaseQueryData <TextInfoBean>("text_id", tableNameForMain + ".mark_id", "in", "(" + values + ")"));
}
/// <summary>
/// 根据ID查询数据
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public List <ItemsInfoBean> QueryDataByIds(long[] ids)
{
string[] leftTable = new string[] { tableNameForLeft, mLeftIntactTableName };
string[] mainKey = new string[] { "id", "intact_id" };
string[] leftKey = new string[] { "items_id", "intact_id" };
string[] colName = new string[] { tableNameForMain + ".id" };
string[] operations = new string[] { "IN" };
string values = TypeConversionUtil.ArrayToStringBySplit(ids, ",");
string[] colValue = new string[] { "(" + values + ")" };
return(SQLiteHandle.LoadTableData <ItemsInfoBean>(ProjectConfigInfo.DATA_BASE_INFO_NAME, tableNameForMain, leftTable, mainKey, leftKey, colName, operations, colValue));
}
/// <summary>
/// 根据ID查询数据
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public List <BuildingInfoBean> QueryDataByIds(long[] ids)
{
string values = TypeConversionUtil.ArrayToStringBySplit(ids, ",");
return(BaseQueryData <BuildingInfoBean>("id", "IN", $"({values})"));
}
/// <summary>
/// 根据Type查询数据
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public List <NpcInfoBean> QueryDataByType(int[] type)
{
string values = TypeConversionUtil.ArrayToStringBySplit(type, ",");
return(BaseQueryData <NpcInfoBean>("npc_id", tableNameForMain + ".npc_type", "IN", "(" + values + ")"));
}
/// <summary>
/// 根据ID查询数据
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public List <NpcInfoBean> QueryDataByIds(long[] ids)
{
string values = TypeConversionUtil.ArrayToStringBySplit(ids, ",");
return(BaseQueryData <NpcInfoBean>("npc_id", tableNameForMain + ".id", "IN", "(" + values + ")"));
}
/// <summary>
/// 根据Id查询数据
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public List <NpcTeamBean> QueryDataById(long[] teamId)
{
string values = TypeConversionUtil.ArrayToStringBySplit(teamId, ",");
return(BaseQueryData <NpcTeamBean>("team_id", tableNameForMain + ".valid", "=", "1", tableNameForMain + ".id", "in", "(" + values + ")"));
}