Пример #1
0
        private void btnCapNhat_Click(object sender, EventArgs e)
        {
            // Nếu MonKy có dữ liệu thì insert hoặc Update, nếu không có thì xóa hết.
            if (dtMonKy != null)
            {
                try
                {
                    if (dtMonKy.Rows.Count > 0)
                    {
                        string MonHocNotIn = "";
                        foreach (DataRow dr in dtMonKy.Rows)
                        {
                            pXL_MonHocTrongKyInfo                     = new XL_MonHocTrongKyInfo();
                            pXL_MonHocTrongKyInfo.IDDM_Lop            = IDDM_Lop;
                            pXL_MonHocTrongKyInfo.IDKQHT_CTDT_ChiTiet = int.Parse(dr["IDKQHT_CTDT_ChiTiet"].ToString());
                            pXL_MonHocTrongKyInfo.IDDM_NamHoc         = Program.IDNamHoc;
                            pXL_MonHocTrongKyInfo.HocKy               = Program.HocKy;
                            pXL_MonHocTrongKyInfo.IDDM_HinhThucThi    = int.Parse(dr["IDDM_HinhThucThi"].ToString());
                            pXL_MonHocTrongKyInfo.SoHocTrinh          = float.Parse("0" + dr["SoHocTrinh"]);
                            pXL_MonHocTrongKyInfo.LyThuyet            = int.Parse("0" + dr["LyThuyet"]);
                            pXL_MonHocTrongKyInfo.ThucHanh            = int.Parse("0" + dr["ThucHanh"]);
                            pXL_MonHocTrongKyInfo.SoTiet              = pXL_MonHocTrongKyInfo.LyThuyet + pXL_MonHocTrongKyInfo.ThucHanh;
                            pXL_MonHocTrongKyInfo.ChoPhepXepLich      = bool.Parse(dr["ChoPhepXepLich"].ToString());
                            pXL_MonHocTrongKyInfo.TinhDiemToanKhoa    = bool.Parse(dr["TinhDiemToanKhoa"].ToString());
                            pXL_MonHocTrongKyInfo.HocOLopTachGop      = false;

                            MonHocNotIn += pXL_MonHocTrongKyInfo.IDKQHT_CTDT_ChiTiet.ToString() + ",";
                            if (int.Parse(dr["XL_MonHocTrongKyID"].ToString()) > 0)
                            {
                                pXL_MonHocTrongKyInfo.XL_MonHocTrongKyID = int.Parse(dr["XL_MonHocTrongKyID"].ToString());
                                oBXL_MonHocTrongKy.Update(pXL_MonHocTrongKyInfo);
                            }
                            else
                            {
                                dr["XL_MonHocTrongKyID"] = oBXL_MonHocTrongKy.Add(pXL_MonHocTrongKyInfo);
                            }
                        }
                        MonHocNotIn = MonHocNotIn.Substring(0, MonHocNotIn.Length - 1);

                        oBXL_MonHocTrongKy.DeleteMonHocNotIn(IDDM_Lop, Program.IDNamHoc, Program.HocKy, MonHocNotIn);
                    }
                    else
                    {
                        oBXL_MonHocTrongKy.DeleteByHocKyNamHoc(IDDM_Lop, Program.IDNamHoc, Program.HocKy);
                    }
                    // ghi log
                    GhiLog("Cập nhật thay đổi môn học trong kỳ của lớp '" + pDM_LopInfo.TenLop + "'", "Cập nhật", this.Tag.ToString());
                    LoadMonKy(IDDM_Lop);
                    cmbKyKhung_SelectedValueChanged(null, null);
                    if (e != null)
                    {
                        ThongBao("Thay đổi thành công.");
                    }
                }
                catch
                {
                    ThongBaoLoi("Có thể một số môn học của lớp này đã phân công giáo viên.");
                }
            }
        }
Пример #2
0
        public List <XL_MonHocTrongKyInfo> GetList(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
        {
            List <XL_MonHocTrongKyInfo> oXL_MonHocTrongKyInfoList = new List <XL_MonHocTrongKyInfo>();
            DataTable dtb = Get(pXL_MonHocTrongKyInfo);

            if (dtb != null)
            {
                for (int i = 0; i < dtb.Rows.Count; i++)
                {
                    oXL_MonHocTrongKyInfo = new XL_MonHocTrongKyInfo();

                    oXL_MonHocTrongKyInfo.XL_MonHocTrongKyID  = int.Parse(dtb.Rows[i]["XL_MonHocTrongKyID"].ToString());
                    oXL_MonHocTrongKyInfo.IDKQHT_CTDT_ChiTiet = int.Parse(dtb.Rows[i]["IDKQHT_CTDT_ChiTiet"].ToString());
                    oXL_MonHocTrongKyInfo.IDDM_Lop            = int.Parse(dtb.Rows[i]["IDDM_Lop"].ToString());
                    oXL_MonHocTrongKyInfo.HocKy            = int.Parse(dtb.Rows[i]["HocKy"].ToString());
                    oXL_MonHocTrongKyInfo.IDDM_NamHoc      = int.Parse(dtb.Rows[i]["IDDM_NamHoc"].ToString());
                    oXL_MonHocTrongKyInfo.SoTiet           = int.Parse(dtb.Rows[i]["SoTiet"].ToString());
                    oXL_MonHocTrongKyInfo.LyThuyet         = int.Parse(dtb.Rows[i]["LyThuyet"].ToString());
                    oXL_MonHocTrongKyInfo.ThucHanh         = int.Parse(dtb.Rows[i]["ThucHanh"].ToString());
                    oXL_MonHocTrongKyInfo.LoaiTietKhac1    = int.Parse(dtb.Rows[i]["LoaiTietKhac1"].ToString());
                    oXL_MonHocTrongKyInfo.LoaiTietKhac2    = int.Parse(dtb.Rows[i]["LoaiTietKhac2"].ToString());
                    oXL_MonHocTrongKyInfo.SoHocTrinh       = double.Parse(dtb.Rows[i]["SoHocTrinh"].ToString());
                    oXL_MonHocTrongKyInfo.ChoPhepXepLich   = bool.Parse(dtb.Rows[i]["ChoPhepXepLich"].ToString());
                    oXL_MonHocTrongKyInfo.IDDM_HinhThucThi = int.Parse(dtb.Rows[i]["IDDM_HinhThucThi"].ToString());
                    oXL_MonHocTrongKyInfo.SapXep           = int.Parse(dtb.Rows[i]["SapXep"].ToString());

                    oXL_MonHocTrongKyInfoList.Add(oXL_MonHocTrongKyInfo);
                }
            }
            return(oXL_MonHocTrongKyInfoList);
        }
Пример #3
0
 public DataTable Get(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
 {
     using (var client = new UnimOsServiceClient())
     {
         return(ConvertList.ToDataTable <sp_XL_MonHocTrongKy_GetResult>(client.cDXL_MonHocTrongKy_Get(GlobalVar.MaXacThuc, pXL_MonHocTrongKyInfo)));
     }
 }
Пример #4
0
        public void Delete(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@XL_MonHocTrongKyID", SqlDbType.Int, pXL_MonHocTrongKyInfo.XL_MonHocTrongKyID));

            RunProcedure("sp_XL_MonHocTrongKy_Delete", colParam);
        }
Пример #5
0
        public DataTable Get(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@XL_MonHocTrongKyID", SqlDbType.Int, pXL_MonHocTrongKyInfo.XL_MonHocTrongKyID));

            return(RunProcedureGet("sp_XL_MonHocTrongKy_Get", colParam));
        }
Пример #6
0
        public int Add(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
        {
            int ID = 0;

            ID            = oDXL_MonHocTrongKy.Add(pXL_MonHocTrongKyInfo);
            mErrorMessage = oDXL_MonHocTrongKy.ErrorMessages;
            mErrorNumber  = oDXL_MonHocTrongKy.ErrorNumber;
            return(ID);
        }
Пример #7
0
        public void Delete(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
        {
            var client = new UnimOsServiceClient();

            client.cDXL_MonHocTrongKy_Delete(GlobalVar.MaXacThuc, pXL_MonHocTrongKyInfo);
            client.Close();
            mErrorMessage = oDXL_MonHocTrongKy.ErrorMessages;
            mErrorNumber  = oDXL_MonHocTrongKy.ErrorNumber;
        }
Пример #8
0
        public int Add(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
        {
            int ID     = 0;
            var client = new UnimOsServiceClient();

            ID = client.cDXL_MonHocTrongKy_Add(GlobalVar.MaXacThuc, pXL_MonHocTrongKyInfo);
            client.Close();
            mErrorMessage = oDXL_MonHocTrongKy.ErrorMessages;
            mErrorNumber  = oDXL_MonHocTrongKy.ErrorNumber;
            return(ID);
        }
Пример #9
0
 public void ToDataRow(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo, ref DataRow dr)
 {
     dr[pXL_MonHocTrongKyInfo.strXL_MonHocTrongKyID]  = pXL_MonHocTrongKyInfo.XL_MonHocTrongKyID;
     dr[pXL_MonHocTrongKyInfo.strIDKQHT_CTDT_ChiTiet] = pXL_MonHocTrongKyInfo.IDKQHT_CTDT_ChiTiet;
     dr[pXL_MonHocTrongKyInfo.strIDDM_Lop]            = pXL_MonHocTrongKyInfo.IDDM_Lop;
     dr[pXL_MonHocTrongKyInfo.strHocKy]            = pXL_MonHocTrongKyInfo.HocKy;
     dr[pXL_MonHocTrongKyInfo.strIDDM_NamHoc]      = pXL_MonHocTrongKyInfo.IDDM_NamHoc;
     dr[pXL_MonHocTrongKyInfo.strSoTiet]           = pXL_MonHocTrongKyInfo.SoTiet;
     dr[pXL_MonHocTrongKyInfo.strLyThuyet]         = pXL_MonHocTrongKyInfo.LyThuyet;
     dr[pXL_MonHocTrongKyInfo.strThucHanh]         = pXL_MonHocTrongKyInfo.ThucHanh;
     dr[pXL_MonHocTrongKyInfo.strLoaiTietKhac1]    = pXL_MonHocTrongKyInfo.LoaiTietKhac1;
     dr[pXL_MonHocTrongKyInfo.strLoaiTietKhac2]    = pXL_MonHocTrongKyInfo.LoaiTietKhac2;
     dr[pXL_MonHocTrongKyInfo.strSoHocTrinh]       = pXL_MonHocTrongKyInfo.SoHocTrinh;
     dr[pXL_MonHocTrongKyInfo.strChoPhepXepLich]   = pXL_MonHocTrongKyInfo.ChoPhepXepLich;
     dr[pXL_MonHocTrongKyInfo.strIDDM_HinhThucThi] = pXL_MonHocTrongKyInfo.IDDM_HinhThucThi;
     dr[pXL_MonHocTrongKyInfo.strSapXep]           = pXL_MonHocTrongKyInfo.SapXep;
     dr[pXL_MonHocTrongKyInfo.strTinhDiemToanKhoa] = pXL_MonHocTrongKyInfo.TinhDiemToanKhoa;
 }
Пример #10
0
        public void Update(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
        {
            ArrayList colParam = new ArrayList();

            colParam.Add(CreateParam("@IDKQHT_CTDT_ChiTiet", SqlDbType.BigInt, pXL_MonHocTrongKyInfo.IDKQHT_CTDT_ChiTiet));
            colParam.Add(CreateParam("@IDDM_Lop", SqlDbType.Int, pXL_MonHocTrongKyInfo.IDDM_Lop));
            colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pXL_MonHocTrongKyInfo.HocKy));
            colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pXL_MonHocTrongKyInfo.IDDM_NamHoc));
            colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pXL_MonHocTrongKyInfo.SoTiet));
            colParam.Add(CreateParam("@LyThuyet", SqlDbType.Int, pXL_MonHocTrongKyInfo.LyThuyet));
            colParam.Add(CreateParam("@ThucHanh", SqlDbType.Int, pXL_MonHocTrongKyInfo.ThucHanh));
            colParam.Add(CreateParam("@LoaiTietKhac1", SqlDbType.Int, pXL_MonHocTrongKyInfo.LoaiTietKhac1));
            colParam.Add(CreateParam("@LoaiTietKhac2", SqlDbType.Int, pXL_MonHocTrongKyInfo.LoaiTietKhac2));
            colParam.Add(CreateParam("@SoHocTrinh", SqlDbType.Real, pXL_MonHocTrongKyInfo.SoHocTrinh));
            colParam.Add(CreateParam("@ChoPhepXepLich", SqlDbType.Bit, pXL_MonHocTrongKyInfo.ChoPhepXepLich));
            colParam.Add(CreateParam("@IDDM_HinhThucThi", SqlDbType.Int, pXL_MonHocTrongKyInfo.IDDM_HinhThucThi));
            colParam.Add(CreateParam("@HocOLopTachGop", SqlDbType.Bit, pXL_MonHocTrongKyInfo.HocOLopTachGop));
            colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pXL_MonHocTrongKyInfo.SapXep));
            colParam.Add(CreateParam("@TinhDiemToanKhoa", SqlDbType.Bit, pXL_MonHocTrongKyInfo.TinhDiemToanKhoa));
            colParam.Add(CreateParam("@XL_MonHocTrongKyID", SqlDbType.Int, pXL_MonHocTrongKyInfo.XL_MonHocTrongKyID));

            RunProcedure("sp_XL_MonHocTrongKy_Update", colParam);
        }
Пример #11
0
 public DataTable Get(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
 {
     return(oDXL_MonHocTrongKy.Get(pXL_MonHocTrongKyInfo));
 }
Пример #12
0
 public void Delete(XL_MonHocTrongKyInfo pXL_MonHocTrongKyInfo)
 {
     oDXL_MonHocTrongKy.Delete(pXL_MonHocTrongKyInfo);
     mErrorMessage = oDXL_MonHocTrongKy.ErrorMessages;
     mErrorNumber  = oDXL_MonHocTrongKy.ErrorNumber;
 }