public CTPhieuThueDTO[] getListByMaPhieuThue(string MaPhieuThue)
{
strSQL = "Select KHACHHANG.MaKhachHang, KHACHHANG.TenKhachHang,KHACHHANG.MaLoaiKH, KHACHHANG.CMND,KHACHHANG.DiaChi, CTPHIEUTHUE.MaCTPT, PHIEUTHUE.MaPhieuThue From CTPHIEUTHUE,KHACHHANG,LOAIKHACHHANG,PHIEUTHUE Where KHACHHANG.MaLoaiKH=LOAIKHACHHANG.MaLoaiKH and KHACHHANG.MaKhachHang=CTPHIEUTHUE.MaKhachHang and CTPHIEUTHUE.MaPhieuThue=PHIEUTHUE.MaPhieuThue and CTPHIEUTHUE.MaPhieuThue='" + MaPhieuThue + "'";
DataTable dt = dp.ExecuteQuery(strSQL);
CTPhieuThueDTO[] ctptDTOArr = new CTPhieuThueDTO[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
object ctptDTO = GetDataFromDataRow(dt, i);
ctptDTOArr[i] = (CTPhieuThueDTO)ctptDTO;
}
return ctptDTOArr;
}
public int Insert(CTPhieuThueDTO ctptDTO)
{
strSQL = "Insert Into CTPHIEUTHUE Values('" + ctptDTO.MaCTPT + "','" + ctptDTO.MaPhieuThue + "','" + ctptDTO.MaKhachHang + "')";
return dp.ExecuteNonQuery(strSQL)?1:0;
}
protected override object GetDataFromDataRow(DataTable dt, int i)
{
CTPhieuThueDTO ctptDTO = new CTPhieuThueDTO();
ctptDTO.MaCTPT = dt.Rows[i]["MaCTPT"].ToString();
ctptDTO.MaKhachHang = dt.Rows[i]["MaKhachHang"].ToString();
ctptDTO.MaPhieuThue = dt.Rows[i]["MaPhieuThue"].ToString();
return (object)ctptDTO;
}
public int Update(CTPhieuThueDTO ctptDTO)
{
strSQL = "Update CTPHIEUTHUE Set MaKhachHang='" + ctptDTO.MaKhachHang + "' Where MaCTPT='" + ctptDTO.MaCTPT + "'";
return dp.ExecuteNonQuery(strSQL)?1:0;
}
public int UpdateCTPhieuThue(CTPhieuThueDTO ctptDTO)
{
return new CTPhieuThueDAO().Update(ctptDTO);
}
public int InsertCTPhieuThue(CTPhieuThueDTO ctptDTO)
{
return new CTPhieuThueDAO().Insert(ctptDTO);
}
