void frm_themmoi_phieuthanhlythuoc_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
cmdExit_Click(cmdExit, new EventArgs());
}
if (e.Control && e.KeyCode == Keys.S)
{
cmdSave_Click(cmdSave, new EventArgs());
}
if (e.KeyCode == Keys.F2)
{
grdKhoXuat.Focus();
grdKhoXuat.MoveFirst();
Janus.Windows.GridEX.GridEXColumn gridExColumn = grdKhoXuat.RootTable.Columns["SO_LUONG_CHUYEN"];
grdKhoXuat.Col = gridExColumn.Position;
}
if (e.KeyCode == Keys.Enter)
{
if (this.ActiveControl.Name == txtHoidong.Name)
{
return;
}
else
{
SendKeys.Send("{TAB}");
}
}
if (e.Control && e.Alt && e.Shift && e.KeyCode == Keys.Z)
{
Test();
}
}
private void UpdateSumOfChiDinh()
{
Janus.Windows.GridEX.GridEXColumn gridExColumn = grdDetail.RootTable.Columns["TT"];
Janus.Windows.GridEX.GridEXColumn gridExColumnPhuThu = grdDetail.RootTable.Columns[KcbChidinhclsChitiet.Columns.PhuThu];
decimal Thanhtien = Utility.DecimaltoDbnull(grdDetail.GetTotal(gridExColumn, AggregateFunction.Sum));
decimal phuthu = Utility.DecimaltoDbnull(grdDetail.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum));
}
void frm_themmoi_PhieutrathuocNhacungcap_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
SendKeys.Send("{TAB}");
}
if (e.KeyCode == Keys.Escape)
{
cmdExit_Click(cmdExit, new EventArgs());
}
if (e.Control && e.KeyCode == Keys.S)
{
cmdSave_Click(cmdSave, new EventArgs());
}
if (e.KeyCode == Keys.F2)
{
grdKhoXuat.Focus();
grdKhoXuat.MoveFirst();
Janus.Windows.GridEX.GridEXColumn gridExColumn = grdKhoXuat.RootTable.Columns["SO_LUONG_CHUYEN"];
grdKhoXuat.Col = gridExColumn.Position;
}
if (e.Control && e.Alt && e.Shift && e.KeyCode == Keys.Z)
{
Test();
}
}
void grdKhoXuat_KeyDown(object sender, KeyEventArgs e)
{
Janus.Windows.GridEX.GridEXColumn gridExColumn = grdKhoXuat.RootTable.Columns["SO_LUONG_CHUYEN"];
if (e.Control && e.KeyCode == Keys.Enter)// && Utility.Int32Dbnull(grdKhoXuat.GetValue(gridExColumn.Key), 0) > 0 && grdKhoXuat.CurrentColumn.Position == gridExColumn.Position)
{
grdKhoXuat.Focus();
cmdNext_Click(cmdNext, new EventArgs());
}
}
/// <summary>
/// hàm thực hiện việc phím tắt của lọc thông tin
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txtFilterName_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.PageDown)
{
grdKhoXuat.Focus();
grdKhoXuat.MoveFirst();
Janus.Windows.GridEX.GridEXColumn gridExColumn = grdKhoXuat.RootTable.Columns["SO_LUONG_CHUYEN"];
grdKhoXuat.Col = gridExColumn.Position;
}
}
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();
}
void frm_Themmoi_PhieuTrathuocThua_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
cmdExit_Click(cmdExit, new EventArgs());
}
if (e.Control && e.KeyCode == Keys.S)
{
cmdSave_Click(cmdSave, new EventArgs());
}
if (e.KeyCode == Keys.F2)
{
grdKhoXuat.Focus();
grdKhoXuat.MoveFirst();
Janus.Windows.GridEX.GridEXColumn gridExColumn = grdKhoXuat.RootTable.Columns["SO_LUONG_CHUYEN"];
grdKhoXuat.Col = gridExColumn.Position;
}
if (e.KeyCode == Keys.Enter)
{
SendKeys.Send("{TAB}");
}
//if (e.Control && e.Alt && e.Shift && e.KeyCode == Keys.Z) Test();
if (e.Control && e.Alt && e.Shift && e.KeyCode == Keys.H)
{
if (panel2.Height == 0)
{
uiGroupBox1.Height = 148;
panel2.Height = 54;
}
else
{
uiGroupBox1.Height = 0;
panel2.Height = 0;
}
}
}
/// <summary>
/// hàm thực hiện việc in phiếu xét nghiêm
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdPrint_Click(object sender, EventArgs e)
{
try
{
if (!isValidData())
{
return;
}
_reportTable =
BAOCAO_NGOAITRU.BaocaoDanhsachhoadonThuphi(chkByDate.Checked ? dtFromDate.Value : Convert.ToDateTime("01/01/1900"),
chkByDate.Checked ? dtToDate.Value : globalVariables.SysDate, chkLoaitimkiem.Checked ? 1 : 0,
Utility.sDbnull(cboDoituongKCB.SelectedValue, -1),
Utility.sDbnull(cbonhanvien.SelectedValue, -1),
Utility.Int32Dbnull(cboNTNT.SelectedValue, -1),
Utility.Int32Dbnull(cboHoadon.SelectedValue, -1), chkMaQuyen.Checked? Utility.sDbnull(cboQuyen.SelectedValue, "-1"):"-1",
Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtfromSerie.Text)), Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtToserie.Text)),
Utility.sDbnull(cbokhoa.SelectedValue, -1));
Utility.SetDataSourceForDataGridEx(grdList, _reportTable, false, true, "1=1", "");
Janus.Windows.GridEX.GridEXColumn gridExColumnTientong = grdList.RootTable.Columns["tong_Tien"];
tong_tien = Utility.Int32Dbnull(grdList.GetTotal(gridExColumnTientong, Janus.Windows.GridEX.AggregateFunction.Sum));
if (_reportTable.Rows.Count <= 0)
{
Utility.ShowMsg("Không tìm thấy dữ liệu cho báo cáo", "Thông báo", MessageBoxIcon.Warning);
return;
}
string StaffName = globalVariables.gv_strTenNhanvien;
if (string.IsNullOrEmpty(globalVariables.gv_strTenNhanvien))
{
StaffName = globalVariables.UserName;
}
string Condition = string.Format("Từ ngày {0} đến {1} - Đối tượng : {2} -TNV :{3} - Loại điều trị :{4} ", dtFromDate.Text, dtToDate.Text,
cboDoituongKCB.SelectedIndex > 0
? Utility.sDbnull(cboDoituongKCB.Text)
: "Tất cả",
cbonhanvien.SelectedIndex > 0
? Utility.sDbnull(cbonhanvien.Text)
: "Tất cả", cboNTNT.SelectedIndex > 0 ? Utility.sDbnull(cboNTNT.Text) : "Tất cả");
Utility.UpdateLogotoDatatable(ref _reportTable);
var crpt = Utility.GetReport("baocao_danhsachhoadonthuphi", ref tieude, ref reportname);
if (crpt == null)
{
return;
}
frmPrintPreview objForm = new frmPrintPreview(tieude, crpt, true, _reportTable.Rows.Count <= 0 ? false : true);
crpt.SetDataSource(_reportTable);
objForm.mv_sReportFileName = Path.GetFileName(reportname);
objForm.mv_sReportCode = "baocao_danhsachhoadonthuphi";
Utility.SetParameterValue(crpt, "StaffName", StaffName);
Utility.SetParameterValue(crpt, "BranchName", globalVariables.Branch_Name);
Utility.SetParameterValue(crpt, "ParentBranchName", globalVariables.ParentBranch_Name);
Utility.SetParameterValue(crpt, "Address", globalVariables.Branch_Address);
Utility.SetParameterValue(crpt, "Phone", globalVariables.Branch_Phone);
Utility.SetParameterValue(crpt, "FromDateToDate", Condition);
Utility.SetParameterValue(crpt, "Hienthinhom", Utility.Int32Dbnull(cboHoadon.SelectedValue, -1) == 0 ? 0 : 1);
Utility.SetParameterValue(crpt, "sTitleReport", tieude);
Utility.SetParameterValue(crpt, "sCurrentDate", Utility.FormatDateTimeWithThanhPho(dtNgayInPhieu.Value));
Utility.SetParameterValue(crpt, "BottomCondition", THU_VIEN_CHUNG.BottomCondition());
objForm.crptViewer.ReportSource = crpt;
objForm.ShowDialog();
}
catch (Exception ex)
{
Utility.CatchException("Lỗi khi in báo cáo", ex);
}
}