private void butprint_Click(object sender, System.EventArgs e)
{
try
{
string tjlb = rdo1.Checked == true?rdo1.Text.Trim() : rdo2.Text.Trim();
string kcsxxheadertext = rdo1.Checked == true?"下限":"上限";
string bjczheadertext = rdo1.Checked == true?"低于下限":"高于上限";
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
// ts_Yk_ReportView.药品高低储报警 rpt=new ts_Yk_ReportView.药品高低储报警();
ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1();
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
myrow = Dset.药品高低储报警.NewRow();
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]);
myrow["ypspm"] = Convert.ToString(tb.Rows[i]["品名"]);
myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["pfj"] = Convert.ToDecimal(tb.Rows[i]["批发价"]);
myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["零售价"]);
if (rdo1.Checked == true)
{
myrow["kcsxx"] = Convert.ToDecimal(tb.Rows[i]["下限"]);
}
else
{
myrow["kcsxx"] = Convert.ToDecimal(tb.Rows[i]["上限"]);
}
myrow["kcl"] = Convert.ToDecimal(tb.Rows[i]["库存量"]);
if (rdo1.Checked == true)
{
myrow["gdc"] = Convert.ToDecimal(tb.Rows[i]["低于下限"]);
}
else
{
myrow["gdc"] = Convert.ToDecimal(tb.Rows[i]["高于上限"]);
}
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]);
Dset.药品高低储报警.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "yplx";
parameters[0].Value = cmbyplx.Text;
parameters[1].Text = "tjlb";
parameters[1].Value = tjlb;
parameters[2].Text = "kcsxxheadertext";
parameters[2].Value = kcsxxheadertext.Trim();
parameters[3].Text = "bjczheadertext";
parameters[3].Value = bjczheadertext.Trim();
parameters[4].Text = "TITLETEXT";
parameters[4].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + this.Text;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品高低储报警, Constant.ApplicationDirectory + "\\Report\\YK_药品高低储报警.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, System.EventArgs e)
{
string where1 = "";
if (rdo1.Checked == true)
{
where1 = "按日期统计 日期:" + dtp1.Value.ToShortDateString();
where1 = where1 + " 到:" + dtp2.Value.ToShortDateString();
}
else
{
where1 = "按会计月份统计 日期:" + this.statusBar1.Panels[3].Text;
}
try
{
YpConfig s = new YpConfig(Convert.ToInt32(cmbyjks.SelectedValue), InstanceForm.BDatabase);
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1();
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 2; i++)
{
myrow = Dset.报损报溢单.NewRow();
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]);
if (s.打印单据时单据显示商品名 == true)
{
myrow["ypmc"] = Convert.ToString(tb.Rows[i]["商品名"]);
}
else
{
myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]);
}
myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["ypsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["数量"], "0"));
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["pfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发价"], "0"));
myrow["pfje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发金额"], "0"));
myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售价"], "0"));
myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售金额"], "0"));
decimal plce = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售金额"], "0")) - Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发金额"], "0"));
myrow["plce"] = plce.ToString("0.00");
myrow["jhj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进价"], "0"));
myrow["jhje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进货金额"], "0"));
decimal jlce = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售金额"], "0")) - Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进货金额"], "0"));
myrow["jlce"] = jlce.ToString("0.00");
myrow["ypph"] = Convert.ToString(tb.Rows[i]["批号"]);
myrow["ypxq"] = Convert.ToString(tb.Rows[i]["效期"]);
myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]);
myrow["kwmc"] = ""; //Convert.ToString(tb.Rows[i]["库位"]);
Dset.报损报溢单.Rows.Add(myrow);
}
string title = this.Text; //_menuTag.Function_Name.Trim()=="Fun_ts_yk_ypbs"?"药品报损单":"药品报溢单";
ParameterEx[] parameters = new ParameterEx[8];
parameters[0].Text = "DJH";
parameters[0].Value = ""; //this.lbldjh.Text;
parameters[1].Text = "DJY";
parameters[1].Value = InstanceForm.BCurrentUser.Name;
parameters[2].Text = "BSBYYY";
parameters[2].Value = ""; //txtyy.Text.Trim();
parameters[3].Text = "RQ";
parameters[3].Value = ""; //dtprq.Value.ToShortDateString();
parameters[4].Text = "TITLETEXT";
parameters[4].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + title.Trim();
parameters[5].Text = "BZ";
parameters[5].Value = ""; //txtbz.Text.Trim();
parameters[6].Text = "ybps";
parameters[6].Value = "";
parameters[7].Text = "swhere";
parameters[7].Value = where1.Trim();
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.报损报溢单, Constant.ApplicationDirectory + "\\Report\\YF_药品报损报溢单.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, EventArgs e)
{
try
{
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[5];
parameters[0].Text = "类型";
parameters[0].Value = this._chineseName;
parameters[1].Text = "开始时间";
parameters[1].Value = dtpBjksj.Value.ToString("yyyy-MM-dd");
parameters[2].Text = "结束时间";
parameters[2].Value = dtpBjksj.Value.ToString("yyyy-MM-dd");
parameters[3].Text = "数据源";
parameters[3].Value = cmbSource.SelectedText;
parameters[4].Text = "科室类型";
parameters[4].Value = cmbDepartMentType.Text;
TrasenFrame.Forms.FrmReportView f = null;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\单项收入报表(经管).rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void PrintCf(string inpatient_id, string mngtype, string groupid, RelationalDatabase _DataBase)
{
DataTable tb = null;
string ssql = "select top 1 presc_no,execdept_id,cz_flag from zy_orderrecord a,zy_fee_speci b " +
" where a.inpatient_id=b.inpatient_id and a.order_id=b.order_id and a.inpatient_id='" + inpatient_id +
"' and (mngtype=" + mngtype + " or mngtype=5 ) and a.group_id=" + groupid + " and cz_flag in(0,1) order by cz_flag ";
DataTable tbcx = _DataBase.GetDataTable(ssql, 30);
decimal cfh = 0;
int zxks = 0;
int cz_flag = 0;
if (tbcx.Rows.Count > 0)
{
cfh = Convert.ToDecimal(tbcx.Rows[0]["presc_no"].ToString());
zxks = Convert.ToInt32(tbcx.Rows[0]["execdept_id"].ToString());
cz_flag = Convert.ToInt32(tbcx.Rows[0]["cz_flag"].ToString());
if (cz_flag == 1)
{
MessageBox.Show("该处方已冲正,不能打印", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
MessageBox.Show("请确认处方已执行", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cfh == 0)
{
return;
}
tb = ZY_FY.SelectCF("0", new Guid(inpatient_id), "", "", "", "", "", "", "0", 0, 0, 0, cfh, _DataBase, 2);
if (tb.Rows.Count == 0)
{
tb = ZY_FY.SelectCF("0", new Guid(inpatient_id), "", "", "", "", "", "", "1", 0, 0, 0, cfh, _DataBase, 2);
}
if (new SystemCfg(8021).Config == "0")
{
#region 区分中药
try
{
if (tb.Rows.Count == 0)
{
return;
}
DataRow[] rows;
rows = tb.Select("ypsl<>0");
ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2();
DataRow myrow;
for (int i = 0; i <= rows.Length - 1; i++)
{
myrow = Dset.发药明细单.NewRow();
myrow["rowno"] = Convert.ToString(rows[i]["序号"]);
myrow["yppm"] = Convert.ToString(rows[i]["品名"]);
myrow["ypspm"] = Convert.ToString(rows[i]["商品名"]);
myrow["ypgg"] = Convert.ToString(rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(rows[i]["厂家"]);
myrow["lsj"] = Convert.ToDecimal(rows[i]["单价"]);
myrow["ypsl"] = Convert.ToDecimal(rows[i]["数量"]);
if (Convert.ToDecimal(rows[i]["剂数"]) > 1 || Convert.ToString(rows[i]["STATITEM_CODE"]).Substring(0, 2) == "03")
{
myrow["cfts"] = "剂数:" + rows[i]["剂数"].ToString() + " 剂 " + rows[i]["煎药"].ToString();
}
myrow["ypdw"] = Convert.ToString(rows[i]["单位"]);
myrow["lsje"] = Convert.ToDecimal(rows[i]["金额"]);
myrow["shh"] = Convert.ToString(rows[i]["货号"]);
myrow["bed_no"] = Convert.ToString(rows[i]["床号"]);
myrow["name"] = Convert.ToString(rows[i]["姓名"]).Trim() + " 处方日期:" + Convert.ToString(rows[i]["处方日期"]).Trim();
myrow["inpatient_no"] = Convert.ToString(rows[i]["住院号"]);
myrow["lydw"] = Convert.ToString(rows[i]["发药科室"]) + " 医生:" + Convert.ToString(rows[i]["医生"]);
myrow["ksname"] = Yp.SeekDeptName(Convert.ToInt32(rows[i]["dept_id"]), _DataBase);
myrow["presc_no"] = rows[i]["处方号"].ToString().Trim();
myrow["order_usage"] = rows[i]["用法"].ToString().Trim() + " " + rows[i]["频次"].ToString().Trim();
myrow["xb"] = Convert.ToString(rows[i]["性别"]);
myrow["nl"] = Convert.ToString(rows[i]["年龄"]);
myrow["JTDZ"] = "";
myrow["LXDH"] = "";
myrow["SFZH"] = "";
myrow["bz1"] = Convert.ToString(rows[i]["诊断"]);
myrow["bz2"] = Convert.ToString(rows[i]["中医诊断"]);
myrow["bz3"] = Convert.ToString(rows[i]["中医症型"]);
Dset.发药明细单.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "titletext";
string ss = "";
//if (chkcydy.Checked == false)
ss = "住院处方清单";
// else
// ss = "出院带药清单";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + Yp.SeekDeptName(zxks, _DataBase) + ")" + ss.Trim();
parameters[1].Text = "BZ";
parameters[1].Value = "";
bool bview = false;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方清单医生站用.rpt", parameters, bview);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
#endregion
}
else
{
try
{
DataRow[] rows;
rows = tb.Select(" ypsl<>0");
DataRow[] rows_xy = null;
DataRow[] rows_zy = null;
rows_xy = tb.Select(" STATITEM_CODE not like '%03%' ");
rows_zy = tb.Select(" STATITEM_CODE like '%03%' ");
ts_Yk_ReportView.Dataset2 Dset;
DataRow myrow;
if (rows_xy.Length > 0)
{
Dset = new ts_Yk_ReportView.Dataset2();
for (int i = 0; i <= rows_xy.Length - 1; i++)
{
myrow = Dset.发药明细单.NewRow();
myrow["rowno"] = Convert.ToString(rows_xy[i]["序号"]);
myrow["yppm"] = Convert.ToString(rows_xy[i]["品名"]);
myrow["ypspm"] = Convert.ToString(rows_xy[i]["商品名"]);
myrow["ypgg"] = Convert.ToString(rows_xy[i]["规格"]);
myrow["sccj"] = Convert.ToString(rows_xy[i]["厂家"]);
myrow["lsj"] = Convert.ToDecimal(rows_xy[i]["单价"]);
myrow["ypsl"] = Convert.ToDecimal(rows_xy[i]["数量"]);
if (Convert.ToDecimal(rows_xy[i]["剂数"]) > 1 || Convert.ToString(rows_xy[i]["STATITEM_CODE"]).Substring(0, 2) == "03")
{
myrow["cfts"] = "剂数:" + rows_xy[i]["剂数"].ToString() + " 剂 " + rows_xy[i]["煎药"].ToString();
}
myrow["ypdw"] = Convert.ToString(rows_xy[i]["单位"]);
myrow["lsje"] = Convert.ToDecimal(rows_xy[i]["金额"]);
myrow["shh"] = Convert.ToString(rows_xy[i]["货号"]);
myrow["bed_no"] = Convert.ToString(rows_xy[i]["床号"]);
myrow["name"] = Convert.ToString(rows_xy[i]["姓名"]).Trim() + " 处方日期:" + Convert.ToString(rows_xy[i]["处方日期"]).Trim();
myrow["inpatient_no"] = Convert.ToString(rows_xy[i]["住院号"]);
myrow["lydw"] = Convert.ToString(rows_xy[i]["发药科室"]) + " 医生:" + Convert.ToString(rows_xy[i]["医生"]);
myrow["ksname"] = Yp.SeekDeptName(Convert.ToInt32(rows_xy[i]["dept_id"]), _DataBase);
myrow["presc_no"] = rows_xy[i]["处方号"].ToString().Trim();
myrow["order_usage"] = rows_xy[i]["用法"].ToString().Trim() + " " + rows_xy[i]["频次"].ToString().Trim();
myrow["xb"] = Convert.ToString(rows_xy[i]["性别"]);
myrow["nl"] = Convert.ToString(rows_xy[i]["年龄"]);
myrow["JTDZ"] = "";
myrow["LXDH"] = "";
myrow["SFZH"] = "";
myrow["bz1"] = Convert.ToString(rows_xy[i]["诊断"]);
myrow["bz2"] = Convert.ToString(rows_xy[i]["中医诊断"]);
myrow["bz3"] = Convert.ToString(rows_xy[i]["中医症型"]);
Dset.发药明细单.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "titletext";
string ss = "";
//if (chkcydy.Checked == false)
ss = "住院处方清单";
//else
// ss = "出院带药清单";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + Yp.SeekDeptName(zxks, _DataBase) + ")" + ss.Trim();
parameters[1].Text = "BZ";
parameters[1].Value = "";
bool bview = false;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方清单医生站用.rpt", parameters, bview);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
if (rows_zy.Length > 0)
{
Dset = new ts_Yk_ReportView.Dataset2();
for (int i = 0; i <= rows_zy.Length - 1; i++)
{
myrow = Dset.发药明细单.NewRow();
myrow["rowno"] = Convert.ToString(rows_zy[i]["序号"]);
myrow["yppm"] = Convert.ToString(rows_zy[i]["品名"]);
myrow["ypspm"] = Convert.ToString(rows_zy[i]["商品名"]);
myrow["ypgg"] = Convert.ToString(rows_zy[i]["规格"]);
myrow["sccj"] = Convert.ToString(rows_zy[i]["厂家"]);
myrow["lsj"] = Convert.ToDecimal(rows_zy[i]["单价"]);
myrow["ypsl"] = Convert.ToDecimal(rows_zy[i]["数量"]);
if (Convert.ToDecimal(rows_zy[i]["剂数"]) > 1 || Convert.ToString(rows_zy[i]["STATITEM_CODE"]).Substring(0, 2) == "03")
{
myrow["cfts"] = "剂数:" + rows_zy[i]["剂数"].ToString() + " 剂 " + rows_zy[i]["煎药"].ToString();
}
myrow["ypdw"] = Convert.ToString(rows_zy[i]["单位"]);
myrow["lsje"] = Convert.ToDecimal(rows_zy[i]["金额"]);
myrow["shh"] = Convert.ToString(rows_zy[i]["货号"]);
myrow["bed_no"] = Convert.ToString(rows_zy[i]["床号"]);
myrow["name"] = Convert.ToString(rows_zy[i]["姓名"]).Trim() + " 处方日期:" + Convert.ToString(rows_zy[i]["处方日期"]).Trim();
myrow["inpatient_no"] = Convert.ToString(rows_zy[i]["住院号"]);
myrow["lydw"] = Convert.ToString(rows_zy[i]["发药科室"]) + " 医生:" + Convert.ToString(rows_zy[i]["医生"]);
myrow["ksname"] = Yp.SeekDeptName(Convert.ToInt32(rows_zy[i]["dept_id"]), _DataBase);
myrow["presc_no"] = rows_zy[i]["处方号"].ToString().Trim();
myrow["order_usage"] = rows_zy[i]["用法"].ToString().Trim() + " " + rows_zy[i]["频次"].ToString().Trim();
myrow["xb"] = Convert.ToString(rows_zy[i]["性别"]);
myrow["nl"] = Convert.ToString(rows_zy[i]["年龄"]);
myrow["JTDZ"] = "";
myrow["LXDH"] = "";
myrow["SFZH"] = "";
myrow["bz1"] = Convert.ToString(rows_zy[i]["诊断"]);
myrow["bz2"] = Convert.ToString(rows_zy[i]["中医诊断"]);
myrow["bz3"] = Convert.ToString(rows_zy[i]["中医症型"]);
Dset.发药明细单.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "titletext";
string ss = "";
//if (chkcydy.Checked == false)
ss = "住院处方清单";
//else
// ss = "出院带药清单";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + Yp.SeekDeptName(zxks, _DataBase) + ")" + ss.Trim();
parameters[1].Text = "BZ";
parameters[1].Value = "";
bool bview = false;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方清单(中药)医生站用.rpt", parameters, bview);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void butprint_Click(object sender, System.EventArgs e)
{
try
{
string yplx = cmbyplx.Text.Trim();
string rq1 = dtp1.Value.ToShortDateString();
string rq2 = dtp2.Value.ToShortDateString();
string pmlx = "";
if (rdosl.Checked == true)
{
pmlx = rdosl.Text.Trim();
}
if (rdoje.Checked == true)
{
pmlx = rdoje.Text.Trim();
}
if (rdojhje.Checked == true)
{
pmlx = rdojhje.Text.Trim();
}
string pmws = txtnum.Text.Trim();
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1();
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
myrow = Dset.进出货排名统计.NewRow();
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["排名"]);
myrow["ypspm"] = Convert.ToString(tb.Rows[i]["品名"]);
myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["pfj"] = Convert.ToDecimal(tb.Rows[i]["批发价"]);
myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["零售价"]);
myrow["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]);
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["jhje"] = Convert.ToString(tb.Rows[i]["进货金额"]);
myrow["pfje"] = Convert.ToString(tb.Rows[i]["批发金额"]);
myrow["lsje"] = Convert.ToString(tb.Rows[i]["零售金额"]);
myrow["plce"] = Convert.ToDecimal(tb.Rows[i]["零售金额"]) - Convert.ToDecimal(tb.Rows[i]["批发金额"]);
myrow["jlce"] = Convert.ToDecimal(tb.Rows[i]["零售金额"]) - Convert.ToDecimal(tb.Rows[i]["进货金额"]);
myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]);
Dset.进出货排名统计.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[7];
parameters[0].Text = "yplx";
parameters[0].Value = yplx.Trim();
parameters[1].Text = "rq1";
parameters[1].Value = rq1.Trim();
parameters[2].Text = "rq2";
parameters[2].Value = rq2.Trim();
parameters[3].Text = "pmlx";
parameters[3].Value = pmlx.Trim();
parameters[4].Text = "pmws";
parameters[4].Value = pmws.Trim();
parameters[5].Text = "TITLETEXT";
parameters[5].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + this.Text;
parameters[6].Text = "ckmc";
parameters[6].Value = cmbck.Text.Trim();
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.进出货排名统计, Constant.ApplicationDirectory + "\\Report\\YK_进货排名统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
try
{
DataTable tbsk = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow;
for (int i = 0; i <= tbsk.Rows.Count - 1; i++)
{
myrow = Dset.交款表.NewRow();
int x = i + 1;
myrow["序号"] = Convert.ToString(tbsk.Rows[i]["序号"]);
myrow["收费员"] = Convert.ToString(tbsk.Rows[i]["收费员"]);
//myrow["交款时间"] = Convert.ToString(tbsk.Rows[i]["缴款时间"]);
myrow["发票金额"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["发票金额"], "0"));
myrow["有效张数"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["有效张数"], "0"));
myrow["废票张数"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["废票张数"], "0"));
myrow["现金支付"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["现金支付"], "0"));
myrow["银联支付"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["银联支付"], "0"));
myrow["支票支付"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["支票支付"], "0"));
myrow["医保支付"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["医保支付"], "0"));
myrow["财务记账"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["财务记账"], "0"));
myrow["欠费挂账"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["欠费挂账"], "0"));
myrow["优惠金额"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["优惠金额"], "0"));
myrow["舍入金额"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["舍入金额"], "0"));
if (tbsk.Columns.Contains("废票金额") == true)
{
myrow["作废金额"] = Convert.ToDecimal(Convertor.IsNull(tbsk.Rows[i]["废票金额"], "0"));
}
Dset.交款表.Rows.Add(myrow);
}
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 = "收费员:" + cmbuser.Text.Trim();
parameters[3].Text = "现金大写";
parameters[3].Value = "";
TrasenFrame.Forms.FrmReportView 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 butprint_Click(object sender, System.EventArgs e)
{
string where1 = "";
if (rdo1.Checked == true)
{
where1 = "按日期统计 日期:" + dtp1.Value.ToShortDateString();
where1 = where1 + " 到:" + dtp2.Value.ToShortDateString();
}
else
{
where1 = "按会计月份统计 日期:" + this.statusBar1.Panels[3].Text;
}
decimal pcjhje = 0;
decimal ykjhje = 0;
try
{
YpConfig ss = new YpConfig(Convert.ToInt32(cmbyjks.SelectedValue), InstanceForm.BDatabase);
this.Cursor = PubStaticFun.WaitCursor();
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2();
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 2; i++)
{
myrow = Dset.药品盘点单.NewRow();
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]);
if (ss.打印单据时单据显示商品名 == true)
{
myrow["ypmc"] = Convert.ToString(tb.Rows[i]["商品名"]);
}
else
{
myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]);
}
myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["pfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["批发价"], "0"));
myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["零售价"], "0"));
myrow["zcsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["帐存数量"], "0"));
myrow["zcje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["帐存金额"], "0"));
myrow["pcsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盘存数量"], "0"));
myrow["pcje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盘存金额"], "0"));
myrow["yksl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盈亏数量"], "0"));
myrow["ykje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盈亏金额"], "0"));
myrow["jhj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进价"], "0"));
myrow["jhje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进货金额盈亏"], "0"));
myrow["jlce"] = 0;
pcjhje = pcjhje + Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进价"], "0")) * Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["盘存数量"], "0"));
ykjhje = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["进货金额盈亏"], "0"));
myrow["ypph"] = Convert.ToString(tb.Rows[i]["批号"]);
myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]);
myrow["kwmc"] = ""; //Convert.ToString(tb.Rows[i]["库位"]);
Dset.药品盘点单.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[10];
parameters[0].Text = "DJH";
parameters[0].Value = ""; //this.lbldjh.Text;
parameters[1].Text = "DJY";
parameters[1].Value = InstanceForm.BCurrentUser.Name;
parameters[2].Text = "RQ";
parameters[2].Value = ""; //dtprq.Text.Trim();
parameters[3].Text = "TITLETEXT";
parameters[3].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + this.Text;
parameters[4].Text = "BZ";
parameters[4].Value = ""; //txtbz.Text.Trim();
parameters[5].Text = "swhere";
parameters[5].Value = where1.Trim();
parameters[6].Text = "YKJHJE";
parameters[6].Value = Convert.ToDecimal(ykjhje.ToString("0.00"));
parameters[7].Text = "PCJHJE";
parameters[7].Value = Convert.ToDecimal(pcjhje.ToString("0.00"));
parameters[8].Text = "ckmc";
parameters[8].Value = cmbyjks.Text.Trim();
parameters[9].Text = "dyr";
parameters[9].Value = InstanceForm.BCurrentUser.Name;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品盘点单, Constant.ApplicationDirectory + "\\Report\\YF_药品盘点单据.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
this.Cursor = Cursors.Arrow;
}
}
private void butprint_Click(object sender, System.EventArgs e)
{
try
{
string where1 = "日期:" + dtp1.Value.ToShortDateString();
where1 = where1 + " 到:" + dtp2.Value.ToShortDateString();
if (rdosl.Checked == true && Convert.ToInt32(Convertor.IsNull(txtdm.Tag, "0")) != 0)
{
where1 = where1 + " 药品名称:" + txtdm.Text.Trim();
}
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2();
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
myrow = Dset.药品汇总统计.NewRow();
if (this.rdoje.Checked == true)
{
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]);
myrow["wardname"] = Convert.ToString(tb.Rows[i]["病区"]);
myrow["DJZS"] = Convert.ToDecimal(tb.Rows[i]["单据张数"]);
myrow["djje"] = Convert.ToDecimal(tb.Rows[i]["金额"]);
}
else
{
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]);
myrow["wardname"] = Convert.ToString(tb.Rows[i]["病区"]);
myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]);
myrow["yppm"] = Convert.ToString(tb.Rows[i]["品名"]);
myrow["ypspm"] = Convert.ToString(tb.Rows[i]["商品名"]);
myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]);
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["lsje"] = Convert.ToDecimal(tb.Rows[i]["金额"]);
}
Dset.药品汇总统计.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "where1";
parameters[0].Value = where1.Trim();
parameters[1].Text = "where2";
parameters[1].Value = "";
parameters[2].Text = "title";
parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + "借药汇总统计";
if (rdoje.Checked == true)
{
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品汇总统计, Constant.ApplicationDirectory + "\\Report\\YF_药品领药按单据汇总统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
else
{
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品汇总统计, Constant.ApplicationDirectory + "\\Report\\YF_药品领药按药品汇总统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprinthz_Click(object sender, EventArgs e)
{
try
{
DataTable tb = (DataTable)this.myDataGrid2.DataSource;
ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2();
if (tb.Rows.Count == 0)
{
return;
}
DataTable tbmx = (DataTable)this.myDataGrid1.DataSource;
DataRow[] rows;
rows = tbmx.Select("ypsl<>0");
if (rows.Length == 0 && new SystemCfg(8041).Config == "1")
{
MessageBox.Show("没有要打印的已发药处方", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
butprinthz.Enabled = false;
//string lydw=Yp.SeekWardName(tb.Rows[0]["wardid"].ToString().Trim());
//string fyr=Yp.SeekEmpName(Convert.ToInt32(tb.Rows[0]["fyr"]));
//string pyr=Yp.SeekEmpName(Convert.ToInt32(tb.Rows[0]["pyr"]));
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
if (tb.Rows[i]["品名"].ToString().Trim().Equals("总金额"))
{
continue;
}
myrow = Dset.发药明细单.NewRow();
myrow["yppm"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["品名"]), "");
myrow["ypspm"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["商品名"]), "");
myrow["ypgg"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["规格"]), "");
myrow["sccj"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["厂家"]), "");
myrow["lsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["单价"], "0"));
myrow["ypsl"] = Convertor.IsNull(tb.Rows[i]["领药数"], "");
myrow["ypdw"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["单位"]), "");
myrow["lsje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["金额"], "0"));
myrow["shh"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["货号"]), "");
myrow["tlfl"] = "";
myrow["fyrq"] = "";
myrow["fyr"] = "";
myrow["pyr"] = "";
myrow["lydw"] = "";
myrow["bz"] = Convertor.IsNull(Convert.ToString(tb.Rows[i]["药库单位"]), "");
Dset.发药明细单.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "title";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")代煎处方汇总单";
parameters[1].Text = "lydwHeadText";
parameters[1].Value = "";
bool bview = this.chkprintview.Checked == true ? false : true;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.发药明细单, Constant.ApplicationDirectory + "\\Report\\YF_住院处方汇总单.rpt", parameters, bview);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
butprinthz.Enabled = true;
}
catch (System.Exception err)
{
butprinthz.Enabled = true;
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
try
{
DataTable tbmx = (DataTable)dataGridView1.DataSource;
DataTable tbzf = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= tbmx.Rows.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = tbmx.Rows[i]["项目"].ToString();
}
Dset.收费项目.Rows.Add(myrow);
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int nrow = 0; nrow <= tbmx.Rows.Count - 1; nrow++)
{
int x = nrow + 1;
string nm = "je" + x.ToString();
myrow1[nm] = tbmx.Rows[nrow]["金额"].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
DataRow myrow2 = Dset.收费项目1.NewRow();
for (int i = 0; i <= tbzf.Rows.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow2[nm] = tbzf.Rows[i]["项目"].ToString();
}
Dset.收费项目1.Rows.Add(myrow2);
DataRow myrow3 = Dset.收费项目金额1.NewRow();
for (int nrow = 0; nrow <= tbzf.Rows.Count - 1; nrow++)
{
int x = nrow + 1;
string nm = "je" + x.ToString();
myrow3[nm] = tbzf.Rows[nrow]["金额"].ToString();
}
Dset.收费项目金额1.Rows.Add(myrow3);
ParameterEx[] parameters = new ParameterEx[8];
parameters[0].Text = "结帐起始时间";
parameters[0].Value = "" + dtp1.Value.ToString() + " 到:" + dtp2.Value.ToString();
parameters[1].Text = "医院名称";
parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[2].Text = "填报日期";
parameters[2].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
parameters[3].Text = "备注";
parameters[3].Value = "";
decimal sumhj = Convert.ToDecimal(Convertor.IsNull(tbzf.Compute("sum(金额)", "项目='发票金额'"), "0"));
parameters[4].Text = "合计大写";
parameters[4].Value = Money.NumToChn(sumhj.ToString());
parameters[5].Text = "合计小写";
parameters[5].Value = sumhj;
parameters[6].Text = "操作员";
parameters[6].Value = InstanceForm.BCurrentUser.Name;
parameters[7].Text = "收费员"; //Add By zp 2014-02-10 新增收费员
parameters[7].Value = SfyName;
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 butprint_Click(object sender, System.EventArgs e)
{
try
{
string bz = "调价日期 " + this.dtp1.Value.ToShortDateString() + " 到 " + this.dtp2.Value.ToShortDateString();
if (chkyplx.Checked == true)
{
bz = bz + " 药品类型 " + cmbyplx.Text;
}
if (chkypmc.Checked == true)
{
bz = bz + " 药品名称 " + txtypmc.Text;
}
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2();
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
myrow = Dset.药品调价单.NewRow();
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]);
if (s.打印单据时单据显示商品名 == true)
{
myrow["ypmc"] = Convert.ToString(tb.Rows[i]["商品名"]);
}
else
{
myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]);
}
myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["ypsl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调价数量"], "0"));
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["ypfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["原批发价"], "0"));
myrow["xpfj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调批发价"], "0"));
decimal pfjdwcj = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调批发价"], "0")) - Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["原批发价"], "0"));
decimal tpfje = pfjdwcj * (Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调价数量"], "0")));
myrow["pfjdwcj"] = pfjdwcj.ToString("0.00");
myrow["tpfje"] = tpfje.ToString("0.00");
myrow["ylsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["原零售价"], "0"));
myrow["xlsj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调零售价"], "0"));
myrow["lsjdwcj"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["单位差价"], "0"));
myrow["tlsje"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["调零售金额"], "0"));
myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]);
myrow["tjwh"] = Convert.ToString(tb.Rows[i]["调价文号"]);
myrow["zxrq"] = Convert.ToString(tb.Rows[i]["调价日期"]);
Dset.药品调价单.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[7];
parameters[0].Text = "DJH";
parameters[0].Value = "0";
parameters[1].Text = "DJY";
parameters[1].Value = InstanceForm.BCurrentUser.Name;
parameters[2].Text = "RQ";
parameters[2].Value = "";
parameters[3].Text = "TJWH";
parameters[3].Value = "";
parameters[4].Text = "TITLETEXT";
parameters[4].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + "药品调价单";
parameters[5].Text = "BZ";
parameters[5].Value = bz;
parameters[6].Text = "swhere";
parameters[6].Value = bz.Trim();
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.药品调价单, Constant.ApplicationDirectory + "\\Report\\YF_药品调价单据.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null || ((DataTable)dataGridView1.DataSource).Rows.Count == 0)
{
MessageBox.Show("没有数据！");
return;
}
try
{
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 rq = "";
string sfy = "";
if (_menuTag.Function_Name == "Fun_ts_mz_tjbb_yb_rtj_jk")
{
rq = "缴款日期:";
sfy = "缴款员:";
}
else
{
rq = "收费日期:";
sfy = "收费员:";
}
parameters[2].Text = "备注";
parameters[2].Value = rq + dtp1.Value.ToString() + " 到 " + dtp2.Value.ToString() + " 部门名称:" + cmbjgbm.Text + " " + sfy + cmbuser.Text.Trim();
parameters[3].Text = "现金大写";
parameters[3].Value = "";
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 btnprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
if (dataGridView2.DataSource == null)
{
return;
}
DataTable hztb = (DataTable)dataGridView1.DataSource;
DataTable mxtb = (DataTable)dataGridView2.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow;
for (int i = 0; i <= hztb.Rows.Count - 1; i++)
{
myrow = Dset.银医办卡统计.NewRow();
myrow["序号"] = Convert.ToString(hztb.Rows[i]["序号"]);
myrow["卡类型"] = Convert.ToString(hztb.Rows[i]["卡类型"]);
myrow["办卡数"] = Convert.ToString(hztb.Rows[i]["办卡数"]);
myrow["有效数"] = Convert.ToString(hztb.Rows[i]["有效数"]);
myrow["退卡数"] = Convert.ToString(hztb.Rows[i]["退卡数"]);
myrow["冻结数"] = Convert.ToString(hztb.Rows[i]["冻结数"]);
myrow["挂失数"] = Convert.ToString(hztb.Rows[i]["挂失数"]);
//myrow["预交金"] = Convert.ToString(hztb.Rows[i]["预交金"]);
myrow["办卡金额"] = Convert.ToString(hztb.Rows[i]["办卡金额"]);
myrow["退办卡金额"] = Convert.ToString(hztb.Rows[i]["退办卡金额"]);
Dset.银医办卡统计.Rows.Add(myrow);
}
DataRow mymxrow;
for (int i = 0; i <= mxtb.Rows.Count - 1; i++)
{
mymxrow = Dset.诊疗卡办卡明细.NewRow();
mymxrow["序号"] = Convert.ToString(mxtb.Rows[i]["序号"]);
mymxrow["姓名"] = Convert.ToString(mxtb.Rows[i]["姓名"]);
mymxrow["卡号"] = Convert.ToString(mxtb.Rows[i]["卡号"]);
//mymxrow["预交金"] = Convert.ToString(mxtb.Rows[i]["预交金"]);
mymxrow["身份证号"] = Convert.ToString(mxtb.Rows[i]["身份证"]);
mymxrow["办卡金额"] = Convert.ToString(mxtb.Rows[i]["办卡金额"]);
mymxrow["退卡金额"] = Convert.ToString(mxtb.Rows[i]["退办卡金额"]);
mymxrow["办卡操作员"] = Convert.ToString(mxtb.Rows[i]["办卡操作员"]);
mymxrow["退卡操作员"] = Convert.ToString(mxtb.Rows[i]["退卡操作员"]);
Dset.诊疗卡办卡明细.Rows.Add(mymxrow);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "日期";
parameters[0].Value = dtp1.Value.ToString() + " - " + dtp2.Value.ToString();
parameters[1].Text = "打印人";
parameters[1].Value = InstanceForm.BCurrentUser.Name;
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\MZ_诊疗卡办卡数统计.rpt", parameters, false);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null)
{
return;
}
try
{
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[6];
parameters[0].Text = "医院名称";
parameters[0].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[1].Text = "统计来源";
parameters[1].Value = rdmz.Checked == true ? "门诊" : "住院";
parameters[2].Text = "统计类型";
parameters[2].Value = rdoqr.Checked == true ? "确认情况" : "开单情况";
parameters[3].Text = "rq1";
parameters[3].Value = dtp1.Value.ToShortDateString();
parameters[4].Text = "rq2";
parameters[4].Value = dtp2.Value.ToShortDateString();
parameters[5].Text = "jgbm";
parameters[5].Value = cmbjgbm.Text;
TrasenFrame.Forms.FrmReportView f;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\YY_执行科室收入明细情况.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_Click(object sender, System.EventArgs e)
{
try
{
string where1 = "";
string where2 = InstanceForm.BCurrentUser.Name;
//where1 = "药剂科室:" + cmbyjks.Text.Trim() + " ";
if (rdo1.Checked == true)
{
where1 = where1 + "按日期统计 日期:" + dtp1.Value.ToShortDateString();
where1 = where1 + " 到:" + dtp2.Value.ToShortDateString();
}
else
{
where1 = where1 + "按会计月份统计 日期:" + this.statusBar1.Panels[3].Text;
}
DataTable tb = (DataTable)this.myDataGrid1.DataSource;
ts_Yk_ReportView.Dataset2 Dset = new ts_Yk_ReportView.Dataset2();
DataRow myrow;
int ii = 0;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
myrow = Dset.单据汇总统计.NewRow();
myrow["xh"] = Convert.ToString(tb.Rows[i]["序号"]);
myrow["rckfs"] = Convert.ToString(tb.Rows[i]["入库方式"]);
myrow["wldw"] = Convert.ToString(tb.Rows[i]["往来单位"]);
myrow["jhje"] = Convert.ToDecimal(tb.Rows[i]["进货金额"]);
myrow["pfje"] = Convert.ToDecimal(tb.Rows[i]["批发金额"]);
myrow["lsje"] = Convert.ToDecimal(tb.Rows[i]["零售金额"]);
myrow["jlce"] = Convert.ToDecimal(tb.Rows[i]["进零差额"]);
myrow["plce"] = Convert.ToDecimal(tb.Rows[i]["批零差额"]);
myrow["djzs"] = Convert.ToDecimal(tb.Rows[i]["单据张数"]);
Dset.单据汇总统计.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[3];
parameters[0].Text = "where1";
parameters[0].Value = where1.Trim();
parameters[1].Text = "where2";
parameters[1].Value = where2.Trim();
parameters[2].Text = "title";
parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + "入库汇总表";
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.单据汇总统计, Constant.ApplicationDirectory + "\\Report\\YP_入库汇总报表.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, System.EventArgs e)
{
try
{
string title = "";
string where1 = "";
if (rdo1.Checked == true)
{
title = "门诊医生用药情况统计";
}
else
{
title = "住院医生用药情况统计";
}
where1 = "日期:" + dtp1.Value.ToShortDateString();
where1 = where1 + " 到:" + dtp2.Value.ToShortDateString();
DataView dv = (DataView)this.myDataGrid1.DataSource;
//DataTable tb=(DataTable)this.myDataGrid1.DataSource;
DataTable tb = dv.Table;
ts_Yk_ReportView.Dataset1 Dset = new ts_Yk_ReportView.Dataset1();
DataRow myrow;
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
myrow = Dset.医生用药情况统计.NewRow();
myrow["ypmc"] = Convert.ToString(tb.Rows[i]["品名"]);
myrow["ypspm"] = Convert.ToString(tb.Rows[i]["商品名"]);
myrow["ypgg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["sccj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["单价"]);
myrow["ksmc"] = Convert.ToString(tb.Rows[i]["科室"]);
myrow["ysmc"] = Convert.ToString(tb.Rows[i]["医生"]);
myrow["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]);
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["lsje"] = Convert.ToDecimal(tb.Rows[i]["金额"]);
myrow["xh"] = Convert.ToInt32(tb.Rows[i]["序号"]);
Dset.医生用药情况统计.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[2];
parameters[0].Text = "swhere";
parameters[0].Value = where1.Trim();
parameters[1].Text = "title";
parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + title.Trim();
TrasenFrame.Forms.FrmReportView f = new TrasenFrame.Forms.FrmReportView(Dset.医生用药情况统计, Constant.ApplicationDirectory + "\\Report\\YF_医生用药情况统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message);
}
}
private void butprint_Click(object sender, EventArgs e)
{
if (dataGridView1.DataSource == null || ((DataTable)dataGridView1.DataSource).Rows.Count == 0)
{
MessageBox.Show("没有数据！");
return;
}
try
{
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();
}
try
{
//add by zouchihua 2013-5-6
myrow["T47"] = this.txtBkje.Text;
}
catch { };
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[26];
parameters[0].Text = "结帐起始时间";
parameters[0].Value = "";
parameters[1].Text = "医院名称";
parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName;
parameters[2].Text = "收费员";
parameters[2].Value = cmbuser.Text;
parameters[3].Text = "挂号退费数";
parameters[3].Value = "";
parameters[4].Text = "挂号退费金额";
parameters[4].Value = "";
parameters[5].Text = "收费退费数";
parameters[5].Value = "";
parameters[6].Text = "收费退费金额";
parameters[6].Value = "";
parameters[7].Text = "填报日期";
parameters[7].Value = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString();
parameters[8].Text = "现金";
parameters[8].Value = lblxjzf.Text.Trim();
parameters[9].Text = "银联";
parameters[9].Value = lblylkzf.Text.Trim();
parameters[10].Text = "医保";
parameters[10].Value = lblybzf.Text.Trim();
parameters[11].Text = "财务记账";
parameters[11].Value = lblcwjz.Text.Trim();
parameters[12].Text = "欠费";
parameters[12].Value = lblqfgz.Text.Trim();
parameters[13].Text = "优惠";
parameters[13].Value = lblyhje.Text.Trim();
parameters[14].Text = "舍入";
parameters[14].Value = lblsrje.Text.Trim();
parameters[15].Text = "有效张数";
parameters[15].Value = lblyxzs.Text.Trim() + "张";
parameters[16].Text = "废票张数";
parameters[16].Value = lblfpzs.Text.Trim() + "张";
parameters[17].Text = "发票金额";
parameters[17].Value = lblfpje.Text.Trim();
parameters[18].Text = "现金大写";
parameters[18].Value = "";
parameters[19].Text = "备注";
parameters[19].Value = lblrq.Text + ":" + dtp1.Value.ToString() + " 到:" + dtp2.Value.ToString() + " 收费员:" + cmbuser.Text.Trim() + " 部门名称:" + cmbjgbm.Text;
parameters[20].Text = "废票金额";
parameters[20].Value = lblzfje.Text.Trim();
parameters[21].Text = "废票号集合";
parameters[21].Value = "";
parameters[22].Text = "支票";
parameters[22].Value = lblzpzf.Text;
parameters[23].Text = "预收款";
parameters[23].Value = lblyjj.Text;
//add by tck 2013-08-22
parameters[24].Text = "离休老干";
parameters[24].Value = lgje.ToString();
parameters[25].Text = "职工血透";
parameters[25].Value = xtje.ToString();
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 Print()
{
try
{
DataTable dt = (DataTable)dataGridView1.DataSource;
ts_mz_report.DataSet1 Dset = new ts_mz_report.DataSet1();
DataRow myrow = Dset.收费项目.NewRow();
for (int i = 0; i <= dt.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "T" + x.ToString();
myrow[nm] = dt.Columns[i].ColumnName.Trim();
}
Dset.收费项目.Rows.Add(myrow);
for (int nrow = 0; nrow <= dt.Rows.Count - 1; nrow++)
{
DataRow myrow1 = Dset.收费项目金额.NewRow();
for (int i = 0; i <= dt.Columns.Count - 1; i++)
{
int x = i + 1;
string nm = "JE" + x.ToString();
myrow1[nm] = dt.Rows[nrow][dt.Columns[i].ColumnName].ToString();
}
Dset.收费项目金额.Rows.Add(myrow1);
}
ParameterEx[] parameters = new ParameterEx[13];
parameters[0].Text = "黑白B超";
parameters[0].Value = GetNumColOfItem(dt, "黑白B超");
parameters[1].Text = "彩超";
parameters[1].Value = GetNumColOfItem(dt, "黑白B超");
parameters[2].Text = "心电图";
parameters[2].Value = GetNumColOfItem(dt, "心电图");
parameters[3].Text = "脑血流图";
parameters[3].Value = GetNumColOfItem(dt, "脑血流图");
parameters[4].Text = "胃镜";
parameters[4].Value = GetNumColOfItem(dt, "胃镜");
parameters[5].Text = "肠镜";
parameters[5].Value = GetNumColOfItem(dt, "肠镜");
parameters[6].Text = "肝肾功能";
parameters[6].Value = GetNumColOfItem(dt, "肝肾功能");
parameters[7].Text = "三大常规";
parameters[7].Value = GetNumColOfItem(dt, "三大常规");
parameters[8].Text = "用血量";
parameters[8].Value = GetNumColOfItem(dt, "用血量");
parameters[9].Text = "血气分析";
parameters[9].Value = GetNumColOfItem(dt, "血气分析");
parameters[10].Text = "切片";
parameters[10].Value = GetNumColOfItem(dt, "切片");
parameters[11].Text = "涂片";
parameters[11].Value = GetNumColOfItem(dt, "涂片");
parameters[12].Text = "动态心电图";
parameters[12].Value = GetNumColOfItem(dt, "动态心电图");
TrasenFrame.Forms.FrmReportView f = null;
f = new TrasenFrame.Forms.FrmReportView(Dset, Constant.ApplicationDirectory + "\\Report\\医技项目人次统计.rpt", parameters);
if (f.LoadReportSuccess)
{
f.Show();
}
else
{
f.Dispose();
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}