Example #1
0
    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 + ")"));
    }
Example #2
0
    /// <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})"));
    }
Example #4
0
    /// <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 + ")"));
    }
Example #5
0
    /// <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 + ")"));
    }
Example #6
0
    /// <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 + ")"));
    }