/// <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>
/// khoi tao gia tri
/// </summary>
public KhachHangTraLai()
{
khtl = null;
Sql = null;
conn = null;
cmd = null;
arr = null;
dr = null;
khachhangtralai = null;
cn = null;
}
/// <summary>
/// khoi tao gia tri
/// </summary>
public CongNo()
{
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 { }
}
