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