private void butprint_Click(object sender, System.EventArgs e)
{
try
{
string yplx = chkyplx.Checked == true?Convertor.IsNull(cmbyplx.Text, "全部") : "全部";
string ypzlx = chkypzlx.Checked == true?Convertor.IsNull(cmbypzlx.Text, "全部") : "全部";
string ypjx = chkjx.Checked == true?Convertor.IsNull(cmbjx.Text, "全部") : "全部";
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.ToString(tb.Rows[i]["批发价"]);
myrow["lsj"] = Convert.ToString(tb.Rows[i]["零售价"]);
myrow["kcl"] = Convert.ToString(tb.Rows[i]["总库存"]);
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["pfje"] = Convert.ToString(tb.Rows[i]["批发金额"]);
myrow["lsje"] = Convert.ToString(tb.Rows[i]["零售金额"]);
myrow["shh"] = Convert.ToString(tb.Rows[i]["货号"]);
Dset.库存情况表.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "yplx";
parameters[0].Value = yplx.Trim();
parameters[1].Text = "ypzlx";
parameters[1].Value = ypzlx.Trim();
parameters[2].Text = "ypjx";
parameters[2].Value = ypjx.Trim();
parameters[3].Text = "TITLETEXT";
parameters[3].Value = TrasenFrame.Classes.Constant.HospitalName + "全院药品库存情况";
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)
{
try
{
string swhere = "药房:" + cmbks.Text.Trim() + " 日期:" + dtp1.Value.ToShortDateString() + " 到 " + dtp2.Value.ToShortDateString();
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["lyyf"] = Convert.ToString(tb.Rows[i]["领药药房"]);
myrow["djh"] = Convert.ToInt64(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["ypsl"] = Convert.ToDecimal(tb.Rows[i]["数量"]);
myrow["ypdw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["jj"] = Convert.ToDecimal(tb.Rows[i]["进价"]);
myrow["jhje"] = Convert.ToDecimal(tb.Rows[i]["进货金额"]);
myrow["lsj"] = Convert.ToDecimal(tb.Rows[i]["零售价"]);
myrow["lsje"] = 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[2];
parameters[0].Text = "swhere";
parameters[0].Value = swhere.Trim();
parameters[1].Text = "TITLETEXT";
parameters[1].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + 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 butprintmx_Click(object sender, System.EventArgs e)
{
try
{
DataTable tb = (DataTable)this.myDataGrid2.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["pm"] = Convert.ToString(tb.Rows[i]["品名"]);
myrow["gg"] = Convert.ToString(tb.Rows[i]["规格"]);
myrow["cj"] = Convert.ToString(tb.Rows[i]["厂家"]);
myrow["lsj"] = Convert.ToString(tb.Rows[i]["零售价"]);
myrow["sl"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["数量"], "0"));
myrow["dw"] = Convert.ToString(tb.Rows[i]["单位"]);
myrow["je"] = Convert.ToDecimal(Convertor.IsNull(tb.Rows[i]["金额"], "0"));
myrow["bfbl"] = Convert.ToString(tb.Rows[i]["百分比"]);
Dset.药理分类统计明细.Rows.Add(myrow);
}
ParameterEx[] parameters = new ParameterEx[4];
parameters[0].Text = "swhere";
parameters[0].Value = "药剂科室：" + cmbyjks.Text.Trim() + " 日期从：" + dtp1.Value.ToShortDateString() + " 到 " + dtp2.Value.ToShortDateString();
parameters[1].Text = "swhere1";
parameters[1].Value = this.myDataGrid1.CaptionText;
parameters[2].Text = "title";
parameters[2].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + InstanceForm.BCurrentDept.DeptName + ")" + this.Text;
parameters[3].Text = "username";
parameters[3].Value = InstanceForm.BCurrentUser.Name;
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 (cmbck.Visible == true) where1 = "仓库名称:" + cmbck.Text.Trim();
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 = _menuTag.Function_Name.Trim() == "Fun_ts_yk_tjbb_bshz" ? "药品报损汇总统计" : "药品报溢汇总统计";
ParameterEx[] parameters = new ParameterEx[9];
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();
parameters[8].Text = "ckmc";
parameters[8].Value = cmbck.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)
{
try
{
string yplx = cmbyplx.Text.Trim();
string rq1 = dtp1.Value.ToShortDateString();
string rq2 = dtp2.Value.ToShortDateString();
string pmlx = this.rdosl.Checked == true?this.rdosl.Text:this.rdoje.Text;
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["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["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, 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)
{
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, System.EventArgs e)
{
try
{
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["xmmc"] = Convert.ToString(tb.Rows[i]["项目1"]);
myrow["jhje"] = Convert.ToString(tb.Rows[i]["进货金额1"]);
myrow["je"] = Convert.ToString(tb.Rows[i]["零售金额1"]);
myrow["jlce"] = Convert.ToString(tb.Rows[i]["进零差额1"]);
myrow["xmmc1"] = Convert.ToString(tb.Rows[i]["项目2"]);
myrow["jhje1"] = Convert.ToString(tb.Rows[i]["进货金额2"]);
myrow["je1"] = Convert.ToString(tb.Rows[i]["零售金额2"]);
myrow["jlce1"] = Convert.ToString(tb.Rows[i]["进零差额2"]);
Dset.进销存情况表.Rows.Add(myrow);
}
string kjqj = "";
string bz = "";
if (checkBox1.Checked == true)
{
kjqj = "年份:" + cmbyear.Text + "年 月份:" + cmbmonth.Text + "月 日期区间" + this.statusBarPanel3.Text + " 药品类型:" + cmbyplx.Text;
bz = "进销存月报表";
}
else
{
kjqj = "年份:" + cmbyear.Text + "年 药品类型:" + cmbyplx.Text;
bz = "进销存年报表";
}
ParameterEx[] parameters = new ParameterEx[5];
parameters[0].Text = "nf";
parameters[0].Value = "";
parameters[1].Text = "yf";
parameters[1].Value = "";
parameters[2].Text = "kjqj";
parameters[2].Value = kjqj;
parameters[3].Text = "dyr";
parameters[3].Value = InstanceForm.BCurrentUser.Name;
parameters[4].Text = "TITLETEXT";
parameters[4].Value = TrasenFrame.Classes.Constant.HospitalName + "(" + cmbyjks.Text.Trim() + ")" + bz;
TrasenFrame.Forms.FrmReportView f;
if (checkBox2.Checked == true)
{
f = new TrasenFrame.Forms.FrmReportView(Dset.进销存情况表, Constant.ApplicationDirectory + "\\Report\\YK_进销存情况表_进货金额.rpt", parameters);
}
else
{
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);
}
}
