public bool UpdateThanhToanNgay(Entities.HoaDonNhap hdn) { bool Trave = false; try { dh = new Constants.HoaDonNhap(); Sql = new Constants.Sql(); string sql = Sql.UpdateThanhToanNgayHoaDonNhap; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(dh.MaHoaDonNhap, SqlDbType.VarChar, 20).Value = hdn.MaHoaDonNhap; cmd.Parameters.Add("@ThanhToanSauKhiLapPhieu", SqlDbType.Float).Value = hdn.ThanhToanSauKhiLapPhieu; int i = cmd.ExecuteNonQuery(); if (i == 1) { Trave = true; } else { Trave = false; } return(Trave); } catch (Exception ex) { string s = ex.Message.ToString(); return(Trave); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } }
/// <summary> /// vuong hung ================================= /// </summary> /// <param name="HanhDong"></param> /// <param name="PhieuThuID"></param> public int sp_Xoa_HoaDonNhap(Entities.HoaDonNhap hdn) { int Trave = 0; try { dh = new Constants.HoaDonNhap(); Sql = new Constants.Sql(); string sql = Sql.sp_Xoa_HoaDonNhap; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(dh.HanhDong, SqlDbType.NVarChar, 20).Value = hdn.Hanhdong; cmd.Parameters.Add(dh.MaHoaDonNhap, SqlDbType.VarChar, 20).Value = hdn.MaHoaDonNhap; Trave = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(Trave); }
/// <summary> /// Thanh toán sau lập phiếu /// </summary> /// <returns></returns> public bool InsertUpdateSauKhiLapPhieu(Entities.HoaDonNhap hdn) { try { bool kt = false; hoadonnhap = new Constants.HoaDonNhap(); Sql = new Constants.Sql(); string sql = Sql.UpdateThanhToanNgayHoaDonNhap; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(hoadonnhap.MaHoaDonNhap, SqlDbType.VarChar, 20).Value = hdn.MaHoaDonNhap; cmd.Parameters.Add(hoadonnhap.ThanhToanNgay, SqlDbType.Float).Value = hdn.ThanhToanSauKhiLapPhieu; int i = cmd.ExecuteNonQuery(); if (i == 1) { kt = true; } else { kt = false; } cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; return(kt); } catch { return(false); } }
public frmXuLyNhapKho(string hanhdong, Entities.HoaDonNhap hoa) { InitializeComponent(); this.hanhdong = hanhdong; this.hoadon = hoa; dsQuyDoiDonViTinh = this.Bangquydoidonvitinh(); }
public Entities.HoaDonNhap[] Select() { Entities.HoaDonNhap[] arrC = null; try { dh = new Constants.HoaDonNhap(); Sql = new Constants.Sql(); string sql = "Select * from HoaDonNhap "; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { cla = new Entities.HoaDonNhap(); cla.HoaDonNhapID = System.Convert.ToInt32(dr[dh.HoaDonNhapID].ToString()); cla.MaHoaDonNhap = dr[dh.MaHoaDonNhap].ToString(); cla.NgayNhap = Convert.ToDateTime(dr[dh.NgayNhap].ToString()); cla.MaHoaDonNhap = dr[dh.MaHoaDonNhap].ToString(); cla.NgayNhap = Convert.ToDateTime(dr[dh.NgayNhap].ToString()); cla.MaNhaCungCap = "" + dr[dh.MaNhaCungCap].ToString(); cla.NoHienThoi = dr[dh.NoHienThoi].ToString(); cla.NguoiGiaoHang = dr[dh.NguoiGiaoHang].ToString(); cla.HinhThucThanhToan = dr[dh.HinhThucThanhToan].ToString(); cla.MaKho = dr[dh.MaKho].ToString(); cla.HanThanhToan = Convert.ToDateTime(dr[dh.HanThanhToan].ToString()); cla.MaDonDatHang = dr[dh.MaDonDatHang].ToString(); cla.MaTienTe = dr[dh.MaTienTe].ToString(); cla.ChietKhau = Double.Parse(0 + dr[dh.ChietKhau].ToString()).ToString(); cla.ThanhToanNgay = Double.Parse(0 + dr[dh.ThanhToanNgay].ToString()).ToString(); cla.ThueGTGT = Double.Parse(0 + dr[dh.ThueGTGT].ToString()).ToString(); cla.TongTien = Double.Parse(0 + dr[dh.TongTien].ToString()).ToString(); cla.GhiChu = dr[dh.GhiChu].ToString(); cla.Deleted = Convert.ToBoolean(dr[dh.Deleted].ToString()); cla.ThanhToanSauKhiLapPhieu = dr["ThanhToanSauKhiLapPhieu"].ToString(); arr.Add(cla); } int n = arr.Count; if (n == 0) { arrC = null; } arrC = new Entities.HoaDonNhap[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.HoaDonNhap)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); arrC = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(arrC); }
public QuyDoi() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; cla = null; cn = null; }
public HangHoaGoiHang() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; cla = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public HoaDonNhap() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; cla = null; cn = null; }
public frmXuLyNhapKho(string hanhdong, HoaDonNhap hoa) { InitializeComponent(); this.hanhdong = hanhdong; hoadon = hoa; //_dsQuyDoiDonViTinh = Bangquydoidonvitinh(); try { _dsQuyDoiDonViTinh = "Select".GetDataFromServer<QuyDoiDonViTinh[]>(new CheckRefer("QD")).ToList(); } catch { _dsQuyDoiDonViTinh = new List<QuyDoiDonViTinh>(); } }
public void LayHDNhap() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", ""); clientstrem = cl.SerializeObj(this.client1, "Select", ctxh); Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0]; HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN); if (HDN == null) { HoaDonNhap = new Entities.HoaDonNhap[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.HoaDonNhap[] HoaDonNhap1 = new Entities.HoaDonNhap[count]; count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { HoaDonNhap1[count] = HDN[i]; count++; } } if (HoaDonNhap1.Length == 0) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } else { HoaDonNhap = HoaDonNhap1; } } catch { } }
/// <summary> /// lay ban ghi cuoi cung /// </summary> public Entities.HoaDonNhap LayHoaDonNhap(Entities.TruyenGiaTri truyen) { Entities.HoaDonNhap giatri = null; try { string sql = "exec sp_LayBang_TheoTenBang @table,@values"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("table", SqlDbType.NVarChar, 100).Value = truyen.Giatritruyen; cmd.Parameters.Add("values", SqlDbType.NVarChar, 50).Value = truyen.Giatrithuhai; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { giatri = new Entities.HoaDonNhap(); giatri.Hanhdong = ""; giatri.HoaDonNhapID = int.Parse(dr[0].ToString()); giatri.MaHoaDonNhap = dr[1].ToString(); giatri.NgayNhap = Convert.ToDateTime(dr[2].ToString()); giatri.MaNhaCungCap = dr[3].ToString(); giatri.NoHienThoi = dr[4].ToString(); giatri.NguoiGiaoHang = dr[5].ToString(); giatri.HinhThucThanhToan = dr[6].ToString(); giatri.MaKho = dr[7].ToString(); giatri.HanThanhToan = Convert.ToDateTime(dr[8].ToString()); giatri.MaDonDatHang = dr[9].ToString(); giatri.MaTienTe = dr[10].ToString(); giatri.ChietKhau = dr[11].ToString(); giatri.ThanhToanNgay = dr[12].ToString(); giatri.ThueGTGT = dr[13].ToString(); giatri.TongTien = dr[14].ToString(); giatri.GhiChu = dr[15].ToString(); giatri.Deleted = Convert.ToBoolean(dr[16].ToString()); cla.ThanhToanSauKhiLapPhieu = dr[17].ToString(); } } catch (Exception ex) { string s = ex.Message.ToString(); return(null); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(giatri); }
/// <summary> /// lay ban ghi cuoi cung /// </summary> public Entities.HoaDonNhap LayHoaDonNhap(Entities.TruyenGiaTri truyen) { Entities.HoaDonNhap giatri = null; try { string sql = "exec sp_LayBang_TheoTenBang @table,@values"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("table", SqlDbType.NVarChar, 100).Value = truyen.Giatritruyen; cmd.Parameters.Add("values", SqlDbType.NVarChar, 50).Value = truyen.Giatrithuhai; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { giatri = new Entities.HoaDonNhap(); giatri.Hanhdong = ""; giatri.HoaDonNhapID = int.Parse(dr[0].ToString()); giatri.MaHoaDonNhap = dr[1].ToString(); giatri.NgayNhap = Convert.ToDateTime(dr[2].ToString()); giatri.MaNhaCungCap = dr[3].ToString(); giatri.NoHienThoi = dr[4].ToString(); giatri.NguoiGiaoHang = dr[5].ToString(); giatri.HinhThucThanhToan = dr[6].ToString(); giatri.MaKho = dr[7].ToString(); giatri.HanThanhToan = Convert.ToDateTime(dr[8].ToString()); giatri.MaDonDatHang = dr[9].ToString(); giatri.MaTienTe = dr[10].ToString(); giatri.ChietKhau = dr[11].ToString(); giatri.ThanhToanNgay = dr[12].ToString(); giatri.ThueGTGT = dr[13].ToString(); giatri.TongTien = dr[14].ToString(); giatri.GhiChu = dr[15].ToString(); giatri.Deleted = Convert.ToBoolean(dr[16].ToString()); cla.ThanhToanSauKhiLapPhieu = dr[17].ToString(); } } catch (Exception ex) { string s = ex.Message.ToString(); return null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return giatri; }
/// <summary> /// vuong hung ===================== them sua HoaDonNhap===================== /// </summary> public int sp_XuLy_HoaDonNhap(Entities.HoaDonNhap hdn) { int Trave = 0; try { dh = new Constants.HoaDonNhap(); Sql = new Constants.Sql(); string sql = Sql.sp_XuLy_HoaDonNhap; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(dh.HanhDong, SqlDbType.NVarChar, 20).Value = hdn.Hanhdong; cmd.Parameters.Add(dh.HoaDonNhapID, SqlDbType.Int).Value = hdn.HoaDonNhapID; cmd.Parameters.Add(dh.MaHoaDonNhap, SqlDbType.VarChar, 20).Value = hdn.MaHoaDonNhap; cmd.Parameters.Add(dh.NgayNhap, SqlDbType.DateTime).Value = hdn.NgayNhap; cmd.Parameters.Add(dh.MaNhaCungCap, SqlDbType.NVarChar, 20).Value = hdn.MaNhaCungCap; cmd.Parameters.Add(dh.NoHienThoi, SqlDbType.Float).Value = hdn.NoHienThoi; cmd.Parameters.Add(dh.NguoiGiaoHang, SqlDbType.NVarChar, 20).Value = hdn.NguoiGiaoHang; cmd.Parameters.Add(dh.HinhThucThanhToan, SqlDbType.NVarChar).Value = hdn.HinhThucThanhToan; cmd.Parameters.Add(dh.MaKho, SqlDbType.VarChar, 20).Value = hdn.MaKho; cmd.Parameters.Add(dh.HanThanhToan, SqlDbType.DateTime).Value = hdn.HanThanhToan; cmd.Parameters.Add(dh.MaDonDatHang, SqlDbType.VarChar, 20).Value = hdn.MaDonDatHang; cmd.Parameters.Add(dh.MaTienTe, SqlDbType.VarChar, 20).Value = hdn.MaTienTe; cmd.Parameters.Add(dh.ChietKhau, SqlDbType.Float).Value = hdn.ChietKhau; cmd.Parameters.Add(dh.ThanhToanNgay, SqlDbType.Float).Value = hdn.ThanhToanNgay; cmd.Parameters.Add(dh.ThueGTGT, SqlDbType.Float).Value = hdn.ThueGTGT; cmd.Parameters.Add(dh.TongTien, SqlDbType.Float).Value = hdn.TongTien; cmd.Parameters.Add(dh.GhiChu, SqlDbType.NVarChar).Value = hdn.GhiChu; cmd.Parameters.Add(dh.Deleted, SqlDbType.Bit).Value = hdn.Deleted; cmd.Parameters.Add("ThanhToanSauKhiLapPhieu", SqlDbType.Float).Value = hdn.ThanhToanSauKhiLapPhieu; Trave = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); Trave = 0; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(Trave); }
public void LayHDNhap() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.CheckRefer ctxh = new Entities.CheckRefer("HDN", ""); clientstrem = cl.SerializeObj(this.client1, "Select", ctxh); Entities.HoaDonNhap[] HDN = new Entities.HoaDonNhap[0]; HDN = (Entities.HoaDonNhap[])cl.DeserializeHepper1(clientstrem, HDN); if (HDN == null) { HoaDonNhap = new Entities.HoaDonNhap[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.HoaDonNhap[] HoaDonNhap1 = new Entities.HoaDonNhap[count]; count = 0; for (int i = 0; i < HDN.Length; i++) { DateTime ngaylap = HDN[i].NgayNhap; if (ngaylap >= BatDau && ngaylap <= KetThuc) { HoaDonNhap1[count] = HDN[i]; count++; } } if (HoaDonNhap1.Length == 0) { HoaDonNhap = new Entities.HoaDonNhap[0]; return; } else HoaDonNhap = HoaDonNhap1; } catch { } }
private void XuLy_HoaDonNhap(string hanhdong) { try { if (!KiemTraNgayHetHan()) return; thanhtoan = new Entities.HoaDonNhap[1]; Entities.HoaDonNhap don = new Entities.HoaDonNhap(); Common.Utilities ck = new Common.Utilities(); string thoigian_1 = makNgaydonhang.Text; string thoigian_2 = makHanthanhtoan.Text; string thoigian_sosanh = Date.ToString("dd/MM/yyyy"); if (string.IsNullOrEmpty(thoigian_1) || string.IsNullOrEmpty(thoigian_2)) { MessageBox.Show("Kiểm tra ngày"); return; } if (!(ck.SoSanhNgay('/', ">=", thoigian_1, thoigian_sosanh) && ck.SoSanhNgay('/', ">=", thoigian_2, thoigian_sosanh))) { MessageBox.Show("Kiểm tra ngày"); return; } else { bool _kq0 = true; bool _kq1 = true; don.NgayNhap = Utils.StringToDateTime(thoigian_1, out _kq0); don.HanThanhToan = Utils.StringToDateTime(thoigian_2, out _kq1); //don.NgayNhap = DateTime.Parse(new Common.Utilities().KiemTraDinhDangNgayThangNam("ThangNgayNam", thoigian_1, '/')); //don.HanThanhToan = DateTime.Parse(new Common.Utilities().KiemTraDinhDangNgayThangNam("ThangNgayNam", thoigian_2, '/')); don.Hanhdong = hanhdong; don.HoaDonNhapID = ID; don.MaHoaDonNhap = txtSodonhang.Text; don.MaNhaCungCap = txtManhacungcap.Text; don.NoHienThoi = txtNohienthoi.Text; don.NguoiGiaoHang = "" + txtnguoigiaohang.Text; don.HinhThucThanhToan = cbxHinhthucthanhtoan.SelectedItem.ToString(); string kh = ""; try { kh = cbxKhoHang.SelectedValue.ToString(); } catch (Exception ex) { MessageBox.Show("Kiểm tra mã kho"); kh = ""; return; } don.MaKho = kh; string MaDonDatHang = txtMadondathang.Text; if (MaDonDatHang == "<F4 - Tra cứu>" || MaDonDatHang.Length <= 0) { MaDonDatHang = "NULL"; } don.MaDonDatHang = MaDonDatHang; string tt = ""; try { tt = cbxTienTe_TyGia.SelectedValue.ToString(); } catch (Exception ex) { MessageBox.Show("Kiểm tra mã tiền tệ"); tt = ""; return; } don.MaTienTe = tt; don.ChietKhau = Double.Parse(0 + txtTienCKTM0.Text).ToString(); don.ThanhToanNgay = Double.Parse(0 + txtThanhtoanngay.Text.Replace(",", "")).ToString(); don.ThueGTGT = Double.Parse(0 + txtGiatrigiatang.Text).ToString(); don.TongTien = Double.Parse(0 + txtTongThanhToan.Text).ToString(); don.GhiChu = "" + txtDiengiai.Text; don.Deleted = false; don.Manhanvien = Common.Utilities.User.NhanVienID; don.Tendangnhap = Common.Utilities.User.TenDangNhap; don.ThanhToanSauKhiLapPhieu = "0"; if (dgvInsertOrder.RowCount > 0) { if (CheckData(don) == true) { cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", don); Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[1]; int trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, tralai)); if (trave == 1) { thanhtoan[0] = don; try { LuuChiTietDonHang(); } catch { } CapNhatTrangThaiDonDatHang("Update", MaDonDatHang, "Đã thành công"); frmQuanLyNhapKho.BaoDong = ""; DialogResult giatri = MessageBox.Show("Bạn có muốn thêm phiếu nhập tiếp không?", "Thông Báo", System.Windows.Forms.MessageBoxButtons.YesNo); { if (giatri == DialogResult.No) frmQuanLyNhapKho.BaoDong = "A"; } this.Close(); } else { MessageBox.Show("Thất bại"); } } } else { MessageBox.Show("Không có hàng hóa trong đơn đặt hàng"); } } } catch (Exception ex) { string s = ex.Message.ToString(); MessageBox.Show("Thông tin nhập không đúng"); } }
private void XuLy_Xoa_HoaDonNhap(string hanhdong, string mahoadonnhap) { try { Entities.HoaDonNhap them = new Entities.HoaDonNhap(); them = new Entities.HoaDonNhap(hanhdong, mahoadonnhap); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", them); //hứng giá trị trả về int trave; Entities.HoaDonNhap[] tralai = new Entities.HoaDonNhap[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 !"); } } catch (Exception ex) { string s = ex.Message; } }
private Entities.HoaDonNhap ConfilickData(string table, string values) { Entities.HoaDonNhap ddh = new Entities.HoaDonNhap(); 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, "CheckHoaDonNhap", gitri); ddh = (Entities.HoaDonNhap)cl.DeserializeHepper(clientstrem, ddh); client.Close(); clientstrem.Close(); } catch (Exception ex) { string s = ex.Message.ToString(); ddh = null; } return ddh; }
/// <summary> /// vuong hung ========================hien thi hoa don nhap=================== /// </summary> /// <returns></returns> public Entities.HoaDonNhap[] sp_LayBang_HoaDonNhap(Entities.HoaDonNhap hoadon) { Entities.HoaDonNhap[] arrC = null; try { dh = new Constants.HoaDonNhap(); Sql = new Constants.Sql(); string sql = Sql.sp_LayBang_HoaDonNhap; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(dh.MaHoaDonNhap, SqlDbType.VarChar, 20).Value = hoadon.MaHoaDonNhap; cmd.Parameters.Add(dh.MaKho, SqlDbType.VarChar, 20).Value = hoadon.MaKho; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { cla = new Entities.HoaDonNhap(); cla.HoaDonNhapID = System.Convert.ToInt32(dr[dh.HoaDonNhapID].ToString()); cla.MaHoaDonNhap = dr[dh.MaHoaDonNhap].ToString(); cla.NgayNhap = Convert.ToDateTime(dr[dh.NgayNhap].ToString()); cla.MaHoaDonNhap = dr[dh.MaHoaDonNhap].ToString(); cla.NgayNhap = Convert.ToDateTime(dr[dh.NgayNhap].ToString()); cla.MaNhaCungCap = dr[dh.MaNhaCungCap].ToString(); cla.NoHienThoi = dr[dh.NoHienThoi].ToString(); cla.NguoiGiaoHang = dr[dh.NguoiGiaoHang].ToString(); cla.HinhThucThanhToan = dr[dh.HinhThucThanhToan].ToString(); cla.MaKho = dr[dh.MaKho].ToString(); cla.HanThanhToan = Convert.ToDateTime(dr[dh.HanThanhToan].ToString()); cla.MaDonDatHang = dr[dh.MaDonDatHang].ToString(); cla.MaTienTe = dr[dh.MaTienTe].ToString(); cla.ChietKhau = Double.Parse(0 + dr[dh.ChietKhau].ToString()).ToString(); cla.ThanhToanNgay = Double.Parse(0 + dr[dh.ThanhToanNgay].ToString()).ToString(); cla.ThueGTGT = Double.Parse(0 + dr[dh.ThueGTGT].ToString()).ToString(); cla.TongTien = Double.Parse(0 + dr[dh.TongTien].ToString()).ToString(); cla.GhiChu = dr[dh.GhiChu].ToString(); cla.Deleted = Convert.ToBoolean(dr[dh.Deleted].ToString()); cla.ThanhToanSauKhiLapPhieu = dr["ThanhToanSauKhiLapPhieu"].ToString(); arr.Add(cla); } int n = arr.Count; if (n == 0) { arrC = null; } arrC = new Entities.HoaDonNhap[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.HoaDonNhap)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); arrC = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return arrC; }
private void DeleteData(string ID) { try { Entities.HoaDonNhap dh = new Entities.HoaDonNhap(); cl = new Server_Client.Client(); this.client = cl.Connect(Luu.IP, Luu.Ports); dh = new Entities.HoaDonNhap("Delete", ID); clientstrem = cl.SerializeObj(this.client, "HoaDonNhap", dh); int trave = 0; trave = System.Convert.ToInt32(cl.DeserializeHepper(clientstrem, trave)); client.Close(); clientstrem.Close(); } catch (Exception ex) { string s = ex.Message; } }