public List <TC_PhanBoQuyHocBongInfo> GetList(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
List <TC_PhanBoQuyHocBongInfo> oTC_PhanBoQuyHocBongInfoList = new List <TC_PhanBoQuyHocBongInfo>();
DataTable dtb = Get(pTC_PhanBoQuyHocBongInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_PhanBoQuyHocBongInfo = new TC_PhanBoQuyHocBongInfo();
oTC_PhanBoQuyHocBongInfo.TC_PhanBoQuyHocBongID = int.Parse(dtb.Rows[i]["TC_PhanBoQuyHocBongID"].ToString());
oTC_PhanBoQuyHocBongInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oTC_PhanBoQuyHocBongInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oTC_PhanBoQuyHocBongInfo.IDTC_QuyHocBong = int.Parse(dtb.Rows[i]["IDTC_QuyHocBong"].ToString());
oTC_PhanBoQuyHocBongInfo.IDDM_Khoa = int.Parse(dtb.Rows[i]["IDDM_Khoa"].ToString());
oTC_PhanBoQuyHocBongInfo.IDDM_KhoaHoc = int.Parse(dtb.Rows[i]["IDDM_KhoaHoc"].ToString());
oTC_PhanBoQuyHocBongInfo.IDDM_Nganh = int.Parse(dtb.Rows[i]["IDDM_Nganh"].ToString());
oTC_PhanBoQuyHocBongInfo.IDDM_Lop = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString());
oTC_PhanBoQuyHocBongInfo.SoSinhVien = int.Parse(dtb.Rows[i]["SoSinhVien"].ToString());
oTC_PhanBoQuyHocBongInfo.SoTien = float.Parse(dtb.Rows[i]["SoTien"].ToString());
oTC_PhanBoQuyHocBongInfo.PhanDacBiet = bool.Parse(dtb.Rows[i]["PhanDacBiet"].ToString());
oTC_PhanBoQuyHocBongInfoList.Add(oTC_PhanBoQuyHocBongInfo);
}
}
return(oTC_PhanBoQuyHocBongInfoList);
}
public frmXetHocBong()
{
InitializeComponent();
pTC_QuyHocBongInfo = new TC_QuyHocBongInfo();
oBTC_QuyHocBong = new cBTC_QuyHocBong();
pTC_PhanBoQuyHocBongInfo = new TC_PhanBoQuyHocBongInfo();
oBTC_PhanBoQuyHocBong = new cBTC_PhanBoQuyHocBong();
}
public void Delete(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_PhanBoQuyHocBongID", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.TC_PhanBoQuyHocBongID));
RunProcedure("sp_TC_PhanBoQuyHocBong_Delete", colParam);
}
public DataTable Get(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_PhanBoQuyHocBongID", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.TC_PhanBoQuyHocBongID));
return(RunProcedureGet("sp_TC_PhanBoQuyHocBong_Get", colParam));
}
public int Add(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
int ID = 0;
ID = oDTC_PhanBoQuyHocBong.Add(pTC_PhanBoQuyHocBongInfo);
mErrorMessage = oDTC_PhanBoQuyHocBong.ErrorMessages;
mErrorNumber = oDTC_PhanBoQuyHocBong.ErrorNumber;
return(ID);
}
public frmQuyHocBong()
{
InitializeComponent();
pDM_LoaiQuyInfo = new DM_LoaiQuyInfo();
oBDM_LoaiQuy = new cBDM_LoaiQuy();
pTC_QuyHocBongInfo = new TC_QuyHocBongInfo();
oBTC_QuyHocBong = new cBTC_QuyHocBong();
pTC_PhanBoQuyHocBongInfo = new TC_PhanBoQuyHocBongInfo();
oBTC_PhanBoQuyHocBong = new cBTC_PhanBoQuyHocBong();
}
public void ToDataRow(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo, ref DataRow dr)
{
dr[pTC_PhanBoQuyHocBongInfo.strTC_PhanBoQuyHocBongID] = pTC_PhanBoQuyHocBongInfo.TC_PhanBoQuyHocBongID;
dr[pTC_PhanBoQuyHocBongInfo.strIDDM_NamHoc] = pTC_PhanBoQuyHocBongInfo.IDDM_NamHoc;
dr[pTC_PhanBoQuyHocBongInfo.strHocKy] = pTC_PhanBoQuyHocBongInfo.HocKy;
dr[pTC_PhanBoQuyHocBongInfo.strIDTC_QuyHocBong] = pTC_PhanBoQuyHocBongInfo.IDTC_QuyHocBong;
dr[pTC_PhanBoQuyHocBongInfo.strIDDM_Khoa] = pTC_PhanBoQuyHocBongInfo.IDDM_Khoa;
dr[pTC_PhanBoQuyHocBongInfo.strIDDM_KhoaHoc] = pTC_PhanBoQuyHocBongInfo.IDDM_KhoaHoc;
dr[pTC_PhanBoQuyHocBongInfo.strIDDM_Nganh] = pTC_PhanBoQuyHocBongInfo.IDDM_Nganh;
dr[pTC_PhanBoQuyHocBongInfo.strIDDM_Lop] = pTC_PhanBoQuyHocBongInfo.IDDM_Lop;
dr[pTC_PhanBoQuyHocBongInfo.strSoSinhVien] = pTC_PhanBoQuyHocBongInfo.SoSinhVien;
dr[pTC_PhanBoQuyHocBongInfo.strSoTien] = pTC_PhanBoQuyHocBongInfo.SoTien;
dr[pTC_PhanBoQuyHocBongInfo.strPhanDacBiet] = pTC_PhanBoQuyHocBongInfo.PhanDacBiet;
}
public void ToInfo(ref TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo, DataRow dr)
{
pTC_PhanBoQuyHocBongInfo.TC_PhanBoQuyHocBongID = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strTC_PhanBoQuyHocBongID].ToString());
pTC_PhanBoQuyHocBongInfo.IDDM_NamHoc = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strIDDM_NamHoc].ToString());
pTC_PhanBoQuyHocBongInfo.HocKy = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strHocKy].ToString());
pTC_PhanBoQuyHocBongInfo.IDTC_QuyHocBong = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strIDTC_QuyHocBong].ToString());
pTC_PhanBoQuyHocBongInfo.IDDM_Khoa = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strIDDM_Khoa].ToString());
pTC_PhanBoQuyHocBongInfo.IDDM_KhoaHoc = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strIDDM_KhoaHoc].ToString());
pTC_PhanBoQuyHocBongInfo.IDDM_Nganh = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strIDDM_Nganh].ToString());
pTC_PhanBoQuyHocBongInfo.IDDM_Lop = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strIDDM_Lop].ToString());
pTC_PhanBoQuyHocBongInfo.SoSinhVien = int.Parse(dr[pTC_PhanBoQuyHocBongInfo.strSoSinhVien].ToString());
pTC_PhanBoQuyHocBongInfo.SoTien = float.Parse(dr[pTC_PhanBoQuyHocBongInfo.strSoTien].ToString());
pTC_PhanBoQuyHocBongInfo.PhanDacBiet = bool.Parse(dr[pTC_PhanBoQuyHocBongInfo.strPhanDacBiet].ToString());
}
public frmPhanBoDacBiet(DataRow mdr, ref DataTable mdtDoiTuong, double mSoTienDaPhanBo)
{
InitializeComponent();
dr = mdr;
dtDoiTuong = mdtDoiTuong;
if (dr != null)
{
txtTenLoaiQuy.Text = dr["TenLoaiQuy"].ToString();
txtSoTien.Text = double.Parse(dr["SoTien"].ToString()).ToString("N0");
}
txtSoTienDaPhanBo.Text = mSoTienDaPhanBo.ToString("N0");
cmbDoiTuong.Properties.DataSource = dtDoiTuong;
oBTC_PhanBoQuyHocBong = new cBTC_PhanBoQuyHocBong();
pTC_PhanBoQuyHocBongInfo = new TC_PhanBoQuyHocBongInfo();
}
public void Update(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.HocKy));
colParam.Add(CreateParam("@IDTC_QuyHocBong", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDTC_QuyHocBong));
colParam.Add(CreateParam("@IDDM_Khoa", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_Khoa));
colParam.Add(CreateParam("@IDDM_KhoaHoc", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_KhoaHoc));
colParam.Add(CreateParam("@IDDM_Nganh", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_Nganh));
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_Lop));
colParam.Add(CreateParam("@SoSinhVien", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.SoSinhVien));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_PhanBoQuyHocBongInfo.SoTien));
colParam.Add(CreateParam("@PhanDacBiet", SqlDbType.Bit, pTC_PhanBoQuyHocBongInfo.PhanDacBiet));
colParam.Add(CreateParam("@TC_PhanBoQuyHocBongID", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.TC_PhanBoQuyHocBongID));
RunProcedure("sp_TC_PhanBoQuyHocBong_Update", colParam);
}
public int Add(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.HocKy));
colParam.Add(CreateParam("@IDTC_QuyHocBong", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDTC_QuyHocBong));
colParam.Add(CreateParam("@IDDM_Khoa", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_Khoa));
colParam.Add(CreateParam("@IDDM_KhoaHoc", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_KhoaHoc));
colParam.Add(CreateParam("@IDDM_Nganh", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_Nganh));
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.IDDM_Lop));
colParam.Add(CreateParam("@SoSinhVien", SqlDbType.Int, pTC_PhanBoQuyHocBongInfo.SoSinhVien));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_PhanBoQuyHocBongInfo.SoTien));
colParam.Add(CreateParam("@PhanDacBiet", SqlDbType.Bit, pTC_PhanBoQuyHocBongInfo.PhanDacBiet));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_PhanBoQuyHocBong_Add", colParam));
}
public void Delete(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
oDTC_PhanBoQuyHocBong.Delete(pTC_PhanBoQuyHocBongInfo);
mErrorMessage = oDTC_PhanBoQuyHocBong.ErrorMessages;
mErrorNumber = oDTC_PhanBoQuyHocBong.ErrorNumber;
}
public DataTable Get(TC_PhanBoQuyHocBongInfo pTC_PhanBoQuyHocBongInfo)
{
return(oDTC_PhanBoQuyHocBong.Get(pTC_PhanBoQuyHocBongInfo));
}
