/// <summary> /// hungvv =======================Xoa =========================== /// </summary> private void DeleteData(string ID) { try { ctdh = new Entities.KhachHangTraLai(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.KhachHangTraLai("Delete", ID); clientstrem = cl.SerializeObj(this.client, "KhachHangTraLai", ctdh); int trave = 0; trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, trave)); client.Close(); clientstrem.Close(); if (trave >= 1) { SelectData(""); } else { MessageBox.Show("Thất bại !"); } } catch (Exception ex) { string s = ex.Message; } }
/// <summary> /// hungvv =======================giao tiep voi server=========================== /// </summary> private void SelectData(string ID) { try { dgvHienThi.DataSource = null; ctdh = new Entities.KhachHangTraLai(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.KhachHangTraLai("Select", ID); clientstrem = cl.SerializeObj(this.client, "KhachHangTraLai", ctdh); Entities.KhachHangTraLai[] ddh = new Entities.KhachHangTraLai[1]; ddh = (Entities.KhachHangTraLai[])cl.DeserializeHepper(clientstrem, ddh); client.Close(); clientstrem.Close(); if (ddh.Length > 0) { search = new Entities.KhachHangTraLai[ddh.Length]; search = ddh; dgvHienThi.DataSource = null; dgvHienThi.DataSource = ddh; rdoTatca.Checked = true; } else { CapNhat(dgvHienThi); } fixDatagridview(); } catch (Exception ex) { string s = ex.Message; CapNhat(dgvHienThi); fixDatagridview(); } }
/// <summary> /// hungvv =================sua==================== /// </summary> /// <returns></returns> private Entities.KhachHangTraLai getDatagridview() { Entities.KhachHangTraLai tralai = new Entities.KhachHangTraLai(); int x = dgvHienThi.RowCount; int y = dgvHienThi.ColumnCount; if (y <= -1 || x <= -1) { } else { int vitri = dgvHienThi.CurrentRow.Index; tralai.MaKhachHangTraLai = "" + dgvHienThi.Rows[vitri].Cells["MaKhachHangTraLai"].Value.ToString(); tralai.NgayNhap = Convert.ToDateTime("" + dgvHienThi.Rows[vitri].Cells["NgayNhap"].Value.ToString()); tralai.MaKhachHang = "" + dgvHienThi.Rows[vitri].Cells[4].Value.ToString(); tralai.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString(); tralai.NguoiTra = "" + dgvHienThi.Rows[vitri].Cells[6].Value.ToString(); tralai.HinhThucThanhToan = "" + dgvHienThi.Rows[vitri].Cells["HinhThucThanhToan"].Value.ToString(); tralai.HanThanhToan = Convert.ToDateTime("" + dgvHienThi.Rows[vitri].Cells["HanThanhToan"].Value.ToString()); tralai.MaHoaDonMuaHang = dgvHienThi.Rows[vitri].Cells["MaHoaDonMuaHang"].Value.ToString(); tralai.MaKho = "" + dgvHienThi.Rows[vitri].Cells["MaKho"].Value.ToString(); tralai.MaTienTe = "" + dgvHienThi.Rows[vitri].Cells["MaTienTe"].Value.ToString(); tralai.TienBoiThuong = dgvHienThi.Rows[vitri].Cells["TienBoiThuong"].Value.ToString(); tralai.ThanhToanNgay = dgvHienThi.Rows[vitri].Cells["ThanhToanNgay"].Value.ToString(); tralai.ThueGTGT = dgvHienThi.Rows[vitri].Cells["ThueGTGT"].Value.ToString(); tralai.GhiChu = "" + dgvHienThi.Rows[vitri].Cells["GhiChu"].Value.ToString(); } return(tralai); }
public void LayKHTL() { try { List <Entities.KhachHangTraLai> listTemp = new List <Entities.KhachHangTraLai>(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.KhachHangTraLai KHTL1 = new Entities.KhachHangTraLai("Select"); clientstrem = cl.SerializeObj(this.client, "KHTL", KHTL1); Entities.KhachHangTraLai[] HDN = new Entities.KhachHangTraLai[1]; HDN = (Entities.KhachHangTraLai[])cl.DeserializeHepper(clientstrem, HDN); // if (HDN == null) { HDN = new Entities.KhachHangTraLai[0]; } // for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { listTemp.Add(HDN[i]); } } // KHTL = listTemp.ToArray(); } catch { } }
/// <summary> /// select khách hàng trả lại /// </summary> private void SelectKHTL() { try { Entities.KhachHangTraLai[] pt2 = new Entities.KhachHangTraLai[kh.Length]; int sotang = 0; for (int j = 0; j < kh.Length; j++) { string month1 = kh[j].NgayNhap.Month.ToString(); string year1 = kh[j].NgayNhap.Year.ToString(); if (kh[j].Deleted == false) { if (month == month1 && year1 == year && Convert.ToDouble(kh[j].ThanhToanNgay) != 0) { sl++; pt2[sotang] = kh[j]; sotang++; } } } kh = new Entities.KhachHangTraLai[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { kh[j] = pt2[j]; } } else { kh = new Entities.KhachHangTraLai[0]; } } catch { } }
public frmXuLy_HangTraLai(string hanhdong, string tenForm, string truyen, Entities.KhachHangTraLai add) { InitializeComponent(); this.HanhDong = hanhdong; this.tenForm = tenForm; this.truyen = truyen; this.update = add; }
public Entities.KhachHangTraLai[] KhachHangTraLai() { Entities.KhachHangTraLai[] select = (Entities.KhachHangTraLai[]) new BizLogic.CongNo().SelectKHTL(); if (select == null) { select = new Entities.KhachHangTraLai[0]; } return(select); }
private void CapNhat(DataGridView dgv) { try { Entities.KhachHangTraLai[] lay = new Entities.KhachHangTraLai[0]; dgv.DataSource = lay; } catch (Exception ex) { string s = ex.Message; } }
public void LayKHTL() { try { Entities.KhachHangTraLai[] HDN = new Entities.KhachHangTraLai[1]; HDN = new BizLogic.KhachHangTraLai().Select(); if (HDN == null) { KHTL = new Entities.KhachHangTraLai[0]; return; } int count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { count++; } } Entities.KhachHangTraLai[] khtl1 = new Entities.KhachHangTraLai[count]; count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { khtl1[count] = HDN[i]; count++; } } if (khtl1.Length == 0) { KHTL = new Entities.KhachHangTraLai[0]; return; } else { KHTL = khtl1; } } catch { } }
/// <summary> /// hungvv =======================giao tiep voi server=========================== /// </summary> private void SelectData() { dgvHienThi.DataSource = null; ctdh = new Entities.KhachHangTraLai(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.KhachHangTraLai("Select"); clientstrem = cl.SerializeObj(this.client, "KhachHangTraLai", ctdh); Entities.KhachHangTraLai[] ddh = new Entities.KhachHangTraLai[1]; ddh = (Entities.KhachHangTraLai[])cl.DeserializeHepper(clientstrem, ddh); dgvHienThi.DataSource = ddh; dgvHienThi.Columns[1].Visible = false; dgvHienThi.Columns[0].HeaderText = "STT"; new Common.Utilities().CountDatagridview(dgvHienThi); client.Close(); clientstrem.Close(); }
/// <summary> /// hungvv =================sua==================== /// </summary> /// <returns></returns> private Entities.KhachHangTraLai getDatagridview() { Entities.KhachHangTraLai tralai = new Entities.KhachHangTraLai(); try { if (dgvHienThi.RowCount > 0) { int x = dgvHienThi.RowCount; int y = dgvHienThi.ColumnCount; if (y <= -1 || x <= -1) { } else { int vitri = dgvHienThi.CurrentRow.Index; tralai.KhachHangTraLaiID = int.Parse(dgvHienThi.Rows[vitri].Cells[1].Value.ToString()); tralai.MaKhachHangTraLai = dgvHienThi.Rows[vitri].Cells[2].Value.ToString(); tralai.NgayNhap = Convert.ToDateTime(dgvHienThi.Rows[vitri].Cells[3].Value.ToString()); tralai.MaKhachHang = dgvHienThi.Rows[vitri].Cells[4].Value.ToString(); tralai.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString(); tralai.NguoiTra = dgvHienThi.Rows[vitri].Cells[6].Value.ToString(); tralai.HinhThucThanhToan = dgvHienThi.Rows[vitri].Cells[7].Value.ToString(); tralai.HanThanhToan = Convert.ToDateTime(dgvHienThi.Rows[vitri].Cells[8].Value.ToString()); tralai.MaHoaDonMuaHang = dgvHienThi.Rows[vitri].Cells[9].Value.ToString(); tralai.MaKho = dgvHienThi.Rows[vitri].Cells[10].Value.ToString(); tralai.MaTienTe = dgvHienThi.Rows[vitri].Cells[11].Value.ToString(); tralai.TienBoiThuong = dgvHienThi.Rows[vitri].Cells[12].Value.ToString(); tralai.ThanhToanNgay = dgvHienThi.Rows[vitri].Cells[13].Value.ToString(); tralai.ThueGTGT = dgvHienThi.Rows[vitri].Cells[14].Value.ToString(); tralai.GhiChu = dgvHienThi.Rows[vitri].Cells[15].Value.ToString(); tralai.Deleted = Boolean.Parse(dgvHienThi.Rows[vitri].Cells[16].Value.ToString()); } } else { } } catch (Exception ex) { string s = ex.Message.ToString(); } return(tralai); }
/// <summary> /// select khách hàng trả lại /// </summary> private void SelectKHTL() { try { if (khtl == null || khtl.Length == 0) { khtl = new Entities.KhachHangTraLai[0]; return; } Entities.KhachHangTraLai[] pt2 = new Entities.KhachHangTraLai[khtl.Length]; int sotang = 0; for (int j = 0; j < khtl.Length; j++) { DateTime hientai = khtl[j].NgayNhap; if (khtl[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date&& hientai.Date < Convert.ToDateTime(ketthuc).Date) { pt2[sotang] = khtl[j]; sotang++; } } khtl = new Entities.KhachHangTraLai[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { khtl[j] = pt2[j]; } } else { khtl = new Entities.KhachHangTraLai[0]; } } catch (Exception ex) { } finally { } }
/// <summary> /// hungvv =======================Xoa =========================== /// </summary> private void DeleteData(string ID) { ctdh = new Entities.KhachHangTraLai(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); ctdh = new Entities.KhachHangTraLai("Delete", ID); clientstrem = cl.SerializeObj(this.client, "KhachHangTraLai", ctdh); int trave = 0; trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, trave)); client.Close(); clientstrem.Close(); if (trave == 1) { SelectData(); MessageBox.Show("Thành công !"); } if (trave == 0) { MessageBox.Show("Thất bại !"); } }
/// <summary> /// hungvv =================sua==================== /// </summary> /// <returns></returns> private Entities.KhachHangTraLai getDatagridview() { Entities.KhachHangTraLai tralai = new Entities.KhachHangTraLai(); int x = dgvHienThi.RowCount; int y = dgvHienThi.ColumnCount; if (y <= -1 || x <= -1) { } else { int vitri = dgvHienThi.CurrentRow.Index; tralai.MaKhachHangTraLai = "" + dgvHienThi.Rows[vitri].Cells["MaKhachHangTraLai"].Value.ToString(); tralai.NgayNhap = Convert.ToDateTime("" + dgvHienThi.Rows[vitri].Cells["NgayNhap"].Value.ToString()); tralai.MaKhachHang = "" + dgvHienThi.Rows[vitri].Cells[4].Value.ToString(); tralai.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString(); tralai.NguoiTra = "" + dgvHienThi.Rows[vitri].Cells[6].Value.ToString(); tralai.HinhThucThanhToan = "" + dgvHienThi.Rows[vitri].Cells["HinhThucThanhToan"].Value.ToString(); tralai.HanThanhToan = Convert.ToDateTime("" + dgvHienThi.Rows[vitri].Cells["HanThanhToan"].Value.ToString()); tralai.MaHoaDonMuaHang = dgvHienThi.Rows[vitri].Cells["MaHoaDonMuaHang"].Value.ToString(); tralai.MaKho = "" + dgvHienThi.Rows[vitri].Cells["MaKho"].Value.ToString(); tralai.MaTienTe = "" + dgvHienThi.Rows[vitri].Cells["MaTienTe"].Value.ToString(); tralai.TienBoiThuong = dgvHienThi.Rows[vitri].Cells["TienBoiThuong"].Value.ToString(); tralai.ThanhToanNgay = dgvHienThi.Rows[vitri].Cells["ThanhToanNgay"].Value.ToString(); tralai.ThueGTGT = dgvHienThi.Rows[vitri].Cells["ThueGTGT"].Value.ToString(); tralai.GhiChu = "" + dgvHienThi.Rows[vitri].Cells["GhiChu"].Value.ToString(); } return tralai; }
public void LayKHTL() { try { Entities.KhachHangTraLai[] HDN = new Entities.KhachHangTraLai[1]; HDN = new BizLogic.KhachHangTraLai().Select(); if (HDN == null) { KHTL = new Entities.KhachHangTraLai[0]; return; } int count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { count++; } } Entities.KhachHangTraLai[] khtl1 = new Entities.KhachHangTraLai[count]; count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { khtl1[count] = HDN[i]; count++; } } if (khtl1.Length == 0) { KHTL = new Entities.KhachHangTraLai[0]; return; } else KHTL = khtl1; } catch { } }
public void CheckUpdateKHTL() { kt = false; cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhachHangTraLai ctk = new Entities.KhachHangTraLai(); ctk = new Entities.KhachHangTraLai("Select"); Entities.KhachHangTraLai[] ctk1 = new Entities.KhachHangTraLai[1]; clientstrem = cl.SerializeObj(this.client1, "KhachHangTraLai", ctk); ctk1 = (Entities.KhachHangTraLai[])cl.DeserializeHepper1(clientstrem, ctk1); dgvXemthongtin.DataSource = ctk; if (ctk != null) { for (int j = 0; j < ctk1.Length; j++) { if (ctk1[j].MaKhachHangTraLai == sodonhang) { kt = CheckKHTL(ctk1[j]); if (kt == false) MessageBox.Show("đã cật nhập 1 số trường thay đổi - kiểm tra lại", "hệ thống cảnh báo"); break; } else kt = true; } } }
/// <summary> /// hungvv ========================================them moi hoac sua=============== /// </summary> private void XuLy_TraLaiNhaCungCap(string hanhdong) { try { Entities.TraLaiNCC xuly = new Entities.TraLaiNCC(); string thoigian_1 = null; thoigian_1 = new Common.Utilities().MyDateConversion(makNgaydonhang.Text); if (thoigian_1 != null) { xuly.Ngaytra = DateTime.Parse(thoigian_1); thoigian_1 = null; xuly.Hanhdong = hanhdong; xuly.MaHDTraLaiNCC = txtSodonhang.Text.ToUpper(); xuly.MaNCC = txtMakhachhang.Text.ToUpper(); xuly.NoHienThoi = 0 + txtNohienthoi.Text; xuly.NguoiNhanHang = "" + txtNguoitra.Text; xuly.HinhThucThanhToan = cbxHinhthucthanhtoan.SelectedItem.ToString(); xuly.MaHoaDonNhap = txtChungtugoc.Text.ToUpper(); xuly.MaKho = cbxKhoHang.SelectedValue.ToString().ToUpper(); xuly.MaTienTe = cbxTiente_Tygia.SelectedValue.ToString().ToUpper(); xuly.TienBoiThuong = 0 + txtTienboithuong.Text; xuly.ThanhToanNgay = 0 + txtThanhtoanngay.Text; xuly.ThueGTGT = 0 + txtGiatrigiatang.Text; xuly.GhiChu = "" + txtDiengiai.Text; xuly.Deleted = false; if (dgvXemthongtin.RowCount > 0) { if (CheckData(xuly) == true) { CheckInsertTLNCC(); if (kt == true) { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "TraLaiNhaCungCap", xuly); Entities.KhachHangTraLai[] tralai = new Entities.KhachHangTraLai[1]; int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai)); if (trave == 1) { LuuChiTietTraLaiNhaCungCap(); CheckDataGridTruSL(dgvXemthongtin); MessageBox.Show("Thành công"); } else { MessageBox.Show("Thất bại"); } } } } else { MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); } } else { MessageBox.Show("Kiểm tra ngày"); } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show("Thông tin nhập không đúng"); } }
/// <summary> /// select khách hàng trả lại /// </summary> private void SelectKHTL() { try { Entities.KhachHangTraLai[] pt2 = new Entities.KhachHangTraLai[kh.Length]; int sotang = 0; for (int j = 0; j < kh.Length; j++) { if (kh[j].Deleted == false) { if (batDau <= kh[j].NgayNhap && kh[j].NgayNhap <= ketThuc && Convert.ToDouble(kh[j].ThanhToanNgay) != 0) { sl++; pt2[sotang] = kh[j]; sotang++; } } } kh = new Entities.KhachHangTraLai[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { kh[j] = pt2[j]; } } else kh = new Entities.KhachHangTraLai[0]; } catch (Exception ex) { } finally { } }
private void XuLy_TraLaiNhaCungCap(string hanhdong) { try { Entities.TraLaiNCC xuly = new Entities.TraLaiNCC(); Common.Utilities ck = new Common.Utilities(); //Mrk Fix 3/2/2013 string _makNgaydonhang = makNgaydonhang.Text; if (string.IsNullOrEmpty(_makNgaydonhang)) { MessageBox.Show("Vui lòng kiểm tra lại ngày! \r\nkhông được phép rỗng!"); return; } string[] temp = _makNgaydonhang.Split('/'); DateTime temp_date1 = new DateTime(int.Parse(temp[2]), int.Parse(temp[1]), int.Parse(temp[0])); DateTime temp_date2 = DateServer.Date(); if (temp_date1.Date >= temp_date2.Date) { xuly.Ngaytra = temp_date1; /////////////////////////////////////////////////////// //string thoigian_1 = makNgaydonhang.Text; //string thoigian_sosanh = DateServer.Date().ToString("dd/MM/yyyy"); //if (ck.SoSanhNgay('/', ">=", thoigian_1, thoigian_sosanh) == true && thoigian_1 != null) //{ //xuly.Ngaytra = DateTime.Parse(new Common.Utilities().KiemTraDinhDangNgayThangNam("ThangNgayNam", thoigian_1, '/')); //thoigian_1 = null; xuly.Hanhdong = hanhdong; xuly.TraLaiNCCID = NhaCungCapID; xuly.MaHDTraLaiNCC = txtSodonhang.Text; xuly.NoHienThoi = txtNohienthoi.Text; xuly.MaNCC = txtMakhachhang.Text; xuly.NguoiNhanHang = "" + txtNguoitra.Text; xuly.HinhThucThanhToan = cbxHinhthucthanhtoan.SelectedItem.ToString(); xuly.MaHoaDonNhap = txtChungtugoc.Text; xuly.MaKho = cbxKhoHang.SelectedValue.ToString(); xuly.MaTienTe = cbxTiente_Tygia.SelectedValue.ToString(); xuly.TienBoiThuong = txtTongtienthanhtoan.Text; xuly.ThanhToanNgay = Double.Parse(0 + txtThanhtoanngay.Text).ToString(); xuly.ThueGTGT = 0 + txtGiatrigiatang.Text; xuly.GhiChu = "" + txtDiengiai.Text; xuly.Deleted = false; xuly.Manhanvien = Common.Utilities.User.NhanVienID; xuly.Tendangnhap = Common.Utilities.User.TenDangNhap; if (dgvXemthongtin.RowCount > 0) { if (CheckDataNhaCungCap(xuly) == true) { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "TraLaiNhaCungCap", xuly); Entities.KhachHangTraLai[] tralai = new Entities.KhachHangTraLai[1]; int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai)); if (trave == 1) { if (CapNhatDuNoNhaCungCap() >= 1) { LuuChiTietTraLaiNhaCungCap(); } else { MessageBox.Show("Chưa cập nhật dư nợ nhà cung cấp"); } } else { MessageBox.Show("Thất bại"); } } } else { MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); } } else { MessageBox.Show("Kiểm tra ngày"); } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show("Thông tin nhập không đúng"); } }
private void XuLy_KhachHangTraLai(string hanhdong) { try { Entities.KhachHangTraLai xuly = new Entities.KhachHangTraLai(); Common.Utilities ck = new Common.Utilities(); //Mrk Fix 3/2/2013 string _makNgaydonhang = makNgaydonhang.Text; string _makHanthanhtoan = makHanthanhtoan.Text; //if (string.IsNullOrEmpty(_makNgaydonhang)) //{ // MessageBox.Show("Vui lòng kiểm tra lại ngày đơn hàng! \r\nkhông được phép rỗng!"); // return; //} //else if (string.IsNullOrEmpty(_makHanthanhtoan)) //{ // MessageBox.Show("Vui lòng kiểm tra lại Hạn thanh toán! \r\nkhông được phép rỗng!"); // return; //} string[] temp_makNgaydonhang = _makNgaydonhang.Split('/'); string[] temp_makHanthanhtoan = _makHanthanhtoan.Split('/'); DateTime temp_date1 = new DateTime(int.Parse(temp_makNgaydonhang[2]), int.Parse(temp_makNgaydonhang[1]), int.Parse(temp_makNgaydonhang[0])); DateTime temp_date11 = new DateTime(int.Parse(temp_makHanthanhtoan[2]), int.Parse(temp_makHanthanhtoan[1]), int.Parse(temp_makHanthanhtoan[0])); DateTime temp_date2 = DateServer.Date(); if (temp_date1.Date >= temp_date2.Date) { xuly.NgayNhap = temp_date1; xuly.HanThanhToan = temp_date11; /////////////////////////////////////////////////////// //string thoigian_1 = makNgaydonhang.Text; //string thoigian_2 = makHanthanhtoan.Text; //string thoigian_sosanh = DateServer.Date().ToString("dd/MM/yyyy"); //if (ck.SoSanhNgay('/', ">=", thoigian_1, thoigian_sosanh) == true) //{ //xuly.NgayNhap = DateTime.Parse(new Common.Utilities().KiemTraDinhDangNgayThangNam("ThangNgayNam", thoigian_1, '/')); //thoigian_1 = null; //xuly.HanThanhToan = DateTime.Parse(new Common.Utilities().KiemTraDinhDangNgayThangNam("ThangNgayNam", thoigian_2, '/')); //thoigian_2 = null; xuly.Hanhdong = hanhdong; xuly.KhachHangTraLaiID = KhachHangID; xuly.MaKhachHangTraLai = txtSodonhang.Text; string maKH = txtMakhachhang.Text; if (maKH.ToUpper().Equals("<F4 - TRA CỨU>")) maKH = string.Empty; xuly.MaKhachHang = maKH; xuly.NoHienThoi = txtNohienthoi.Text; xuly.NguoiTra = "" + txtNguoitra.Text; xuly.HinhThucThanhToan = cbxHinhthucthanhtoan.SelectedItem.ToString(); string ma = txtChungtugoc.Text; if (ma.ToUpper().Equals("<F4 - TRA CỨU>") || ma.Length <= 0) { ma = string.Empty; } xuly.MaHoaDonMuaHang = ma; xuly.MaKho = cbxKhoHang.SelectedValue.ToString(); xuly.MaTienTe = cbxTiente_Tygia.SelectedValue.ToString(); xuly.TienBoiThuong = txtTongtienthanhtoan.Text; string tnn = "0"; if (txtThanhtoanngay.Text == "") tnn = "0"; else tnn = txtThanhtoanngay.Text; if (Double.Parse(tnn) < 0) { xuly.ThanhToanNgay = "0"; } else { xuly.ThanhToanNgay = tnn; } xuly.ThueGTGT = txtGiatrigiatang.Text; xuly.GhiChu = "" + txtDiengiai.Text; xuly.Deleted = false; xuly.Manhanvien = Common.Utilities.User.NhanVienID; xuly.Tendangnhap = Common.Utilities.User.TenDangNhap; if (dgvXemthongtin.RowCount > 0) { if (CheckData(xuly) == true) { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "KhachHangTraLai", xuly); Entities.KhachHangTraLai[] tralai = new Entities.KhachHangTraLai[1]; int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai)); if (trave >= 1) { if (rdoBanbuon.Checked == true) { if (CapNhatDuNoKhachHang() >= 1) { LuuChiTietKhachHangTraLai(); } else { MessageBox.Show("Chưa cập nhập dư nợ khách hàng"); } } else { LuuChiTietKhachHangTraLai(); } } else { MessageBox.Show("Thất bại"); } } } else { MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); } } else { MessageBox.Show("Kiểm tra ngày"); } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show("Thất bại"); } }
private Entities.KhachHangTraLai ConfilickData(string table, string values) { Entities.KhachHangTraLai ddh = new Entities.KhachHangTraLai(); try { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.TruyenGiaTri gitri = new Entities.TruyenGiaTri("Select", table, values); clientstrem = cl.SerializeObj(this.client, "CheckKhachHangTraLai", gitri); ddh = (Entities.KhachHangTraLai)cl.DeserializeHepper(clientstrem, ddh); } catch (Exception ex) { string s = ex.Message.ToString(); ddh = null; } return ddh; }
/// <summary> /// select khách hàng trả lại /// </summary> private void SelectKHTL() { try { if (khtl == null || khtl.Length == 0) { khtl = new Entities.KhachHangTraLai[0]; return; } Entities.KhachHangTraLai[] pt2 = new Entities.KhachHangTraLai[khtl.Length]; int sotang = 0; for (int j = 0; j < khtl.Length; j++) { DateTime hientai = khtl[j].NgayNhap; if (khtl[j].Deleted == false && hientai.Date >= Convert.ToDateTime(batdau).Date && hientai.Date < Convert.ToDateTime(ketthuc).Date) { pt2[sotang] = khtl[j]; sotang++; } } khtl = new Entities.KhachHangTraLai[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { khtl[j] = pt2[j]; } } else khtl = new Entities.KhachHangTraLai[0]; } catch (Exception ex) { } finally { } }
public void CheckInsertKHTL() { kt = false; cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhachHangTraLai ctk = new Entities.KhachHangTraLai(); ctk = new Entities.KhachHangTraLai("Select"); clientstrem = cl.SerializeObj(this.client1, "KhachHangTraLai", ctk); Entities.KhachHangTraLai[] ctk1 = new Entities.KhachHangTraLai[1]; ctk1 = (Entities.KhachHangTraLai[])cl.DeserializeHepper1(clientstrem, ctk1); dgvXemthongtin.DataSource = ctk; if (ctk != null) { for (int j = 0; j < ctk1.Length; j++) { if (ctk1[j].MaKhachHangTraLai == sodonhang) { MessageBox.Show("cập nhật mã phiếu - kiểm tra lại để insert"); kt = false; sodonhang = txtSodonhang.Text = new Common.Utilities().ProcessID(txtSodonhang.Text); break; } else kt = true; } } }
/// <summary> /// hungvv ========================================them moi hoac sua=============== /// </summary> private void XuLy_KhachHangTraLai(string hanhdong) { try { Entities.KhachHangTraLai xuly = new Entities.KhachHangTraLai(); string thoigian_1 = null; thoigian_1 = new Common.Utilities().MyDateConversion(makNgaydonhang.Text); string thoigian_2 = null; thoigian_2 = new Common.Utilities().MyDateConversion(makHanthanhtoan.Text); if (thoigian_1 != null && thoigian_2 != null) { xuly.NgayNhap = DateTime.Parse(thoigian_1); thoigian_1 = null; xuly.HanThanhToan = DateTime.Parse(thoigian_2); thoigian_2 = null; xuly.Hanhdong = hanhdong; xuly.MaKhachHangTraLai = txtSodonhang.Text.ToUpper(); xuly.MaKhachHang = txtMakhachhang.Text.ToUpper(); xuly.NoHienThoi = float.Parse(0 + txtNohienthoi.Text).ToString(); xuly.NguoiTra = "" + txtNguoitra.Text; xuly.HinhThucThanhToan = cbxHinhthucthanhtoan.SelectedItem.ToString(); xuly.MaHoaDonMuaHang = "" + txtChungtugoc.Text.ToUpper(); xuly.MaKho = cbxKhoHang.SelectedValue.ToString().ToUpper(); xuly.MaTienTe = cbxTiente_Tygia.SelectedValue.ToString().ToUpper(); xuly.TienBoiThuong = 0 + txtTienboithuong.Text; xuly.ThanhToanNgay = 0 + txtThanhtoanngay.Text; xuly.ThueGTGT = 0 + txtGiatrigiatang.Text; xuly.GhiChu = "" + txtDiengiai.Text; xuly.Deleted = false; if (dgvXemthongtin.RowCount > 0) { if (CheckData(xuly) == true) { if (hanhdong == "Insert") CheckInsertKHTL(); else if (hanhdong == "Update") CheckUpdateKHTL(); if (kt == true) { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "KhachHangTraLai", xuly); int trave1 = 0; trave1 = (int)cl.DeserializeHepper(clientstrem, trave1); if (trave1 == 1) { LuuChiTietKhachHangTraLai(); MessageBox.Show("Thành công"); this.Close(); } else { MessageBox.Show("Thất bại"); } } else return; } } else { MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); } } else { MessageBox.Show("Kiểm tra ngày"); } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show("Thông tin nhập không đúng"); } }
/// <summary> /// hungvv =================sua==================== /// </summary> /// <returns></returns> private Entities.KhachHangTraLai getDatagridview() { Entities.KhachHangTraLai tralai = new Entities.KhachHangTraLai(); try { if (dgvHienThi.RowCount > 0) { int x = dgvHienThi.RowCount; int y = dgvHienThi.ColumnCount; if (y <= -1 || x <= -1) { } else { int vitri = dgvHienThi.CurrentRow.Index; tralai.KhachHangTraLaiID = int.Parse(dgvHienThi.Rows[vitri].Cells[1].Value.ToString()); tralai.MaKhachHangTraLai = dgvHienThi.Rows[vitri].Cells[2].Value.ToString(); tralai.NgayNhap = Convert.ToDateTime(dgvHienThi.Rows[vitri].Cells[3].Value.ToString()); tralai.MaKhachHang = dgvHienThi.Rows[vitri].Cells[4].Value.ToString(); tralai.NoHienThoi = dgvHienThi.Rows[vitri].Cells[5].Value.ToString(); tralai.NguoiTra = dgvHienThi.Rows[vitri].Cells[6].Value.ToString(); tralai.HinhThucThanhToan = dgvHienThi.Rows[vitri].Cells[7].Value.ToString(); tralai.HanThanhToan = Convert.ToDateTime(dgvHienThi.Rows[vitri].Cells[8].Value.ToString()); tralai.MaHoaDonMuaHang = dgvHienThi.Rows[vitri].Cells[9].Value.ToString(); tralai.MaKho = dgvHienThi.Rows[vitri].Cells[10].Value.ToString(); tralai.MaTienTe = dgvHienThi.Rows[vitri].Cells[11].Value.ToString(); tralai.TienBoiThuong = dgvHienThi.Rows[vitri].Cells[12].Value.ToString(); tralai.ThanhToanNgay = dgvHienThi.Rows[vitri].Cells[13].Value.ToString(); tralai.ThueGTGT = dgvHienThi.Rows[vitri].Cells[14].Value.ToString(); tralai.GhiChu = dgvHienThi.Rows[vitri].Cells[15].Value.ToString(); tralai.Deleted = Boolean.Parse(dgvHienThi.Rows[vitri].Cells[16].Value.ToString()); } } else { } } catch (Exception ex) { string s = ex.Message.ToString(); } return tralai; }
private void XuLy_Xoa_KhachHangTraLai(string hanhdong, string makhachhangtralai) { Entities.KhachHangTraLai them = new Entities.KhachHangTraLai(); them = new Entities.KhachHangTraLai(hanhdong, makhachhangtralai); clientstrem = cl.SerializeObj(this.client, "KhachHangTraLai", them); //hứng giá trị trả về int trave; Entities.KhachHangTraLai[] tralai = new Entities.KhachHangTraLai[1]; trave = (int)cl.DeserializeHepper(clientstrem, tralai); //thong bao if (trave == 1) { MessageBox.Show("Thành công !"); } else { MessageBox.Show("Thất bại !"); } }
/// <summary> /// select khách hàng trả lại /// </summary> private void SelectKHTL() { try { if (khtl == null || khtl.Length == 0) { khtl = new Entities.KhachHangTraLai[0]; return; } Entities.KhachHangTraLai[] pt2 = new Entities.KhachHangTraLai[khtl.Length]; int sotang = 0; for (int j = 0; j < khtl.Length; j++) { string month1 = khtl[j].NgayNhap.Month.ToString(); string year1 = khtl[j].NgayNhap.Year.ToString(); if (khtl[j].Deleted == false && month == month1 && year1 == year) { pt2[sotang] = khtl[j]; sotang++; } } khtl = new Entities.KhachHangTraLai[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { khtl[j] = pt2[j]; } } else khtl = new Entities.KhachHangTraLai[0]; } catch { } }
public void LayKHTL() { try { List<Entities.KhachHangTraLai> listTemp = new List<Entities.KhachHangTraLai>(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); Entities.KhachHangTraLai KHTL1 = new Entities.KhachHangTraLai("Select"); clientstrem = cl.SerializeObj(this.client, "KHTL", KHTL1); Entities.KhachHangTraLai[] HDN = new Entities.KhachHangTraLai[1]; HDN = (Entities.KhachHangTraLai[])cl.DeserializeHepper(clientstrem, HDN); // if (HDN == null) HDN = new Entities.KhachHangTraLai[0]; // for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { listTemp.Add(HDN[i]); } } // KHTL = listTemp.ToArray(); } catch { } }
/// <summary> /// select khách hàng trả lại /// </summary> private void SelectKHTL() { try { Entities.KhachHangTraLai[] pt2 = new Entities.KhachHangTraLai[kh.Length]; int sotang = 0; for (int j = 0; j < kh.Length; j++) { string month1 = kh[j].NgayNhap.Month.ToString(); string year1 = kh[j].NgayNhap.Year.ToString(); if (kh[j].Deleted == false) { if (month == month1 && year1 == year && Convert.ToDouble(kh[j].ThanhToanNgay) != 0) { sl++; pt2[sotang] = kh[j]; sotang++; } } } kh = new Entities.KhachHangTraLai[sotang]; if (sotang != 0) { for (int j = 0; j < sotang; j++) { kh[j] = pt2[j]; } } else kh = new Entities.KhachHangTraLai[0]; } catch { } }
public Entities.KhachHangTraLai[] KhachHangTraLai() { Entities.KhachHangTraLai[] select = (Entities.KhachHangTraLai[])new BizLogic.CongNo().SelectKHTL(); if (select == null) select = new Entities.KhachHangTraLai[0]; return select; }