C#超市管理系统毕业论文

} //显示会员卡号 if (this.TextBoxMemID.Text.Trim() != \.Label4.Text = this.TextBoxMemID.Text; } SqlConnection conn = new

SqlConnection(ConfigurationManager.ConnectionStrings[\.C onnectionString); conn.Open();//打开数据库连接 //显示页眉页脚 string sqlymyj = \.ExecuteReader(); if (dry.Read()) { this.Label1.Text = dry[0].ToString(); this.Label2.Text = dry[1].ToString(); } dry.Close(); //自动显示交易（今日）日期(必须具体到小时，因为有些商品的退货是有时间 限制的！) this.TextBoxDate.Text = System.DateTime.Now.ToString(); this.Label8.Text = System.DateTime.Now.ToString(); //自动显示商品名称 string sql2 = \.TextBoxMerchID .Text.Trim() + \conn); string merch = Convert.ToString(cmd2.ExecuteScalar()); if (merch == \.TextBoxMerchID.Text != \.TextBoxMerch.Text = \无此商品\else { this.TextBoxMerch.Text = merch.ToString(); }//显示会员名称 string sql3 = \memberID='\.TextBoxMemID.Text.Trim()+\Convert.ToString(cmd3.ExecuteScalar()); if (name != \.LabelName.Text = name; 46

} if(this.TextBoxMemID.Text!=\.LabelName.Text = \无此会员\显示商品单价（还用考虑是否在促销日期内，如果在，则显示促销价格。同 样会员也在此基础上打折9.5） if (this.TextBoxMerchID.Text != \where merchid='\.TextBoxMerchID.Text + \.ExecuteReader(); if (dr.Read()) { string sp = dr[0].ToString(); string spp = dr[1].ToString(); string dps = dr[2].ToString(); string dpe = dr[3].ToString(); dr.Close(); string sql5 = \.TextBoxMerchID.Text + \.TextBoxDate.Text + \dpe + \.ExecuteReader(); if (dr2.Read()) { this.Label10.Text = \促销价\this.Label11.Text = \原价：\元\.ToString(); this.TextBoxPrice.Text = spp2; } else { this.Label10.Text = \原价\.Label11.Text = \.TextBoxPrice.Text = sp; } } else {} } //默认商品购买数量为1 if (this.TextBoxMerchNum.Text == \.TextBoxMerchNum.Text = \