private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { string str = new system().ChkSql(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhcmember..web_agent where userid='" + str + "'"); if (reader.Read()) { this.lblid.Text = reader["id"].ToString(); this.tbuserid.Text = reader["userid"].ToString(); this.tbpassword.Text = reader["password"].ToString(); this.tbagentkey.Text = reader["agentkey"].ToString(); this.tbname.Text = reader["name"].ToString(); this.tbqq.Text = reader["qq"].ToString(); this.tbmsn.Text = reader["msn"].ToString(); this.tbhandphone.Text = reader["handphone"].ToString(); this.tbtelephone.Text = reader["telephone"].ToString(); this.tbaddress.Text = reader["address"].ToString(); this.tbbankinfo.Text = reader["bankinfo"].ToString(); this.tbother.Text = reader["other"].ToString(); this.tbgold.Text = reader["gold"].ToString(); this.ddnation.SelectedValue = reader["nation"].ToString(); this.ddstate.SelectedValue = reader["state"].ToString(); this.btnadd.Visible = false; this.btnedit.Visible = true; } reader.Close(); providers.CloseConn(); }
private void btnLogin_ServerClick(object sender, EventArgs e) { DataProviders providers = new DataProviders(); system system = new system(); WebLogic logic = new WebLogic(); string adminid = system.ChkSql(this.admin_id.Value.ToString()); string password = system.ChkSql(this.admin_pwd.Value.ToString()); if (this.vcode.Value != this.Session["VerifyCode"].ToString()) { base.Response.Write("<script language=javascript>alert(\"驗證碼錯誤!\")</script>"); } else { logic.log("", "", adminid, 0, "登陸後臺", this.Page.Request.UserHostAddress.ToString(), "後台登陸日誌"); logic.log("", "", adminid, 0, "登陸後臺", system.GetClientIP(), "後台登陸日誌"); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhcmember..web_login where userid='" + adminid + "' and password='******' and state=1"); if (reader.Read()) { this.Session.Timeout = 600; this.Session["admin_id"] = reader["userid"].ToString(); this.Session["admin_name"] = reader["name"].ToString(); this.Session["admin_ip"] = system.GetClientIP(); base.Response.Redirect("cpserverinfo.aspx"); } else { base.Response.Write("<script language=javascript>alert(\"用戶名或密碼錯誤!\")</script>"); } providers.CloseConn(); } }
private void Page_Load(object sender, EventArgs e) { this.gold = "0"; DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select top 1 playerid as gold from (select top 1 playerid,convert(varchar(10),date,120) as date,sum(gold) as gold from mhcmember..web_log where convert(varchar(10),date,120)=convert(varchar(10),getdate(),120) and type='代理發放金幣' group by playerid,convert(varchar(10),date,120) order by sum(gold) desc union select top 1 userid as playerid,convert(varchar(10),date,120) as date,sum(money)*10 as gold from web_alipay where convert(varchar(10),date,120)=convert(varchar(10),getdate(),120) and state=1 group by userid,convert(varchar(10),date,120) order by gold desc) b order by gold desc"); if (reader.Read()) { this.gold = reader["gold"].ToString(); } if (this.gold != "0") { string str = this.gold.Substring(0, 1).ToString(); string str2 = this.gold.Substring(3).ToString(); this.gold = str + "**" + str2; } reader.Close(); reader = providers.ExecuteSqlDataReader("SELECT [id],[name], [nation], '充足' as gold FROM [MHCMEMBER].[dbo].[Web_Agent] where [state]=1"); while (reader.Read()) { this.str = this.str + "<tr height=\"20\"><td width=\"10\"></td>"; string str3 = this.str; this.str = str3 + "<td width=\"241\" align=center height=\"20\"><a href=viewagent.aspx?id=" + reader["id"].ToString() + ">" + reader["name"].ToString() + "</a></td>"; this.str = this.str + "<td width=\"12\"></td></tr>"; } providers.CloseConn(); }
private void ddchalist_SelectedIndexChanged(object sender, EventArgs e) { int num = int.Parse(this.ddchalist.SelectedValue); if (num == 0) { this.lbldex.Text = "0"; this.lblsimmak.Text = "0"; this.lblgengoal.Text = "0"; this.lblsta.Text = "0"; this.lblpoint.Text = "0"; this.tbsimmak.Text = "0"; this.tbdex.Text = "0"; this.tbgengoal.Text = "0"; this.tbsta.Text = "0"; } else { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhgame..tb_character WHERE character_idx=" + num); if (reader.Read()) { this.lbldex.Text = reader["CHARACTER_dex"].ToString(); this.lblsimmak.Text = reader["CHARACTER_simmak"].ToString(); this.lblgengoal.Text = reader["CHARACTER_gengoal"].ToString(); this.lblsta.Text = reader["CHARACTER_sta"].ToString(); this.lblpoint.Text = reader["CHARACTER_GRADEUPPOINT"].ToString(); this.tbsimmak.Text = "0"; this.tbdex.Text = "0"; this.tbgengoal.Text = "0"; this.tbsta.Text = "0"; reader.Close(); providers.CloseConn(); } else { reader.Close(); providers.CloseConn(); } } }
private void Page_Load(object sender, EventArgs e) { new WebLogic().isagent(); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhcmember..web_agent where userid='" + this.Session["agent_id"].ToString() + "'"); if (reader.Read()) { this.gold = reader["gold"].ToString(); } reader.Close(); providers.CloseConn(); }
private void Page_Load(object sender, EventArgs e) { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("SELECT [id],[name] FROM [MHCMEMBER].[dbo].[Web_Agent] where [state]=1"); while (reader.Read()) { this.stragentlist = this.stragentlist + "<tr><td width=\"380\" height=\"23\">"; object stragentlist = this.stragentlist; this.stragentlist = string.Concat(new object[] { stragentlist, "<img src=images/icon_leftmenu_purple.gif><a href=agent.aspx?id=", reader["id"], " target=\"_blank\"> ", reader["name"], "</a></td><td width=\"66\"></td></tr>" }); } reader.Close(); providers.CloseConn(); }
private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { int num = int.Parse(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from TB_OPERIP where ipidx=" + num); if (reader.Read()) { this.lblid.Text = num.ToString(); this.tbip.Text = reader["ipadress"].ToString(); this.btnedit.Visible = true; } reader.Close(); providers.CloseConn(); }
private void Page_Load(object sender, EventArgs e) { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select top 5 substring(name,1,30) as name ,link,convert(char(10),date,111) as date from web_download order by date desc"); while (reader.Read()) { this.strdownloadlist = this.strdownloadlist + "<tr><td width=\"380\" height=\"23\">"; object strdownloadlist = this.strdownloadlist; this.strdownloadlist = string.Concat(new object[] { strdownloadlist, "<a href=\"", reader["link"], "\" target=\"_blank\"><img src=images/icon_leftmenu_purple.gif> ", reader["name"], "...</a></td><td width=\"66\">", reader["date"], "</td></tr>" }); this.strdownloadlist = this.strdownloadlist + "<tr><td colspan=\"2\"><img src=\"images/press_line.gif\" width=\"100%\" height=\"1\"></td></tr>"; } reader.Close(); providers.CloseConn(); }
private void Page_Load(object sender, EventArgs e) { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select top 10 a.id as id,substring(title,1,30) as title ,type,name, convert(char(10),adddate,111) as adddate from web_news a,web_newstype b where a.type=b.id and b.used=1 order by adddate desc"); while (reader.Read()) { object strnewslist = this.strnewslist; this.strnewslist = string.Concat(new object[] { strnewslist, "<tr><td width=\"100%\" height=\"23\"><a href='newslist.aspx?type=", reader["type"], "' class='style32'><strong>[", reader["name"], "]</strong></a>" }); strnewslist = this.strnewslist; this.strnewslist = string.Concat(new object[] { strnewslist, "<a href=\"viewnews.aspx?id=", reader["id"], "\" target=\"_blank\">", reader["title"], "</a></td><td width=\"66\">", reader["adddate"], "</td></tr>" }); this.strnewslist = this.strnewslist + "<tr><td colspan=\"2\"><img src=\"images/press_line.gif\" width=\"100%\" height=\"1\"></td></tr>"; } reader.Close(); providers.CloseConn(); }
private void Page_Load(object sender, EventArgs e) { new system().loadConfig(0); if (!this.Page.IsPostBack) { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select top 10 character_name,character_grade,webchareset from mhgame..tb_character where substring(character_name,1,1)!='@' order by webchareset desc,character_grade desc,character_EXPOINT desc"); for (int i = 1; reader.Read(); i++) { object strhero = this.strhero; this.strhero = string.Concat(new object[] { strhero, "<tr><td width=15% align=left><img src=images/top_", i, ".gif></td><td width=50%><strong>", new system().ConvertToBig5(reader["character_name"].ToString(), 950), "</strong></td><td width=30% align=center>", reader["character_grade"].ToString(), "級", reader["webchareset"], "轉</td></tr>" }); } reader.Close(); providers.CloseConn(); } }
private void Page_Load(object sender, EventArgs e) { if (base.Request.QueryString["id"] != null) { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from web_news" + (" where id=" + int.Parse(base.Request.QueryString["id"]).ToString())); if (reader.Read()) { this.strtitle = reader["title"].ToString(); this.stradddate = reader["adddate"].ToString(); this.strauthor = reader["author"].ToString(); this.strclick = reader["clicks"].ToString(); this.strcontent = reader["content"].ToString(); } reader.Close(); providers.CloseConn(); } }
private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { string str = new system().ChkSql(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from web_login where id=" + str); if (reader.Read()) { this.lblid.Text = reader["id"].ToString(); this.tbuserid.Text = reader["userid"].ToString(); this.tbname.Text = reader["name"].ToString(); this.ddstate.SelectedValue = reader["state"].ToString(); this.btnadd.Visible = false; this.btnedit.Visible = true; } reader.Close(); providers.CloseConn(); }
private void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from web_newstype where used=1"); this.strtypelist = this.strtypelist + "<tr><td><img src=\"images/icon_leftmenu_red.gif\"> <a href=\"newslist.aspx\">☆全部新聞☆</a></td></tr>"; this.strtypelist = this.strtypelist + "<tr><td><img src=\"images/press_line.gif\"></td></tr>"; while (reader.Read()) { object strtypelist = this.strtypelist; this.strtypelist = string.Concat(new object[] { strtypelist, "<tr><td><img src=\"images/icon_leftmenu_red.gif\"> <a href=\"newslist.aspx?type=", reader["id"], "\">☆", reader["name"].ToString(), "☆</a></td></tr>" }); this.strtypelist = this.strtypelist + "<tr><td><img src=\"images/press_line.gif\"></td></tr>"; } reader.Close(); providers.CloseConn(); } }
private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { int num = int.Parse(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from web_download where id=" + num); if (reader.Read()) { this.lblid.Text = num.ToString(); this.tbname.Text = reader["name"].ToString(); this.tblink.Text = reader["link"].ToString(); this.tbsize.Text = reader["size"].ToString(); this.tbcomment.Text = reader["comment"].ToString(); this.cbdate.Visible = true; this.btnedit.Visible = true; } reader.Close(); providers.CloseConn(); }
private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { int num = int.Parse(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhgame..tb_character where character_idx=" + num); if (reader.Read()) { this.tbuseridx.Text = reader["user_idx"].ToString(); this.tbchaidx.Text = reader["character_idx"].ToString(); this.tbchaname.Text = new system().ConvertToBig5(reader["character_name"].ToString(), 950); this.tbguild.Text = new system().ConvertToBig5(reader["character_munpaname"].ToString(), 950); this.tbparty.Text = reader["character_partyidx"].ToString(); if (this.tbguild.Text.ToString() == "") { this.btnsearchguild.Enabled = false; } else { this.btnsearchguild.Enabled = true; } this.ddsex.SelectedValue = reader["character_gender"].ToString(); this.ddstage.SelectedValue = reader["character_stage"].ToString(); this.ddmap.SelectedValue = reader["character_map"].ToString(); this.tbchalv.Text = reader["character_grade"].ToString(); this.tbmoney.Text = reader["character_money"].ToString(); this.tbchareset.Text = reader["webchareset"].ToString(); this.tbnewname.Text = reader["webnewname"].ToString(); this.tbgengoal.Text = reader["character_gengoal"].ToString(); this.tbsta.Text = reader["character_sta"].ToString(); this.tbdex.Text = reader["character_dex"].ToString(); this.tbsimmak.Text = reader["character_simmak"].ToString(); this.tbpoint.Text = reader["character_gradeuppoint"].ToString(); this.tbabilityexp.Text = reader["character_abilityexp"].ToString(); this.tbbadfame.Text = reader["character_badfame"].ToString(); this.tblogouttime.Text = reader["character_lastmodified"].ToString(); this.tbplaytime.Text = reader["character_playtime"].ToString(); } reader.Close(); providers.CloseConn(); }
private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { int num = int.Parse(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from web_news where id=" + num); if (reader.Read()) { this.lblid.Text = num.ToString(); this.tbtitle.Text = reader["title"].ToString(); this.edit.Value = reader["content"].ToString(); this.tbauthor.Text = reader["author"].ToString(); this.DropDownList1.SelectedValue = reader["type"].ToString(); this.btnadd.Visible = false; this.btnedit.Visible = true; this.cbdate.Visible = true; this.btnadd.Visible = true; } reader.Close(); providers.CloseConn(); }
private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { int num = int.Parse(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhcmember..web_item where id=" + num); if (reader.Read()) { this.lblid.Text = num.ToString(); this.tbname.Text = reader["name"].ToString(); this.tbitemid.Text = reader["itemid"].ToString(); this.tbprice.Text = reader["price"].ToString(); this.tbgold.Text = reader["gold"].ToString(); this.tbpic.Text = reader["pic"].ToString(); this.tbcomment.Text = reader["comment"].ToString(); this.DropDownList1.SelectedValue = reader["type"].ToString(); this.DropDownList3.SelectedValue = reader["num"].ToString(); this.btnadd.Visible = true; this.btnedit.Visible = true; } reader.Close(); providers.CloseConn(); }
private void DataGrid1_SelectedIndexChanged(object sender, EventArgs e) { int num = int.Parse(this.DataGrid1.SelectedItem.Cells[0].Text.ToString()); DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhcmember..chr_log_info where propid=" + num); if (reader.Read()) { this.tbuserid.Text = reader["id_loginid"].ToString(); this.tbpassword.Text = reader["id_passwd"].ToString(); this.tbwebkey.Text = reader["webkey"].ToString(); this.tbwebemail.Text = reader["webemail"].ToString(); this.tbwebgold.Text = reader["webgold"].ToString(); this.tbwebbank.Text = reader["webbank"].ToString(); this.tbcreatetime.Text = reader["id_regdate"].ToString(); this.tbwebregip.Text = reader["webregip"].ToString(); this.ddvip.SelectedValue = reader["weblevel"].ToString(); this.ddsex.SelectedValue = reader["websex"].ToString(); this.ddlevel.SelectedValue = reader["userlevel"].ToString(); } reader.Close(); providers.CloseConn(); }
private void Page_Load(object sender, EventArgs e) { if (base.Request.QueryString["id"] != null) { DataProviders providers = new DataProviders(); SqlDataReader reader = providers.ExecuteSqlDataReader("select * from web_agent" + (" where id=" + int.Parse(base.Request.QueryString["id"]).ToString())); if (reader.Read()) { this.nation = reader["nation"].ToString(); this.name = reader["name"].ToString(); this.msn = reader["msn"].ToString(); this.qq = reader["qq"].ToString(); this.hp = reader["handphone"].ToString(); this.tp = reader["telephone"].ToString(); this.bankinfo = reader["bankinfo"].ToString(); this.TextBox1.Text = this.bankinfo; this.other = reader["other"].ToString(); this.TextBox2.Text = this.other; this.gold = reader["gold"].ToString(); } reader.Close(); providers.CloseConn(); } }