Пример #1
0
 /// <summary>
 /// 根据学号查询学生订单信息
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void button3_Click(object sender, EventArgs e)
 {
     if (string.IsNullOrWhiteSpace(txtSearch.Text))
     {
         MessageBox.Show("请输入要查询的学生的学号");
     }
     else
     {
         BLL.UserGoodsBLL objU = new BLL.UserGoodsBLL();
         dataGridView1.DataSource = objU.GetList(x => x.uid == Convert.ToInt32(txtSearch.Text.ToString()));
         dataGridView1.Refresh();
     }
 }
Пример #2
0
        private void frmUsers_Load(object sender, EventArgs e)
        {
            this.label1.Parent    = pictureBox1;
            this.label1.BackColor = Color.FromArgb(0, Color.Transparent);
            this.label2.Parent    = pictureBox1;
            this.label2.BackColor = Color.FromArgb(0, Color.Transparent);
            this.label3.Parent    = pictureBox1;
            this.label3.BackColor = Color.FromArgb(0, Color.Transparent);
            this.label4.Parent    = pictureBox1;
            this.label4.BackColor = Color.FromArgb(0, Color.Transparent);
            this.label5.Parent    = pictureBox1;
            this.label5.BackColor = Color.FromArgb(0, Color.Transparent);
            this.label6.Parent    = pictureBox1;
            this.label6.BackColor = Color.FromArgb(0, Color.Transparent);
            this.label9.Parent    = pictureBox1;
            this.label9.BackColor = Color.FromArgb(0, Color.Transparent);

            this.rbMale.Parent    = pictureBox1;
            this.rbMale.BackColor = Color.FromArgb(0, Color.Transparent);

            this.rbFemale.Parent    = pictureBox1;
            this.rbFemale.BackColor = Color.FromArgb(0, Color.Transparent);

            BLL.UsersBLL objU = new BLL.UsersBLL();
            dataGridView2.DataSource = objU.GetList(x => true);
            dataGridView2.Refresh();

            BLL.UserGoodsBLL objUB = new BLL.UserGoodsBLL();
            dataGridView1.DataSource = objUB.GetList(x => true);
            dataGridView1.Refresh();

            dataGridView2.Columns[0].HeaderCell.Value = "学生ID";
            dataGridView2.Columns[1].HeaderCell.Value = "姓名";
            dataGridView2.Columns[2].HeaderCell.Value = "性别";
            dataGridView2.Columns[3].HeaderCell.Value = "密码";
            dataGridView2.Columns[4].HeaderCell.Value = "学校";


            dataGridView1.Columns[0].HeaderCell.Value = "学生ID";
            dataGridView1.Columns[1].HeaderCell.Value = "商品ID";
            dataGridView1.Columns[2].HeaderCell.Value = "商品类别";
            dataGridView1.Columns[3].HeaderCell.Value = "商品名称";
            dataGridView1.Columns[4].HeaderCell.Value = "商品价格";
            dataGridView1.Columns[5].HeaderCell.Value = "商品状态";
        }
Пример #3
0
        private void button5_Click(object sender, EventArgs e)
        {
            int uid = (int)(dataGridView1.SelectedRows[0].Cells["uid"].Value);
            int gid = (int)(dataGridView1.SelectedRows[0].Cells["gid"].Value);

            string SQL = String.Format("delete from UserGoods where uid = {0} and gid = {1}", uid, gid);

            if (SqlHelper.ExcuteSQL(SQL) > 0)
            {
                MessageBox.Show("删除成功");
                BLL.UserGoodsBLL objUB = new BLL.UserGoodsBLL();
                dataGridView1.DataSource = objUB.GetList(x => true);
                dataGridView1.Refresh();
            }
            else
            {
                MessageBox.Show("删除失败");
            }
        }
Пример #4
0
 private void btnUdelete_Click(object sender, EventArgs e)
 {
     BLL.UserGoodsBLL objU = new BLL.UserGoodsBLL();
     dataGridView1.DataSource = objU.GetList(x => true);
     dataGridView1.Refresh();
 }