コード例 #1
0
        protected override void DeleteRow()
        {
            try
            {
                DeleteRowGrid(dgv_DanhSach, "ID", "TenPhong");
                if (IdDelete.Count <= 0) return;
                foreach (var i in IdDelete)
                {
                    var xp = new XepPhong
                    {
                        IdKyThi = _idkythi,
                        IdPhong = i
                    };

                    var ktp = new KTPhong
                    {
                        IdKyThi = _idkythi,
                        IdPhong = i
                    };
                    _listXepPhong.Add(xp);
                    _listKtPhong.Add(ktp);
                }
                DeleteData.XoaKtPhong(_listKtPhong);
                UpdateData.UpdateXepPhongNull(_listXepPhong);
                MessageBox.Show(FormResource.MsgThongbaothanhcong, FormResource.MsgCaption, MessageBoxButtons.OK,
                    MessageBoxIcon.Information);
                LoadGrid();
                IdDelete.Clear();
            }
            catch (Exception ex)
            {
                Log2File.LogExceptionToFile(ex);
            }
        }
コード例 #2
0
 /// <summary>
 /// Lưu 1 phòng được sử dụng trong kỳ thi
 /// </summary>
 /// <param name="item"></param>
 /// <returns></returns>
 public static bool KtPhong(KTPhong item)
 {
     try
     {
         Conn.ExcuteQuerySql("insert into KT_PHONG(IdKyThi,IdPhong,SiSo) values(" + item.IdKyThi + "," + item.IdPhong +
                             "," + item.SiSo + ")");
         return true;
     }
     catch (Exception ex)
     {
         Log2File.LogExceptionToFile(ex);
         return false;
     }
 }
コード例 #3
0
        private void button2_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(cboPhongthi.Text))
            {
                errorPhongthi.SetError(cboPhongthi, "Chọn Phòng thi");
                return;
            }
            if (bUpdate)
            {
                var hs = new XepPhong
                {
                    IdSV = int.Parse(txtmasinhvien.Text),
                    IdPhong = int.Parse(cboPhongthi.Value.ToString()),
                    IdKyThi = IdKythi
                };
                UpdateData.UpdateXepPhong(hs);
                UpdateData.UpdateKtPhong(hs.IdPhong, IdPhong, IdKythi);
                bUpdate = false;
                Close();
            }
            else
            {
                var a = cboPhongthi.Value;
                if (a == null) return;
                var hsxp = new XepPhong
                {
                    IdKyThi = IdKythi,
                    IdPhong = (int)a,
                    IdSV = int.Parse(txtmasinhvien.Text),
                };

                var hspp = new KTPhong
                {
                    IdKyThi = IdKythi,
                    IdPhong = (int)a,
                    SiSo = 1
                };
                UpdateData.UpdateXepPhong(hsxp);
                UpdateData.UpdateTangSiSo(hspp.IdPhong, hspp.IdKyThi);
                bUpdate = true;
                Close();
            }
        }
コード例 #4
0
 protected override void DeleteRow()
 {
     try
     {
         bool xoa = false;
         if (dgv_DanhSach.Selected.Rows.Count > 0)
         {
             if (DialogResult.Yes ==
                 MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo,
                     MessageBoxIcon.Question))
             {
                 foreach (var row in dgv_DanhSach.Selected.Rows)
                 {
                     var masv = row.Cells["MaSV"].Text;
                     var idPhong = row.Cells["IdPhong"].Text;
                     if (!string.IsNullOrEmpty(idPhong))
                     {
                         var ktp = new KTPhong
                         {
                             IdKyThi = _idkythi,
                             IdPhong = int.Parse(idPhong)
                         };
                         _listKtPhong.Add(ktp);
                     }
                     var xp = new XepPhong
                     {
                         IdKyThi = _idkythi,
                         IdSV = int.Parse(masv)
                     };
                     _listXepPhong.Add(xp);
                 }
                 DeleteAndUpdate = true;
                 dgv_DanhSach.DeleteSelectedRows(false);
                 xoa = true;
             }
         }
         else if (dgv_DanhSach.ActiveRow != null)
         {
             if (DialogResult.Yes ==
                 MessageBox.Show(FormResource.msgHoixoa, FormResource.MsgCaption, MessageBoxButtons.YesNo,
                     MessageBoxIcon.Question))
             {
                 var masv = dgv_DanhSach.ActiveRow.Cells["MaSV"].Text;
                 var idPhong = dgv_DanhSach.ActiveRow.Cells["IdPhong"].Text;
                 if (!string.IsNullOrEmpty(idPhong))
                 {
                     var ktp = new KTPhong
                     {
                         IdKyThi = _idkythi,
                         IdPhong = int.Parse(idPhong)
                     };
                     _listKtPhong.Add(ktp);
                 }
                 var xp = new XepPhong
                 {
                     IdKyThi = _idkythi,
                     IdSV = int.Parse(masv)
                 };
                 _listXepPhong.Add(xp);
                 DeleteAndUpdate = true;
                 dgv_DanhSach.ActiveRow.Delete(false);
                 xoa = true;
             }
         }
         UpdateData.UpdateGiamSiSo(_listKtPhong);
         DeleteData.XoaXepPhong(_listXepPhong);
         if (xoa)
         {
             MessageBox.Show(@"Xóa dữ liệu thành công.", @"Thông báo");
         }
         LoadGrid();
     }
     catch (Exception ex)
     {
         Log2File.LogExceptionToFile(ex);
     }
 }
コード例 #5
0
ファイル: UpdateData.cs プロジェクト: tungph80/TTMWeb
 /// <summary>
 /// sửa lại SiSo trong bảng KT_PHONG khi xếp phòng xong
 /// </summary>
 /// <param name="item"></param>
 /// <returns></returns>
 private static void UpdateKtPhong(KTPhong item)
 {
     try
     {
         Conn.ExcuteQuerySql("update KT_PHONG set SiSo = " + item.SiSo + " where IdPhong = " + item.IdPhong +
                             " and IdKyThi =" + item.IdKyThi + "");
     }
     catch (Exception ex)
     {
         Log2File.LogExceptionToFile(ex);
     }
 }
コード例 #6
0
 /// <summary>
 /// xóa bảng KT_PHONG theo kỳ thi và mã phòng
 /// </summary>
 private static void XoaKtPhong(KTPhong item)
 {
     try
     {
         Conn.ExcuteQuerySql("DELETE FROM KT_PHONG WHERE IdKyThi = " + item.IdKyThi + " and IdPhong = " + item.IdPhong + "");
     }
     catch (Exception ex)
     {
         Log2File.LogExceptionToFile(ex);
     }
 }