Stockpile/open.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 System.Data.SqlClient;

public partial class Stockpile_open : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            stockClass sc = new stockClass();
            this.payment.Text = Convert.ToString(sc.not(Convert.ToString(Request["id"])));
            this.date.Text = Convert.ToString(DateTime.Now.Date.ToShortDateString());
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string payment = this.payment.Text;
        string manageman = this.manageman.Text;
        string username=Convert.ToString(Session["username"]);
        stockClass sc = new stockClass();
        if(Convert.ToInt32(this.payment.Text)>Convert.ToInt32(sc.not(Convert.ToString(Request["id"]))))
        {
            Response.Write("<script>alert('您填写的结款金额大于实际未付金额');history.back()</script>");
            Response.End();
        }
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
        strcon.Open();
        string sql = "insert into tb_Reckoning (CommodityId,Settlement,ManageMan,username,Addtime,datetime)values(" + Request["id"].ToString() + ",'" + payment + "','" + manageman + "','" + username + "','" + Convert.ToString(DateTime.Now) + "','" + Convert.ToDateTime(date.Text).ToShortDateString() + "')";
        SqlCommand scd = new SqlCommand(sql,strcon);
        scd.ExecuteNonQuery();
        Response.Write("<script>alert('成功');opener.location='Reckoning.aspx?type="+Request["type"]+"';window.close()</script>");
    }
}