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