public DataTable Get(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_MonHoc_CT_KhoiKienThuc_GetResult>(client.cDKQHT_MonHoc_CT_KhoiKienThuc_Get(GlobalVar.MaXacThuc, pKQHT_MonHoc_CT_KhoiKienThucInfo)));
}
}
public List <KQHT_MonHoc_CT_KhoiKienThucInfo> GetList(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
List <KQHT_MonHoc_CT_KhoiKienThucInfo> oKQHT_MonHoc_CT_KhoiKienThucInfoList = new List <KQHT_MonHoc_CT_KhoiKienThucInfo>();
DataTable dtb = Get(pKQHT_MonHoc_CT_KhoiKienThucInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_MonHoc_CT_KhoiKienThucInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo();
oKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID = int.Parse(dtb.Rows[i]["KQHT_MonHoc_CT_KhoiKienThucID"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.IDKQHT_CT_KhoiKienThuc = int.Parse(dtb.Rows[i]["IDKQHT_CT_KhoiKienThuc"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_MonHoc = int.Parse(dtb.Rows[i]["IDDM_MonHoc"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.SoHocTrinh = double.Parse(dtb.Rows[i]["SoHocTrinh"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.SoTiet = int.Parse(dtb.Rows[i]["SoTiet"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.LyThuyet = int.Parse(dtb.Rows[i]["LyThuyet"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.ThucHanh = int.Parse(dtb.Rows[i]["ThucHanh"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac1 = int.Parse(dtb.Rows[i]["LoaiTietKhac1"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac2 = int.Parse(dtb.Rows[i]["LoaiTietKhac2"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.ChoPhepXepLich = bool.Parse(dtb.Rows[i]["ChoPhepXepLich"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_HinhThucThi = int.Parse(dtb.Rows[i]["IDDM_HinhThucThi"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.TuChon = bool.Parse(dtb.Rows[i]["TuChon"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfo.SapXep = int.Parse(dtb.Rows[i]["SapXep"].ToString());
oKQHT_MonHoc_CT_KhoiKienThucInfoList.Add(oKQHT_MonHoc_CT_KhoiKienThucInfo);
}
}
return(oKQHT_MonHoc_CT_KhoiKienThucInfoList);
}
public void Delete(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_MonHoc_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID));
RunProcedure("sp_KQHT_MonHoc_CT_KhoiKienThuc_Delete", colParam);
}
public DataTable Get(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_MonHoc_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID));
return(RunProcedureGet("sp_KQHT_MonHoc_CT_KhoiKienThuc_Get", colParam));
}
public frmChuongTrinhKhoiKienThuc()
{
InitializeComponent();
oBKQHT_CT_KhoiKienThuc = new cBKQHT_CT_KhoiKienThuc();
pKQHT_CT_KhoiKienThucInfo = new KQHT_CT_KhoiKienThucInfo();
oBKQHT_MonHoc_CT_KhoiKienThuc = new cBKQHT_MonHoc_CT_KhoiKienThuc();
pKQHT_MonHoc_CT_KhoiKienThucInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo();
SetButton(false);
}
public dlgChonCTKhoiKienThuc(int mIDKQHT_ChuongTrinhDaoTao)
{
InitializeComponent();
oBKQHT_CT_KhoiKienThuc = new cBKQHT_CT_KhoiKienThuc();
pKQHT_CT_KhoiKienThucInfo = new KQHT_CT_KhoiKienThucInfo();
oBKQHT_MonHoc_CT_KhoiKienThuc = new cBKQHT_MonHoc_CT_KhoiKienThuc();
pKQHT_MonHoc_CT_KhoiKienThucInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo();
IDKQHT_ChuongTrinhDaoTao = mIDKQHT_ChuongTrinhDaoTao;
}
public void Delete(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_MonHoc_CT_KhoiKienThuc_Delete(GlobalVar.MaXacThuc, pKQHT_MonHoc_CT_KhoiKienThucInfo);
client.Close();
mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber;
}
public int Add(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
int ID = 0;
ID = oDKQHT_MonHoc_CT_KhoiKienThuc.Add(pKQHT_MonHoc_CT_KhoiKienThucInfo);
mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber;
return(ID);
}
public dlgCTDTChonMonHoc(int mIDKQHT_CT_KhoiKienThuc, string TenCTDT, ref DataTable _dtMonHoc)
{
InitializeComponent();
dtMonHoc = _dtMonHoc;
oBKQHT_MonHoc_CT_KhoiKienThuc = new cBKQHT_MonHoc_CT_KhoiKienThuc();
pInfo = new KQHT_MonHoc_CT_KhoiKienThucInfo();
pInfo.IDKQHT_CT_KhoiKienThuc = mIDKQHT_CT_KhoiKienThuc;
lblCTDT.Text = TenCTDT.ToUpper();
this.DialogResult = DialogResult.Cancel;
}
public int Add(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_MonHoc_CT_KhoiKienThuc_Add(GlobalVar.MaXacThuc, pKQHT_MonHoc_CT_KhoiKienThucInfo);
client.Close();
mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber;
return(ID);
}
public void ToDataRow(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo, ref DataRow dr)
{
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strKQHT_MonHoc_CT_KhoiKienThucID] = pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strIDKQHT_CT_KhoiKienThuc] = pKQHT_MonHoc_CT_KhoiKienThucInfo.IDKQHT_CT_KhoiKienThuc;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strIDDM_MonHoc] = pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_MonHoc;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strSoHocTrinh] = pKQHT_MonHoc_CT_KhoiKienThucInfo.SoHocTrinh;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strSoTiet] = pKQHT_MonHoc_CT_KhoiKienThucInfo.SoTiet;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strLyThuyet] = pKQHT_MonHoc_CT_KhoiKienThucInfo.LyThuyet;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strThucHanh] = pKQHT_MonHoc_CT_KhoiKienThucInfo.ThucHanh;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strLoaiTietKhac1] = pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac1;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strLoaiTietKhac2] = pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac2;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strChoPhepXepLich] = pKQHT_MonHoc_CT_KhoiKienThucInfo.ChoPhepXepLich;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strIDDM_HinhThucThi] = pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_HinhThucThi;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strTuChon] = pKQHT_MonHoc_CT_KhoiKienThucInfo.TuChon;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strSapXep] = pKQHT_MonHoc_CT_KhoiKienThucInfo.SapXep;
dr[pKQHT_MonHoc_CT_KhoiKienThucInfo.strTinhDiemToanKhoa] = pKQHT_MonHoc_CT_KhoiKienThucInfo.TinhDiemToanKhoa;
}
public void Update(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDKQHT_CT_KhoiKienThuc", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.IDKQHT_CT_KhoiKienThuc));
colParam.Add(CreateParam("@IDDM_MonHoc", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_MonHoc));
colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Real, pKQHT_MonHoc_CT_KhoiKienThucInfo.SoHocTrinh));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.SoTiet));
colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.LyThuyet));
colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.ThucHanh));
colParam.Add(CreateParam("@LoaiTietKhac1", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac1));
colParam.Add(CreateParam("@LoaiTietKhac2", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.LoaiTietKhac2));
colParam.Add(CreateParam("@ChoPhepXepLich", SqlDbType.Bit, pKQHT_MonHoc_CT_KhoiKienThucInfo.ChoPhepXepLich));
colParam.Add(CreateParam("@IDDM_HinhThucThi", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.IDDM_HinhThucThi));
colParam.Add(CreateParam("@TuChon", SqlDbType.Bit, pKQHT_MonHoc_CT_KhoiKienThucInfo.TuChon));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.SapXep));
colParam.Add(CreateParam("@TinhDiemToanKhoa", SqlDbType.Bit, pKQHT_MonHoc_CT_KhoiKienThucInfo.TinhDiemToanKhoa));
colParam.Add(CreateParam("@KQHT_MonHoc_CT_KhoiKienThucID", SqlDbType.Int, pKQHT_MonHoc_CT_KhoiKienThucInfo.KQHT_MonHoc_CT_KhoiKienThucID));
RunProcedure("sp_KQHT_MonHoc_CT_KhoiKienThuc_Update", colParam);
}
public void Delete(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
oDKQHT_MonHoc_CT_KhoiKienThuc.Delete(pKQHT_MonHoc_CT_KhoiKienThucInfo);
mErrorMessage = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDKQHT_MonHoc_CT_KhoiKienThuc.ErrorNumber;
}
public DataTable Get(KQHT_MonHoc_CT_KhoiKienThucInfo pKQHT_MonHoc_CT_KhoiKienThucInfo)
{
return(oDKQHT_MonHoc_CT_KhoiKienThuc.Get(pKQHT_MonHoc_CT_KhoiKienThucInfo));
}