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 buttj_Click(object sender, EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
this.buttj.Enabled = false;
ParameterEx[] parameters = new ParameterEx[4];
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[3].Value = rbtFyr.Checked ? 0 : 1;
parameters[0].Text = "@deptid";
parameters[1].Text = "@rq1";
parameters[2].Text = "@rq2";
parameters[3].Text = "@tjfs";
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_YF_TJ_GZL", parameters, 30);
FunBase.AddRowtNo(tb);
this.myDataGrid1.DataSource = tb;
}
catch
{
}
finally
{
this.buttj.Enabled = true;
this.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 str = "";
if (rbMz.Checked)
{
str = "门诊";
}
else
{
str = "住院";
}
string swhere = string.Format("交款来源：{0} 交款员：{1} 交款时间：{2} 到 {3}", str, 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 buttj_Click(object sender, System.EventArgs e)
{
try
{
this.Cursor = PubStaticFun.WaitCursor();
this.buttj.Enabled = false;
ParameterEx[] parameters = new ParameterEx[3];
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[0].Text = "@rq1";
parameters[1].Text = "@rq2";
parameters[2].Text = "@yplx";
DataTable tb = InstanceForm.BDatabase.GetDataTable("SP_YF_TJ_JzFyCftj", parameters, 600);
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 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 btntj_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new DataTable();
if (radioButtonmz.Checked)
{
ParameterEx[] parameter = new ParameterEx[3];
parameter[0].Text = "@RQ1";
parameter[0].Value = dtpbegin.Value.Date.ToString("yyyy-MM-dd") + " 00:00:00";
parameter[1].Text = "@RQ2";
parameter[1].Value = dtpEnd.Value.Date.ToString("yyyy-MM-dd") + " 23:59:59";
parameter[2].Text = "@jgbm";
parameter[2].Value = InstanceForm.BCurrentDept.Jgbm;
dt = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_MZYS_YPSYBL", parameter, 100);
}
else
{
ParameterEx[] parameter = new ParameterEx[4];
parameter[0].Text = "@RQ1";
parameter[0].Value = dtpbegin.Value.Date.ToString("yyyy-MM-dd") + " 00:00:00";
parameter[1].Text = "@RQ2";
parameter[1].Value = dtpEnd.Value.Date.ToString("yyyy-MM-dd") + " 23:59:59";
parameter[2].Text = "@jgbm";
parameter[2].Value = InstanceForm.BCurrentDept.Jgbm;
parameter[3].Text = "@SS_FLAG";
parameter[3].Value = checkBox1.Checked ? 1 : 0;
dt = TrasenFrame.Forms.FrmMdiMain.Database.GetDataTable("SP_ZY_TJ_YSYPSRBL", parameter, 100);
}
PubStaticFun.SetDataGridIncreaseRowNumber(dt, "序号");
dataGridView1.DataSource = dt;
}
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 frmCWSX_Load(object sender, System.EventArgs e)
{
string sSql;
//Modify by Tany 2005-02-24
//增加停用标志
sSql = @"select a.Room_no as 房号,a.Bed_No as 床号,dbo.FUN_ZY_SEEKDEPTNAME(a.dept_id) as 所属科室," +
" dbo.FUN_ZY_SEEKEMPLOYEENAME(a.zz_doc) as 主治医生,dbo.FUN_ZY_SEEKEMPLOYEENAME(a.zy_doc) as 经治医生,dbo.FUN_ZY_SEEKEMPLOYEENAME(a.CHARGENURSE) as 负责护士, " +
" h.order_name as 长期账单," +
" i.inpatient_no as 住院号,i.name as 姓名,a.bedsex as 性别," +
" case when i.baby_id>0 then '√' else '' end as 婴儿否," +
" i.cur_Dept_name as 病人所属科室, " +
" case a.isplus when 1 then '√'else ''end as 加床否," +
" case a.isbf when 1 then '√'else ''end as 包床否," +
" case a.isMYTS when 1 then '√'else ''end as 母婴同室否," +
" case a.isinuse when 1 then '√'else ''end as 是否停用" +
" from zy_BedDiction a left join jc_hoitemdiction h on h.order_id=a.hoitem_id" +
" left join vi_zy_vinpatient_bed i on a.inpatient_id=i.inpatient_id and a.baby_id=i.baby_id" +
" where a.ward_id ='" + InstanceForm.BCurrentDept.WardId + "'" +
" order by a.Room_no,a.Bed_No ";
string[] GrdMappingName = { "房号", "床号", "所属科室", "主治医生", "经治医生", "负责护士", "长期账单", "住院号", "姓名", "性别", "婴儿否", "病人所属科室", "加床否", "包床否", "母婴否", "是否停用" };
int[] GrdWidth = { 4, 4, 14, 8, 8, 8, 18, 9, 8, 4, 6, 14, 6, 6, 6, 8 };
int[] Alignment = { 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 1, 1 };
myFunc.InitGridSQL(sSql, GrdMappingName, GrdWidth, Alignment, this.myDataGrid1);
PubStaticFun.ModifyDataGridStyle(myDataGrid1, 0);
myFunc.SelRow(this.myDataGrid1);
}
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 bool myDataGrid1_myKeyDown(ref System.Windows.Forms.Message msg, System.Windows.Forms.Keys keyData)
{
try
{
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
int nrow = this.myDataGrid1.CurrentCell.RowNumber;
int ncol = this.myDataGrid1.CurrentCell.ColumnNumber;
int nkey = Convert.ToInt32(keyData);
string columnName = this.myDataGrid1.TableStyles[0].GridColumnStyles[ncol].HeaderText.Trim();
if (nrow > tb.Rows.Count - 1)
{
return(true);
}
//如果是名称列
if (columnName.Trim() == "名称" && nkey == 13)
{
string coltext = "";
DataGridTextBoxColumn txtCol = (DataGridTextBoxColumn)this.myDataGrid1.TableStyles[0].GridColumnStyles[ncol];
coltext = txtCol.TextBox.Text;
if (coltext.Trim() == "")
{
return(true);
}
if (nrow >= tb.Rows.Count - 1)
{
DataRow row = tb.NewRow();
row["序号"] = nrow + 2;
tb.Rows.Add(row);
}
tb.Rows[nrow]["名称"] = coltext;
tb.Rows[nrow]["拼音码"] = PubStaticFun.GetPYWBM(coltext, 0);
tb.Rows[nrow]["五笔码"] = PubStaticFun.GetPYWBM(coltext, 1);
}
//回车控制
//if (nkey==13 && columnName!="药品类型")
if (nkey == 13 && columnName != "统领分类")
{
this.myDataGrid1.CurrentCell = new DataGridCell(nrow, ncol + 1);
}
//if (nkey==13 && columnName=="药品类型")
if (nkey == 13 && (columnName == "统领分类" || columnName == "剂型大类"))
{
this.myDataGrid1.CurrentCell = new DataGridCell(nrow + 1, 1);
}
if (this.myDataGrid1.TableStyles[0].GridColumnStyles[ncol + 1].HeaderText.Trim() == "统领分类" || this.myDataGrid1.TableStyles[0].GridColumnStyles[ncol + 1].HeaderText.Trim() == "剂型大类")
{
cmbyplx.Focus();
}
}
catch (System.Exception err)
{
MessageBox.Show("错误" + err.Message);
}
return(false);
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
try
{
this.dataGridView1.EndEdit();
this.BindingContext[((DataTable)this.dataGridView1.DataSource)].EndCurrentEdit();
DataTable temp = ((DataTable)this.dataGridView1.DataSource);
DataTable tt = temp.GetChanges();
DataTable tdel = temp.GetChanges(DataRowState.Deleted);
this.dataGridView1.Rows.Count.ToString();
for (int i = 0; i < temp.Rows.Count; i++)
{
if (temp.Rows[i].RowState == DataRowState.Deleted)
{
continue;
}
if (temp.Rows[i]["delete_bit1"].ToString() == "false")
{
temp.Rows[i]["delete_bit"] = 0;
}
else
{
temp.Rows[i]["delete_bit"] = 1;
}
if (temp.Rows[i].RowState == DataRowState.Added)
{
temp.Rows[i]["delete_bit"] = 0;
temp.Rows[i]["delete_bit1"] = "false";
}
if (temp.Rows[i]["pym"].ToString().Trim() == "")
{
temp.Rows[i]["pym"] = PubStaticFun.GetPYWBM(temp.Rows[i]["name"].ToString().Trim(), 0);
temp.Rows[i]["wbm"] = PubStaticFun.GetPYWBM(temp.Rows[i]["name"].ToString().Trim(), 1);
}
temp.Rows[i]["type"] = this.toolStripComboBox1.ComboBox.SelectedValue.ToString();
temp.Rows[i]["typename"] = this.toolStripComboBox1.ComboBox.Text.ToString();
if (temp.Rows[i]["name"].ToString().Trim() == "")
{
temp.Rows[i].Delete();
}
}
databaseupdate("select * from ss_ShblJcsj where 1=2", ((DataTable)this.dataGridView1.DataSource));
((DataTable)this.dataGridView1.DataSource).AcceptChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
FrmShblJcwh_Load(null, null);
try
{
this.dataGridView1.CurrentCell = this.dataGridView1.Rows[this.dataGridView1.Rows.Count - 1].Cells[0];
}
catch { }
}
}
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 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 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 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 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 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 ViewDataGrid()
{
if (_dataSource != null)
{
PubStaticFun.SetCardGridTopAndLeft(this, cardGrid, this.Parent, this.Top, this.Left);
cardGrid.Visible = true;
this.Focus();
this.SelectionStart = this.Text.Length;
}
}
//查询处方按钮事件
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 txtinpatientNo_KeyPress(object sender, KeyPressEventArgs e)
{
Cursor.Current = PubStaticFun.WaitCursor();
cmbWard.SelectedValue = "-1";
if (e.KeyChar == 13)
{
BingData();
}
}
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;
}
}
public string DoInsertChange(int iStatus, DateTime importTime)
{
;
string strSql = "";
strSql = string.Format(@"insert into jc_gf_patrec_Change( id, ylzh, name, pym, wbm, gflx, qy, brlx, del_bit, cfsl_xz, cfslM_xz,
je_xz, jcje_xz, zlje_xz,yje_xz, GRJB, RZQK, ZFBL, RDWBH, DWBH, RRYLB, RGRBH, SFZH, xb ,memo,
DM,lxdh, csrq,GZSJ,DDYY1,DDYY2,DDYY3,bzsj,xzsj,ydsj,ydlb,drsj,cxsj,dr_bit,memo_1,memo_2,memo_3)
VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}','{36}','{37}','{38}','{39}','{40}','{41}')",
DDLH.Replace("'", "") + _strZone,
DDLH.Replace("'", ""),
RGRXM.Replace("'", ""),
PubStaticFun.GetPYWBM(RGRXM.Replace("'", ""), 0),
PubStaticFun.GetPYWBM(RGRXM.Replace("'", ""), 1),
_strWhsGf,
_strZone,
_strYbjklx,
"0",
_cfsl,
_cfslM,
_jexz,
_rJcje,
_rZlje,
_yjexz,
RGRJB,
RRZQK,
RZFBL,
RDWBH,
DWBH,
RRYLB,
RGRBH,
SFZH,
RGRXB,
BZ,
"2",
NXDH.Replace("'", ""),
string.IsNullOrEmpty(RZSSJ.Trim()) ? "" : RZSSJ.Trim(),
string.IsNullOrEmpty(RGZSJ.Trim()) ? "" : RGZSJ.Trim(),
RDDY1,
RDDY2,
RDDY3,
string.IsNullOrEmpty(RBZSJ.Trim()) ? "" : RBZSJ.Trim(),
string.IsNullOrEmpty(RSZSJ.Trim()) ? "" : RSZSJ.Trim(),
string.IsNullOrEmpty(BDSJ.Trim()) ? "" : BDSJ.Trim(),
BDLB,
importTime,
importTime.ToString("yyyy-MM-dd HH:mm:ss"),
iStatus,
"",
RGRJB,
RRZQK
);
return(strSql);
}
private void Frmmxcx_Load(object sender, System.EventArgs e)
{
for (int i = 0; i <= panel2.Controls.Count - 1; i++)
{
if (panel2.Controls[i].GetType().ToString() == "TrasenClasses.GeneralControls.ButtonDataGridEx")
{
TrasenClasses.GeneralControls.ButtonDataGridEx mydatagrid = (TrasenClasses.GeneralControls.ButtonDataGridEx)panel2.Controls[i];
//PublicStaticFun.ModifyDataGridStyle(mydatagrid,0);
PubStaticFun.ModifyDataGridStyle(mydatagrid, 0);
}
}
}
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;
}
}
public string DoInsert()
{
string strSql = "";
strSql = string.Format(@"insert into jc_gf_patrec( id, ylzh,ylzh1,ylzh2, name, pym, wbm, gflx, qy, brlx, del_bit, cfsl_xz, cfslM_xz, je_xz, jcje_xz, zlje_xz,yje_xz,
GRJB, RZQK, ZFBL, RDWBH, DWBH, RRYLB, RGRBH, SFZH, xb ,memo,
DM,lxdh, csrq,GZSJ,DDYY1,DDYY2,DDYY3,bzsj,xzsj,ydsj,ydlb,memo_1,memo_2,memo_3)
VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}','{36}','{37}','{38}','{39}','{40}')",
DDLH.Replace("'", "") + _strZone,
DDLH.Replace("'", ""),
DDLH.Replace("'", ""),
DDLH.Replace("'", ""),
RGRXM.Replace("'", ""),
PubStaticFun.GetPYWBM(RGRXM.Replace("'", ""), 0),
PubStaticFun.GetPYWBM(RGRXM.Replace("'", ""), 1),
_strWhsGf,
_strZone,
_strYbjklx,
"0",
_cfsl,
_cfslM,
_jexz,
_rJcje,
_rZlje,
_yjexz,
RGRJB,
RRZQK,
RZFBL,
RDWBH,
DWBH,
RRYLB,
RGRBH,
SFZH,
RGRXB,
BZ,
"2",
NXDH.Replace("'", ""),
string.IsNullOrEmpty(RZSSJ.Trim()) ? "" : RZSSJ.Trim(),
string.IsNullOrEmpty(RGZSJ.Trim()) ? "" : RGZSJ.Trim(),
RDDY1,
RDDY2,
RDDY3,
string.IsNullOrEmpty(RBZSJ.Trim()) ? "" : RBZSJ.Trim(),
string.IsNullOrEmpty(RSZSJ.Trim()) ? "" : RSZSJ.Trim(),
string.IsNullOrEmpty(BDSJ.Trim()) ? "" : BDSJ.Trim(),
BDLB,
"",
RGRJB,
RRZQK);
//InstanceForm._database.DoCommand(strSql);
return(strSql);
}
private void textBox2_KeyPress_1(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == '\r')
{
if ((sender as Control).Name == "textBox2")
{
this.textBox4.Text = PubStaticFun.GetPYWBM(this.textBox2.Text, 0);
this.textBox5.Text = PubStaticFun.GetPYWBM(this.textBox2.Text, 1);
}
this.SelectNextControl((sender as TextBox), true, false, false, true);
}
}
private void textBox_TextChanged(object sender, System.EventArgs e)
{
string Sort = "";
TBox = (TextBox)sender;
this.GrdSel.Visible = true;
if (TBox == this.txtXY)
{
this.GrdSel.Top = 128;
Sort = "D";
}
string str = TBox.Text.Trim().Replace("'", ".").ToUpper();
str = str == "" ? "" : " and (拼音码 like '" + str + "%' )";
// string sSql="select name NAME,coding ICD,py_code 拼音码 from base_disease where sort='"+Sort+"' and py_code like '"+str+"%'";
// if (diseaseTb==null)
// {
//string sSql = "select top 20 name NAME,coding ICD,py_code 拼音码,sort from jc_disease where py_code like '" + TBox.Text.Trim() + "%' order by len(py_code)";
//string sSql = "select top 20 name NAME,coding ICD,py_code 拼音码,sort from jc_disease where 1=1 " + (ybjklx <= 0 ? "" : " and ybjklx =" + ybjklx) + " and py_code like '" + TBox.Text.Trim() + "%' order by len(py_code)";
//Modify By Tany 2015-05-26 医保接口类型=0的时候也要过滤
//Modify by jchl 2015-08-22 加入ybjbbm
string sSql = "select top 20 name NAME,coding ICD,'' as YBJBBM,'' as YBJBMC,py_code 拼音码,sort from jc_disease where 1=1 " + (ybjklx < 0 ? "" : " and ybjklx =" + ybjklx) + " and py_code like '" + TBox.Text.Trim() + "%' order by len(py_code)";
if (ybjklx == 40 && yblx >= 0)
{
//医保诊断带出医保编码
sSql = @"select top 20 a.name NAME,a.coding ICD,b.YBJBBM,b.YBJBMC,a.py_code 拼音码,a.wb_code 五笔码,a.sort
from jc_disease a
inner join JC_DISEASE_YYYBDZ b on a.CODING=b.YYJBBM
where 1=1 and a.ybjklx =" + ybjklx + " and (py_code like '" + TBox.Text.Trim() + "%' or wb_code like '%" + TBox.Text.Trim() + "%' ) order by len(py_code)";
}
diseaseTb = FrmMdiMain.Database.GetDataTable(sSql);
dt = null;
dt = diseaseTb.Clone();
// }
DataRow[] diseaseDR = diseaseTb.Select();//("sort='"+Sort+"'","拼音码"); //暂时屏蔽
GrdSel.DataSource = null;
dt.Clear();
foreach (DataRow dr in diseaseDR)
{
dt.Rows.Add(dr.ItemArray);
}
// dt=DatabaseAccess.GetDataTable(DatabaseType.IbmDb2ZY,sSql);
GrdSel.DataSource = dt;
PubStaticFun.ModifyDataGridStyle(GrdSel, 0);
}
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);
}