private void BtnSave_Click(object sender, RoutedEventArgs e) { CrystalPrintConfigModel validConfig = GetValidationModel(); if (validConfig != null) { var model = this.gpConfig.DataContext as CrystalPrintConfigModel; if (model.Id == 0) // 插入打印配置 { string result = new CrystalPrintConfigService().AddConfig(validConfig); MessageBox.Show(result); } else // 更新打印配置 { validConfig.Id = model.Id; string result = new CrystalPrintConfigService().ModifyConfig(validConfig); MessageBox.Show(result); } this.gpConfig.DataContext = new CrystalPrintConfigService().GetCrystalPrintConfig(1, Dns.GetHostName()); } else { MessageBox.Show(" 参数录入不合法 "); } }
public bool UpdateCrystalPrintConfig(CrystalPrintConfigModel model) { string sql = @" update SJCrystalPrintConfig set Orientation=@Orientation,PrinterName=@PrinterName,MarginLeft=@MarginLeft,MarginTop=@MarginTop,MarginRight=@MarginRight,MarginBottom=@MarginBottom,PaperName=@PaperName where Id=@Id;"; using (var connection = SqlDb.UpdateConnection) { return(connection.Execute(sql, model) > 0); } }
public string ModifyConfig(CrystalPrintConfigModel model) { int count = dal.ModifyCrystalPrintConfig(model); if (count != 1) { return(" 更改参数配置失败"); } return(" 保存成功 "); }
public string AddConfig(CrystalPrintConfigModel model) { int count = dal.AddCrystalPrintConfig(model); if (count != 1) { return(" 新增参数配置失败"); } return(" 保存成功 "); }
public bool InsertCrystalPrintConfig(CrystalPrintConfigModel model) { string sql = @" insert into SJCrystalPrintConfig(TypeId,TypeDesciption,HostName,PrinterName,MarginLeft,MarginTop,MarginRight,MarginBottom,PaperName,UserId) values(@TypeId,@TypeDesciption,@HostName,@PrinterName,@MarginLeft,@MarginTop,@MarginRight,@MarginBottom,@PaperName,@UserId);"; using (var connection = SqlDb.UpdateConnection) { return(connection.Execute(sql, model) > 0); } }
public int ModifyCrystalPrintConfig(CrystalPrintConfigModel model) { return(SqlHelper.ExecuteNonQuery(" update SJCrystalPrintConfig set Orientation=@Orientation,PrinterName=@PrinterName,MarginLeft=@MarginLeft,MarginTop=@MarginTop,MarginRight=@MarginRight,MarginBottom=@MarginBottom ,PaperName=@PaperName where Id=@Id", new SqlParameter[] { new SqlParameter("@Id", model.Id), new SqlParameter("@Orientation", model.Orientation ?? ""), new SqlParameter("@PrinterName", model.PrinterName ?? ""), new SqlParameter("@MarginLeft", model.MarginLeft), new SqlParameter("@MarginTop", model.MarginTop), new SqlParameter("@MarginRight", model.MarginRight), new SqlParameter("@MarginBottom", model.MarginBottom), new SqlParameter("@PaperName", model.PaperName) } )); }
public int AddCrystalPrintConfig(CrystalPrintConfigModel model) { return(SqlHelper.ExecuteNonQuery(" insert into SJCrystalPrintConfig(TypeId,TypeDesciption,HostName,Orientation,PrinterName,MarginLeft,MarginTop,MarginRight,MarginBottom,PaperName) values (@TypeId,@TypeDesciption,@HostName,@Orientation,@PrinterName,@MarginLeft,@MarginTop,@MarginRight,@MarginBottom,@PaperName)", new SqlParameter[] { new SqlParameter("@TypeId", model.TypeId), new SqlParameter("@TypeDesciption", model.TypeDesciption), new SqlParameter("@HostName", model.HostName), new SqlParameter("@Orientation", model.Orientation ?? ""), new SqlParameter("@PrinterName", model.PrinterName ?? ""), new SqlParameter("@MarginLeft", model.MarginLeft), new SqlParameter("@MarginTop", model.MarginTop), new SqlParameter("@MarginRight", model.MarginRight), new SqlParameter("@MarginBottom", model.MarginBottom), new SqlParameter("@PaperName", model.PaperName) } )); }
private void BtnPrint_Click(object sender, RoutedEventArgs e) { if (this.MainDataGrid.SelectedItems.Count == 1) { CustomerModel customer = this.MainDataGrid.SelectedItem as CustomerModel; CrystalPrintConfigModel validConfig = GetValidationModel(); if (validConfig != null) { DataTable dataTable = UniversalFunction.ModelToTable <CustomerModel>(new List <CustomerModel> { this.MainDataGrid.SelectedItems[0] as CustomerModel }); ReportDocument reportDoc = new ReportDocument(); string reportDataSource = System.IO.Path.Combine(Directory.GetCurrentDirectory(), "Report/Customer.rpt"); reportDoc.Load(reportDataSource); reportDoc.SetDataSource(dataTable); ////打印机名称设置 //reportDoc.PrintOptions.PrinterName = validConfig.PrinterName; //// 打印方向设置(此处和对应的模板方向一致即可) //if (validConfig.Orientation == "横向") // reportDoc.PrintOptions.PaperOrientation = PaperOrientation.Landscape; //else if (validConfig.Orientation == "竖向") // reportDoc.PrintOptions.PaperOrientation = PaperOrientation.Portrait; //else // reportDoc.PrintOptions.PaperOrientation = PaperOrientation.DefaultPaperOrientation; ////打印机页面大小设置 //PageSettings settings = new PageSettings(new PrinterSettings { PrinterName = validConfig.PrinterName }); //var pageSizes = PrintHelper.GetPrinterPageSizes(validConfig.PrinterName); //int rawKind = Convert.ToInt32(this.CbPaperSize.SelectedValue); //reportDoc.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)rawKind; // 打印机页边距设置 //PageMargins margins = reportDoc.PrintOptions.PageMargins; // margins.bottomMargin = validConfig.MarginBottom * 100; // margins.leftMargin = validConfig.MarginLeft * 100; // margins.rightMargin = validConfig.MarginRight * 100; // margins.topMargin = validConfig.MarginTop * 100; // reportDoc.PrintOptions.ApplyPageMargins(margins); //应用页边距。 PrinterSettings printerSettings = new PrinterSettings(); printerSettings.PrinterName = validConfig.PrinterName; PageSettings pageSettings = new PageSettings(printerSettings); pageSettings.Margins = new Margins { Left = validConfig.MarginLeft * 1000 / 254, Top = validConfig.MarginTop * 1000 / 254, Right = validConfig.MarginRight * 1000 / 254, Bottom = validConfig.MarginBottom * 1000 / 254 }; pageSettings.Landscape = validConfig.Orientation == "竖向"?true:false; // 打印 //reportDoc.PrintToPrinter(1, true, 0, 0); 完全按照模板【页面设置】配置参数,自定义需要用重载方法,载入打印机配置。 reportDoc.PrintToPrinter(printerSettings, pageSettings, true); reportDoc.Close(); reportDoc.Dispose(); MessageBox.Show(" 打印成功 "); } else { MessageBox.Show(" 打印参数错误 "); } } else { MessageBox.Show("先选择一条需要打印的记录"); } }