private void frmSeachBook_Load(object sender, EventArgs e) { sb = new StringBuilder(BASESQL); using (MySqlConnection con = DBHelper.getCon()) { adapter = new MySqlDataAdapter(sb.ToString(), con); adapter.Fill(ds, "books"); dgvBooks.DataSource = ds.Tables["books"]; lbSearchInfo.Text = string.Format("当前库存的书籍共有 {0} 本", ds.Tables["books"].Rows.Count.ToString()); } cobCategories.DisplayMember = "Title"; foreach (Categorie cat in BookManage.getAllCategories()) { cobCategories.Items.Add(cat); } cobCategories.Items.Add(new Categorie()); cobGenres.DisplayMember = "Title"; cobGenres.Items.Add(new Genre()); cobPubshers.DisplayMember = "Name"; foreach (Publisher pub in BookManage.getAllPublishers()) { cobPubshers.Items.Add(pub); } cobPubshers.Items.Add(new Publisher()); }
private void frmSaleAccount_Load(object sender, EventArgs e) { using (MySqlConnection con = DBHelper.getCon()) { adapter = new MySqlDataAdapter(sb.ToString(), con); adapter.Fill(ds, "saleitems"); dgSaleClassify.DataSource = ds.Tables["saleitems"]; float sum = 0; int count = 0; for (int i = 0; i < ds.Tables["saleitems"].Rows.Count; i++) { sum = sum + float.Parse(ds.Tables["saleitems"].Rows[i]["sumprice"].ToString()); } lbInfo.Text = string.Format("目前共有{0}条件记录,销售总额为{1}", ds.Tables["saleitems"].Rows.Count.ToString(), sum.ToString()); } cobCategories.DisplayMember = "Title"; foreach (Categorie cat in BookManage.getAllCategories()) { cobCategories.Items.Add(cat); } cobCategories.Items.Add(new Categorie()); cobGenres.DisplayMember = "Title"; cobGenres.Items.Add(new Genre()); cobPubshers.DisplayMember = "Name"; foreach (Publisher pub in BookManage.getAllPublishers()) { cobPubshers.Items.Add(pub); } cobPubshers.Items.Add(new Publisher()); }
private void loadCategories() { foreach (Categorie cat in BookManage.getAllCategories()) { cobCategories.Items.Add(cat); } //cobCategories.SelectedItem = cobCategories.Items[0]; }
private void loadCategories() { foreach (Categorie cat in BookManage.getAllCategories()) { cobCategories.Items.Add(cat); } cobCategories.DisplayMember = "Title"; cobCategories.ValueMember = "Id"; cobCategories.SelectedItem = cobCategories.Items[0]; }
private void FrmManageBook_Load(object sender, EventArgs e) { List <Categorie> cats = BookManage.getAllCategories(); foreach (Categorie cat in cats) { TreeNode ctn = new TreeNode(); ctn.Text = cat.Title; ctn.Tag = cat.Id; foreach (Genre gen in BookManage.getGenresByCatId(cat.Id)) { TreeNode gtn = new TreeNode(); gtn.Text = gen.Title; gtn.Tag = gen.Id; ctn.Nodes.Add(gtn); } tvBooks.Nodes.Add(ctn); } }