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