public void loadData(List<ViTriHienThi> list, NhanVienPT nhanvien) { try { treeListPhong.BeginUnboundLoad(); treeListPhong.DataSource = list; treeListPhong.EndUnboundLoad(); List<Phong> _list = nhanvien.phongs.ToList(); foreach (Phong p in _list) { if (!p.id.Equals(Guid.Empty)) { TreeListNode node = treeListPhong.FindNodeByKeyID(p.id); if (node != null) { treeListPhong.SetNodeCheckState(node, CheckState.Checked, true); node.Selected = true; } } } if (treeListPhong.Nodes.Count > 0) treeListPhong.FocusedNode = treeListPhong.Nodes[0]; } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData: " + ex.Message); } }
public void loadData(List <ViTriHienThi> list, NhanVienPT nhanvien) { try { treeListPhong.BeginUnboundLoad(); treeListPhong.DataSource = list; treeListPhong.EndUnboundLoad(); List <Phong> _list = nhanvien.phongs.ToList(); foreach (Phong p in _list) { if (!p.id.Equals(Guid.Empty)) { TreeListNode node = treeListPhong.FindNodeByKeyID(p.id); if (node != null) { treeListPhong.SetNodeCheckState(node, CheckState.Checked, true); node.Selected = true; } } } if (treeListPhong.Nodes.Count > 0) { treeListPhong.FocusedNode = treeListPhong.Nodes[0]; } } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData: " + ex.Message); } }
public void LoadData() { _ucCollectionPager_DanhSachPhong.CollectionPager_Object.QueryStringKey = "PageRoom"; listNhanVienPT = NhanVienPT.getQuery().OrderBy(c => c.hoten).ToList(); if (listNhanVienPT.Count > 0) { SearchFunction(); if (Request.QueryString["id"] != null) { Guid id = Guid.Empty; try { id = GUID.From(Request.QueryString["id"]); } catch { Response.Redirect(Request.Url.AbsolutePath); } objNhanVienPT = NhanVienPT.getById(id); if (objNhanVienPT != null) { PanelThongTinNhanVienPhuTrach.Visible = true; Label_MaNhanVien.Text = objNhanVienPT.subId; _ucNhanVien_BreadCrumb.Label_TenNhanVien.Text = Label_HoTen.Text = objNhanVienPT.hoten; Label_SoDienThoai.Text = objNhanVienPT.sodienthoai; Libraries.ImageHelper.LoadImageWeb(objNhanVienPT.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object); List <PTB.Entities.Phong> ListPhong = objNhanVienPT.phongs.ToList(); var list = ListPhong.Select(a => new { id = a.id, ten = string.Format("{0}{1}", a.ten, !Object.Equals(getVitri(a), "") ? " " + getVitri(a) : ""), url = string.Format("http://{0}/Phong.aspx?Search={1}", HttpContext.Current.Request.Url.Authority, a.id.ToString()) }).ToList(); _ucCollectionPager_DanhSachPhong.CollectionPager_Object.DataSource = list; _ucCollectionPager_DanhSachPhong.CollectionPager_Object.BindToControl = RepeaterDanhSachPhong; RepeaterDanhSachPhong.DataSource = _ucCollectionPager_DanhSachPhong.CollectionPager_Object.DataSourcePaged; RepeaterDanhSachPhong.DataBind(); } else { Response.Redirect(Request.Url.AbsolutePath); } } else { PanelDanhSachNhanVienPhuTrach.Visible = true; BindData(); } } else { ucThongBaoLoi.Panel_ThongBaoLoi.Visible = true; ucThongBaoLoi.Label_ThongBaoLoi.Text = "Chưa có nhân viên"; } }
public void LoadData() { _ucCollectionPager_DanhSachPhong.CollectionPager_Object.QueryStringKey = "PageRoom"; listNhanVienPT = NhanVienPT.getQuery().OrderBy(c => c.hoten).ToList(); if (listNhanVienPT.Count > 0) { SearchFunction(); if (Request.QueryString["id"] != null) { Guid id = Guid.Empty; try { id = GUID.From(Request.QueryString["id"]); } catch { Response.Redirect(Request.Url.AbsolutePath); } objNhanVienPT = NhanVienPT.getById(id); if (objNhanVienPT != null) { PanelThongTinNhanVienPhuTrach.Visible = true; Label_MaNhanVien.Text = objNhanVienPT.subId; _ucNhanVien_BreadCrumb.Label_TenNhanVien.Text = Label_HoTen.Text = objNhanVienPT.hoten; Label_SoDienThoai.Text = objNhanVienPT.sodienthoai; Libraries.ImageHelper.LoadImageWeb(objNhanVienPT.hinhanhs.ToList(), _ucASPxImageSlider_Mobile.ASPxImageSlider_Object); List<PTB.Entities.Phong> ListPhong = objNhanVienPT.phongs.ToList(); var list = ListPhong.Select(a => new { id = a.id, ten = string.Format("{0}{1}", a.ten, !Object.Equals(getVitri(a), "") ? " " + getVitri(a) : ""), url = string.Format("http://{0}/Phong.aspx?Search={1}", HttpContext.Current.Request.Url.Authority, a.id.ToString()) }).ToList(); _ucCollectionPager_DanhSachPhong.CollectionPager_Object.DataSource = list; _ucCollectionPager_DanhSachPhong.CollectionPager_Object.BindToControl = RepeaterDanhSachPhong; RepeaterDanhSachPhong.DataSource = _ucCollectionPager_DanhSachPhong.CollectionPager_Object.DataSourcePaged; RepeaterDanhSachPhong.DataBind(); } else { Response.Redirect(Request.Url.AbsolutePath); } } else { PanelDanhSachNhanVienPhuTrach.Visible = true; BindData(); } } else { ucThongBaoLoi.Panel_ThongBaoLoi.Visible = true; ucThongBaoLoi.Label_ThongBaoLoi.Text = "Chưa có nhân viên"; } }
private void button1_Click(object sender, EventArgs e) { XtraReport1 report = new XtraReport1(); //// Add bounded labels to the Detail band of the report. report._bindData(); report._group(); report.DataSource = NhanVienPT.getAll(); ReportPrintTool printTool = new ReportPrintTool(report); printTool.ShowRibbonPreview(); }
private void getThongTinPhong(Boolean first) { if (listPhong.Count() > 0) { int row = 0; if (!first) { row = gridViewPhong.FocusedRowHandle; } if (row >= 0 && row < listPhong.Count()) { //int id = (gridViewPhong.GetRow(row) as Phong).id; //objPhong = Phong.getById(id); objPhong = gridViewPhong.GetRowCellValue(row, colphong) as Phong; if (objPhong != null) { if (objPhong.nhanvienpt != null) { objNhanVienPT = objPhong.nhanvienpt; //objNhanVienPT = NhanVienPT.getById(objPhong.nhanvienpt.id); } setData(); enableBar(true); } } else { deleteData(); enableBar(false); } } else { deleteData(); enableBar(false); } rbnGroupPhong.Enabled = true; barButtonThemPhong.Enabled = true && canAdd; btnR_Them.Enabled = true && canAdd; enableEdit(false); function = ""; }
public void loadData() { try { checkPermission(); editGUI("view"); layout.load(gridViewNhanVien); NhanVienPTs = NhanVienPT.getQuery().OrderBy(c => c.hoten).ToList(); gridControlNhanVien.DataSource = NhanVienPTs; if (NhanVienPTs.Count == 0) { enableButton(false); barBtnThemNhanVien.Enabled = true; } } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData: " + ex.Message); } }
private void setDataView() { try { dxErrorProvider1.ClearErrors(); if (!function.Equals("view")) { editGUI("view"); } if (gridViewNhanVien.RowCount > 0) { if (gridViewNhanVien.FocusedRowHandle > -1 && gridViewNhanVien.GetFocusedRow() != null) { objNhanVienPT = gridViewNhanVien.GetFocusedRow() as NhanVienPT; txtMa.Text = objNhanVienPT.subId; txtTen.Text = objNhanVienPT.hoten; txtSodt.Text = objNhanVienPT.sodienthoai; listPhong = objNhanVienPT.phongs.ToList(); listBoxPhong.DataSource = listPhong; listHinhs = objNhanVienPT.hinhanhs.ToList(); reloadImage(); } else { clearText(); objNhanVienPT = new NhanVienPT(); } } else { enableButton(false); barBtnThemNhanVien.Enabled = true && canAdd; clearText(); objNhanVienPT = new NhanVienPT(); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->setDataView: " + ex.Message); } }
// Load dữ liệu public void loadData() { try { //load layout layout.load(gridViewPhong); canAdd = Permission.canAdd <Phong>(); listVitris = ViTriHienThi.getAll().ToList(); _ucTreeViTri.loadData(listVitris); _ucComboBoxViTri.DataSource = listVitris; _ViTriHienTai = _ucTreeViTri.getVitri(); listPhong = PhongHienThi.getPhongByViTri(_ViTriHienTai.coso != null ? _ViTriHienTai.coso.id : Guid.Empty, _ViTriHienTai.day != null ? _ViTriHienTai.day.id : Guid.Empty, _ViTriHienTai.tang != null ? _ViTriHienTai.tang.id : Guid.Empty); gridControlPhong.DataSource = listPhong; if (listPhong.Count() == 0) { deleteData(); enableEdit(false); enableBar(false); } else { getThongTinPhong(true); enableEdit(false); enableBar(true); } listNhanVienPT = NhanVienPT.getAll(); NhanVienPT NhanVienPTNULL = new NhanVienPT(); NhanVienPTNULL.hoten = "[Không có]"; NhanVienPTNULL.id = Guid.Empty; listNhanVienPT.Insert(0, NhanVienPTNULL); searchLookUpEditNhanVienPT.Properties.DataSource = listNhanVienPT; } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData: " + ex.Message); } }
//Xóa hết dữ liệu form thông tin phòng + nhân viên private void deleteData() { setTextGroupControl("Chi tiết phòng", Color.Empty); function = ""; errorProvider1.Clear(); imgPhong.Images.Clear(); listHinhAnhPhong = new List <HinhAnh>(); txtMaPhong.Text = ""; txtTenPhong.Text = ""; txtMoTaPhong.Text = ""; if (listVitris.Count > 0) { _ucComboBoxViTri.ViTri = _ViTriHienTai; } searchLookUpEditNhanVienPT.EditValue = -1; objNhanVienPT = null; imgNhanVien.Images.Clear(); listHinhAnhNhanVien = null; txtMaNhanVien.Text = ""; txtTenNhanVien.Text = ""; txtSoDienThoai.Text = ""; }
private void searchLookUpEditNhanVienPT_EditValueChanged(object sender, EventArgs e) { try { if (searchLookUpEditNhanVienPT.EditValue != null && !searchLookUpEditNhanVienPT.EditValue.Equals(-1)) { Guid id = GUID.From(searchLookUpEditNhanVienPT.EditValue); if (id != Guid.Empty) { objNhanVienPT = NhanVienPT.getById(id); } else { objNhanVienPT = null; } if (objNhanVienPT != null) { txtMaNhanVien.Text = objNhanVienPT.subId; txtTenNhanVien.Text = objNhanVienPT.hoten; txtSoDienThoai.Text = objNhanVienPT.sodienthoai; listHinhAnhNhanVien = objNhanVienPT.hinhanhs.ToList(); reloadImageNhanVienPT(); } else { imgNhanVien.Images.Clear(); txtMaNhanVien.Text = ""; txtTenNhanVien.Text = ""; txtSoDienThoai.Text = ""; } } } catch (Exception ex) { System.Console.WriteLine(this.Name + ": " + ex.Message); } }
//Xóa hết dữ liệu form thông tin phòng + nhân viên private void deleteData() { setTextGroupControl("Chi tiết phòng", Color.Empty); function = ""; errorProvider1.Clear(); imgPhong.Images.Clear(); listHinhAnhPhong = new List<HinhAnh>(); txtMaPhong.Text = ""; txtTenPhong.Text = ""; txtMoTaPhong.Text = ""; if (listVitris.Count > 0) _ucComboBoxViTri.ViTri = _ViTriHienTai; searchLookUpEditNhanVienPT.EditValue = -1; objNhanVienPT = null; imgNhanVien.Images.Clear(); listHinhAnhNhanVien = null; txtMaNhanVien.Text = ""; txtTenNhanVien.Text = ""; txtSoDienThoai.Text = ""; }
// Load dữ liệu public void loadData() { try { //load layout layout.load(gridViewPhong); canAdd = Permission.canAdd<Phong>(); listVitris = ViTriHienThi.getAll().ToList(); _ucTreeViTri.loadData(listVitris); _ucComboBoxViTri.DataSource = listVitris; _ViTriHienTai = _ucTreeViTri.getVitri(); listPhong = PhongHienThi.getPhongByViTri(_ViTriHienTai.coso != null ? _ViTriHienTai.coso.id : Guid.Empty, _ViTriHienTai.day != null ? _ViTriHienTai.day.id : Guid.Empty, _ViTriHienTai.tang != null ? _ViTriHienTai.tang.id : Guid.Empty); gridControlPhong.DataSource = listPhong; if (listPhong.Count() == 0) { deleteData(); enableEdit(false); enableBar(false); } else { getThongTinPhong(true); enableEdit(false); enableBar(true); } listNhanVienPT = NhanVienPT.getAll(); NhanVienPT NhanVienPTNULL = new NhanVienPT(); NhanVienPTNULL.hoten = "[Không có]"; NhanVienPTNULL.id = Guid.Empty; listNhanVienPT.Insert(0, NhanVienPTNULL); searchLookUpEditNhanVienPT.Properties.DataSource = listNhanVienPT; } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData: " + ex.Message); } }
private void Function(String _function) { try { if (_function.Equals("edit")) { objNhanVienPT.subId = txtMa.Text; objNhanVienPT.hoten = txtTen.Text; objNhanVienPT.sodienthoai = txtSodt.Text; objNhanVienPT.hinhanhs = listHinhs; if (objNhanVienPT.update() > 0 && DBInstance.commit() > 0) { XtraMessageBox.Show("Sửa nhân viên thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); //reLoad(); reLoadAndFocused(objNhanVienPT.id); } else { XtraMessageBox.Show("Sửa nhân viên không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (_function.Equals("add")) { NhanVienPT objNew = new NhanVienPT(); objNew.subId = txtMa.Text; objNew.hoten = txtTen.Text; objNew.sodienthoai = txtSodt.Text; objNew.hinhanhs = listHinhs; if (objNew.add() > 0 && DBInstance.commit() > 0) { XtraMessageBox.Show("Thêm nhân viên thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); //reLoad(); reLoadAndFocused(objNew.id); } else { XtraMessageBox.Show("Thêm nhân viên không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (_function.Equals("phancong")) { Guid id = objNhanVienPT.id; try { objNhanVienPT.phongs.Clear(); objNhanVienPT.phongs = listPhong; ////Quan hệ 0 - n nên không thể gán list //List<Phong> listToRemove = objNhanVienPT.phongs.Except(listPhong).ToList(); //List<Phong> listToAdd = listPhong.Except(objNhanVienPT.phongs).ToList(); //foreach (Phong objToRemove in listToRemove) //{ // objToRemove.nhanvienpt = null; // objToRemove.update(); //} //foreach (Phong objToAdd in listToAdd) //{ // objToAdd.nhanvienpt = objNhanVienPT; // objToAdd.update(); //} if (DBInstance.commit() > 0) { XtraMessageBox.Show("Phân công nhân viên thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); editGUI("view"); reLoadAndFocused(id); } else { XtraMessageBox.Show("Phân công nhân viên không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->Function-PhanCong: " + ex.Message); } } } catch (Exception ex) { Debug.WriteLine(this.Name + "->Function: " + ex.Message); } }
private void setDataView() { try { dxErrorProvider1.ClearErrors(); if (!function.Equals("view")) editGUI("view"); if (gridViewNhanVien.RowCount > 0) { if (gridViewNhanVien.FocusedRowHandle > -1 && gridViewNhanVien.GetFocusedRow() != null) { objNhanVienPT = gridViewNhanVien.GetFocusedRow() as NhanVienPT; txtMa.Text = objNhanVienPT.subId; txtTen.Text = objNhanVienPT.hoten; txtSodt.Text = objNhanVienPT.sodienthoai; listPhong = objNhanVienPT.phongs.ToList(); listBoxPhong.DataSource = listPhong; listHinhs = objNhanVienPT.hinhanhs.ToList(); reloadImage(); } else { clearText(); objNhanVienPT = new NhanVienPT(); } } else { enableButton(false); barBtnThemNhanVien.Enabled = true && canAdd; clearText(); objNhanVienPT = new NhanVienPT(); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->setDataView: " + ex.Message); } }
private void getThongTinPhong(Boolean first) { if (listPhong.Count() > 0) { int row = 0; if (!first) row = gridViewPhong.FocusedRowHandle; if (row >= 0 && row < listPhong.Count()) { //int id = (gridViewPhong.GetRow(row) as Phong).id; //objPhong = Phong.getById(id); objPhong = gridViewPhong.GetRowCellValue(row, colphong) as Phong; if (objPhong != null) { if (objPhong.nhanvienpt != null) { objNhanVienPT = objPhong.nhanvienpt; //objNhanVienPT = NhanVienPT.getById(objPhong.nhanvienpt.id); } setData(); enableBar(true); } } else { deleteData(); enableBar(false); } } else { deleteData(); enableBar(false); } rbnGroupPhong.Enabled = true; barButtonThemPhong.Enabled = true && canAdd; btnR_Them.Enabled = true && canAdd; enableEdit(false); function = ""; }
private void searchLookUpEditNhanVienPT_EditValueChanged(object sender, EventArgs e) { try { if (searchLookUpEditNhanVienPT.EditValue != null && !searchLookUpEditNhanVienPT.EditValue.Equals(-1)) { Guid id = GUID.From(searchLookUpEditNhanVienPT.EditValue); if (id != Guid.Empty) objNhanVienPT = NhanVienPT.getById(id); else objNhanVienPT = null; if (objNhanVienPT != null) { txtMaNhanVien.Text = objNhanVienPT.subId; txtTenNhanVien.Text = objNhanVienPT.hoten; txtSoDienThoai.Text = objNhanVienPT.sodienthoai; listHinhAnhNhanVien = objNhanVienPT.hinhanhs.ToList(); reloadImageNhanVienPT(); } else { imgNhanVien.Images.Clear(); txtMaNhanVien.Text = ""; txtTenNhanVien.Text = ""; txtSoDienThoai.Text = ""; } } } catch (Exception ex) { System.Console.WriteLine(this.Name + ": " + ex.Message); } }
public static bool ImportNhanVien(String fileName, String sheet) { try { int line = 0; System.Data.DataTable dt = new System.Data.DataTable(); const int STT = 0; const int MANHANVIEN = 1; const int TENNHANVIEN = 2; const int SODIENTHOAI = 3; const int NGAYTAO = 4; const int HINHANH = 5; const int PASS = 6; dt = OpenFile(fileName, sheet); if (dt != null) { int lines = dt.Rows.Count; foreach (System.Data.DataRow row in dt.Rows) { line++; DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Import Nhân viên... " + String.Format(System.Globalization.CultureInfo.InvariantCulture, "{0:0.0}", (line * 1.0 / lines) * 100) + "%"); if (!row[PASS].Equals("Pass")) { if (row[TENNHANVIEN] != DBNull.Value) { if (NhanVienPT.getAll().FirstOrDefault(c => c.hoten.ToUpper() == row[TENNHANVIEN].ToString().Trim().ToUpper()) == null) { try { NhanVienPT obj = new NhanVienPT(); obj.subId = row[MANHANVIEN] != DBNull.Value ? row[MANHANVIEN].ToString().Trim() : null; obj.hoten = row[TENNHANVIEN].ToString().Trim(); obj.date_create = row[NGAYTAO] != DBNull.Value ? (DateTime?)Convert.ToDateTime(row[NGAYTAO]) : DateTime.Now; obj.sodienthoai = row[SODIENTHOAI].ToString().Trim(); if (row[HINHANH] != DBNull.Value) { String[] file_names = row[HINHANH].ToString().Trim().Split(','); obj.hinhanhs = AddImage(fileName, file_names); } if (obj.add() > 0 && DBInstance.commit() > 0) { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass"); } else { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error"); } } catch(Exception ex) { Debug.WriteLine("ExcelDataBaseHelper : ImportNhanVien : " + ex.Message); WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error"); } } else { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Exist"); } } else { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không đủ thông tin)"); } } } } return true; } catch (Exception ex) { Debug.WriteLine("ExcelDataBaseHelper : ImportNhanVien : "+ ex.Message); return false; } }