private void btnExport_Click(object sender, EventArgs e)
{
try
{
if (dataGridView2.DataSource == null)
{
return;
}
if (dataGridView2.Rows.Count == 0)
{
return;
}
this.Cursor = PubStaticFun.WaitCursor();
this.btnExport.Enabled = false;
ts_jc_log.ExcelOper.ExportData_ForDataTable(dataGridView2, "");
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
this.btnExport.Enabled = true;
}
}
private void treeListView1_Click(object sender, EventArgs e)
{
System.Windows.Forms.TreeListView TreeListView = (System.Windows.Forms.TreeListView)sender;
try
{
this.Cursor = PubStaticFun.WaitCursor();
TreeListViewItem item = (TreeListViewItem)TreeListView.SelectedItems[0];
string pid = "";
if (item.Text != "门诊事件")
{
pid = item.Text;
}
string Event = item.Text;
int finish = this.radioButton1.Checked == true ? 0 : 1;
handle.GetMzEventlog(pid, this.dateTimePicker1.Value.ToString("yyyy-MM-dd").ToString() + " 00:00:00",
this.dateTimePicker2.Value.ToString("yyyy-MM-dd").ToString() + " 23:59:59", txtevent.Text.Trim(), txtbizid.Text.Trim(), false, finish, this.dgveventlog);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void btnRefresh_Click(object sender, System.EventArgs e)
{
dgWard.DataSource = null;
dgPat.DataSource = null;
dgList.DataSource = null;
dgWard.CaptionText = "病区收入";
dgPat.CaptionText = "病人费用";
dgList.CaptionText = "费用明细";
if (cmbDept.Text.Trim() == "")
{
MessageBox.Show("请选择一个科室！");
return;
}
Cursor.Current = PubStaticFun.WaitCursor();
string sSql = "exec sp_zyhs_selkssr '" + dtpBegin.Value + "','" + dtpEnd.Value + "'," + cmbDept.SelectedValue;
dataTb = InstanceForm.BDatabase.GetDataTable(sSql);
wardTb = dataTb.Clone();
DataRow[] drM = dataTb.Select("病区='合 计'");
foreach (DataRow dr in drM)
{
wardTb.Rows.Add(dr.ItemArray);
}
dgWard.DataSource = wardTb;
Cursor.Current = Cursors.Default;
}
private void bt查询_Click(object sender, System.EventArgs e)
{
this.GetData1();
Cursor.Current = PubStaticFun.WaitCursor();
this.Show_data(true);
Cursor.Current = Cursors.Default;
}
private void dgPat_CurrentCellChanged(object sender, System.EventArgs e)
{
dgList.DataSource = null;
dgList.CaptionText = "费用明细";
int nrow = dgPat.CurrentCell.RowNumber;
dgPat.Select(nrow);
Guid sInpatientId = new Guid(dgPat[nrow, 6].ToString().Trim());
if (sInpatientId != Guid.Empty)
{
Cursor.Current = PubStaticFun.WaitCursor();
dgList.CaptionText += " [病区：" + dgPat[nrow, 1].ToString() + " 住院号：" + dgPat[nrow, 4].ToString() + " 姓名：" + dgPat[nrow, 5].ToString() + "]";
string sSql = "select a.subcode as 项目代码, " +
" a.item_name 项目名称, " +
" a.retail_price 单价,a.num*a.dosage 数量,a.acvalue 金额,a.charge_date 记帐日期,dbo.fun_getempname(a.charge_user) 记帐人, " +
" dbo.fun_getdeptname(a.execdept_id) 执行科室,c.item_name 项目类别 " +
" from (select * from (select * from zy_fee_speci union all select * from zy_fee_speci_h) a where inpatient_id='" + sInpatientId + "' and charge_bit=1 and delete_bit=0" +
" and charge_date >= '" + dtpBegin.Value.ToShortDateString() + " 00:00:00' and charge_date < '" + dtpEnd.Value.AddDays(1).ToShortDateString() + " 00:00:00' and dept_id=" + cmbDept.SelectedValue + ") a" +
" inner join jc_stat_item c" +
" on a.statitem_code=c.code" +
" order by c.code,charge_date";
DataTable myTb = InstanceForm.BDatabase.GetDataTable(sSql);
dgList.DataSource = myTb;
}
Cursor.Current = Cursors.Default;
}
private void btnExcel_Click(object sender, EventArgs e)
{
try
{
if (dgvList.DataSource == null)
{
return;
}
if (dgvList.Rows.Count == 0)
{
return;
}
this.Cursor = PubStaticFun.WaitCursor();
this.btnExcel.Enabled = false;
ExportToExcel();
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
this.btnExcel.Enabled = true;
}
}
private void Show_Data()
{
Cursor.Current = PubStaticFun.WaitCursor();
//条件：开医嘱时间小于等于查询时间 && (最大执行日期小于查询时间 || 没有执行过的）
DataTable myTb = new DataTable();
DataTable patTb = InstanceForm.BDatabase.GetDataTable("select inpatient_id,baby_id from vi_zy_vinpatient_bed where ward_id='" + InstanceForm.BCurrentDept.WardId + "' order by bed_no");
DataTable tmpTb = new DataTable();
progressBar1.Maximum = patTb.Rows.Count;
progressBar1.Minimum = 0;
progressBar1.Value = 0;
//循环病区病人
for (int i = 0; i < patTb.Rows.Count; i++)
{
tmpTb.Clear();
tmpTb = myFunc.GetBinOrdrs("", new Guid(patTb.Rows[i]["inpatient_id"].ToString()), Convert.ToInt64(patTb.Rows[i]["baby_id"].ToString()), 0, 2, 0, this.DateExecDate.Value, InstanceForm.BCurrentDept.WardId, 0);
if (i == 0)
{
myTb = tmpTb.Clone();
}
for (int j = 0; j < tmpTb.Rows.Count; j++)
{
// DataRow dr = myTb.NewRow();
// for(int k=0;k<tmpTb.Columns.Count;k++)
// {
// dr[k]=tmpTb.Rows[j][k];
// }
// myTb.Rows.Add(dr);
myTb.Rows.Add(tmpTb.Rows[j].ItemArray);
}
progressBar1.Value += 1;
}
// myTb=myFunc.GetBinOrdrs("",ClassStatic.Current_BinID,Convert.ToInt32(ClassStatic.Current_BabyID),0,2,0,this.DateExecDate.Value,InstanceForm.BCurrentDept.WardId);
DataColumn col = new DataColumn();
col.DataType = System.Type.GetType("System.Boolean");
col.AllowDBNull = false;
col.ColumnName = "选";
col.DefaultValue = false;
myTb.Columns.Add(col);
this.myDataGrid1.DataSource = myTb;
this.myDataGrid1.TableStyles[0].RowHeaderWidth = 5;
CheckGrdData(myTb);
this.myDataGrid1.DataSource = myTb;
this.priceInfo1.ClearYpInfo();
this.Show_Patient();
progressBar1.Value = 0;
Cursor.Current = Cursors.Default;
}
//Add By Tany 2015-04-28 增加多诊断录入
private void btManyZD_Click(object sender, EventArgs e)
{
Cursor = PubStaticFun.WaitCursor();
try
{
ArrayList arrList = new ArrayList();
arrList.Add(BinID);
arrList.Add(lblZyh.Text.ToString());
arrList.Add(BabyID);
arrList.Add(ybjklx);
arrList.Add(yblx);
arrList.Add("");
FrmMultipleDiagnostic frmMD = new FrmMultipleDiagnostic(arrList);
frmMD.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Cursor = Cursors.Arrow;
}
}
private void butexcel_Click(object sender, EventArgs e)
{
if (dgvData.DataSource == null)
{
return;
}
try
{
this.Cursor = PubStaticFun.WaitCursor();
this.btnExcel.Enabled = false;
DataTable tb = dgvData.DataSource as DataTable;
string swhere = string.Format("科室名称：{0} 医保类型：{1} 收费员：{2} 收费时间：{3} 到 {4}", cmbksmc.Text, cmbyblx.Text, cmbsfy.Text, dtp1.Text, dtp2.Text);
ExportToExcel(tb, Constant.HospitalName + " " + this.Text, swhere);
}
catch (System.Exception ex)
{
MessageBox.Show("导出Excel时发生错误：" + Environment.NewLine + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
this.Cursor = Cursors.Default;
this.btnExcel.Enabled = true;
}
}
private void FrmPvsCancelScn_Load(object sender, EventArgs e)
{
Cursor.Current = PubStaticFun.WaitCursor();
this.myDataGrid1.Enabled = true;
this.ShowData();
this.myDataGrid1.TableStyles[0].GridColumnStyles.Clear();
string[] GrdMappingName = { "选", "医嘱日期", "频次", "内容", "规格", "数量", "单位", "次数", "剂数", "单价", "金额",
"发送信息", "执行科室", "记账信息", "发药信息", "记账类型", "charge_bit", "finish_bit", "delete_bit",
"Order_ID", "ID", "EXECDEPT_ID", "dept_br", "dept_id", "item_code", "day1", "day2", "发送护士", "记账员",
"基数药", "isJZ", "jz_flag", "DISCHARGE_BIT", "名称", "iskdksly", "xmly", //36
"发药单号",
"药品批次", "药品批号",
"发药时间", "发药人", "领药科室", "领药类型", "操作人", "操作时间", "type", "statitem_code", "转打包" };//名称是给汇总用的//Add By Tany 2010-12-15 增加statitem_code
int[] GrdWidth = { 2, 10, 4, 24, 10, 6, 6, 4, 4, 8, 8, 12, 10, 12, 12, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8,
8, 8
, 15, 8, 10, 8, 8, 15, 0, 0, 6 };
int[] Alignment = { 0, 0, 0, 0, 0, 2, 1, 2, 2, 2, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2,
2, 2
, 0, 2, 0, 0, 0, 0, 0, 0, 0 };
int[] ReadOnly = { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 };
this.InitGridYZ(GrdMappingName, GrdWidth, Alignment, ReadOnly, this.myDataGrid1);
PubStaticFun.ModifyDataGridStyle(myDataGrid1, 0);//去掉网格
Cursor.Current = Cursors.Default;
}
private void butnew_Click(object sender, System.EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
this.buttask.Visible = true;
Frmpdsh f = new Frmpdsh(_menuTag, _chineseName, _mdiParent);
Point point = new Point(160, 75);
f.Location = point;
f.MdiParent = _mdiParent;
f.Show();
//f.Add_sum_pdcsmx();
this.buttask.Visible = false;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void tabControl1_Click(object sender, EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
computeTld("");
if (this.tabControl1.SelectedTab == this.tabPage2)
{
this.butprinthz.Enabled = true;
}
else
{
this.butprinthz.Enabled = false;
}
}
catch (System.Exception err)
{
DataTable tb = (DataTable)this.myDataGrid2.DataSource;
tb.Rows.Clear();
MessageBox.Show(this, "发生错误" + err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btncx_Click(object sender, EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
//查询条件
int deptid = Convert.ToInt32(this.combdept.SelectedValue);
string starttime = this.dateTimePicker1.Value.ToShortDateString();
string endtime = this.dateTimePicker2.Value.ToShortDateString();
bool showxtcz = false;
if (this.checkBox1.Checked)
{
showxtcz = true;
}
DataTable tb = czDataAccess.GetCZStatistics(deptid, starttime, endtime, showxtcz);
this.dataGridView1.DataSource = tb;
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
MessageBox.Show(ex.Message);
}
finally { this.Cursor = Cursors.Default; }
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
this.buttj.Enabled = false;
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Value = Convert.ToInt32(cmbyjks.SelectedValue);
parameters[1].Value = dtp1.Value.ToShortDateString() + " 00:00:00";
parameters[2].Value = dtp2.Value.ToShortDateString() + " 23:59:59";
parameters[0].Text = "@deptid";
parameters[1].Text = "@rq1";
parameters[2].Text = "@rq2";
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_YF_TJ_PDRate", parameters, 30);
FunBase.AddRowtNo(tb);
this.myDataGrid1.DataSource = tb;
}
catch
{
}
finally
{
this.buttj.Enabled = true;
this.Cursor = Cursors.Arrow;
}
}
private void buttj_Click(object sender, System.EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
this.buttj.Enabled = false;
if (Convertor.IsNumeric(Convertor.IsNull(txtnum1.Text, "0")) == false ||
Convertor.IsNumeric(Convertor.IsNull(txtnum2.Text, "0")) == false)
{
MessageBox.Show("销售范围请输入数字", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int ntype = 2;//全院
if (rdo1.Checked == true)
{
ntype = 0; //门诊
}
if (rdo2.Checked == true)
{
ntype = 1; //住院
}
int ntype1 = rdoje.Checked == true ? 1 : 0; //数量 金额
ParameterEx[] parameters = new ParameterEx[7];
parameters[0].Value = ntype;
parameters[1].Value = ntype1;
parameters[2].Value = dtp1.Value.ToShortDateString();
parameters[3].Value = dtp2.Value.ToShortDateString();
parameters[4].Value = Convert.ToDecimal(Convertor.IsNull(txtnum1.Text, "0"));
parameters[5].Value = Convert.ToDecimal(Convertor.IsNull(txtnum2.Text, "0"));
parameters[6].Value = Convert.ToInt32(cmbyplx.SelectedValue);
parameters[0].Text = "@type";
parameters[1].Text = "@type1";
parameters[2].Text = "@dtp1";
parameters[3].Text = "@dtp2";
parameters[4].Text = "@num1";
parameters[5].Text = "@num2";
parameters[6].Text = "@yplx";
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_Yf_tj_zxyptj", parameters, 30);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
this.myDataGrid1.DataSource = tb;
this.buttj.Enabled = true;
}
catch (System.Exception err)
{
this.buttj.Enabled = true;
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void butref_Click(object sender, System.EventArgs e)
{
try
{
int yplx = Convert.ToInt32(cmbyplx.SelectedValue);
this.Cursor = PubStaticFun.WaitCursor();
this.butref.Enabled = false;
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Value = Convert.ToInt16(rdo1.Checked);
parameters[1].Value = yplx;
parameters[2].Value = Convert.ToInt32(Convertor.IsNull(cmbck.SelectedValue, "0"));
parameters[0].Text = "@type";
parameters[1].Text = "@yplx";
parameters[2].Text = "@deptid";
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_YK_tj_kcsxx", parameters, 30);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
this.myDataGrid1.DataSource = tb;
this.butref.Enabled = true;
}
catch (System.Exception err)
{
this.butref.Enabled = true;
MessageBox.Show("发生错误" + err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
void combWard_SelectedIndexChanged(object sender, EventArgs e)
{
Cursor.Current = PubStaticFun.WaitCursor();
try
{
if (this.combWard.SelectedValue.ToString().Trim() != "9999")
{
BedTball.DefaultView.RowFilter = " WARD_ID='" + this.combWard.SelectedValue + "'";
BedTb = BedTball.DefaultView.ToTable();
InitView(1, 1);
}
else
{
BedTball.DefaultView.RowFilter = " ";
BedTb = BedTball.DefaultView.ToTable();
InitView(1, 1);
}
tj(this.combWard.SelectedValue.ToString());
this.combCwlx.SelectedIndexChanged -= new EventHandler(combCwlx_SelectedIndexChanged);
this.combCwlx.SelectedIndex = 0;
this.combCwlx.SelectedIndexChanged += new EventHandler(combCwlx_SelectedIndexChanged);
this.serchText1.textBox1.Text = "";
}
catch
{ }
finally
{
GC.Collect();
Cursor.Current = Cursors.Default;
}
}
private void buttj_Click(object sender, System.EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
this.buttj.Enabled = false;
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Value = dtp1.Value.ToShortDateString() + " 00:00:00";
parameters[1].Value = dtp2.Value.ToShortDateString() + " 23:59:59";
parameters[2].Value = Convert.ToInt32(cmbyjks.SelectedValue);
parameters[3].Value = "0";
parameters[0].Text = "@rq1";
parameters[1].Text = "@rq2";
parameters[2].Text = "@yplx";
parameters[3].Text = "@ksGroup";
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_YF_TJ_SfFyCftj", parameters, 600);
FunBase.AddRowtNo(tb);
tb.TableName = "Tb";
this.myDataGrid1.DataSource = tb;
this.buttj.Tag = parameters[2].Value;//药剂科室
this.buttj.Enabled = true;
}
catch (System.Exception err)
{
this.buttj.Enabled = true;
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void dataGridView2_MouseDoubleClick(object sender, MouseEventArgs e)
{
this.Cursor = PubStaticFun.WaitCursor();
try
{
string inpatient_id = ((DataTable)this.dataGridView2.DataSource).Rows[this.dataGridView2.CurrentCell.RowIndex]["inpatient_id"].ToString();
string baby_id = ((DataTable)this.dataGridView2.DataSource).Rows[this.dataGridView2.CurrentCell.RowIndex]["baby_id"].ToString();
//获得费用
string ss = "select cast( row_number() over(order by a.xmid ) as varchar) xh,ITEM_NAME zfxmmc,sum(NUM) sl,min(COST_PRICE) dj, isnull(b.ZFBL,1) zfbl,isnull(b.ZFBL,1)*sum(SDVALUE) zfje "
+ ",'' jsqm,c.name bz1,(select config from jc_config where id=2) bz2,CUR_DEPT_NAME bz3,ryzd bz4,'' bz5,'' bz6,'' bz7 "
+ " from ZY_FEE_SPECI a left join JC_YB_BL b on a.XMID=b.XMID and a.XMLY=b.XMLY "
+ " left join vi_zy_vinpatient_all c on a.inpatient_id=c.inpatient_id and a.baby_id=c.baby_id "
+ " where a.CHARGE_BIT=1 and a.DELETE_BIT=0 and DISCHARGE_BIT=0 and SDVALUE!=0 and isnull(b.ZFBL,1)<>0 "
+ " and a.inpatient_id='" + inpatient_id + "'and a.baby_id=" + baby_id + " group by a.XMID ,a.XMLY,a.ITEM_NAME,b.ZFBL,c.name,c.CUR_DEPT_NAME,c.ryzd ";
DataTable tbfee = FrmMdiMain.Database.GetDataTable(ss);
ts_zyhs_fyxx.DataSet1.tabZfxmqdDataTable tbzfxm = new DataSet1.tabZfxmqdDataTable();
//for(int i=0;i<tbfee.Rows.Count;)
ParameterEx[] pa = new ParameterEx[4];
pa[0].Text = "hzxm";
pa[0].Value = ((DataTable)this.dataGridView2.DataSource).Rows[this.dataGridView2.CurrentCell.RowIndex]["name"].ToString();
pa[1].Text = "yymc";
pa[1].Value = TrasenFrame.Classes.Constant.HospitalName;
pa[2].Text = "ksmc";
pa[2].Value = ((DataTable)this.dataGridView2.DataSource).Rows[this.dataGridView2.CurrentCell.RowIndex]["CUR_DEPT_NAME"].ToString();
pa[3].Text = "ryzd";
pa[3].Value = ((DataTable)this.dataGridView2.DataSource).Rows[this.dataGridView2.CurrentCell.RowIndex]["ryzd"].ToString();
ReportDocument rptdoc = new ReportDocument();
string ss1 = Constant.CustomDirectory;
try
{
rptdoc.Load(Constant.CustomDirectory + "\\Report\\zyhs_医保自费项目同意签字单.rpt");
}
catch
{
rptdoc.Load(Constant.ApplicationDirectory + "\\Report\\zyhs_医保自费项目同意签字单.rpt");
}
//for (int i = 0; i < pa.Length; i++)
//{
// rptdoc.SetParameterValue(pa[i].Text, pa[i].Value.ToString());
//}
rptdoc.SetDataSource(tbfee);
// rptdoc.PrintOptions.PrinterName = prtdoc.PrinterSettings.PrinterName;
// DataTable tb=ts_zyhs_fyxx.tabZfxm
this.crystalReportViewer1.ReportSource = rptdoc;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.Cursor = Cursors.Default;
}
private void btnSelect_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
try
{
this.Cursor = PubStaticFun.WaitCursor();
btnSelect.Enabled = false;
int tjlx = 0;
if (rdozy.Checked == true)
{
tjlx = 2;
}
if (rdomz.Checked == true)
{
tjlx = 1;
}
ParameterEx[] parameters = new ParameterEx[6];
parameters[0].Value = dtp1.Value.ToShortDateString() + "";
parameters[1].Value = dtp2.Value.ToShortDateString() + "";
parameters[2].Value = Convertor.IsNull(txtks.Tag, "0");
parameters[3].Value = Convertor.IsNull(txtys.Tag, "0");
parameters[4].Value = tjlx;
parameters[0].Text = "@rq1";
parameters[1].Text = "@rq2";
parameters[2].Text = "@ksdm";
parameters[3].Text = "@ysdm";
parameters[4].Text = "@tjlx";
parameters[5].Text = "@bz";
parameters[5].ParaDirection = ParameterDirection.Output;
parameters[5].ParaSize = 100;
DataSet dset = new DataSet();
InstanceForm.BDatabase.AdapterFillDataSet("SP_YP_KSSZB_TJ", parameters, dset, "kss", 30);
dset.Tables[0].TableName = "Tb";
this.dataGridView1.DataSource = dset.Tables[0];
Fun.AddRowtNo(dset.Tables[0]);
btnSelect.Enabled = true;
}
catch (System.Exception err)
{
btnSelect.Enabled = true;
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
Cursor = PubStaticFun.WaitCursor();
ParameterEx[] parameters = new ParameterEx[9];
parameters[0].Text = "@TJFS";
parameters[0].Value = rbJkrq.Checked ? 0 : 1;
parameters[1].Text = "@rq1";
parameters[1].Value = dtp1.Value.ToString();
parameters[2].Text = "@rq2";
parameters[2].Value = dtp2.Value.ToString();
parameters[3].Text = "@jky";
parameters[3].Value = Convert.ToInt32(Convertor.IsNull(cmbuser.SelectedValue, "0"));
parameters[4].Text = "@KS";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbDept.SelectedValue, "0"));
int zffs = Convert.ToInt32(cmbZffs.SelectedValue);
parameters[5].Text = "@ZFFS";
parameters[5].Value = zffs;
//Modify By Kevin 2014-03-11
//Begin
parameters[6].Text = "@SBILLNO";
parameters[6].Value = txtSBillNo.Text.Trim();
parameters[7].Text = "@EBILLNO";
parameters[7].Value = txtEBillNo.Text.Trim();
//End
//Modify By Tany 2011-12-06 增加机构编码过滤
parameters[8].Text = "@JGBM";
parameters[8].Value = FrmMdiMain.Jgbm;
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_ZY_TJ_YJJTJ", parameters, 120);
AddRowtNo(tb);
if (tb.Rows.Count > 0)
{
tb.Rows[tb.Rows.Count - 1]["序号"] = "合计";
}
this.dataGridView1.DataSource = tb;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
private void Frmyjqr_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.F5)
{
Cursor.Current = PubStaticFun.WaitCursor();
btref_Click(sender, e);
Cursor.Current = Cursors.Default;
}
}
private void printbutt_Click(object sender, EventArgs e)
{
Cursor.Current = PubStaticFun.WaitCursor();
DataTable myTb = (DataTable)this.dataGridView1.DataSource;
if (myTb == null || myTb != null && myTb.Rows.Count < 1)
{
MessageBox.Show(this, "没有数据，不能打印", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
rds.Tables["MZFPDY"].Clear();
DataRow dr;
int flag = 0;
string sfyname = "";
for (int j = 0; j < myTb.Rows.Count; j++)
{
flag++;
dr = rds.Tables["MZFPDY"].NewRow();
dr["门诊号"] = myTb.Rows[j]["BLH"].ToString();
dr["病人姓名"] = myTb.Rows[j]["BRXM"].ToString();
dr["收费日期"] = myTb.Rows[j]["SFRQ"].ToString();
dr["打印时间"] = Convert.ToDateTime(myTb.Rows[j]["fpdysj"]).ToString();
dr["发票号"] = myTb.Rows[j]["FPH"].ToString();
dr["总金额"] = Convert.ToDouble(myTb.Rows[j]["ZJE"].ToString());
dr["科室"] = myTb.Rows[j]["Deptname"].ToString();
dr["医生"] = myTb.Rows[j]["EmpName"].ToString();
dr["收费员"] = myTb.Rows[j]["sfy"].ToString();
sfyname = myTb.Rows[j]["sfy"].ToString();
rds.Tables["MZFPDY"].Rows.Add(dr);
}
Cursor.Current = Cursors.Default;
FrmReportView frmReport = null;
ParameterEx[] _parameters = new ParameterEx[5];
_parameters[0].Text = "tTitle";
_parameters[0].Value = new SystemCfg(2).Config;
_parameters[1].Text = "tUser";
_parameters[1].Value = "打印者：" + sfyname;
_parameters[2].Text = "tDate";
_parameters[2].Value = DateManager.ServerDateTimeByDBType(BDatabase);
_parameters[3].Text = "kssj";
_parameters[3].Value = this.dydtpks.Value;
_parameters[4].Text = "jssj";
_parameters[4].Value = this.dydtpjs.Value;
if (flag > 0)
{
frmReport = new FrmReportView(rds, Constant.ApplicationDirectory + "\\report\\MZ_门诊补打发票.rpt", _parameters);
frmReport.Show();
}
}
//补充上传病人剩余未上传费用
private void btnSupplyLoad_Click(object sender, EventArgs e)
{
this.Cursor = PubStaticFun.WaitCursor();
try
{
string zyh = txtZyh.Text.Trim();
if (string.IsNullOrEmpty(zyh))
{
MessageBox.Show("请输入住院号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string strSql = string.Format("select INPATIENT_ID from ZY_INPATIENT where INPATIENT_NO ='{0}' and DEPT_ID='{1}' ", zyh, InstanceForm.BCurrentDept.DeptId);
string inp = "";
try
{
inp = database.GetDataResult(strSql).ToString();
}
catch (Exception ex)
{
MessageBox.Show("未在本科室找到该住院号：" + zyh + " 的病人信息\r" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
bool CanAudit = ClsAuditCheck.CheckIsAuditCheck(inp, database);//是否需要智审
if (!CanAudit)
{
MessageBox.Show("该病人不满足进行智审判断条件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBox.Show("确认补传 住院号:" + zyh + " 该病人未上传费用吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Cancel)
{
return;
}
string strMsg = "";
bool bSuc = DoVaildYbFee(new DataTable(), 9, 0, new Guid(inp), 0, true, out strMsg);
if (!bSuc)
{
MessageBox.Show(strMsg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
MessageBox.Show("补传病人费用成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
//查询处方按钮事件
private void butcfcx_Click(object sender, System.EventArgs e)
{
this.Cursor = PubStaticFun.WaitCursor();
try
{
DataTable tb = new DataTable();
string rq1 = dtprq1.Value.ToShortDateString();
string rq2 = dtprq2.Value.ToShortDateString();
string wardid = InstanceForm.BCurrentDept.DeptId.ToString();
//未发药
//if (this.tabControl1.SelectedTab == this.tabPage1)
//{
// if (_menuTag.Function_Name.Trim() == "Fun_ts_yf_zyfy_cf_cx" || _menuTag.Function_Name.Trim() == "Fun_ts_yf_zyfy_cf_jy")
// tb = ZY_FY.SelectCF(wardid, inpatient_id, rq1, rq2, "", "", "", "", "0", bk, (rdCydy.Checked ? 1 : 0), 0, cfh, InstanceForm.BDatabase, bdybz);
// else
// tb = ZY_FY.SelectCF(wardid, inpatient_id, rq1, rq2, "", "", "", "", "0", bk, (rdCydy.Checked ? 1 : 0), InstanceForm.BCurrentDept.DeptId, cfh, InstanceForm.BDatabase, bdybz);
//}
////已发药
//if (this.tabControl1.SelectedTab == this.tabPage2)
//{
// string fybz = "1";
// if (_menuTag.Function_Name.Trim() == "Fun_ts_yf_zyfy_cf_jy")
// fybz = "9";
// if (_menuTag.Function_Name.Trim() == "Fun_ts_yf_zyfy_cf_cx")
// tb = ZY_FY.SelectCF(wardid, inpatient_id, "", "", "", "", rq1, rq2, fybz, bk, (rdCydy.Checked ? 1 : 0), 0, cfh, InstanceForm.BDatabase, bdybz);
// else
// tb = ZY_FY.SelectCF(wardid, inpatient_id, "", "", "", "", rq1, rq2, fybz, bk, (rdCydy.Checked ? 1 : 0), InstanceForm.BCurrentDept.DeptId, cfh, InstanceForm.BDatabase, bdybz);
//}
string fybz = "1";
int bdybz = 0;
string fyType = cmbFylb.SelectedValue.ToString();
tb = ZY_FY.SelectCF(fyType, wardid, rq1, rq2, fybz, bdybz, InstanceForm.BDatabase);
//添加处方
this.AddPresc(tb);
chkall.Checked = false;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
if (cmbKdDept.Text.Contains("手术") == true)
{
}
else
{
MessageBox.Show("开单科室必须为手术室！", "提示");
return;
}
Cursor = PubStaticFun.WaitCursor();
ParameterEx[] parameters = new ParameterEx[9];
parameters[0].Text = "@TYPE";
parameters[0].Value = 0;
parameters[1].Text = "@TJ_TYPE";
parameters[1].Value = 0;
parameters[2].Text = "@RQ1";
parameters[2].Value = dtp1.Value.ToString();
parameters[3].Text = "@RQ2";
parameters[3].Value = dtp2.Value.ToString();
parameters[4].Text = "@DEPT_BR";
parameters[4].Value = Convert.ToInt32(Convertor.IsNull(cmbBrDept.SelectedValue, "0"));
parameters[5].Text = "@DEPT_ID";
parameters[5].Value = Convert.ToInt32(Convertor.IsNull(cmbKdDept.SelectedValue, "0"));
parameters[6].Text = "@DEPT_SS";
parameters[6].Value = Convert.ToInt32(Convertor.IsNull(cmbSqDept.SelectedValue, "0"));
parameters[7].Text = "@ISBRMX";
parameters[7].Value = chkBrmx.Checked ? 1 : 0;
parameters[8].Text = "@JGBM";
parameters[8].Value = FrmMdiMain.Jgbm;
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_ZY_TJ_KSSRTJ_SSSQKS", parameters, 120);
AddRowtNo(tb);
if (tb.Columns.Contains("序号") && tb.Rows.Count > 0)
{
tb.Rows[tb.Rows.Count - 1]["序号"] = "合计";
}
this.dataGridView1.DataSource = tb;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
Cursor = Cursors.Default;
}
}
private void txtinpatientNo_KeyPress(object sender, KeyPressEventArgs e)
{
Cursor.Current = PubStaticFun.WaitCursor();
cmbWard.SelectedValue = "-1";
if (e.KeyChar == 13)
{
BingData();
}
}
private void btnSelect_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
try
{
this.Cursor = PubStaticFun.WaitCursor();
btnSelect.Enabled = false;
int tjlx = 0;
if (rdoks.Checked == true)
{
tjlx = 1;
}
if (rdoys.Checked == true)
{
tjlx = 2;
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Value = dtpBeginTime.Value.ToShortDateString() + "";
parameters[1].Value = dtpEndTime.Value.ToShortDateString() + "";
parameters[2].Value = tjlx;
parameters[3].Value = Convertor.IsNull(txtks.Tag, "0");
parameters[0].Text = "@rq1";
parameters[1].Text = "@rq2";
parameters[2].Text = "@tjlx";
parameters[3].Text = "@ksdm";
DataSet dset = new DataSet();
InstanceForm.BDatabase.AdapterFillDataSet("SP_YP_KSSZB_ZYDDD", parameters, dset, "kss", 30);
dset.Tables[0].TableName = "Tb";
myDataGrid1.DataSource = dset.Tables[0];
txtDDD.Text = dset.Tables[1].Rows[0]["抗菌药物累计DDD"].ToString();
txtoutPatient.Text = dset.Tables[1].Rows[0]["出院人数"].ToString();
txtAvgOutpatient.Text = dset.Tables[1].Rows[0]["平均住院天数"].ToString();
txtpatientCount.Text = dset.Tables[1].Rows[0]["同期收治忠者天数"].ToString();
txtqiangdu.Text = dset.Tables[1].Rows[0]["抗菌药物使用强度"].ToString();
txtksssyl.Text = dset.Tables[1].Rows[0]["抗生素使用率"].ToString();
btnSelect.Enabled = true;
}
catch (System.Exception err)
{
btnSelect.Enabled = true;
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void buttj_Click(object sender, EventArgs e)
{
try
{
Cursor = PubStaticFun.WaitCursor();
//Modify By Kevin 2013-06-18
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "@rq1";
parameters[0].Value = dtp1.Value.ToString();
parameters[1].Text = "@rq2";
parameters[1].Value = dtp2.Value.ToString();
parameters[2].Text = "@jky";
parameters[2].Value = Convert.ToInt32(Convertor.IsNull(cmbuser.SelectedValue, "0"));
//Modify By Tany 2012-01-05
int type = 0;
if (rbJkczrq.Checked)
{
type = 2;
}
else if (rbSfrq.Checked)
{
type = 1;
}
parameters[3].Text = "@TYPE";
parameters[3].Value = type;
//Add By Kevin 2013-06-18 增加机构编码
parameters[4].Text = "@JGBM";
parameters[4].Value = FrmMdiMain.Jgbm;
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_ZY_TJ_JKHZTJ", parameters, 120);
AddRowtNo(tb);
if (tb.Rows.Count > 0)
{
tb.Rows[tb.Rows.Count - 1]["序号"] = "合计";
}
this.dataGridView1.DataSource = tb;
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor = Cursors.Default;
}
}
private void btRefreshPrinter_Click(object sender, System.EventArgs e)
{
cmbPrinter.Enabled = true;
cmbReportPrinter.Enabled = true;
cmbPrinter.DropDownStyle = ComboBoxStyle.DropDownList;
cmbReportPrinter.DropDownStyle = ComboBoxStyle.DropDownList;
Cursor.Current = PubStaticFun.WaitCursor();
LoadDefaultPrinter();
Cursor.Current = Cursors.Default;
FrmPrinterSetting fPrinterSet = new FrmPrinterSetting();
fPrinterSet.ShowDialog(this);
}