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);
}
}
