sendmes.aspx.cs

拍卖系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using myPaimai;
public partial class sendMes : System.Web.UI.Page
{
    dataOperate do1 = new dataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["userID"] != null)
        {
            string Text = Request.QueryString["userID"].ToString();
            tbUserID.Text = Text.Substring(Text.IndexOf('`')+1);
        }
        if (Session["userID"] == null)
        {
            Response.Write("<script language='javascript'>alert('您还没登录呢！');window.openner='anyone';window.close();</script>");
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
            string toUserID = tbUserID.Text.ToString();
            string title = tbTitle.Text.ToString();
            string fromUserID = (string)Session["userID"];
            string cont = TextBox1.Text.ToString();
            try
            {
                if (Convert.ToInt32(do1.executeScalar("SELECT COUNT(*) FROM userPaimai WHERE userID='" + toUserID + "'")) == 0)
                {
                    Response.Write("<script language='javascript'>alert(\"对不起，用户不存在!\");</script>");
                }
                else
                {
                    do1.setParameter("@fromUserID", fromUserID);
                    do1.setParameter("@userID", toUserID);
                    do1.setParameter("@generateTIme", DateTime.Now.ToString());
                    do1.setParameter("@contOfMessage", cont);
                    do1.setParameter("@title", title);
                    do1.executeNonQuery("INSERT INTO shortMessage(title,fromUserID,userID,generateTime,contOfMessage) VALUES(@title,@fromUserID,@userID,@generateTime,@contOfMessage)");
                    Response.Write("<script language='javascript'>alert(\"恭喜！消息发送成功!\");</script>");
                }
            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }
    }
}