private void LoadHoaDon() { try { HoaDonClient hdclient = new HoaDonClient(); HoaDon hd = new HoaDon(); DataTable dtb = hdclient.HoaDon_GetHoaDon(hd, "").Tables[0]; AutoCompleteStringCollection DsHoaDon = new AutoCompleteStringCollection(); foreach (DataRow row in dtb.Rows) { DsHoaDon.Add(row["MaHoaDon"].ToString()); } txt_HoaDon.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txt_HoaDon.AutoCompleteSource = AutoCompleteSource.CustomSource; txt_HoaDon.AutoCompleteCustomSource = DsHoaDon; } catch (Exception ex) { throw ex; } }
//Load thông tin thống kê private void LoadTotalReport() { try { #region Thống kê phiếu nhập PhieuNhapClient phieunhap_client = new PhieuNhapClient(); PhieuNhap pn = new PhieuNhap(); pn.NgayNhap = DateTime.Today; DataTable dt = phieunhap_client.PhieuNhap_GetPhieuNhap(pn, "").Tables[0]; lb_PhieuNhap1_SoPhieu_value.Text = dt.Rows.Count.ToString(); decimal Tongtiennhap = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { Tongtiennhap += Convert.ToDecimal(row["TongTien"]); } } if (Tongtiennhap != 0) { lb_PhieuNhap1_Tien_value.Text = Tongtiennhap.ToString("#,##"); } else { lb_PhieuNhap1_Tien_value.Text = "0"; } pn = new PhieuNhap(); dt = phieunhap_client.PhieuNhap_GetPhieuNhap(pn, " and Year(pns.NgayNhap) = " + DateTime.Today.Year + " and Month(pns.NgayNhap) = " + DateTime.Today.Month).Tables[0]; lb_PhieuNhap2_SoPhieu_value.Text = dt.Rows.Count.ToString(); Tongtiennhap = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { Tongtiennhap += Convert.ToDecimal(row["TongTien"]); } } if (Tongtiennhap != 0) { lb_PhieuNhap2_Tien_value.Text = Tongtiennhap.ToString("#,##"); } else { lb_PhieuNhap2_Tien_value.Text = "0"; } #endregion #region Thống kê phiếu xuất PhieuXuatClient phieuxuat_client = new PhieuXuatClient(); PhieuXuat px = new PhieuXuat(); px.NgayXuat = DateTime.Today; dt = phieuxuat_client.PhieuXuat_GetPhieuXuat(px, "").Tables[0]; lb_PhieuXuat1_SoPhieu_value.Text = dt.Rows.Count.ToString(); decimal Tongtienxuat = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { Tongtienxuat += Convert.ToDecimal(row["TongTien"]); } } if (Tongtienxuat != 0) { lb_PhieuXuat1_Tien_value.Text = Tongtienxuat.ToString("#,##"); } else { lb_PhieuXuat1_Tien_value.Text = "0"; } px = new PhieuXuat(); dt = phieuxuat_client.PhieuXuat_GetPhieuXuat(px, " and Year(pxs.NgayXuat) = " + DateTime.Today.Year + " and Month(pxs.NgayXuat) = " + DateTime.Today.Month).Tables[0]; lb_PhieuXuat2_SoPhieu_value.Text = dt.Rows.Count.ToString(); Tongtienxuat = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { Tongtienxuat += Convert.ToDecimal(row["TongTien"]); } } if (Tongtienxuat != 0) { lb_PhieuXuat2_Tien_value.Text = Tongtienxuat.ToString("#,##"); } else { lb_PhieuXuat2_Tien_value.Text = "0"; } #endregion #region Thống kê hoá đơn - ghi nợ HoaDonClient hoadon_client = new HoaDonClient(); HoaDon hd = new HoaDon(); hd.NgayXuat = DateTime.Today; dt = hoadon_client.HoaDon_GetHoaDon(hd, "").Tables[0]; lb_HoaDon1_SoHD_value.Text = dt.Rows.Count.ToString(); Tongtienxuat = 0; decimal Tongtienno = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { Tongtienxuat += Convert.ToDecimal(row["TongTien"]); Tongtienno += Convert.ToDecimal(row["ConLai"]); } } if (Tongtienxuat != 0) { lb_HoaDon1_DoanhThu_value.Text = Tongtienxuat.ToString("#,##"); } else { lb_HoaDon1_DoanhThu_value.Text = "0"; } if (Tongtienno != 0) { lb_SoNo_value.Text = Tongtienno.ToString("#,##"); } else { lb_SoNo_value.Text = "0"; } hd = new HoaDon(); dt = hoadon_client.HoaDon_GetHoaDon(hd, " and Year(NgayXuat) = " + DateTime.Today.Year + " and Month(NgayXuat) = " + DateTime.Today.Month).Tables[0]; lb_HoaDon2_SoHD_value.Text = dt.Rows.Count.ToString(); Tongtienxuat = 0; Tongtienno = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { Tongtienxuat += Convert.ToDecimal(row["TongTien"]); Tongtienno += Convert.ToDecimal(row["ConLai"]); } } if (Tongtienxuat != 0) { lb_HoaDon2_DoanhThu_value.Text = Tongtienxuat.ToString("#,##"); } else { lb_HoaDon2_DoanhThu_value.Text = "0"; } if (Tongtienno != 0) { lb_SoNo_Thang_value.Text = Tongtienno.ToString("#,##"); } else { lb_SoNo_Thang_value.Text = "0"; } #endregion #region Thống kê khách hàng KhachHangClient khachhang_client = new KhachHangClient(); KhachHang kh = new KhachHang(); //Đếm tổng số khách hàng dt = khachhang_client.KhachHang_GetKhachHang(kh, "").Tables[0]; lb_KhachHang_Tong_value.Text = dt.Rows.Count.ToString(); //Đếm số khách hàng còn nợ dt = khachhang_client.KhachHang_GetKhachHang(kh, " and SoNo > 0").Tables[0]; lb_KhachHang_ConNo_value.Text = dt.Rows.Count.ToString(); #endregion #region Thống kê nhân viên NhanVienClient nhanvien_client = new NhanVienClient(); //Đếm số nv nam NhanVien nv = new NhanVien(); nv.GioiTinh = "Nam"; dt = nhanvien_client.NhanVien_GetNhanVien(nv, "").Tables[0]; lb_NhanVien_Nam_value.Text = dt.Rows.Count.ToString(); //Đếm số nv nữ nv = new NhanVien(); nv.GioiTinh = "Nu"; dt = nhanvien_client.NhanVien_GetNhanVien(nv, "").Tables[0]; lb_NhanVien_Nu_value.Text = dt.Rows.Count.ToString(); #endregion #region Thống kê phiếu thu - thanh toán nợ PhieuThuClient phieuthu_client = new PhieuThuClient(); PhieuThu pt = new PhieuThu(); pt.NgayThu = DateTime.Today; dt = phieuthu_client.PhieuThu_GetPhieuThu(pt, "").Tables[0]; decimal TongTienThu = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { TongTienThu += Convert.ToDecimal(row["SoTienThu"]); } } if (TongTienThu != 0) { lb_TienThu_value.Text = TongTienThu.ToString("#,##"); } else { lb_TienThu_value.Text = "0"; } pt = new PhieuThu(); dt = phieuthu_client.PhieuThu_GetPhieuThu(pt, " and Year(NgayThu) = " + DateTime.Today.Year + " and Month(NgayThu) = " + DateTime.Today.Month).Tables[0]; TongTienThu = 0; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { TongTienThu += Convert.ToDecimal(row["SoTienThu"]); } } if (TongTienThu != 0) { lb_TienThu_Thang_value.Text = TongTienThu.ToString("#,##"); } else { lb_TienThu_Thang_value.Text = "0"; } #endregion #region Thống kê sản phẩm SanPhamClient sanpham_client = new SanPhamClient(); SanPham sp = new SanPham(); SanPham[] dssp = sanpham_client.SanPham_GetSanPham(sp, ""); lb_MaSanPham_value.Text = dssp.Length.ToString(); decimal tongsotonkho = 0; if (dssp.Length > 0) { foreach (SanPham sanpham in dssp) { tongsotonkho += Convert.ToDecimal(sanpham.LuongTon); } } lb_TongTon_value.Text = tongsotonkho.ToString(); dssp = sanpham_client.SanPham_GetSanPham(sp, " and SoLuongTon > 0"); lb_ConHang_value.Text = dssp.Length.ToString(); dssp = sanpham_client.SanPham_GetSanPham(sp, " and SoLuongTon = 0"); lb_HetHang_value.Text = dssp.Length.ToString(); #endregion } catch (Exception ex) { MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void uc_SellingInvoiceCreate_Load(object sender, EventArgs e) { try { HoaDonClient client = new HoaDonClient(); DataTable dtb = new DataTable(); dtb.Columns.Add("MaSanPham"); dtb.Columns.Add("SoLuong"); dtb.Columns.Add("DonGia"); if (string.IsNullOrEmpty(hd.MaHoaDon))//Insert { txt_MaHoaDon.Text = client.HoaDon_GetNewID(DateTime.Today.Year, DateTime.Today.Month); txt_MaHoaDon.Enabled = false; txt_TongTien.Text = "0"; txt_TongTien.Enabled = false; LoadMaNhanVien(); LoadMaKhachHang(); LoadSanPham(); LoadDonHang(); dgv_DanhSachChiTiet.DataSource = dtb; } else//Update or Detail { txt_MaHoaDon.Text = hd.MaHoaDon; txt_MaHoaDon.Enabled = false; msk_NgayXuat.Text = hd.NgayXuat.ToString("dd/MM/yyyy"); txt_NhanVien.Text = hd.NhanVien.ToString(); txt_KhachHang.Text = hd.KhachHang.ToString(); txt_DonHang.Text = hd.DonDatHang.ToString(); txt_TongTien.Text = hd.TongTien.ToString("#,##"); txt_TongTien.Enabled = false; txt_DaThanhToan.Text = hd.DaThanhToan.ToString("#,##"); txt_ConLai.Text = hd.ConLai.ToString("#,##"); txt_ConLai.Enabled = false; foreach (HoaDonCT ct in hd.DSChiTiet) { DataRow row = dtb.NewRow(); row["MaSanPham"] = ct.MaSanPham; row["SoLuong"] = ct.SoLuong; row["DonGia"] = ct.DonGia.ToString("#,##"); dtb.Rows.Add(row); } dgv_DanhSachChiTiet.DataSource = dtb; if (IsInsertOrUpdate) { msk_NgayXuat.Enabled = false; txt_NhanVien.Enabled = false; txt_KhachHang.Enabled = false; txt_DonHang.Enabled = false; btn_AddProduct.Visible = false; btn_Luu.Visible = false; txt_MaSanPham.Enabled = false; txt_TenSanPham.Enabled = false; txt_DonGia.Enabled = false; txt_SoLuong.Enabled = false; dgv_DanhSachChiTiet.Columns["Delete"].Visible = false; } LoadMaNhanVien(); LoadMaKhachHang(); LoadSanPham(); LoadDonHang(); FormatGrid(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//Nút lưu private void btn_Luu_Click(object sender, EventArgs e) { try { HoaDonClient client = new HoaDonClient(); HoaDon hd = new HoaDon(); hd.MaHoaDon = txt_MaHoaDon.Text; hd.NgayXuat = Convert.ToDateTime(msk_NgayXuat.Text); hd.NhanVien = txt_NhanVien.Text; hd.KhachHang = txt_KhachHang.Text; hd.DonDatHang = txt_DonHang.Text; hd.TongTien = Convert.ToDecimal(txt_TongTien.Text); hd.DaThanhToan = Convert.ToDecimal(txt_DaThanhToan.Text); hd.ConLai = Convert.ToDecimal(txt_ConLai.Text); List <HoaDonCT> dsct = new List <HoaDonCT>(); foreach (DataGridViewRow row in dgv_DanhSachChiTiet.Rows) { HoaDonCT ct = new HoaDonCT(); ct.MaHoaDon = txt_MaHoaDon.Text; ct.MaSanPham = row.Cells["MaSanPham"].Value.ToString(); ct.SoLuong = Convert.ToInt32(row.Cells["SoLuong"].Value); ct.DonGia = Convert.ToDecimal(row.Cells["DonGia"].Value); dsct.Add(ct); } hd.DSChiTiet = dsct.ToArray(); if (IsInsertOrUpdate && !Checknull()) { if (client.HoaDon_Insert(hd)) { MessageBox.Show("Thêm hoá đơn thành công"); DataTable dtb = new DataTable(); dtb.Columns.Add("MaSanPham"); dtb.Columns.Add("SoLuong"); dtb.Columns.Add("DonGia"); txt_MaHoaDon.Text = client.HoaDon_GetNewID(DateTime.Today.Year, DateTime.Today.Month); txt_MaHoaDon.Enabled = false; txt_NhanVien.Text = ""; txt_KhachHang.Text = ""; txt_DonHang.Text = ""; msk_NgayXuat.Text = ""; txt_TongTien.Text = "0"; txt_TongTien.Enabled = false; txt_DaThanhToan.Text = "0"; txt_ConLai.Text = "0"; txt_MaSanPham.Text = ""; txt_TenSanPham.Text = ""; txt_SoLuong.Text = ""; txt_DonGia.Text = ""; LoadMaNhanVien(); LoadMaKhachHang(); LoadSanPham(); LoadDonHang(); dgv_DanhSachChiTiet.DataSource = dtb; } else { MessageBox.Show("Thêm hoá đơn thất bại"); } } else if (!IsInsertOrUpdate && !Checknull()) { if (client.HoaDon_Update(hd)) { MessageBox.Show("Cập nhật hoá đơn thành công"); } else { MessageBox.Show("Cập nhật hoá đơn thất bại"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }