/// <summary>
/// 在指定位置上插入表格
/// </summary>
/// <param name="type">插入类型</param>
/// <param name="value">二维字符串数组</param>
/// <param name="wordStyle">文字外观</param>
public void WriteTableToDoc <T>(InsertionPoint type, T[,] value, WordTableStyle wordStyle = WordTableStyle.LightGrid)
{
try
{
int rowCount = value.GetLength(0);
int colCount = value.GetLength(1);
Word.Range r = GetRange(type);
Word.Table tab = _wordTables.Add(r, rowCount, colCount);
tab.set_Style(wordStyle);
tab.Select();
for (int i = 0; i < rowCount; i++)
{
for (int j = 0; j < colCount; j++)
{
tab.Cell(i + 1, j + 1).Select();
_engine.Selection.TypeText(value[i, j].ToString());
}
}
}
catch (Exception ex)
{
ErrorParser(ex);
return;
}
}
/// <summary>
/// Metod koj kreira tabela vo dokumentot vo koja se zapisuvaat
/// najprvo zaglavijata na kolonite, a potoa i
/// polinjata so vrednostite za izvestajot
/// </summary>
/// <param name="rowNum"></param>
/// <param name="colNum"></param>
public void CreateTable(int rowNum, int colNum)
{
object start = 0;
object end = 0;
object styleName = "Table Grid 3";
_wordRange = _wordApplication.ActiveDocument.Range(ref start, ref end);
_wordApplication.ActiveDocument.Tables.Add(_wordRange, rowNum, colNum, ref _value, ref _value);
_wordTable = _wordDocument.Tables[1];
_wordTable.Range.Font.Size = 8;
_wordTable.set_Style(ref styleName);
for (int k = 0; k < colNum; k++)
{
_wordCell = _wordTable.Cell(1, k + 1);
_wordCell.Range.Text = (string)Headers[k];
}
for (int i = 0; i < rowNum; i++)
{
for (int j = 0; j < colNum; j++)
{
_wordCell = _wordTable.Cell(i + 2, j + 1);
_wordCell.Range.Text = Convert.ToString(FillValues[i, j]);
}
}
}
/// <summary>
/// 设置基本的表格样式
/// </summary>
/// <param name="wordTable"></param>
public static void SetTableStyle(Word.Table wordTable)
{
//设置表格格式
try
{ //2007
object styleName = "网格型"; // "Table Grid";
wordTable.Range.Font.Size = 10;
wordTable.set_Style(ref styleName);
}
catch (Exception e)
{ //2003
try
{
object styleName = "Table Grid";
// wordTable.Range.Font.Size = 8;
wordTable.set_Style(ref styleName);
}
catch (Exception e2)
{
Console.WriteLine(e2.Message + e.Message);
}
}
}
//</Snippet82>
//---------------------------------------------------------------------
//<Snippet89>
private void CreateDocumentPropertyTable()
{
//<Snippet90>
object start = 0, end = 0;
Word.Document document = this.Application.ActiveDocument;
Word.Range rng = document.Range(ref start, ref end);
//</Snippet90>
// Insert a title for the table and paragraph marks.
//<Snippet91>
rng.InsertBefore("Document Statistics");
rng.Font.Name = "Verdana";
rng.Font.Size = 16;
rng.InsertParagraphAfter();
rng.InsertParagraphAfter();
rng.SetRange(rng.End, rng.End);
//</Snippet91>
// Add the table.
//<Snippet92>
rng.Tables.Add(document.Paragraphs[2].Range, 3, 2, ref missing, ref missing);
//</Snippet92>
// Format the table and apply a style.
//<Snippet93>
Word.Table tbl = document.Tables[1];
tbl.Range.Font.Size = 12;
tbl.Columns.DistributeWidth();
object styleName = "Table Professional";
tbl.set_Style(ref styleName);
//</Snippet93>
// Insert document properties into cells.
//<Snippet94>
tbl.Cell(1, 1).Range.Text = "Document Property";
tbl.Cell(1, 2).Range.Text = "Value";
tbl.Cell(2, 1).Range.Text = "Subject";
tbl.Cell(2, 2).Range.Text = ((Office.DocumentProperties)(document.BuiltInDocumentProperties))
[Word.WdBuiltInProperty.wdPropertySubject].Value.ToString();
tbl.Cell(3, 1).Range.Text = "Author";
tbl.Cell(3, 2).Range.Text = ((Office.DocumentProperties)(document.BuiltInDocumentProperties))
[Word.WdBuiltInProperty.wdPropertyAuthor].Value.ToString();
//</Snippet94>
}
private void ReportWord1()
{
Word.Application app = new Word.Application();
app.Visible = true;
Word.Document doc = app.Documents.Add();
app.Selection.Font.Name = "Times New Roman";
app.Selection.Font.Size = 14;
app.Selection.Font.Bold = 1;
app.Selection.TypeText("ОТЧЕТ О ПРОДАЖАХ ЗА " +
dateTimePicker1.Value.ToShortDateString() +
" - " + dateTimePicker2.Value.ToShortDateString());
app.Selection.ParagraphFormat.Alignment =
Word.WdParagraphAlignment.wdAlignParagraphCenter;
app.Selection.TypeParagraph();
app.Selection.ParagraphFormat.Alignment =
Word.WdParagraphAlignment.wdAlignParagraphLeft;
app.Selection.Font.Bold = 0;
Word.Table t = doc.Tables.Add(app.Selection.Range, 1, 5);
Object style = "Сетка таблицы";
t.set_Style(style);
Object unit = Word.WdUnits.wdCell;
app.Selection.TypeText("Производитель");
app.Selection.MoveRight(unit);
app.Selection.TypeText("Товар");
app.Selection.MoveRight(unit);
app.Selection.TypeText("Клиент");
app.Selection.MoveRight(unit);
app.Selection.TypeText("Дата");
app.Selection.MoveRight(unit);
app.Selection.TypeText("Сумма продаж");
report1TableAdapter1.Fill(kondirDataSet1.Report1,
dateTimePicker1.Value, dateTimePicker2.Value);
foreach (KondirDataSet.Report1Row r in kondirDataSet1.Report1)
{
app.Selection.MoveRight(unit);
app.Selection.TypeText(r.SupplierName);
app.Selection.MoveRight(unit);
app.Selection.TypeText(r.ProductName);
app.Selection.MoveRight(unit);
app.Selection.TypeText(r.ClientName);
app.Selection.MoveRight(unit);
app.Selection.TypeText(r.SaleDate.ToShortDateString());
app.Selection.MoveRight(unit);
app.Selection.TypeText(r.Total.ToString());
}
}
protected void _SetTableStyle(ref Microsoft.Office.Interop.Word.Table table)
{
object style = "网格型";
table.set_Style(ref style);
//11/04/14加入
//外边框颜色
table.Rows.Borders.InsideLineStyle = Microsoft.Office.Interop.Word.WdLineStyle.wdLineStyleInset;
table.Borders.OutsideColor = Microsoft.Office.Interop.Word.WdColor.wdColorBlack;
table.Borders.OutsideLineWidth = Microsoft.Office.Interop.Word.WdLineWidth.wdLineWidth150pt;
//编写表格格式
table.LeftPadding = 0;
table.RightPadding = 0;
table.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
}
/// <summary>
/// Add a Table to your Document with the specified number of Rows and Columns
/// </summary>
/// <param name="numRows"></param>
/// <param name="numColumns"></param>
/// <returns></returns>
public static Word.Table AddTable(int numRows, int numColumns)
{
activeDocument.Tables.Add(Range: activeSelection.Range, NumRows: numRows, NumColumns: numColumns,
DefaultTableBehavior: Word.WdDefaultTableBehavior.wdWord9TableBehavior, AutoFitBehavior: Word.WdAutoFitBehavior.wdAutoFitFixed);
Word.Table table = activeSelection.Tables[1];
table.set_Style("Table Grid");
table.ApplyStyleHeadingRows = true;
table.ApplyStyleLastRow = false;
table.ApplyStyleFirstColumn = true;
table.ApplyStyleLastColumn = false;
table.ApplyStyleRowBands = true;
table.ApplyStyleColumnBands = false;
return(table);
}
/// <summary>
/// Called when [drop occurred].
/// </summary>
/// <param name="x">The x.</param>
/// <param name="y">The y.</param>
/// <param name="data">The data.</param>
public void OnDropOccurred(int x, int y, object data)
{
//Get the Word range from the form's point location
Microsoft.Office.Interop.Word.Range range = (Microsoft.Office.Interop.Word.Range)Globals.ThisAddIn.Application.ActiveWindow.RangeFromPoint(x, y);
//Insert a dummy details table for the selected order
Word.Table table = this.Application.ActiveDocument.Tables.Add(range, 4, 4);
table.Range.Font.Size = 8;
table.set_Style("Table Grid 8");
table.Rows[1].Cells[1].Range.Text = "Order Details";
table.Rows[1].Cells[2].Range.Text = "Order Details";
table.Rows[1].Cells[3].Range.Text = "Order Details";
table.Rows[1].Cells[4].Range.Text = "Order Details";
for (int i = 2; i < 5; i++)
{
for (int j = 1; j < 5; j++)
{
table.Rows[i].Cells[j].Range.Text = data.ToString();
}
}
}
private void addDocument(Word.Table oTable, loepDocument document)
{
try { oTable.set_Style(Doc.Styles["Table Grid"].NameLocal); }
catch { }
oTable.Range.ParagraphFormat.SpaceAfter = 0;
int fileExtPos = document.name.LastIndexOf(".");
if (fileExtPos >= 0)
{
document.name = document.name.Substring(0, fileExtPos);
}
oTable.Rows[oTable.Rows.Count - 2].Range.Text = document.name;
oTable.Rows[oTable.Rows.Count - 2].Range.Font.Bold = 1;
oTable.Rows[oTable.Rows.Count - 2].Range.Font.Size = 10;
oTable.Rows[oTable.Rows.Count - 2].Range.Font.Position = 1;
oTable.Rows[oTable.Rows.Count - 2].Cells[1].Merge(oTable.Rows[oTable.Rows.Count - 2].Cells[2]);
oTable.Rows[oTable.Rows.Count - 2].Cells[1].Merge(oTable.Rows[oTable.Rows.Count - 2].Cells[2]);
oTable.Rows[oTable.Rows.Count - 2].Cells[1].Merge(oTable.Rows[oTable.Rows.Count - 2].Cells[2]);
oTable.Cell(oTable.Rows.Count - 2, 1).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Rows[oTable.Rows.Count - 1].Range.Font.Size = 10;
oTable.Rows[oTable.Rows.Count].Range.Font.Size = 9;
oTable.Rows[oTable.Rows.Count - 1].Range.Font.Bold = 1;
oTable.Cell(oTable.Rows.Count - 1, 1).Range.Text = "From Page";
oTable.Cell(oTable.Rows.Count - 1, 2).Range.Text = "To Page";
oTable.Cell(oTable.Rows.Count - 1, 3).Range.Text = "Revision";
oTable.Cell(oTable.Rows.Count - 1, 4).Range.Text = "Date";
oTable.Cell(oTable.Rows.Count - 1, 1).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Cell(oTable.Rows.Count - 1, 2).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Cell(oTable.Rows.Count - 1, 3).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Cell(oTable.Rows.Count - 1, 4).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Cell(oTable.Rows.Count, 1).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Cell(oTable.Rows.Count, 2).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Cell(oTable.Rows.Count, 3).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
oTable.Cell(oTable.Rows.Count, 4).Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphCenter;
addPages(document.location, oTable);
}
public static void FormatTable()
{
Word.Application app = Globals.ThisAddIn.Application;
Word.Table table = app.Selection.Range.Tables[1];
for (int row = 1; row <= table.Rows.Count; row++)
{
for (int col = 1; col <= table.Columns.Count; col++)
{
try {
table.Cell(row, col).Range.Select();
app.Selection.ClearFormatting();
if (row == 1)
{
table.Cell(row, col).Range.set_Style(app.ActiveDocument.Styles["2016_TableHeader | 10pt bold"]);
}
else
{
table.Cell(row, col).Range.set_Style(app.ActiveDocument.Styles["2016_Table | 9pt"]);
}
} catch (Exception f) {
Debug.Print(f.Message);
}
}
}
table.set_Style(app.ActiveDocument.Styles["MasterTable"]);
table.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitContent);
table.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitWindow);
try {
table.Cell(1, 1).Row.HeadingFormat = (int)Word.WdConstants.wdToggle;
table.ApplyStyleHeadingRows = true;
} catch (Exception) { };
}
public Wordy.Table wstawTabele(object bookmark, String[] naglowki)
{
Wordy.Bookmark book = doc.Bookmarks.get_Item(ref oEndOfDoc);
Wordy.Table tab = doc.Tables.Add(book.Range, 1, naglowki.Count());
// tab.Range.ParagraphFormat.SpaceAfter = 6;
object styleName = stylTab;
tab.set_Style(ref styleName);
int i = 1;
foreach (String kol in naglowki)
{
Wordy.Cell cel = tab.Cell(1, i);
cel.Range.Text = kol;
object snorm = stylNorm;
cel.Range.set_Style(ref snorm);
i++;
}
return(tab);
}
private void btnTarife_Click(object sender, EventArgs e)
{
Tarife = new Word.Application();
Tarife.Visible = true;
Word.Document wdoc = Tarife.Documents.Add();
Word.Range wr = wdoc.Range();
wr.Text = "\n\n" + "TARIFE HOTEL" + "\n\n\n";
wr.Font.Name = "Segoe UI";
wr.Font.Size = 14;
wr.Font.Bold = -1;
wdoc.Paragraphs.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
wr.Collapse(Word.WdCollapseDirection.wdCollapseEnd);
Word.Table tabel = wr.Tables.Add(wr, 9, 2);
wr.Collapse(Word.WdCollapseDirection.wdCollapseEnd);
tabel.set_Style("Table Grid 8");
tabel.Borders.Enable = 1;
tabel.Cell(1, 1).Range.Text = "TIP CAMERĂ";
tabel.Cell(1, 1).Range.Font.Size = 17;
tabel.Cell(1, 2).Range.Text = "PREȚ PE NOAPTE";
tabel.Cell(1, 2).Range.Font.Size = 17;
con.Open();
OleDbDataAdapter cmdTip = new OleDbDataAdapter("SELECT Tip_Camera, Pret_Noapte " +
"FROM Camere ", con);
DataTable dtTip = new DataTable();
cmdTip.Fill(dtTip);
int nr = 0;
int linie = 2;
try
{
while (dtTip.Rows[nr][0].ToString() != "")
{
tabel.Cell(linie, 1).Range.Text = dtTip.Rows[nr][0].ToString();
tabel.Cell(linie, 2).Range.Text = dtTip.Rows[nr][1].ToString() + " LEI";
nr += 1;
linie += 1;
}
}
catch (Exception ex)
{
}
tabel.Cell(linie, 1).Range.Text = "EXTRAOPȚIUNE";
tabel.Cell(linie, 1).Range.Font.Size = 17;
tabel.Cell(linie, 1).Range.Font.Bold = 0;
tabel.Cell(linie, 1).Range.Font.Color = Word.WdColor.wdColorWhite;
tabel.Cell(linie, 1).Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorDarkBlue;
tabel.Cell(linie, 2).Range.Text = "PREȚ";
tabel.Cell(linie, 2).Range.Font.Size = 17;
tabel.Cell(linie, 2).Range.Font.Bold = 0;
tabel.Cell(linie, 2).Range.Font.Color = Word.WdColor.wdColorWhite;
tabel.Cell(linie, 2).Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorDarkBlue;
OleDbDataAdapter cmdExtra = new OleDbDataAdapter("SELECT Denumire_Extraoptiune, Pret_Extraoptiune " +
"FROM Extraoptiuni ", con);
DataTable dtExtra = new DataTable();
cmdExtra.Fill(dtExtra);
nr = 0;
try
{
while (dtExtra.Rows[nr][0].ToString() != "")
{
nr += 1;
linie += 1;
tabel.Cell(linie, 1).Range.Text = dtExtra.Rows[nr][0].ToString();
tabel.Cell(linie, 2).Range.Text = dtExtra.Rows[nr][1].ToString() + " LEI";
}
}
catch (Exception ex)
{
}
}
private void CreateDocumentPropertyTable(Document newDocument)
{
//<Snippet90>
object start = 10, end = 10;
Word.Range rangeTbl = null;
string keys = "[tbl]";
while (newDocument.Content.Find.Execute(FindText: keys))
{
if (newDocument.Content.Find.Execute(FindText: keys))
{
if (newDocument.Application.Selection.Find.Execute(keys) == true)
{
rangeTbl = newDocument.Range(newDocument.Application.Selection.Range.Start, newDocument.Application.Selection.Range.End);
}
}
}
//if (newDocument.Application.Selection.Find.Execute("[tbl]"))
//{
// rangeTbl = newDocument.Range(newDocument.Application.Selection.Range.Start, newDocument.Application.Selection.Range.End);
//}
Word.Range rng = newDocument.Range(rangeTbl.Start, rangeTbl.End);
//</Snippet90>
// Insert a title for the table and paragraph marks.
//<Snippet91>
//rng.InsertBefore("Document Statistics");
rng.Font.Name = "Calibri (Body)";
rng.Font.Size = 16;
rng.InsertParagraphAfter();
rng.InsertParagraphAfter();
rng.SetRange(rng.End, rng.End);
//</Snippet91>
// Add the table.
//<Snippet92>
rng.Tables.Add(newDocument.Paragraphs[2].Range, 3, 2);
//</Snippet92>
// Format the table and apply a style.
//<Snippet93>
Word.Table tbl = newDocument.Tables[1];
tbl.Range.Font.Size = 12;
tbl.Columns.DistributeWidth();
object styleName = "Table Professional";
tbl.set_Style(ref styleName);
//</Snippet93>
// Insert document properties into cells.
//<Snippet94>
tbl.Cell(1, 1).Range.Text = "Document Property";
tbl.Cell(1, 2).Range.Text = "Value";
tbl.Cell(2, 1).Range.Text = "Subject";
tbl.Cell(2, 2).Range.Text = "Test";
tbl.Cell(3, 1).Range.Text = "Author";
tbl.Cell(3, 2).Range.Text = "test";
//</Snippet94>
}
/// <summary>
/// 將 DataTable 插入至指定的 Word Range 位置
/// </summary>
/// <param name="dt"></param>
/// <param name="oRange"></param>
/// <returns></returns>
public static Word.Table CreateWordTableWithDataTable(DataTable dt, Word.Range oRange)
{
int RowCount = dt.Rows.Count;
int ColumnCount = dt.Columns.Count;
Object[,] DataArray = new object[RowCount, ColumnCount];
//int RowCount = 0; int ColumnCount = 0;
int r = 0;
for (int c = 0; c <= ColumnCount - 1; c++)
{
DataColumn dc = dt.Columns[c];
object[] colValues;
#region 的資料型態轉換格式化
if (dc.DataType == typeof(double))
{
var o = dt.AsEnumerable().Select(x => Math.Round(x.Field <double>(dc.ColumnName), 4)).ToArray();
colValues = new object[o.Length];
o.CopyTo(colValues, 0);
}
else if (dc.DataType == typeof(DateTime))
{
var o = dt.AsEnumerable().Select(x => string.Format("{0:yyyy-MM-dd hh:mm:ss}", x.Field <DateTime>(dc.ColumnName))).ToArray();
colValues = new object[o.Length];
o.CopyTo(colValues, 0);
}
else
{
var o = dt.AsEnumerable().Select(x => x[dc.ColumnName]).ToArray();
colValues = new object[o.Length];
o.CopyTo(colValues, 0);
}
#endregion
for (r = 0; r <= RowCount - 1; r++)
{
DataArray[r, c] = colValues[r];
} //end row loop
} //end column loop
StringBuilder oTemp = new StringBuilder();
for (r = 0; r <= RowCount - 1; r++)
{
for (int c = 0; c <= ColumnCount - 1; c++)
{
oTemp.Append(DataArray[r, c] + "\t");
}
}
oRange.Text = oTemp.ToString();
object Separator = Word.WdTableFieldSeparator.wdSeparateByTabs;
object Format = Word.WdTableFormat.wdTableFormatWeb1;
object ApplyBorders = true;
object AutoFit = true;
object AutoFitBehavior = Word.WdAutoFitBehavior.wdAutoFitContent;
Word.Table tbl = oRange.ConvertToTable(Separator: Separator,
NumRows: RowCount,
NumColumns: ColumnCount,
ApplyBorders: ApplyBorders, AutoFit: AutoFit, AutoFitBehavior: AutoFitBehavior);
tbl.Rows.AllowBreakAcrossPages = 0;
tbl.Rows.Alignment = Word.WdRowAlignment.wdAlignRowCenter;
tbl.Rows.Add(tbl.Rows[1]);
//gotta do the header row manually
for (int c = 0; c <= ColumnCount - 1; c++)
{
tbl.Cell(1, c + 1).Range.Text = dt.Columns[c].ColumnName;
}
tbl.set_Style(Word.WdBuiltinStyle.wdStyleTableLightGrid);
return(tbl);
}
private void btnExcel_Click(object sender, RibbonControlEventArgs e)
{
factura = new Word.Application();
factura.Visible = true;
Word.Document wdoc = factura.Documents.Add();
Word.Range wr = wdoc.Range();
wr.Text = "\n\n" + "FACTURĂ" + "\n\n\n";
wr.Font.Name = "Segoe UI";
wr.Font.Size = 14;
wr.Font.Bold = -1;
wdoc.Paragraphs.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
wr.Collapse(Word.WdCollapseDirection.wdCollapseEnd);
Word.Table tabel = wr.Tables.Add(wr, 4, 2);
wr.Collapse(Word.WdCollapseDirection.wdCollapseEnd);
tabel.set_Style("Table Grid 8");
tabel.Borders.Enable = 1;
tabel.Cell(1, 1).Range.Text = "DENUMIRE";
tabel.Cell(1, 1).Range.Font.Size = 17;
tabel.Cell(1, 2).Range.Text = "DE PLĂTIT";
tabel.Cell(1, 2).Range.Font.Size = 17;
tabel.Cell(2, 1).Range.Text = "REZERVARE";
tabel.Cell(3, 1).Range.Text = "ALTE CHELTUIELI";
tabel.Cell(4, 1).Range.Text = "TOTAL";
Excel.Application excel = Globals.ThisAddIn.Application;
Excel.Worksheet wsh = excel.ActiveSheet;
Excel.Range rsh = excel.Selection;
con.Open();
OleDbDataAdapter cmdInregistrari = new OleDbDataAdapter("SELECT (Pret_Noapte*(Data_Sfarsit-Data_Inceput)) AS TotalRez, Sum(Extraoptiuni.Pret_Extraoptiune) AS TotalEx " +
"FROM Clienti INNER JOIN((Rezervari INNER JOIN(Camere INNER JOIN Camere_Rezervate ON Camere.Tip_Camera = Camere_Rezervate.Tip_Camera) ON Rezervari.NR_Inregistrare = Camere_Rezervate.NR_Inregistrare) INNER JOIN(Extraoptiuni INNER JOIN Extraoptiuni_Rezervare ON Extraoptiuni.Denumire_Extraoptiune = Extraoptiuni_Rezervare.Denumire_Extraoptiune) ON Rezervari.NR_Inregistrare = Extraoptiuni_Rezervare.NR_Inregistrare) ON Clienti.ID_Client = Rezervari.ID_Client " +
"WHERE Rezervari.NR_Inregistrare Like '" + rsh.Value2.ToString() + "'" +
"GROUP BY Rezervari.NR_Inregistrare, Rezervari.Data_Inceput, Rezervari.Data_Sfarsit, Camere.Pret_Noapte; ", con);
DataTable dtInregistrari = new DataTable();
cmdInregistrari.Fill(dtInregistrari);
int a;
int b;
a = Int32.Parse(dtInregistrari.Rows[0][0].ToString());
b = Int32.Parse(dtInregistrari.Rows[0][1].ToString());
tabel.Cell(2, 2).Range.Text = dtInregistrari.Rows[0][0].ToString() + " LEI";
tabel.Cell(3, 2).Range.Text = dtInregistrari.Rows[0][1].ToString() + " LEI";
tabel.Cell(4, 2).Range.Text = (a + b).ToString() + " LEI";
con.Close();
}
private void button4_Click(object sender, EventArgs e)
{
OpenDocument($@"{_pathToDocumentDirectory}\список авто.docx");
ReplaceText("<Today>", DateTime.Today.ToShortDateString());
object start = 0;
object end = _wordDocument.Characters.Count;
Word.Range rng = _wordDocument.Range(ref
start, ref end);
rng.TextRetrievalMode.IncludeHiddenText = false;
rng.TextRetrievalMode.IncludeFieldCodes = false;
string metka = "<Table>";
int beginphrase = rng.Text.IndexOf(metka);
start = beginphrase;
end = beginphrase + metka.Length;
if (beginphrase != -1)
{
rng = _wordDocument.Range(ref start, ref end);
rng.Text = "";
object defaultTableBehavior = Type.Missing;
object autoFitBehavior = Type.Missing;
Word.Table tbl = rng.Tables.Add(rng, 1, 4, ref defaultTableBehavior, ref autoFitBehavior);
object style = "Сетка таблицы";
tbl.Range.Font.Size = 14;
tbl.set_Style(ref style);
tbl.Cell(1, 1).Range.Text = "№";
tbl.Cell(1, 2).Range.Text = "Имя марки";
tbl.Cell(1, 3).Range.Text = "Номер машины";
tbl.Cell(1, 4).Range.Text = "Дата регистрации в ГАИ";
int i = 0;
foreach (Mark mark in dB_OwnersCarsDataSet.Mark)
{
Car[] cars = mark.GetChildRows(dB_OwnersCarsDataSet.Relations["MarkCar"]) as Car[];
if (cars != null && cars.Length < 1 || cars == null)
{
continue;
}
string name = mark.MarkName;
foreach (Car car in cars)
{
i++;
object beforeRow = Type.Missing;
tbl.Rows.Add(ref beforeRow);
tbl.Cell(i + 1, 1).Range.Text = i.ToString();
tbl.Cell(i + 1, 2).Range.Text = name;
tbl.Cell(i + 1, 3).Range.Text = car.Number;
tbl.Cell(i + 1, 4).Range.Text = car.DateRegGAI.ToString();
}
}
tbl.Rows[1].Range.Font.Italic = 1;
tbl.Rows[1].Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
}
else
{
ReplaceText("Table", "");
}
_wordApplication.Visible = true;
}
