private void frmTimBaoCao_Load(object sender, EventArgs e) { makNgaybatdau.Text = new Common.Utilities().XuLy(2, DateServer.Date().ToString()); makNgayketthuc.Text = new Common.Utilities().XuLy(2, DateServer.Date().ToString()); layBang(); this.cbxLoaibaocao.Items.AddRange(new object[] { "Xuất Hàng Theo Từng Kho", "Xuất Hàng Theo Từng Nhóm Hàng", "Xuất Hàng Theo Từng Mặt Hàng" }); this.cbxLoaibaocao.Text = "Chọn báo cáo cần hiển thị"; this.cbxNam.Items.AddRange(new object[] { "2011", "2012", "2013", "2014", "2015", "2016", "2017", "2018", "2020" }); if (rdoTheoquy.Checked == true) { cbxNam.Enabled = true; cbxThang_Quy.Enabled = true; makNgaybatdau.Enabled = false; makNgayketthuc.Enabled = false; lblThang_Quy.Text = "Quý:"; this.cbxThang_Quy.Items.AddRange(new object[] { "1", "2", "3", "4" }); this.cbxThang_Quy.Text = "Chọn quý"; } if (rdoTheothang.Checked == true) { cbxNam.Enabled = true; cbxThang_Quy.Enabled = true; makNgaybatdau.Enabled = false; makNgayketthuc.Enabled = false; lblThang_Quy.Text = "Tháng:"; this.cbxThang_Quy.Items.AddRange(new object[] { "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12" }); } }
public static DateTime GetDateTimeNow(string select) { if (string.IsNullOrEmpty(select)) { select = "server"; } DateTime dateTime = new DateTime(1753, 1, 1); //check kết nối mạng //if (Klib2.InternetConnection.IsConnectedToInternet()) dateTime = Klib2.KUtilsTime.GetTimeInternet(); bool a = dateTime.Date == (new DateTime(1753, 1, 1)).Date; bool b = dateTime.Date == (new DateTime()).Date; bool c = a || b; if (c && select.Equals("client")) { try { dateTime = DateServer.Date(); } catch { dateTime = DateTime.Now; } } else if (c && select.Equals("server")) { dateTime = DateTime.Now; } return(dateTime); }
public frmBCTonKhoTheoKho() { InitializeComponent(); datesv = DateServer.Date(); KhoHang(); TonKho(); HienThiTongThe(); }
public frmBCNhapHangTheoMatHang() { try { InitializeComponent(); datesv = DateServer.Date(); nam = datesv.Year; thang = datesv.Month; cbbthang.Text = thang.ToString(); cbbnam.Text = nam.ToString(); HoaDonNhap(); ChiTietHoaDonNhap(); KhachHangTraLai(); ChiTietKhachHangTraLai(); HangHoa(); GoiHang(); ChiTietGoiHang(); PhieuDieuChuyenKhoNoiBo(); ChiTietPhieuDieuChuyenKho(); NhapHangTheoMatHang(); } catch { } }
public void hienthi() { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Pdck = new PhieuDieuChuyenKhoNoiBo("Select", 1, "a", DateServer.Date(), "a", "a ", "a", "a", "a", false, "a", false); clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", Pdck); PhieuDieuChuyenKhoNoiBo[] pdck1 = new PhieuDieuChuyenKhoNoiBo[1]; pdck1[0] = new PhieuDieuChuyenKhoNoiBo(1, "a", DateServer.Date(), "a", "a", "a", false, "a", false); pdck1 = (PhieuDieuChuyenKhoNoiBo[])cl.DeserializeHepper1(clientstrem, pdck1); if (pdck1 == null) { Entities.PhieuDieuChuyenKhoNoiBo[] a = new PhieuDieuChuyenKhoNoiBo[0]; PDCK_Search = a; dgvHienThi.DataSource = a; FixDataGridView(); toolStripStatus_Sua.Enabled = false; toolStripStatus_Xoa.Enabled = false; } else { PDCK_Search = pdck1; dgvHienThi.DataSource = pdck1; FixDataGridView(); toolStripStatus_Sua.Enabled = true; toolStripStatus_Xoa.Enabled = true; } }
public frmBCXuatNhapTonPhieuXuatNhap() { try { InitializeComponent(); nam = DateServer.Date().Year; thang = DateServer.Date().Month; cbbthang.Text = thang.ToString(); cbbnam.Text = nam.ToString(); PhieuXuatHuy(); ChiTietXuatHuy(); HDBanHang(); ChiTietHDBanHang(); HoaDonNhap(); ChiTietHoaDonNhap(); TraLaiNCC(); ChiTietTraLaiNCC(); KhachHangTraLai(); ChiTietKhachHangTraLai(); HangHoa(); SoDuKho(); GoiHang(); ChiTietGoiHang(); TongTienNhanVien(); } catch { } }
public frmBCXuatHangTheoThoiGian() { InitializeComponent(); try { datesv = DateServer.Date(); for (int i = 0; i < cbbthang.Items.Count; i++) { if (cbbthang.Items[i].ToString() == datesv.Month.ToString()) { cbbthang.SelectedIndex = i; break; } } for (int i = 0; i < cbbnam.Items.Count; i++) { if (cbbnam.Items[i].ToString() == datesv.Year.ToString()) { cbbnam.SelectedIndex = i; break; } } cbbnam.Text = datesv.Year.ToString(); cbbthang.Text = datesv.Month.ToString(); batdau = new DateTime(Convert.ToInt32(cbbnam.Text), Convert.ToInt32(cbbthang.Text), 1).ToString(); ketthuc = new DateTime(Convert.ToInt32(cbbnam.Text), Convert.ToInt32(cbbthang.Text), DateTime.DaysInMonth(Convert.ToInt32(cbbnam.Text), Convert.ToInt32(cbbthang.Text))).ToString(); //batdau = new Common.Utilities().MyDateConversion("01/" + cbbthang.Text + "/" + cbbnam.Text); //if (cbbthang.Text == "12") // ketthuc = new Common.Utilities().MyDateConversion("01/01/" + (Convert.ToInt32(cbbnam.Text) + 1).ToString()); //else // ketthuc = new Common.Utilities().MyDateConversion("01/" + (Convert.ToInt32(cbbthang.Text) + 1).ToString() + "/" + cbbnam.Text); truoc = Convert.ToDateTime(batdau); sau = Convert.ToDateTime(ketthuc); nam = datesv.Year; thang = datesv.Month; cbbthang.Text = thang.ToString(); cbbnam.Text = nam.ToString(); //Xuất hủy PhieuXuatHuy(); ChiTietXuatHuy(); //Hóa đơn bán hàng HDBanHang1(); ChiTietHDBanHang(); //Trả lại nhà cung cấp TraLaiNCC(); ChiTietTraLaiNCC(); HangHoa1(); GoiHang(); ChiTietGoiHang(); TongTienNhanVien(); } catch { } }
public frmKetChuyenSoDu() { InitializeComponent(); datesv = DateServer.Date(); cbbnam.Text = datesv.Year.ToString(); cbbthang.Text = datesv.Month.ToString(); SelectData(); }
public frmBCThue() { InitializeComponent(); datesv = DateServer.Date(); datesv = DateServer.Date(); truoc = sau = datesv; SelectData(); dtgvhienthi.DataSource = new Entities.BCThue[0]; fix(); }
public frmKetChuyenSoDuCongNo() { InitializeComponent(); datesv = DateServer.Date(); cbbnam.Text = datesv.Year.ToString(); cbbthang.Text = datesv.Month.ToString(); cbbdoituong.SelectedIndex = 0; SelectData(); }
private void frmBCTienTonKho_Load(object sender, EventArgs e) { try { DateTime hientai = DateServer.Date(); DateTime truoc = new DateTime(hientai.Year, hientai.Month, 1); Xuly(truoc, hientai); } catch { } }
private void toolStripStatusLabel1_Click(object sender, EventArgs e) { //Nạp Lại try { DateTime hientai = DateServer.Date(); DateTime truoc = new DateTime(hientai.Year, hientai.Month, 1); Xuly(truoc, hientai); } catch { } }
private void frmBCThuTienTheGiaTri_Load(object sender, EventArgs e) { try { DateTime hientai = DateServer.Date(); DateTime truoc = new DateTime(hientai.Year, hientai.Month, 1); DateTime sau = new DateTime(hientai.Year, hientai.Month, DateTime.DaysInMonth(hientai.Year, hientai.Month)); Xuly(truoc, sau); } catch { } }
/// <summary> /// xử lý khi truyền giá trị tới /// </summary> public frmQuanLyBanBuon() { InitializeComponent(); datesv = DateServer.Date(); makho = new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen; if (string.IsNullOrEmpty(makho)) { MessageBox.Show("Chưa cài đặt kho", "Hệ thống cảnh báo"); } truoc = sau = datesv; }
public frmSoDuSoQuy() { try { InitializeComponent(); datesv = DateServer.Date(); cbbnam.Text = datesv.Year.ToString(); cbbthang.Text = datesv.Month.ToString(); SelectData(); } catch { } }
public void CheckDataGridCongSL(DataGridView dgv, string maKho) { if (dgv.RowCount != 0) { try { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.ChiTietKhoHangTheoHoaHonNhap nv = new Entities.ChiTietKhoHangTheoHoaHonNhap("Select"); clientstrem = cl.SerializeObj(this.client1, "ChiTietKho", nv); Entities.ChiTietKhoHangTheoHoaHonNhap[] kh1 = new Entities.ChiTietKhoHangTheoHoaHonNhap[1]; kh1 = (Entities.ChiTietKhoHangTheoHoaHonNhap[])cl.DeserializeHepper1(clientstrem, kh1); List <Entities.ChiTietKhoHangTheoHoaHonNhap> ctList = new List <Entities.ChiTietKhoHangTheoHoaHonNhap>(); for (int i = 0; i < dgv.RowCount; i++) { bool retVal = false; foreach (Entities.ChiTietKhoHangTheoHoaHonNhap item in kh1) { if (dgv["MaHangHoa", i].Value.ToString().ToUpper().Equals(item.Mahanghoa.ToUpper()) && maKho.Equals(item.Makho)) { retVal = true; break; } } if (!retVal) { Entities.ChiTietKhoHangTheoHoaHonNhap ct = new Entities.ChiTietKhoHangTheoHoaHonNhap(); ct.Hanhdong = "Insert"; ct.Mahanghoa = dgv["MaHangHoa", i].Value.ToString(); ct.Makho = maKho; ct.Ngaynhap = DateServer.Date(); DateTime ngayHetHan = DateTime.Now; if (dgv["NgayHetHan", i] != null) { ngayHetHan = (DateTime)dgv["NgayHetHan", i].Value; } ct.Ngayhethan = ngayHetHan; ct.Soluong = int.Parse(dgv["SoLuong", i].Value.ToString()); ct.Ghichu = ""; ctList.Add(ct); } } Server_Client.Client cl1 = new Server_Client.Client(); this.client1 = cl1.Connect(Luu.IP, Luu.Ports); clientstrem = cl1.SerializeObj(this.client1, "ThemChiTietKhoHang", ctList.ToArray()); } catch (Exception) { } } }
public frmBCXuatHuyHangHoa() { InitializeComponent(); truoc = sau = DateServer.Date(); SelectData(); dtgvhienthi.DataSource = new Entities.BCXuatHuyHangHoa[0]; makho = new Common.Utilities().CaiDatKho("View", "", "").Giatritruyen; if (makho == "") { MessageBox.Show("Bạn chưa cài đặt kho - Xin hãy kiểm tra lại", "Hệ thống cảnh báo"); } TongTienNhanVien(); fix(); }
public frmSoDuKhoHang() { InitializeComponent(); try { datesv = DateServer.Date(); LayHangHoa(); toolStrip1.Enabled = false; LayKhoHang(); cbbkhohang.DataSource = khohang; cbbkhohang.DisplayMember = "TenKho"; } catch { } }
public frmSoDuKhachHang() { try { InitializeComponent(); datesv = DateServer.Date(); cbbnam.Text = datesv.Year.ToString(); cbbthang.Text = datesv.Month.ToString(); cbbdoituong.SelectedIndex = 0; SelectData(); } catch { } }
public void hienthi() { Server_Client.Client cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Pdck = new PhieuDieuChuyenKhoNoiBo("Select", 1, "a", DateServer.Date(), "a", "a", "a", "a", "a", false, "a", false); clientstrem = cl.SerializeObj(this.client1, "PhieuDieuCHuyenKhoNoiBo", Pdck); PhieuDieuChuyenKhoNoiBo[] pdck1 = new PhieuDieuChuyenKhoNoiBo[1]; pdck1[0] = new PhieuDieuChuyenKhoNoiBo(1, "a", DateServer.Date(), "a", "a", "a", false, "a", false); pdck1 = (PhieuDieuChuyenKhoNoiBo[])cl.DeserializeHepper1(clientstrem, pdck1); ////PDCK_Search = pdck1; if (pdck1 == null) { Entities.PhieuDieuChuyenKhoNoiBo[] a = new PhieuDieuChuyenKhoNoiBo[0]; dgvHienThi.DataSource = a; PDCK_Search = a; FixDataGridView(); toolStripStatus_Sua.Enabled = false; toolStripStatus_ChiTiet.Enabled = false; } else { int count = 0; for (int i = 0; i < pdck1.Length; i++) { if (pdck1[i].XacNhan == false) { count++; } } PhieuDieuChuyenKhoNoiBo[] pdck2 = new PhieuDieuChuyenKhoNoiBo[count]; count = 0; for (int i = 0; i < pdck1.Length; i++) { if (pdck1[i].XacNhan == false) { pdck2[count] = pdck1[i]; count++; } } PDCK_Search = pdck2; dgvHienThi.DataSource = pdck2; FixDataGridView(); toolStripStatus_Sua.Enabled = true; toolStripStatus_ChiTiet.Enabled = true; } }
private void frmTimKiemChungTu_Load(object sender, EventArgs e) { try { truoc = DateServer.Date(); sau = DateServer.Date(); HienThi(); fixChiTiet(); fixHienThi(); label1.Text = "Tìm Kiếm Chứng Từ " + new Common.Utilities().XuLy(2, truoc.ToShortDateString()) + " đến ngày " + new Common.Utilities().XuLy(2, sau.ToShortDateString()); } catch { } }
public frmBCMucTonToiThieuToiDa() { try { InitializeComponent(); datesv = DateServer.Date(); KhoHang(); ChiTietKhoHang(); HangHoa(); dtgvhienthi.DataSource = khohang; fix(); } catch { } }
public frmSoquy(string nam, string thang) { InitializeComponent(); try { datesv = DateServer.Date(); batdau = true; cbbnam.Text = datesv.Year.ToString(); cbbthang.Text = datesv.Month.ToString(); month = thang; year = nam; } catch { } SelectSoQuy(); HienThiTongThe(); }
public frmBCXuatNhapTonNhomHang() { try { InitializeComponent(); nam = DateServer.Date().Year; thang = DateServer.Date().Month; cbbthang.Text = thang.ToString(); cbbnam.Text = nam.ToString(); SelectData(); TongTienNhanVien(); } catch { } }
public frmXuLyNhaCungCap(string str1, string str2, DataGridViewRow dgvNCC) { try { InitializeComponent(); datesv = DateServer.Date(); XuLyString(str1, str2); id = dgvNCC.Cells["NhaCungCapID"].Value.ToString(); mancc = txtMaNCC.Text = dgvNCC.Cells["MaNhaCungCap"].Value.ToString(); tenncc = txtTenNCC.Text = dgvNCC.Cells["TenNhaCungCap"].Value.ToString(); diachi = txtDiaChi.Text = dgvNCC.Cells["DiaChi"].Value.ToString(); dienthoai = mktxtdienthoai.Text = dgvNCC.Cells["DienThoai"].Value.ToString(); fax = txtFax.Text = dgvNCC.Cells["Fax"].Value.ToString(); email = txtEmail.Text = dgvNCC.Cells["Email"].Value.ToString(); website = txtWebsite.Text = dgvNCC.Cells["Website"].Value.ToString(); mst = txtMasothue.Text = dgvNCC.Cells["MST"].Value.ToString(); nguoilienhe = txtNguoilienhe.Text = dgvNCC.Cells["NguoiLienHe"].Value.ToString(); ghichu = txtGhichu.Text = dgvNCC.Cells["GhiChu"].Value.ToString(); duno = txtduno.Text = dgvNCC.Cells["DuNo"].Value.ToString(); Entities.DonHangNCC[] lay = new Entities.DonHangNCC[0]; dataGridView1.DataSource = lay; for (int j = 1; j < dataGridView1.ColumnCount; j++) { dataGridView1.Columns[j].Visible = false; } dataGridView1.RowHeadersVisible = false; dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[1].Visible = true; dataGridView1.Columns[1].HeaderText = "Mã Đơn Đặt Hàng"; dataGridView1.Columns[2].Visible = true; dataGridView1.Columns[2].HeaderText = "Mã Nhà Cung Cấp"; dataGridView1.Columns[3].Visible = true; dataGridView1.Columns[3].HeaderText = "Ngày Đơn Hàng"; dataGridView1.Columns[4].Visible = true; dataGridView1.Columns[4].HeaderText = "Trạng Thái Đơn Hàng"; dataGridView1.Columns[5].Visible = true; dataGridView1.Columns[5].HeaderText = "Hình Thức Thanh Toán"; dataGridView1.Columns[6].HeaderText = "Tổng Tiền"; dataGridView1.Columns[6].Visible = true; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.AllowUserToAddRows = false; dataGridView1.AllowUserToDeleteRows = false; dataGridView1.AllowUserToResizeRows = false; } catch { } }
public frm_Xuly_XacNhanDieuChuyenKho(DataGridViewRow dgvr) { InitializeComponent(); datesv = DateServer.Date(); LayKhoHang(cbxTukho, dgvr.Cells[4].Value.ToString()); LayKhoHang(cbxDenkho, dgvr.Cells[6].Value.ToString()); HienThi(dgvr); if (txtSochungtunhap.Text == "") { HienThiChiTietTheoPDCK(txtSochungtu.Text); } else { if (txtSochungtunhap.Text != "") { HienThiChiTiet(txtSochungtunhap.Text, cbxTukho.Text); } } }
public frmBCLaiLo() { try { InitializeComponent(); datesv = DateServer.Date(); nam = datesv.Year; thang = datesv.Month; cbbthang.Text = thang.ToString(); cbbnam.Text = nam.ToString(); giaVon = GiaVon(); HDBanHang(); ChiTietHDBanHang(); HangHoa(); GoiHang(); TongTienNhanVien(); } catch { } }
public frmBCDoanhThuHangHoa() { try { InitializeComponent(); SelectAll(); datesv = DateServer.Date(); cbbnam.Text = datesv.Year.ToString(); cbbthang.Text = datesv.Month.ToString(); cbbngay.Text = datesv.Day.ToString(); batdau = Convert.ToDateTime(cbbthang.Text + "/" + cbbngay.Text + "/" + cbbnam.Text).ToShortDateString(); ketthuc = batdau; truoc = Convert.ToDateTime(batdau); sau = Convert.ToDateTime(ketthuc); TongTienHangHoa(truoc, sau); fix(); } catch { } }
public frmBCCongNoKhachHang() { InitializeComponent(); try { datesv = DateServer.Date(); batdau = new Common.Utilities().MyDateConversion("01/" + datesv.Month.ToString() + "/" + datesv.Year.ToString()); if (datesv.Month.ToString() == "12") { ketthuc = new Common.Utilities().MyDateConversion("01/01/" + (Convert.ToInt32(datesv.Year.ToString()) + 1).ToString()); } else { ketthuc = new Common.Utilities().MyDateConversion("01/" + (Convert.ToInt32(datesv.Month.ToString()) + 1).ToString() + "/" + datesv.Year.ToString()); } truoc = Convert.ToDateTime(batdau); sau = Convert.ToDateTime(ketthuc); } catch { } }
public frmBCNhapHangTheoNhom() { try { InitializeComponent(); datesv = DateServer.Date(); nam = datesv.Year; thang = datesv.Month; cbbthang.Text = thang.ToString(); cbbnam.Text = nam.ToString(); //DateTime a = DateTime.Now; BCNhapHangTheoNhomHang(); //DateTime b = DateTime.Now; //double c = (b - a).TotalMilliseconds; //498.0285 415.0238 449.0256 //DateTime aa = DateTime.Now; TinhToan(); //DateTime bb = DateTime.Now; //double cc = (bb - aa).TotalMilliseconds; //177.0102 //HoaDonNhap(); //ChiTietHoaDonNhap(); //PhieuDieuChuyenKhoNoiBo(); //ChiTietPhieuDieuChuyenKho(); //KhachHangTraLai(); //ChiTietKhachHangTraLai(); //HangHoa(); //NhomHang(); //GoiHang(); //ChiTietGoiHang(); //TongTienNhanVien(); } catch { } }