/// <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 =======================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;
}
/// <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();
}
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 { }
}
/// <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();
}
}
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
{
}
}
private void CapNhat(DataGridView dgv)
{
try
{
Entities.KhachHangTraLai[] lay = new Entities.KhachHangTraLai[0];
dgv.DataSource = lay;
}
catch (Exception ex)
{ string s = ex.Message; }
}
/// <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 { }
}
/// <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; }
}
public Entities.KhachHangTraLai[] KhachHangTraLai()
{
Entities.KhachHangTraLai[] select = (Entities.KhachHangTraLai[])new BizLogic.CongNo().SelectKHTL();
if (select == null)
select = new Entities.KhachHangTraLai[0];
return select;
}
