public DTO_Pro setControlToDTO(ref DTO_Pro pro, BLL_QuanLySP bll) { pro.CatID = Convert.ToInt32(bll.GetCatIDWithCatName(ref err, cbo_dm.SelectedItem.ToString())); pro.ProName = txt_name.Text; pro.proDescription = txt_des.Text; pro.ProID = Convert.ToInt32(lbl_ProID.Text); return(pro); }
private void btn_ViewReport_Click(object sender, EventArgs e) { bll = new BLL_QuanLySP(); Frm_Report frm_report = new Frm_Report(); frm_report.CatID = bll.GetCatIDWithCatName(ref err, cbo_dm.SelectedItem.ToString()).ToString(); frm_report.Show(); }
private void Frm_DSSP_Load(object sender, EventArgs e) { bll = new BLL_QuanLySP(); DataTable dt = new DataTable(); dt = bll.GetListCat(ref err); cbo_dm.Items.Add("Chọn tất cả"); cbo_dm.SelectedIndex = 0; for (int i = 0; i < dt.Rows.Count - 1; i++) { cbo_dm.Items.Add(dt.Rows[i][1].ToString()); } }
private void btn_add_Click(object sender, EventArgs e) { bll = new BLL_QuanLySP(); DTO_Pro pro = new DTO_Pro(); setControlToDTO(ref pro, bll); if (bll.AddProduct(ref err, pro.ProName, pro.proDescription, pro.CatID)) { MessageBox.Show("Đã thêm thành công"); cbo_dm_SelectedIndexChanged(sender, e); } else { MessageBox.Show("Không thêm đuọc"); } }
private void cbo_dm_SelectedIndexChanged(object sender, EventArgs e) { bll = new BLL_QuanLySP(); DataTable dt = new DataTable(); if (cbo_dm.SelectedIndex == 0) { dt = bll.GetListPro(ref err); } else { int id = bll.GetCatIDWithCatName(ref err, cbo_dm.SelectedItem.ToString()); dt = bll.GetListProWithCatID(ref err, id); } dataGridView1.DataSource = dt; lbl_QuantityPro.Text = dt.Rows.Count.ToString(); }
public void HienThiReport() { BLL_QuanLySP bll = new BLL_QuanLySP(); DataTable dt = new DataTable(); dt = bll.GetListProWithCatID(ref err, Convert.ToInt32(CatID)); dt.Columns.Add("STT"); int i = 1; foreach (DataRow item in dt.Rows) { item["STT"] = i; i++; } reportViewer1.Reset(); reportViewer1.LocalReport.ReportEmbeddedResource = "ThiWinfrom.Report1.rdlc"; reportViewer1.LocalReport.DataSources.Clear(); ReportDataSource _dataSource = new ReportDataSource("DS_InBaoCao", dt); reportViewer1.LocalReport.DataSources.Add(_dataSource); this.reportViewer1.RefreshReport(); }
private void btn_Del_Click(object sender, EventArgs e) { bll = new BLL_QuanLySP(); bool result = false; for (int i = dataGridView1.RowCount - 1; i > 0; i--) { if (dataGridView1.Rows[i].Cells["col_Check"].Selected) { int proid = Convert.ToInt32(dataGridView1.Rows[i].Cells["col_ProID"].Value); result = bll.DeletePro(ref err, proid); } } if (result) { MessageBox.Show("Xóa hoàn tất"); cbo_dm_SelectedIndexChanged(sender, e); } else { MessageBox.Show("Xóa thất bại"); } }