public List <XL_LopTachGopInfo> GetList(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
List <XL_LopTachGopInfo> oXL_LopTachGopInfoList = new List <XL_LopTachGopInfo>();
DataTable dtb = Get(pXL_LopTachGopInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_LopTachGopInfo = new XL_LopTachGopInfo();
oXL_LopTachGopInfo.XL_LopTachGopID = int.Parse(dtb.Rows[i]["XL_LopTachGopID"].ToString());
oXL_LopTachGopInfo.TenLopTachGop = dtb.Rows[i]["TenLopTachGop"].ToString();
oXL_LopTachGopInfo.SoSinhVien = int.Parse(dtb.Rows[i]["SoSinhVien"].ToString());
oXL_LopTachGopInfo.IDDM_LopGoc = int.Parse(dtb.Rows[i]["IDDM_LopGoc"].ToString());
oXL_LopTachGopInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
oXL_LopTachGopInfo.HocKy = int.Parse(dtb.Rows[i]["HocKy"].ToString());
oXL_LopTachGopInfo.LopTach = bool.Parse(dtb.Rows[i]["LopTach"].ToString());
oXL_LopTachGopInfo.ParentID = int.Parse(dtb.Rows[i]["ParentID"].ToString());
oXL_LopTachGopInfoList.Add(oXL_LopTachGopInfo);
}
}
return(oXL_LopTachGopInfoList);
}
public void Delete(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_LopTachGopID", SqlDbType.Int, pXL_LopTachGopInfo.XL_LopTachGopID));
RunProcedure("sp_XL_LopTachGop_Delete", colParam);
}
public DataTable Get(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_LopTachGopID", SqlDbType.Int, pXL_LopTachGopInfo.XL_LopTachGopID));
return(RunProcedureGet("sp_XL_LopTachGop_Get", colParam));
}
public dlgSuaLopGop(string mIDXL_LopTachGops, string mTenLopTachGop)
{
InitializeComponent();
oBXL_LopTachGop = new cBXL_LopTachGop();
pXL_LopTachGopInfo = new XL_LopTachGopInfo();
strXL_LopTachGopIDs = mIDXL_LopTachGops;
TenLopTachGop = mTenLopTachGop;
txtTenLopGop.Text = TenLopTachGop;
}
public int Add(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
int ID = 0;
ID = oDXL_LopTachGop.Add(pXL_LopTachGopInfo);
mErrorMessage = oDXL_LopTachGop.ErrorMessages;
mErrorNumber = oDXL_LopTachGop.ErrorNumber;
return(ID);
}
public void ToDataRow(XL_LopTachGopInfo pXL_LopTachGopInfo, ref DataRow dr)
{
dr[pXL_LopTachGopInfo.strXL_LopTachGopID] = pXL_LopTachGopInfo.XL_LopTachGopID;
dr[pXL_LopTachGopInfo.strTenLopTachGop] = pXL_LopTachGopInfo.TenLopTachGop;
dr[pXL_LopTachGopInfo.strSoSinhVien] = pXL_LopTachGopInfo.SoSinhVien;
dr[pXL_LopTachGopInfo.strIDDM_LopGoc] = pXL_LopTachGopInfo.IDDM_LopGoc;
dr[pXL_LopTachGopInfo.strIDDM_NamHoc] = pXL_LopTachGopInfo.IDDM_NamHoc;
dr[pXL_LopTachGopInfo.strHocKy] = pXL_LopTachGopInfo.HocKy;
dr[pXL_LopTachGopInfo.strLopTach] = pXL_LopTachGopInfo.LopTach;
dr[pXL_LopTachGopInfo.strParentID] = pXL_LopTachGopInfo.ParentID;
}
public void ToInfo(ref XL_LopTachGopInfo pXL_LopTachGopInfo, DataRow dr)
{
pXL_LopTachGopInfo.XL_LopTachGopID = int.Parse(dr[pXL_LopTachGopInfo.strXL_LopTachGopID].ToString());
pXL_LopTachGopInfo.TenLopTachGop = dr[pXL_LopTachGopInfo.strTenLopTachGop].ToString();
pXL_LopTachGopInfo.SoSinhVien = int.Parse(dr[pXL_LopTachGopInfo.strSoSinhVien].ToString());
pXL_LopTachGopInfo.IDDM_LopGoc = int.Parse(dr[pXL_LopTachGopInfo.strIDDM_LopGoc].ToString());
pXL_LopTachGopInfo.IDDM_NamHoc = int.Parse(dr[pXL_LopTachGopInfo.strIDDM_NamHoc].ToString());
pXL_LopTachGopInfo.HocKy = int.Parse(dr[pXL_LopTachGopInfo.strHocKy].ToString());
pXL_LopTachGopInfo.LopTach = bool.Parse(dr[pXL_LopTachGopInfo.strLopTach].ToString());
pXL_LopTachGopInfo.ParentID = int.Parse(dr[pXL_LopTachGopInfo.strParentID].ToString());
}
private void dlgThemLopGop_Load(object sender, EventArgs e)
{
oBDM_Lop = new cBDM_Lop();
oBXL_GiaoVien_MonHoc = new cBXL_GiaoVien_MonHoc();
oBXL_LopTachGop = new cBXL_LopTachGop();
oBXL_LopTachGop_MonHoc = new cBXL_LopTachGop_MonHoc();
pXL_LopTachGop_MonHocInfo = new XL_LopTachGop_MonHocInfo();
pXL_LopTachGopInfo = new XL_LopTachGopInfo();
txtNamHoc.Text = Program.NamHoc;
LoadData();
repositoryPhongHoc.DataSource = LoadPhongHoc();
}
public frmLopTach()
{
InitializeComponent();
oBXL_LopTachGop = new cBXL_LopTachGop();
oBXL_GiaoVien_MonHoc = new cBXL_GiaoVien_MonHoc();
oBXL_LopTachGop_MonHoc = new cBXL_LopTachGop_MonHoc();
pXL_LopTachGopInfo = new XL_LopTachGopInfo();
pXL_LopTachGop_MonHocInfo = new XL_LopTachGop_MonHocInfo();
panelTop.Visible = false;
cmbKhoa.Properties.DataSource = LoadKhoa();
cmbKhoa_EditValueChanged(null, null);
repositoryPhongHoc.DataSource = LoadPhongHoc();
repositoryGiaoVien.DataSource = (new cBNS_GiaoVien()).Get_TKB(0);
}
public void Update(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenLopTachGop", SqlDbType.NVarChar, pXL_LopTachGopInfo.TenLopTachGop));
colParam.Add(CreateParam("@SoSinhVien", SqlDbType.Int, pXL_LopTachGopInfo.SoSinhVien));
colParam.Add(CreateParam("@IDDM_LopGoc", SqlDbType.Int, pXL_LopTachGopInfo.IDDM_LopGoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pXL_LopTachGopInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pXL_LopTachGopInfo.HocKy));
colParam.Add(CreateParam("@LopTach", SqlDbType.Bit, pXL_LopTachGopInfo.LopTach));
colParam.Add(CreateParam("@ParentID", SqlDbType.Int, pXL_LopTachGopInfo.ParentID));
colParam.Add(CreateParam("@XL_LopTachGopID", SqlDbType.Int, pXL_LopTachGopInfo.XL_LopTachGopID));
RunProcedure("sp_XL_LopTachGop_Update", colParam);
}
public int Add(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenLopTachGop", SqlDbType.NVarChar, pXL_LopTachGopInfo.TenLopTachGop));
colParam.Add(CreateParam("@SoSinhVien", SqlDbType.Int, pXL_LopTachGopInfo.SoSinhVien));
colParam.Add(CreateParam("@IDDM_LopGoc", SqlDbType.Int, pXL_LopTachGopInfo.IDDM_LopGoc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pXL_LopTachGopInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pXL_LopTachGopInfo.HocKy));
colParam.Add(CreateParam("@LopTach", SqlDbType.Bit, pXL_LopTachGopInfo.LopTach));
colParam.Add(CreateParam("@ParentID", SqlDbType.Int, pXL_LopTachGopInfo.ParentID));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_LopTachGop_Add", colParam));
}
public frmLopGop()
{
InitializeComponent();
this.Tag = "";
oBDM_He = new cBDM_He();
oBDM_Nganh = new cBDM_Nganh();
oBDM_TrinhDo = new cBDM_TrinhDo();
oBDM_KhoaHoc = new cBDM_KhoaHoc();
pDM_HeInfo = new DM_HeInfo();
pDM_NganhInfo = new DM_NganhInfo();
pDM_TrinhDoInfo = new DM_TrinhDoInfo();
pDM_KhoaHocInfo = new DM_KhoaHocInfo();
pXL_LopTachGopInfo = new XL_LopTachGopInfo();
oBXL_LopTachGop = new cBXL_LopTachGop();
}
public void Delete(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
oDXL_LopTachGop.Delete(pXL_LopTachGopInfo);
mErrorMessage = oDXL_LopTachGop.ErrorMessages;
mErrorNumber = oDXL_LopTachGop.ErrorNumber;
}
public DataTable Get(XL_LopTachGopInfo pXL_LopTachGopInfo)
{
return(oDXL_LopTachGop.Get(pXL_LopTachGopInfo));
}
