Wed Mar 23, 2016 11:56 am
thanks brother i am glad so much if u can help me see my code
private void CreateTableInDoc(int intCustomerId, string strMobileNo, string strCustomerName, DateTime firstDate,
DateTime lastDate)
{
try
{
//Create Table
Document document = new Document();
ParagraphStyle style = new ParagraphStyle(document);
style.ParagraphFormat.TextAlignment=TextAlignment.Center;
Section section = document.AddSection();
//load a document
//Get a paragraph
Paragraph paragraph = document.Sections[0].AddParagraph();
//Set Center Alignment
paragraph.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Right;
//Append Text
paragraph.AppendText(" کەشف حسابی بەڕێز " + strCustomerName + " لەبەرواری " +
firstDate.ToShortDateString() + " تا بەرواری " + lastDate.ToShortDateString()).CharacterFormat.FontName = "unikurd jino";
//Create Header and Data
String[] headerReceipt = {"ناوی شۆفێر", "بەروار", "جۆری چیمەنتۆ", "تێبینی", "نرخ", "طن", "ژ."};
// set width column for receipt table
CMEntities context = new CMEntities();
var queryFullTransactions =
context.CM_TRANSACTION_FULLREPORT.Where(
x =>
x.CUSTOMER_ID == intCustomerId &&
DbFunctions.TruncateTime(x.SYS_DATE) >= DbFunctions.TruncateTime(firstDate) &&
DbFunctions.TruncateTime(x.SYS_DATE) <= DbFunctions.TruncateTime(lastDate))
.OrderBy(x => x.TRANSACTION_FULLREPORT_ID)
.ToList();
if (queryFullTransactions.Any())
{
//create table receipt
foreach (var cmTransactionFullreport in queryFullTransactions)
{
// if transaction type id= 1 create table for order details
if (cmTransactionFullreport.RECEIPT_ID.HasValue &&
cmTransactionFullreport.TRANSACION_TYPE_ID == 1)
{
// get order details
var queryGetReceiptDetail =
context.CM_ORDER_DETAILS_VIEW.Where(
x => x.RECEIPT_ID == cmTransactionFullreport.RECEIPT_ID.Value)
.OrderBy(x => x.ORDER_ID)
.AsEnumerable()
.Select(
x =>
new String[]
{
x.DRIVER_NAME, x.DATE.ToShortDateString(), x.ITEM_NAME, x.NOTE,
x.PRICE.ToString(), x.QUANTITY_TONS.ToString(), x.ORDER_ID.ToString()
})
.ToArray();
Table tableOrderDetails = section.AddTable(true);
//Add Cells
tableOrderDetails.ResetCells(queryGetReceiptDetail.Length + 1, headerReceipt.Length);
//Header Row
TableRow fRow = tableOrderDetails.Rows[0];
fRow.IsHeader = true;
//Row Height
fRow.Height = 23;
//Header Format
fRow.RowFormat.BackColor = Color.AliceBlue;
for (int i = 0; i < headerReceipt.Length; i++)
{
//Cell Alignment
Paragraph p = fRow.Cells[i].AddParagraph();
fRow.Cells[i].CellFormat.VerticalAlignment =
Spire.Doc.Documents.VerticalAlignment.Middle;
p.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
//Data Format
TextRange tr = p.AppendText(headerReceipt[i]);
tr.CharacterFormat.FontName = "unikurd jino";
tr.CharacterFormat.FontSize = 14;
tr.CharacterFormat.TextColor = Color.Teal;
tr.CharacterFormat.Bold = true;
}
//Data Row
for (int r = 0; r < queryGetReceiptDetail.Length; r++)
{
TableRow dataRow = tableOrderDetails.Rows[r + 1];
//Row Height
dataRow.Height = 20;
//C Represents Column.
for (int c = 0; c < queryGetReceiptDetail[r].Length; c++)
{
//Cell Alignment
dataRow.Cells[c].CellFormat.VerticalAlignment =
Spire.Doc.Documents.VerticalAlignment.Middle;
//Fill Data in Rows
Paragraph p2 = dataRow.Cells[c].AddParagraph();
TextRange tr2 = p2.AppendText(queryGetReceiptDetail[r][c]);
//Format Cells
p2.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
tr2.CharacterFormat.FontName = "unikurd jino";
tr2.CharacterFormat.FontSize = 12;
tr2.CharacterFormat.TextColor = Color.Brown;
}
}
Paragraph paragraphEnd = document.Sections[0].AddParagraph();
paragraphEnd.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
//Append Text
paragraphEnd.AppendText("========= ");
}
if (cmTransactionFullreport.TRANSACTION_ID.HasValue &&
cmTransactionFullreport.TRANSACION_TYPE_ID == 2)
{
CM_TRANSACTION_FULLREPORT fullreport = cmTransactionFullreport;
var queryGetTransactionLoan =
context.CM_TRANSACTION_LOANS_VIEW.FirstOrDefault(x => x.TRANSACTION_ID == fullreport.TRANSACTION_ID);
Table tableLoanTransactions = section.AddTable(true);
tableLoanTransactions.ResetCells(4, 6);
tableLoanTransactions.ApplyHorizontalMerge(0, 1, 3);
tableLoanTransactions.ApplyVerticalMerge(0, 1, 3);
tableLoanTransactions.ApplyHorizontalMerge(3, 1, 2);
if (queryGetTransactionLoan != null)
{
tableLoanTransactions.Rows[0].Cells[0].AddParagraph().AppendText("تێبینی").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[1].Cells[0].AddParagraph().AppendText(queryGetTransactionLoan.NOTE).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[0].Cells[5].AddParagraph().AppendText("کۆی گشتی باڵانس").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[0].Cells[4].AddParagraph().AppendText(queryGetTransactionLoan.BEFORE_BALANCE.ToString()).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[1].Cells[5].AddParagraph().AppendText("بڕی پێ دراو").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[1].Cells[4].AddParagraph().AppendText(queryGetTransactionLoan.TOTAL_ADD.ToString()).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[1].Cells[3].AddParagraph().AppendText(queryGetTransactionLoan.TOTAL_ADD_IQD.ToString()).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[2].Cells[3].AddParagraph().AppendText(queryGetTransactionLoan.TOTAL_PAID_IQD.ToString()).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[1].Cells[2].AddParagraph().AppendText("شکێنراوە بە").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[1].Cells[1].AddParagraph().AppendText(queryGetTransactionLoan.AMOUNT_USD.ToString()).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[2].Cells[5].AddParagraph().AppendText("بڕی لێ وەرگیراو").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[2].Cells[4].AddParagraph().AppendText(queryGetTransactionLoan.TOTAL_PAID.ToString()).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[2].Cells[2].AddParagraph().AppendText("شکێنراوە بە").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[3].Cells[5].AddParagraph().AppendText("کۆی گشتی").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[3].Cells[4].AddParagraph().AppendText(queryGetTransactionLoan.AFTER_BALANCE.ToString()).CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[3].Cells[3].AddParagraph().AppendText("بەروار").CharacterFormat.FontName = "unikurd jino";
tableLoanTransactions.Rows[3].Cells[1].AddParagraph().AppendText(queryGetTransactionLoan.SYS_DATE.ToString("dd/MM/yyyy")).CharacterFormat.FontName = "unikurd jino";
}
Paragraph paragraphEnd = document.Sections[0].AddParagraph();
paragraphEnd.Format.HorizontalAlignment = Spire.Doc.Documents.HorizontalAlignment.Center;
//Append Text
paragraphEnd.AppendText("=========");
}
}
}
//Save and Launch
document.Replace(" ", " ", false, true);
//Evaluation Warning : The document was created with Spire.Doc for .NET
document.SaveToFile("WordTable.docx");
Process.Start("WordTable.docx");
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
}
}