protected void Page_Load( object sender, EventArgs e )
{
BLL.Game BllGame = new BLL.Game();
fullUrl = BllGame.GetDownUrl("dianxindown");
smallUrl = BllGame.GetDownUrl("wangtongdown");
//if( !string.IsNullOrEmpty( UserLoginInfo.UserID ) )
//{
// loginId.Visible = false;
//}
}
protected void Page_Load(object sender, EventArgs e)
{
BLL.Game BllGame = new BLL.Game();
fullUrl = BllGame.GetDownUrl("dianxindown");
smallUrl = BllGame.GetDownUrl("wangtongdown");
//if( !string.IsNullOrEmpty( UserLoginInfo.UserID ) )
//{
// loginId.Visible = false;
//}
}
//游戏名称集合
public void BindGameNames()
{
DataTable dt = new BLL.Game().ListTGameNameInfo(0);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlNameID.Items.Add(new ListItem(dt.Rows[i]["ComName"].ToString(), dt.Rows[i]["NameID"].ToString()));
}
}
ddlNameID.Items.Insert(0, new ListItem("--请选择--", "-1"));
}
//绑定数据
private void ShowInfo()
{
Model.User userMod = new Model.User();
BLL.User userBll = new BLL.User();
Model.Game gMod = new Model.Game();
BLL.Game gBll = new BLL.Game();
//gMod = gBll.GetModel(Convert.ToInt32(modelExtend.gameID));
this.lbChanelName.Text = modelExtend.ChanelName;
this.lbgamename.Text = modelExtend.gameName;
}
public void BindGameInfo()
{
string id = Utility.Common.SqlEncode(Utility.Common.GetStringOfUrl("id"));
if (string.IsNullOrEmpty(id) || !Utility.Common.IsNumber(id))
{
Response.Write("<script>history.back();</script>");
Response.End();
return;
}
DataRow dr = new BLL.Game().GetInfo(id);
if (dr != null)
{
GameName = dr["Game_Name"].ToString();
GameDownAddress = dr["Down_Address"].ToString();
GameInfo2 = dr["Game_Info"].ToString();
GameRule = dr["Game_Rule"].ToString();
}
}
//绑定数据
private void ShowInfo()
{
Model.User userMod = new Model.User();
BLL.User userBll = new BLL.User();
Model.Game gMod = new Model.Game();
BLL.Game gBll = new BLL.Game();
//gMod = gBll.GetModel(Convert.ToInt32(model.gameID));
this.lbChanel.Text = model.ChanelName;
this.lbGameName.Text = model.gameName;
this.ddlStatus.SelectedValue = model.Status;
this.ddlUpdateType.SelectedValue = model.UpdateType;
this.txtBak1.Text = model.Bak1;
this.txtVersion.Text = model.version;
if (model.Bak2 != "")
{
this.ddlMenu.SelectedValue = model.Bak2;
this.ddlChanel.SelectedValue = model.Bak3;
this.ddlGame.SelectedValue = model.Bak4;
}
this.txtScale.Text = model.Bak5;
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt;
if (Session["gamelist"] == null)
{
dt = new BLL.Game().List(0);
Session["gamelist"] = dt;
}
else
{
dt = (DataTable)Session["gamelist"];
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
strUrl = strUrl + "/GameInfo.aspx?id=" + row["Game_id"].ToString() + ",";
strSrc = strSrc + row["Image_URL"].ToString() + ",";
}
}
}
protected void Page_Load( object sender, EventArgs e )
{
DataTable dt;
if (Session["gamelist"] == null)
{
dt = new BLL.Game().List(0);
Session["gamelist"] = dt;
}
else
{
dt = (DataTable)Session["gamelist"];
}
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
strUrl =strUrl+ "/GameInfo.aspx?id=" + row["Game_id"].ToString() + ",";
strSrc =strSrc+ row["Image_URL"].ToString() + ",";
}
}
}
public void BindGameInfo()
{
string id = Utility.Common.SqlEncode( Utility.Common.GetStringOfUrl( "id" ) );
if( string.IsNullOrEmpty( id ) || !Utility.Common.IsNumber( id ) )
{
Response.Write( "<script>history.back();</script>" );
Response.End();
return;
}
DataRow dr = new BLL.Game().GetInfo( id );
if( dr != null )
{
GameName = dr["Game_Name"].ToString();
GameDownAddress = dr["Down_Address"].ToString();
GameInfo2 = dr["Game_Info"].ToString();
GameRule = dr["Game_Rule"].ToString();
}
}
protected void CreateHtml(object sender, EventArgs e)
{
try
{
//文件存放根目录
string RootFilePath = "/Html/Ranking/";
//域名
string domain = Request.Url.OriginalString.ToLower().Replace("/admin/sconfig/createranking.aspx", ""); //System.Configuration.ConfigurationSettings.AppSettings["Domain"].TrimEnd( '/' );
//Ranking.aspx
System.Net.WebRequest rq = System.Net.WebRequest.Create(domain + "/Ranking2.aspx");
System.Net.HttpWebResponse rp = (System.Net.HttpWebResponse)rq.GetResponse();
System.IO.Stream pageStream = rp.GetResponseStream();
using (System.IO.StreamReader sr = new System.IO.StreamReader(pageStream))
{
//读取
string tmp = sr.ReadToEnd();
//无参数的Ranking.html
string path = HttpContext.Current.Server.MapPath(RootFilePath + "Ranking.html");
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(path, false, System.Text.Encoding.UTF8))
{
sw.Write(tmp);
}
}
rq.Abort();
rp.Close();
pageStream.Close();
//RankFascination.aspx
rq = System.Net.WebRequest.Create(domain + "/RankFascination2.aspx");
rp = (System.Net.HttpWebResponse)rq.GetResponse();
pageStream = rp.GetResponseStream();
using (System.IO.StreamReader sr = new System.IO.StreamReader(pageStream))
{
//读取
string tmp = sr.ReadToEnd();
//无参数的Ranking.html
string path = HttpContext.Current.Server.MapPath(RootFilePath + "RankFascination.html");
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(path, false, System.Text.Encoding.UTF8))
{
sw.Write(tmp);
}
}
rq.Abort();
rp.Close();
pageStream.Close();
//RankGameTime.aspx
rq = System.Net.WebRequest.Create(domain + "/RankGameTime2.aspx");
rp = (System.Net.HttpWebResponse)rq.GetResponse();
pageStream = rp.GetResponseStream();
using (System.IO.StreamReader sr = new System.IO.StreamReader(pageStream))
{
//读取
string tmp = sr.ReadToEnd();
//无参数的Ranking.html
string path = HttpContext.Current.Server.MapPath(RootFilePath + "RankGameTime.html");
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(path, false, System.Text.Encoding.UTF8))
{
sw.Write(tmp);
}
}
rq.Abort();
rp.Close();
pageStream.Close();
//RankMoney.aspx
rq = System.Net.WebRequest.Create(domain + "/RankMoney2.aspx");
rp = (System.Net.HttpWebResponse)rq.GetResponse();
pageStream = rp.GetResponseStream();
using (System.IO.StreamReader sr = new System.IO.StreamReader(pageStream))
{
//读取
string tmp = sr.ReadToEnd();
//无参数的Ranking.html
string path = HttpContext.Current.Server.MapPath(RootFilePath + "RankMoney.html");
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(path, false, System.Text.Encoding.UTF8))
{
sw.Write(tmp);
}
}
rq.Abort();
rp.Close();
pageStream.Close();
//RankOnLineTime.aspx
rq = System.Net.WebRequest.Create(domain + "/RankOnLineTime2.aspx");
rp = (System.Net.HttpWebResponse)rq.GetResponse();
pageStream = rp.GetResponseStream();
using (System.IO.StreamReader sr = new System.IO.StreamReader(pageStream))
{
//读取
string tmp = sr.ReadToEnd();
//无参数的Ranking.html
string path = HttpContext.Current.Server.MapPath(RootFilePath + "RankOnLineTime.html");
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(path, false, System.Text.Encoding.UTF8))
{
sw.Write(tmp);
}
}
rq.Abort();
rp.Close();
pageStream.Close();
//Ranking带参数的页面输出开始
System.Data.DataTable dt;
object dtCache = HttpContext.Current.Cache.Get("GameIDList"); //BCST.Cache.BCSTCache.Default.Get<BCST.Cache.AspNetCache>("GameIDList");
if (dtCache == null)
{
//重新读取
dt = new BLL.Game().ListTGameNameInfo(0);
HttpContext.Current.Cache.Insert("GameIDList", dt, null, System.Web.Caching.Cache.NoAbsoluteExpiration, new TimeSpan(12, 0, 0));
}
else
{
dt = (System.Data.DataTable)dtCache;
}
foreach (System.Data.DataRow row in dt.Rows)
{
rq = System.Net.WebRequest.Create(domain + "/Ranking2.aspx?id=" + row["NameID"].ToString() + "&name=" + Server.UrlEncode(row["ComName"].ToString()));
rp = (System.Net.HttpWebResponse)rq.GetResponse();
pageStream = rp.GetResponseStream();
using (System.IO.StreamReader sr = new System.IO.StreamReader(pageStream))
{
//读取
string tmp = sr.ReadToEnd();
//无参数的Ranking.html
string path = HttpContext.Current.Server.MapPath(RootFilePath + "Ranking_" + row["NameID"].ToString() + ".html");
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(path, false, System.Text.Encoding.UTF8))
{
sw.Write(tmp);
}
}
rq.Abort();
rp.Close();
pageStream.Close();
}
msg.Text = "全部生成成功！"+DateTime.Now;
msg.ForeColor = System.Drawing.Color.Green;
}
catch (Exception ex)
{
msg.Text = "生成失败："+ex.Message;
}
}
/// <summary>
/// 数据集操作
/// </summary>
/// <param name="ds"></param>
private void DataSetOperator(DataSet ds, string filePath)
{
int k = 0;
if (ds.Tables[0].Rows.Count < 1)
{
JscriptMsg(350, 230, "错误提示", "<b>没有数据！</b>", "back", "Error");
return;
}
try
{
string strPlatform=this.ddlPlatform.SelectedValue;
//string strFirstLetter=this.ddlFirstLetter.SelectedValue;
ArrayList SQLStringList1 = new ArrayList();
Spread.BLL.Game bllGame = new BLL.Game();
bllGame.DeletByPlatform(strPlatform);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
k++;
string sqlStr1 = "insert into Game(Name,Platform,FirstLetter,UpdateDate,IsLock)";
sqlStr1 += "values ('" + ds.Tables[0].Rows[i][1].ToString().Trim() + "',";
sqlStr1 += "'" + strPlatform + "',";
sqlStr1 += "'" + ds.Tables[0].Rows[i][0].ToString().Trim() + "',";
sqlStr1 += "'" + DateTime.Now + "',";
sqlStr1 += "'False')";//其他备注
SQLStringList1.Add(sqlStr1);
}
DbHelper.ExecuteSqlTran(SQLStringList1);
}
catch (Exception ex)
{
JscriptMsg(350, 230, "错误提示", "<b>没有数据！" + ex.Message + "</b>", "back", "Error");
}
finally
{
JscriptMsg(350, 230, "上传成功", "上传成功" + k + "条", "back", "Error");
File.Delete(filePath);
}
}
