private void PrintBarcode(int repid)
{
try
{
PageReport rpt = new PageReport();
rpt.Load(new FileInfo("reg\\doc\\barcode.rdlx"));
rpt.Report.DataSources[0].ConnectionProperties.ConnectString = KontoGlobals.sqlConnectionString.ConnectionString;
GrapeCity.ActiveReports.Document.PageDocument doc = new GrapeCity.ActiveReports.Document.PageDocument(rpt);
doc.Parameters["reportid"].CurrentValue = repid;
var frm = new KontoRepViewer(doc);
frm.Text = "Print";
var _tab = this.Parent.Parent as TabControlAdv;
if (_tab == null)
{
return;
}
var pg1 = new TabPageAdv();
pg1.Text = "Barcode Print";
_tab.TabPages.Add(pg1);
_tab.SelectedTab = pg1;
frm.TopLevel = false;
frm.Parent = pg1;
frm.Location = new System.Drawing.Point(pg1.Location.X + pg1.Width / 2 - frm.Width / 2, pg1.Location.Y + pg1.Height / 2 - frm.Height / 2);
frm.Show();// = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
Log.Error(ex, "print barcode");
}
}
public override void Print()
{
base.Print();
if (this.customGridView1.FocusedRowHandle < 0)
{
return;
}
if (KontoView.Columns.ColumnByFieldName("ReportId") != null)
{
string accname = Convert.ToString(this.customGridView1.GetRowCellValue(customGridView1.FocusedRowHandle, "AccName"));
int reportid = Convert.ToInt32(this.customGridView1.GetRowCellValue(customGridView1.FocusedRowHandle, "ReportId"));
if (KontoView.Columns.ColumnByFieldName("IsDeleted") != null)
{
if (Convert.ToBoolean(this.KontoView.GetRowCellValue(this.KontoView.FocusedRowHandle, "IsDeleted")))
{
return;
}
}
PageReport rpt = new PageReport();
rpt.Load(new FileInfo("reg\\doc\\Outwardbarcode.rdlx"));
rpt.Report.DataSources[0].ConnectionProperties.ConnectString = KontoGlobals.sqlConnectionString.ConnectionString;
GrapeCity.ActiveReports.Document.PageDocument doc = new GrapeCity.ActiveReports.Document.PageDocument(rpt);
doc.Parameters["Party"].CurrentValue = accname;
doc.Parameters["ReportId"].CurrentValue = reportid;
doc.Parameters["BarcodeNo"].CurrentValue = "0";
var frm = new KontoRepViewer(doc);
frm.Text = "Barcode";
var _tab = this.ParentForm.Parent.Parent as TabControlAdv;
if (_tab == null)
{
return;
}
var pg1 = new TabPageAdv();
pg1.Text = "Barcode Print";
_tab.TabPages.Add(pg1);
_tab.SelectedTab = pg1;
frm.TopLevel = false;
frm.Parent = pg1;
frm.Location = new System.Drawing.Point(pg1.Location.X + pg1.Width / 2 - frm.Width / 2, pg1.Location.Y + pg1.Height / 2 - frm.Height / 2);
frm.Show();// = true;
}
}
private void FrmReportNew_Load(object sender, EventArgs e)
{
try
{
// Setup a new instance of the AnnualReport.
//AnnualReport rpt = new AnnualReport();
//Run the report, and set it to the viewer control on the Form.
//String filename = "";
System.IO.FileInfo rptPath = new System.IO.FileInfo(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + reportfilename + ".rdlx");
PageReport definition = new PageReport(rptPath);
GrapeCity.ActiveReports.Document.PageDocument runtime = new GrapeCity.ActiveReports.Document.PageDocument(definition);
runtime.LocateDataSource += Runtime_LocateDataSource;
//arvMain.LoadDocument(filename);
arvMain.LoadDocument(runtime);
}
catch (ReportException ex)
{
MessageBox.Show(ex.Message, Text);
}
}
private void viewer_disp()
{
//ページレポートに接続文字列とクエリ（sql）をセットして表示する
GrapeCity.ActiveReports.PageReport rpt = new GrapeCity.ActiveReports.PageReport();
// レポート定義のファイルをロードします。
rpt.Load(new System.IO.FileInfo("rpt_uriage_denpyou.rdlx"));
// 接続文字列を変更します
//rpt.Report.DataSources[0].ConnectionProperties.DataProvider = tss.DataSource;
rpt.Report.DataSources[0].ConnectionProperties.ConnectString = tss.GetConnectionString();
// 変更するSQL文を定義します
String tmpQuery = "select * from tss_uriage_denpyou_trn";
// SQL文を変更します
rpt.Report.DataSets[0].Query.CommandText = GrapeCity.ActiveReports.Expressions.ExpressionInfo.Parse(tmpQuery, GrapeCity.ActiveReports.Expressions.ExpressionResultType.String);
GrapeCity.ActiveReports.Document.PageDocument pageDocument = new GrapeCity.ActiveReports.Document.PageDocument(rpt);
viewer1.LoadDocument(pageDocument);
//viewer1.LoadDocument("rpt_uriage_denpyou.rdlx");
}
private void viewer_disp()
{
//ページレポートに接続文字列とクエリ（sql）をセットして表示する
GrapeCity.ActiveReports.PageReport rpt = new GrapeCity.ActiveReports.PageReport();
// レポート定義のファイルをロードします。
rpt.Load(new System.IO.FileInfo("rpt_uriage_denpyou.rdlx"));
// 接続文字列を変更します
//rpt.Report.DataSources[0].ConnectionProperties.DataProvider = tss.DataSource;
rpt.Report.DataSources[0].ConnectionProperties.ConnectString = tss.GetConnectionString();
// 変更するSQL文を定義します
String tmpQuery = "select * from tss_uriage_denpyou_trn";
// SQL文を変更します
rpt.Report.DataSets[0].Query.CommandText = GrapeCity.ActiveReports.Expressions.ExpressionInfo.Parse(tmpQuery,GrapeCity.ActiveReports.Expressions.ExpressionResultType.String);
GrapeCity.ActiveReports.Document.PageDocument pageDocument = new GrapeCity.ActiveReports.Document.PageDocument(rpt);
viewer1.LoadDocument(pageDocument);
//viewer1.LoadDocument("rpt_uriage_denpyou.rdlx");
}
public void ExportReport(String filename)
{
try
{
System.IO.FileInfo rptPath = new System.IO.FileInfo(System.IO.Directory.GetCurrentDirectory() + "\\report\\" + reportfilename + ".rdlx");
PageReport definition = new PageReport(rptPath);
GrapeCity.ActiveReports.Document.PageDocument runtime = new GrapeCity.ActiveReports.Document.PageDocument(definition);
//runtime.LocateDataSource += Runtime_LocateDataSource;
runtime.LocateDataSource += Runtime_LocateDataSource1;
//arvMain.LoadDocument(rptPath.FullName);
GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport PdfExport1 = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport();
PdfExport1.Export(runtime, filename);
//arvMain.LoadDocument(runtime);
Application.DoEvents();
//List<SectionExport> sectionExports = new List<SectionExport>();
//sectionExports.Add(new SectionExport
////{
//// DisplayName = Properties.Resources.SectionHTMLString,
//// Filter = Properties.Resources.HTMLFilter,
//// DefaultFileName = Properties.Resources.HTMLFileName,
//// Settings = new Export.Html.Section.HtmlExport()
////});
////sectionExports.Add(new SectionExport
//{
// DisplayName = Properties.Resources.SectionPDFString,
// Filter = Properties.Resources.PDFFilter,
// DefaultFileName = Properties.Resources.PDFFileName,
// Settings = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport()
//});
//this.Show();
//Application.DoEvents();
//((SectionExport)sectionExports[0]).Export(arvMain.Document, filename);
}
catch (ReportException ex)
{
MessageBox.Show(ex.Message, Text);
}
//sectionExports.Add(new SectionExport
//{
// DisplayName = Properties.Resources.SectionRTFString,
// Filter = Properties.Resources.RtfFilter,
// DefaultFileName = Properties.Resources.RtfFileName,
// Settings = new Export.Word.Section.RtfExport()
//});
//sectionExports.Add(new SectionExport
//{
// DisplayName = Properties.Resources.SectionTIFFString,
// Filter = Properties.Resources.TiffFilter,
// DefaultFileName = Properties.Resources.TiffFileName,
// Settings = new Export.Image.Tiff.Section.TiffExport()
//});
//sectionExports.Add(new SectionExport
//{
// DisplayName = Properties.Resources.SectionPlainTextString,
// Filter = Properties.Resources.TextFilter,
// DefaultFileName = Properties.Resources.TextFileName,
// Settings = new Export.Xml.Section.TextExport()
//});
//sectionExports.Add(new SectionExport
//{
// DisplayName = Properties.Resources.SectionExcelString,
// Filter = Properties.Resources.ExcelFilter,
// DefaultFileName = Properties.Resources.ExcelFileName,
// Settings = new XlsExport()
//});
//cmbExportFormat.DataSource = sectionExports;
//cmbExportFormat.DisplayMember = "DisplayName";
//cmbExportFormat.SelectedIndex = 0;
}
public override void SaveDataAsync(bool newmode)
{
try
{
if (_bc == null)
{
return;
}
if (qtySpinEdit.Value == 0)
{
return;
}
var st = Convert.ToDecimal(stockLabelControl.Text);
if (st - qtySpinEdit.Value < 0)
{
MessageBox.Show("Can not generate Barcode For Extra Qty");
return;
}
using (var db = new KontoContext())
{
var repid = db.Barcodes.DefaultIfEmpty().Max(x => x == null ? 0 : x.ReportId) + 1;
var barcode = Convert.ToInt32(GetNextBarcodeNo(db));
for (int i = 0; i < qtySpinEdit.Value; i++)
{
var bm = new BarcodeModel()
{
CompId = KontoGlobals.CompanyId,
IsActive = true,
IsDeleted = false,
OrderTransId = _bc.OrderTransId,
PcsNo = 1,
AccId = _bc.AccId,
Qty = 1,
ProductId = _bc.ProductId,
ReportId = repid,
RefBarcodeId = _bc.Id
};
if (i == 0)
{
bm.BarcodeNo = barcode.ToString();
}
else
{
barcode = barcode + 1;
bm.BarcodeNo = barcode.ToString();
}//String.Format("{0:d9}", (DateTime.Now.Ticks / 10) % 1000000000); //KontoUtils.GetUniqueKey(8)).tos;
db.Barcodes.Add(bm);
}
db.SaveChanges();
_bc = null;
PageReport rpt = new PageReport();
rpt.Load(new FileInfo("reg\\doc\\Outwardbarcode.rdlx"));
rpt.Report.DataSources[0].ConnectionProperties.ConnectString = KontoGlobals.sqlConnectionString.ConnectionString;
GrapeCity.ActiveReports.Document.PageDocument doc = new GrapeCity.ActiveReports.Document.PageDocument(rpt);
doc.Parameters["Party"].CurrentValue = partyLabelControl.Text;
doc.Parameters["ReportId"].CurrentValue = repid;
doc.Parameters["BarcodeNo"].CurrentValue = "0";
var frm = new KontoRepViewer(doc);
frm.Text = "Barcode";
var _tab = this.Parent.Parent as TabControlAdv;
if (_tab == null)
{
return;
}
var pg1 = new TabPageAdv();
pg1.Text = "Barcode Print";
_tab.TabPages.Add(pg1);
_tab.SelectedTab = pg1;
frm.TopLevel = false;
frm.Parent = pg1;
frm.Location = new System.Drawing.Point(pg1.Location.X + pg1.Width / 2 - frm.Width / 2, pg1.Location.Y + pg1.Height / 2 - frm.Height / 2);
frm.Show();// = true;
}
this.ResetPage();
barcodeTextEdit.Focus();
}
catch (Exception ex)
{
Log.Error(ex, "Barcode Save");
MessageBox.Show(ex.ToString());
}
}
