发布时间 : 星期六 文章C#超市管理系统毕业论文更新完毕开始阅读b4f7e61b33d4b14e8424684d
this.lbdl.Text = cishui.ToString(); //页面加载时，检查是否有告警商品，提示用户 string sql2 = \CautionNum)\.ExecuteReader(); if (dr.Read()) { this.Label2.Visible = true; this.Label2.ForeColor = Color.Red; } else { this.Label2.Visible = false; } conn.Close(); } 3.商品信息录入代码： protected void Button1_Click(object sender, EventArgs e) { if (this.txttxm.Text==\.txttxm.Text=\.txtcxj.Text == \.txtcxj.Text=\.txtya.Text == \{this.txtya.Text=\.txtyb.Text == \.txtyb.Text=\.txtsccj.Text == \.txtsccj.Text = \创建连接数据库的对象 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[\.C onnectionString); conn.Open();//打开数据库连接 string ss = \.Text.ToString() + \.SelectedItem.ToString() + \.SelectedItem.ToString(); string se = \txtyb.Text.ToString() + \.SelectedItem.ToString() + \.SelectedItem.ToString(); SqlCommand cmd2 = new SqlCommand(\FROM MerchInfo WHERE MerchID='\.Text.Trim() + \
//执行命令对象操作的查询操作，并将结果返回给DataReader对象。 SqlDataReader dr = cmd2.ExecuteReader(); //执行DataReader的Read方法，判断是否查询到记录 if (dr.Read()) { Response.Write(\该商品已存在!')\.Close(); } else { dr.Close(); //创建一个命令对象 SqlCommand cmd = new SqlCommand(\.Text.Trim() + \.Text.Trim() + \.Text.Trim() + \ddllb.SelectedItem.ToString() + \.Text.Trim() + \.Text.Trim() + \.Text.Trim() + \
Convert.ToDateTime(ss).ToShortDateString() + \.ToDateTime(se).ToShortDateString() + \.Text.Trim() + \.Text.Trim() + \.Text.Trim() + \.Text.Trim() + \.ToInt32(ddlghs.SelectedItem.ToString()) + \.ExecuteNonQuery(); if (i == 1) { Response.Write(\录入成功！')\.Write(\错误，录入失败！')\.Close(); } } 4.商品信息查询代码： protected void Button1_Click(object sender, EventArgs e) { this.GridView1.Visible = false; //创建连接数据库的对象 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[\.C onnectionString); conn.Open();//打开数据库连接 //创建一个命令对象 string sql = \.rbl.SelectedItem.ToString() == \商品编号\
sql = sql + \.TextBox1.Text.Trim() + \.rbl.SelectedItem.ToString() == \商品名称\like '%\.TextBox1.Text.Trim() + \创建并填充dataset DataSet ds = new DataSet(); da.Fill(ds); GridView2.DataSource = ds; GridView2.DataBind(); conn.Close(); } 5.进货单制定界面加载时代码： protected void Page_Load(object sender, EventArgs e) { //创建连接数据库的对象 SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrings[\.C onnectionString); //进货单编号自动编号 string sql = \max(PurchaseListID)from Purchase\.Open();//打开数据库连接 SqlCommand cmd = new SqlCommand(sql, conn); int maxID = Convert.ToInt32(cmd.ExecuteScalar()) + 1; this.Label1.Text = maxID.ToString(); //自动显示进货（今日）日期 this.TextBoxriqi.Text =
System.DateTime.Now.ToShortDateString(); //创建一个命令对象 //自动显示商品名 string sql2 = \this.TextBoxbianhao.Text.Trim() + \.ToString(cmd2.ExecuteScalar()); if (merch == \.TextBoxbianhao.Text!=\.Labelmc.Text = \无此商品\
this.Labelmingcheng.Text = merch.ToString(); this.Labelmc.Text = \提示！\自动显示进价 string sql3 = \MerchID = '\.TextBoxbianhao.Text.Trim() + \
Convert.ToString(cmd3.ExecuteScalar()); this.TextBoxjinjia.Text = jinjia.ToString(); //自动计算总额 if (jinjia != \.TextBoxjinhuoliang.Text.Trim() != \{ this.TextBoxzonge.Text = Convert.ToString(Convert.ToDecimal(this.TextBoxjinhuoliang.Text.Trim()) *
Convert.ToDecimal(this.TextBoxjinjia.Text.Trim())); } //自动显示供货商名称 string sql4 = \.SupplierName from MerchInfo,Supplier where MerchInfo.MerchID = '\.TextBoxbianhao.Text.Trim() + \.SupplierID=MerchInfo.SupplierID\
SqlCommand(sql4, conn); string ghs = Convert.ToString(cmd4.ExecuteScalar()); if (ghs == \.TextBoxgonghuoshang.Text = ghs.ToString(); } //自动显示电话 string sqldh = \.MerchID='\.TextBoxbianhao.Text+\
MerchInfo.SupplierID=Supplier.SupplierID\.ToString(cmddh.ExecuteScalar()); this.TextBoxdianhua.Text = dh; conn.Close(); } 6.销售页面加载时代码： protected void Page_Load(object sender, EventArgs e) { if (Session[\.ToString() == \收银员\.TextBoxWorkerID.Text = Context.User.Identity.Name; this.Label3.Text = Context.User.Identity.Name; 45