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