cardinfo.aspx.cs

商业源码

                                    //如果不是已加密字符串 就会出错
                                }

                                DataRow myRow = myDT.NewRow();
                                myRow["CardNum"] = sCardNum;
                                myRow["CardPassword"] = sCardPassword;
                                myDT.Rows.Add( myRow );

                            }
                            while( mydr2.Read() );
                            
                            CardRepeater.DataSource = myDT;//显示 卡的信息
                            CardRepeater.DataBind();

                            //Session["getCardinfor"] = "Yes";//成功获取卡的信息

                        }
                        else
                        {
                            Response.Write("<script>");
                            Response.Write("alert('库存不足!!! 请与客服服务部联系!');");
                            Response.Write("</script>");
                            mydr2.Close();
                            myDB2.Close();
                            return;
                        }
                        mydr2.Close();
                        myDB2.Close();

                    }
                    else
                    {	//-------------------------------如果支付失败

                        /*
                        #提示支付失败信息#
                        */
                        Response.Write("您在网上 支付失败<br>");
                        Response.Write("请检查存款余额是否足够!!!<br>");
                        return;
                    } 
                }
                else
                {   //--------------------------------------------------------------如果签名验证失败！
                    /*
                    #提示签名验证失败信息#
                    */
                    Response.Redirect("index.aspx");
                    Response.End();
                    return;
                }
            }//if
        }

        private void getCardinfo( string strOID )//获取 所购卡的信息 卡号,密码
        {
            DataTable myDT = new DataTable(); //存放卡号,密码
            myDT.Columns.Add("CardNum");
            myDT.Columns.Add("CardPassword");

            string sql="select * from [PList] where PLID=-1";

            //查询 订单明细表 卡的编号
            DBConn myDB = new DBConn();
            string mySql="select * from [OrderList] where OID='" + strOID + "'";
            OleDbDataReader mydr = myDB.getDataReader( mySql );
            if( mydr.Read() )
            {
                do
                {
                    sql += " or PLID=" +mydr["PLID"].ToString();
                }while( mydr.Read() );
            }
            else
            {
                //lblNull.Text = "无";
                mydr.Close();
                myDB.Close();
                return;
            }
            mydr.Close();
            myDB.Close();

            //获得 卡的信息
            DBConn DB = new DBConn();
            OleDbDataReader dr = DB.getDataReader( sql );
            while( dr.Read() )
            {
                DataRow myRow = myDT.NewRow();
                myRow["CardNum"] = dr["CardNum"].ToString();
                myRow["CardPassword"] = dr["CardPassword"].ToString();

                //加密对象
                DCard.Encode myEncode = new DCard.Encode();
                try
                {
                    myRow["CardPassword"] = myEncode.DecryptString( myRow["CardPassword"].ToString() );
                }
                catch
                {
                    //如果不是已加密字符串 就会出错
                }

                myDT.Rows.Add( myRow );
            }
            dr.Close();
            DB.Close();

            CardRepeater.DataSource = myDT;
            CardRepeater.DataBind();
            
        }

        private bool checkOrderidAndAmount( string strOrderid, string strAmount )//检查 订单编号 && 支付的金额
        {
            bool flag = true;

            string mySql = "select * from [Order] where OID='" + strOrderid + "'";
            DBConn myDB = new DBConn();
            OleDbDataReader mydr  = myDB.getDataReader( mySql );
            if( mydr.Read() )
            {
                double dblTPrice = double.Parse( mydr["TotalPrice"].ToString() );
                if( dblTPrice != double.Parse( strAmount ) )//检查 订单需要支付的金额是否一致
                {
                    flag = false;
                }
            }
            else
            {
                flag = false; //订单不存在
            }
            mydr.Close();
            myDB.Close();

            return flag;
        }

        private string getMerchantKey()//获取 私钥值
        {
            string s = "";

            DBConn myDB = new DBConn();
            string mySql="select [text] from [wangguan] where [id]='1'";
            OleDbDataReader mydr  = myDB.getDataReader( mySql );
            if( mydr.Read() )
            {
                s = mydr["text"].ToString();
            }
            mydr.Close();
            myDB.Close();

            //加密对象
            DCard.Encode myEncode = new DCard.Encode();
            try
            { 
                s = myEncode.DecryptString( s );
            }
            catch
            {
                //如果不是已加密字符串 就会出错
            }

            return s;
        }

        private string getMerchantID()//获取 商户编号
        {
            string s = "";

            DBConn myDB = new DBConn();
            string mySql="select [text] from [wangguan] where [id]='0'";
            OleDbDataReader mydr  = myDB.getDataReader( mySql );
            if( mydr.Read() )
            {
                s = mydr["text"].ToString();
            }
            mydr.Close();
            myDB.Close();

            return s;
        }

        private int setOState(string strOID)//修改订单的状态 1
        {
            DBConn myDB = new DBConn();
            string mySql = "update [Order] set OState=1 where OID='" + strOID +"'";
            int i = myDB.ExecuteNonQuery( mySql );
            myDB.Close();

            return i;
        }

        private int setPStock(string strPID)//修改卡的库存(-1)和卖出个数(+1)
        {
            DBConn myDB = new DBConn();
            string mySql = "update Products set PStock=PStock-1,PSellNum=PSellNum+1 where PID=" + strPID;
            int i = myDB.ExecuteNonQuery( mySql );
            myDB.Close();

            return i;
        }

        private int setOrderList(string strOID,string strPLID)//添加到订单明细表
        {
            DBConn myDB = new DBConn();
            string mySql = "insert into OrderList(OID,PLID) values('" + strOID + "'," + strPLID + ")";
            int i = myDB.ExecuteNonQuery( mySql );
            myDB.Close();

            return i;
        }

        private int setCardState(string strPLID)//修改卡的状态
        {
            DBConn myDB = new DBConn();
            string mySql = "update PList set CardState=1 where PLID=" + strPLID;
            int i = myDB.ExecuteNonQuery( mySql );
            myDB.Close();

            return i;
        }

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

        }
		#endregion
	}
}