private void PrintReport()
{
try
{
if (this.Dgv_RzInfo.Rows.Count < 1)
{
MessageBox.Show("没有需要打印的数据!", "提示");
return;
}
Report.Ds_Mzrz Dset = new ts_mz_cx.Report.Ds_Mzrz();
DataTable dt = (DataTable)this.Dgv_RzInfo.DataSource;
foreach (DataRow dr in dt.Rows)
{
DataRow _dr = Dset.Tables[0].NewRow();
_dr["就诊日期"] = dr["就诊日期"];
_dr["门诊号"] = dr["门诊号"];
_dr["联系人"] = dr["联系人"];
_dr["姓名"] = dr["姓名"];
_dr["性别"] = dr["性别"];
_dr["职业"] = dr["职业"];
_dr["住址"] = dr["住址"];
_dr["联系电话"] = dr["联系电话"];
_dr["诊断"] = dr["诊断"];
_dr["发病日期"] = dr["发病日期"];
_dr["诊断时间"] = dr["诊断时间"];
_dr["初复诊"] = dr["初复诊"];
_dr["备注"] = dr["备注"];
Dset.Tables[0].Rows.Add(_dr);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "Title";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "门诊日志";
parameters[1].Text = "Memo";
parameters[1].Value = "日期:" + this.dtp1.Value.ToString("yyyy-MM-dd HH:mm:ss") + "至" + this.dtp2.Value.ToString("yyyy-MM-dd HH:mm:ss");
parameters[2].Text = "Date";
parameters[2].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString("yyyy-MM-dd HH:mm:ss");
parameters[3].Text = "Czy";
parameters[3].Value = InstanceForm.BCurrentUser.Name.ToString();
FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_门诊日志统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (Exception ea)
{
MessageBox.Show("出现异常!原因:" + ea.Message, "错误");
}
}
private void butprint_pos_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
try
{
DataTable dtbk = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 dset = new ts_mz_report.DataSet1();
DataRow dr;
for (int i = 0; i <= dtbk.Rows.Count - 1; i++)
{
dr = dset.银医办卡统计.NewRow();
int x = i + 1;
dr["卡类型"] = Convert.ToString(dtbk.Rows[i]["卡类型"]);
dr["办卡数"] = Convert.ToString(Convertor.IsNull(dtbk.Rows[i]["办卡数"], "0"));
dr["有效数"] = Convert.ToString(Convertor.IsNull(dtbk.Rows[i]["有效数"], "0"));
dr["退卡数"] = Convert.ToString(Convertor.IsNull(dtbk.Rows[i]["退卡数"], "0"));
dr["冻结数"] = Convert.ToString(Convertor.IsNull(dtbk.Rows[i]["冻结数"], "0"));
dr["挂失数"] = Convert.ToString(Convertor.IsNull(dtbk.Rows[i]["挂失数"], "0"));
dr["预交金"] = Convert.ToDecimal(Convertor.IsNull(dtbk.Rows[i]["预交金"], "0"));
dset.银医办卡统计.Rows.Add(dr);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
parameters[2].Text = "备注";
parameters[2].Value = "办卡日期:" + startTjrq.Value.ToString() + " 到 " + endTjrq.Value.ToString();
parameters[3].Text = "统计人";
parameters[3].Value = InstanceForm.BCurrentUser.Name;
bool bprint = chkprint.Checked == true ? false : true;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(dset, Constant.ApplicationDirectory + "\\Report\\MZ_银医诊疗卡办卡统计.rpt", parameters, bprint);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnprintmxbfy_Click(object sender, EventArgs e)
{
if (dataGridView2.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[1];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医保结算统计(明细不分页).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
DataTable dt = dataGridView1.DataSource as DataTable;
ts_mz_txyy.DataSet1 Dset = new ts_mz_txyy.DataSet1();
DataRow myrow;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
myrow = Dset.门诊科室退号量.NewRow();
myrow["名称"] = Convert.ToString(dt.Rows[i]["名称"]);
myrow["退号数"] = Convert.ToString(dt.Rows[i]["退号数"]);
Dset.门诊科室退号量.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "yq";
parameters[0].Value = comboBox1.Text;
parameters[1].Text = "kssj";
parameters[1].Value = dateTimePicker1.Value.ToString("yyyy-MM-dd") + " 00:00:00";
parameters[2].Text = "jssj";
parameters[2].Value = dateTimePicker2.Value.ToString("yyyy-MM-dd") + " 23:59:59";
parameters[3].Text = "dyr";
parameters[3].Value = InstanceForm.BCurrentUser.Name;
parameters[4].Text = "ks";
parameters[4].Value = textBox1.Text;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\门诊科室退号数统计.rpt", parameters, true);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
private void butprint_pos_Click(object sender, EventArgs e)
{
try
{
DataTable tbmx = dset.Tables[0];
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
int x = 0;
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = x + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
//}
}
Dset.收费项目.Rows.Add(myrow);
x = 0;
for (int nrow = 0; nrow <= tbmx.Rows.Count - 2; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
//}
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[6];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
parameters[2].Text = "填报人";
parameters[2].Value = InstanceForm.BCurrentUser.Name;
parameters[3].Text = "rq1";
parameters[3].Value = dtpjsrq1.Value.ToString();
parameters[4].Text = "rq2";
parameters[4].Value = dtpjsrq2.Value.ToString();
parameters[5].Text = "院区";
parameters[5].Value = cmbjgbm.Text;
bool bprint = chkprint.Checked == true ? false : true;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_预交款收款明细表.rpt", parameters, bprint);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btApplyAffirm_Click(object sender, EventArgs e)
{
if (tabControl1.SelectedTab == tabPage1)
{
#region 打印明细
try
{
DataView dv = (DataView)dgvyjsq.DataSource;
DataTable tbmx = dv.Table;
DataSet1 Dset = new DataSet1();
int x = 0;
DataRow myrow = Dset.项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
if (dgvyjsq.Columns[i].Visible == true)
{
x = x + 1;
string nm = "T" + x.ToString();
myrow[nm] = dgvyjsq.Columns[i].HeaderText;
}
}
Dset.项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
int xx = 0;
DataRow myrow1 = Dset.项目内容.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
if (dgvyjsq.Columns[i].Visible == true)
{
xx = xx + 1;
string nm = "JE" + xx.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
}
Dset.项目内容.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
string bz1 = "";
if (rdoqrrq.Checked == true)
{
bz1 = "确认日期从:" + dtpqrrq1.Value.ToShortDateString() + " 到 " + dtpqrrq2.Value.ToShortDateString() + " ";
}
else
{
bz1 = "申请日期从:" + dtpqrrq1.Value.ToShortDateString() + " 到 " + dtpqrrq2.Value.ToShortDateString() + " ";
}
parameters[1].Text = "备注";
parameters[1].Value = bz1;
parameters[2].Text = "备注1";
parameters[2].Value = "确认科室:" + InstanceForm.BCurrentDept.DeptName;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\YJ_医技确认明细.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
#endregion
}
else
{
#region 打印汇总
try
{
DataTable tbmx = (DataTable)dataGridView2.DataSource;
DataSet1 Dset = new DataSet1();
int x = 0;
DataRow myrow = Dset.项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
if (dataGridView2.Columns[i].Visible == true)
{
x = x + 1;
string nm = "T" + x.ToString();
myrow[nm] = dataGridView2.Columns[i].HeaderText;
}
}
Dset.项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
int xx = 0;
DataRow myrow1 = Dset.项目内容.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
if (dataGridView2.Columns[i].Visible == true)
{
xx = xx + 1;
string nm = "JE" + xx.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
}
Dset.项目内容.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
string bz1 = "";
if (rdoqrrq.Checked == true)
{
bz1 = "确认日期从:" + dtpqrrq1.Value.ToShortDateString() + " 到 " + dtpqrrq2.Value.ToShortDateString() + " ";
}
else
{
bz1 = "申请日期从:" + dtpqrrq1.Value.ToShortDateString() + " 到 " + dtpqrrq2.Value.ToShortDateString() + " ";
}
parameters[1].Text = "备注";
parameters[1].Value = bz1;
parameters[2].Text = "备注1";
parameters[2].Value = "确认科室:" + InstanceForm.BCurrentDept.DeptName;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\YJ_医技确认汇总.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
#endregion
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dgvList.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dgvList.DataSource;
if (tbmx == null || tbmx.Rows.Count == 0) //Add by zp 2013-10-22
{
MessageBox.Show("没有需要打印的数据!", "提示");
return;
}
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "统计时间";
parameters[1].Value = this.dtp1.Value.ToString("yyyy-MM-dd HH:mm:ss") + " ～ " + this.dtp2.Value.ToString("yyyy-MM-dd HH:mm:ss");
parameters[2].Text = "制表人";
parameters[2].Value = TrasenFrame.Forms.FrmMdiMain.CurrentUser.Name;
string ss = "";
if (txtks.Text.Trim() != "")
{
ss = " 接诊科室：" + txtks.Text.Trim();
}
if (cmbghjb.SelectedIndex != 0)
{
ss = ss + " 接诊级别：" + cmbghjb.Text.Trim();
}
if (txtys.Text.Trim() != "")
{
ss = ss + " 接诊医生：" + txtys.Text.Trim();
}
parameters[3].Text = "其它条件";
parameters[3].Value = ss;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_门诊医生接诊量统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void buttondy_Click(object sender, EventArgs e)
{
DataView view = Tb.DefaultView;
//view.RowFilter = "床号='01'";
ParameterEx[] pa = new ParameterEx[1];
pa[0].Text = "报表名称";
if (radiowdy.Checked)
{
pa[0].Value = "会诊申请单";
}
else
{
pa[0].Value = "会诊申请单(补打)";
}
for (int i = 0; i < view.Count; i++)
{
if (view[i]["选择"].ToString().Trim() == "1")
{
DataSet1.HzdDataTable hzdtb = new DataSet1.HzdDataTable();
DataTable tbdy = hzdtb;
string sql = "select dbo.fun_getDeptname(CON_DEPT) 被邀科室,CON_DATE,dbo.fun_getEmpName(CON_DOC) 会诊医师,ACCEPT_DATE,CONTENT from ZY_CON_MX where P_ID='" + view[i]["id"] + "'";
DataTable tbcommx = FrmMdiMain.Database.GetDataTable(sql);
if (tbcommx.Rows.Count == 0)
{
DataRow dr = tbdy.NewRow();
dr["姓名"] = view[i]["病人姓名"];
dr["床号"] = view[i]["床号"];
dr["住院号"] = view[i]["住院号"];
dr["病区"] = view[i]["病区"];
dr["科室"] = view[i]["科室"];
dr["年龄"] = view[i]["年龄"];
dr["性别"] = view[i]["性别"];
dr["简要病史及检查"] = view[i]["病史及检查"];
dr["会诊目的"] = view[i]["会诊目的"];
dr["申请医师"] = view[i]["申请医生"];
dr["申请日期"] = view[i]["申请日期"];
tbdy.Rows.Add(dr);
}
else
{
for (int j = 0; j < tbcommx.Rows.Count; j++)
{
DataRow dr = tbdy.NewRow();
dr["姓名"] = view[i]["病人姓名"];
dr["床号"] = view[i]["床号"];
dr["住院号"] = view[i]["住院号"];
dr["病区"] = view[i]["病区"];
dr["科室"] = view[i]["科室"];
dr["年龄"] = view[i]["年龄"];
dr["性别"] = view[i]["性别"];
dr["简要病史及检查"] = view[i]["病史及检查"];
dr["会诊目的"] = view[i]["会诊目的"];
dr["申请医师"] = view[i]["申请医生"];
dr["申请日期"] = view[i]["申请日期"];
dr["会诊意见"] = tbcommx.Rows[j]["CONTENT"].ToString();
dr["会诊医师"] = tbcommx.Rows[j]["会诊医师"].ToString();
dr["会诊日期"] = tbcommx.Rows[j]["ACCEPT_DATE"].ToString();
dr["被邀科室"] = tbcommx.Rows[j]["被邀科室"].ToString();
for (int x = 1; x <= 7; x++)
{
dr["bz" + x.ToString()] = "";
}
tbdy.Rows.Add(dr);
}
}
bool bview = this.checkBox1.Checked?false:true;
string[] sqls = new string[1];
sqls[0] = " update ZY_CONSULTATION set isprint=1 where ID='" + view[i]["id"] + "'";
//打印
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(tbdy, Constant.ApplicationDirectory + "\\report\\zyys_会诊单打印.rpt", pa, bview);//sqls[0]);
f._sqlStr = sqls;
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
}
this.button1_Click(null, null);
}
private void btApplyAffirm_Click(object sender, EventArgs e)
{
try
{
DataTable tbmx = (DataTable)dgvyjsq.DataSource;
DataSet1 Dset = new DataSet1();
DataRow myrow = Dset.项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.项目内容.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.项目内容.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "备注";
parameters[1].Value = "医技科室:" + cmbzxks.Text + " 申请科室:" + cmbks.Text;
string bz1 = "确认日期从:" + dtpqrrq1.Value.ToShortDateString() + " 到 " + dtpqrrq2.Value.ToShortDateString() + " ";
if (txtjcxm.Text.Trim() != "")
{
bz1 = bz1 + " 项目名称:" + txtjcxm.Text.Trim();
}
parameters[2].Text = "备注1";
parameters[2].Value = bz1;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\YJ_项目医生汇总统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprint_pos_Click(object sender, EventArgs e)
{
try
{
DataTable tbmx = dset.Tables[0];
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
int x = 0;
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = x + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
//}
}
Dset.收费项目.Rows.Add(myrow);
x = 0;
for (int nrow = 0; nrow <= tbmx.Rows.Count - 2; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
//if (dataGridView1.Columns[i].Visible == true)
//{
x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
//}
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[12];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
parameters[2].Text = "填报人";
parameters[2].Value = InstanceForm.BCurrentUser.Name;
parameters[3].Text = "rq1";
parameters[3].Value = chkbkrq.Checked == true?dtpjsrq1.Value.ToString() : "";
parameters[4].Text = "rq2";
parameters[4].Value = chkbkrq.Checked == true?dtpjsrq2.Value.ToString() : "";
parameters[5].Text = "工作单位";
parameters[5].Value = txtgzdw.Text;
parameters[6].Text = "家庭地址";
parameters[6].Value = txtjtdz.Text;
string zt = "";
if (chkye.Checked == true)
{
zt = "有余额";
}
if (chkdj.Checked == true)
{
zt = zt + " 已冻结";
}
if (chkgs.Checked == true)
{
zt = zt + " 已挂失";
}
parameters[7].Text = "其它";
parameters[7].Value = "状态: " + zt;
parameters[8].Text = "办卡张数";
parameters[8].Value = lblbkzs.Text;
parameters[9].Text = "累计存入";
parameters[9].Value = lblljcr.Text;
parameters[10].Text = "累计消费";
parameters[10].Value = lblljxf.Text;
parameters[11].Text = "结余金额";
parameters[11].Value = lbljcje.Text;
bool bprint = chkprint.Checked == true ? false : true;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_预交款结余情况表.rpt", parameters, bprint);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnsfyhz_Click(object sender, EventArgs e)
{
if (dataGridView2.DataSource == null)
{
return;
}
DataTable tb = (DataTable)dataGridView2.DataSource;
string[] GroupbyField1 = { "医保类型", "结算员" };
string[] ComputeField1 = { "结算金额", "帐户支付", "统筹支付", "其它支付", "现金支付" };
string[] CField1 = { "sum", "sum", "sum", "sum", "sum" };
TrasenFrame.Classes.TsSet xcset1 = new TrasenFrame.Classes.TsSet();
xcset1.TsDataTable = tb;
DataTable tbcf1 = xcset1.GroupTable(GroupbyField1, ComputeField1, CField1, "");
if (tbcf1.Rows.Count == 0)
{
return;
}
tbcf1.Columns.Remove("发票号");
tbcf1.Columns.Remove("姓名");
tbcf1.Columns.Remove("结算时间");
try
{
DataTable tbmx = tbcf1;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "条件";
parameters[1].Value = "收费日期:" + dtp1.Value.ToString("yyyy-MM-dd HH:mm:ss") + " 到 " + dtp2.Value.ToString("yyyy-MM-dd HH:mm:ss");
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医保结算统计(按收费员汇总).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void butprintmx_Click(object sender, EventArgs e)
{
if (dataGridView2.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
if (tbmx.Rows[nrow]["医保类型"].ToString() != "总计")
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
}
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
string ss = "部门:" + cmbjgbm.Text;
if (Convertor.IsNull(cmbyblx.SelectedValue, "0") != "0")
{
ss = ss + " 医保类型:" + cmbyblx.Text.Trim();
}
if (Convertor.IsNull(cmbsfy.SelectedValue, "0") != "0")
{
ss = ss + " 收费员:" + cmbsfy.Text.Trim();
}
ss = ss + " 收费日期:" + dtp1.Value.ToString() + " 到 " + dtp2.Value.ToString();
parameters[2].Text = "备注";
parameters[2].Value = ss;
parameters[3].Text = "现金大写";
parameters[3].Value = "";
parameters[4].Text = "操作员";
parameters[4].Value = InstanceForm.BCurrentUser.Name;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医保结算统计(明细).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDy_Click(object sender, EventArgs e)
{
try
{
if (dataGridView1.DataSource == null)
{
MessageBox.Show("没有数据！");
return;
}
DataTable tbmx = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= tbmx.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow][tbmx.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "填报日期";
parameters[1].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
string bz = "";
if (txtDept.Text.Trim() != "")
{
bz = bz + " 开单科室:" + txtDept.Text.Trim();
}
if (txtUser.Text.Trim() != "")
{
bz = bz + " 开单医生:" + txtUser.Text.Trim();
}
parameters[2].Text = "备注";
parameters[2].Value = dtpTjKs.Value.ToString() + " 到 " + dtpTjJs.Value.ToString() + " " + " 部门名称:" + cmbjgbm.Text + " " + bz;
parameters[3].Text = "现金大写";
parameters[3].Value = "";
TrasenFrame.Forms.FrmReportView f;
//if (rdJg.Checked == true)
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医生收入情况统计.rpt", parameters);
//else
// f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_医生收入报表(会计).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//打印小票 add by pgj 20150120
/// <summary>
/// 打印小票
/// </summary>
/// <param name="kdjid"></param>
/// <param name="action"></param>
private void Print(string kdjid, string action)
{
string rptURL = "";
ParameterEx[] parameters = null;
try
{
string operateName = InstanceForm.BDatabase.GetDataResult("select Name from JC_EMPLOYEE_PROPERTY where EMPLOYEE_ID=" + InstanceForm.BCurrentUser.EmployeeId).ToString();
String sqll = "select a.*,b.Name ZFDJY,c.XB,c.BRLXFS DH,c.SFZH from yy_KDJB a left join JC_EMPLOYEE_PROPERTY b on a.zfdjy=b.EMPloyee_ID left join yy_brxx c on a.brxxid=c.brxxid where kdjid='" + kdjid + "'";
DataTable tb = InstanceForm.BDatabase.GetDataTable(sqll);
if (tb.Rows.Count != 0)
{
DataSet1 Dset = new DataSet1();
DataRow myrow;
if (action == "卡作废")
{
myrow = Dset.作废卡.NewRow();
myrow["kh"] = tb.Rows[0]["KH"].ToString().Trim();
myrow["CKRXM"] = tb.Rows[0]["CKRXM"].ToString().Trim();
myrow["XB"] = tb.Rows[0]["XB"].ToString().Trim();
myrow["DH"] = tb.Rows[0]["DH"].ToString().Trim();
myrow["SFZH"] = tb.Rows[0]["SFZH"].ToString().Trim();
myrow["BKJE"] = tb.Rows[0]["BKJE"].ToString().Trim();
myrow["ZFDJY"] = tb.Rows[0]["ZFDJY"].ToString().Trim();
myrow["ZFSJ"] = tb.Rows[0]["ZFSJ"].ToString().Trim();
Dset.作废卡.Rows.Add(myrow);
parameters = new ParameterEx[1];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "作废卡凭证";
rptURL = Constant.ApplicationDirectory + "\\Report\\作废卡.rpt";
}
else if (action == "卡冻结")
{
myrow = Dset.冻结卡.NewRow();
myrow["KH"] = tb.Rows[0]["KH"].ToString().Trim();
myrow["CKRXM"] = tb.Rows[0]["CKRXM"].ToString().Trim();
myrow["XB"] = tb.Rows[0]["XB"].ToString().Trim();
myrow["DH"] = tb.Rows[0]["DH"].ToString().Trim();
myrow["SFZH"] = tb.Rows[0]["SFZH"].ToString().Trim();
myrow["KYE"] = tb.Rows[0]["KYE"].ToString().Trim();
myrow["DJDJY"] = operateName;
myrow["DJSJ"] = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString();
Dset.冻结卡.Rows.Add(myrow);
parameters = new ParameterEx[1];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "冻结卡凭证";
rptURL = Constant.ApplicationDirectory + "\\Report\\冻结卡.rpt";
}
else if (action == "卡挂失")
{
myrow = Dset.挂失卡.NewRow();
myrow["KH"] = tb.Rows[0]["KH"].ToString().Trim();
myrow["CKRXM"] = tb.Rows[0]["CKRXM"].ToString().Trim();
myrow["XB"] = tb.Rows[0]["XB"].ToString().Trim();
myrow["DH"] = tb.Rows[0]["DH"].ToString().Trim();
myrow["SFZH"] = tb.Rows[0]["SFZH"].ToString().Trim();
myrow["KYE"] = tb.Rows[0]["KYE"].ToString().Trim();
myrow["GSDJY"] = operateName;
myrow["GSSJ"] = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToString();
Dset.挂失卡.Rows.Add(myrow);
parameters = new ParameterEx[1];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "挂失卡凭证";
rptURL = Constant.ApplicationDirectory + "\\Report\\挂失卡.rpt";
}
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, rptURL, parameters);
string Bview = ApiFunction.GetIniString("划价收费", "发票预览", Constant.ApplicationDirectory + "//ClientWindow.ini");
if (Bview == "true")
{
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
else
{
f = new TrasenFrame.Forms.FrmReportView(Dset, rptURL, parameters, true);
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}