public void Delete(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_LopTachGop_MonHocID", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.XL_LopTachGop_MonHocID));
RunProcedure("sp_XL_LopTachGop_MonHoc_Delete", colParam);
}
public DataTable Get(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_LopTachGop_MonHocID", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.XL_LopTachGop_MonHocID));
return(RunProcedureGet("sp_XL_LopTachGop_MonHoc_Get", colParam));
}
public void ToDataRow(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo, ref DataRow dr)
{
dr[pXL_LopTachGop_MonHocInfo.strXL_LopTachGop_MonHocID] = pXL_LopTachGop_MonHocInfo.XL_LopTachGop_MonHocID;
dr[pXL_LopTachGop_MonHocInfo.strIDXL_LopTachGop] = pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop;
dr[pXL_LopTachGop_MonHocInfo.strIDXL_MonHocTrongKy] = pXL_LopTachGop_MonHocInfo.IDXL_MonHocTrongKy;
dr[pXL_LopTachGop_MonHocInfo.strIDNS_GiaoVien] = pXL_LopTachGop_MonHocInfo.IDNS_GiaoVien;
dr[pXL_LopTachGop_MonHocInfo.strIDDM_PhongHoc] = pXL_LopTachGop_MonHocInfo.IDDM_PhongHoc;
dr[pXL_LopTachGop_MonHocInfo.strCaHoc] = pXL_LopTachGop_MonHocInfo.CaHoc;
}
public int Add(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
int ID = 0;
ID = oDXL_LopTachGop_MonHoc.Add(pXL_LopTachGop_MonHocInfo);
mErrorMessage = oDXL_LopTachGop_MonHoc.ErrorMessages;
mErrorNumber = oDXL_LopTachGop_MonHoc.ErrorNumber;
return(ID);
}
public void ToInfo(ref XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo, DataRow dr)
{
pXL_LopTachGop_MonHocInfo.XL_LopTachGop_MonHocID = int.Parse(dr[pXL_LopTachGop_MonHocInfo.strXL_LopTachGop_MonHocID].ToString());
pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop = int.Parse(dr[pXL_LopTachGop_MonHocInfo.strIDXL_LopTachGop].ToString());
pXL_LopTachGop_MonHocInfo.IDXL_MonHocTrongKy = int.Parse(dr[pXL_LopTachGop_MonHocInfo.strIDXL_MonHocTrongKy].ToString());
pXL_LopTachGop_MonHocInfo.IDNS_GiaoVien = int.Parse(dr[pXL_LopTachGop_MonHocInfo.strIDNS_GiaoVien].ToString());
pXL_LopTachGop_MonHocInfo.IDDM_PhongHoc = int.Parse(dr[pXL_LopTachGop_MonHocInfo.strIDDM_PhongHoc].ToString());
pXL_LopTachGop_MonHocInfo.CaHoc = int.Parse(dr[pXL_LopTachGop_MonHocInfo.strCaHoc].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 void Update(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDXL_LopTachGop", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDDM_PhongHoc));
colParam.Add(CreateParam("@CaHoc", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.CaHoc));
colParam.Add(CreateParam("@XL_LopTachGop_MonHocID", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.XL_LopTachGop_MonHocID));
RunProcedure("sp_XL_LopTachGop_MonHoc_Update", colParam);
}
public int Add(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDXL_LopTachGop", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDXL_LopTachGop));
colParam.Add(CreateParam("@IDXL_MonHocTrongKy", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDXL_MonHocTrongKy));
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDDM_PhongHoc", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.IDDM_PhongHoc));
colParam.Add(CreateParam("@CaHoc", SqlDbType.Int, pXL_LopTachGop_MonHocInfo.CaHoc));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_LopTachGop_MonHoc_Add", colParam));
}
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 dlgThemMonHoc_LopTach(string mXL_LopTachGopIDs, int mIDDM_Lop, int mIDXL_MonHocTrongKy, string mIDXL_MonHocTrongKys, bool mCheckTach_Gop, string mIDDM_Lops, int mSoLop)
{
InitializeComponent();
oBXL_GiaoVien_MonHoc = new cBXL_GiaoVien_MonHoc();
oBXL_LopTachGop_MonHoc = new cBXL_LopTachGop_MonHoc();
oBXL_LopTachGop = new cBXL_LopTachGop();
pXL_GiaoVien_MonHocInfo = new XL_GiaoVien_MonHocInfo();
pXL_LopTachGop_MonHocInfo = new XL_LopTachGop_MonHocInfo();
CheckTach_Gop = mCheckTach_Gop;
XL_LopTachGopIDs = mXL_LopTachGopIDs;
IDXL_MonHocTrongKy = mIDXL_MonHocTrongKy;
IDXL_MonHocTrongKys = mIDXL_MonHocTrongKys;
// them mon hoc - lop tach
if (CheckTach_Gop == false)
{
dtMonHoc = MonHocTrongKyGetAll(mIDDM_Lop);
IDDM_Lop = mIDDM_Lop;
}
else
{
// them mon hoc - lop gop
dtMonHocAll = MonHocTrongKyGetByLopGop(mIDDM_Lops, mSoLop);
Lib.clsDataTableHelper cls = new Lib.clsDataTableHelper();
dtMonHoc = cls.SelectDistinct(dtMonHocAll, new string[] { "IDDM_MonHoc", "TenMonHoc", "MaMonHoc", "IDNS_GiaoVien", "IDDM_PhongHoc", "Cahocs", "Chon" });
IDDM_Lops = mIDDM_Lops;
char[] mChar = { ',' };
ArrayLop = IDDM_Lops.Split(mChar);
IDDM_Lop = int.Parse(XL_LopTachGopIDs.Substring(0, XL_LopTachGopIDs.IndexOf(",")));
SoLop = mSoLop;
}
dtMonHoc.AcceptChanges();
repositoryPhongHoc.DataSource = LoadPhongHoc();
this.Tag = "";
}
public List <XL_LopTachGop_MonHocInfo> GetList(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
List <XL_LopTachGop_MonHocInfo> oXL_LopTachGop_MonHocInfoList = new List <XL_LopTachGop_MonHocInfo>();
DataTable dtb = Get(pXL_LopTachGop_MonHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_LopTachGop_MonHocInfo = new XL_LopTachGop_MonHocInfo();
oXL_LopTachGop_MonHocInfo.XL_LopTachGop_MonHocID = int.Parse(dtb.Rows[i]["XL_LopTachGop_MonHocID"].ToString());
oXL_LopTachGop_MonHocInfo.IDXL_LopTachGop = int.Parse(dtb.Rows[i]["IDXL_LopTachGop"].ToString());
oXL_LopTachGop_MonHocInfo.IDXL_MonHocTrongKy = int.Parse(dtb.Rows[i]["IDXL_MonHocTrongKy"].ToString());
oXL_LopTachGop_MonHocInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oXL_LopTachGop_MonHocInfo.IDDM_PhongHoc = int.Parse(dtb.Rows[i]["IDDM_PhongHoc"].ToString());
oXL_LopTachGop_MonHocInfo.CaHoc = int.Parse(dtb.Rows[i]["CaHoc"].ToString());
oXL_LopTachGop_MonHocInfoList.Add(oXL_LopTachGop_MonHocInfo);
}
}
return(oXL_LopTachGop_MonHocInfoList);
}
public void Delete(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
oDXL_LopTachGop_MonHoc.Delete(pXL_LopTachGop_MonHocInfo);
mErrorMessage = oDXL_LopTachGop_MonHoc.ErrorMessages;
mErrorNumber = oDXL_LopTachGop_MonHoc.ErrorNumber;
}
public DataTable Get(XL_LopTachGop_MonHocInfo pXL_LopTachGop_MonHocInfo)
{
return(oDXL_LopTachGop_MonHoc.Get(pXL_LopTachGop_MonHocInfo));
}
