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 + ")")); }