/// <summary> /// vuong hung ================================= /// </summary> /// <param name="HanhDong"></param> /// <param name="PhieuThuID"></param> public int sp_Xoa_KhachHangTraLai(Entities.KhachHangTraLai kkt) { int Trave = 0; try { khtl = new Constants.KhachHangTraLai(); Sql = new Constants.Sql(); string sql = Sql.sp_Xoa_KhachHangTraLai; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(khtl.HanhDong, SqlDbType.NVarChar, 20).Value = kkt.Hanhdong; cmd.Parameters.Add(khtl.MaKhachHangTraLai, SqlDbType.VarChar).Value = kkt.MaKhachHangTraLai; Trave = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(Trave); }
public Entities.KhachHangTraLai[] SelectKHTL() { Entities.KhachHangTraLai[] arrC = null; try { khtl = new Constants.KhachHangTraLai(); Sql = new Constants.Sql(); string sql = "Select * from KhachHangTraLai"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { khachhangtralai = new Entities.KhachHangTraLai(); khachhangtralai.KhachHangTraLaiID = int.Parse(dr[0].ToString()); khachhangtralai.MaKhachHangTraLai = dr[1].ToString(); khachhangtralai.NgayNhap = Convert.ToDateTime(dr[2].ToString()); khachhangtralai.MaKhachHang = dr[3].ToString(); khachhangtralai.NoHienThoi = dr[4].ToString(); khachhangtralai.NguoiTra = dr[5].ToString(); khachhangtralai.HinhThucThanhToan = dr[6].ToString(); khachhangtralai.HanThanhToan = Convert.ToDateTime(dr[7].ToString()); khachhangtralai.MaHoaDonMuaHang = dr[8].ToString(); khachhangtralai.MaKho = dr[9].ToString(); khachhangtralai.MaTienTe = dr[10].ToString(); khachhangtralai.TienBoiThuong = dr[11].ToString(); khachhangtralai.ThanhToanNgay = dr[12].ToString(); khachhangtralai.ThueGTGT = dr[13].ToString(); khachhangtralai.GhiChu = dr[14].ToString(); khachhangtralai.Deleted = Convert.ToBoolean(dr[15].ToString()); arr.Add(khachhangtralai); } int n = arr.Count; if (n == 0) { arrC = null; } arrC = new Entities.KhachHangTraLai[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.KhachHangTraLai)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); arrC = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(arrC); }
/// <summary> /// khoi tao gia tri /// </summary> public CongNo() { khtl = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; khachhangtralai = null; cn = null; }
/// <summary> /// khoi tao gia tri /// </summary> public KhachHangTraLai() { khtl = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; khachhangtralai = null; cn = null; }
public void LayKHTL() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhachHangTraLai KHTL1 = new Entities.KhachHangTraLai("Select"); clientstrem = cl.SerializeObj(this.client1, "KHTL", KHTL1); Entities.KhachHangTraLai[] HDN = new Entities.KhachHangTraLai[1]; HDN = (Entities.KhachHangTraLai[])cl.DeserializeHepper(clientstrem, HDN); 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 Entities.KhachHangTraLai CheckKhachHangTraLai(Entities.TruyenGiaTri truyen) { Entities.KhachHangTraLai 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.KhachHangTraLai(); giatri.KhachHangTraLaiID = int.Parse(dr[0].ToString()); giatri.MaKhachHangTraLai = dr[1].ToString(); giatri.NgayNhap = Convert.ToDateTime(dr[2].ToString()); giatri.MaKhachHang = dr[3].ToString(); giatri.NoHienThoi = dr[4].ToString(); giatri.NguoiTra = dr[5].ToString(); giatri.HinhThucThanhToan = dr[6].ToString(); giatri.HanThanhToan = Convert.ToDateTime(dr[7].ToString()); giatri.MaHoaDonMuaHang = dr[8].ToString(); giatri.MaKho = dr[9].ToString(); giatri.MaTienTe = dr[10].ToString(); giatri.TienBoiThuong = dr[11].ToString(); giatri.ThanhToanNgay = dr[12].ToString(); giatri.ThueGTGT = dr[13].ToString(); giatri.GhiChu = dr[14].ToString(); giatri.Deleted = Convert.ToBoolean(dr[15].ToString()); } } catch (Exception ex) { string s = ex.Message.ToString(); giatri= null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return giatri; }
public Entities.KhachHangTraLai CheckKhachHangTraLai(Entities.TruyenGiaTri truyen) { Entities.KhachHangTraLai 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.KhachHangTraLai(); giatri.KhachHangTraLaiID = int.Parse(dr[0].ToString()); giatri.MaKhachHangTraLai = dr[1].ToString(); giatri.NgayNhap = Convert.ToDateTime(dr[2].ToString()); giatri.MaKhachHang = dr[3].ToString(); giatri.NoHienThoi = dr[4].ToString(); giatri.NguoiTra = dr[5].ToString(); giatri.HinhThucThanhToan = dr[6].ToString(); giatri.HanThanhToan = Convert.ToDateTime(dr[7].ToString()); giatri.MaHoaDonMuaHang = dr[8].ToString(); giatri.MaKho = dr[9].ToString(); giatri.MaTienTe = dr[10].ToString(); giatri.TienBoiThuong = dr[11].ToString(); giatri.ThanhToanNgay = dr[12].ToString(); giatri.ThueGTGT = dr[13].ToString(); giatri.GhiChu = dr[14].ToString(); giatri.Deleted = Convert.ToBoolean(dr[15].ToString()); } } catch (Exception ex) { string s = ex.Message.ToString(); giatri = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(giatri); }
/// <summary> /// vuong hung =================xu ly don dat hang================ /// </summary> /// <returns></returns> public int sp_XuLy_KhachHangTraLai(Entities.KhachHangTraLai kkt) { int Trave = 0; try { khtl = new Constants.KhachHangTraLai(); Sql = new Constants.Sql(); string sql = Sql.sp_XuLy_KhachHangTraLai; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(khtl.HanhDong, SqlDbType.NVarChar, 20).Value = kkt.Hanhdong; cmd.Parameters.Add("KhachHangTraLaiID", SqlDbType.Int).Value = kkt.KhachHangTraLaiID; cmd.Parameters.Add(khtl.MaKhachHangTraLai, SqlDbType.NVarChar, 20).Value = kkt.MaKhachHangTraLai; cmd.Parameters.Add(khtl.NgayNhap, SqlDbType.DateTime).Value = kkt.NgayNhap; cmd.Parameters.Add(khtl.MaKhachHang, SqlDbType.NVarChar, 20).Value = kkt.MaKhachHang; cmd.Parameters.Add(khtl.NoHienThoi, SqlDbType.Float).Value = kkt.NoHienThoi; cmd.Parameters.Add(khtl.NguoiTra, SqlDbType.NVarChar, 200).Value = kkt.NguoiTra; cmd.Parameters.Add(khtl.HinhThucThanhToan, SqlDbType.NVarChar, 200).Value = kkt.HinhThucThanhToan; cmd.Parameters.Add(khtl.HanThanhToan, SqlDbType.DateTime).Value = kkt.HanThanhToan; cmd.Parameters.Add(khtl.MaHoaDonMuaHang, SqlDbType.NVarChar, 20).Value = kkt.MaHoaDonMuaHang; cmd.Parameters.Add(khtl.MaKho, SqlDbType.NVarChar, 20).Value = kkt.MaKho; cmd.Parameters.Add(khtl.MaTienTe, SqlDbType.NVarChar, 20).Value = kkt.MaTienTe; cmd.Parameters.Add(khtl.TienBoiThuong, SqlDbType.Float).Value = kkt.TienBoiThuong; cmd.Parameters.Add(khtl.ThanhToanNgay, SqlDbType.Float).Value = kkt.ThanhToanNgay; cmd.Parameters.Add(khtl.ThueGTGT, SqlDbType.Float).Value = kkt.ThueGTGT; cmd.Parameters.Add(khtl.GhiChu, SqlDbType.NVarChar, 100).Value = kkt.GhiChu; cmd.Parameters.Add(khtl.Deleted, SqlDbType.Bit).Value = kkt.Deleted; Trave = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(Trave); }
/// <summary> /// vuong hung =================lay bang DonDatHang================ /// </summary> /// <returns></returns> public Entities.KhachHangTraLai[] sp_LayBang_KhachHangTraLai(Entities.KhachHangTraLai KH) { Entities.KhachHangTraLai[] arrC = null; try { khtl = new Constants.KhachHangTraLai(); Sql = new Constants.Sql(); string sql = Sql.sp_LayBang_KhachHangTraLai; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(khtl.MaKhachHangTraLai, SqlDbType.NVarChar, 20).Value = KH.MaKhachHangTraLai; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { khachhangtralai = new Entities.KhachHangTraLai(); khachhangtralai.KhachHangTraLaiID = int.Parse(dr[0].ToString()); khachhangtralai.MaKhachHangTraLai = dr[1].ToString(); khachhangtralai.NgayNhap = Convert.ToDateTime(dr[2].ToString()); khachhangtralai.MaKhachHang = dr[3].ToString(); khachhangtralai.NoHienThoi = dr[4].ToString(); khachhangtralai.NguoiTra = dr[5].ToString(); khachhangtralai.HinhThucThanhToan = dr[6].ToString(); khachhangtralai.HanThanhToan = Convert.ToDateTime(dr[7].ToString()); khachhangtralai.MaHoaDonMuaHang = dr[8].ToString(); khachhangtralai.MaKho = dr[9].ToString(); khachhangtralai.MaTienTe = dr[10].ToString(); khachhangtralai.TienBoiThuong = dr[11].ToString(); khachhangtralai.ThanhToanNgay = dr[12].ToString(); khachhangtralai.ThueGTGT = dr[13].ToString(); khachhangtralai.GhiChu = dr[14].ToString(); khachhangtralai.Deleted = Convert.ToBoolean(dr[15].ToString()); arr.Add(khachhangtralai); } int n = arr.Count; if (n == 0) { arrC= null; } arrC = new Entities.KhachHangTraLai[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.KhachHangTraLai)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); arrC = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return arrC; }
public Entities.KhachHangTraLai[] Select() { Entities.KhachHangTraLai[] arrC = null; try { Entities.KhachHang[] kh = new BizLogic.KhachHang().Select(); khtl = new Constants.KhachHangTraLai(); Sql = new Constants.Sql(); string sql = "Select * from KhachHangTraLai where Deleted = 0"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { khachhangtralai = new Entities.KhachHangTraLai(); khachhangtralai.KhachHangTraLaiID = int.Parse(dr[0].ToString()); khachhangtralai.MaKhachHangTraLai = dr[1].ToString(); khachhangtralai.NgayNhap = Convert.ToDateTime(dr[2].ToString()); khachhangtralai.MaKhachHang = dr[3].ToString(); khachhangtralai.TenKhachHang = ""; foreach (Entities.KhachHang item in kh) { if (item.MaKH == khachhangtralai.MaKhachHang) { khachhangtralai.TenKhachHang = item.Ten; break; } } khachhangtralai.NoHienThoi = dr[4].ToString(); khachhangtralai.NguoiTra = dr[5].ToString(); khachhangtralai.HinhThucThanhToan = dr[6].ToString(); khachhangtralai.HanThanhToan = Convert.ToDateTime(dr[7].ToString()); khachhangtralai.MaHoaDonMuaHang = dr[8].ToString(); khachhangtralai.MaKho = dr[9].ToString(); khachhangtralai.MaTienTe = dr[10].ToString(); khachhangtralai.TienBoiThuong = dr[11].ToString(); khachhangtralai.ThanhToanNgay = dr[12].ToString(); khachhangtralai.ThueGTGT = dr[13].ToString(); khachhangtralai.GhiChu = dr[14].ToString(); khachhangtralai.Deleted = Convert.ToBoolean(dr[15].ToString()); arr.Add(khachhangtralai); } int n = arr.Count; if (n == 0) { arrC = null; } arrC = new Entities.KhachHangTraLai[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.KhachHangTraLai)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); arrC = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return arrC; }
public void LayKHTL() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhachHangTraLai KHTL1 = new Entities.KhachHangTraLai("Select"); clientstrem = cl.SerializeObj(this.client1, "KHTL", KHTL1); Entities.KhachHangTraLai[] HDN = new Entities.KhachHangTraLai[1]; HDN = (Entities.KhachHangTraLai[])cl.DeserializeHepper(clientstrem, HDN); 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 { } }