站内搜索：

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

来源：xiaoniu168.com 作者：本站原创添加时间：2011-12-26 点击数：27136

5.6 申请贷款
此模块是学生申请贷款模块。

以下是引用片段：

核心代码如下：
                     DataTable dt=new DataTable ();
            dt=Database.GetData("select * from 学生,班级 where 学生.班级代码=班级.班级代码 and 学号='"+ Session["user"].ToString() +"'");
            if(dt.Rows.Count>0)
            {
                    this.txtXH.Text = dt.Rows[0]["学号"].ToString();
                    this.txtXM.Text = dt.Rows[0]["姓名"].ToString();
                    this.txtXB.Text = dt.Rows[0]["性别"].ToString();
                    this.txtNL.Text = dt.Rows[0]["年龄"].ToString();
                    this.txtRXRQ.Text = dt.Rows[0]["入学日期"].ToString();
                    this.txtCSRQ.Text = dt.Rows[0]["出生日期"].ToString();
                    this.txtMZ.Text = dt.Rows[0]["民族"].ToString();
                    this.txtBJ.Text = dt.Rows[0]["班级名称"].ToString();
            }

            if (Request.QueryString["ID"] != null)
            {
                //显示当前的商品信息
                DataTable tmpda = new DataTable();
                tmpda = Database.GetData("select * from 贷款申请 where 申请代码=" + 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();

                }
            }