private void Xoa() { try { if (vtIndex != -1) //khi click lên tiêu đề header của datagrid thì bỏ qua { if (MSG.BanCoChacChanMuonXoaKhong() == System.Windows.Forms.DialogResult.Yes) { LoaiTaiSan temp = Utils.DataGridViewRow_to_LoaiTaiSan(DataGridView.Rows[vtIndex]); int kq = LoaiTaiSanBiz.DeleteLoaiTaiSan(temp); //if (kq > 0) MSG.XoaThanhCong(); //else MSG.XoaThatBai(); if (kq <= 0) { MSG.XoaThatBai(); } HienThi(); } } } catch (Exception ex) { MSG.Error(ex); } }
public frmReport() { InitializeComponent(); this.Size = new System.Drawing.Size(this.Size.Width, HeightNormal); comboBoxEdit_LoaiBaoCao.SelectedIndex = 0; dateEdit_TuNgay.DateTime = DateTime.Today.Date; dateEdit_DenNgay.DateTime = DateTime.Today.Date; dateEdit_Nam.DateTime = DateTime.Today.Date; ucComboBoxLoaiTS_LoaiTaiSan.showCheck(); ucComboBoxLoaiTS_LoaiTaiSan.DataSource = LoaiTSHienThi.Convert(LoaiTaiSan.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten)); DonVi objNULL = new DonVi(); ListDonVi = DonVi.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten).ToList(); objNULL.id = Guid.Empty; objNULL.ten = "[Không có đơn vị]"; objNULL.parent = null; ListDonVi.Insert(0, objNULL); ucComboBoxDonVi_ChonDonVi.DataSource = ListDonVi; ucComboBoxDonVi_ChonDonVi.DonVi = objNULL; checkedComboBoxEdit_ChonCoSo.Properties.DataSource = CoSo.getQuery().OrderBy(c => c.order).ToList(); }
public void loadData() { try { editGUI("view"); listLoaiTaiSan = LoaiTaiSan.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten).ToList(); treeListLoaiTS.DataSource = LoaiTSHienThi.Convert(listLoaiTaiSan); loadDonViTinh(); LoaiTaiSan LoaiTaiSanNULL = new LoaiTaiSan(); LoaiTaiSanNULL.id = Guid.Empty; LoaiTaiSanNULL.ten = "[Không thuộc loại nào]"; LoaiTaiSanNULL.parent = null; List <LoaiTaiSan> listLoaiTaiSanParent = new List <LoaiTaiSan>(listLoaiTaiSan); listLoaiTaiSanParent.Insert(0, LoaiTaiSanNULL); _ucComboBoxLoaiTS.DataSource = listLoaiTaiSanParent; if (listLoaiTaiSan.Count == 0) { enableButton(false); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData:" + ex.Message); } }
public void loadSearchXml(String fileName) { try { String currentPath = Directory.GetCurrentDirectory(); String path = Path.Combine(currentPath, "Search"); if (Directory.Exists(path)) { String file = path + "//" + fileName + "_Search.xml"; if (!File.Exists(file)) { XmlWriterSettings settings = new XmlWriterSettings(); settings.Indent = true; XmlWriter writer_new = XmlWriter.Create(file, settings); writer_new.WriteStartDocument(); writer_new.WriteStartElement("Search"); writer_new.WriteAttributeString("vTen", ""); writer_new.WriteAttributeString("cTen", "0"); writer_new.WriteAttributeString("vTinhTrang", ""); writer_new.WriteAttributeString("cTinhTrang", "0"); writer_new.WriteAttributeString("vLoai", ""); writer_new.WriteAttributeString("cLoai", "0"); writer_new.WriteAttributeString("vDVQL", ""); writer_new.WriteAttributeString("cDVQL", "0"); writer_new.WriteAttributeString("vViTri", ""); writer_new.WriteAttributeString("cViTri", "0"); writer_new.WriteEndElement(); writer_new.WriteEndDocument(); writer_new.Flush(); writer_new.Close(); } if (System.IO.File.Exists(file)) { XmlReader reader = XmlReader.Create(file); while (reader.Read()) { if (reader.NodeType == XmlNodeType.Element && reader.Name == "Search") { //checkTen.Checked = Convert.ToInt32(reader.GetAttribute(0)).Equals(1) ? true : false; txtTen.Text = reader.GetAttribute(0); checkTenTS.Checked = Convert.ToInt32(reader.GetAttribute(1)).Equals(1) ? true : false; checkedCbxTinhTrang.SetEditValue(reader.GetAttribute(2)); checkTinhTrang.Checked = Convert.ToInt32(reader.GetAttribute(3)).Equals(1) ? true : false; ucComboBoxLoaiTS1.LoaiTS = LoaiTaiSan.getById(GUID.From(reader.GetAttribute(4))); checkLoai.Checked = Convert.ToInt32(reader.GetAttribute(5)).Equals(1) ? true : false; ucComboBoxDonVi1.DonVi = DonVi.getById(GUID.From(reader.GetAttribute(6))); checkDVQL.Checked = Convert.ToInt32(reader.GetAttribute(7)).Equals(1) ? true : false; ucComboBoxViTri1.EditValue = GUID.From(reader.GetAttribute(8)); checkViTri.Checked = Convert.ToInt32(reader.GetAttribute(9)).Equals(1) ? true : false; } } reader.Close(); } } } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadSearchXml:" + ex.Message); } }
public static LoaiTaiSan DataGridViewRow_to_LoaiTaiSan(System.Windows.Forms.DataGridViewRow Input) { LoaiTaiSan kq = new LoaiTaiSan(); kq.MaLoaiTaiSan = Input.Cells["MaLoaiTaiSan"].Value.ToString(); kq.TenLoaiTaiSan = Input.Cells["TenLoaiTaiSan"].Value.ToString(); return(kq); }
/// <summary> /// vd: muốn thống kê cho năm 2014 thì from=(2014,1,1), to=(2014,12,31) /// </summary> /// <param name="from"></param> /// <param name="to"></param> /// <returns></returns> public static List <TK_TangGiam_TheoLoaiTS> getAll(DateTime?from, DateTime?to) { var list_loaits = LoaiTaiSan.getAll();// LoaiTaiSan.getAll(); List <TK_TangGiam_TheoLoaiTS> re = new List <TK_TangGiam_TheoLoaiTS>(); foreach (var item in list_loaits) { TK_TangGiam_TheoLoaiTS obj = new TK_TangGiam_TheoLoaiTS(); obj.tenloai = item.ten; obj.id_loai = item.id; obj.donvitinh = item.donvitinh == null ? "":item.donvitinh.ten; int count = 0; foreach (var taisan in item.taisans) { //Tính số đầu năm foreach (var ctts in taisan.cttaisans.Where( c => c.soluong > 0 && ( (c.ngay != null && c.ngay < from) ) ) ) { obj.sodaunam_soluong += ctts.soluong; obj.sodaunam_giatri += ctts.thanhtien; } var list_log_ctts = taisan.logtanggiamtaisans.Where(c => c.ngay != null && c.ngay >= from && c.ngay <= to && c.soluong > 0); //Tính tăng/giảm trong năm foreach (var ctts in list_log_ctts.Where(c => c.tang_giam == 1 || c.tang_giam == -1)) { if (ctts.tang_giam == 1) { obj.tangtrongnam_soluong += ctts.soluong; obj.tangtrongnam_giatri += ctts.thanhtien; } else if (ctts.tang_giam == -1) { obj.giamtrongnam_soluong += ctts.soluong; obj.giamtrongnam_giatri += ctts.thanhtien; } } //Tính số cuối năm obj.socuoinam_soluong = obj.sodaunam_soluong + obj.tangtrongnam_soluong - obj.giamtrongnam_soluong; obj.socuoinam_giatri = obj.sodaunam_giatri + obj.tangtrongnam_giatri - obj.giamtrongnam_giatri; } //add to list re.Add(obj); } //final filter, tự động tính tổng cho loại TS cha nếu cần //... return(re); }
private void btnAddNew_Click(object sender, EventArgs e) { id = lookUpTinhTrang.EditValue; objLoaiTS = ucComboBoxLoaiTS1.LoaiTS; frmAddTaiSan frm = new frmAddTaiSan(listCTTaiSan, listTinhTrang, listLoaiTaiSan); frm.reloadAndFocused = new ReloadAndFocused(reload); frm.reLoadAndSetValueLoaiTS = new ReLoadAndSetValueLoaiTS(reloadLoaiTS); frm.reLoadAndSetValueTinhTrang = new ReLoadAndSetValueTinhTrang(reloadTinhTrang); frm.Text = "Thêm tài sản kèm theo"; frm.ShowDialog(); }
public frmXuLyDMLoaiTaiSan(DataGridViewRow dgvr) {//Sửa InitializeComponent(); try { Them = false; LoaiTaiSan temp = Utils.DataGridViewRow_to_LoaiTaiSan(dgvr); txtMa.Text = temp.MaLoaiTaiSan; txtMa.Enabled = false; txtTen.Text = temp.TenLoaiTaiSan; } catch { } }
private void setDataView() { try { dxErrorProviderInfo.ClearErrors(); if (!function.Equals("view")) { editGUI("view"); } if (treeListLoaiTS.Nodes.Count > 0) { TreeListNode node = treeListLoaiTS.FocusedNode; if (node != null && node.GetValue(colobj) != null) { objLoaiTaiSan = node.GetValue(colobj) as LoaiTaiSan; if (objLoaiTaiSan != null) { txtMa.Text = objLoaiTaiSan.subId; txtTen.Text = objLoaiTaiSan.ten; txtMoTa.Text = objLoaiTaiSan.mota; spinHaoMon351.EditValue = objLoaiTaiSan.phantramhaomon_351; spinHaoMon32.EditValue = objLoaiTaiSan.phantramhaomon_32; checkHuuHinh.Checked = objLoaiTaiSan.huuhinh; gridLookUpDonVi.EditValue = objLoaiTaiSan.donvitinh != null ? objLoaiTaiSan.donvitinh.id : Guid.Empty; _ucComboBoxLoaiTS.LoaiTS = objLoaiTaiSan.parent != null ? objLoaiTaiSan.parent : new LoaiTaiSan(); } else { clearText(); objLoaiTaiSan = new LoaiTaiSan(); } } else { clearText(); objLoaiTaiSan = new LoaiTaiSan(); } } else { enableButton(false); clearText(); objLoaiTaiSan = new LoaiTaiSan(); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->setDataView: " + ex.Message); } }
public static List <LoaiTaiSan> getListLoaiTaiSan() { List <LoaiTaiSan> kq = new List <LoaiTaiSan>(); string sql = "SELECT [MaLoaiTaiSan],[TenLoaiTaiSan] FROM [VNAAccounting].[dbo].[LoaiTaiSan]"; System.Data.DataTable dt = DAL.CSDL.hienthi(sql); for (int i = 0; i < dt.Rows.Count; i++) { LoaiTaiSan temp = new LoaiTaiSan(); temp.MaLoaiTaiSan = dt.Rows[i]["MaLoaiTaiSan"].ToString(); temp.TenLoaiTaiSan = dt.Rows[i]["TenLoaiTaiSan"].ToString(); kq.Add(temp); } return(kq); }
private void loadDataLoaiTS() { try { listLoaiTaiSan = LoaiTaiSan.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten).ToList(); ucComboBoxLoaiTS1.DataSource = LoaiTSHienThi.Convert(listLoaiTaiSan); if (reLoadAndSetValueLoaiTS != null) { reLoadAndSetValueLoaiTS(listLoaiTaiSan); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadDataLoaiTS:" + ex.Message); } }
public void loadData() { loadLayout(); gridControlTaiSan.DataSource = null; ucComboBoxLoaiTS1.DataSource = null; ucComboBoxLoaiTS1.DataSource = LoaiTSHienThi.Convert(LoaiTaiSan.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten)); checkedComboBoxCoSo.Properties.DataSource = CoSo.getQuery().OrderBy(c => c.order).ToList(); List <DonVi> list = DonVi.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten).ToList(); DonVi objNULL = new DonVi(); objNULL.id = Guid.Empty; objNULL.ten = "[Đại học Sài Gòn]"; objNULL.parent = null; list.Insert(0, objNULL); ucComboBoxDonVi1.DataSource = null; ucComboBoxDonVi1.DataSource = list; }
public void loadData() { try { //DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this.ParentForm, typeof(WaitFormLoad), true, true, false); //DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Đang tải dữ liệu..."); //gridControlTaiSan.DataSource = TaiSanHienThi.getAllNoDonVi(); //DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm(false); ucComboBoxLoaiTS1.DataSource = LoaiTSHienThi.Convert(LoaiTaiSan.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten)); List <DonVi> list = DonVi.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten).ToList(); DonVi objNULL = new DonVi(); objNULL.id = Guid.Empty; objNULL.ten = "[Không có đơn vị]"; objNULL.parent = null; list.Insert(0, objNULL); ucComboBoxDonVi1.DataSource = list; ucComboBoxDonVi1.DonVi = objNULL; List <ViTriHienThi> listViTri = ViTriHienThi.getAllHavePhong(); ViTriHienThi objNULL2 = new ViTriHienThi(); objNULL2.id = Guid.Empty; objNULL2.ten = "[Không có vị trí]"; objNULL2.parent_id = Guid.Empty; objNULL2.loai = typeof(Phong).Name; listViTri.Insert(0, objNULL2); ucComboBoxViTri1.DataSource = listViTri; checkedCbxTinhTrang.Properties.DataSource = TinhTrang.getQuery().OrderBy(c => c.order).ToList(); //ucComboBoxDonVi2.DonVi = objNULL; ucGridControlTaiSan1.DataSource = null; barBtnSuaTaiSan.Enabled = false; barBtnXoaTaiSan.Enabled = false; btnSua_r.Enabled = false; btnXoa_r.Enabled = false; btnClear.PerformClick(); loadSearchXml(this.Name); Search(); } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData:" + ex.Message); } }
private void btnOK_Click(object sender, EventArgs e) { try { if (checkInput()) { switch (function) { case "add": objLoaiTaiSan = new LoaiTaiSan(); setDataObj(); if (objLoaiTaiSan.add() > 0 && DBInstance.commit() > 0) { XtraMessageBox.Show("Thêm loại tài sản thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); Guid id = objLoaiTaiSan.id; reLoadAndSelectNode(id); } else { XtraMessageBox.Show("Thêm loại tài sản không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } break; case "edit": setDataObj(); if (objLoaiTaiSan.update() > 0 && DBInstance.commit() > 0) { XtraMessageBox.Show("Sửa loại tài sản thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); Guid id = objLoaiTaiSan.id; reLoadAndSelectNode(id); } else { XtraMessageBox.Show("Sửa loại tài sản không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } break; } } } catch (Exception ex) { Debug.WriteLine(this.Name + "->btnOk_Click: " + ex.Message); } }
public List <LoaiTaiSan> getListLoaiTS() { try { List <LoaiTaiSan> list = new List <LoaiTaiSan>(); List <TreeListNode> listNode = treeListLookUpLoaiTSTreeList.GetAllCheckedNodes(); foreach (TreeListNode node in listNode) { LoaiTaiSan obj = node.GetValue(colobj) as LoaiTaiSan; list.Add(obj); } return(list); } catch (Exception ex) { Debug.WriteLine(this.Name + "->getListLoaiTS: " + ex.Message); return(null); } }
//private void setThanhTien() //{ // if (txtSoLuong.EditValue != null && txtDonGia.EditValue != null) // { // long thanhtien = Convert.ToInt32(txtSoLuong.EditValue) * long.Parse(txtDonGia.EditValue.ToString()); // lbltxtThanhTien.Text = String.Format("{0:### ### ### ###}", thanhtien); // } //} private void setDonViTinh() { try { LoaiTaiSan obj = ucComboBoxLoaiTS1.LoaiTS; if (obj == null || obj.donvitinh == null) { lbltxtDonViTinh.Text = lbltxtDonViTinh1.Text = lbltxtDonViTinh2.Text = ""; } else { lbltxtDonViTinh.Text = lbltxtDonViTinh1.Text = lbltxtDonViTinh2.Text = ucComboBoxLoaiTS1.LoaiTS.donvitinh.ten; } } catch (Exception ex) { Debug.WriteLine(this.Name + "->setDonViTinh:" + ex.Message); } }
public void saveSearchXml(String fileName) { try { String currentPath = Directory.GetCurrentDirectory(); String path = Path.Combine(currentPath, "Search"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } String file = path + "//" + fileName + "_Search.xml"; XmlWriterSettings settings = new XmlWriterSettings(); settings.Indent = true; XmlWriter writer = XmlWriter.Create(file, settings); writer.WriteStartDocument(); //writer.WriteComment(""); writer.WriteStartElement("Search"); //writer.WriteAttributeString("cTen", checkTen.Checked ? "1" : "0"); writer.WriteAttributeString("vTen", txtTen.Text); writer.WriteAttributeString("cTen", checkTenTS.Checked ? "1" : "0"); writer.WriteAttributeString("vTinhTrang", checkedCbxTinhTrang.EditValue.ToString()); writer.WriteAttributeString("cTinhTrang", checkTinhTrang.Checked ? "1" : "0"); LoaiTaiSan loai = ucComboBoxLoaiTS1.LoaiTS; writer.WriteAttributeString("vLoai", loai != null ? loai.id.ToString() : ""); writer.WriteAttributeString("cLoai", checkLoai.Checked ? "1" : "0"); DonVi dvql = ucComboBoxDonVi1.DonVi; writer.WriteAttributeString("vDVQL", dvql != null ? dvql.id.ToString() : ""); writer.WriteAttributeString("cDVQL", checkDVQL.Checked ? "1" : "0"); Guid id = GUID.From(ucComboBoxViTri1.EditValue); writer.WriteAttributeString("vViTri", id != Guid.Empty ? id.ToString() : ""); writer.WriteAttributeString("cViTri", checkViTri.Checked ? "1" : "0"); writer.WriteEndElement(); writer.WriteEndDocument(); writer.Flush(); writer.Close(); } catch (Exception ex) { Debug.WriteLine(this.Name + "->saveSearchXml:" + ex.Message); } }
private void btnTim_Click(object sender, EventArgs e) { if (dateNgayTK.EditValue == null) { dateNgayTK.DateTime = DateTime.Now; } if (dateNgayTK.DateTime.Year <= 2008) { XtraMessageBox.Show("Năm thống kê phải lớn hơn 2008", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this.ParentForm, typeof(WaitFormLoad), true, true, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Đang tải dữ liệu..."); try { //String ten = checkTen.Checked ? txtTen.Text : null; //String ten = txtTen.Text; LoaiTaiSan loai = checkLoaiTS.Checked ? ucComboBoxLoaiTS1.LoaiTS : null; DonVi DVQL = ucComboBoxDonVi1.DonVi; ViTri vitri = ucComboBoxViTri1.ViTri; Phong phong = ucComboBoxViTri1.Phong; List <Guid> tinhtrangs = CheckedComboBoxEditHelper.getCheckedValueArray(checkedCbxTinhTrang); bool isViTri = true; if (vitri == null) { isViTri = false; } List <CTTaiSan> tmp = CTTaiSanSF.search(null, loai, checkDonVi.Checked, DVQL, false, null, isViTri && checkViTri.Checked, vitri, !isViTri && checkViTri.Checked, phong, checkTinhTrang.Checked ? tinhtrangs : null).ToList(); List <TaiSanHienThi> list = TaiSanHienThi.Convert(tmp, dateNgayTK.DateTime.Year); gridControlHaoMon.DataSource = list; //saveSearchXml(this.Name); //ucGridControlTaiSan1.CollapseAllGroups(); } catch (Exception ex) { Debug.WriteLine(this.Name + "->Search:" + ex.Message); } DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm(false); } }
private Boolean checkInput() { try { dxErrorProviderInfo.ClearErrors(); Boolean check = true; if (txtTen.Text.Length == 0) { dxErrorProviderInfo.SetError(txtTen, "Chưa điền tên TSCĐ"); check = false; } if (lookUpTinhTrang.EditValue == null || GUID.From(lookUpTinhTrang.EditValue) == Guid.Empty) { dxErrorProviderInfo.SetError(lookUpTinhTrang, "Chưa chọn tình trạng"); check = false; } if (txtDonGia.EditValue == null) { dxErrorProviderInfo.SetError(txtDonGia, "Chưa nhập đơn giá"); check = false; } if (txtSoLuong.EditValue == null) { dxErrorProviderInfo.SetError(lookUpTinhTrang, "Chưa nhầp số lượng"); check = false; } LoaiTaiSan loai = ucComboBoxLoaiTS1.LoaiTS; if (loai == null || loai.id == Guid.Empty) { XtraMessageBox.Show("Chưa chọn loại tài sản"); return(false); } return(check); } catch (Exception ex) { Debug.WriteLine(this.Name + "->checkInput: " + ex.Message); return(false); } }
private void btnDongY_Click(object sender, EventArgs e) { if (Them) {//Thêm LoaiTaiSan temp = new LoaiTaiSan(); temp.MaLoaiTaiSan = txtMa.Text; temp.TenLoaiTaiSan = txtTen.Text; if (!CheckLoi(temp)) { return; } int kq = LoaiTaiSanBiz.AddLoaiTaiSan(temp); if (kq > 0) { MSG.ThemThanhCong(); } else { MSG.ThemThatBai(); } } else {//Sửa LoaiTaiSan temp = new LoaiTaiSan(); temp.MaLoaiTaiSan = txtMa.Text; temp.TenLoaiTaiSan = txtTen.Text; int kq = LoaiTaiSanBiz.EditLoaiTaiSan(temp); if (kq > 0) { MSG.SuaThanhCong(); } else { MSG.SuaThatBai(); } } this.Close(); }
public void Search() { DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this.ParentForm, typeof(WaitFormLoad), true, true, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Đang tải dữ liệu..."); try { //String ten = checkTen.Checked ? txtTen.Text : null; //String ten = txtTen.Text; List <Guid> tinhtrangs = CheckedComboBoxEditHelper.getCheckedValueArray(checkedCbxTinhTrang); LoaiTaiSan loai = checkLoaiTS.Checked ? ucComboBoxLoaiTS1.LoaiTS : null; DonVi DVQL = ucComboBoxDonVi1.DonVi; ViTri vitri = ucComboBoxViTri1.ViTri; Phong phong = ucComboBoxViTri1.Phong; bool isViTri = true; if (vitri == null) { isViTri = false; } List <TaiSanHienThi> list = TaiSanHienThi.Convert(CTTaiSanSF.search(null, loai, checkDonVi.Checked, DVQL, false, null, isViTri && checkViTri.Checked, vitri, !isViTri && checkViTri.Checked, phong, checkTinhTrang.Checked ? tinhtrangs : null, (cbxEquationDonGia.EditValue != null && checkDonGia.Checked) ? cbxEquationDonGia.EditValue.ToString() : null, (spinDonGia.EditValue != null && checkDonGia.Checked) ? (long?)long.Parse(spinDonGia.EditValue.ToString()) : null, (cbxEquationNgaySD.EditValue != null && checkNgaySuDung.Checked) ? cbxEquationNgaySD.EditValue.ToString() : null, (dateNgaySD.EditValue != null && checkNgaySuDung.Checked) ? (DateTime?)dateNgaySD.DateTime : null)); //ucGridControlTaiSan1.DataSource = list; gridControlTaiSan.DataSource = list; taisans = list; //bool isEnabled = list.Count > 0; //barBtnSuaTaiSan.Enabled = isEnabled; //barBtnXoaTaiSan.Enabled = isEnabled; //btnSua_r.Enabled = isEnabled; //btnXoa_r.Enabled = isEnabled; //saveSearchXml(this.Name); //ucGridControlTaiSan1.CollapseAllGroups(); gridViewTaiSan.CollapseAllGroups(); } catch (Exception ex) { Debug.WriteLine(this.Name + "->Search:" + ex.Message); } DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm(false); }
bool CheckLoi(LoaiTaiSan data) { bool kq = true; //mã loại tài sản rỗng if (string.IsNullOrEmpty(data.MaLoaiTaiSan)) { MSG.ErrorStand("Bạn chưa nhập mã loại tài sản!"); txtMa.Focus(); return(false); } //mã loại tài sản đã có trong cơ sở dữ liệu foreach (LoaiTaiSan item in frmDMLoaiTaiSan.Ldata) { if (item.MaLoaiTaiSan.ToUpper().Equals(txtMa.Text.ToUpper())) { MSG.ErrorStand("Mã loại tài sản đã có trong cơ sở dữ liệu!"); txtMa.Focus(); return(false); } } return(kq); }
private void setDataObj() { try { objLoaiTaiSan.subId = txtMa.Text; objLoaiTaiSan.ten = txtTen.Text; objLoaiTaiSan.mota = txtMoTa.Text; objLoaiTaiSan.phantramhaomon_351 = spinHaoMon351.EditValue != null?double.Parse(spinHaoMon351.EditValue.ToString()) : 0; objLoaiTaiSan.phantramhaomon_32 = spinHaoMon32.EditValue != null?double.Parse(spinHaoMon32.EditValue.ToString()) : 0; objLoaiTaiSan.huuhinh = checkHuuHinh.Checked; DonViTinh objDonVi = gridLookUpDonVi.EditValue != null?DonViTinh.getById(GUID.From(gridLookUpDonVi.EditValue)) : null; objLoaiTaiSan.donvitinh = (objDonVi != null && objDonVi.id != Guid.Empty) ? objDonVi : null; LoaiTaiSan objParent = _ucComboBoxLoaiTS.LoaiTS; objLoaiTaiSan.parent = (objParent != null && objParent.id != Guid.Empty) ? objParent : null; } catch (Exception ex) { Debug.WriteLine(this.Name + "->setDataObj: " + ex.Message); } }
public void Search() { DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this.ParentForm, typeof(WaitFormLoad), true, true, false); DevExpress.XtraSplashScreen.SplashScreenManager.Default.SetWaitFormCaption("Đang tải dữ liệu..."); try { //String ten = checkTen.Checked ? txtTen.Text : null; String ten = txtTen.Text; LoaiTaiSan loai = checkLoai.Checked ? ucComboBoxLoaiTS1.LoaiTS : null; DonVi DVQL = ucComboBoxDonVi1.DonVi; ViTri vitri = ucComboBoxViTri1.ViTri; Phong phong = ucComboBoxViTri1.Phong; bool isViTri = true; if (vitri == null) { isViTri = false; } List <Guid> tinhtrangs = CheckedComboBoxEditHelper.getCheckedValueArray(checkedCbxTinhTrang); List <TaiSanHienThi> list = TaiSanHienThi.Convert(CTTaiSanSF.search(checkTenTS.Checked ? ten : "", checkLoai.Checked ? loai : null, checkDVQL.Checked, DVQL, false, null, isViTri && checkViTri.Checked, vitri, !isViTri && checkViTri.Checked, phong, checkTinhTrang.Checked ? tinhtrangs : null)); ucGridControlTaiSan1.DataSource = list; bool isEnabled = list.Count > 0; barBtnSuaTaiSan.Enabled = isEnabled; barBtnXoaTaiSan.Enabled = isEnabled; btnSua_r.Enabled = isEnabled; btnXoa_r.Enabled = isEnabled; saveSearchXml(this.Name); ucGridControlTaiSan1.CollapseAllGroups(); } catch (Exception ex) { Debug.WriteLine(this.Name + "->Search:" + ex.Message); } DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm(false); }
//------------------------------------------> private void DongY() { if (vtIndex == -1) { return; } switch (chose) { case CONFIG.ConstFrm.frmDMLoaiTaiSan: { loaitaisan = Utils.DataGridViewRow_to_LoaiTaiSan(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMTaiSan: { taisan = Utils.DataGridViewRow_to_TaiSan(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMPhanNhomTaiSan: { phannhomtaisan = Utils.DataGridViewRow_to_PhanNhomTaiSan(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMLyDoTangGiamTaiSan: { lydotanggiamtaisan = Utils.DataGridViewRow_to_LyDoTangGiamTaiSan(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMBoPhanHachToan: { bophanhachtoan = Utils.DataGridViewRow_to_BoPhanHachToan(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMPhanXuong: { phanxuong = Utils.DataGridViewRow_to_PhanXuong(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMPhi: { phi = Utils.DataGridViewRow_to_Phi(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMBoPhanSuDung: { bophansusung = Utils.DataGridViewRow_to_BoPhanSuDung(DataGridView.Rows[vtIndex]); break; } case CONFIG.ConstFrm.frmDMNguonVon: { nguonvon = Utils.DataGridViewRow_to_NguonVon(DataGridView.Rows[vtIndex]); break; } default: break; } }
private static LoaiTaiSan getLoai(String _ten) { try { String ten = _ten.Trim(); ten = ten.Replace("- ", ""); LoaiTaiSan obj = LoaiTaiSan.getQuery().Where(c => c.ten.ToUpper().Equals(ten.ToUpper())).FirstOrDefault(); if (obj == null) { obj = new LoaiTaiSan(); obj.ten = ten; obj.huuhinh = true; obj.donvitinh = null; if (obj.add() > 0 && DBInstance.commit() > 0) return obj; else return null; } return obj; } catch { return null; } }
/// <summary> /// Hàm tìm kiếm dạng QueryAble, sau khi lấy kết quả có thể /// lọc lần 2 bằng Where rồi gọi .ToList(); sẽ ra được kết quả sau cùng /// </summary> /// <param name="tenTaiSan">(null||blank)=>ignore</param> /// <param name="loaiTaiSan">null=>ignore</param> /// <param name="timTheoDonViQL">false=>ignore</param> /// <param name="donViQuanLy"></param> /// <param name="timTheoDonViSD">false=>ignore</param> /// <param name="donViSuDung"></param> /// <returns></returns> public static IQueryable <CTTaiSan> search( String tenTaiSan = "", LoaiTaiSan loaiTaiSan = null, Boolean timTheoDonViQL = false, DonVi donViQuanLy = null, Boolean timTheoDonViSD = false, DonVi donViSuDung = null, Boolean timTheoViTri = false, ViTri vitri = null, Boolean timTheoPhong = false, Phong phong = null, List <Guid> tinhtrangs = null, String equation = null, long?dongia = null, String equation_ngay = null, DateTime?ngay_sd = null ) { var query = CTTaiSan.getQuery(); query = query.Where(c => c.soluong > 0); if (tenTaiSan != null && !tenTaiSan.Equals("")) { query = query.Where(c => c.taisan.ten.ToLower().Contains(tenTaiSan.ToLower())); } if (loaiTaiSan != null) { //tim kiem de quy cho loai tai san List <LoaiTaiSan> list = loaiTaiSan.getAllChildsRecursive(true); List <Guid> list_id = list.Select(c => c.id).ToList(); query = query.Where(c => list_id.Contains(c.taisan.loaitaisan.id)); } if (timTheoDonViQL) { if (donViQuanLy == null) { query = query.Where(c => c.donviquanly == null); } else { //tim kiem de quy cho dvquanly List <DonVi> list = donViQuanLy.getAllChildsRecursive(); List <Guid> list_id = list.Select(c => c.id).ToList(); query = query.Where(c => (c.donviquanly != null) && (list_id.Contains(c.donviquanly.id))); } } if (timTheoDonViSD) { if (donViSuDung == null) { query = query.Where(c => c.donvisudung == null); } else { //tim kiem de quy cho dvquanly List <DonVi> list = donViSuDung.getAllChildsRecursive(); List <Guid> list_id = list.Select(c => c.id).ToList(); query = query.Where(c => (c.donvisudung != null) && (list_id.Contains(c.donvisudung.id))); } } if (timTheoViTri) { if (vitri == null) { query = query.Where(c => c.vitri == null); } else { query = query.Where(c => //Tìm chính xác theo vị trí (c.vitri != null && c.vitri.id == vitri.id) || //Tìm luôn record có phòng thuộc vitri (c.phong != null && c.phong.vitri != null && c.phong.vitri.id == vitri.id) ); } } if (timTheoPhong) { if (phong == null) { query = query.Where(c => c.phong == null); } else { query = query.Where(c => (c.phong != null && c.phong.id == phong.id) ); } } if (tinhtrangs != null && tinhtrangs.Count > 0) { query = query.Where(c => c.tinhtrang == null || tinhtrangs.Contains(c.tinhtrang.id)); } //DONGIA if ((equation != null && (equation.Equals("=") || equation.Equals(">=") || equation.Equals(">") || equation.Equals("<=") || equation.Equals("<"))) && dongia != null && dongia >= 0) { if (equation.Equals("=")) { query = query.Where(x => x.taisan.dongia == dongia); } else if (equation.Equals(">=")) { query = query.Where(x => x.taisan.dongia >= dongia); } else if (equation.Equals(">")) { query = query.Where(x => x.taisan.dongia > dongia); } else if (equation.Equals("<=")) { query = query.Where(x => x.taisan.dongia <= dongia); } else if (equation.Equals("<")) { query = query.Where(x => x.taisan.dongia < dongia); } } //NGAYSUDUNG if ((equation_ngay != null && (equation_ngay.Equals("=") || equation_ngay.Equals(">=") || equation_ngay.Equals(">") || equation_ngay.Equals("<=") || equation_ngay.Equals("<"))) && ngay_sd != null) { if (equation_ngay.Equals("=")) { query = query.Where(x => x.ngay == null || x.ngay == ngay_sd); } else if (equation_ngay.Equals(">=")) { query = query.Where(x => x.ngay == null || x.ngay >= ngay_sd); } else if (equation_ngay.Equals(">")) { query = query.Where(x => x.ngay == null || x.ngay > ngay_sd); } else if (equation_ngay.Equals("<=")) { query = query.Where(x => x.ngay == null || x.ngay <= ngay_sd); } else if (equation_ngay.Equals("<")) { query = query.Where(x => x.ngay == null || x.ngay < ngay_sd); } } return(query); }
public static bool ImportLoaiTS(String fileName, String sheet) { try { System.Data.DataTable dt = new System.Data.DataTable(); const int STT = 0; const int TEN = 1; const int DONVITINH = 2; const int LOAI = 3; const int PARENT = 4; const int PASS = 5; dt = OpenFile(fileName, sheet); if (dt != null) { foreach (System.Data.DataRow row in dt.Rows) { if (row[PASS] == DBNull.Value || !row[PASS].Equals("Pass")) { if (row[TEN] != DBNull.Value && row[LOAI] != DBNull.Value) { try { if (row[PARENT] != DBNull.Value) { String tenParent = row[PARENT].ToString().Trim().ToUpper(); LoaiTaiSan objParent = LoaiTaiSan.getQuery().Where(c => c.ten.ToUpper().Equals(tenParent)).FirstOrDefault(); if (objParent != null) { String ten = row[TEN].ToString().Trim().ToUpper(); LoaiTaiSan obj = LoaiTaiSan.getQuery().Where(c => c.ten.ToUpper().Equals(ten)).FirstOrDefault(); if (obj == null) { obj = new LoaiTaiSan(); obj.ten = row[TEN].ToString().Trim(); obj.parent = objParent; obj.donvitinh = row[DONVITINH] != DBNull.Value ? getDonViTinh(row[DONVITINH].ToString()) : null; obj.huuhinh = Convert.ToBoolean(row[LOAI]); if (obj.add() > 0 && DBInstance.commit() > 0) { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass"); } else { 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 có loại tài sản cha)"); } } else { String ten = row[TEN].ToString().Trim().ToUpper(); LoaiTaiSan obj = LoaiTaiSan.getQuery().Where(c => c.ten.ToUpper().Equals(ten)).FirstOrDefault(); if (obj == null) { obj = new LoaiTaiSan(); obj.ten = row[TEN].ToString().Trim(); obj.donvitinh = row[DONVITINH] != DBNull.Value ? getDonViTinh(row[DONVITINH].ToString()) : null; obj.huuhinh = Convert.ToBoolean(row[LOAI]); if (obj.add() > 0 && DBInstance.commit() > 0) { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Pass"); } else { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error"); } } else { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Exist"); } } } catch (Exception ex) { Debug.WriteLine("ExcelDataBaseHelper->ImportDonVi: " + ex.Message); WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error"); } } else { WriteFile(fileName, sheet, row[STT].ToString().Trim(), "Error (Không đủ thông tin)"); } } } } return true; } catch (Exception ex) { Debug.WriteLine("ExcelDataBaseHelper->ImportDonVi: " + ex.Message); return false; } }
public static int EditLoaiTaiSan(LoaiTaiSan input) { string sql = "UPDATE [VNAAccounting].[dbo].[LoaiTaiSan] SET TenLoaiTaiSan = N'" + input.TenLoaiTaiSan + "' WHERE MaLoaiTaiSan = N'" + input.MaLoaiTaiSan.ToUpper() + "'"; return(DAL.CSDL.ThemSuaXoa(sql)); }
public static int AddLoaiTaiSan(LoaiTaiSan input) { string sql = "INSERT INTO [VNAAccounting].[dbo].[LoaiTaiSan]([MaLoaiTaiSan],[TenLoaiTaiSan]) VALUES(N'" + input.MaLoaiTaiSan.ToUpper() + "',N'" + input.TenLoaiTaiSan + "')"; return(DAL.CSDL.ThemSuaXoa(sql)); }
public static int DeleteLoaiTaiSan(LoaiTaiSan input) { string sql = "DELETE FROM [VNAAccounting].[dbo].[LoaiTaiSan] WHERE MaLoaiTaiSan = N'" + input.MaLoaiTaiSan.ToUpper() + "'"; return(DAL.CSDL.ThemSuaXoa(sql)); }
public void loadData() { try { editGUI("view"); listLoaiTaiSan = LoaiTaiSan.getQuery().OrderBy(c => c.parent_id).ThenBy(c => c.ten).ToList(); treeListLoaiTS.DataSource = LoaiTSHienThi.Convert(listLoaiTaiSan); loadDonViTinh(); LoaiTaiSan LoaiTaiSanNULL = new LoaiTaiSan(); LoaiTaiSanNULL.id = Guid.Empty; LoaiTaiSanNULL.ten = "[Không thuộc loại nào]"; LoaiTaiSanNULL.parent = null; List<LoaiTaiSan> listLoaiTaiSanParent = new List<LoaiTaiSan>(listLoaiTaiSan); listLoaiTaiSanParent.Insert(0, LoaiTaiSanNULL); _ucComboBoxLoaiTS.DataSource = listLoaiTaiSanParent; if (listLoaiTaiSan.Count == 0) { enableButton(false); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->loadData:" + ex.Message); } }
private void setDataView() { try { dxErrorProviderInfo.ClearErrors(); if (!function.Equals("view")) editGUI("view"); if (treeListLoaiTS.Nodes.Count > 0) { TreeListNode node = treeListLoaiTS.FocusedNode; if (node != null && node.GetValue(colobj) != null) { objLoaiTaiSan = node.GetValue(colobj) as LoaiTaiSan; if (objLoaiTaiSan != null) { txtMa.Text = objLoaiTaiSan.subId; txtTen.Text = objLoaiTaiSan.ten; txtMoTa.Text = objLoaiTaiSan.mota; spinHaoMon351.EditValue = objLoaiTaiSan.phantramhaomon_351; spinHaoMon32.EditValue = objLoaiTaiSan.phantramhaomon_32; checkHuuHinh.Checked = objLoaiTaiSan.huuhinh; gridLookUpDonVi.EditValue = objLoaiTaiSan.donvitinh != null ? objLoaiTaiSan.donvitinh.id : Guid.Empty; _ucComboBoxLoaiTS.LoaiTS = objLoaiTaiSan.parent != null ? objLoaiTaiSan.parent : new LoaiTaiSan(); } else { clearText(); objLoaiTaiSan = new LoaiTaiSan(); } } else { clearText(); objLoaiTaiSan = new LoaiTaiSan(); } } else { enableButton(false); clearText(); objLoaiTaiSan = new LoaiTaiSan(); } } catch (Exception ex) { Debug.WriteLine(this.Name + "->setDataView: " + ex.Message); } }