/// <summary>
/// 血糖数据绑定
/// </summary>
/// <param name="dtBloodGluRecord">血糖数据</param>
public void BindBloodGluRecord(DataTable dtBloodGluRecord)
{
try
{
GridViewResult.Stop();
this.Cursor = Cursors.WaitCursor;
Dictionary <string, object> myDictionary = new Dictionary <string, object>();
int rowindex = dgvPatInfo.CurrentCell.RowIndex;
DataTable dt = (DataTable)dgvPatInfo.DataSource;
myDictionary.Add("医院名称", (InvokeController("this") as AbstractController).LoginUserInfo.WorkName);
myDictionary.Add("科室", dt.Rows[rowindex]["deptName"]);
myDictionary.Add("姓名", dt.Rows[rowindex]["PatName"]);
myDictionary.Add("性别", dt.Rows[rowindex]["PatSex"]);
myDictionary.Add("年龄", GetAge(dt.Rows[rowindex]["Age"].ToString()));
myDictionary.Add("床号", dt.Rows[rowindex]["BedNo"]);
myDictionary.Add("住院号", dt.Rows[rowindex]["SerialNumber"]);
gridreport = new GridReport();
gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 3205, 0, myDictionary, dtBloodGluRecord);
GridViewResult.Report = gridreport.Report;
GridViewResult.Start();
GridViewResult.Refresh();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender">控件对象</param>
/// <param name="e">事件参数</param>
private void BtnQuery_Click(object sender, EventArgs e)
{
try
{
GridViewResult.Stop();
this.Cursor = Cursors.WaitCursor;
DateTime bdate = Convert.ToDateTime(sdtDate.Bdate.Value.ToString("yyyy-MM-dd 00:00:00"));
DateTime edate = Convert.ToDateTime(sdtDate.Edate.Value.ToString("yyyy-MM-dd 23:59:59"));
int queryWorkId = Convert.ToInt32(cmbWorker.SelectedValue);
int queryTimeType = cmbTimeType.SelectedIndex;//0收费时间 1缴款时间
int rowGroupType = cmbRowGroupType.SelectedIndex;
int colGroupType = cmbColGroupType.SelectedIndex;
string currentUserName = (string)InvokeController("GetCurrentUserName");
DataTable dtReport = (DataTable)InvokeController("GetFinacialOPRevenueData", frmName, bdate, edate, queryWorkId, queryTimeType, rowGroupType, colGroupType);
Dictionary <string, object> myDictionary = new Dictionary <string, object>();
myDictionary.Add("Title", cmbWorker.Text.Trim() + "门诊收入统计");
myDictionary.Add("DateRange", sdtDate.Bdate.Value.ToString("yyyy-MM-dd") + "至" + sdtDate.Edate.Value.ToString("yyyy-MM-dd"));
myDictionary.Add("Printer", currentUserName);
gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 2006, 0, myDictionary, dtReport);
gridreport.Report.Initialize += new _IGridppReportEvents_InitializeEventHandler(ReportInitialize);
GridViewResult.Report = gridreport.Report;
GridViewResult.Start();
GridViewResult.Refresh();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender">控件对象</param>
/// <param name="e">事件参数</param>
private void BtnQuery_Click(object sender, EventArgs e)
{
try
{
GridViewResult.Stop();
this.Cursor = Cursors.WaitCursor;
DateTime bdate = Convert.ToDateTime(sdtDate.Bdate.Value.ToString("yyyy-MM-dd 00:00:00"));
DateTime edate = Convert.ToDateTime(sdtDate.Edate.Value.ToString("yyyy-MM-dd 23:59:59"));
int queryWorkId = Convert.ToInt32(cmbWorker.SelectedValue);
string currentUserName = (string)InvokeController("GetCurrentUserName");
DataTable dtReport = (DataTable)InvokeController("GetFinacialDispenseData", frmName, bdate, edate, queryWorkId);
Dictionary <string, object> myDictionary = new Dictionary <string, object>();
myDictionary.Add("Title", cmbWorker.Text.Trim() + "发药人员工作量统计");
myDictionary.Add("DateRange", sdtDate.Bdate.Value.ToString("yyyy-MM-dd") + "至" + sdtDate.Edate.Value.ToString("yyyy-MM-dd"));
myDictionary.Add("Printer", currentUserName);
GridReport gridreport = new GridReport();
gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 4019, 0, myDictionary, dtReport);
GridViewResult.Report = gridreport.Report;
GridViewResult.Start();
GridViewResult.Refresh();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender">控件对象</param>
/// <param name="e">事件参数</param>
private void BtnQuery_Click(object sender, EventArgs e)
{
try
{
GridViewResult.Stop();
this.Cursor = Cursors.WaitCursor;
DateTime bdate = dtTimer.Bdate.Value;
DateTime edate = dtTimer.Edate.Value;
int queryWorkId = Convert.ToInt32(cbbWork.SelectedValue);
string queryTimeType = Convert.ToString(cbbTimeType.SelectedValue);
string qyeryDocType = Convert.ToString(cbbDocType.SelectedValue);
string currentUserName = (string)InvokeController("GetCurrentUserName");
DataTable dtReport = (DataTable)InvokeController("QueryInpatientWorkLoad", queryWorkId, bdate.ToString("yyyy-MM-dd 00:00:00"), edate.ToString("yyyy-MM-dd 23:59:59"), qyeryDocType, queryTimeType);
Dictionary <string, object> myDictionary = new Dictionary <string, object>();
myDictionary.Add("Title", cbbWork.Text.Trim() + "住院医生工作量统计");
myDictionary.Add("DateRange", dtTimer.Bdate.Value.ToString("yyyy-MM-dd") + "至" + dtTimer.Edate.Value.ToString("yyyy-MM-dd"));
myDictionary.Add("Printer", currentUserName);
myDictionary.Add("DocType", "医生类型:" + cbbDocType.Text);
myDictionary.Add("TimeType", "时间类型:" + cbbTimeType.Text);
GridReport gridreport = new GridReport();
gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 3011, 0, myDictionary, dtReport);
GridViewResult.Report = gridreport.Report;
GridViewResult.Start();
GridViewResult.Refresh();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// 加载数据
/// </summary>
/// <param name="dtData">统计数据</param>
public void LoadData(DataTable dtData)
{
Dictionary <string, object> myDictionary = new Dictionary <string, object>();
myDictionary.Add("Title", cmbWorker.Text.Trim() + "药品医生开方统计");
myDictionary.Add("DateRange", sdtDate.Bdate.Value.ToString("yyyy-MM-dd") + "至" + sdtDate.Edate.Value.ToString("yyyy-MM-dd"));
myDictionary.Add("Printer", (InvokeController("this") as AbstractController).LoginUserInfo.EmpName);
gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 6001, 0, myDictionary, dtData);
GridViewResult.Report = gridreport.Report;
GridViewResult.Start();
GridViewResult.Refresh();
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender">控件对象</param>
/// <param name="e">事件参数</param>
private void BtQuery_Click(object sender, EventArgs e)
{
if (txtItem.Text == string.Empty)
{
MessageBoxEx.Show("请选择查询项目!", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if ((Convert.ToInt16(cbbPatType.SelectedValue) == 1) && (Convert.ToString(cbbTimeType.SelectedValue) == "ChargeDate"))
{
MessageBoxEx.Show("门诊类型按记帐时间统计单项目收入!", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int workID = Convert.ToInt32(cmbWork.SelectedValue);
DateTime queryDate = dtTimer.Value;
int patType = Convert.ToInt32(cbbPatType.SelectedValue);
string timeType = Convert.ToString(cbbTimeType.SelectedValue);
string itemInfo = ItemID;
try
{
GridViewResult.Stop();
this.Cursor = Cursors.WaitCursor;
string currentUserName = (string)InvokeController("GetCurrentUserName");
DataTable dtReport = (DataTable)InvokeController("GetItmeItemStatistics", workID, queryDate, patType, timeType, itemInfo);
Dictionary <string, object> myDictionary = new Dictionary <string, object>();
myDictionary.Add("TjTime", "统计时间：" + dtTimer.Value.ToString("yyyy-MM"));
myDictionary.Add("Printer", "制表人：" + currentUserName);
myDictionary.Add("PrintTime", "制表时间：" + DateTime.Now.ToString("yyyy-MM-dd"));
myDictionary.Add("ItemName", txtItem.Text);
GridReport gridreport = new GridReport();
gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 2009, 0, myDictionary, dtReport);
GridViewResult.Report = gridreport.Report;
GridViewResult.Start();
GridViewResult.Refresh();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender">控件对象</param>
/// <param name="e">事件参数</param>
private void BtnQuery_Click(object sender, EventArgs e)
{
try
{
GridViewResult.Stop();
this.Cursor = Cursors.WaitCursor;
DateTime bdate = Convert.ToDateTime(sdtDate.Bdate.Value.ToString("yyyy-MM-dd 00:00:00"));
DateTime edate = Convert.ToDateTime(sdtDate.Edate.Value.ToString("yyyy-MM-dd 23:59:59"));
int queryWorkId = Convert.ToInt32(cmbWorker.SelectedValue);
int queryTimeType = cmbTimeType.SelectedIndex;//0收费时间 1缴款时间
string currentUserName = (string)InvokeController("GetCurrentUserName");
DataTable dtReport = (DataTable)InvokeController("GetFinacialOPDoctorData", frmName, bdate, edate, queryWorkId, queryTimeType);
Dictionary <string, object> myDictionary = new Dictionary <string, object>();
myDictionary.Add("Title", cmbWorker.Text.Trim() + "门诊医生工作量统计");
myDictionary.Add("DateRange", sdtDate.Bdate.Value.ToString("yyyy-MM-dd") + "至" + sdtDate.Edate.Value.ToString("yyyy-MM-dd"));
myDictionary.Add("Printer", currentUserName);
if (dtReport.Rows.Count > 0)
{
decimal allDrugFee = Convert.ToDecimal(dtReport.Compute("sum(DrugFee)", string.Empty));
decimal allMeterialFee = Convert.ToDecimal(dtReport.Compute("sum(MeterialFee)", string.Empty));
decimal allFee = Convert.ToDecimal(dtReport.Compute("sum(TotalFee)", string.Empty));
myDictionary.Add("AllDrugFeePerCent", allDrugFee / allFee);
myDictionary.Add("AllMeterailFeePerCent", allMeterialFee / allFee);
}
GridReport gridreport = new GridReport();
gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 2005, 0, myDictionary, dtReport);
GridViewResult.Report = gridreport.Report;
GridViewResult.Start();
GridViewResult.Refresh();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
this.Cursor = Cursors.Default;
}
}