/// <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; }
/// <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); }