private void Page_Load(object sender, EventArgs e)
{
DataProviders providers = new DataProviders();
this.lblonlineplayer.Text = providers.ExecScalarOne("select sum(1) from mhcmember..logintable");
this.Label1.Text = providers.ExecScalarOne("select sum(gold) as gold from web_log where type='代理發放金幣' and convert(char(10),date,120)=convert(char(10),getdate(),120)");
}
private void btnread_Click(object sender, EventArgs e)
{
DataProviders providers = new DataProviders();
this.lblonlineplayer.Text = providers.ExecScalarOne("select sum(1) from mhcmember..logintable");
this.lblregister.Text = providers.ExecScalarOne("select sum(1) from mhcmember..chr_log_info");
this.lblmale.Text = providers.ExecScalarOne("select sum(1) from mhcmember..chr_log_info where websex='帥哥'");
this.lblfemale.Text = providers.ExecScalarOne("select sum(1) from mhcmember..chr_log_info where websex='美女'");
this.lblvip.Text = providers.ExecScalarOne("select sum(1) from mhcmember..chr_log_info where weblevel=1");
this.lbl2lvpet.Text = providers.ExecScalarOne("select sum(1) from mhgame..tb_petinfo where grade=2");
this.lbl3lvpet.Text = providers.ExecScalarOne("select sum(1) from mhgame..tb_petinfo where grade=3");
this.lblbank.Text = providers.ExecScalarOne("select sum(webbank) from mhcmember..chr_log_info");
this.lblplayergold.Text = string.Format("{0:N}", providers.ExecScalarOne("select sum(webgold) from mhcmember..chr_log_info"));
this.lblagentgold.Text = providers.ExecScalarOne("select sum(gold) from mhcmember..web_agent");
this.lblallcharacter.Text = providers.ExecScalarOne("select sum(1) from mhgame..tb_character");
}