addgoodsl.ascx.cs

用vs2005和sql2000实现的小型超市管理系统

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 control_addgoodsl : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {

        //if (Convert.ToString(Session["username"]) == "")
        //{
        //    Response.Write("<script language=javascript>alert('请登录');location='../login.aspx'</script>");
        //    return;
        //}
        if (!IsPostBack)
        {
            SqlConnection strcon = DB.createConnection(); 
            strcon.Open();
            SqlCommand cmd = new SqlCommand("select * from client ", strcon);
            SqlDataReader sdr = cmd.ExecuteReader();
            this.ddlgoodclient.DataSource = sdr;
            this.ddlgoodclient.DataValueField = "客户编号";
            this.ddlgoodclient.DataTextField = "客户名称";
            this.ddlgoodclient.DataBind();
            this.bindtogridview();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {

            string txtgoodsnum = this.txtgoodsnum.Text.ToString();
            string txtgoodsname = this.txtgoodsname.Text.ToString();
            string txtgoodsunit = this.txtgoodsunit.Text.ToString();
            string txtgoodsspecs = this.txtgoodsspecs.Text.ToString();
            string txtgoodsprice = this.txtgoodsprice.Text.ToString();
            string txtgoodsnumber = this.txtgoodsnumber.Text.ToString();
            string ddlgoodclient = this.ddlgoodclient.Text.ToString();
            //string Remark = this.Remark.Text.ToString();
            //string Username = Convert.ToString(Session["username"]);
            //string AddTime = Convert.ToString(DateTime.Now);
            SqlConnection strcon = DB.createConnection();
            //new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
            strcon.Open();
            SqlCommand scd = new SqlCommand("insert into addgoods(商品编号,商品名称,单位 ,规格型号,单价,进货数量, 供货商)values('" + txtgoodsnum + "','" + txtgoodsname + "','" + txtgoodsunit + "','" + txtgoodsspecs + "','" + txtgoodsprice + "','" + txtgoodsnumber + "','" + ddlgoodclient + "')", strcon);
            scd.ExecuteNonQuery();
            strcon.Close();
            Response.Write("<script language=javascript>alert('您已经添加成功');location='addgoods.aspx'</script>");
        }
        else
        {
            Response.Write("<script language=javascript>alert('添加失败，请重新输入！');location='addgoods.aspx'</script>");
        }
    }
    private void bindtogridview()
    {
        SqlConnection con = DB.createConnection();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from addgoods", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "addgoods");
        this.GridView1.DataKeyNames = new string[] { "商品编号" };
        this.GridView1.DataSource = ds.Tables["addgoods"];
        this.GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        this.bindtogridview();
    }
    //protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    //{
    //    string 商品编号 = args.Value.ToString();
    //    SqlConnection con = DB.createConnection();
    //    con.Open();
    //    SqlCommand cmd = new SqlCommand("select cuont(*) from addgoods where 商品编号='" + 商品编号 + "'", con);
    //    int count = Convert.ToInt32(cmd.ExecuteScalar());
    //    if (count > 0)
    //    {
    //        args.IsValid = false;
    //    }
    //    else
    //    {
    //        args.IsValid = true;
    //    }
    //    con.Close();
    //}
}