public DataTable Get(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachTroCapID", SqlDbType.Int, pTC_DanhSachTroCapInfo.TC_DanhSachTroCapID));
return(RunProcedureGet("sp_TC_DanhSachTroCap_Get", colParam));
}
public void Delete(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TC_DanhSachTroCapID", SqlDbType.Int, pTC_DanhSachTroCapInfo.TC_DanhSachTroCapID));
RunProcedure("sp_TC_DanhSachTroCap_Delete", colParam);
}
public void ToDataRow(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo, ref DataRow dr)
{
dr[pTC_DanhSachTroCapInfo.strTC_DanhSachTroCapID] = pTC_DanhSachTroCapInfo.TC_DanhSachTroCapID;
dr[pTC_DanhSachTroCapInfo.strIDSV_SinhVien] = pTC_DanhSachTroCapInfo.IDSV_SinhVien;
dr[pTC_DanhSachTroCapInfo.strIDDM_NamHoc] = pTC_DanhSachTroCapInfo.IDDM_NamHoc;
dr[pTC_DanhSachTroCapInfo.strHocKy] = pTC_DanhSachTroCapInfo.HocKy;
dr[pTC_DanhSachTroCapInfo.strSoTien] = pTC_DanhSachTroCapInfo.SoTien;
dr[pTC_DanhSachTroCapInfo.strGhiChu] = pTC_DanhSachTroCapInfo.GhiChu;
}
public void ToInfo(ref TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo, DataRow dr)
{
pTC_DanhSachTroCapInfo.TC_DanhSachTroCapID = int.Parse(dr[pTC_DanhSachTroCapInfo.strTC_DanhSachTroCapID].ToString());
pTC_DanhSachTroCapInfo.IDSV_SinhVien = int.Parse(dr[pTC_DanhSachTroCapInfo.strIDSV_SinhVien].ToString());
pTC_DanhSachTroCapInfo.IDDM_NamHoc = int.Parse(dr[pTC_DanhSachTroCapInfo.strIDDM_NamHoc].ToString());
pTC_DanhSachTroCapInfo.HocKy = int.Parse(dr[pTC_DanhSachTroCapInfo.strHocKy].ToString());
pTC_DanhSachTroCapInfo.SoTien = double.Parse(dr[pTC_DanhSachTroCapInfo.strSoTien].ToString());
pTC_DanhSachTroCapInfo.GhiChu = dr[pTC_DanhSachTroCapInfo.strGhiChu].ToString();
}
public int Add(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
int ID = 0;
ID = oDTC_DanhSachTroCap.Add(pTC_DanhSachTroCapInfo);
mErrorMessage = oDTC_DanhSachTroCap.ErrorMessages;
mErrorNumber = oDTC_DanhSachTroCap.ErrorNumber;
return(ID);
}
public frmDanhSachTroCap()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_DoiTuongTroCapInfo = new DM_DoiTuongTroCapInfo();
oBDM_DoiTuongTroCap = new cBDM_DoiTuongTroCap();
pTC_DanhSachTroCapInfo = new TC_DanhSachTroCapInfo();
oBTC_DanhSachTroCap = new cBTC_DanhSachTroCap();
pTC_DanhSachTroCap_ChiTietInfo = new TC_DanhSachTroCap_ChiTietInfo();
oBTC_DanhSachTroCap_ChiTiet = new cBTC_DanhSachTroCap_ChiTiet();
}
public void Update(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachTroCapInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachTroCapInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachTroCapInfo.HocKy));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_DanhSachTroCapInfo.SoTien));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_DanhSachTroCapInfo.GhiChu));
colParam.Add(CreateParam("@TC_DanhSachTroCapID", SqlDbType.Int, pTC_DanhSachTroCapInfo.TC_DanhSachTroCapID));
RunProcedure("sp_TC_DanhSachTroCap_Update", colParam);
}
public int Add(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pTC_DanhSachTroCapInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pTC_DanhSachTroCapInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pTC_DanhSachTroCapInfo.HocKy));
colParam.Add(CreateParam("@SoTien", SqlDbType.Money, pTC_DanhSachTroCapInfo.SoTien));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pTC_DanhSachTroCapInfo.GhiChu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_TC_DanhSachTroCap_Add", colParam));
}
public List <TC_DanhSachTroCapInfo> GetList(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
List <TC_DanhSachTroCapInfo> oTC_DanhSachTroCapInfoList = new List <TC_DanhSachTroCapInfo>();
DataTable dtb = Get(pTC_DanhSachTroCapInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oTC_DanhSachTroCapInfo = new TC_DanhSachTroCapInfo();
oTC_DanhSachTroCapInfo.TC_DanhSachTroCapID = int.Parse(dtb.Rows[i]["TC_DanhSachTroCapID"].ToString());
oTC_DanhSachTroCapInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oTC_DanhSachTroCapInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oTC_DanhSachTroCapInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oTC_DanhSachTroCapInfo.SoTien = double.Parse(dtb.Rows[i]["SoTien"].ToString());
oTC_DanhSachTroCapInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString();
oTC_DanhSachTroCapInfoList.Add(oTC_DanhSachTroCapInfo);
}
}
return(oTC_DanhSachTroCapInfoList);
}
public void Delete(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
oDTC_DanhSachTroCap.Delete(pTC_DanhSachTroCapInfo);
mErrorMessage = oDTC_DanhSachTroCap.ErrorMessages;
mErrorNumber = oDTC_DanhSachTroCap.ErrorNumber;
}
public DataTable Get(TC_DanhSachTroCapInfo pTC_DanhSachTroCapInfo)
{
return(oDTC_DanhSachTroCap.Get(pTC_DanhSachTroCapInfo));
}
