shebei/tongji.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using dao;

public partial class shebei_tongji : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack) {
            int all = 0;
            int ttsl = 0;
            int sysl = 0;
            int gzsl = 0;
            string sql = "select count(1) as num from shebei where  1=1";//准备查询记录的sql
            DataTable dt = DBHelper.GetDataSet(sql);//执行sql语句
            if (dt.Rows.Count > 0)
            {//如果有记录 进行赋值

                all = int.Parse(dt.Rows[0]["num"].ToString());
                this.sl.Text = dt.Rows[0]["num"].ToString();
            }
            sql = "select count(1) as num from shebei where  1=1 and zt='淘汰'";//准备查询记录的sql
             dt = DBHelper.GetDataSet(sql);//执行sql语句
            if (dt.Rows.Count > 0)
            {//如果有记录 进行赋值

                ttsl = int.Parse(dt.Rows[0]["num"].ToString());
                this.ttsl.Text = dt.Rows[0]["num"].ToString();
            }
            this.ttl.Text = Convert.ToString(ttsl*100/all);

            sql = "select count(1) as num from shebei where  1=1 and sbmc in (select sb from sbjh)";//准备查询记录的sql
            dt = DBHelper.GetDataSet(sql);//执行sql语句
            if (dt.Rows.Count > 0)
            {//如果有记录 进行赋值

                sysl = int.Parse(dt.Rows[0]["num"].ToString());
                this.sysl.Text = dt.Rows[0]["num"].ToString();
            }
            this.syl.Text = Convert.ToString(sysl * 100 / all);
            sql = "select count(1) as num from shebei where  1=1 and sbmc in (select sb from sbgzjl)";//准备查询记录的sql
            dt = DBHelper.GetDataSet(sql);//执行sql语句
            if (dt.Rows.Count > 0)
            {//如果有记录 进行赋值

                gzsl = int.Parse(dt.Rows[0]["num"].ToString());
                this.gzsl.Text = dt.Rows[0]["num"].ToString();
            }
            this.gzl.Text = Convert.ToString(gzsl * 100 / all);
        }