private void btPrint_Click(object sender, EventArgs e)
{
if (this.dgvDrug.CurrentCell != null)
{
DataTable dt = (DataTable)this.dgvDrug.DataSource;
int RowIndex = this.dgvDrug.CurrentCell.RowIndex;
Report = new grproLib.GridppReport();
Report.LoadFromFile(HIS.SYSTEM.PubicBaseClasses.Constant.ApplicationDirectory + "\\report\\护士统领汇总单据.grf");
Report.ParameterByName("UserName").AsString = data[6];
Report.ParameterByName("ExeTime").AsString = data[0];
Report.ParameterByName("DeptName").AsString = BaseNameFactory.GetName(baseNameType.科室名称, data[1]);
Report.ParameterByName("DispDept").AsString = BaseNameFactory.GetName(baseNameType.科室名称, data[2]);
Report.ParameterByName("Printer").AsString = _currentUser.Name;
Report.ParameterByName("PrintTime").AsString = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime.ToString();
Report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
//List<string> patNames = new List<string>();
//int masterID = Convert.ToInt32(dsMessageData.dtMessageMaster.Rows[RowIndex]["DRUGMESSAGEID"].ToString().Trim());
//string patname = "";
//DataRow[] drs = dsMessageData.dtMessageOrder.Select("masterid=" + masterID);
//for (int i = 0; i < drs.Length; i++)
//{
// string patS = patNames.Find(delegate(string y) { return y == drs[i]["patname"].ToString(); });
// if (patS == null)
// {
// patNames.Add(drs[i]["patname"].ToString());
// patname += drs[i]["patname"].ToString() + ",";
// }
//}
//if (patname != "") patname = patname.Substring(0, patname.Length - 1);
Report.ParameterByName("PatientNames").AsString = "";
Report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(Report_FetchRecord);
Report.PrintPreview(false);
}
}
/// <summary>
/// 打印明细账报表
/// </summary>
/// <param name="printCondition">报表头</param>
/// <param name="orderDt">报表明细</param>
/// <param name="path">报表文件路径</param>
public override void PrintReport(YP_PrintCondition printCondition, System.Data.DataTable orderDt, string path)
{
if (printCondition == null || orderDt == null)
{
return;
}
YP_AccountCondition actCondition = (YP_AccountCondition)printCondition;
if (orderDt.Rows.Count > 0)
{
_printOrder = orderDt;
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("AccountYear").AsString = actCondition.actYear;
report.ParameterByName("AccountMonth").AsString = actCondition.actMonth;
report.ParameterByName("DrugName").AsString = actCondition.drugName;
report.ParameterByName("ProductName").AsString = actCondition.productName;
report.ParameterByName("BeginNum").AsString = actCondition.beginNum;
report.ParameterByName("BeginFee").AsString = actCondition.begingFee;
report.ParameterByName("EndNum").AsString = actCondition.endNum;
report.ParameterByName("EndFee").AsString = actCondition.endFee;
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.PrintPreview(false);
}
}
/// <summary>
/// 供应商报表
/// </summary>
/// <param name="printCondition">进销存报表头</param>
/// <param name="orderDt">进销存报表明细</param>
/// <param name="path">报表文件路径</param>
public override void PrintReport(YP_PrintCondition printCondition, System.Data.DataTable orderDt, string path)
{
try
{
if (orderDt != null)
{
if (orderDt.Rows.Count > 0)
{
_printOrder = orderDt;
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("btime").AsString = printCondition.actYear;
report.ParameterByName("etime").AsString = printCondition.actMonth;
report.ParameterByName("Printer").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.GetUserName(printCondition.userId);
report.PrintPreview(false);
}
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// 打印调价单
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
if (billMaster == null || billOrder == null)
{
return;
}
HIS.Model.YP_AdjMaster printMaster = (HIS.Model.YP_AdjMaster)billMaster;
if (billOrder.Rows.Count > 0)
{
_printOrder = billOrder;
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("BillNo").AsString = printMaster.BillNum.ToString();
report.ParameterByName("AdjCode").AsString = printMaster.AdjCode;
report.ParameterByName("BillDate").AsDateTime = printMaster.RegTime;
report.ParameterByName("Remark").AsString = printMaster.Remark;
report.ParameterByName("RegPeople").AsString = BaseData.GetUserName(printMaster.RegPeople);
report.ParameterByName("RegDept").AsString = BaseData.GetDeptName(printMaster.DeptID.ToString());
report.ParameterByName("HospitalName").AsString = BaseData.WorkName;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.PrintPreview(false);
}
}
/// <summary>
/// 打印住院统领单据
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
if (billMaster == null || billOrder == null)
{
return;
}
HIS.Model.YP_DispDeptHis printMaster = (HIS.Model.YP_DispDeptHis)billMaster;
if (billOrder.Rows.Count > 0)
{
_printOrder = billOrder;
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("DeptName").AsString = BaseData.GetDeptName(printMaster.DeptId.ToString());
report.ParameterByName("UserName").AsString = BaseData.GetUserName(printMaster.OpMan);
report.ParameterByName("ExeTime").AsDateTime = printMaster.OpTime;
report.ParameterByName("DispDept").AsString = BaseData.GetDeptName(printMaster.DispDept.ToString());
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName
+ printMaster.BillType + "统领发药单";
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("PatientNames").AsString = printMaster.PatientNames;
report.PrintPreview(false);
}
}
/// <summary>
/// 打印采购计划单
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
try
{
HIS.Model.YP_PlanMaster printMaster = (HIS.Model.YP_PlanMaster)billMaster;
_printOrder = BillFactory.GetQuery(ConfigManager.OP_YK_STOCKPLAN).LoadOrder(printMaster);
if (printMaster != null && _printOrder.Rows.Count > 0)
{
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("RegTime").AsDateTime = printMaster.RegTime;
report.ParameterByName("RegPeopleName").AsString = printMaster.RegPeopleName;
report.ParameterByName("TotalRetailFee").AsString = printMaster.RetailFee.ToString();
report.ParameterByName("TotalTradeFee").AsString = printMaster.TradeFee.ToString();
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("DiffFee").AsString = (printMaster.RetailFee - printMaster.TradeFee).ToString();
report.PrintPreview(false);
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// 打印门诊发药单据
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
try
{
if (billMaster == null)
{
return;
}
HIS.Model.YP_DRMaster printMaster = (HIS.Model.YP_DRMaster)billMaster;
billOrder = HIS.YP_BLL.BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE).LoadOrder(billMaster);
if (billOrder.Rows.Count > 0)
{
_printOrder = billOrder;
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("InvoiceNum").AsString = printMaster.InvoiceNum.ToString();
report.ParameterByName("UserName").AsString = BaseData.GetUserName(printMaster.OPPeopleID);
report.ParameterByName("ExeTime").AsDateTime = printMaster.OPTime;
report.ParameterByName("PatientName").AsString = printMaster.PatientName;
report.ParameterByName("HospitalName").AsString = BaseData.WorkName;
report.ParameterByName("DocName").AsString = BaseData.GetUserName(printMaster.DocID.ToString());
report.ParameterByName("DeptName").AsString = BaseData.GetDeptName(printMaster.DeptID.ToString());
report.ParameterByName("RecipeNum").AsString = printMaster.RecipeNum.ToString();
report.ParameterByName("RecipeNo").AsString = printMaster.RecipeID.ToString();
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.PrintPreview(false);
}
}
catch (Exception error)
{
throw error;
}
}
static public void PrintCheckReport(string path, PrintCondition condition, DataTable drugInfo)
{
try
{
_printOrder = drugInfo;
if (path != "" && drugInfo.Rows.Count > 0)
{
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("审核单号").AsString = condition.billNo;
report.ParameterByName("盘点开始时间").AsDateTime = condition.beginTime;
report.ParameterByName("盘存库房").AsString = BaseData.GetDeptName(condition.exeDeptId.ToString());
report.ParameterByName("盘盈金额").AsString = condition.reportFees["盘盈金额"].ToString();
report.ParameterByName("盘亏金额").AsString = condition.reportFees["盘亏金额"].ToString();
report.ParameterByName("盘后金额合计").AsString = condition.reportFees["盘存金额"].ToString();
report.ParameterByName("盘点结束时间").AsDateTime = condition.endTime;
report.ParameterByName("打印人员").AsString = BaseData.GetUserName(condition.printer);
report.ParameterByName("审核人员").AsString = condition.exePeoples;
report.ParameterByName("医院名称").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("打印时间").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.PrintPreview(false);
}
}
catch (Exception error)
{
throw error;
}
}
//交款表打印
private void Print(int accountType)
{
Controller.BeginChargeWorkid();
zyAccount = new ZY_Account();
Report = new grproLib.GridppReport();
if (accountType == 0)
{
chargeRpt.GetAccountRptInfo(chargeRpt, ids.ToArray(), accountType);
#region 预交金
Report.LoadFromFile(Constant.ApplicationDirectory + "\\report\\住院财务结帐预交金汇总.grf");
GWI_DesReport.HisReport.FillRecordToReport(Report, chargeRpt);
Report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(Report_FetchRecord);
#endregion
}
else
{
#region 结算
Report.LoadFromFile(Constant.ApplicationDirectory + "\\report\\住院财务结帐结算汇总.grf");
costRpt.GetAccountRptInfo(costRpt, ids.ToArray(), accountType);
GWI_DesReport.HisReport.FillRecordToReport(Report, costRpt);
for (int i = 0; i < costRpt.发票项目.Rows.Count; i++)
{
try
{
Report.ParameterByName(costRpt.发票项目.Rows[i]["itemname"].ToString()).AsString = costRpt.发票项目.Rows[i]["Tolal_Fee"].ToString();
}
catch (Exception err)
{
MessageBox.Show("发票打印传入参数:发票项目_" + costRpt.发票项目.Rows[i]["itemname"].ToString() + " 错误\r\n" + err.Message);
continue;
}
}
for (int i = 0; i < costRpt.记账内容.Length; i++)
{
try
{
Report.ParameterByName(costRpt.记账内容[i].TypeName + "_记账_张数").AsString = costRpt.记账内容[i].CostNum;
Report.ParameterByName(costRpt.记账内容[i].TypeName + "_记账").AsString = costRpt.记账内容[i].CostFee;
}
catch (Exception err)
{
MessageBox.Show("发票打印传入参数:记账类型_" + costRpt.记账内容[i].TypeName + " 错误\r\n" + err.Message);
continue;
}
}
#endregion
}
Controller.EndChargeWorkid();
//zyAccount.UpdatePrintNum(Accountid);
Report.PrintPreview(false);
}
/// <summary>
/// 打印库存清单
/// </summary>
/// <param name="path">报表位置</param>
/// <param name="printer">打印人</param>
/// <param name="deptId">部门ID</param>
/// <param name="drugInfo">药品库存信息表</param>
/// <param name="_belongSystem">所属系统（药房、药库）</param>
static public void PrintStoreBill(string path, int printer, int deptId, DataTable drugInfo, string _belongSystem)
{
_printOrder = drugInfo.Copy();
if (path != "" && drugInfo.Rows.Count > 0)
{
decimal retailFee = StoreFactory.GetQuery(_belongSystem).QueryStoreFee(deptId, 0);
decimal tradeFee = StoreFactory.GetQuery(_belongSystem).QueryTradeFee(deptId, 0);
decimal xy_RetailFee = StoreFactory.GetQuery(_belongSystem).QueryStoreFee(deptId, 1);
decimal zcy_RetailFee = StoreFactory.GetQuery(_belongSystem).QueryStoreFee(deptId, 2);
decimal zy_RetailFee = StoreFactory.GetQuery(_belongSystem).QueryStoreFee(deptId, 3);
decimal xy_TradeFee = StoreFactory.GetQuery(_belongSystem).QueryTradeFee(deptId, 1);
decimal zcy_TradeFee = StoreFactory.GetQuery(_belongSystem).QueryTradeFee(deptId, 2);
decimal zy_TradeFee = StoreFactory.GetQuery(_belongSystem).QueryTradeFee(deptId, 3);
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("Printer").AsString = BaseData.GetUserName(printer);
report.ParameterByName("DeptName").AsString = BaseData.GetDeptName(deptId.ToString());
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("TotalFee").AsString = retailFee.ToString("0.00");
report.ParameterByName("TotalFee_XY").AsString = xy_RetailFee.ToString("0.00");
report.ParameterByName("TotalFee_ZCY").AsString = zcy_RetailFee.ToString("0.00");
report.ParameterByName("TotalFee_ZY").AsString = zy_RetailFee.ToString("0.00");
if (_belongSystem == ConfigManager.YF_SYSTEM && !ConfigManager.ManageTradepriceByYF())
{
report.ParameterByName("TradeFee").AsString = "受管制无法显示";
report.ParameterByName("DiffFee").AsString = "受管制无法显示";
report.ParameterByName("TradeFee_XY").AsString = "受管制无法显示";
report.ParameterByName("TradeFee_ZCY").AsString = "受管制无法显示";
report.ParameterByName("TradeFee_ZY").AsString = "受管制无法显示";
report.ParameterByName("DiffFee_XY").AsString = "受管制无法显示";
report.ParameterByName("DiffFee_ZCY").AsString = "受管制无法显示";
report.ParameterByName("DiffFee_ZY").AsString = "受管制无法显示";
_printOrder.Columns.Remove("TRADEPRICE");
_printOrder.Columns.Remove("TRADEFEE");
_printOrder.Columns.Remove("FEEDIFFERENCE");
report.PrintPreview(false);
return;
}
else
{
report.ParameterByName("TradeFee").AsString = tradeFee.ToString("0.00");
report.ParameterByName("DiffFee").AsString = (retailFee - tradeFee).ToString("0.00");
report.ParameterByName("TradeFee_XY").AsString = xy_TradeFee.ToString("0.00");
report.ParameterByName("TradeFee_ZCY").AsString = zcy_TradeFee.ToString("0.00");
report.ParameterByName("TradeFee_ZY").AsString = zy_TradeFee.ToString("0.00");
report.ParameterByName("DiffFee_XY").AsString = (xy_RetailFee - xy_TradeFee).ToString("0.00");
report.ParameterByName("DiffFee_ZCY").AsString = (zcy_RetailFee - zcy_TradeFee).ToString("0.00");
report.ParameterByName("DiffFee_ZY").AsString = (zy_RetailFee - zy_TradeFee).ToString("0.00");
report.PrintPreview(false);
return;
}
}
}
/// <summary>
/// 报表打印
/// </summary>
private void ReportPrint(bool view)
{
if (dgvReport.Rows.Count == 0)
{
return;
}
if (dgvReport.DataSource == null)
{
return;
}
reportPrinter = new grproLib.GridppReport( );
string reportFile = System.Windows.Forms.Application.StartupPath + "\\report\\" + FormTitle + ".grf";
if (!System.IO.File.Exists(reportFile))
{
MessageBox.Show("报表模板文件不存在，不能打印或预览！请下载或联系管理员增加该报表", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
reportPrinter.LoadFromFile(reportFile);
string printerName = HIS_PublicManager.PublicPrintSet.GetPrinterNameByReport(FormTitle + ".grf");
reportPrinter.Printer.PrinterName = printerName;
try
{
reportPrinter.Title = FormTitle;
try
{
reportPrinter.ParameterByName("医院名称").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
reportPrinter.ParameterByName("报表标题").AsString = FormTitle;
reportPrinter.ParameterByName("统计时间").AsString = "统计日期：" + this.lblDate.Text;
reportPrinter.ParameterByName("制表人").AsString = "制表人：" + currentUser.Name;
reportPrinter.ParameterByName("备注").AsString = "";
}
catch (Exception err)
{
throw new Exception("报表模板参数没有正确设置，请用设计器打开报表并设置好参数");
}
reportPrinter.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
if (view)
{
reportPrinter.PrintPreview(false);
}
else
{
reportPrinter.Print(true);
}
}
catch (Exception err)
{
MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
private void ctrlReport1_ReportInit(grproLib.GridppReport report)
{
try
{
report.ParameterByName("ParamBillID").Value = this._BillID;
}
catch (Exception ex)
{
ErrorHandler.OnError(ex);
}
}
//打印住院发票
public static void Print(int CostMasterID)
{
grproLib.GridppReport Report = new grproLib.GridppReport();
string ReportPath;
string PrinterName;
Object invoice;
//广东发票打印
//ReportPath = Constant.ApplicationDirectory + "\\report\\住院发票.grf";
//PrinterName = HIS_PublicManager.PublicPrintSet.GetPrinterNameByReport("住院发票.grf");
//invoice =InvoiceFactory.CreateInvoice(CostMasterID,"广东");
//湖南发票打印
ReportPath = Constant.ApplicationDirectory + "\\report\\住院发票_HN.grf";
PrinterName = HIS_PublicManager.PublicPrintSet.GetPrinterNameByReport("住院发票_HN.grf");
invoice = InvoiceFactory.CreateInvoice(CostMasterID, "湖南");
Report.LoadFromFile(ReportPath);
Report.Printer.PrinterName = PrinterName;
GWI_DesReport.HisReport.FillRecordToReport(Report, invoice);
Report.ParameterByName("WorkName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
#region 发票项目
DataTable dt = ((AbstractInvoice)invoice).发票项目费用;
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 1; j <= Report.Parameters.Count; j++)
{
if (dt.Rows[i]["itemname"].ToString().Trim() == Report.Parameters[j].Name)
{
Report.Parameters[j].Value = dt.Rows[i]["Tolal_Fee"].ToString();
}
}
}
#endregion
if (Report.Printer.PrinterName == null || Report.Printer.PrinterName == "")
{
MessageBox.Show("请先设置好此报表的打印机！", "询问", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
return;
}
#if DEBUG
Report.PrintPreview(false);
#else
//Report.PrintPreview(false);
Report.Print(false);
#endif
}
public override void Print(string path, HIS.Model.ZY_PatList patlist, List <HIS.Model.ZY_DOC_ORDERRECORD> applys, DateTime dtime, string name, string state, string palce, string deptname, string tjjg, string Xjg, string hyjg, string othercheck)
{
if (path != "" && applys.Count > 0)
{
string itemname = applys[0].ORDER_CONTENT.ToString();
decimal price = applys[0].ORDER_PRICE;
for (int i = 1; i < applys.Count; i++)
{
itemname = itemname + ", " + applys[i].ORDER_CONTENT.ToString();
price = price + applys[i].ORDER_PRICE;
}
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("医院名称").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("住院号").AsString = patlist.CureNo;
report.ParameterByName("病人姓名").AsString = patlist.PatientInfo.PatName;
report.ParameterByName("病人性别").AsString = patlist.PatientInfo.PatSex;
string age = HIS.SYSTEM.PubicBaseClasses.Age.GetAgeString(patlist.PatientInfo.PatBriDate, XcDate.ServerDateTime, 1);
report.ParameterByName("病人年龄").AsString = age;
report.ParameterByName("床号").AsString = patlist.BedCode;
string[] strdiag = patlist.DiseaseName.Split(new char[] { '|' });
if (strdiag[0] == "")
{
report.ParameterByName("诊断").AsString = strdiag[1].Replace("\r\n", "");
}
else
{
report.ParameterByName("诊断").AsString = strdiag[0].Replace("\r\n", "");
}
report.ParameterByName("申请时间").AsString = dtime.ToString();
report.ParameterByName("申请医生").AsString = name;
report.ParameterByName("项目金额").AsString = price.ToString() + " 元";
report.ParameterByName("申请科室").AsString = deptname;
report.ParameterByName("打印人").AsString = name;
report.ParameterByName("Purpose").AsString = itemname;
report.ParameterByName("History").AsString = state;
report.ParameterByName("检查部位").AsString = palce;
report.ParameterByName("体检").AsString = tjjg;
report.ParameterByName("X线检查结果").AsString = Xjg;
report.ParameterByName("化验结果").AsString = hyjg;
report.ParameterByName("其他辅助检查").AsString = othercheck;
report.PrintPreview(false);
}
}
static public void PrintTotalInOutStore(string path, PrintCondition condition, DataTable totalOrder)
{
_printOrder = totalOrder;
if (path != "" && totalOrder != null)
{
if (totalOrder.Rows.Count <= 0)
{
return;
}
else
{
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("开始时间").AsDateTime = condition.beginTime;
report.ParameterByName("结束时间").AsDateTime = condition.endTime;
if (condition.exeDeptId != 0)
{
report.ParameterByName("统计科室").AsString = BaseData.GetDeptName(condition.exeDeptId.ToString());
}
else
{
report.ParameterByName("统计科室").AsString = "全部库房（含物资与药库）";
}
report.ParameterByName("打印人员").AsString = BaseData.GetUserName(condition.printer);
report.ParameterByName("打印时间").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
if (condition.billNo == "0")
{
report.ParameterByName("标题").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName
+ "入库统计单";
}
else
{
report.ParameterByName("标题").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName
+ "出库统计单";
}
report.PrintPreview(false);
}
}
}
//打印
private void toolSBPrint_Click(object sender, EventArgs e)
{
if (((DataTable)this.dgBill.DataSource).Rows.Count == 0)
{
return;
}
if (Convert.ToInt32(((DataTable)this.dgBill.DataSource).DefaultView.ToTable().Rows[this.dgBill.CurrentCell.RowIndex]["Record_Flag"]) != 0 || Convert.ToInt32(((DataTable)this.dgBill.DataSource).DefaultView.ToTable().Rows[this.dgBill.CurrentCell.RowIndex]["Delete_Flag"]) != 0)
{
MessageBox.Show("此条是做废记录或已经结算，不能打印！");
return;
}
if (MessageBox.Show("确定要打印吗？", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
zy_ChargeList = (ZY_ChargeList)HIS.SYSTEM.PubicBaseClasses.ApiFunction.DataTableToObject(((DataTable)this.dgBill.DataSource).Copy(), this.dgBill.CurrentCell.RowIndex, zy_ChargeList);
grproLib.GridppReport Report = new grproLib.GridppReport();
string reportPath = Constant.ApplicationDirectory + "\\report\\住院收费收据.grf";
Report.LoadFromFile(reportPath);
GWI_DesReport.HisReport.FillRecordToReport(Report, zy_ChargeList);
Report.ParameterByName("PatName").AsString = zy_PatList.patientInfo.PatName;
Report.ParameterByName("DeptName").AsString = this.tbpatDept.Text;
Report.ParameterByName("BedNO").AsString = zy_PatList.BedCode;
Report.ParameterByName("Total_Fee1").AsString = zy_ChargeList.Total_Fee.ToString();
Report.ParameterByName("PrintPerson").AsString = base.currentUser.Name;
Report.ParameterByName("WorkName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
Report.Printer.PrinterName = HIS_PublicManager.PublicPrintSet.GetPrinterNameByReport("住院收费收据.grf");
if (Report.Printer.PrinterName == null || Report.Printer.PrinterName == "")
{
MessageBox.Show("请先设置好此报表的打印机！", "询问", MessageBoxButtons.OK, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
return;
}
if (this.printType.Checked)
{
Report.Print(false);
}
else
{
Report.PrintPreview(false);
}
}
}
/// <summary>
/// 打印启用药品
/// </summary>
/// <param name="path">报表文件路径</param>
/// <param name="printer">打印人</param>
/// <param name="deptId">部门ID</param>
/// <param name="drugInfo">药品信息表</param>
static public void PrintUseDrug(string path, int printer, int deptId, DataTable drugInfo)
{
try
{
_printOrder = drugInfo;
if (path != "" && drugInfo.Rows.Count > 0)
{
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("Printer").AsString = BaseData.GetUserName(printer);
report.ParameterByName("DeptName").AsString = BaseData.GetDeptName(deptId.ToString());
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.PrintPreview(false);
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// 打印住院退药单据
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
if (billMaster == null)
{
return;
}
_printOrder = BillFactory.GetQuery(ConfigManager.OP_YF_REFUND).LoadOrder(billMaster);
if (_printOrder.Rows.Count > 0)
{
HIS.Model.YP_DRMaster printMaster = (HIS.Model.YP_DRMaster)billMaster;
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("InpatientNo").AsString = printMaster.InpatientID;
report.ParameterByName("UserName").AsString = BaseData.GetUserName(printMaster.OPPeopleID);
report.ParameterByName("ExeTime").AsDateTime = printMaster.OPTime;
report.ParameterByName("PatientName").AsString = printMaster.PatientName;
report.ParameterByName("HospitalName").AsString = BaseData.WorkName;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.PrintPreview(false);
}
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
if (this.dataGridViewEx1.CurrentCell != null)
{
int RowIndex = this.dataGridViewEx1.CurrentCell.RowIndex;
Report = new grproLib.GridppReport();
Report.LoadFromFile(Constant.ApplicationDirectory + "\\report\\护士统领汇总单据.grf");
Report.ParameterByName("UserName").AsString = dsMessageData.dtMessageMaster.Rows[RowIndex]["SENDERNAME"].ToString().Trim();
Report.ParameterByName("ExeTime").AsString = dsMessageData.dtMessageMaster.Rows[RowIndex]["SENDTIME"].ToString().Trim();
Report.ParameterByName("DeptName").AsString = dsMessageData.dtMessageMaster.Rows[RowIndex]["presdeptname"].ToString().Trim();
Report.ParameterByName("DispDept").AsString = dsMessageData.dtMessageMaster.Rows[RowIndex]["dispDeptName"].ToString().Trim();
Report.ParameterByName("Printer").AsString = _currentUser.Name;
Report.ParameterByName("PrintTime").AsString = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime.ToString();
Report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
List <string> patNames = new List <string>();
int masterID = Convert.ToInt32(dsMessageData.dtMessageMaster.Rows[RowIndex]["DRUGMESSAGEID"].ToString().Trim());
string patname = "";
DataRow[] drs = dsMessageData.dtMessageOrder.Select("masterid=" + masterID);
for (int i = 0; i < drs.Length; i++)
{
string patS = patNames.Find(delegate(string y) { return(y == drs[i]["patname"].ToString()); });
if (patS == null)
{
patNames.Add(drs[i]["patname"].ToString());
patname += drs[i]["patname"].ToString() + ",";
}
}
if (patname != "")
{
patname = patname.Substring(0, patname.Length - 1);
}
Report.ParameterByName("PatientNames").AsString = patname;
Report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(Report_FetchRecord);
Report.PrintPreview(false);
}
}
public override void Print(string path, HIS.Model.ZY_PatList patlist, List <HIS.Model.ZY_DOC_ORDERRECORD> applys, DateTime dtime, string name, string state)
{
if (path != "" && applys.Count > 0)
{
for (int i = 0; i < applys.Count; i++)
{
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("医院名称").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("cureno").AsString = patlist.CureNo;
report.ParameterByName("patname").AsString = patlist.PatientInfo.PatName;
report.ParameterByName("patsex").AsString = patlist.PatientInfo.PatSex;
report.ParameterByName("bedcode").AsString = patlist.BedCode;
string[] strdiag = patlist.DiseaseName.Split(new char[] { '|' });
if (strdiag[0] == "")
{
report.ParameterByName("diag").AsString = strdiag[1].Replace("\r\n", "");
}
else
{
report.ParameterByName("diag").AsString = strdiag[0].Replace("\r\n", "");
}
report.ParameterByName("applydate").AsString = dtime.ToString();
report.ParameterByName("state").AsString = state;
report.ParameterByName("items").AsString = applys[i].ORDER_CONTENT;
report.ParameterByName("price").AsString = applys[i].ORDER_PRICE.ToString() + " 元";
report.ParameterByName("nums").AsString = applys[i].AMOUNT.ToString();
report.ParameterByName("totalprice").AsString = (Convert.ToDecimal(applys[i].ORDER_PRICE.ToString()) * Convert.ToDecimal(applys[i].AMOUNT.ToString())).ToString() + "元";
report.ParameterByName("presdoc").AsString = name;
string age = HIS.SYSTEM.PubicBaseClasses.Age.GetAgeString(patlist.PatientInfo.PatBriDate, XcDate.ServerDateTime, 1);
report.ParameterByName("patage").AsString = age;
report.PrintPreview(false);
}
}
}
/// <summary>
/// 打印出库单据
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
HIS.Model.YP_OutMaster printMaster = (HIS.Model.YP_OutMaster)billMaster;
if (printMaster != null && billOrder != null)
{
if (billOrder.Rows.Count > 0)
{
DataTable dtt = billOrder.Copy();
bool isShowTradePrice = ConfigManager.ManageTradepriceByYF();
if (!isShowTradePrice)
{
_printOrder.Columns.Remove("TRADEPRICE");
_printOrder.Columns.Remove("TRADEFEE");
_printOrder.Columns.Remove("DIFFFEE");
}
DataColumn dc = null;
dc = dtt.Columns.Add("OVERNUM", Type.GetType("System.String"));//增加结余数 zhangyunhui 5.8
for (int i = 0; i < dtt.Rows.Count; i++)
{
dtt.Rows[i]["OVERNUM"] = Getovernumber(Convert.ToInt32(dtt.Rows[i]["OUTSTORAGEID"].ToString()));
}
_printOrder = dtt;
if (printMaster.OpType == ConfigManager.OP_YK_REPORTLOSS)
{
report = new grproLib.GridppReport();
string startPath = path + "\\report\\药品报损出库单据.grf";
report.LoadFromFile(startPath);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
}
else
{
report = new grproLib.GridppReport();
string startPath = path + "\\report\\科室领药出库单据.grf";
report.LoadFromFile(startPath);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("OutDept").AsString = BaseData.GetDeptName(printMaster.OutDeptId.ToString());
}
report.ParameterByName("BillNo").AsString = printMaster.BillNum.ToString();
if (printMaster.Audit_Flag == 0)
{
report.ParameterByName("ExeTime").AsString = printMaster.RegTime.ToString();
report.ParameterByName("RegPeople").AsString = BaseData.GetUserName(printMaster.RegPeopleID);
}
else
{
report.ParameterByName("ExeTime").AsString = printMaster.AuditTime.ToString();
report.ParameterByName("RegPeople").AsString = BaseData.GetUserName(printMaster.AuditPeopleID);
}
report.ParameterByName("RegDept").AsString = BaseData.GetDeptName(printMaster.DeptID.ToString());
report.ParameterByName("Remark").AsString = printMaster.ReMark;
report.ParameterByName("TotalRetailFee").AsString = printMaster.RetailFee.ToString();
string billType = DrugBaseDataBll.FindDrugDept(printMaster.DeptID).DeptType1 == "物资" ? "物资出库单" : "药品出库单";
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName + billType;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
if (isShowTradePrice)
{
report.ParameterByName("TotalTradeFee").AsString = printMaster.TradeFee.ToString();
report.ParameterByName("TotalDiffFee").AsString = (printMaster.RetailFee - printMaster.TradeFee).ToString();
}
else
{
report.ParameterByName("TotalTradeFee").AsString = "受管制无法显示";
report.ParameterByName("TotalDiffFee").AsString = "受管制无法显示";
}
report.ParameterByName("Auditer").AsString = BaseData.GetUserName(printMaster.AuditPeopleID);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
//report.ParameterByName("BillDate").AsDateTime = (printMaster.BillDate);
report.PrintPreview(false);
}
}
}
/// <summary>
/// 打印入库单据
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
try
{
string billType = "";
HIS.Model.YP_InMaster printMaster = (HIS.Model.YP_InMaster)billMaster;
DataTable dtt = billOrder.Clone();
DataRow[] datarows;
datarows = billOrder.Select("");
foreach (DataRow dr in datarows)
{
dtt.Rows.Add(dr.ItemArray);
}
DataColumn dc = null;
dc = dtt.Columns.Add("OVERNUM", Type.GetType("System.String")); // 增加结余数 zhangyunhui 5.8
for (int i = 0; i < dtt.Rows.Count; i++)
{
dtt.Rows[i]["OVERNUM"] = Getovernumber(Convert.ToInt32(dtt.Rows[i]["INSTORAGEID"].ToString()));
}
_printOrder = dtt;
if (printMaster != null && billOrder.Rows.Count > 0)
{
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("Supporter").AsString = printMaster.SupportDic.Name;
report.ParameterByName("InvoiceNo").AsString = printMaster.InvoiceNum;
report.ParameterByName("BillNo").AsString = printMaster.BillNum.ToString();
if (printMaster.Audit_Flag == 0)
{
report.ParameterByName("ExeTime").AsString = printMaster.RegTime.ToString();
report.ParameterByName("AuditPeople").AsString = BaseData.GetUserName(printMaster.RegPeopleID);
}
else
{
report.ParameterByName("ExeTime").AsString = printMaster.AuditTime.ToString();
report.ParameterByName("AuditPeople").AsString = BaseData.GetUserName(printMaster.AuditPeopleID);
}
report.ParameterByName("TotalFee").AsString = printMaster.RetailFee.ToString();
report.ParameterByName("CurrentUser").AsString = BaseData.GetUserName(printMaster.RegPeopleID);
if (printMaster.OpType == ConfigManager.OP_YK_BACKSTORE)
{
billType = DrugBaseDataBll.FindDrugDept(printMaster.DeptID).DeptType1 == "物资" ? "物资退库单" : "药品退库单";
}
else
{
billType = DrugBaseDataBll.FindDrugDept(printMaster.DeptID).DeptType1 == "物资" ? "物资入库单" : "药品入库单";
}
report.ParameterByName("CurrentDept").AsString = BaseData.GetDeptName(printMaster.DeptID.ToString());
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName + billType;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("InstoreFee").AsString = printMaster.StockFee.ToString();
report.ParameterByName("DiffFee").AsString = (printMaster.RetailFee - printMaster.StockFee).ToString();
report.ParameterByName("ReMark").AsString = printMaster.ReMark.ToString();
report.PrintPreview(false);
}
}
catch (Exception error)
{
throw error;
}
}
/// <summary>
/// 打印住院摆药单据
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
//if (billMaster == null)
//{
// return;
//}
//HIS.Model.YP_DRMaster printMaster = (HIS.Model.YP_DRMaster)billMaster;
//billOrder = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE).LoadOrder(billMaster);
//HIS.Interface.IZY_Data zyInterFace = new HIS.Interface.ZY_Data();
//billOrder=zyInterFace
//if (billOrder.Rows.Count > 0)
//{
// _printOrder = billOrder;
// report = new grproLib.GridppReport();
// report.LoadFromFile(path);
// report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
// report.ParameterByName("CureNo").AsString = printMaster.InpatientID.ToString();
// report.ParameterByName("UserName").AsString = BaseData.GetUserName(printMaster.OPPeopleID);
// report.ParameterByName("ExeTime").AsDateTime = printMaster.OPTime;
// report.ParameterByName("PatientName").AsString = printMaster.PatientName;
// report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
// report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
// report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
// report.PrintPreview(false);
//}
if (billMaster == null)
{
if (billOrder == null)
{
return;
}
if (billOrder.Rows.Count > 0)
{
HIS.Model.ZY_PatList patlist = HIS.SYSTEM.Core.BindEntity <HIS.Model.ZY_PatList> .CreateInstanceDAL(oleDb).GetModel(Convert.ToInt32(billOrder.Rows[0]["patlistid"]));
_printOrder = billOrder;
//for (int i = 0; i < _printOrder.Rows.Count; i++)
//{
// decimal presamount =( _printOrder.Rows[i]["presamount"] == null || _printOrder.Rows[i]["presamount"].ToString() == "0" ? 1 : Convert.ToDecimal(_printOrder.Rows[i]["presamount"].ToString()));
// _printOrder.Rows[i]["amount"] = Convert.ToDecimal(_printOrder.Rows[i]["amount"].ToString()) / presamount;
//}
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("CureNo").AsString = patlist.CureNo;
report.ParameterByName("UserName").AsString = BaseData.GetUserName(Printer);
//report.ParameterByName("ExeTime").AsDateTime = printMaster.OPTime;
report.ParameterByName("PatientName").AsString = patlist.PatientInfo.PatName;
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("总金额").AsString = Convert.ToDecimal(_printOrder.Compute("sum(tolal_fee)", "")).ToString("0.00") + " 元";
report.ParameterByName("病人科室").AsString = BaseData.GetDeptName(patlist.CurrDeptCode);
report.ParameterByName("开方医生").AsString = billOrder.Rows[0]["presdocname"].ToString();
report.PrintPreview(false);
}
}
else
{
HIS.Model.YP_DRMaster printMaster = (HIS.Model.YP_DRMaster)billMaster;
billOrder = BillFactory.GetQuery(ConfigManager.OP_YF_DISPENSE).LoadOrder(billMaster);
if (billOrder.Rows.Count > 0)
{
_printOrder = billOrder;
for (int i = 0; i < _printOrder.Rows.Count; i++)
{
decimal presamount = (_printOrder.Rows[i]["recipenum"] == null || _printOrder.Rows[i]["recipenum"].ToString() == "0" ? 1 : Convert.ToDecimal(_printOrder.Rows[i]["recipenum"].ToString()));
_printOrder.Rows[i]["drugocnum"] = Convert.ToDecimal(_printOrder.Rows[i]["drugocnum"].ToString()) / presamount;
}
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("CureNo").AsString = printMaster.InpatientID.ToString();
report.ParameterByName("UserName").AsString = BaseData.GetUserName(printMaster.OPPeopleID);
report.ParameterByName("ExeTime").AsDateTime = printMaster.OPTime;
report.ParameterByName("PatientName").AsString = printMaster.PatientName;
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("总金额").AsString = Convert.ToDecimal(_printOrder.Compute("sum(retailfee)", "")).ToString("0.00") + " 元";
report.PrintPreview(false);
}
}
}
/// <summary>
/// 打印摆药单据
/// </summary>
/// <param name="printCondition">打印头信息</param>
/// <param name="orderDt">打印明细</param>
/// <param name="path">报表路径</param>
public override void PrintReport(YP_PrintCondition printCondition, System.Data.DataTable orderDt, string path)
{
if (orderDt == null)
{
return;
}
if (orderDt.Rows.Count > 0)
{
HIS.Interface.IZY_Data zyInterFace = new HIS.Interface.ZY_Data();
_printOrder = new DataTable();
DateTime currentTime = XcDate.ServerDateTime;
_printOrder.Columns.Add("OrderContents", Type.GetType("System.String"));
_printOrder.Columns.Add("PatName", Type.GetType("System.String"));
_printOrder.Columns.Add("PatAge", Type.GetType("System.String"));
_printOrder.Columns.Add("BedNo", Type.GetType("System.String"));
_printOrder.Columns.Add("OrderId", Type.GetType("System.Int32"));
_printOrder.Columns.Add("ChargeDate", Type.GetType("System.DateTime"));
_printOrder.Columns.Add("UnitName", Type.GetType("System.String"));
_printOrder.Columns.Add("CureNo", Type.GetType("System.String"));
_printOrder.Columns.Add("DrugNum", Type.GetType("System.Decimal"));
_printOrder.Columns.Add("PresDeptName", Type.GetType("System.String"));
_printOrder.Columns.Add("SortNum", Type.GetType("System.Int32"));
_printOrder.PrimaryKey = new DataColumn[] { _printOrder.Columns["OrderId"], _printOrder.Columns["CureNo"] };
//如果只打口服摆药单
if (printCondition.drugType == "口服药")
{
for (int index = 0; index < orderDt.Rows.Count; index++)
{
//按医嘱ID获取用法对应执行单表
DataTable useTypeDt = zyInterFace.GetUseType(Convert.ToInt32(orderDt.Rows[index]["docorderid"])); if (useTypeDt != null)
{
//如果是口服药
if (useTypeDt.Select("TYPE_NAME='服药单'").Count() == 0)
{
orderDt.Rows[index]["ISDISPENSE"] = 0;
}
}
}
}
for (int index = 0; index < orderDt.Rows.Count; index++)
{
DataRow currentRow = orderDt.Rows[index];
if (currentRow["ISDISPENSE"] == DBNull.Value)
{
continue;
}
if (Convert.ToInt32(currentRow["ISDISPENSE"]) == 0)
{
continue;
}
DataRow findRow = _printOrder.Rows.Find(new object[] { currentRow["docorderid"], currentRow["cureno"] });
if (findRow != null)
{
findRow["DrugNum"] = Convert.ToDecimal(findRow["DrugNum"])
+ Convert.ToDecimal(currentRow["DrugNum"]);
}
else
{
DataRow newRow = _printOrder.NewRow();
newRow["OrderContents"] = zyInterFace.GetDocOrderInfo(Convert.ToInt32(currentRow["docorderid"]));
newRow["PatName"] = currentRow["patname"];
string bedNo = currentRow["bedno"].ToString();
newRow["SortNum"] = Convert.ToInt32(bedNo.Replace("加", "100").ToString());
newRow["BedNo"] = bedNo;
newRow["OrderId"] = currentRow["docorderid"];
newRow["ChargeDate"] = currentRow["chargedate"];
newRow["UnitName"] = currentRow["unitname"];
newRow["CureNo"] = currentRow["cureno"];
newRow["DrugNum"] = currentRow["drugnum"];
newRow["PresDeptName"] = currentRow["presdeptname"];
newRow["PatAge"] = zyInterFace.GetPatAge(newRow["CureNo"].ToString(), currentTime);
_printOrder.Rows.Add(newRow);
}
}
DataRow[] dRows = _printOrder.Select("", "SortNum");
DataTable newDt = _printOrder.Clone();
foreach (DataRow dRow in dRows)
{
newDt.Rows.Add(dRow.ItemArray);
}
_printOrder = newDt;
if (_printOrder.Rows.Count > 0)
{
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
string type = "";
switch (printCondition.queyType)
{
case 0:
type = "长期";
break;
case 1:
type = "临时";
break;
default:
break;
}
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName
+ type + "住院药品摆药单";
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(printCondition.userId);
report.PrintPreview(false);
}
}
}
private void BtnNumber_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
PassToStockEdit ors;
switch (btn.Name)
{
case "Delete":
try
{
SqlConnection conn = sqlcon.getcon("");
string strsql = "delete from BR_PassToStock where ID='" + WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["ID"].Value.ToString() + "'";
conn.Open();
SqlCommand sqlcom = new SqlCommand(strsql, conn);
sqlcom.ExecuteNonQuery();
conn.Close();
sqlcom.Dispose();
MessageBox.Show("已删除！！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case "Edit":
if (WPHbROWDGV.Rows.Count > 0)
{
ors = new PassToStockEdit(WPHbROWDGV.Rows[WPHbROWDGV.CurrentCell.RowIndex].Cells["ID"].Value.ToString(), "BR_PassToStock");
ors.ShowDialog();
}
break;
case "Excel":
if (WPHbROWDGV.Rows.Count > 0)
{
//建立Excel对象
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
excel.Application.Workbooks.Add(true);
//生成字段名称
for (int i = 0; i < WPHbROWDGV.ColumnCount; i++)
{
excel.Cells[1, i + 1] = WPHbROWDGV.Columns[i].HeaderText;
} //填充数据
for (int i = 0; i < WPHbROWDGV.RowCount; i++)
{
for (int j = 0; j < WPHbROWDGV.ColumnCount; j++)
{
if (WPHbROWDGV[j, i].Value == typeof(string))
{
excel.Cells[i + 2, j + 1] = "" + WPHbROWDGV[i, j].Value.ToString();
}
else
{
excel.Cells[i + 2, j + 1] = WPHbROWDGV[j, i].Value.ToString();
}
}
}
excel.Visible = true;
}
else
{
MessageBox.Show("没有你要导的数据！！！");
}
break;
case "Pring": //数据参数新增
if (WPHbROWDGV.Rows.Count > 0)
{
grproLib.GridppReport Report = new grproLib.GridppReport();
DataTable dt = new DataTable();
SqlConnection conn = sqlcon.getcon("");
string strsql = " select BR_PassToStock.Cade,Cadedate,m_Factory.title files,Ordercade,BarCode,item_no as Item,S_COLOR as Color,CO_CODE as Code,m_product.photo," +
"m_SizeDetails.cade as Sizecade,m_SizeDetails.[name] as Sizename,khdw,m_SizeDetails.Name as Size,Qty as Nomber,m_ProductSub.pid,username " +
"from BR_PassToStock " +
"left join m_Factory on m_Factory.id=BR_PassToStock.FID " +
"left join m_product on m_product.id=BR_PassToStock.pid " +
"left join m_ProductSub on m_ProductSub.id=BR_PassToStock.colourid " +
"left join m_SizeDetails on m_SizeDetails.id=BR_PassToStock.sdid where BarCode='" + WPHbROWDGV[4, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString() +
"' and BR_PassToStock.Cade='" + WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString() + "'";
SqlDataAdapter sqlDaper = new SqlDataAdapter(strsql, conn);
DataSet ds = new DataSet();
try
{
conn.Open();
sqlDaper.Fill(ds);
conn.Close();
try
{
//下载打印图片
string strimageurl = "http://120.43.209.230:8082/" + ds.Tables[0].Rows[0]["photo"].ToString();
System.Net.WebClient webclient = new System.Net.WebClient();
webclient.DownloadFile(strimageurl, @"D:\迈途\ZXCPTP.jpg");
}
catch (Exception ex)
{
if (File.Exists(@"D:\迈途\ZXCPTP.jpg")) //判断文件是不是存在
{
File.Delete(@"D:\迈途\ZXCPTP.jpg"); //如果存在则删除
}
Console.WriteLine(ex.Message);
}
Report.LoadFromFile(@rwos().ToString());
Report.ConnectionString = sqlcon.XMLIP();
Report.QuerySQL = " select BR_PassToStock.Cade,Cadedate,m_Factory.title files,Ordercade,BarCode,item_no as Item,S_COLOR as Color,CO_CODE as Code,m_product.photo," +
"m_SizeDetails.cade as Sizecade,m_SizeDetails.[name] as Sizename,khdw,m_SizeDetails.Name as Size,Qty as Nomber,m_ProductSub.pid,username " +
"from BR_PassToStock " +
"left join m_Factory on m_Factory.id=BR_PassToStock.FID " +
"left join m_product on m_product.id=BR_PassToStock.pid " +
"left join m_ProductSub on m_ProductSub.id=BR_PassToStock.colourid " +
"left join m_SizeDetails on m_SizeDetails.id=BR_PassToStock.sdid where BarCode='" + WPHbROWDGV[4, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString() +
"' and BR_PassToStock.Cade='" + WPHbROWDGV[0, WPHbROWDGV.CurrentCell.RowIndex].Value.ToString() + "'";
//Report.Print(false);
DialogResult result = MessageBox.Show("“是”直接打印，“否”打印预览", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
Report.Print(false);
}
else
{
Report.PrintPreview(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
else
{
MessageBox.Show("没有你要打印的数据！！");
}
break;
}
}
/// <summary>
/// 打印盘点汇总单据
/// </summary>
/// <param name="billMaster">单据表头</param>
/// <param name="billOrder">单据明细</param>
/// <param name="path">报表文件路径</param>
/// <param name="Printer">打印人员</param>
public override void PrintBill(HIS.Model.BillMaster billMaster, System.Data.DataTable billOrder, string path, int Printer)
{
try
{
if (billMaster == null)
{
return;
}
HIS.Model.YP_CheckMaster printMaster = (HIS.Model.YP_CheckMaster)billMaster;
string strWhere = BLL.Tables.yk_checkmaster.AUDITNUM + oleDb.EuqalTo() + printMaster.AuditNum + oleDb.And()
+ BLL.Tables.yk_checkmaster.DEL_FLAG + oleDb.EuqalTo() + "0" + oleDb.And()
+ BLL.Tables.yk_checkmaster.DEPTID + oleDb.EuqalTo() + printMaster.DeptID;
List <YP_CheckMaster> masterList = new List <YP_CheckMaster>();
DataTable orderDt = null;
#region 合并药房盘点单
if (printMaster.OpType == ConfigManager.OP_YF_CHECK)
{
masterList = BindEntity <YP_CheckMaster> .CreateInstanceDAL(oleDb, BLL.Tables.YF_CHECKMASTER).GetListArray(strWhere);
if (masterList.Count <= 0)
{
return;
}
foreach (YP_CheckMaster master in masterList)
{
if (orderDt == null)
{
orderDt = BillFactory.GetQuery(ConfigManager.OP_YF_CHECK).LoadOrder(master);
orderDt.PrimaryKey = new DataColumn[] { orderDt.Columns["MAKERDICID"] };
continue;
}
else
{
DataTable newDt = BillFactory.GetQuery(ConfigManager.OP_YF_CHECK).LoadOrder(master);
for (int index = 0; index < newDt.Rows.Count; index++)
{
DataRow currentRow = newDt.Rows[index];
DataRow findRow = orderDt.Rows.Find(Convert.ToInt32(currentRow["MAKERDICID"]));
if (findRow == null)
{
orderDt.Rows.Add(currentRow.ItemArray);
}
else
{
findRow["CPACKNUM"] = Convert.ToDecimal(findRow["CPACKNUM"])
+ Convert.ToDecimal(currentRow["CPACKNUM"]);
findRow["CKRETAILFEE"] = Convert.ToDecimal(findRow["CKRETAILFEE"])
+ Convert.ToDecimal(currentRow["CKRETAILFEE"]);
findRow["CKTRADEFEE"] = Convert.ToDecimal(findRow["CKTRADEFEE"])
+ Convert.ToDecimal(currentRow["CKTRADEFEE"]);
findRow["CBASENUM"] = Convert.ToDecimal(findRow["CBASENUM"])
+ Convert.ToDecimal(currentRow["CBASENUM"]);
}
}
}
}
}
#endregion
#region 合并药库盘点单
if (printMaster.OpType == ConfigManager.OP_YK_CHECK)
{
masterList = BindEntity <YP_CheckMaster> .CreateInstanceDAL(oleDb, BLL.Tables.YK_CHECKMASTER).GetListArray(strWhere);
if (masterList.Count <= 0)
{
return;
}
foreach (YP_CheckMaster master in masterList)
{
if (orderDt == null)
{
orderDt = BillFactory.GetQuery(ConfigManager.OP_YK_CHECK).LoadOrder(master);
orderDt.PrimaryKey = new DataColumn[] { orderDt.Columns["MAKERDICID"], orderDt.Columns["BATCHNUM"] };
continue;
}
else
{
DataTable newDt = BillFactory.GetQuery(ConfigManager.OP_YK_CHECK).LoadOrder(master);
for (int index = 0; index < newDt.Rows.Count; index++)
{
DataRow currentRow = newDt.Rows[index];
DataRow findRow = orderDt.Rows.Find(new object[] { Convert.ToInt32(currentRow["MAKERDICID"]),
currentRow["BATCHNUM"].ToString() });
if (findRow == null)
{
orderDt.Rows.Add(currentRow.ItemArray);
}
else
{
findRow["CPACKNUM"] = Convert.ToDecimal(findRow["CPACKNUM"])
+ Convert.ToDecimal(currentRow["CPACKNUM"]);
findRow["CKRETAILFEE"] = Convert.ToDecimal(findRow["CKRETAILFEE"])
+ Convert.ToDecimal(currentRow["CKRETAILFEE"]);
findRow["CKTRADEFEE"] = Convert.ToDecimal(findRow["CKTRADEFEE"])
+ Convert.ToDecimal(currentRow["CKTRADEFEE"]);
}
}
}
}
}
#endregion
#region 生成盘点单汇总数据
billOrder = orderDt.Clone();
DataRow[] dRows = orderDt.Select("", "typename,chemname asc");
foreach (DataRow dRow in dRows)
{
billOrder.Rows.Add(dRow.ItemArray);
}
billOrder.Columns.Add("DIFFFEE", System.Type.GetType("System.Decimal"));
billOrder.Columns.Add("DIFFTRADEFEE", System.Type.GetType("System.Decimal"));
for (int index = 0; index < billOrder.Rows.Count; index++)
{
decimal diffRetailFee = Convert.ToDecimal(billOrder.Rows[index]["CKRETAILFEE"]) -
Convert.ToDecimal(billOrder.Rows[index]["FTRETAILFEE"]);
decimal diffTradeFee = Convert.ToDecimal(billOrder.Rows[index]["CKTRADEFEE"]) -
Convert.ToDecimal(billOrder.Rows[index]["FTTRADEFEE"]);
billOrder.Rows[index]["DIFFFEE"] = diffRetailFee;
billOrder.Rows[index]["DIFFTRADEFEE"] = diffTradeFee;
//盘盈
if (diffRetailFee > 0)
{
printMaster.MoreRetailFee += diffRetailFee;
printMaster.MoreTradeFee += diffTradeFee;
}
//盘亏
else
{
printMaster.LessRetailFee -= diffRetailFee;
printMaster.LessTradeFee -= diffTradeFee;
}
}
printMaster.AuditNum = masterList[0].AuditNum;
printMaster.AuditPeopleID = masterList[0].AuditPeopleID;
printMaster.AuditTime = masterList[0].AuditTime;
printMaster.DeptID = masterList[0].DeptID;
#endregion
#region 参数赋值
if (billOrder.Rows.Count > 0)
{
_printOrder = billOrder;
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(report_FetchRecord);
report.ParameterByName("CheckDate").AsDateTime = printMaster.AuditTime;
report.ParameterByName("BillNo").AsString = printMaster.AuditNum.ToString();
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName;
report.ParameterByName("Printer").AsString = BaseData.GetUserName(Printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("AuditPeople").AsString = BaseData.GetUserName(printMaster.AuditPeopleID);
report.ParameterByName("AuditDept").AsString = BaseData.GetDeptName(printMaster.DeptID.ToString()) + "盘点单据";
report.ParameterByName("FtTradeFee").AsString = billOrder.Compute("sum(CKTRADEFEE)", "").ToString();
report.ParameterByName("FtRetailFee").AsString = billOrder.Compute("sum(CKRETAILFEE)", "").ToString();
report.ParameterByName("XYFtTradeFee").AsString = billOrder.Compute("sum(CKTRADEFEE)", "typedicid=1").ToString();
report.ParameterByName("XYFtRetailFee").AsString = billOrder.Compute("sum(CKRETAILFEE)", "typedicid=1").ToString();
report.ParameterByName("ZCYFtTradeFee").AsString = billOrder.Compute("sum(CKTRADEFEE)", "typedicid=2").ToString();
report.ParameterByName("ZCYFtRetailFee").AsString = billOrder.Compute("sum(CKRETAILFEE)", "typedicid=2").ToString();
report.ParameterByName("ZYFtTradeFee").AsString = billOrder.Compute("sum(CKTRADEFEE)", "typedicid=3").ToString();
report.ParameterByName("ZYFtRetailFee").AsString = billOrder.Compute("sum(CKRETAILFEE)", "typedicid=3").ToString();
report.ParameterByName("WZFtTradeFee").AsString = billOrder.Compute("sum(CKTRADEFEE)", "typedicid=4").ToString();
report.ParameterByName("WZFtRetailFee").AsString = billOrder.Compute("sum(CKRETAILFEE)", "typedicid=4").ToString();
report.ParameterByName("CkTradeFee").AsString = billOrder.Compute("sum(FTTRADEFEE)", "").ToString();
report.ParameterByName("CkRetailFee").AsString = billOrder.Compute("sum(FTRETAILFEE)", "").ToString();
report.ParameterByName("XYCkTradeFee").AsString = billOrder.Compute("sum(FTTRADEFEE)", "typedicid=1").ToString();
report.ParameterByName("XYCkRetailFee").AsString = billOrder.Compute("sum(FTRETAILFEE)", "typedicid=1").ToString();
report.ParameterByName("ZCYCkTradeFee").AsString = billOrder.Compute("sum(FTTRADEFEE)", "typedicid=2").ToString();
report.ParameterByName("ZCYCkRetailFee").AsString = billOrder.Compute("sum(FTRETAILFEE)", "typedicid=2").ToString();
report.ParameterByName("ZYCkTradeFee").AsString = billOrder.Compute("sum(FTTRADEFEE)", "typedicid=3").ToString();
report.ParameterByName("ZYCkRetailFee").AsString = billOrder.Compute("sum(FTRETAILFEE)", "typedicid=3").ToString();
report.ParameterByName("WZCkTradeFee").AsString = billOrder.Compute("sum(FTTRADEFEE)", "typedicid=4").ToString();
report.ParameterByName("WZCkRetailFee").AsString = billOrder.Compute("sum(FTRETAILFEE)", "typedicid=4").ToString();
report.ParameterByName("MoreRetailFee").AsString = printMaster.MoreRetailFee.ToString();
report.ParameterByName("MoreTradeFee").AsString = printMaster.MoreTradeFee.ToString();
report.ParameterByName("XYMoreRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=1 and difffee>0").ToString();
report.ParameterByName("XYMoreTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=1 and difftradefee>0").ToString();
report.ParameterByName("ZCYMoreRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=2 and difffee>0").ToString();
report.ParameterByName("ZCYMoreTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=2 and difftradefee>0").ToString();
report.ParameterByName("ZYMoreRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=3 and difffee>0").ToString();
report.ParameterByName("ZYMoreTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=3 and difftradefee>0").ToString();
report.ParameterByName("WZMoreRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=4 and difffee>0").ToString();
report.ParameterByName("WZMoreTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=4 and difftradefee>0").ToString();
report.ParameterByName("LessRetailFee").AsString = (-printMaster.LessRetailFee).ToString();
report.ParameterByName("LessTradeFee").AsString = (-printMaster.LessTradeFee).ToString();
report.ParameterByName("XYLessRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=1 and difffee<0").ToString();
report.ParameterByName("XYLessTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=1 and difftradefee<0").ToString();
report.ParameterByName("ZCYLessRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=2 and difffee<0").ToString();
report.ParameterByName("ZCYLessTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=2 and difftradefee<0").ToString();
report.ParameterByName("ZYLessRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=3 and difffee<0").ToString();
report.ParameterByName("ZYLessTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=3 and difftradefee<0").ToString();
report.ParameterByName("WZLessRetailFee").AsString = billOrder.Compute("sum(DIFFFEE)", "typedicid=4 and difffee<0").ToString();
report.ParameterByName("WZLessTradeFee").AsString = billOrder.Compute("sum(DIFFTRADEFEE)", "typedicid=4 and difftradefee<0").ToString();
report.PrintPreview(false);
}
#endregion
}
catch (Exception error)
{
throw error;
}
}
public Grid十十ReportPrinter()
{
grdrpt = new grproLib.GridppReport();
grdrpt.FetchRecord += new grproLib._IGridppReportEvents_FetchRecordEventHandler(grdrpt_FetchRecord);
}
/// <summary>
/// 打印药库入库单汇总表
/// </summary>
/// <param name="path">路径</param>
/// <param name="inMasterDt">入库单头表</param>
/// <param name="billTime">单据时间</param>
/// <param name="deptId">部门ID</param>
/// <param name="printer">打印人员ID</param>
static public void PringInStoreTotal(string path, DataTable inMasterDt, string billTime, int deptId, int printer)
{
try
{
decimal xy_RetailFee = 0, zcy_RetailFee = 0, zy_RetailFee = 0, xy_TradeFee = 0,
zcy_TradeFee = 0, zy_TradeFee = 0, wz_RetailFee = 0, wz_TradeFee = 0;
decimal xy_RetailFee1 = 0, zcy_RetailFee1 = 0, zy_RetailFee1 = 0, xy_TradeFee1 = 0,
zcy_TradeFee1 = 0, zy_TradeFee1 = 0, wz_RetailFee1 = 0, wz_TradeFee1 = 0;
int supportId = 0;
string supportName = "";
report = new grproLib.GridppReport();
report.LoadFromFile(path);
report.ParameterByName("HospitalName").AsString = HIS.SYSTEM.BussinessLogicLayer.Classes.BaseData.WorkName
+ "入库单汇总";
if (inMasterDt != null)
{
if (inMasterDt.Rows.Count >= 1)
{
report.ParameterByName("BillTime").AsString = Convert.ToDateTime(inMasterDt.Rows[0]["AUDITTIME"]).ToString()
+ "到" + Convert.ToDateTime(inMasterDt.Rows[inMasterDt.Rows.Count - 1]["AUDITTIME"]).ToString();
}
else
{
report.ParameterByName("BillTime").AsString = billTime;
}
report.ParameterByName("BillCount").AsString = inMasterDt.Rows.Count.ToString();
for (int index = 0; index < inMasterDt.Rows.Count; index++)
{
DataRow currentRow = inMasterDt.Rows[index];
int masterId = Convert.ToInt32(currentRow["MASTERINSTORAGEID"]);
if (supportId != Convert.ToInt32(currentRow["SUPPORTDICID"]))
{
supportId = Convert.ToInt32(currentRow["SUPPORTDICID"]);
string currentSupporter = BindEntity <HIS.Model.YP_SupportDic> .CreateInstanceDAL(oleDb,
BLL.Tables.YP_SUPPORTDIC).GetModel(supportId).Name;
if (supportName.IndexOf(currentSupporter + ",") == -1)
{
supportName += currentSupporter + ",";
}
}
//加载类型汇金额总表
DataTable typeFeeDt = BillQuery.LoadTotalFeeByInOrder(masterId);
DataTable outFeeDt = BillQuery.LoadTotalFeeByOutOrder(masterId);
//按类型累加各单据批发金额和零售金额(入库)
for (int temp = 0; temp < typeFeeDt.Rows.Count; temp++)
{
DataRow typeFeeRow = typeFeeDt.Rows[temp];
if (typeFeeRow["TypeDicID"] != DBNull.Value)
{
int typeId = Convert.ToInt32(typeFeeRow["TypeDicID"]);
switch (typeId)
{
case 1:
xy_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]);
xy_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
case 2:
zcy_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]);
zcy_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
case 3:
zy_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]);
zy_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
case 4:
wz_RetailFee += Convert.ToDecimal(typeFeeRow["RetailFee"]);
wz_TradeFee += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
default:
break;
}
}
}
//按类型累加各单据批发金额和零售金额(退库) //update by heyan 增加退库汇总信息
for (int temp = 0; temp < outFeeDt.Rows.Count; temp++)
{
DataRow typeFeeRow = outFeeDt.Rows[temp];
if (typeFeeRow["TypeDicID"] != DBNull.Value)
{
int typeId = Convert.ToInt32(typeFeeRow["TypeDicID"]);
switch (typeId)
{
case 1:
xy_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]);
xy_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
case 2:
zcy_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]);
zcy_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
case 3:
zy_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]);
zy_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
case 4:
wz_RetailFee1 += Convert.ToDecimal(typeFeeRow["RetailFee"]);
wz_TradeFee1 += Convert.ToDecimal(typeFeeRow["TradeFee"]);
break;
default:
break;
}
}
}
}
//报表参数赋值
report.ParameterByName("SupportName").AsString = supportName;
report.ParameterByName("TradeFee").AsString = (xy_TradeFee + zcy_TradeFee +
zy_TradeFee + wz_TradeFee).ToString("0.00");
report.ParameterByName("DiffFee").AsString = (xy_RetailFee + zcy_RetailFee + zy_RetailFee + wz_RetailFee
- xy_TradeFee - zcy_TradeFee - zy_TradeFee - wz_TradeFee).ToString("0.00");
report.ParameterByName("RetailFee").AsString = (xy_RetailFee + zcy_RetailFee +
zy_RetailFee + wz_RetailFee).ToString("0.00");
report.ParameterByName("RetailFee_XY").AsString = xy_RetailFee.ToString("0.00");
report.ParameterByName("RetailFee_ZCY").AsString = zcy_RetailFee.ToString("0.00");
report.ParameterByName("RetailFee_ZY").AsString = zy_RetailFee.ToString("0.00");
report.ParameterByName("RetailFee_WZ").AsString = wz_RetailFee.ToString("0.00");
report.ParameterByName("TradeFee_XY").AsString = xy_TradeFee.ToString("0.00");
report.ParameterByName("TradeFee_ZCY").AsString = zcy_TradeFee.ToString("0.00");
report.ParameterByName("TradeFee_ZY").AsString = zy_TradeFee.ToString("0.00");
report.ParameterByName("TradeFee_WZ").AsString = wz_TradeFee.ToString("0.00");
report.ParameterByName("DiffFee_XY").AsString = (xy_RetailFee - xy_TradeFee).ToString("0.00");
report.ParameterByName("DiffFee_ZCY").AsString = (zcy_RetailFee - zcy_TradeFee).ToString("0.00");
report.ParameterByName("DiffFee_ZY").AsString = (zy_RetailFee - zy_TradeFee).ToString("0.00");
report.ParameterByName("DiffFee_WZ").AsString = (wz_RetailFee - wz_TradeFee).ToString("0.00");
report.ParameterByName("DeptName").AsString = BaseData.GetDeptName(deptId.ToString());
report.ParameterByName("Printer").AsString = BaseData.GetUserName(printer);
report.ParameterByName("PrintTime").AsDateTime = HIS.SYSTEM.PubicBaseClasses.XcDate.ServerDateTime;
report.ParameterByName("TradeFee1").AsString = (xy_TradeFee1 + zcy_TradeFee1 +
zy_TradeFee1 + wz_TradeFee1).ToString("0.00");
report.ParameterByName("DiffFee1").AsString = (xy_RetailFee1 + zcy_RetailFee1 + zy_RetailFee1 + wz_RetailFee1
- xy_TradeFee1 - zcy_TradeFee1 - zy_TradeFee1 - wz_TradeFee1).ToString("0.00");
report.ParameterByName("RetailFee1").AsString = (xy_RetailFee1 + zcy_RetailFee1 +
zy_RetailFee1 + wz_RetailFee1).ToString("0.00");
report.ParameterByName("RetailFee_XY1").AsString = xy_RetailFee1.ToString("0.00");
report.ParameterByName("RetailFee_ZCY1").AsString = zcy_RetailFee1.ToString("0.00");
report.ParameterByName("RetailFee_ZY1").AsString = zy_RetailFee1.ToString("0.00");
report.ParameterByName("RetailFee_WZ1").AsString = wz_RetailFee1.ToString("0.00");
report.ParameterByName("TradeFee_XY1").AsString = xy_TradeFee1.ToString("0.00");
report.ParameterByName("TradeFee_ZCY1").AsString = zcy_TradeFee1.ToString("0.00");
report.ParameterByName("TradeFee_ZY1").AsString = zy_TradeFee1.ToString("0.00");
report.ParameterByName("TradeFee_WZ1").AsString = wz_TradeFee1.ToString("0.00");
report.ParameterByName("DiffFee_XY1").AsString = (xy_RetailFee1 - xy_TradeFee1).ToString("0.00");
report.ParameterByName("DiffFee_ZCY1").AsString = (zcy_RetailFee1 - zcy_TradeFee1).ToString("0.00");
report.ParameterByName("DiffFee_ZY1").AsString = (zy_RetailFee1 - zy_TradeFee1).ToString("0.00");
report.ParameterByName("DiffFee_WZ1").AsString = (wz_RetailFee1 - wz_TradeFee1).ToString("0.00");
report.PrintPreview(false);
}
}
catch (Exception error)
{
throw error;
}
}
public void ExportDataToExcelByGridCombine(string id)
{
try
{
DataSet dsZyjl = this.GetZyjlById(int.Parse(id));
if (dsZyjl.Tables.Count > 0 && dsZyjl.Tables[0].Rows.Count > 0)
{
DataRow drZyjl = dsZyjl.Tables[0].Rows[0];
string name = drZyjl["name"].ToString();
string ybhm = drZyjl["ylzh"].ToString();
//创建报表对象
Util.ReportShow reportShow = new Util.ReportShow("shenhe_old.grf");
reportShow.SetParameter("name", name);
reportShow.SetParameter("ybhm", ybhm);
//先计算 在再并导出
Business.MainList mainList = new Business.MainList();
bool result = mainList.ComputeFeeDetail(id);
if (result)
{
DataSet ds = this.CombineFeeDetail(id);
//甲类总费用
string classAFee = "";
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dtCombineResult = ds.Tables[0];
//计算总费用
string zfy = dtCombineResult.Compute("sum(金额)", "").ToString();
reportShow.SetParameter("zfy", zfy);
//计算甲类费用
DataRow[] drClassA = dtCombineResult.Select("自付比=0 ");
if (drClassA.Length > 0)
{
object obj = dtCombineResult.Compute("sum(金额)", "自付比=0 ");
if (obj != DBNull.Value)
{
classAFee = obj.ToString();
}
reportShow.SetParameter("ClassAFee", classAFee);
}
//创建新表
DataSet dsClassB = new DataSet();
DataTable dtClassB = dtCombineResult.Clone();
dtClassB.Columns.Add("项目编码1");
dtClassB.Columns.Add("项目名称1");
dtClassB.Columns.Add("金额1");
dtClassB.Columns.Add("自付比1");
dtClassB.Columns.Add("自付金额1");
dtClassB.Columns.Add("超限价金额1");
int rowNum = 0;//新表的总行数
//计算乙类费用 10%
DataRow[] drClassB10Array = dtCombineResult.Select("自付比=0.1");
if (drClassB10Array.Length > 0)
{
//计算10%的总费用 自付总金额
string ClassB10Zfy = dtCombineResult.Compute("sum(金额)", "自付比=0.1 ").ToString();
string ClassB10SFeeTotal = dtCombineResult.Compute("sum(自付金额)", "自付比=0.1 ").ToString();
reportShow.SetParameter("ClassB10Zfy", ClassB10Zfy);
reportShow.SetParameter("ClassB10SFeeTotal", ClassB10SFeeTotal);
for (int i = 1; i <= drClassB10Array.Length; i++)
{
//奇数
if (Util.Util.IsOdd(i))
{
dtClassB.Rows.Add(drClassB10Array[i - 1].ItemArray);
rowNum++;
}
else//偶数
{
dtClassB.Rows[rowNum - 1]["项目编码1"] = drClassB10Array[i - 1]["项目编码"];
dtClassB.Rows[rowNum - 1]["项目名称1"] = drClassB10Array[i - 1]["项目名称"];
dtClassB.Rows[rowNum - 1]["金额1"] = drClassB10Array[i - 1]["金额"];
dtClassB.Rows[rowNum - 1]["自付比1"] = drClassB10Array[i - 1]["自付比"];
dtClassB.Rows[rowNum - 1]["自付金额1"] = drClassB10Array[i - 1]["自付金额"];
dtClassB.Rows[rowNum - 1]["超限价金额1"] = drClassB10Array[i - 1]["超限价金额"];
}
}
}
//计算乙类费用 20%
DataRow[] drClassB20Array = dtCombineResult.Select("自付比=0.2");
if (drClassB20Array.Length > 0)
{
//计算20%的总费用 自付总金额
string ClassB20Zfy = dtCombineResult.Compute("sum(金额)", "自付比=0.2 ").ToString();
string ClassB20SFeeTotal = dtCombineResult.Compute("sum(自付金额)", "自付比=0.2 ").ToString();
reportShow.SetParameter("ClassB20Zfy", ClassB20Zfy);
reportShow.SetParameter("ClassB20SFeeTotal", ClassB20SFeeTotal);
for (int i = 1; i <= drClassB20Array.Length; i++)
{
//奇数
if (Util.Util.IsOdd(i))
{
dtClassB.Rows.Add(drClassB20Array[i - 1].ItemArray);
rowNum++;
}
else//偶数
{
dtClassB.Rows[rowNum - 1]["项目编码1"] = drClassB20Array[i - 1]["项目编码"];
dtClassB.Rows[rowNum - 1]["项目名称1"] = drClassB20Array[i - 1]["项目名称"];
dtClassB.Rows[rowNum - 1]["金额1"] = drClassB20Array[i - 1]["金额"];
dtClassB.Rows[rowNum - 1]["自付比1"] = drClassB20Array[i - 1]["自付比"];
dtClassB.Rows[rowNum - 1]["自付金额1"] = drClassB20Array[i - 1]["自付金额"];
dtClassB.Rows[rowNum - 1]["超限价金额1"] = drClassB20Array[i - 1]["超限价金额"];
}
}
}
//计算乙类费用 30%
DataRow[] drClassB30Array = dtCombineResult.Select("自付比=0.3");
if (drClassB30Array.Length > 0)
{
//计算30%的总费用 自付总金额
string ClassB30Zfy = dtCombineResult.Compute("sum(金额)", "自付比=0.3 ").ToString();
string ClassB30SFeeTotal = dtCombineResult.Compute("sum(自付金额)", "自付比=0.3 ").ToString();
reportShow.SetParameter("ClassB30Zfy", ClassB30Zfy);
reportShow.SetParameter("ClassB30SFeeTotal", ClassB30SFeeTotal);
for (int i = 1; i <= drClassB30Array.Length; i++)
{
//奇数
if (Util.Util.IsOdd(i))
{
dtClassB.Rows.Add(drClassB30Array[i - 1].ItemArray);
rowNum++;
}
else//偶数
{
dtClassB.Rows[rowNum - 1]["项目编码1"] = drClassB30Array[i - 1]["项目编码"];
dtClassB.Rows[rowNum - 1]["项目名称1"] = drClassB30Array[i - 1]["项目名称"];
dtClassB.Rows[rowNum - 1]["金额1"] = drClassB30Array[i - 1]["金额"];
dtClassB.Rows[rowNum - 1]["自付比1"] = drClassB30Array[i - 1]["自付比"];
dtClassB.Rows[rowNum - 1]["自付金额1"] = drClassB30Array[i - 1]["自付金额"];
dtClassB.Rows[rowNum - 1]["超限价金额1"] = drClassB30Array[i - 1]["超限价金额"];
}
}
}
//计算乙类费用 40%
DataRow[] drClassB40Array = dtCombineResult.Select("自付比=0.4");
if (drClassB40Array.Length > 0)
{
//计算40%的总费用 自付总金额
string ClassB40Zfy = dtCombineResult.Compute("sum(金额)", "自付比=0.4 ").ToString();
string ClassB40SFeeTotal = dtCombineResult.Compute("sum(自付金额)", "自付比=0.4 ").ToString();
reportShow.SetParameter("ClassB40Zfy", ClassB40Zfy);
reportShow.SetParameter("ClassB40SFeeTotal", ClassB40SFeeTotal);
for (int i = 1; i <= drClassB40Array.Length; i++)
{
//奇数
if (Util.Util.IsOdd(i))
{
dtClassB.Rows.Add(drClassB40Array[i - 1].ItemArray);
rowNum++;
}
else//偶数
{
dtClassB.Rows[rowNum - 1]["项目编码1"] = drClassB40Array[i - 1]["项目编码"];
dtClassB.Rows[rowNum - 1]["项目名称1"] = drClassB40Array[i - 1]["项目名称"];
dtClassB.Rows[rowNum - 1]["金额1"] = drClassB40Array[i - 1]["金额"];
dtClassB.Rows[rowNum - 1]["自付比1"] = drClassB40Array[i - 1]["自付比"];
dtClassB.Rows[rowNum - 1]["自付金额1"] = drClassB40Array[i - 1]["自付金额"];
dtClassB.Rows[rowNum - 1]["超限价金额1"] = drClassB40Array[i - 1]["超限价金额"];
}
}
}
//创建新自费表
DataSet dsClassC = new DataSet();
DataTable dtClassC = dtCombineResult.Clone();
dtClassC.Columns.Add("项目编码1");
dtClassC.Columns.Add("项目名称1");
dtClassC.Columns.Add("金额1");
dtClassC.Columns.Add("自付比1");
dtClassC.Columns.Add("自付金额1");
dtClassC.Columns.Add("超限价金额1");
dtClassC.Columns.Add("项目编码2");
dtClassC.Columns.Add("项目名称2");
dtClassC.Columns.Add("金额2");
dtClassC.Columns.Add("自付比2");
dtClassC.Columns.Add("自付金额2");
dtClassC.Columns.Add("超限价金额2");
int rowNumSelf = 0;//新表的总行数
//计算全自付费用
DataRow[] drSelfFeeArray = dtCombineResult.Select("自付比=1 or (自付比>0 and 自付比<1 and 超限价金额>0)");
if (drSelfFeeArray.Length > 0)
{
//如果 自付比=1 全自费
//如果 自付比>0 and 自付比<1 and 超限价金额>0 超限价
for (int i = 1; i <= drSelfFeeArray.Length; i++)
{
string nameOver = "";
string nameAllSelf = "";
if (drSelfFeeArray[i - 1]["自付比"].ToString() == "1")
{
nameAllSelf = "(全自费)";
}
if (drSelfFeeArray[i - 1]["自付比"].ToString() != "1" && drSelfFeeArray[i - 1]["自付比"].ToString() != "0" && drSelfFeeArray[i - 1]["超限价金额"].ToString() != "0")
{
nameOver = "(超)";
}
//第一列
if (i % 3 == 1)
{
object[] objArray = new object[] {
drSelfFeeArray[i - 1]["项目编码"], drSelfFeeArray[i - 1]["项目名称"] + nameOver + nameAllSelf, drSelfFeeArray[i - 1]["金额"], drSelfFeeArray[i - 1]["自付比"], drSelfFeeArray[i - 1]["自付金额"], drSelfFeeArray[i - 1]["超限价金额"]
};
// dtClassC.Rows.Add(drSelfFeeArray[i - 1].ItemArray);
dtClassC.Rows.Add(objArray);
rowNumSelf++;
}
else if (i % 3 == 2)//第二列
{
dtClassC.Rows[rowNumSelf - 1]["项目编码1"] = drSelfFeeArray[i - 1]["项目编码"];
dtClassC.Rows[rowNumSelf - 1]["项目名称1"] = drSelfFeeArray[i - 1]["项目名称"] + nameOver + nameAllSelf;
dtClassC.Rows[rowNumSelf - 1]["金额1"] = drSelfFeeArray[i - 1]["金额"];
dtClassC.Rows[rowNumSelf - 1]["自付比1"] = drSelfFeeArray[i - 1]["自付比"];
dtClassC.Rows[rowNumSelf - 1]["自付金额1"] = drSelfFeeArray[i - 1]["自付金额"];
dtClassC.Rows[rowNumSelf - 1]["超限价金额1"] = drSelfFeeArray[i - 1]["超限价金额"];
}
else//第三列
{
dtClassC.Rows[rowNumSelf - 1]["项目编码2"] = drSelfFeeArray[i - 1]["项目编码"];
dtClassC.Rows[rowNumSelf - 1]["项目名称2"] = drSelfFeeArray[i - 1]["项目名称"] + nameOver + nameAllSelf;
dtClassC.Rows[rowNumSelf - 1]["金额2"] = drSelfFeeArray[i - 1]["金额"];
dtClassC.Rows[rowNumSelf - 1]["自付比2"] = drSelfFeeArray[i - 1]["自付比"];
dtClassC.Rows[rowNumSelf - 1]["自付金额2"] = drSelfFeeArray[i - 1]["自付金额"];
dtClassC.Rows[rowNumSelf - 1]["超限价金额2"] = drSelfFeeArray[i - 1]["超限价金额"];
}
}
}
//Util.Util.WriteExcel(dtClassB, "d:/test.xls");
dsClassB.Tables.Add(dtClassB);
dsClassC.Tables.Add(dtClassC);
reportShow.Report.LoadDataFromXML(dsClassB.GetXml());
grproLib.GridppReport subReport = new grproLib.GridppReport();
reportShow.Report.ControlByName("SubReport").AsSubReport.Report = subReport;
subReport.LoadDataFromXML(dsClassC.GetXml());
reportShow.Show();
}
}
else
{
MessageBox.Show("计算费用明细失败！");
return;
}
}
else
{
throw new ApplicationException("未获取到该住院记录的信息!");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnPackintBarCode_Click(object sender, EventArgs e)
{
try
{
grproLib.GridppReport Report = new grproLib.GridppReport();
DataSet ds = new DataSet();
SqlConnection conn = sqlcon.getcon("");
try
{
string sqlstr = "";
for (int i = 0; i < WPHbROWDGV.Rows.Count; i++)
{
if (WPHbROWDGV.Rows[i].Cells["Cade"].Value.ToString() != "合计")
{
sqlstr += " insert into Wph_PackingPrint(Cade,BarCode,Item,Size,Colour,Nomber,[ADd],Special) values ('" + WPHbROWDGV.Rows[i].Cells["Cade"].Value.ToString() +
"','" + WPHbROWDGV.Rows[i].Cells["BarCode"].Value.ToString() + "','" + WPHbROWDGV.Rows[i].Cells["Item_no"].Value.ToString() +
"','" + WPHbROWDGV.Rows[i].Cells["SDname"].Value.ToString() + "','" + WPHbROWDGV.Rows[i].Cells["s_color"].Value.ToString() +
"','" + WPHbROWDGV.Rows[i].Cells["NO"].Value.ToString() + "','" + WPHbROWDGV.Rows[i].Cells["stname"].Value.ToString() + "','"
+ WPHbROWDGV.Rows[i].Cells["Special"].Value.ToString() + "');";
}
}
conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
cmd.ExecuteNonQuery();
sqlstr = "";
SqlDataAdapter sqlDaper = new SqlDataAdapter("select cade,[add],Special,count(1) as counts from Wph_PackingPrint group by cade,[add],Special", conn);
sqlDaper.Fill(ds);
try
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
// % Convert.ToInt32(txtRows.Text.ToString())
for (int row = Convert.ToInt32(ds.Tables[0].Rows[i]["counts"].ToString()); row < 16; row++)
{
sqlstr += " insert into Wph_PackingPrint(Cade,[ADd],Special) values ('" + ds.Tables[0].Rows[i]["cade"].ToString() + "','" + ds.Tables[0].Rows[i]["ADd"].ToString() + "','" + ds.Tables[0].Rows[i]["Special"].ToString() + "');";
}
}
cmd = new SqlCommand(sqlstr, conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
//唯品汇条码打印
DataTable dt = new DataTable();
string Rouet = Application.StartupPath + "\\PrintRoute.xml";
string printR = "";
dt = xmldate.CXmlToDataTable(Rouet);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["FormID"].ToString() == "唯品汇条码打印")
{
printR = dt.Rows[i]["Route"].ToString();
}
}
Report.LoadFromFile(@printR);
Report.ConnectionString = sqlcon.XMLIP();
Report.QuerySQL = "select * from Wph_PackingPrint";
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
if (MessageBox.Show("\n“是”直接打印，“否”打印预览！!", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
Report.Print(true);
}
else
{
Report.PrintPreview(true);
}
//if()
//Report.PrintPreview(true);
//Report.Print(true);
conn.Open();
SqlCommand cmdd = new SqlCommand("delete from Wph_PackingPrint", conn);
cmdd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
