private void GetDataPresDetail() { int stock_id = -1; stock_id = Utility.Int32Dbnull(id_khoXuat); m_dtDataPresDetail = SPs.DuocLaythongtinDonthuocLinhthuoc(Pres_ID, stock_id).GetDataSet().Tables[0]; if (!m_dtDataPresDetail.Columns.Contains("CHON")) { m_dtDataPresDetail.Columns.Add("CHON", typeof(int)); } foreach (DataRow dr in m_dtDataPresDetail.Rows) { dr["CHON"] = 0; } m_dtDataPresDetail.AcceptChanges(); string _rowFilter = string.Format("Pres_ID={0}", Pres_ID); Utility.SetDataSourceForDataGridEx(grdPresDetail, m_dtDataPresDetail, false, true, "1=1", KcbDonthuocChitiet.Columns.ThuTuIn); GridEXColumn gridExColumn = grdPresDetail.RootTable.Columns[KcbDonthuocChitiet.Columns.ThuTuIn]; var gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending); grdPresDetail.RootTable.SortKeys.Add(gridExSortKey); // grdPresDetail.DataSource = p_dtPresDetail.DefaultView; ///thực hiện việc thay đổi khi load thông tin của thành tiền UpdateDataWhenChanged(); //ModifyCommnad(); }
private void UpdateBindingSourceFilter() { bindingSource.Filter = GetBindingSourceFilterString(); if (dgEvents.RootTable.SortKeys.Count == 0) { currentSort = null; } else { GridEXSortKey key = dgEvents.RootTable.SortKeys[0]; if (key.SortOrder != Janus.Windows.GridEX.SortOrder.Unsorted) { currentSort = key.Column.Key + (key.SortOrder == Janus.Windows.GridEX.SortOrder.Ascending ? " ASC" : " DESC"); } else { currentSort = null; } } if (currentSort == null) { bindingSource.Sort = "Index DESC"; } else { bindingSource.Sort = currentSort; } }
private void CauHinh() { HisDuocProperties = Utility.HisDuocProperties; cmdHuyDonThuoc.Visible = HisDuocProperties.HuyXacNhan; cmdXoaChiTietThuoc.Visible = HisDuocProperties.Chophepxoachitiet; Janus.Windows.GridEX.GridEXColumn gridExColumn = grdPres.RootTable.Columns[TPrescription.Columns.PresId]; Janus.Windows.GridEX.GridEXSortKey gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending); grdPres.RootTable.SortKeys.Add(gridExSortKey); if (HisDuocProperties.KieuDuyetDonThuoc == "DONTHUOC") { Utility.VisiableGridEx(grdPres, TPrescription.Columns.Status, true); Janus.Windows.GridEX.GridEXColumn gridExColumnFormat = grdPres.RootTable.Columns[TPrescription.Columns.Status]; Janus.Windows.GridEX.GridEXFormatCondition gridExFormatCondition = new GridEXFormatCondition(gridExColumnFormat, ConditionOperator.Equal, 1); gridExFormatCondition.FormatStyle.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); grdPres.RootTable.FormatConditions.Add(gridExFormatCondition); } else { Utility.VisiableGridEx(grdPres, TPrescription.Columns.Status, false); } dtNgayPhatThuoc.Enabled = HisDuocProperties.ChoPhepChinhNgayDuyet; chkLocNgayKhiDuyet.Checked = HisDuocProperties.LocDonThuocKhiDuyet; //LoadLayout(); }
private GridEXSortKey CreateSortKey(GridEXColumn column, bool ascending) { GridEXSortKey sortKey = new GridEXSortKey(); sortKey.Column = column; if (!ascending) { sortKey.SortOrder = Janus.Windows.GridEX.SortOrder.Descending; } return sortKey; }
private void CreateSortKeys(GridEX grid) { int sortKeysCount = 0; if (cboColumn3.SelectedIndex > 0) { sortKeysCount = 4; } else if (cboColumn2.SelectedIndex > 0) { sortKeysCount = 3; } else if (cboColumn1.SelectedIndex > 0) { sortKeysCount = 2; } else if (cboColumn0.SelectedIndex > 0) { sortKeysCount = 1; } else { sortKeysCount = 0; } GridEXSortKey[] sortKeys = new GridEXSortKey[sortKeysCount]; if (sortKeysCount > 0) { sortKeys[0] = CreateSortKey((GridEXColumn)((object[])cboColumn0.SelectedItem)[1], optAscending0.Checked); } if (sortKeysCount > 1) { sortKeys[1] = CreateSortKey((GridEXColumn)((object[])cboColumn1.SelectedItem)[1], optAscending1.Checked); } if (sortKeysCount > 2) { sortKeys[2] = CreateSortKey((GridEXColumn)((object[])cboColumn2.SelectedItem)[1], optAscending2.Checked); } if (sortKeysCount > 3) { sortKeys[3] = CreateSortKey((GridEXColumn)((object[])cboColumn3.SelectedItem)[1], optAscending3.Checked); } grid.RootTable.SortKeys.AddRange(sortKeys); }
public DialogResult ShowDialog(GridEX grid, Form parent) { GridEXSortKey sortKey = null; this.FillColumnList(grid.RootTable.Columns, this.cboColumn0); this.FillColumnList(grid.RootTable.Columns, this.cboColumn1); this.FillColumnList(grid.RootTable.Columns, this.cboColumn2); this.FillColumnList(grid.RootTable.Columns, this.cboColumn3); if (grid.RootTable.SortKeys.Count == 0) { SetSortKey(null, true, cboColumn0, optAscending0, optDescending0); } else { if (grid.RootTable.SortKeys.Count >= 1) { sortKey = grid.RootTable.SortKeys[0]; SetSortKey(sortKey.Column, (sortKey.SortOrder == Janus.Windows.GridEX.SortOrder.Ascending), cboColumn0, optAscending0, optDescending0); } if (grid.RootTable.SortKeys.Count >= 2) { sortKey = grid.RootTable.SortKeys[1]; SetSortKey(sortKey.Column, (sortKey.SortOrder == Janus.Windows.GridEX.SortOrder.Ascending), cboColumn1, optAscending1, optDescending1); } if (grid.RootTable.SortKeys.Count >= 3) { sortKey = grid.RootTable.SortKeys[2]; SetSortKey(sortKey.Column, (sortKey.SortOrder == Janus.Windows.GridEX.SortOrder.Ascending), cboColumn2, optAscending2, optDescending2); } if (grid.RootTable.SortKeys.Count >= 4) { sortKey = grid.RootTable.SortKeys[3]; SetSortKey(sortKey.Column, (sortKey.SortOrder == Janus.Windows.GridEX.SortOrder.Ascending), cboColumn3, optAscending3, optDescending3); } } this.ShowDialog(parent); if (this.DialogResult == System.Windows.Forms.DialogResult.OK) { grid.RootTable.SortKeys.Clear(); CreateSortKeys(grid); } return this.DialogResult; }
public void SetFilter(String value) { Janus.Windows.GridEX.GridEXFilterCondition cond = null; Janus.Windows.GridEX.GridEXSortKey sort = null; Attribute[] columnAttributes = Attribute.GetCustomAttributes(persistentType); foreach (Attribute columnAttribute in columnAttributes) { if (columnAttribute is FilterColumnAttribute) { cond = new GridEXFilterCondition(); cond.Column = grdData.RootTable.Columns[(columnAttribute as FilterColumnAttribute).Name]; cond.Value1 = value; cond.ConditionOperator = Janus.Windows.GridEX.ConditionOperator.Contains; sort = new GridEXSortKey(); sort.Column = grdData.RootTable.Columns[(columnAttribute as FilterColumnAttribute).Name]; sort.SortOrder = Janus.Windows.GridEX.SortOrder.Ascending; } } if (value != String.Empty) { grdData.RootTable.ApplyFilter(cond); if (grdData.RowCount == 0) { grdData.RootTable.ApplyFilter(null); } } else { grdData.RootTable.ApplyFilter(null); } grdData.RootTable.SortKeys.Clear(); grdData.RootTable.SortKeys.Add(sort); }
private void getData() { m_dtChiDinhCLS = null; //SPs.ClsLaokhoaInphieuChidinhCls(objAssignInfo.AssignCode, Utility.sDbnull(objAssignInfo.PatientCode), // Utility.Int32Dbnull(objAssignInfo.PatientId,-1)).GetDataSet().Tables[0]; Utility.AddColumToDataTable(ref m_dtChiDinhCLS, "STT", typeof(Int32)); Int32 idx = 1; foreach (DataRow drv in m_dtChiDinhCLS.Rows) { drv["STT"] = idx; idx++; } m_dtChiDinhCLS.AcceptChanges(); Utility.SetDataSourceForDataGridEx(grdAssignInfo, m_dtChiDinhCLS, false, true, "1=1", ""); try { grdAssignInfo.RootTable.SortKeys.Clear(); Janus.Windows.GridEX.GridEXColumn gridExColumnGroup = grdAssignInfo.RootTable.Columns["IntOrderGroup"]; Janus.Windows.GridEX.GridEXColumn gridExColumn = grdAssignInfo.RootTable.Columns["IntOrder"]; Janus.Windows.GridEX.GridEXSortKey gridExSortKeyGroup = new GridEXSortKey(gridExColumnGroup, Janus.Windows.GridEX.SortOrder.Ascending); Janus.Windows.GridEX.GridEXSortKey gridExSortKey = new GridEXSortKey(gridExColumn, Janus.Windows.GridEX.SortOrder.Ascending); grdAssignInfo.RootTable.SortKeys.Add(gridExSortKeyGroup); grdAssignInfo.RootTable.SortKeys.Add(gridExSortKey); grdAssignInfo.CheckAllRecords(); } catch (Exception exception) { if (globalVariables.IsAdmin) { Utility.ShowMsg(exception.ToString()); } } ModifyCommand(); }
public CustomSortKey(GridEXSortKey sortKey) { this.Column = sortKey.Column; this.SortOrder = sortKey.SortOrder; }
private void LayThongTin_Chitiet_CLS() { try { m_dtAssignDetail = SPs.YhhqLaythongtinDichvuThuocVattu(-1, "DICHVU").GetDataSet().Tables[0]; //grdAssignDetail.DataSource = m_dtAssignDetail; Utility.SetDataSourceForDataGridEx(grdAssignDetail, m_dtAssignDetail, false, true, "", ""); grdAssignDetail.RootTable.SortKeys.Clear(); GridEXColumn gridExColumnGroup = grdAssignDetail.RootTable.Columns["IntOrderGroup"]; GridEXColumn gridExColumn = grdAssignDetail.RootTable.Columns["IntOrder"]; var gridExSortKeyGroup = new GridEXSortKey(gridExColumnGroup, SortOrder.Ascending); var gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending); grdAssignDetail.RootTable.SortKeys.Add(gridExSortKeyGroup); grdAssignDetail.RootTable.SortKeys.Add(gridExSortKey); grdAssignDetail.MoveFirst(); } catch (Exception) { } }
private void IntitalData() { try { m_dtServiceDetail = CommonBusiness.LoadDataServiceDetail_KSK("DV", -1, globalVariables.MA_KHOA_THIEN); if (!m_dtServiceDetail.Columns.Contains("Quantity")) m_dtServiceDetail.Columns.Add("Quantity", typeof (int)); if (!m_dtServiceDetail.Columns.Contains("Unit_Name")) m_dtServiceDetail.Columns.Add("Unit_Name", typeof (string)); // ProcessData(ref m_dtServiceDetail); Utility.AddColumToDataTable(ref m_dtServiceDetail, "ShortName", typeof (string)); IEnumerable<DataRow> query = from r in globalVariables.g_dtMeasureUnit.Rows.Cast<DataRow>() where r.ItemArray.All(c => c != DBNull.Value) select r; if (query.Count() <= 0) { globalVariables.g_dtMeasureUnit = CommonBusiness.LayThongTinDonViTinh(); } foreach (DataRow drv in m_dtServiceDetail.Rows) { drv["Quantity"] = 1; drv["ShortName"] = Utility.UnSignedCharacter( Utility.sDbnull(drv[LServiceDetail.Columns.ServiceDetailName]).ToUpper()); EnumerableRowCollection<string> querydvt = globalVariables.g_dtMeasureUnit.AsEnumerable().Select( dvt => new {dvt, y = Utility.sDbnull(drv["Unit_Name"])}).Where( @t => Utility.Int32Dbnull(@t.dvt["Unit_ID"]) == Utility.Int32Dbnull(drv["Unit_ID"], -1)) .Select(@t => @t.y); if (querydvt.Any()) { drv["Unit_Name"] = Utility.sDbnull(querydvt.FirstOrDefault(), ""); } } m_dtServiceDetail.AcceptChanges(); GridEXColumn gridExColumnGroup = grdServiceDetail.RootTable.Columns["GroupIntOrder"]; GridEXColumn gridExColumn = grdServiceDetail.RootTable.Columns["sIntOrder"]; var gridExSortKeyGroup = new GridEXSortKey(gridExColumnGroup, SortOrder.Ascending); var gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending); grdServiceDetail.RootTable.SortKeys.Add(gridExSortKeyGroup); grdServiceDetail.RootTable.SortKeys.Add(gridExSortKey); Utility.SetDataSourceForDataGridEx(grdServiceDetail, m_dtServiceDetail, false, true, "", ""); //grdServiceDetail.RootTable.SortKeys.Clear(); grdServiceDetail.MoveFirst(); grdServiceDetail.RootTable.Columns["sIntOrder"].Visible = globalVariables.IsAdmin; // Janus.Windows.GridEX.GridEXColumn gridExColumnThuTu = grdServiceDetail.RootTable.Columns["sIntOrder"]; Utility.VisiableGridEx(grdServiceDetail, "sIntOrder", globalVariables.IsAdmin); txtFilterName.Focus(); txtFilterName.SelectAll(); } catch (Exception exception) { Utility.ShowMsg("Lỗi trong quá trình load thông tin :" + exception); } }
private void getData() { m_dtChiDinhCLS = null; //SPs.ClsLaokhoaInphieuChidinhCls(objAssignInfo.AssignCode, Utility.sDbnull(objAssignInfo.PatientCode), // Utility.Int32Dbnull(objAssignInfo.PatientId,-1)).GetDataSet().Tables[0]; Utility.AddColumToDataTable(ref m_dtChiDinhCLS,"STT",typeof(Int32)); Int32 idx = 1; foreach (DataRow drv in m_dtChiDinhCLS.Rows) { drv["STT"] = idx; idx++; } m_dtChiDinhCLS.AcceptChanges(); Utility.SetDataSourceForDataGridEx(grdAssignInfo, m_dtChiDinhCLS,false,true,"1=1",""); try { grdAssignInfo.RootTable.SortKeys.Clear(); Janus.Windows.GridEX.GridEXColumn gridExColumnGroup = grdAssignInfo.RootTable.Columns["IntOrderGroup"]; Janus.Windows.GridEX.GridEXColumn gridExColumn = grdAssignInfo.RootTable.Columns["IntOrder"]; Janus.Windows.GridEX.GridEXSortKey gridExSortKeyGroup = new GridEXSortKey(gridExColumnGroup, Janus.Windows.GridEX.SortOrder.Ascending); Janus.Windows.GridEX.GridEXSortKey gridExSortKey = new GridEXSortKey(gridExColumn, Janus.Windows.GridEX.SortOrder.Ascending); grdAssignInfo.RootTable.SortKeys.Add(gridExSortKeyGroup); grdAssignInfo.RootTable.SortKeys.Add(gridExSortKey); grdAssignInfo.CheckAllRecords(); } catch (Exception exception) { if (globalVariables.IsAdmin) { Utility.ShowMsg(exception.ToString()); } } ModifyCommand(); }
private void GetDataPresDetail() { int stock_id = -1; if(HisDuocProperties.KieuDuyetDonThuoc=="DONTHUOC") { stock_id = Utility.Int32Dbnull(grdPres.GetValue(TPrescription.Columns.StockId)); } else { stock_id = Utility.Int32Dbnull(cboKho.SelectedValue); } m_dtDataPresDetail = SPs.DuocLaythongtinDonthuocLinhthuoc(Pres_ID, stock_id).GetDataSet().Tables[0]; if (!m_dtDataPresDetail.Columns.Contains("CHON")) m_dtDataPresDetail.Columns.Add("CHON", typeof(int)); foreach (DataRow dr in m_dtDataPresDetail.Rows) { dr["CHON"] = 0; } m_dtDataPresDetail.AcceptChanges(); string _rowFilter = string.Format("Pres_ID={0}", Pres_ID); Utility.SetDataSourceForDataGridEx(grdPresDetail, m_dtDataPresDetail, false, true, "1=1", TPrescriptionDetail.Columns.ThuTuIn); Janus.Windows.GridEX.GridEXColumn gridExColumn = grdPresDetail.RootTable.Columns[TPrescriptionDetail.Columns.ThuTuIn]; Janus.Windows.GridEX.GridEXSortKey gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending); grdPresDetail.RootTable.SortKeys.Add(gridExSortKey); // grdPresDetail.DataSource = p_dtPresDetail.DefaultView; ///thực hiện việc thay đổi khi load thông tin của thành tiền UpdateDataWhenChanged(); ModifyCommnad(); }