工作備忘錄: 2015

2015年12月16日星期三

[C#]Export excel by NPOI

參考網址
https://www.dotblogs.com.tw/mis2000lab/archive/2015/06/29/npoi_2131_sample_export_to_excel.aspx

2015年8月21日星期五

[C#]使用泛型實作Entity Framework DbContext的增修刪查

參考
利用EF和C#泛型实现通用分页查询
Entity與DataTable互轉
Entity Framework 5 Updating a Record

回傳結果
public class Return_Msg
{
public bool Status;
public string Message;

public Return_Msg(bool status, string message)
{
Status = status;
Message = message;
}
}
1.新增
public Return_Msg InsertData<T>(T entity) where T : class
{
Return_Msg r = new Return_Msg(true, string.Empty);

using (var context = new DbContext())
{
try
{
context.Set<T>().Add(entity);
context.SaveChanges();
}
catch (Exception e)
{
r.Status = false;
r.Message = e.ToString();
}
}
return r;
}
用法：Return_Msg r = dbService.InsertData<Sys_Menu>(menu);
2.修改
public Return_Msg UpdateData<T>(T entity) where T : class
{
Return_Msg r = new Return_Msg(true, string.Empty);

using (var context = new DbContext())
{
try
{
context.Set<T>().Attach(entity);
var entry = context.Entry(entity);
context.Entry(entity).State = EntityState.Modified;
// other changed properties
context.SaveChanges();
}
catch (Exception e)
{
r.Status = false;
r.Message = e.ToString();
}
}
return r;
}
用法：Return_Msg r = dbService.UpdateData<Sys_Menu>(menu);
3.刪除
public Return_Msg DeleteData<T>(T entity) where T : class
{
Return_Msg r = new Return_Msg(true, string.Empty);

using (var context = new DbContext())
{
try
{
context.Set<T>().Remove(entity);
context.SaveChanges();
}
catch (Exception e)
{
r.Status = false;
r.Message = e.ToString();
}
}
return r;
}
用法：Return_Msg r = dbService.DeleteData<Sys_Menu>(menu);
4.查詢
依條件查詢
public DataTable GetDataByWhere<T>(Expression<Func<T, bool>> predicate) where T : class
{
using (var context = new DbContext())
{
return EntityToDataTable<T>(context.Set<T>().Where<T>(predicate).AsEnumerable<T>());
}
}
用法：DataTable dt = dbService.GetDataByWhere<Sys_Menu>(p => p.MenuName.Contains(txtMenuName.Text));
單一Table全部資料
public DataTable GetDataAll<T>() where T : class
{
using (var context = new HDContext())
{
return EntityToDataTable<T>(context.Set<T>().AsEnumerable());
}
}
用法：DataTable dt = dbService.GetDataAll<Sys_Menu>();

2015年8月6日星期四

[C#]AD驗證登入

參考
ASP.NET透過AD進行驗證 #4 -- 會員登入、會員專屬網頁 / Login AD Account
來自 ASP .NET 的 Active Directory 網域服務驗證

2015年7月19日星期日

[C#]取得類別成員的屬性

參考
How do I get the custom attribute value of a field? [duplicate]

以取得字串最大長度為例子，取得成員的StringLength屬性

程式碼如下

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.ComponentModel.DataAnnotations;

namespace RetriveClassAttribute
{
class Program
{
static void Main(string[] args)
{

foreach (var prop in typeof(RetriveClassAttribute).GetProperties())
{
var attrs = (StringLengthAttribute[])prop.GetCustomAttributes
(typeof(StringLengthAttribute), false);
foreach (var attr in attrs)
{
Console.WriteLine("{0}: {1}", prop.Name, attr.MaximumLength);
}
}

Console.ReadLine();
}

}
class RetriveClassAttribute
{
[StringLength(30)]
public string FirstMember { get; set; }
}
}

2015年7月15日星期三

[C#]WCF Service 傳遞XML Data

參考
逐步解說：建立和存取 WCF 服務

WCF服務程式庫與WCF服務應用程式的不同

WCF服務應用程式原始碼

ISendXmlWcfService.svc
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Xml.Linq;

namespace SendXmlWcfService
{
public class SendXmlWcfService : ISendXmlWcfService
{
public string GetData(string value)
{
XDocument xml = XDocument.Parse(value);

return string.Format("To {0}\r\n {1}\r\n {2} {3}", xml.Root.Element("to").Value, xml.Root.Element("body").Value,xml.Root.Element("heading").Value,xml.Root.Element("from").Value);
}
}
}

ISendXmlWcfService.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

namespace SendXmlWcfService

{

[ServiceContract]

public interface ISendXmlWcfService

{

[OperationContract]

string GetData(string value);

}

測試WCF服務應用程式-主控台應用程式

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ConsoleApplication1

{

class Program

{

static void Main(string[] args)

{

StringBuilder builder = new StringBuilder("<note>" +

"<to>Tove</to>" +

"<from>Jani</from>" +

"<heading>Reminder</heading>" +

"<body>Don't forget me this weekend!</body>" +

"</note>");

ServiceReference1.SendXmlWcfServiceClient client = new ServiceReference1.SendXmlWcfServiceClient();

Console.WriteLine(client.GetData(builder.ToString()));

Console.ReadLine();

}

2015年7月8日星期三

[C#]StreamReader　讀取中文亂碼解決方法

參考
StreamReader　讀取中文亂碼解決方法

[C#]WebRequest 遠端伺服器傳回一個錯誤: (407) 必須 Proxy 驗證

參考
[WCF]遠端伺服器傳回未預期的回應: (407) Proxy Authentication Reqiured

在Web.config或App.config內加上

<system.net>
<defaultProxy useDefaultCredentials="true"></defaultProxy>
</system.net>

[C#]產出固定格式til檔，使用T4範本(只附參考)

參考
[入門] T4 入門教學

CODE-透過程式執行T4範本

使用 T4 文字範本在執行階段產生文字

2015年6月30日星期二

[C#]計算Tiff檔頁數，使用BitMiracle.LibTiff.Net

用NuGet下載BitMiracle.LibTiff.Net，Version：2.4.511.0
官方網頁

原始碼如下
using BitMiracle.LibTiff.Classic;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Calculate_Tiff_page_with_BitMiracle.LibTiff.Net
{
class Program
{
static void Main(string[] args)
{
string path = @"C:\Users\owlin\Downloads\test.tif";
using (Tiff image = Tiff.Open(path, "r"))
{
Console.WriteLine(CalculatePageNumber(image));
Console.ReadLine();
}
}
private static int CalculatePageNumber(Tiff image)
{
int pageCount = 0;
do
{
++pageCount;
} while (image.ReadDirectory());

return pageCount;
}
}

}

[C#]FTP上下傳檔案，使用WinSCP

用NuGet下載WinSCP .Net Assembly，Version：5.7.4
官方網頁

原始碼如下

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WinSCP;

namespace FTP_download_and_upload_with_WinSCP
{
class Program
{
static string ftpUploadUrl = "IP或domain"; //不可以有ftp:\
static string ftpAccount = "Ftp帳號";
static string ftpPassword = "Ftp密碼";
static string localPath = @"D:\temp\";
static string remotePath = "/work/";

static void Main(string[] args)
{
Download();
Upload();
}
private static void Upload()
{
try
{
SessionOptions sessionOptions = new SessionOptions
{
Protocol = Protocol.Ftp,
HostName = ftpUploadUrl,
UserName = ftpAccount,
Password = ftpPassword,
};

using (Session session = new Session())
{
// Connect
session.Open(sessionOptions);

// Upload files
TransferOptions transferOptions = new TransferOptions();
transferOptions.TransferMode = TransferMode.Binary;

TransferOperationResult transferResult;

transferResult = session.PutFiles(localPath + "*", remotePath, true, transferOptions); //*表示全部檔案

// Throw on any error
transferResult.Check();
// Print results
foreach (TransferEventArgs transfer in transferResult.Transfers)
{
Console.WriteLine("Upload of {0} succeeded", transfer.FileName);
}
session.Close();
}
}
catch (Exception e)
{
throw e;
}
}

private static void Download()
{
try
{
SessionOptions sessionOptions = new SessionOptions
{
Protocol = Protocol.Ftp,
HostName = ftpUploadUrl,
UserName = ftpAccount,
Password = ftpPassword,
};

using (Session session = new Session())
{
// Connect
session.Open(sessionOptions);

// Upload files
TransferOptions transferOptions = new TransferOptions();
transferOptions.TransferMode = TransferMode.Binary;

TransferOperationResult transferResult;

transferResult = session.GetFiles(remotePath + "*", localPath, false, transferOptions);//*表示全部檔案

// Throw on any error
transferResult.Check();
// Print results
foreach (TransferEventArgs transfer in transferResult.Transfers)
{
Console.WriteLine("Download of {0} succeeded", transfer.FileName);
}
session.Close();
}
}
catch (Exception e)
{
throw e;
}
}
}
}

2015年4月18日星期六

[C#]複寫SignalR OnConnected、OnDisconnected、OnReconnected

若要複寫SignalR Hub的OnConnected、OnDisconnected、OnReconnected

JavaScript

var chat = $.connection.chatHub;
// Need at least one callback for events to be raised on the hub
chat.client.void = function () { };//這行非加不可否則不會自動執行Server的OnConnected跟OnDisconnected
// Start the connection.
$.connection.hub.start();