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