Teacher/bfsztj.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class Teacher_bfsztj : System.Web.UI.Page
{
    public string jeCount = "";//总额
    public string zc = "";
    public string sy = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            string str = " select sum(交费金额) from 班级交费 where 学号 in(select  学号 from 学生 where 学生.班级代码  "
            + "in(select 班级代码 from 教师 where 教师帐号='" + Session["ID"] + "') )  ";
            str += " union  ";
            str += " select sum(支出金额) as 班费支出  from 支出班费 where 班主任教师='" + Session["ID"] + "'  ";
            DataTable dt = db.GetData(str);
            if (dt != null && dt.Rows.Count > 0)
            {
                for (int i = 0; i < 1; i++)
                {
                    jeCount = dt.Rows[i].ItemArray[0]+"";
                    zc = dt.Rows[i+1].ItemArray[0] + "";
                    sy =Math.Abs( Convert.ToInt16(jeCount) - Convert.ToInt32(zc)) + "";
                }
            }
        }
    }
}