sellon.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;

public partial class SellMag_SellOn : System.Web.UI.Page
{
    public string totalnum = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["flag"] == null)
        {
            Response.Write("<script language=JavaScript>{window.alert('网络超时或你还未登录，请重新登陆!');window.location.href='admin_login.aspx';}</script>");
        }// 在此处放置用户代码以初始化页面
        if (!Page.IsPostBack)
        {
          
        }

    }
    protected void Buy_Click(object sender, EventArgs e)
    {
      
        string producesid = this.DropDownList1.SelectedValue.ToString();
        string sellnum = this.TextBox1.Text.ToString();
        string selltime = System.DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
        string workerid = this.DropDownList2.SelectedValue.ToString();
        if (Convert.ToInt32(sellnum) <= Convert.ToInt32(totalnum))
        {
            string sql = "insert into SellList ([ProducesId],[SellNum],[WorkersListId]，[SellDateTime]) values ('"+producesid+"','"+sellnum+"','"+workerid+"','"+selltime+"' ";
            string res = DataBindingtest.operate(sql);

            if (res == "ok")
            {
                Response.Write("<script>alert('添加成功！')</script>");

            }
            else
            {
                Response.Write(res);
            }

        }
        else
        {
            Response.Write("<script>alert('购买数量不正确！')</script>");

 
        }

    }
    protected void DetailsView1_DataBound(object sender, EventArgs e)
    {
        
       double prices = Convert.ToDouble(DataBinder.Eval(DetailsView1.DataItem,"ProducesPrices"));

       double discount = Convert.ToDouble(DataBinder.Eval(DetailsView1.DataItem, "Discount"));
       string trueprices = Convert.ToString(prices * discount);

       Label showprice = (Label)DetailsView1.FindControl("Label1");

     showprice.Text = trueprices;
       string producesid = Convert.ToString(DataBinder.Eval(DetailsView1.DataItem, "ProducesId"));
       Label showtolnum = (Label)DetailsView1.FindControl("Label2");

      totalnum= Convert.ToString(DataBindingtest.stillkc(producesid));
      showtolnum.Text = totalnum;

       
    }
}