public PTTienPhong Layphieuthutheoma(string MaPT)
{
DataTable dt = PTDAL.LayPTTheoMa(MaPT);
PTTienPhong pt = new PTTienPhong();
pt.Manphieuthu = dt.Rows[0][0].ToString();
pt.Maphong = dt.Rows[0][1].ToString();
pt.Tienphong = dt.Rows[0][2].ToString();
pt.Thangthu = dt.Rows[0][3].ToString();
pt.Masinhvien = dt.Rows[0][4].ToString();
pt.Manhanvien = dt.Rows[0][5].ToString();
pt.Ghichu = dt.Rows[0][6].ToString();
return(pt);
}
public void XoaPhieuThu(string MaPT)
{
PT = new PTTienPhong(MaPT, "", "", "", "", "", "");
PTDAL.Xoaphieuthu(PT);
}
public void SuaPhieuThu(string maphieuthu, string maphong, string tienphong, string thangthu, string masv, string manv, string ghichu)
{
PT = new PTTienPhong(maphieuthu, maphong, tienphong, thangthu, masv, manv, Chuanhoaxau(ghichu));
PTDAL.Suaphieuthu(PT);
}
public void Xoaphieuthu(PTTienPhong pt)
{
strSQL = "Delete PTTienPhong where MaPT='" + pt.Manphieuthu + "'";
helper.ThucThiKN(strSQL);
}
public void Suaphieuthu(PTTienPhong pt)
{
strSQL = "Update PTTienPhong set MaPhong='" + pt.Maphong + "',TienPhong='" + pt.Tienphong + "',ThangThu='" + pt.Thangthu + "',MaSV='" + pt.Masinhvien + "',MaNV='" + pt.Manhanvien + "',GhiChu=N'" + pt.Ghichu + "' where MaPT='" + pt.Manphieuthu + "'";
helper.ThucThiKN(strSQL);
}
public void Themphieuthu(PTTienPhong pt)
{
strSQL = "Insert into PTTienPhong values('" + pt.Manphieuthu + "','" + pt.Maphong + "','" + pt.Tienphong + "','" + pt.Thangthu + "','" + pt.Masinhvien + "','" + pt.Manhanvien + "',N'" + pt.Ghichu + "' )";
helper.ThucThiKN(strSQL);
}
