public static bool GetAllSongDT()
{
string jsonText = CrazyKTVWCF.QuerySong(null, null, null, null, 0, 1000000, "Song_Id");
GuiGlobal.AllSongDT = GlobalFunctions.JsontoDataTable(jsonText);
if (GuiGlobal.AllSongDT == null)
{
return(false);
}
System.Threading.Thread.Sleep(200);
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_SingerType=3", 0, 1000000, "Song_Id");
GuiGlobal.ChorusSongDT = GlobalFunctions.JsontoDataTable(jsonText);
if (GuiGlobal.ChorusSongDT == null)
{
return(false);
}
System.Threading.Thread.Sleep(200);
foreach (string langstr in GuiGlobal.SongLangList)
{
jsonText = CrazyKTVWCF.QuerySong(langstr, null, null, null, 0, GuiGlobal.MaxNewSongRows, "Song_CreatDate desc, Song_SongName");
if (GlobalFunctions.JsontoDataTable(jsonText) == null)
{
return(false);
}
GuiGlobal.NewSongDT.Merge(GlobalFunctions.JsontoDataTable(jsonText));
System.Threading.Thread.Sleep(200);
}
foreach (string langstr in GuiGlobal.SongLangList)
{
jsonText = CrazyKTVWCF.QuerySong(langstr, null, null, "Song_PlayCount >= 1", 0, GuiGlobal.MaxTopSongRows, "Song_PlayCount desc, Song_SongName");
if (GlobalFunctions.JsontoDataTable(jsonText) == null)
{
return(false);
}
GuiGlobal.TopSongDT.Merge(GlobalFunctions.JsontoDataTable(jsonText));
System.Threading.Thread.Sleep(200);
}
return(true);
}
private void SingerSongList(int page, int rows, string Singer_Name)
{
string jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_Singer like '%" + Singer_Name.Trim() + "%'", page, rows, "Song_Singer, Song_SongName"); //more than 2000 per rows will be super slow
DataTable dt3 = GlobalFunctions.JsontoDataTable(jsonText);
DataView dv3 = new DataView(dt3);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView1.DataSource = dv3;
GridView1.DataBind();
if (dv3.Count == rows)
{
BNext.Visible = true;
if (page > 0)
{
BPrevious.Visible = true;
}
else
{
BPrevious.Visible = false;
}
}
else
{
BNext.Visible = false;
if (page > 0)
{
BPrevious.Visible = true;
}
else
{
BPrevious.Visible = false;
}
}
}
private void songList(int page, int rows)
{
findCaller.Value = "toTop";
//pre-set
hideAllGridViewPanel();
Panel2.Visible = true;
int currentPageNumber = page;
int rowsPerPage = rows;
try
{
string jsonText = "";
gvMode.Value = "";
if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Song".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_SongName like '%" + tSearch.Text.ToString().Trim() + "%'", currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName"); //more than 2000 per rows will be super slow
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Singer".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_Singer like '%" + tSearch.Text.ToString().Trim() + "%'", page, rows, "Song_Singer, Song_WordCount,Song_SongStroke, Song_SongName"); //more than 2000 per rows will be super slow
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "NewSongs".ToLower())
{
tSearch.Text = "";
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_CreatDate >= '" + DateTime.Now.AddDays(-120).ToString("yyyy/MM/dd") + "'", currentPageNumber, rowsPerPage, "Song_CreatDate desc, Song_SongName"); //more than 2000 per rows will be super slow
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "male".ToLower())
{
hideAllGridViewPanel();
Panel4.Visible = true;
tSearch.Text = "";
jsonText = CrazyKTVWCF.QuerySinger("Singer_Type=0", 0, 2000, "Singer_Strokes, Singer_Name");
DataTable dt3 = GlobalFunctions.JsontoDataTable(jsonText);
DataView dv3 = new DataView(dt3);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView3.DataSource = dv3;
GridView3.DataBind();
//ddSearchType.SelectedIndex = 1;
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "female".ToLower())
{
hideAllGridViewPanel();
Panel4.Visible = true;
tSearch.Text = "";
jsonText = CrazyKTVWCF.QuerySinger("Singer_Type=1", 0, 2000, "Singer_Strokes, Singer_Name");
DataTable dt3 = GlobalFunctions.JsontoDataTable(jsonText);
DataView dv3 = new DataView(dt3);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView3.DataSource = dv3;
GridView3.DataBind();
//ddSearchType.SelectedIndex = 1;
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Group".ToLower())
{
hideAllGridViewPanel();
Panel4.Visible = true;
tSearch.Text = "";
jsonText = CrazyKTVWCF.QuerySinger("Singer_Type=2", 0, 2000, "Singer_Strokes, Singer_Name");
DataTable dt3 = GlobalFunctions.JsontoDataTable(jsonText);
DataView dv3 = new DataView(dt3);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView3.DataSource = dv3;
GridView3.DataBind();
//ddSearchType.SelectedIndex = 1;
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "chorus".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_SingerType=3", currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke, Song_SongName, Song_Singer, Song_CreatDate desc"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "wordcount".ToLower())
{
if (tSearch.Text.ToString().Trim().Length > 0)
{
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_WordCount=" + tSearch.Text.ToString().Trim(), currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName,Song_CreatDate desc"); //more than 2000 per rows will be super slow
}
else
{
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_Singer like '%'", currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName,Song_CreatDate desc"); //more than 2000 per rows will be super slow
}
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "toporder".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong(null, null, null, "Song_PlayCount >= 1 ", currentPageNumber, rowsPerPage, "Song_PlayCount desc, Song_CreatDate desc, Song_SongStroke, Song_SongName"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Mandarin".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("國語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount, Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Taiwanese".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("台語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Cantonese".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("粵語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Japanese".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("日語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "English".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("英語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Haka".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("客語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Local".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("原住民語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Korean".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("韓語", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Kid".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("兒歌", null, null, null, currentPageNumber, rowsPerPage, "Song_WordCount,Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "OtherLangs".ToLower())
{
jsonText = CrazyKTVWCF.QuerySong("其它", null, null, null, currentPageNumber, rowsPerPage, "Song_SongStroke,Song_SongName, Song_Singer"); //more than 2000 per rows will be super slow
tSearch.Text = "";
}
else if (ddSearchType.SelectedValue.ToString().Trim().ToLower() == "Favorites".ToLower())
{
tSearch.Text = "";
hideAllGridViewPanel();
Panel3.Visible = true;
jsonText = CrazyKTVWCF.FavoriteUser(0, 200);
DataTable dt2 = GlobalFunctions.JsontoDataTable(jsonText);
DataView dv2 = new DataView(dt2);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView2.DataSource = dv2;
GridView2.DataBind();
}
//jsonText = jsonText.TrimStart('"');
//jsonText = jsonText.TrimEnd('"');
//jsonText = Regex.Replace(jsonText, @"\\""", @"""");
try
{
DataTable dt = GlobalFunctions.JsontoDataTable(jsonText);
DataView dv = new DataView(dt);
//dv.Sort = "Song_Singer asc, Song_SongName asc, Song_Id asc";
GridView1.DataSource = dv;
GridView1.DataBind();
if (dv.Count == rows)
{
BNext.Visible = true;
if (page > 0)
{
BPrevious.Visible = true;
}
else
{
BPrevious.Visible = false;
}
}
else
{
BNext.Visible = false;
if (page > 0)
{
BPrevious.Visible = true;
}
else
{
BPrevious.Visible = false;
}
}
}
catch { }
}
catch { }
// GlobalFunctions.DerializetoDataTable(); //test data
}