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