ASP.NET学生助学贷款管理系统(9)

以下是引用片段：

核心代码如下：
            if (Request.QueryString["ID"] != null)
            {
                //显示当前的商品信息
                DataTable tmpda = new DataTable();
                tmpda = Database.GetData("select * from 贷款申请,学生,班级  where 贷款申请.学号=学生.学号 and 学生.班级代码=班级.班级代码 and  申请代码=" + Request.QueryString["ID"]);
                if (tmpda.Rows.Count > 0)
                {
                    this.drXZ.SelectedValue = tmpda.Rows[0]["学制"].ToString();
                    this.drXSLB.SelectedValue = tmpda.Rows[0]["学生类别"].ToString();
                    this.drHKLB.Text = tmpda.Rows[0]["户口类别"].ToString();
                    this.txtZY.Text = tmpda.Rows[0]["专业"].ToString();
                    this.txtJTZZ.Text = tmpda.Rows[0]["家庭住址"].ToString();
                    this.txtLXDH.Text = tmpda.Rows[0]["联系电话"].ToString();
                    this.txtXXZK.Text = tmpda.Rows[0]["学习状况"].ToString();
                    this.txtPDZK.Text = tmpda.Rows[0]["品德状况"].ToString();
                    this.txtDKJE.Text = tmpda.Rows[0]["贷款金额"].ToString();
                    this.txtDKNX.Text = tmpda.Rows[0]["贷款年限"].ToString();
                    this.txtBZ.Text = tmpda.Rows[0]["备注"].ToString();
                    this.txtShenHe.Text = tmpda.Rows[0]["审核"].ToString();
                    this.txtSHRQ.Text = tmpda.Rows[0]["审核日期"].ToString();
                    Session["imgname"] = tmpda.Rows[0]["相关材料"].ToString();
                    strPath = "../file/" + tmpda.Rows[0]["相关材料"].ToString();
                    this.txtXH.Text = tmpda.Rows[0]["学号"].ToString();
                    this.txtXM.Text = tmpda.Rows[0]["姓名"].ToString();
                    this.txtXB.Text = tmpda.Rows[0]["性别"].ToString();
                    this.txtNL.Text = tmpda.Rows[0]["年龄"].ToString();
                    this.txtRXRQ.Text = tmpda.Rows[0]["入学日期"].ToString();
                    this.txtCSRQ.Text = tmpda.Rows[0]["出生日期"].ToString();
                    this.txtMZ.Text = tmpda.Rows[0]["民族"].ToString();
                    this.txtBJ.Text = tmpda.Rows[0]["班级名称"].ToString();

                }
            }

以下是引用片段：

核心代码如下：
                          string bjid=Database.GetData("select 班级代码 from 班级 where 辅导员帐号='"+ Session["user"].ToString() +"'").Rows[0][0].ToString();
            DataTable dt = new DataTable();
            dt = Database.GetData("select count(*),sum(cast(贷款金额 as float)) from 贷款申请,学生 where 贷款申请.学号=学生.学号 and 学生.班级代码 ="+ bjid +" ");
            if (dt.Rows.Count > 0)
            {
                this.txtDKBS.Text = dt.Rows[0][0].ToString();
                this.txtDKBS0.Text = dt.Rows[0][1].ToString() + "万";
            }
            dt = Database.GetData("select count(*),sum(cast(贷款金额 as float)) from 贷款申请,学生 where 贷款申请.学号=学生.学号 and 贷款申请.审核='同意' and 学生.班级代码 =" + bjid + " ");
            if (dt.Rows.Count > 0)
            {
                this.txtTYBS.Text = dt.Rows[0][0].ToString();
                this.txtTYBS0.Text = dt.Rows[0][1].ToString() + "万";
            }
            dt = Database.GetData("select count(*) from (select distinct 学生.学号 from 贷款申请,学生 where 贷款申请.学号=学生.学号 and 学生.班级代码 =" + bjid + " ) a ");
            if (dt.Rows.Count > 0)
            {
                this.txtDKRC.Text = dt.Rows[0][0].ToString();
            }