Unique's Pei Coding: 6月 2016

2016年6月30日星期四

使用擴充方法將Linq資料集合轉成DataTable

static class IQueryableExtension
{
    public static DataTable ToDataTable<T>(this IQueryable<T> data)
    {
        PropertyDescriptorCollection properties =
            TypeDescriptor.GetProperties(typeof(T));
        DataTable table = new DataTable();
        foreach (PropertyDescriptor prop in properties)
            table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);
        foreach (T item in data)
        {
            DataRow row = table.NewRow();
            foreach (PropertyDescriptor prop in properties)
                row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
            table.Rows.Add(row);
        }
        return table;
    }
}

遠端資料夾、網路芳鄰存取檔案

網路上別人寫好的遠端資料夾、網路芳鄰存取檔案的程式碼

namespace MyNameSpace
{

    #region Using directives.
    // ----------------------------------------------------------------------

    using System;
    using System.Security.Principal;
    using System.Runtime.InteropServices;
    using System.ComponentModel;

    // ----------------------------------------------------------------------
    #endregion

    /////////////////////////////////////////////////////////////////////////

    /// <summary>
    /// Impersonation of a user. Allows to execute code under another
    /// user context.
    /// Please note that the account that instantiates the Impersonator class
    /// needs to have the 'Act as part of operating system' privilege set.
    /// </summary>
    /// <remarks> 
    /// This class is based on the information in the Microsoft knowledge base
    /// article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306158
    /// 
    /// Encapsulate an instance into a using-directive like e.g.:
    /// 
    /// ...
    /// using ( new Impersonator( "myUsername", "myDomainname", "myPassword" ) )
    /// {
    /// ...
    /// [code that executes under the new context]
    /// ...
    /// }
    /// ...
    /// 
    /// Please contact the author Uwe Keim (mailto:uwe.keim@zeta-software.de)
    /// for questions regarding this class.
    /// </remarks>
    public class Impersonator :
        IDisposable
    {
        #region Public methods.
        // ------------------------------------------------------------------

        /// <summary>
        /// Constructor. Starts the impersonation with the given credentials.
        /// Please note that the account that instantiates the Impersonator class
        /// needs to have the 'Act as part of operating system' privilege set.
        /// </summary>
        /// <param name="userName">The name of the user to act as.</param>
        /// <param name="domainName">The domain name of the user to act as.</param>
        /// <param name="password">The password of the user to act as.</param>
        public Impersonator(
            string userName,
            string domainName,
            string password)
        {
            ImpersonateValidUser(userName, domainName, password);
        }

        // ------------------------------------------------------------------
        #endregion

        #region IDisposable member.
        // ------------------------------------------------------------------

        public void Dispose()
        {
            UndoImpersonation();
        }

        // ------------------------------------------------------------------
        #endregion

        #region P/Invoke.
        // ------------------------------------------------------------------

        [DllImport("advapi32.dll", SetLastError = true)]
        private static extern int LogonUser(
            string lpszUserName,
            string lpszDomain,
            string lpszPassword,
            int dwLogonType,
            int dwLogonProvider,
            ref IntPtr phToken);

        [DllImport("advapi32.dll", CharSet = CharSet.Auto, SetLastError = true)]
        private static extern int DuplicateToken(
            IntPtr hToken,
            int impersonationLevel,
            ref IntPtr hNewToken);

        [DllImport("advapi32.dll", CharSet = CharSet.Auto, SetLastError = true)]
        private static extern bool RevertToSelf();

        [DllImport("kernel32.dll", CharSet = CharSet.Auto)]
        private static extern bool CloseHandle(
            IntPtr handle);

        private const int LOGON32_LOGON_INTERACTIVE = 2;
        private const int LOGON32_PROVIDER_DEFAULT = 0;
        private const int LOGON32_LOGON_NETWORK = 3;
        private const int LOGON32_LOGON_BATCH = 4;
        private const int LOGON32_LOGON_SERVICE = 5;
        private const int LOGON32_LOGON_UNLOCK = 7;
        private const int LOGON32_LOGON_NETWORK_CLEARTEXT = 8; // Only for Win2K or higher 
        private const int LOGON32_LOGON_NEW_CREDENTIALS = 9; // Only for Win2K or higher 


        // ------------------------------------------------------------------
        #endregion

        #region Private member.
        // ------------------------------------------------------------------

        /// <summary>
        /// Does the actual impersonation.
        /// </summary>
        /// <param name="userName">The name of the user to act as.</param>
        /// <param name="domainName">The domain name of the user to act as.</param>
        /// <param name="password">The password of the user to act as.</param>
        private void ImpersonateValidUser(
            string userName,
            string domain,
            string password)
        {
            WindowsIdentity tempWindowsIdentity = null;
            IntPtr token = IntPtr.Zero;
            IntPtr tokenDuplicate = IntPtr.Zero;

            try
            {
                if (RevertToSelf())
                {//LOGON32_LOGON_NETWORK_CLEARTEXT通常是在Server為了配合多平台的檔案寫入（例如：linux）
                    //才會用這個降低安全性的選項，讓server允許直接帳號密碼登入並且寫入檔案系統
                    //LOGON32_LOGON_NEW_CREDENTIALS才是一般server會採用的安全性作法，使用者需利用帳密取得一組credential
                    //再用credential去登入server, 方可寫入server的檔案系統
                    //完整的LogonType解釋詳見msdn
                    //https://msdn.microsoft.com/en-us/library/windows/desktop/aa378184(v=vs.85).aspx
                    //Server的這個設定在 程式集=>系統管理工具=>本機安全性原則裡面，此設定為進階設定，非mis人員通常很少設定他
                    if (LogonUser(
                        userName,
                        domain,
                        password,
                        LOGON32_LOGON_NEW_CREDENTIALS,
                        LOGON32_PROVIDER_DEFAULT,
                        ref token) != 0)
                    {
                        if (DuplicateToken(token, 2, ref tokenDuplicate) != 0)
                        {
                            tempWindowsIdentity = new WindowsIdentity(tokenDuplicate);
                            impersonationContext = tempWindowsIdentity.Impersonate();
                        }
                        else
                        {
                            throw new Win32Exception(Marshal.GetLastWin32Error());
                        }
                    }
                    else
                    {
                        throw new Win32Exception(Marshal.GetLastWin32Error());
                    }
                }
                else
                {
                    throw new Win32Exception(Marshal.GetLastWin32Error());
                }
            }
            finally
            {
                if (token != IntPtr.Zero)
                {
                    CloseHandle(token);
                }
                if (tokenDuplicate != IntPtr.Zero)
                {
                    CloseHandle(tokenDuplicate);
                }
            }
        }

        /// <summary>
        /// Reverts the impersonation.
        /// </summary>
        private void UndoImpersonation()
        {
            if (impersonationContext != null)
            {
                impersonationContext.Undo();
            }
        }

        private WindowsImpersonationContext impersonationContext = null;

        // ------------------------------------------------------------------
        #endregion
    }

    /////////////////////////////////////////////////////////////////////////
}

使用方法：

string remotePath = @"\\RemoteIP\\Folder\\";
using (new Impersonator("yourUserName", "yourDomainName","yourPassword"))
{

 string[] Files = Directory.GetFiles(remotePath);

 File.Copy("localFile", "remoteFile", true);
}

參考資料：[.net]程式碼如何寫入網芳、網路磁碟、網路硬碟

2016年6月20日星期一

[DateTime] Compare 回傳結果

static void Main(string[] args)
{
    DateTime t1 = DateTime.Parse("2016-01-01");
    DateTime t2 = DateTime.Parse("2016-01-02");

    Console.WriteLine(t1.CompareTo(t2));  // DateTime.Compare(t1, t2);
    Console.WriteLine(t1.CompareTo(t1));  // DateTime.Compare(t1, t1);
    Console.WriteLine(t2.CompareTo(t1));  // DateTime.Compare(t2, t1);

    // t1 < t2 -> -1
    // t1 = t2 -> 0
    // t1 > t2 -> 1

    Console.ReadLine();
}

2016年6月4日星期六

用描述屬性取得Enum的值

Using

1 2	using System.ComponentModel; using System.Reflection;

Enum

    /// <summary>
    /// 權限類型
    /// </summary>
    public enum AuthType
    {
        [Description("Query")]
        Query,
        [Description("Add")]
        Add,
        [Description("Edit")]
        Edit,
        [Description("Delete")]
        Delete,
        [Description("Export")]
        Export,
        [Description("Import")]
        Import
    }

用描述屬性取得Enum的值

/// <summary>
/// 用描述屬性取得Enum的值
/// </summary>
/// <param name="value">Enum</param>
/// <returns></returns>
public string GetEnumDescription(Enum value)
{
    FieldInfo fi = value.GetType().GetField(value.ToString());
    DescriptionAttribute[] attributes = (DescriptionAttribute[])fi.GetCustomAttributes(typeof(DescriptionAttribute), false);
    return (attributes.Length > 0) ? attributes[0].Description : value.ToString();
}

使用反射取得物件屬性

/// <summary>
/// 用反射方式取得屬性
/// <para>Exception：屬性名稱不存在</para>
/// <para>Exception：屬性型態錯誤</para>
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="obj">欲取得屬性的物件</param>
/// <param name="PropertyName">屬性名稱</param>
/// <returns></returns>
private T GetProperty<T>(object obj, string PropertyName)
{
    // 判斷有無該屬性名稱
    PropertyInfo propertyInfo = obj.GetType().GetProperty(PropertyName);
    if (propertyInfo == null)
    {
        throw new Exception("屬性名稱：" + PropertyName + "，不存在。");
    }

    // 判斷型態是否正確
    object tmp = propertyInfo.GetValue(obj);
    if (!(tmp is T))
    {
        throw new Exception("屬性型態錯誤。");
    }

    return (T)tmp;
}

2016年6月1日星期三

AutoCompleteExtender By Ajax Using WebService

CSS

.CompletionListCssClass
{
    z-index:99999 !important;
}

aspx

<asp:TextBox ID="TextBox_PY" runat="server"></asp:TextBox>
<asp:AutoCompleteExtender 
   ID="AutoCompleteExtender1"
   runat="server"
   MinimumPrefixLength="1"
   TargetControlID="TextBox_PY"
   ServiceMethod="GetCompletionList_PY"
   ServicePath="WebService/WebServiceTest.asmx"
   CompletionSetCount="20"
   CompletionListCssClass ="CompletionListCssClass"
/>

WebService.asmx.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Services;

namespace Project.WebService
{
    /// <summary>
    ///WebServiceTest 的摘要描述
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // 若要允許使用 ASP.NET AJAX 從指令碼呼叫此 Web 服務，請取消註解下列一行。
    [System.Web.Script.Services.ScriptService]
    public class WebServiceTest : System.Web.Services.WebService
    {
        [System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
        //方法不可宣告static
        public string[] GetCompletionList_PY(string prefixText, int count)
        {
            //資料庫連線字串
            string connStr = @"Data Source=.;Initial Catalog=DatabaseName;User ID=id;Password=pw;";

            ArrayList array = new ArrayList();//儲存撈出來的字串集合

            using (SqlConnection conn = new SqlConnection(connStr))
            {
                DataSet ds = new DataSet();
                string selectStr = @"SELECT Top (" + count + ") [PY] FROM [View_PYList] Where [PY] Like '" + prefixText + "%' Order by [PY] ASC";
                SqlDataAdapter da = new SqlDataAdapter(selectStr, conn);
                conn.Open();
                da.Fill(ds);
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    array.Add(dr["PY"].ToString());
                }
            }
            return (string[])array.ToArray(typeof(string));
        }
    }
}

AutoCompleteExtender參考：https://dotblogs.com.tw/shadow/archive/2011/05/08/24535.aspx

CSS參考：http://note.tc.edu.tw/598.html

2016年6月30日 星期四

使用擴充方法將Linq資料集合轉成DataTable

遠端資料夾、網路芳鄰存取檔案

2016年6月20日 星期一

[DateTime] Compare 回傳結果

2016年6月4日 星期六

用描述屬性取得Enum的值

使用反射取得物件屬性

2016年6月1日 星期三

AutoCompleteExtender By Ajax Using WebService

2016年6月30日星期四

2016年6月20日星期一

2016年6月4日星期六

2016年6月1日星期三