dt.TableName = "DataTable1";
dt.Columns.Add("id");
dt.Columns.Add("DESCRIPTION");
dt.Columns.Add("QUANTITY");
dt.Columns.Add("UNITPRICE");
dt.Columns.Add("HandWorkPrice");
DataTable dtOrder = new DataTable();
dtOrder.TableName = "Order";
dtOrder.Columns.Add("id");
dtOrder.Columns.Add("ReceiveDate");
dtOrder.Columns.Add("PRODUCT");
dtOrder.Columns.Add("MachineSN");
dtOrder.Columns.Add("TroubleDescription");
dtOrder.Columns.Add("Description2");
dtOrder.Columns.Add("Diagnose");
dtOrder.Columns.Add("SUBTOTAL");
dtOrder.Columns.Add("Inspection");
dtOrder.Columns.Add("TOTAL");
dtOrder.Columns.Add("To");
dtOrder.Columns.Add("Date");
dtOrder.Columns.Add("Telephone");
dtOrder.Columns.Add("QuotationNo");
dtOrder.Columns.Add("MOBILE");
dtOrder.Columns.Add("ENGINEER");
dtOrder.Columns.Add("Email");
dtOrder.Columns.Add("SchoolAddr");
dtOrder.Columns.Add("SchoolPhone");
dtOrder.Columns.Add("SchoolEmail");
DataSet ds = new DataSet();
ds.Tables.Add(dtOrder);
ds.Tables.Add(dt);
DataRelation dataRelation = new DataRelation("rel1", dtOrder.Columns[0], dt.Columns["id"]);
string parts = "";
listOrder = SPContext.Current.Web.Lists[Helper.Global.ListNames.OrderList];
SPList accessoryList = SPContext.Current.Web.Lists[Helper.Global.ListNames.ComponentList];
SPListItem item = listOrder.GetItemById(orderid);
string queryStr = ASPsolution.Helper.Global.QueryString.Component;
queryStr = string.Format(queryStr, orderid.ToString());
SPQuery query = new SPQuery();
query.Query = queryStr;
SPListItemCollection accessaryItem = accessoryList.GetItems(query);
List<ASPsolution.BLL.Entity.ASPOrder> order = new List<ASPsolution.BLL.Entity.ASPOrder>();
//decimal totalPrice=0;
for (int i = 0; i < accessaryItem.Count; i++)
{
DataRow dr = dt.NewRow();
dr["id"] = orderid;
dr["DESCRIPTION"] = accessaryItem[i]["Description"];
dr["QUANTITY"] = accessaryItem[i]["Count"];
//totalPrice=
dr["UNITPRICE"] = Helper.Formater.FormateCurrency(OrderProvider.ComputeComponentCustomerPrice(Convert.ToDecimal(accessaryItem[i]["Price"].ToString()), int.Parse(accessaryItem[i]["Count"].ToString()), Convert.ToDecimal(accessaryItem[i]["HandWorkPrice"].ToString())));
dr["HandWorkPrice"] = accessaryItem[i]["HandWorkPrice"];
dt.Rows.Add(dr);
parts = parts + "," + Convert.ToString(dr["Description"]);
}
if (accessaryItem.Count == 0)
{
DataRow dr = dt.NewRow();
dr["id"] = orderid;
dr["DESCRIPTION"] = "";
dr["QUANTITY"] = "";
dr["UNITPRICE"] = "";
dr["HandWorkPrice"] = "";
dt.Rows.Add(dr);
}
if (parts.StartsWith(","))
{
parts = parts.Substring(1);
}
if (parts.EndsWith(","))
{
parts = parts.Substring(0, parts.Length - 1);
}
DataRow dataRow = dtOrder.NewRow();
dataRow["id"] = orderid;
dataRow["PRODUCT"] = item["model"];
dataRow["MachineSN"] = item["MachineSN"];
dataRow["TroubleDescription"] = item["TroubleDescription"];
dataRow["Diagnose"] = item["Diagnose"];
decimal checkFee = 0m, customerFee = 0m, subTotal = 0m;
checkFee = Convert.ToDecimal(item["CheckFee"]);
customerFee = Convert.ToDecimal(item["Custom_TotalPrice"]);
subTotal = customerFee - checkFee;
dataRow["SUBTOTAL"] = Helper.Formater.FormateCurrency(subTotal);
dataRow["Inspection"] = Helper.Formater.FormateCurrency(checkFee);
dataRow["TOTAL"] = Helper.Formater.FormateCurrency(customerFee);
dataRow["Description2"] = parts;
dataRow["To"] = item["CustomName"];
try
{
dataRow["ReceiveDate"] = Convert.ToDateTime(item["receiveDate"]).ToString(Helper.Global.DateFormatReport);
dataRow["Date"] = Convert.ToDateTime(item["CreatedDate"]).ToString(Helper.Global.DateFormatReport);
}
catch(Exception ex)
{
Helper.Logger.Log("Helper.ReportHelper.cs CreatePDFReport", ex.Message);
}
dataRow["Telephone"] = item["phone"];
dataRow["QuotationNo"] = item["QuotationID"];
dataRow["MOBILE"] = item["mobile"];
SPFieldUser lookUpUser = listOrder.Fields.GetField("UserName") as SPFieldUser;
SPFieldUserValue userValue = lookUpUser.GetFieldValue(item["UserName"].ToString()) as SPFieldUserValue;
string userName = userValue.User.Name;
dataRow["ENGINEER"] = userName;// item["UserName"];/////////////////////
dataRow["Email"] = item["Email"];
listMaintenanceCenter = SPContext.Current.Web.Lists[Helper.Global.ListNames.MaintenanceCenter];
SPFieldLookup lookUp = listOrder.Fields.GetField("MaintenanceCenter") as SPFieldLookup;
SPFieldLookupValue lookUpValue = lookUp.GetFieldValue(item["MaintenanceCenter"].ToString()) as SPFieldLookupValue;
int maintenanceCenterId = int.Parse(lookUpValue.LookupId.ToString());
listMaintenanceCenter = SPContext.Current.Web.Lists[Helper.Global.ListNames.MaintenanceCenter];
SPListItem maintenanceCenter = listMaintenanceCenter.GetItemById(maintenanceCenterId);
dataRow["SchoolAddr"] = Convert.ToString(maintenanceCenter["Address"]);
dataRow["SchoolPhone"] = Convert.ToString(maintenanceCenter["Phone"]);
dataRow["SchoolEmail"] = Convert.ToString(maintenanceCenter["Email"]);
dtOrder.Rows.Add(dataRow);
string path = HttpContext.Current.Server.MapPath("/tmp/" + orderid + ".pdf");
ReportDocument repDoc = new ReportDocument();
string path1 = Helper.DocumentHelper.GetDocumentPhysicalPath("CrystalReport2.rpt");
repDoc.Load(path1);
repDoc.SetDataSource(ds);
repDoc.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, path);
System.Threading.Thread.Sleep(500);
return path;