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();
}
