این نرم افزار با کدهای HTML و با پسوند اجرایی hta تولید شده است که به صورت یک Application می‌تواند اجرا شود.
برای انجام این کار از ActiveXObjectها استفاده می‌نماید.
برای تبدیل اطلاعات موجود در sheetهای مختلف اکسل به فایل csv، مشابه نام هریک از sheetهای اکسل یک فایل csv متنی ایجاد میکند.
PM> Install-Package Postal
using Postal;
public class HomeController : Controller
{
public ActionResult Index()
{
dynamic email = new Email("Example");
email.To = "webninja@example.com";
email.FunnyLink = DB.GetRandomLolcatLink();
email.Send();
return View();
}
} To: @ViewBag.To From: lolcats@website.com Subject: Important Message Hello, You wanted important web links right? Check out this: @ViewBag.FunnyLink <3
<configuration>
...
<system.net>
<mailSettings>
<smtp deliveryMethod="network">
<network host="example.org" port="25" defaultCredentials="true"/>
</smtp>
</mailSettings>
</system.net>
...
</configuration> namespace App.Models
{
public class ExampleEmail : Email
{
public string To { get; set; }
public string Message { get; set; }
}
} public void Send()
{
var email = new ExampleEmail
{
To = "hello@world.com",
Message = "Strong typed message"
};
email.Send();
} @model App.Models.ExampleEmail To: @Model.To From: postal@example.com Subject: Example Hello, @Model.Message Thanks!
public class ExampleController : Controller
{
public ExampleController(IEmailService emailService)
{
this.emailService = emailService;
}
readonly IEmailService emailService;
public ActionResult Index()
{
dynamic email = new Email("Example");
// ...
emailService.Send(email);
return View();
}
} [Test]
public void ItSendsEmail()
{
var emailService = A.Fake<IEmailService>();
var controller = new ExampleController(emailService);
controller.Index();
A.CallTo(() => emailService.Send(A<Email>._))
.MustHaveHappened();
} To: test@test.com From: example@test.com Subject: Fancy email Views: Text, Html
Content-Type: text/plain; charset=utf-8 Hello @ViewBag.PersonName, This is a message
Content-Type: text/html; charset=utf-8
<html>
<body>
<p>Hello @ViewBag.PersonName,</p>
<p>This is a message</p>
</body>
</html> dynamic email = new Email("Example");
email.Attach(new Attachment("c:\\attachment.txt"));
email.Send(); <configuration>
<system.web.webPages.razor>
<pages pageBaseType="System.Web.Mvc.WebViewPage">
<namespaces>
<add namespace="Postal" />
</namespaces>
</pages>
</system.web.webPages.razor>
</configuration> To: john@example.org
From: app@example.org
Subject: Image
@Html.EmbedImage("~/content/postal.jpg") using Postal;
class Program
{
static void Main(string[] args)
{
// Get the path to the directory containing views
var viewsPath = Path.GetFullPath(@"..\..\Views");
var engines = new ViewEngineCollection();
engines.Add(new FileSystemRazorViewEngine(viewsPath));
var service = new EmailService(engines);
dynamic email = new Email("Test");
// Will look for Test.cshtml or Test.vbhtml in Views directory.
email.Message = "Hello, non-asp.net world!";
service.Send(email);
}
} Email Headers: برای در بر داشتن نام، در آدرس ایمیل از فرمت زیر استفاده کنید.
To: John Smith <john@example.org>
Bcc: john@smith.com, harry@green.com Subject: Example etc
Bcc: john@smith.com Bcc: harry@green.com Subject: Example etc
public class ExampleController : Controller
{
public ExampleController(IEmailService emailService)
{
this.emailService = emailService;
}
readonly IEmailService emailService;
public ActionResult Index()
{
dynamic email = new Email("Example");
// ...
var message = emailService.CreateMailMessage(email);
CustomProcessMailMessage(message);
return View();
}
} dynamic excel = Activator.CreateInstance(Type.GetTypeFromProgID("Excel.Application", true));
excel.Visible = true;
Console.WriteLine("Press Enter to close Excel.");
Console.ReadLine();
excel.Quit(); System.__ComObject does not contain a definition for 'Visible'
using Excel = Microsoft.Office.Interop.Excel;
// ...
var excel = new Excel.Application();
excel.Visible = true;
Console.WriteLine("Press Enter to close Excel.");
Console.ReadLine();
excel.Quit(); <ItemGroup>
<Reference Include="Interop.WIA">
<HintPath>..\DNTScanner.Core.TypeLibrary\bin\Debug\Interop.WIA.dll</HintPath>
<EmbedInteropTypes>True</EmbedInteropTypes>
</Reference>
</ItemGroup> <ItemGroup Condition=" '$(TargetFramework)' == 'net40' ">
<Reference Include="Microsoft.CSharp" />
</ItemGroup>
<ItemGroup Condition="'$(TargetFramework)' == 'netstandard2.0'">
<PackageReference Include="Microsoft.CSharp" Version="4.5.0" />
</ItemGroup> <Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<OutputType>Exe</OutputType>
<TargetFramework>netcoreapp3.0</TargetFramework>
</PropertyGroup>
<!--
The following 'COMReference' items were copied from a .NET Framework project.
They were added by using the Visual Studio COM References window.
See https://docs.microsoft.com/en-us/visualstudio/ide/managing-references-in-a-project?view=vs-2017.
Observe the 'EmbedInteropTypes' tag value.
See https://docs.microsoft.com/en-us/visualstudio/msbuild/common-msbuild-project-items?view=vs-2017#comreference
-->
<ItemGroup>
<COMReference Include="Microsoft.Office.Core">
<Guid>{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}</Guid>
<VersionMajor>2</VersionMajor>
<VersionMinor>8</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
<COMReference Include="Microsoft.Office.Interop.Excel">
<Guid>{00020813-0000-0000-C000-000000000046}</Guid>
<VersionMajor>1</VersionMajor>
<VersionMinor>9</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
<COMReference Include="VBIDE">
<Guid>{0002E157-0000-0000-C000-000000000046}</Guid>
<VersionMajor>5</VersionMajor>
<VersionMinor>3</VersionMinor>
<Lcid>0</Lcid>
<WrapperTool>primary</WrapperTool>
<Isolated>False</Isolated>
<EmbedInteropTypes>True</EmbedInteropTypes>
</COMReference>
</ItemGroup>
</Project> using System;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
namespace ExcelDemo
{
class Program
{
public static void Main(string[] args)
{
Excel.Application excel;
Excel.Workbook workbook;
Excel.Worksheet sheet;
Excel.Range range;
try
{
// Start Excel and get Application object.
excel = new Excel.Application();
excel.Visible = true;
// Get a new workbook.
workbook = excel.Workbooks.Add(Missing.Value);
sheet = (Excel.Worksheet)workbook.ActiveSheet;
// Add table headers going cell by cell.
sheet.Cells[1, 1] = "First Name";
sheet.Cells[1, 2] = "Last Name";
sheet.Cells[1, 3] = "Full Name";
sheet.Cells[1, 4] = "Salary";
// Format A1:D1 as bold, vertical alignment = center.
sheet.get_Range("A1", "D1").Font.Bold = true;
sheet.get_Range("A1", "D1").VerticalAlignment =
Excel.XlVAlign.xlVAlignCenter;
// Create an array to multiple values at once.
string[,] saNames = new string[5, 2];
saNames[0, 0] = "John";
saNames[0, 1] = "Smith";
saNames[1, 0] = "Tom";
saNames[1, 1] = "Brown";
saNames[2, 0] = "Sue";
saNames[2, 1] = "Thomas";
saNames[3, 0] = "Jane";
saNames[3, 1] = "Jones";
saNames[4, 0] = "Adam";
saNames[4, 1] = "Johnson";
// Fill A2:B6 with an array of values (First and Last Names).
sheet.get_Range("A2", "B6").Value2 = saNames;
// Fill C2:C6 with a relative formula (=A2 & " " & B2).
range = sheet.get_Range("C2", "C6");
range.Formula = "=A2 & \" \" & B2";
// Fill D2:D6 with a formula(=RAND()*100000) and apply format.
range = sheet.get_Range("D2", "D6");
range.Formula = "=RAND()*100000";
range.NumberFormat = "$0.00";
// AutoFit columns A:D.
range = sheet.get_Range("A1", "D1");
range.EntireColumn.AutoFit();
// Make sure Excel is visible and give the user control
// of Microsoft Excel's lifetime.
excel.Visible = true;
excel.UserControl = true;
}
catch (Exception e)
{
Console.WriteLine($"Error: {e.Message} Line: {e.Source}");
}
}
}
}
DECLARE @tblTest AS TABLE (xmlField XML)
INSERT INTO @tblTest
(
xmlField
)
VALUES
(
'<Sample>
<Node1>Value1</Node1>
<Node2>Value2</Node2>
<Node3>OldValue</Node3>
</Sample>'
)
DECLARE @newValue VARCHAR(50)
SELECT @newValue = 'NewValue'
UPDATE @tblTest
SET xmlField.modify('replace value of (/Sample/Node3)[1] with ' + @newValue)
The argument 1 of the XML data type method "modify" must be a string literal.
DECLARE @newValue VARCHAR(50)
SELECT @newValue = 'NewValue'
UPDATE @tblTest
SET xmlField.modify(
'replace value of (/Sample/Node3)[1] with sql:variable("@newValue")'
)
XQuery [@tblTest.xmlField.modify()]: The target of 'replace value of' must be a non-metadata attribute or an element with simple typed content, found 'element(NodeThree,xdt:untyped) ?'
DECLARE @newValue VARCHAR(50)
SELECT @newValue = 'NewValue'
UPDATE @tblTest
SET xmlField.modify(
'replace value of (/Sample/Node3/text())[1]
with sql:variable("@newValue")'
)
SELECT xmlField.value('(/Sample/Node3)[1]','varchar(50)') FROM @tblTest
DECLARE @tblTest AS TABLE (xmlField XML)
INSERT INTO @tblTest
(
xmlField
)
VALUES
(
'<Sample>
<Node1>Value1</Node1>
<Node2>Value2</Node2>
<Node3></Node3>
</Sample>'
)
DECLARE @newValue VARCHAR(50)
SELECT @newValue = 'NewValue'
UPDATE @tblTest
SET xmlField.modify(
'replace value of (/Sample/Node3/text())[1]
with sql:variable("@newValue")'
)
SELECT xmlField.value('(/Sample/Node3)[1]','varchar(50)') FROM @tblTest
DECLARE @newValue VARCHAR(50)
SELECT @newValue = 'NewValue'
UPDATE @tblTest
SET xmlField.modify(
'replace value of (/Sample/Node3/text())[1]
with sql:variable("@newValue")'
)
UPDATE @tblTest
SET xmlField.modify(
'insert text{sql:variable("@newValue")} into
(/Sample/Node3)[1] [not(text())]'
)
SELECT xmlField.value('(/Sample/Node3)[1]','varchar(50)') FROM @tblTest
<system.webServer> <staticContent> <mimeMap fileExtension=".svg" mimeType="images/svg+xml" /> <mimeMap fileExtension=".svgz" mimeType="images/svg+xml" /> <remove fileExtension=".eot" /> <mimeMap fileExtension=".eot" mimeType="application/vnd.ms-fontobject" /> <mimeMap fileExtension=".otf" mimeType="font/otf" /> <mimeMap fileExtension=".woff" mimeType="font/x-woff" /> </staticContent>
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.1.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</configSections>
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0"/>
</startup>
<connectionStrings>
<clear/>
<add name="Sample09Context"
connectionString="Data Source=CodeFirst.db"
providerName="System.Data.SQLite"/>
</connectionStrings>
</configuration>
CREATE TABLE [Payees](
[Id] [integer] PRIMARY KEY AUTOINCREMENT NOT NULL,
[Name] [text] NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedBy] [text] NULL,
[ModifiedOn] [datetime] NOT NULL,
[ModifiedBy] [text] NULL
);
CREATE TABLE [Bills](
[Id] [integer] PRIMARY KEY AUTOINCREMENT NOT NULL,
[Amount] [float](18, 2) NOT NULL,
[Description] [text] NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedBy] [text] NULL,
[ModifiedOn] [datetime] NOT NULL,
[ModifiedBy] [text] NULL,
[Payee_Id] [integer] NULL
);
Database.SetInitializer<Sample09Context>(null);
<connectionStrings>
<clear/>
<add name="Sample09Context"
connectionString="Data Source=mydb.sdf;Password=1234;Encrypt Database=True"
providerName="System.Data.SqlServerCE.4.0"/>
</connectionStrings>
<connectionStrings>
<clear/>
<add name="Sample09Context"
connectionString="Datasource=localhost; Database=testdb2; Uid=root; Pwd=123;"
providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
<system.data>
<DbProviderFactories>
<remove invariant="MySql.Data.MySqlClient"/>
<add name="MySQL Data Provider"
invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
</DbProviderFactories>
</system.data>
CREATE TABLE IF NOT EXISTS `bills` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Amount` float DEFAULT NULL,
`Description` varchar(400) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
`CreatedOn` datetime NOT NULL,
`CreatedBy` varchar(400) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
`ModifiedOn` datetime NOT NULL,
`ModifiedBy` varchar(400) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
`Payee_Id` int(11) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `payees` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(400) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
`CreatedOn` datetime NOT NULL,
`CreatedBy` varchar(400) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
`ModifiedOn` datetime NOT NULL,
`ModifiedBy` varchar(400) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;
ALTER TABLE `bills` DEFAULT CHARACTER SET utf8 COLLATE utf8_persian_ci
<connectionStrings>
<clear/>
<add name="Sample09Context"
connectionString="Datasource=localhost; Database=testdb; Uid=root; Pwd=123;CHARSET=utf8"
providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
ReactDOM.render(<App />, document.getElementById('root')); // List.js
import React, { Component } from 'react';
import { ActionButton } from './ActionButton';
export class List extends Component {
constructor(props) {
super(props);
this.state = {
items: [
{ id: 1, title: "Item 1" },
{ id: 2, title: "Item 2" },
{ id: 3, title: "Item 3" },
{ id: 4, title: "Item 4" },
{ id: 5, title: "Item 5" },
]
};
}
reverse = () => {
this.setState({ items: this.state.items.reverse() });
}
render() {
console.log("Render List Component");
return (
<div className="list-container">
<ActionButton callback={this.reverse} />
<ul>
{this.state.items.map(item => {
return <li key={item.id}>
{item.title}
</li>
})}
</ul>
</div>
);
}
}
// ActionButton.js
import React, { Component } from 'react';
export class ActionButton extends Component {
render() {
console.log("Render ActionButton Component");
return (
<button onClick={this.props.callback}>Click me</button>
);
}
} import React from 'react';
import './App.css';
import { List } from './List';
function App() {
console.log("Render App Component");
return (
<div className="App">
<h1>Reconciliation Process</h1>
<List />
</div>
);
}
export default App; 
Render App Component Render List Component Render ActionButton Component
<ul id="list">
{this.state.items.map(item => {
return <li key={item.id}>
{item.title}
</li>
})}
</ul> document.getElementById("list").classList.add("message") همانطور که مشخص است کد فوق کلاسی با نام message را به عنصر ul اضافه کرده است:
.message {
border: 1px solid green;
padding: 2rem;
}
اکنون وقتی بر روی دکمه Click me کلیک کنیم، محتوای درون کامپوننت فوق تغییر پیدا میکند، اما عنصر ul همچنان دارای کلاس message است؛ دلیل آن نیز همانطور که عنوان شد این است که React محتوای تولید شده توسط کامپوننت List را با Virtual DOM خودش مقایسه میکند و چون از لحاظ ساختار DOM با هم برابر هستند تغییری در ساختار خروجی کامپوننت ایجاد نمیکند و فقط قسمت‌هایی را که تغییر کرده‌اند، بروزرسانی خواهد کرد.
اکنون کامپوننت فوق را اینگونه تغییر خواهیم داد:
import React, { Component } from 'react';
import { ActionButton } from './ActionButton';
export class List extends Component {
constructor(props) {
// as before
}
reverse = () => {
this.setState({ items: this.state.items.reverse(), wrapInDiv: true });
}
generateElement = () => {
const list = <ul id="list">
{this.state.items.map(item => {
return <li key={item.id}>
{item.title}
</li>
})}
</ul>;
return this.state.wrapInDiv ? <div>{list}</div> : list;
}
render() {
console.log("Render List Component");
return (
<div className="list-container">
<ActionButton callback={this.reverse} />
{this.generateElement()}
</div>
);
}
}