orderselect.aspx.cs

商业源码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using System.Data.OleDb;

namespace SCard
{
	/// <summary>
	/// orderSelect 的摘要说明。
	/// </summary>
	public class orderSelect : System.Web.UI.Page
	{
        protected System.Web.UI.WebControls.TextBox txtName;
        protected System.Web.UI.WebControls.Label lblOrderID;
        protected System.Web.UI.WebControls.Label lblTName;
        protected System.Web.UI.WebControls.Label lblEmail;
        protected System.Web.UI.WebControls.Label lblPhone;
        protected System.Web.UI.WebControls.Label lblPID;
        protected System.Web.UI.WebControls.Label lblPName;
        protected System.Web.UI.WebControls.Label lblPPrice;
        protected System.Web.UI.WebControls.Label lblPNum;
        protected System.Web.UI.WebControls.Label lblTotalPrice;
        protected System.Web.UI.WebControls.Label lblPubdate;
        protected System.Web.UI.HtmlControls.HtmlTable tableSelect;
        protected System.Web.UI.HtmlControls.HtmlTable tableInfo;
        protected System.Web.UI.HtmlControls.HtmlForm Form1;
        protected System.Web.UI.WebControls.TextBox txtEmail;
        protected System.Web.UI.WebControls.TextBox txtOrderid;
        protected System.Web.UI.WebControls.ImageButton ibtnSelect;
        protected System.Web.UI.WebControls.Label lblOState;
    
		private void Page_Load(object sender, System.EventArgs e)
		{
            Response.Buffer=true;
            Response.ExpiresAbsolute=DateTime.Now.AddSeconds(-1);
            Response.Expires=0;
            Response.CacheControl="no-cache";

            if( !IsPostBack )
            {
                tableSelect.Visible = true;
                tableInfo.Visible = false;
            }
		}

        private void getOrderData( string strOID, string strName, string strEmail )//获取订单信息
        {
            DBConn myDB = new DBConn();
            string sql="select * from [Order] where OID='" + strOID + "' and TName='" + strName + "' and Email='" + strEmail + "'";
            OleDbDataReader dr  = myDB.getDataReader( sql );
            if( dr.Read() )
            {
                lblOrderID.Text = dr["OID"].ToString();
                lblTName.Text = dr["TName"].ToString();
                lblEmail.Text = dr["Email"].ToString();
                lblPhone.Text = dr["Phone"].ToString();
                lblPID.Text = dr["PID"].ToString();
                lblPName.Text = dr["PName"].ToString();
                lblPPrice.Text = double.Parse( dr["PPrice"].ToString() ).ToString("C");
                lblPNum.Text = dr["PNum"].ToString();
                lblTotalPrice.Text = double.Parse( dr["TotalPrice"].ToString() ).ToString("C");
                lblPubdate.Text = dr["Pubdate"].ToString();
                lblOState.Text = dr["OState"].ToString();

                string strOState = lblOState.Text;
                switch( strOState )
                {
                    case "0":
                        strOState = "未付款";
                        break;
                    case "1":
                        strOState = "完成";
                        break;
                    case "2":
                        strOState = "停止";
                        break;
                    default:
                        strOState = "其他";
                        break;
                }                                   
                lblOState.Text = strOState; 

                //if( Int32.Parse(lblOState.Text) == 1 )
                //{
                //getCardinfo( lblOrderID.Text );//获取 所购卡的信息 卡号,密码
                //}

                tableSelect.Visible = false;
                tableInfo.Visible = true;

            }
            else
            {
                Response.Write("<script>");
                Response.Write("alert('找不到相应的订单资料!!!');");
                Response.Write("</script>");
            }
            dr.Close();
            myDB.Close();
        }

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
            this.ibtnSelect.Click += new System.Web.UI.ImageClickEventHandler(this.ibtnSelect_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
		#endregion


        private void ibtnSelect_Click(object sender, System.Web.UI.ImageClickEventArgs e)
        {
            string strOrderid = txtOrderid.Text.Trim();
            string strName = txtName.Text.Trim();
            string strEmail = txtEmail.Text.Trim();

            if( strOrderid == String.Empty || strName == String.Empty || strEmail == String.Empty )
            {
                Response.Write("<script>");
                Response.Write("alert('订单相应资料不能为空!!!');");
                Response.Write("</script>");
                return;
            }

            strOrderid = CleanString.htmlInputText( strOrderid );
            strName = CleanString.htmlInputText( strName );
            strEmail = CleanString.htmlInputText( strEmail );

            getOrderData( strOrderid, strName, strEmail );//获取订单信息
            
            /*
            txtOrderid.Text = "";
            txtName.Text = "";
            txtEmail.Text = "";
            */
        }
	}
}