public void Update(DM_MonHocInfo pDM_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaMonHoc", SqlDbType.NVarChar, pDM_MonHocInfo.MaMonHoc));
colParam.Add(CreateParam("@TenMonHoc", SqlDbType.NVarChar, pDM_MonHocInfo.TenMonHoc));
colParam.Add(CreateParam("@TenMonHoc_E", SqlDbType.NVarChar, pDM_MonHocInfo.TenMonHoc_E));
colParam.Add(CreateParam("@TenVietTat", SqlDbType.NVarChar, pDM_MonHocInfo.TenVietTat));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pDM_MonHocInfo.SoTiet));
colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pDM_MonHocInfo.LyThuyet));
colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pDM_MonHocInfo.ThucHanh));
colParam.Add(CreateParam("@LoaiTietKhac1", SqlDbType.Int, pDM_MonHocInfo.LoaiTietKhac1));
colParam.Add(CreateParam("@LoaiTietKhac2", SqlDbType.Int, pDM_MonHocInfo.LoaiTietKhac2));
colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Real, pDM_MonHocInfo.SoHocTrinh));
colParam.Add(CreateParam("@ChoPhepXepLich", SqlDbType.Bit, pDM_MonHocInfo.ChoPhepXepLich));
colParam.Add(CreateParam("@SuDungPhong", SqlDbType.Int, pDM_MonHocInfo.SuDungPhong));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pDM_MonHocInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@IDDM_Nganh", SqlDbType.Int, pDM_MonHocInfo.IDDM_Nganh));
colParam.Add(CreateParam("@IDDM_ChuyenNganh", SqlDbType.Int, pDM_MonHocInfo.IDDM_ChuyenNganh));
colParam.Add(CreateParam("@IDDM_BoMon", SqlDbType.Int, pDM_MonHocInfo.IDDM_BoMon));
colParam.Add(CreateParam("@IDDM_KhoiKienThuc", SqlDbType.Int, pDM_MonHocInfo.IDDM_KhoiKienThuc));
colParam.Add(CreateParam("@IDDM_HinhThucThi", SqlDbType.Int, pDM_MonHocInfo.IDDM_HinhThucThi));
colParam.Add(CreateParam("@MoTa", SqlDbType.NText, pDM_MonHocInfo.MoTa));
colParam.Add(CreateParam("@TinhDiemToanKhoa", SqlDbType.Bit, pDM_MonHocInfo.TinhDiemToanKhoa));
colParam.Add(CreateParam("@DM_MonHocID", SqlDbType.Int, pDM_MonHocInfo.DM_MonHocID));
RunProcedure("sp_DM_MonHoc_Update", colParam);
}
public DataTable Get(DM_MonHocInfo pDM_MonHocInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_MonHoc_GetResult>(client.cDDM_MonHoc_Get(GlobalVar.MaXacThuc, pDM_MonHocInfo)));
}
}
public DataTable Get(DM_MonHocInfo pDM_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_MonHocID", SqlDbType.Int, pDM_MonHocInfo.DM_MonHocID));
return(RunProcedureGet("sp_DM_MonHoc_Get", colParam));
}
public void Delete(DM_MonHocInfo pDM_MonHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_MonHocID", SqlDbType.Int, pDM_MonHocInfo.DM_MonHocID));
RunProcedure("sp_DM_MonHoc_Delete", colParam);
}
public void Delete(DM_MonHocInfo pDM_MonHocInfo)
{
var client = new UnimOsServiceClient();
client.cDDM_MonHoc_Delete(GlobalVar.MaXacThuc, pDM_MonHocInfo);
client.Close();
mErrorMessage = oDDM_MonHoc.ErrorMessages;
mErrorNumber = oDDM_MonHoc.ErrorNumber;
}
public int Add(DM_MonHocInfo pDM_MonHocInfo)
{
int ID = 0;
ID = oDDM_MonHoc.Add(pDM_MonHocInfo);
mErrorMessage = oDDM_MonHoc.ErrorMessages;
mErrorNumber = oDDM_MonHoc.ErrorNumber;
return(ID);
}
public int AddByImport(DM_MonHocInfo pDM_MonHocInfo, ref string Error)
{
int ID = 0;
ID = oDDM_MonHoc.AddByImport(pDM_MonHocInfo, ref Error);
mErrorMessage = oDDM_MonHoc.ErrorMessages;
mErrorNumber = oDDM_MonHoc.ErrorNumber;
return(ID);
}
public void ToInfo(ref DM_MonHocInfo pDM_MonHocInfo, DataRow dr, DataTable dt)
{
if (dt.Columns.Contains(pDM_MonHocInfo.strMaMonHoc))
{
pDM_MonHocInfo.MaMonHoc = dr[pDM_MonHocInfo.strMaMonHoc].ToString().Trim();
}
else
{
pDM_MonHocInfo.MaMonHoc = "";
}
if (dt.Columns.Contains(pDM_MonHocInfo.strTenMonHoc))
{
pDM_MonHocInfo.TenMonHoc = dr[pDM_MonHocInfo.strTenMonHoc].ToString().Trim();
}
if (dt.Columns.Contains(pDM_MonHocInfo.strTenVietTat))
{
pDM_MonHocInfo.TenVietTat = dr[pDM_MonHocInfo.strTenVietTat].ToString().Trim();
}
if (dt.Columns.Contains(pDM_MonHocInfo.strSoTiet))
{
pDM_MonHocInfo.SoTiet = int.Parse("0" + dr[pDM_MonHocInfo.strSoTiet]);
}
if (dt.Columns.Contains(pDM_MonHocInfo.strLyThuyet))
{
if ("" + dr[pDM_MonHocInfo.strLyThuyet] == "")
{
if (int.Parse("0" + dr[pDM_MonHocInfo.strThucHanh]) <= 0)
{
pDM_MonHocInfo.LyThuyet = int.Parse(dr[pDM_MonHocInfo.strSoTiet].ToString().Trim());
}
else
{
pDM_MonHocInfo.LyThuyet = 0;
}
}
else
{
pDM_MonHocInfo.LyThuyet = int.Parse(dr[pDM_MonHocInfo.strLyThuyet].ToString().Trim());
}
}
if (dt.Columns.Contains(pDM_MonHocInfo.strThucHanh))
{
pDM_MonHocInfo.ThucHanh = int.Parse("0" + dr[pDM_MonHocInfo.strThucHanh]);
}
if (dt.Columns.Contains(pDM_MonHocInfo.strSoHocTrinh))
{
pDM_MonHocInfo.SoHocTrinh = double.Parse("0" + dr[pDM_MonHocInfo.strSoHocTrinh]);
}
else
{
pDM_MonHocInfo.SoHocTrinh = Math.Round(double.Parse("0" + dr[pDM_MonHocInfo.strSoTiet]) / 15, 0);
}
pDM_MonHocInfo.SuDungPhong = (int)SU_DUNG_PHONG.BAT_KY;
}
public frmMonHoc()
{
InitializeComponent();
oBDM_MonHoc = new cBDM_MonHoc();
pDM_MonHocInfo = new DM_MonHocInfo();
SetControl(false);
SetButton(false);
radiogroupSuDungPhong.SelectedIndex = 1;
grdPhong.Enabled = false;
CheckedChanged();
}
public int AddByImport(DM_MonHocInfo pDM_MonHocInfo, ref string Error)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDDM_MonHoc_AddByImport(GlobalVar.MaXacThuc, pDM_MonHocInfo, ref Error);
client.Close();
mErrorMessage = oDDM_MonHoc.ErrorMessages;
mErrorNumber = oDDM_MonHoc.ErrorNumber;
return(ID);
}
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 int AddByImport(DM_MonHocInfo pDM_MonHocInfo, ref string Error)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaMonHoc", SqlDbType.NVarChar, pDM_MonHocInfo.MaMonHoc));
colParam.Add(CreateParam("@TenMonHoc", SqlDbType.NVarChar, pDM_MonHocInfo.TenMonHoc));
colParam.Add(CreateParam("@TenVietTat", SqlDbType.NVarChar, pDM_MonHocInfo.TenVietTat));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pDM_MonHocInfo.SoTiet));
colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pDM_MonHocInfo.LyThuyet));
colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pDM_MonHocInfo.ThucHanh));
colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Real, pDM_MonHocInfo.SoHocTrinh));
colParam.Add(CreateParam("@SuDungPhong", SqlDbType.Int, pDM_MonHocInfo.SuDungPhong));
colParam.Add(CreateParamOut("@Error", SqlDbType.NVarChar, 400));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
object[] obj = RunProcedureOut("sp_DM_MonHoc_AddByImport", colParam, new string[] { "Error", "ID" });
Error = obj[0].ToString();
return(int.Parse(obj[1].ToString()));
}
public List <DM_MonHocInfo> GetList(DM_MonHocInfo pDM_MonHocInfo)
{
List <DM_MonHocInfo> oDM_MonHocInfoList = new List <DM_MonHocInfo>();
DataTable dtb = Get(pDM_MonHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_MonHocInfo = new DM_MonHocInfo();
oDM_MonHocInfo.DM_MonHocID = int.Parse(dtb.Rows[i]["DM_MonHocID"].ToString());
oDM_MonHocInfo.MaMonHoc = dtb.Rows[i]["MaMonHoc"].ToString();
oDM_MonHocInfo.TenMonHoc = dtb.Rows[i]["TenMonHoc"].ToString();
oDM_MonHocInfo.TenMonHoc_E = dtb.Rows[i]["TenMonHoc_E"].ToString();
oDM_MonHocInfo.TenVietTat = dtb.Rows[i]["TenVietTat"].ToString();
oDM_MonHocInfo.SoTiet = int.Parse(dtb.Rows[i]["SoTiet"].ToString());
oDM_MonHocInfo.LyThuyet = int.Parse(dtb.Rows[i]["LyThuyet"].ToString());
oDM_MonHocInfo.ThucHanh = int.Parse(dtb.Rows[i]["ThucHanh"].ToString());
oDM_MonHocInfo.LoaiTietKhac1 = int.Parse(dtb.Rows[i]["LoaiTietKhac1"].ToString());
oDM_MonHocInfo.LoaiTietKhac2 = int.Parse(dtb.Rows[i]["LoaiTietKhac2"].ToString());
oDM_MonHocInfo.SoHocTrinh = double.Parse(dtb.Rows[i]["SoHocTrinh"].ToString());
oDM_MonHocInfo.ChoPhepXepLich = bool.Parse(dtb.Rows[i]["ChoPhepXepLich"].ToString());
oDM_MonHocInfo.SuDungPhong = int.Parse(dtb.Rows[i]["SuDungPhong"].ToString());
oDM_MonHocInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i]["IDDM_TrinhDo"].ToString());
oDM_MonHocInfo.IDDM_Nganh = int.Parse(dtb.Rows[i]["IDDM_Nganh"].ToString());
oDM_MonHocInfo.IDDM_ChuyenNganh = int.Parse(dtb.Rows[i]["IDDM_ChuyenNganh"].ToString());
oDM_MonHocInfo.IDDM_BoMon = int.Parse(dtb.Rows[i]["IDDM_BoMon"].ToString());
oDM_MonHocInfo.IDDM_KhoiKienThuc = int.Parse(dtb.Rows[i]["IDDM_KhoiKienThuc"].ToString());
oDM_MonHocInfo.IDDM_HinhThucThi = int.Parse(dtb.Rows[i]["IDDM_HinhThucThi"].ToString());
oDM_MonHocInfo.MoTa = dtb.Rows[i]["MoTa"].ToString();
oDM_MonHocInfoList.Add(oDM_MonHocInfo);
}
}
return(oDM_MonHocInfoList);
}
public void ToInfo(ref DM_MonHocInfo pDM_MonHocInfo, DataRow dr)
{
pDM_MonHocInfo.DM_MonHocID = int.Parse(dr[pDM_MonHocInfo.strDM_MonHocID].ToString());
pDM_MonHocInfo.MaMonHoc = dr[pDM_MonHocInfo.strMaMonHoc].ToString();
pDM_MonHocInfo.TenMonHoc = dr[pDM_MonHocInfo.strTenMonHoc].ToString();
pDM_MonHocInfo.TenMonHoc_E = dr[pDM_MonHocInfo.strTenMonHoc_E].ToString();
pDM_MonHocInfo.TenVietTat = dr[pDM_MonHocInfo.strTenVietTat].ToString();
pDM_MonHocInfo.SoTiet = int.Parse(dr[pDM_MonHocInfo.strSoTiet].ToString());
pDM_MonHocInfo.LyThuyet = int.Parse(dr[pDM_MonHocInfo.strLyThuyet].ToString());
pDM_MonHocInfo.ThucHanh = int.Parse(dr[pDM_MonHocInfo.strThucHanh].ToString());
pDM_MonHocInfo.LoaiTietKhac1 = int.Parse(dr[pDM_MonHocInfo.strLoaiTietKhac1].ToString());
pDM_MonHocInfo.LoaiTietKhac2 = int.Parse(dr[pDM_MonHocInfo.strLoaiTietKhac2].ToString());
pDM_MonHocInfo.SoHocTrinh = double.Parse(dr[pDM_MonHocInfo.strSoHocTrinh].ToString());
pDM_MonHocInfo.ChoPhepXepLich = bool.Parse(dr[pDM_MonHocInfo.strChoPhepXepLich].ToString());
pDM_MonHocInfo.SuDungPhong = int.Parse(dr[pDM_MonHocInfo.strSuDungPhong].ToString());
pDM_MonHocInfo.IDDM_TrinhDo = int.Parse(dr[pDM_MonHocInfo.strIDDM_TrinhDo].ToString());
pDM_MonHocInfo.IDDM_Nganh = int.Parse(dr[pDM_MonHocInfo.strIDDM_Nganh].ToString());
pDM_MonHocInfo.IDDM_ChuyenNganh = int.Parse(dr[pDM_MonHocInfo.strIDDM_ChuyenNganh].ToString());
pDM_MonHocInfo.IDDM_BoMon = int.Parse(dr[pDM_MonHocInfo.strIDDM_BoMon].ToString());
pDM_MonHocInfo.IDDM_KhoiKienThuc = int.Parse(dr[pDM_MonHocInfo.strIDDM_KhoiKienThuc].ToString());
pDM_MonHocInfo.IDDM_HinhThucThi = int.Parse(dr[pDM_MonHocInfo.strIDDM_HinhThucThi].ToString());
pDM_MonHocInfo.MoTa = dr[pDM_MonHocInfo.strMoTa].ToString();
pDM_MonHocInfo.TinhDiemToanKhoa = bool.Parse(dr[pDM_MonHocInfo.strTinhDiemToanKhoa].ToString());
}
public void ToDataRow(DM_MonHocInfo pDM_MonHocInfo, ref DataRow dr)
{
dr[pDM_MonHocInfo.strDM_MonHocID] = pDM_MonHocInfo.DM_MonHocID;
dr[pDM_MonHocInfo.strMaMonHoc] = pDM_MonHocInfo.MaMonHoc;
dr[pDM_MonHocInfo.strTenMonHoc] = pDM_MonHocInfo.TenMonHoc;
dr[pDM_MonHocInfo.strTenMonHoc_E] = pDM_MonHocInfo.TenMonHoc_E;
dr[pDM_MonHocInfo.strTenVietTat] = pDM_MonHocInfo.TenVietTat;
dr[pDM_MonHocInfo.strSoTiet] = pDM_MonHocInfo.SoTiet;
dr[pDM_MonHocInfo.strLyThuyet] = pDM_MonHocInfo.LyThuyet;
dr[pDM_MonHocInfo.strThucHanh] = pDM_MonHocInfo.ThucHanh;
dr[pDM_MonHocInfo.strLoaiTietKhac1] = pDM_MonHocInfo.LoaiTietKhac1;
dr[pDM_MonHocInfo.strLoaiTietKhac2] = pDM_MonHocInfo.LoaiTietKhac2;
dr[pDM_MonHocInfo.strSoHocTrinh] = pDM_MonHocInfo.SoHocTrinh;
dr[pDM_MonHocInfo.strChoPhepXepLich] = pDM_MonHocInfo.ChoPhepXepLich;
dr[pDM_MonHocInfo.strSuDungPhong] = pDM_MonHocInfo.SuDungPhong;
dr[pDM_MonHocInfo.strIDDM_TrinhDo] = pDM_MonHocInfo.IDDM_TrinhDo;
dr[pDM_MonHocInfo.strIDDM_Nganh] = pDM_MonHocInfo.IDDM_Nganh;
dr[pDM_MonHocInfo.strIDDM_ChuyenNganh] = pDM_MonHocInfo.IDDM_ChuyenNganh;
dr[pDM_MonHocInfo.strIDDM_BoMon] = pDM_MonHocInfo.IDDM_BoMon;
dr[pDM_MonHocInfo.strIDDM_KhoiKienThuc] = pDM_MonHocInfo.IDDM_KhoiKienThuc;
dr[pDM_MonHocInfo.strIDDM_HinhThucThi] = pDM_MonHocInfo.IDDM_HinhThucThi;
dr[pDM_MonHocInfo.strMoTa] = pDM_MonHocInfo.MoTa;
dr[pDM_MonHocInfo.strTinhDiemToanKhoa] = pDM_MonHocInfo.TinhDiemToanKhoa;
}
public void Delete(DM_MonHocInfo pDM_MonHocInfo)
{
oDDM_MonHoc.Delete(pDM_MonHocInfo);
mErrorMessage = oDDM_MonHoc.ErrorMessages;
mErrorNumber = oDDM_MonHoc.ErrorNumber;
}
public DataTable Get(DM_MonHocInfo pDM_MonHocInfo)
{
return(oDDM_MonHoc.Get(pDM_MonHocInfo));
}
