XDF/Admin/OrderInfo.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;

namespace XDF.Admin
{
    public partial class OrderInfo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack == false)
            {

                if (Session["UserRole"] == null)
                    Response.Redirect("~/Login.aspx");
                string orderid = Session["OrderID"].ToString();
                string baseid = orderid.Substring(0, 4);
                string basename = getBaseName(baseid);
                string stuid = getStuID(orderid);
                string stuname = getStuName(stuid);
                
                
                string courseid = getCourseID(orderid);
                string teaid = getTeaID(courseid);
                string teaname = getTeaName(teaid);
                string coursename = getCourseName(courseid);
                string amount = getAmount(orderid);
                string insdatetime = getInsDateTime(orderid);
                string canceltime = getCancelTime(orderid);
                string orderstate = getOrderState(orderid);
                LabelOrderID.Text = orderid;
                LabelStuID.Text = stuid;
                LabelStuName.Text = stuname;
                LabelTeaID.Text = teaid;
                LabelTeaName.Text = teaname;
                LabelOrderState.Text = orderstate;
                LabelCourseID.Text = courseid;
                LabelBaseID.Text = baseid;
                LabelBaseName.Text = basename;
                LabelCancelTime.Text = canceltime;
                LabelInsDateTime.Text = insdatetime;
                LabelAmount.Text = amount;
                LabelCourseName.Text = coursename;
            }
        }

            private string getBaseName(string baseid)
        {
            string result = "";
            try
            {
                // 1. 创建连接
                SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["XDF"].ConnectionString);

                // 2. 打开连接