public DataTable GetDanhSach(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_GiaoVien_MonHoc_GetDanhSachResult>(client.cDXL_GiaoVien_MonHoc_GetDanhSach(GlobalVar.MaXacThuc, pXL_GiaoVien_MonHocInfo)));
}
}
public DataTable GetDanhSach(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien));
return(RunProcedureGet("sp_XL_GiaoVien_MonHoc_GetDanhSach", colParam));
}
public void Delete(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_GiaoVien_MonHocID", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID));
RunProcedure("sp_XL_GiaoVien_MonHoc_Delete", colParam);
}
public DataTable Get(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_GiaoVien_MonHocID", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID));
return(RunProcedureGet("sp_XL_GiaoVien_MonHoc_Get", colParam));
}
public int Add(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
int ID = 0;
ID = oDXL_GiaoVien_MonHoc.Add(pXL_GiaoVien_MonHocInfo);
mErrorMessage = oDXL_GiaoVien_MonHoc.ErrorMessages;
mErrorNumber = oDXL_GiaoVien_MonHoc.ErrorNumber;
return(ID);
}
public void Update(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@XL_GiaoVien_MonHocID", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID));
RunProcedure("sp_XL_GiaoVien_MonHoc_Update", colParam);
}
public int Add(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pXL_GiaoVien_MonHocInfo.IDDM_MonHoc));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_GiaoVien_MonHoc_Add", colParam));
}
public frmPhanCongGiangDay()
{
InitializeComponent();
repositoryHinhThucThi.DataSource = LoadHinhThucThi();
oBXL_GiaoVien_MonHoc = new cBXL_GiaoVien_MonHoc();
pXL_GiaoVien_MonHocInfo = new XL_GiaoVien_MonHocInfo();
oBXL_PhanCongGiaoVien = new cBXL_PhanCongGiaoVien();
pXL_PhanCongGiaoVienInfo = new XL_PhanCongGiaoVienInfo();
oBNS_GiaoVien = new cBNS_GiaoVien();
}
public frmDanhSachGiaoVien()
{
InitializeComponent();
oBGiaoVien = new cBNS_GiaoVien();
pGiaoVienInfo = new NS_GiaoVienInfo();
pDonViInfo = new NS_DonViInfo();
oBXL_GV_MH = new cBXL_GiaoVien_MonHoc();
pXL_GV_MHInfo = new XL_GiaoVien_MonHocInfo();
repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinh();
}
public dlgChonMonHoc(int mIDNS_GiaoVien, string mHoTen)
{
InitializeComponent();
oBDM_MonHoc = new cBDM_MonHoc();
pDM_MonHocInfo = new DM_MonHocInfo();
oBXL_GV_MH = new cBXL_GiaoVien_MonHoc();
pXL_GV_MHInfo = new XL_GiaoVien_MonHocInfo();
pXL_GV_MHInfo.IDNS_GiaoVien = mIDNS_GiaoVien;
HoTen = mHoTen;
this.Tag = "";
}
public List <XL_GiaoVien_MonHocInfo> GetList(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
List <XL_GiaoVien_MonHocInfo> oXL_GiaoVien_MonHocInfoList = new List <XL_GiaoVien_MonHocInfo>();
DataTable dtb = Get(pXL_GiaoVien_MonHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_GiaoVien_MonHocInfo = new XL_GiaoVien_MonHocInfo();
oXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID = int.Parse(dtb.Rows[i]["XL_GiaoVien_MonHocID"].ToString());
oXL_GiaoVien_MonHocInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oXL_GiaoVien_MonHocInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oXL_GiaoVien_MonHocInfoList.Add(oXL_GiaoVien_MonHocInfo);
}
}
return(oXL_GiaoVien_MonHocInfoList);
}
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 void ToInfo(ref XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo, DataRow dr)
{
pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID = int.Parse(dr[pXL_GiaoVien_MonHocInfo.strXL_GiaoVien_MonHocID].ToString());
pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien = int.Parse(dr[pXL_GiaoVien_MonHocInfo.strIDNS_GiaoVien].ToString());
pXL_GiaoVien_MonHocInfo.IDDM_MonHoc = int.Parse(dr[pXL_GiaoVien_MonHocInfo.strIDDM_MonHoc].ToString());
}
public void ToDataRow(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo, ref DataRow dr)
{
dr[pXL_GiaoVien_MonHocInfo.strXL_GiaoVien_MonHocID] = pXL_GiaoVien_MonHocInfo.XL_GiaoVien_MonHocID;
dr[pXL_GiaoVien_MonHocInfo.strIDNS_GiaoVien] = pXL_GiaoVien_MonHocInfo.IDNS_GiaoVien;
dr[pXL_GiaoVien_MonHocInfo.strIDDM_MonHoc] = pXL_GiaoVien_MonHocInfo.IDDM_MonHoc;
}
public void Delete(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
oDXL_GiaoVien_MonHoc.Delete(pXL_GiaoVien_MonHocInfo);
mErrorMessage = oDXL_GiaoVien_MonHoc.ErrorMessages;
mErrorNumber = oDXL_GiaoVien_MonHoc.ErrorNumber;
}
public DataTable GetDanhSach(XL_GiaoVien_MonHocInfo pXL_GiaoVien_MonHocInfo)
{
return(oDXL_GiaoVien_MonHoc.GetDanhSach(pXL_GiaoVien_MonHocInfo));
}