Advertisement
Guest User

Untitled

a guest
Jan 31st, 2017
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.75 KB | None | 0 0
  1. if (sID > 0)
  2. {
  3. String retXml = String.Empty;
  4. DataSet ds = new DataSet();
  5. DataTable dtpdfAndEmailInfo = new DataTable("pdfandemailinfo");
  6. DataRow dr = dtpdfAndEmailInfo.NewRow();
  7.  
  8. dtpdfAndEmailInfo.Clear();
  9. dtpdfAndEmailInfo.Columns.Add("mailFrom", typeof(string));
  10. dtpdfAndEmailInfo.Columns.Add("mailTo", typeof(string));
  11. dtpdfAndEmailInfo.Columns.Add("mailCC", typeof(string));
  12. dtpdfAndEmailInfo.Columns.Add("mailBCC", typeof(string));
  13. dtpdfAndEmailInfo.Columns.Add("mailSubject", typeof(string));
  14. dtpdfAndEmailInfo.Columns.Add("salesorderpdfurl", typeof(string));
  15. ds.Tables.Add(dtpdfAndEmailInfo);
  16. dtpdfAndEmailInfo.Rows.Add(dr);
  17. String fileDirectory="D:\po\Sandbox\po\BOID_858_ORGID_571\SalesOrderPdf\" ;
  18. String FileName ="BOID_858_SOID_151382.pdf";
  19. for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
  20. {
  21. ds.Tables[0].Rows[i]["mailFrom"] = "someemailid@yopmail.com";
  22. ds.Tables[0].Rows[i]["mailTo"] = "someemailid1@yopmail.com";
  23. ds.Tables[0].Rows[i]["mailCC"] = "someemailid2@yopmail.com";
  24. ds.Tables[0].Rows[i]["mailSubject"] = "Test";
  25. if (System.IO.File.Exists(Path.Combine(fileDirectory, FileName)))
  26. {
  27. ds.Tables[0].Rows[i]["SalesOrderPdfURL"] = Path.Combine(fileDirectory, FileName);
  28. }
  29. else
  30. {
  31. ds.Tables[0].Rows[i]["SalesOrderPdfURL"] = "";
  32. }
  33. }
  34.  
  35. Cmd.ResponseStatus.RowCount = ds.Tables[0].Rows.Count;
  36. retXml = Util.GetXmlList(ds, "salesorderPdfAndEmailInfo", "pdfandemailinfos");
  37. }
  38.  
  39. public static string GetXmlList(DataSet ds, String rootNode, String itemNode)
  40. {
  41. return GetXmlList(ds, rootNode, @"cls=""dataArray""", itemNode, @"cls=""dataItem""");
  42. }
  43.  
  44. public static string GetXmlList(DataSet ds, String rootNode, String rootAttribute, String itemNode, String itemAttribute)
  45. {
  46. String rootNodeStartTag = String.Format("<{0} {1}>", rootNode, rootAttribute);
  47. String rootNodeEndTag = String.Format("</{0}>", rootNode);
  48. String nodeStartTag = String.Format("<{0} {1}>", itemNode, itemAttribute);
  49. String nodeEndTag = String.Format("</{0}>", itemNode);
  50.  
  51. string retXML = ds.GetXml().Replace("<NewDataSet>", rootNodeStartTag).Replace("<Table>", nodeStartTag).Replace("</NewDataSet>", rootNodeEndTag).Replace("</Table>", nodeEndTag);
  52. return HttpUtility.HtmlDecode(retXML);
  53. }
  54.  
  55. "salesorderPdfAndEmailInfo": {
  56. "pdfandemailinfo": {
  57. "mailFrom": "someemailid@yopmail.com",
  58. "mailTo": "someemailid1@yopmail.com",
  59. "mailCC": "someemailid2@yopmail.com",
  60. "mailSubject": "Test",
  61. "salesorderpdfurl": "http://localhost/por/D:\po\Sandbox\po\BOID_858_ORGID_571\SalesOrderPdf\BOID_858_SOID_151382.pdf"
  62. }
  63. }
  64.  
  65. "salesorderPdfAndEmailInfo": {
  66.  
  67. "mailFrom": "someemailid@yopmail.com",
  68. "mailTo": "someemailid1@yopmail.com",
  69. "mailCC": "someemailid2@yopmail.com",
  70. "mailSubject": "Test",
  71. "salesorderpdfurl": "http://localhost/por/D:\po\Sandbox\po\BOID_858_ORGID_571\SalesOrderPdf\BOID_858_SOID_151382.pdf"
  72.  
  73. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement