public bool luuBMDG(BieuMauDanhGia bmdg) { try { dc.BieuMauDanhGias.InsertOnSubmit(bmdg); return(true); } catch { return(false); } }
protected void Page_PreRender(object sender, EventArgs e) { this.LoadNhanVien(); #region enable linkbutton luu int maCK = 0; int.TryParse(ddlChuKyDG.SelectedValue, out maCK); BieuMauDanhGia bm = kho.TimBieuMau(maCK, this.NhanVien.MaVTCV); if (bm != default(BieuMauDanhGia)) {//hay viet lai cho phu hop voi CSDL moi. //var kqDG = kho.TimKQDG(this.NhanVien.MaNV, // ddlNhanSu.SelectedValue, bm.MaBM); //var status = (kqDG == default(KetQuaDanhGia)); //lbtnLuu.Visible = status; } #endregion }
protected void btnLuuBM_Click(object sender, EventArgs e) { string tenVN = string.Empty; string tenEN = string.Empty; if (!MyUtility.TextBoxHopLe(txtTenBM, out tenVN)) { lblThongBao.Text = "Tên không được bỏ trống!"; return; } BieuMauDanhGia bmdg = new BieuMauDanhGia() { //MaBM = 5, TenBM = tenVN, TenBMEN = tenEN, MaVTCV = int.Parse(ddlVTCV.SelectedValue), MaDV = 1 }; try { bmdg.MaBM = int.Parse(hdfMaBM.Value); if (!kho.luuBMDG(bmdg) || !kho.Luu()) { lblThongBao.Text = "Lỗi thêm dữ liệu!"; return; } } catch { if (!kho.luuBMDG(bmdg) || !kho.Luu()) { lblThongBao.Text = "Lỗi thêm dữ liệu!"; return; } } Response.Redirect("~/Admin/QLBieuMau.aspx"); }
protected void btnLuu_Click(object sender, EventArgs e) {//cần kiểm tra lại cho phù hợp với CSDL mới. int maCK = int.Parse(ddlChuKyDG.SelectedValue); BieuMauDanhGia bm = kho.TimBieuMau(maCK, this.NhanVien.MaVTCV); if (bm == default(BieuMauDanhGia)) { return; } //luu ket qua danh gia: KetQuaDanhGia kq = new KetQuaDanhGia() { MaBM = bm.MaBM, NgayDG = DateTime.Today, NguoiDG = this.NhanVien.MaNV, NguoiDuocDG = ddlNhanSu.SelectedValue, HienThi = true, CoHieuLuc = true }; if (!kho.ThemKetQuaDanhGia(kq) || !kho.Luu()) { lblThongBao.Text = ThongBao.ThemKhongThanhCong; return; } //luu chi tiet ket qua danh gia: List <ChiTietDanhGia> lstCTDG = new List <ChiTietDanhGia>(); #region lap theo nhom tieu chi //foreach (ListViewDataItem item in lvNTC.Items) //{ // ListView lvTCCha = item.FindControl("lvTC") as ListView; // foreach (ListViewDataItem i in lvTCCha.Items) // { // RadioButtonList rbl = i.FindControl("rblMucTC") as RadioButtonList; // HiddenField hdfCha = i.FindControl("hdfMaTC") as HiddenField; // if (rbl.Items.Count > 0) // { // MucTrongTieuChi muc = kho.TimMucTrongTC(int.Parse(rbl.SelectedValue)); // TieuChiTheoBieuMau tctbm = kho.TimTCTBM(bm.MaBM, int.Parse(hdfCha.Value)); // ChiTietDanhGia ct = new ChiTietDanhGia() // { // MaKQDG = kq.MaKQDG, // MaMucTC = muc.MaMuc, // MaTCTheoBM = tctbm.Ma, // TongDiem = muc.GiaTri * tctbm.TrongSo, // MaTC = tctbm.MaTC, // MaTCCha = tctbm.TieuChi.MaTCCha, // MaNhomTC = tctbm.TieuChi.MaNTC // }; // lstCTDG.Add(ct); // } // //tim listview tieu chi con: // ListView lvTCCon = i.FindControl("lvTCCon") as ListView; // foreach (ListViewDataItem j in lvTCCon.Items) // { // RadioButtonList rblCon = j.FindControl("rblMucTC") as RadioButtonList; // HiddenField hdfCon = j.FindControl("hdfMaTC") as HiddenField; // if (rblCon.Items.Count > 0) // { // MucTrongTieuChi muc = kho.TimMucTrongTC(int.Parse(rblCon.SelectedValue)); // TieuChiTheoBieuMau tctbm = kho.TimTCTBM(bm.MaBM, int.Parse(hdfCon.Value)); // ChiTietDanhGia ctCon = new ChiTietDanhGia() // { // MaKQDG = kq.MaKQDG, // MaMucTC = muc.MaMuc, // MaTCTheoBM = tctbm.Ma, // TongDiem = muc.GiaTri * tctbm.TrongSo, // MaTC = tctbm.MaTC, // MaTCCha = tctbm.TieuChi.MaTCCha, // MaNhomTC = tctbm.TieuChi.MaNTC // }; // lstCTDG.Add(ctCon); // } // } // } //} #endregion //if (!kho.ThemChiTietDanhGia(lstCTDG) || !kho.Luu()) //{ // lblThongBao.Text = ThongBao.ThemKhongThanhCong; // return; //} ////voi moi tieu chi con trong ChiTietDanhGia, insert 1 record cho tieu chi cha: //lstCTDG = lstCTDG.Where(x => x.MaTCCha != null).ToList(); //var temp = lstCTDG.GroupBy(x => new { x.MaKQDG, x.MaTCCha, x.MaNhomTC }).Select(x => new //{ // MaTC = x.Key.MaTCCha, // MaKQDG = x.Key.MaKQDG, // MaNhomTC = x.Key.MaNhomTC, // TongDiem = x.Sum(t => t.TongDiem), // MaTCTheoBM = kho.TimTCTBM(bm.MaBM, (int)(x.Key.MaTCCha)).Ma //}); //List<ChiTietDanhGia> dsTCCha = new List<ChiTietDanhGia>(); //foreach (var item in temp) // dsTCCha.Add(new ChiTietDanhGia() // { // MaTCTheoBM = item.MaTCTheoBM, // MaMucTC = null, // MaKQDG = item.MaKQDG, // TongDiem = item.TongDiem * kho.TimTieuChi((int)item.MaTC).TrongSo / 100, // MaTC = (int)item.MaTC, // MaTCCha = null, // MaNhomTC = item.MaNhomTC // }); //if (!kho.ThemChiTietDanhGia(dsTCCha) || !kho.Luu()) //{ // lblThongBao.Text = ThongBao.ThemKhongThanhCong; // return; //} //lblThongBao.Text = ThongBao.ThanhCong; }
private void LoadBieuMau(string maNV, int maCK) {//load cac tieu chi cua bieu mau phu hop voi chu ky va nhan vien => listview: //load nhom tieu chi: lvNTC.DataSource = kho.TimNhomTieuChiTheoMaDV(this.MaDV); lvNTC.DataBind(); BieuMauDanhGia bm = kho.TimBieuMau(maCK, this.NhanVien.MaVTCV); divTenBM.InnerHtml = "Biểu mẫu đánh giá: " + (bm == null ? string.Empty : bm.TenBM); if (bm != default(BieuMauDanhGia)) { //load tieu chi tuong ung theo nhom: foreach (ListViewDataItem item in lvNTC.Items) { HiddenField hdf = item.FindControl("hdfMaNTC") as HiddenField; int maNTC = 0; int.TryParse(hdf.Value, out maNTC); ListView lvTC = item.FindControl("lvTC") as ListView; lvTC.DataSource = kho.LayTCTheoBMVaNTC(bm.MaBM, maNTC).Where(t => t.MaTCCha == null).ToList(); lvTC.DataBind(); foreach (ListViewDataItem i in lvTC.Items)//voi moi tieu chi cha. { HiddenField hdfTC = i.FindControl("hdfMaTC") as HiddenField; int maTC = int.Parse(hdfTC.Value); //voi moi tieu chi, load danh sach cac muc tieu chi tuong ung: RadioButtonList rbl = i.FindControl("rblMucTC") as RadioButtonList; List <CapDoTheoTieuChi> dsCapDoTheoTC = kho.LayDSCapDoTheoTieuChi(maTC).ToList(); if (dsCapDoTheoTC.Count > 0) { rbl.DataSource = dsCapDoTheoTC; rbl.DataTextField = MyUtility.TiengViet ? "Ten" : "TenEN"; rbl.DataValueField = "Ma"; rbl.DataBind(); //debug cho nhanh: rbl.Items[0].Selected = true; } //voi moi tieu chi cha, load danh sach cac tieu chi con tuong ung: ListView lvTCCon = i.FindControl("lvTCCon") as ListView; lvTCCon.DataSource = kho.LayTCTheoBMVaTCCha(bm.MaBM, maTC); lvTCCon.DataBind(); foreach (ListViewDataItem j in lvTCCon.Items) { //voi moi tieu chi con, load danh sach cac muc tieu chi tuong ung: HiddenField subHDFTC = j.FindControl("hdfMaTC") as HiddenField; int ma = int.Parse(subHDFTC.Value); RadioButtonList rblCon = j.FindControl("rblMucTC") as RadioButtonList; List <CapDoTheoTieuChi> lst = kho.LayDSCapDoTheoTieuChi(ma).ToList(); if (lst.Count > 0) { rblCon.DataSource = lst; rblCon.DataTextField = MyUtility.TiengViet ? "Ten" : "TenEN"; rblCon.DataValueField = "Ma"; rblCon.DataBind(); //debug cho nhanh: rblCon.Items[0].Selected = true; } } } } } }