private void sbChiTietBaoCao_Click(object sender, EventArgs e) { BaoCaoNhapHang bc = new BaoCaoNhapHang(); DataTable dt = gcChiTietBaoCao.DataSource as DataTable; if (dt != null && dt.Rows.Count > 0) { bc.ChiTietBaoCao = gcChiTietBaoCao.DataSource as DataTable; bc.ThoiGian = ((DateTime)deThoiGian.EditValue).ToString("MM/dd/yyyy"); XRBaoCaoNhapHang BCTonKho = new XRBaoCaoNhapHang(bc); try { BCTonKho.CreateDocument(); } catch (Exception ex) { } ReportPrintTool printTool = new ReportPrintTool(BCTonKho); printTool.ShowPreviewDialog(); } else { MessageBox.Show("Danh Sách Báo Cáo Trống", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); } }
public XRBaoCaoNhapHang(BaoCaoNhapHang bc) { InitializeComponent(); xlNgayLap.Text = bc.ThoiGian; xlNhanVien.Text = StaticVariables.nhanVien.TenNhanVien; if (bc.ChiTietBaoCao != null) { int cellsInRow = 7; int rowsCount = bc.ChiTietBaoCao.Rows.Count; //do cao cua mot o trong table float rowHeight = 20f; for (int i = 0; i < rowsCount; i++) { XRTableRow row = new XRTableRow(); row.HeightF = rowHeight; for (int j = 0; j < cellsInRow; j++) { XRTableCell cell = new XRTableCell(); if (j == 0) { //them so thu tu cell.Text = i.ToString(); } else cell.Text = bc.ChiTietBaoCao.Rows[i].ItemArray[j - 1].ToString(); //chinh lai kich thuoc cua moi o switch (j) { case 0: cell.WidthF = 30; break; case 1: cell.WidthF = 110; break; case 2: cell.WidthF = 115; break; case 3: cell.WidthF = 200; break; case 4: cell.WidthF = 190; break; case 5: cell.WidthF = 60; break; case 6: cell.WidthF = 90; cell.Text = ((DateTime)bc.ChiTietBaoCao.Rows[i].ItemArray[j - 1]).ToString("MM/dd/yyyy"); break; } row.Cells.Add(cell); } xtDanhSachMatHang.Rows.Add(row); } } }
private void deThang_TextChanged(object sender, EventArgs e) { gcChiTietBaoCao.DataSource = null; gvChiTietBaoCao.Columns.Clear(); BaoCaoNhapHang bc = new BaoCaoNhapHang(); bc.ThoiGian = ((DateTime)deThoiGian.EditValue).ToString("MM/dd/yyyy"); gcChiTietBaoCao.DataSource = _BaoCaoNhapHangBUS.LayChiTietBaoCao(bc); }
public ucBaoCaoNhapHang() { InitializeComponent(); _BaoCaoNhapHangBUS = new BaoCaoNhapHangBUS(); deThoiGian.DateTime = DateTime.Now; gcChiTietBaoCao.DataSource = null; gvChiTietBaoCao.Columns.Clear(); BaoCaoNhapHang bc = new BaoCaoNhapHang(); bc.ThoiGian = ((DateTime)deThoiGian.EditValue).ToString("MM/dd/yyyy"); gcChiTietBaoCao.DataSource = _BaoCaoNhapHangBUS.LayChiTietBaoCao(bc); }
public DataTable LayChiTietBaoCao(BaoCaoNhapHang bc) { try { SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@p_ThoiGian", bc.ThoiGian); return this.LoadDataTable("CHITIETBAOCAONHAPHANG_List", para); } catch (System.Exception ex) { Console.WriteLine("Message= {1}", ex.Message); } return null; }
public DataTable LayChiTietBaoCao(BaoCaoNhapHang bc) { return _BaoCaoNhapHangDAL.LayChiTietBaoCao(bc); }