public void Delete(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_QuyenHoaDonID", SqlDbType.Int, pTC_QuyenHoaDonInfo.TC_QuyenHoaDonID));
RunProcedure("sp_TC_QuyenHoaDon_Delete", colParam);
}
public DataTable Get(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_QuyenHoaDonID", SqlDbType.Int, pTC_QuyenHoaDonInfo.TC_QuyenHoaDonID));
return(RunProcedureGet("sp_TC_QuyenHoaDon_Get", colParam));
}
public int Add(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
int ID = 0;
ID = oDTC_QuyenHoaDon.Add(pTC_QuyenHoaDonInfo);
mErrorMessage = oDTC_QuyenHoaDon.ErrorMessages;
mErrorNumber = oDTC_QuyenHoaDon.ErrorNumber;
return(ID);
}
public void ToInfo(ref TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo, DataRow dr)
{
pTC_QuyenHoaDonInfo.TC_QuyenHoaDonID = int.Parse(dr[oTC_QuyenHoaDonInfo.strTC_QuyenHoaDonID].ToString());
pTC_QuyenHoaDonInfo.IDDM_DiaDiem = int.Parse(dr[oTC_QuyenHoaDonInfo.strIDDM_DiaDiem].ToString());
pTC_QuyenHoaDonInfo.TenQuyenHoaDon = dr[oTC_QuyenHoaDonInfo.strTenQuyenHoaDon].ToString();
pTC_QuyenHoaDonInfo.TuSo = dr[oTC_QuyenHoaDonInfo.strTuSo].ToString();
pTC_QuyenHoaDonInfo.SoHienTai = dr[oTC_QuyenHoaDonInfo.strSoHienTai].ToString();
pTC_QuyenHoaDonInfo.HocKy = int.Parse(dr[oTC_QuyenHoaDonInfo.strHocKy].ToString());
pTC_QuyenHoaDonInfo.IDDM_NamHoc = int.Parse(dr[oTC_QuyenHoaDonInfo.strIDDM_NamHoc].ToString());
}
public void ToDataRow(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo, ref DataRow dr)
{
dr[pTC_QuyenHoaDonInfo.strTC_QuyenHoaDonID] = pTC_QuyenHoaDonInfo.TC_QuyenHoaDonID;
dr[pTC_QuyenHoaDonInfo.strIDDM_DiaDiem] = pTC_QuyenHoaDonInfo.IDDM_DiaDiem;
dr[pTC_QuyenHoaDonInfo.strTenQuyenHoaDon] = pTC_QuyenHoaDonInfo.TenQuyenHoaDon;
dr[pTC_QuyenHoaDonInfo.strTuSo] = pTC_QuyenHoaDonInfo.TuSo;
dr[pTC_QuyenHoaDonInfo.strSoHienTai] = pTC_QuyenHoaDonInfo.SoHienTai;
dr[pTC_QuyenHoaDonInfo.strHocKy] = pTC_QuyenHoaDonInfo.HocKy;
dr[pTC_QuyenHoaDonInfo.strIDDM_NamHoc] = pTC_QuyenHoaDonInfo.IDDM_NamHoc;
}
public frmTongHopThuChoSinhVien()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
oBSV_SinhVien = new cBSV_SinhVien();
pDM_LopInfo = new DM_LopInfo();
oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien();
oBTC_QuyenHoaDon = new cBTC_QuyenHoaDon();
pTC_QuyenHoaDonInfo = new TC_QuyenHoaDonInfo();
}
public void Update(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_DiaDiem", SqlDbType.Int, pTC_QuyenHoaDonInfo.IDDM_DiaDiem));
colParam.Add(CreateParam("@TenQuyenHoaDon", SqlDbType.NVarChar, pTC_QuyenHoaDonInfo.TenQuyenHoaDon));
colParam.Add(CreateParam("@TuSo", SqlDbType.NVarChar, pTC_QuyenHoaDonInfo.TuSo));
colParam.Add(CreateParam("@SoHienTai", SqlDbType.NVarChar, pTC_QuyenHoaDonInfo.SoHienTai));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_QuyenHoaDonInfo.HocKy));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_QuyenHoaDonInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@TC_QuyenHoaDonID", SqlDbType.Int, pTC_QuyenHoaDonInfo.TC_QuyenHoaDonID));
RunProcedure("sp_TC_QuyenHoaDon_Update", colParam);
}
public int Add(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_DiaDiem", SqlDbType.Int, pTC_QuyenHoaDonInfo.IDDM_DiaDiem));
colParam.Add(CreateParam("@TenQuyenHoaDon", SqlDbType.NVarChar, pTC_QuyenHoaDonInfo.TenQuyenHoaDon));
colParam.Add(CreateParam("@TuSo", SqlDbType.NVarChar, pTC_QuyenHoaDonInfo.TuSo));
colParam.Add(CreateParam("@SoHienTai", SqlDbType.NVarChar, pTC_QuyenHoaDonInfo.SoHienTai));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_QuyenHoaDonInfo.HocKy));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_QuyenHoaDonInfo.IDDM_NamHoc));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_QuyenHoaDon_Add", colParam));
}
public List <TC_QuyenHoaDonInfo> GetList(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
List <TC_QuyenHoaDonInfo> oTC_QuyenHoaDonInfoList = new List <TC_QuyenHoaDonInfo>();
DataTable dtb = Get(pTC_QuyenHoaDonInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_QuyenHoaDonInfo = new TC_QuyenHoaDonInfo();
oTC_QuyenHoaDonInfo.TC_QuyenHoaDonID = int.Parse(dtb.Rows[i][oTC_QuyenHoaDonInfo.strTC_QuyenHoaDonID].ToString());
oTC_QuyenHoaDonInfo.TenQuyenHoaDon = dtb.Rows[i][oTC_QuyenHoaDonInfo.strTenQuyenHoaDon].ToString();
oTC_QuyenHoaDonInfo.TuSo = dtb.Rows[i][oTC_QuyenHoaDonInfo.strTuSo].ToString();
oTC_QuyenHoaDonInfo.SoHienTai = dtb.Rows[i][oTC_QuyenHoaDonInfo.strSoHienTai].ToString();
oTC_QuyenHoaDonInfo.HocKy = int.Parse(dtb.Rows[i][oTC_QuyenHoaDonInfo.strHocKy].ToString());
oTC_QuyenHoaDonInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i][oTC_QuyenHoaDonInfo.strIDDM_NamHoc].ToString());
oTC_QuyenHoaDonInfoList.Add(oTC_QuyenHoaDonInfo);
}
}
return(oTC_QuyenHoaDonInfoList);
}
public void Delete(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
oDTC_QuyenHoaDon.Delete(pTC_QuyenHoaDonInfo);
mErrorMessage = oDTC_QuyenHoaDon.ErrorMessages;
mErrorNumber = oDTC_QuyenHoaDon.ErrorNumber;
}
public DataTable Get(TC_QuyenHoaDonInfo pTC_QuyenHoaDonInfo)
{
return(oDTC_QuyenHoaDon.Get(pTC_QuyenHoaDonInfo));
}
public cBTC_QuyenHoaDon()
{
oDTC_QuyenHoaDon = new cDTC_QuyenHoaDon();
oTC_QuyenHoaDonInfo = new TC_QuyenHoaDonInfo();
}
public frmDM_QuyenHoaDon()
{
InitializeComponent();
pTC_QuyenHoaDonInfo = new TC_QuyenHoaDonInfo();
oBTC_QuyenHoaDon = new cBTC_QuyenHoaDon();
}