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 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 btnLogin_ServerClick(object sender, EventArgs e)
{
DataProviders providers = new DataProviders();
system system = new system();
WebLogic logic = new WebLogic();
string agentid = system.ChkSql(this.agent_id.Value.ToString());
string str2 = system.ChkSql(this.agent_pwd.Value.ToString());
if (this.vcode.Value != this.Session["VerifyCode"].ToString())
{
base.Response.Write("<script language=javascript>alert(\"驗證碼錯誤！\")</script>");
}
else
{
SqlDataReader reader = providers.ExecuteSqlDataReader("select * from mhcmember..web_agent where userid='" + agentid + "' and password='******' and state=1");
if (reader.Read())
{
this.Session.Timeout = 600;
this.Session["agent_id"] = reader["userid"].ToString();
this.Session["agent_name"] = reader["name"].ToString();
this.Session["agent_ip"] = system.GetClientIP();
logic.log("", agentid, "", 0, "代理後台登陸成功", system.GetClientIP(), "代理登陸日誌");
base.Response.Redirect("account.aspx");
}
else
{
logic.log("", "", agentid, 0, "用戶名或密碼錯誤ID：" + agentid + "PW：" + str2, system.GetClientIP(), "代理登陸日誌");
base.Response.Write("<script language=javascript>alert(\"用戶名或密碼錯誤！\")</script>");
}
}
}
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 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 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 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 (!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)
{
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 (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)
{
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 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 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();
}
}
