?? 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('您填寫的結(jié)款金額大于實(shí)際未付金額');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>");
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -