public dlgApDungAnhXaMon(DataRow mdr)
{
InitializeComponent();
oBSV_AnhXaMon = new cBSV_AnhXaMon();
pSV_AnhXaMonInfo = new SV_AnhXaMonInfo();
oBSV_NhapHocLai = new cBSV_NhapHocLai();
dr = mdr;
}
public void ToInfo(ref SV_AnhXaMonInfo pSV_AnhXaMonInfo, DataRow dr)
{
pSV_AnhXaMonInfo.SV_AnhXaMonID = long.Parse(dr[pSV_AnhXaMonInfo.strSV_AnhXaMonID].ToString());
pSV_AnhXaMonInfo.IDSV_SinhVien = int.Parse(dr[pSV_AnhXaMonInfo.strIDSV_SinhVien].ToString());
pSV_AnhXaMonInfo.IDXL_MonHocTrongKyCu = int.Parse(dr[pSV_AnhXaMonInfo.strIDXL_MonHocTrongKyCu].ToString());
pSV_AnhXaMonInfo.IDXL_MonHocTrongKyMoi = int.Parse(dr[pSV_AnhXaMonInfo.strIDXL_MonHocTrongKyMoi].ToString());
pSV_AnhXaMonInfo.IDDM_Lop = int.Parse(dr[pSV_AnhXaMonInfo.strIDDM_Lop].ToString());
}
public void ToDataRow(SV_AnhXaMonInfo pSV_AnhXaMonInfo, ref DataRow dr)
{
dr[pSV_AnhXaMonInfo.strSV_AnhXaMonID] = pSV_AnhXaMonInfo.SV_AnhXaMonID;
dr[pSV_AnhXaMonInfo.strIDSV_SinhVien] = pSV_AnhXaMonInfo.IDSV_SinhVien;
dr[pSV_AnhXaMonInfo.strIDXL_MonHocTrongKyCu] = pSV_AnhXaMonInfo.IDXL_MonHocTrongKyCu;
dr[pSV_AnhXaMonInfo.strIDXL_MonHocTrongKyMoi] = pSV_AnhXaMonInfo.IDXL_MonHocTrongKyMoi;
dr[pSV_AnhXaMonInfo.strIDDM_Lop] = pSV_AnhXaMonInfo.IDDM_Lop;
}
public void Delete(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_AnhXaMonID", SqlDbType.BigInt, pSV_AnhXaMonInfo.SV_AnhXaMonID));
RunProcedure("sp_SV_AnhXaMon_Delete", colParam);
}
public DataTable Get(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_AnhXaMonID", SqlDbType.BigInt, pSV_AnhXaMonInfo.SV_AnhXaMonID));
return(RunProcedureGet("sp_SV_AnhXaMon_Get", colParam));
}
public int Add(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
int ID = 0;
ID = oDSV_AnhXaMon.Add(pSV_AnhXaMonInfo);
mErrorMessage = oDSV_AnhXaMon.ErrorMessages;
mErrorNumber = oDSV_AnhXaMon.ErrorNumber;
return(ID);
}
public dlgAnhXaMonHoc(DataRow mdr, string TenLopMoi)
{
InitializeComponent();
dr = mdr;
txtTenLopMoi.Text = TenLopMoi;
oBXL_MonHocTrongKy = new cBXL_MonHocTrongKy();
oBSV_AnhXaMon = new cBSV_AnhXaMon();
pSV_AnhXaMonInfo = new SV_AnhXaMonInfo();
}
public void Update(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pSV_AnhXaMonInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDXL_MonHocTrongKyCu", SqlDbType.Int, pSV_AnhXaMonInfo.IDXL_MonHocTrongKyCu));
colParam.Add(CreateParam("@IDXL_MonHocTrongKyMoi", SqlDbType.Int, pSV_AnhXaMonInfo.IDXL_MonHocTrongKyMoi));
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pSV_AnhXaMonInfo.IDDM_Lop));
colParam.Add(CreateParam("@SV_AnhXaMonID", SqlDbType.BigInt, pSV_AnhXaMonInfo.SV_AnhXaMonID));
RunProcedure("sp_SV_AnhXaMon_Update", colParam);
}
public int Add(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDSV_SinhVien", SqlDbType.Int, pSV_AnhXaMonInfo.IDSV_SinhVien));
colParam.Add(CreateParam("@IDXL_MonHocTrongKyCu", SqlDbType.Int, pSV_AnhXaMonInfo.IDXL_MonHocTrongKyCu));
colParam.Add(CreateParam("@IDXL_MonHocTrongKyMoi", SqlDbType.Int, pSV_AnhXaMonInfo.IDXL_MonHocTrongKyMoi));
colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pSV_AnhXaMonInfo.IDDM_Lop));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_SV_AnhXaMon_Add", colParam));
}
public List <SV_AnhXaMonInfo> GetList(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
List <SV_AnhXaMonInfo> oSV_AnhXaMonInfoList = new List <SV_AnhXaMonInfo>();
DataTable dtb = Get(pSV_AnhXaMonInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oSV_AnhXaMonInfo = new SV_AnhXaMonInfo();
oSV_AnhXaMonInfo.SV_AnhXaMonID = long.Parse(dtb.Rows[i]["SV_AnhXaMonID"].ToString());
oSV_AnhXaMonInfo.IDSV_SinhVien = int.Parse(dtb.Rows[i]["IDSV_SinhVien"].ToString());
oSV_AnhXaMonInfo.IDXL_MonHocTrongKyCu = int.Parse(dtb.Rows[i]["IDXL_MonHocTrongKyCu"].ToString());
oSV_AnhXaMonInfo.IDXL_MonHocTrongKyMoi = int.Parse(dtb.Rows[i]["IDXL_MonHocTrongKyMoi"].ToString());
oSV_AnhXaMonInfo.IDDM_Lop = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString());
oSV_AnhXaMonInfoList.Add(oSV_AnhXaMonInfo);
}
}
return(oSV_AnhXaMonInfoList);
}
public void Delete(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
oDSV_AnhXaMon.Delete(pSV_AnhXaMonInfo);
mErrorMessage = oDSV_AnhXaMon.ErrorMessages;
mErrorNumber = oDSV_AnhXaMon.ErrorNumber;
}
public DataTable Get(SV_AnhXaMonInfo pSV_AnhXaMonInfo)
{
return(oDSV_AnhXaMon.Get(pSV_AnhXaMonInfo));
}
