/// <summary>
/// 获取所有的UI文本
/// </summary>
/// <returns></returns>
public static Dictionary <long, UITextBean> LoadAllUIText()
{
List <UITextBean> listData = new List <UITextBean>();
GameLanguageEnum language = CommonConfigure.GameLanguage;
string detailsTableName = CommonDB.PuzzleInfoDB_UITextContent_Table;
if (language.Equals(GameLanguageEnum.Chinese))
{
detailsTableName += "_cn";
}
else if (language.Equals(GameLanguageEnum.English))
{
detailsTableName += "_en";
}
else if (language.Equals(GameLanguageEnum.German))
{
detailsTableName += "_gn";
}
else if (language.Equals(GameLanguageEnum.Japanese))
{
detailsTableName += "_jn";
}
else if (language.Equals(GameLanguageEnum.Russian))
{
detailsTableName += "_rn";
}
else if (language.Equals(GameLanguageEnum.Polish))
{
detailsTableName += "_pn";
}
else if (language.Equals(GameLanguageEnum.French))
{
detailsTableName += "_fn";
}
listData = SQliteHandle.LoadTableData <UITextBean>
(
CommonDB.PuzzleInfoDB_Name,
CommonDB.PuzzleInfoDB_PuzzlesBase_Table,
new string[] { detailsTableName },
"id",
new string[] { "text_id" }
);
Dictionary <long, UITextBean> mapData = new Dictionary <long, UITextBean>();
if (listData != null && listData.Count > 0)
{
int listDataSize = listData.Count;
for (int i = 0; i < listDataSize; i++)
{
UITextBean itemData = listData[i];
if (itemData.Text_id != 0)
{
mapData.Add(itemData.Text_id, itemData);
}
}
}
return(mapData);
}
/// <summary>
/// 更新所有拼图状态为有效
/// </summary>
public static void UpdateAllPuzzlesToValid()
{
SQliteHandle.UpdateTableData
(
CommonDB.PuzzleInfoDB_Name,
CommonDB.PuzzleInfoDB_PuzzlesBase_Table,
new string[] { "valid" }, new string[] { "1" }
);
}
/// <summary>
/// 获取所有拼图数据
/// </summary>
/// <returns></returns>
public static List <PuzzlesInfoBean> LoadAllPuzzlesData()
{
List <PuzzlesInfoBean> listData = new List <PuzzlesInfoBean>();
listData = SQliteHandle.LoadTableData <PuzzlesInfoBean>
(
CommonDB.PuzzleInfoDB_Name,
CommonDB.PuzzleInfoDB_PuzzlesBase_Table
);
return(listData);
}
/// <summary>
/// 查询指定拼图信息
/// <param name="id"></param>
/// <returns></returns>
public static List <PuzzlesInfoBean> LoadBasePuzzlesDataById(long id)
{
List <PuzzlesInfoBean> listData = new List <PuzzlesInfoBean>();
listData = SQliteHandle.LoadTableData <PuzzlesInfoBean>
(
CommonDB.PuzzleInfoDB_Name,
CommonDB.PuzzleInfoDB_PuzzlesBase_Table,
new string[] { " id " },
new string[] { " = " },
new string[] { id + "" }
);
return(listData);
}
/// <summary>
/// 查询指定BGM信息
/// </summary>
/// <param name="bGMEnum"></param>
/// <returns></returns>
public static List <BGMInfoBean> LoadBGMInfo(long bgmId)
{
List <BGMInfoBean> listData = new List <BGMInfoBean>();
listData = SQliteHandle.LoadTableData <BGMInfoBean>
(
CommonDB.PuzzleInfoDB_Name,
CommonDB.PuzzleInfoDB_BGMInfo_Table,
new string[] { " id " },
new string[] { " = " },
new string[] { bgmId + " " }
);
return(listData);
}
/// <summary>
/// 查询所有BGM信息
/// </summary>
/// <returns></returns>
public static List <BGMInfoBean> LoadAllBGMInfo()
{
List <BGMInfoBean> listData = new List <BGMInfoBean>();
listData = SQliteHandle.LoadTableData <BGMInfoBean>
(
CommonDB.PuzzleInfoDB_Name,
CommonDB.PuzzleInfoDB_BGMInfo_Table,
new string[] { "valid" },
new string[] { " = " },
new string[] { "1" }
);
return(listData);
}
/// <summary>
/// 获取拼图图片数据
/// </summary>
/// <param name="language"></param>
/// <param name="resourcesType"></param>
/// <returns></returns>
public static List <PuzzlesInfoBean> LoadAllPuzzlesDataByType(JigsawResourcesEnum resourcesType)
{
List <PuzzlesInfoBean> listData = new List <PuzzlesInfoBean>();
GameLanguageEnum language = CommonConfigure.GameLanguage;
string detailsTableName = "";
if (resourcesType.Equals(JigsawResourcesEnum.Painting))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_Painting_Table;
}
else if (resourcesType.Equals(JigsawResourcesEnum.Movie))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_Movie_Table;
}
else if (resourcesType.Equals(JigsawResourcesEnum.Celebrity))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_Celebrity_Table;
}
else if (resourcesType.Equals(JigsawResourcesEnum.Other))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_Other_Table;
}
else if (resourcesType.Equals(JigsawResourcesEnum.Animal))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_Animal_Table;
}
else if (resourcesType.Equals(JigsawResourcesEnum.Scenery))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_Scenery_Table;
}
else if (resourcesType.Equals(JigsawResourcesEnum.Food))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_Food_Table;
}
else if (resourcesType.Equals(JigsawResourcesEnum.StarrySky))
{
detailsTableName = CommonDB.PuzzleInfoDB_Details_StarrySky_Table;
}
else
{
return(null);
}
if (language.Equals(GameLanguageEnum.Chinese))
{
detailsTableName += "_cn";
}
else if (language.Equals(GameLanguageEnum.English))
{
detailsTableName += "_en";
}
else if (language.Equals(GameLanguageEnum.French))
{
detailsTableName += "_fn";
}
else if (language.Equals(GameLanguageEnum.German))
{
detailsTableName += "_gn";
}
else if (language.Equals(GameLanguageEnum.Japanese))
{
detailsTableName += "_jn";
}
else if (language.Equals(GameLanguageEnum.Polish))
{
detailsTableName += "_pn";
}
else if (language.Equals(GameLanguageEnum.Russian))
{
detailsTableName += "_rn";
}
listData = SQliteHandle.LoadTableData <PuzzlesInfoBean>
(
CommonDB.PuzzleInfoDB_Name,
CommonDB.PuzzleInfoDB_PuzzlesBase_Table,
new string[] { detailsTableName },
"id",
new string[] { "puzzles_id" },
new string[] { "data_type", "valid" },
new string[] { "=", "=" },
new string[] { (int)resourcesType + "", "1" }
);
return(listData);
}
