public DataTable Get(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
ArrayList colParam = new ArrayList();
return(RunProcedureGet("sp_TC_DanhSachHocBong_Get", colParam));
}
public void Delete(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachHocBongID", SqlDbType.Int, pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID));
RunProcedure("sp_TC_DanhSachHocBong_Delete", colParam);
}
public int Add(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
int ID = 0;
ID = oDTC_DanhSachHocBong.Add(pTC_DanhSachHocBongInfo);
mErrorMessage = oDTC_DanhSachHocBong.ErrorMessages;
mErrorNumber = oDTC_DanhSachHocBong.ErrorNumber;
return(ID);
}
public frmDanhSachHocBong_ChamCong()
{
InitializeComponent();
pTC_DanhSachHocBongInfo = new TC_DanhSachHocBongInfo();
oBTC_DanhSachHocBong = new cBTC_DanhSachHocBong();
oBTC_DanhSachHocBong_ChiTiet = new cBTC_DanhSachHocBong_ChiTiet();
pDM_LopInfo = new DM_LopInfo();
}
public void ToInfo(ref TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo, DataRow dr)
{
pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID = int.Parse(dr[pTC_DanhSachHocBongInfo.strTC_DanhSachHocBongID].ToString());
pTC_DanhSachHocBongInfo.IDSV_SinhVien = int.Parse(dr[pTC_DanhSachHocBongInfo.strIDSV_SinhVien].ToString());
pTC_DanhSachHocBongInfo.IDDM_NamHoc = int.Parse(dr[pTC_DanhSachHocBongInfo.strIDDM_NamHoc].ToString());
pTC_DanhSachHocBongInfo.HocKy = int.Parse(dr[pTC_DanhSachHocBongInfo.strHocKy].ToString());
pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong = int.Parse(dr[pTC_DanhSachHocBongInfo.strIDTC_PhanBoQuyHocBong].ToString());
pTC_DanhSachHocBongInfo.SoTienThang = double.Parse(dr[pTC_DanhSachHocBongInfo.strSoTienThang].ToString());
pTC_DanhSachHocBongInfo.SoTienKy = double.Parse(dr[pTC_DanhSachHocBongInfo.strSoTienKy].ToString());
}
public void ToDataRow(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo, ref DataRow dr)
{
dr[pTC_DanhSachHocBongInfo.strTC_DanhSachHocBongID] = pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID;
dr[pTC_DanhSachHocBongInfo.strIDSV_SinhVien] = pTC_DanhSachHocBongInfo.IDSV_SinhVien;
dr[pTC_DanhSachHocBongInfo.strIDDM_NamHoc] = pTC_DanhSachHocBongInfo.IDDM_NamHoc;
dr[pTC_DanhSachHocBongInfo.strHocKy] = pTC_DanhSachHocBongInfo.HocKy;
dr[pTC_DanhSachHocBongInfo.strIDTC_PhanBoQuyHocBong] = pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong;
dr[pTC_DanhSachHocBongInfo.strSoTienThang] = pTC_DanhSachHocBongInfo.SoTienThang;
dr[pTC_DanhSachHocBongInfo.strSoTienKy] = pTC_DanhSachHocBongInfo.SoTienKy;
}
public frmDanhSachHocBong()
{
InitializeComponent();
pTC_DanhSachHocBongInfo = new TC_DanhSachHocBongInfo();
oBTC_DanhSachHocBong = new cBTC_DanhSachHocBong();
oBTC_DanhSachHocBong_ChiTiet = new cBTC_DanhSachHocBong_ChiTiet();
pTC_DanhSachHocBong_ChiTietInfo = new TC_DanhSachHocBong_ChiTietInfo();
pDM_LopInfo = new DM_LopInfo();
//pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo();
//oBTC_BienLaiThuTien_ChiTiet = new cBTC_BienLaiThuTien_ChiTiet();
//pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo();
//oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien();
}
public void Update(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachHocBongID", SqlDbType.Int, pTC_DanhSachHocBongInfo.TC_DanhSachHocBongID));
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachHocBongInfo.HocKy));
colParam.Add(CreateParam("@IDTC_PhanBoQuyHocBong", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong));
colParam.Add(CreateParam("@SoTienThang", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienThang));
colParam.Add(CreateParam("@SoTienKy", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienKy));
RunProcedure("sp_TC_DanhSachHocBong_Update", colParam);
}
public int Add(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachHocBongInfo.HocKy));
colParam.Add(CreateParam("@IDTC_PhanBoQuyHocBong", SqlDbType.Int, pTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong));
colParam.Add(CreateParam("@SoTienThang", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienThang));
colParam.Add(CreateParam("@SoTienKy", SqlDbType.Money, pTC_DanhSachHocBongInfo.SoTienKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_DanhSachHocBong_Add", colParam));
}
public List <TC_DanhSachHocBongInfo> GetList(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
List <TC_DanhSachHocBongInfo> oTC_DanhSachHocBongInfoList = new List <TC_DanhSachHocBongInfo>();
DataTable dtb = Get(pTC_DanhSachHocBongInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_DanhSachHocBongInfo = new TC_DanhSachHocBongInfo();
oTC_DanhSachHocBongInfo.TC_DanhSachHocBongID = int.Parse(dtb.Rows[i]["TC_DanhSachHocBongID"].ToString());
oTC_DanhSachHocBongInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oTC_DanhSachHocBongInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oTC_DanhSachHocBongInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oTC_DanhSachHocBongInfo.IDTC_PhanBoQuyHocBong = int.Parse(dtb.Rows[i]["IDTC_PhanBoQuyHocBong"].ToString());
oTC_DanhSachHocBongInfo.SoTienThang = double.Parse(dtb.Rows[i]["SoTienThang"].ToString());
oTC_DanhSachHocBongInfo.SoTienKy = double.Parse(dtb.Rows[i]["SoTienKy"].ToString());
oTC_DanhSachHocBongInfoList.Add(oTC_DanhSachHocBongInfo);
}
}
return(oTC_DanhSachHocBongInfoList);
}
public void Delete(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
oDTC_DanhSachHocBong.Delete(pTC_DanhSachHocBongInfo);
mErrorMessage = oDTC_DanhSachHocBong.ErrorMessages;
mErrorNumber = oDTC_DanhSachHocBong.ErrorNumber;
}
public DataTable Get(TC_DanhSachHocBongInfo pTC_DanhSachHocBongInfo)
{
return(oDTC_DanhSachHocBong.Get(pTC_DanhSachHocBongInfo));
}
