程式隨筆

YourController Sut = new YourController();
 var request = Substitute.For<HttpRequestBase>();
 var context = Substitute.For<HttpContextBase>();
 request.HttpMethod.Returns("Get");
 context.Request.Returns(request);

 Sut.ControllerContext = new ControllerContext(context, new RouteData(), Sut);

private const string LocalDbMasterConnectionString =
   @"Data Source=(LocalDB)\MSSQLLocalDB;Initial Catalog=master;Integrated Security=True";

private const string TestConnectionString =
   @"Data Source=(LocalDB)\MSSQLLocalDB;Initial Catalog={0};Integrated Security=True;
                 MultipleActiveResultSets=True;AttachDBFilename={1}.mdf";

string DatabaseName {get;set;}
void Main()
{
    this.DatabaseName = "TestCreateDB";
 CreateDB();
}

/// <summary>
/// 建立DB
/// </summary>
void CreateDB() 
{
 //先看看有沒有相同的DB存在，如果有的話卸離並移除
 this.DetachDatabase();

 var fileName = this.CleanupDatabase();

 using (var connection = new SqlConnection(LocalDbMasterConnectionString))
 {
  var commandText = new StringBuilder();
  //Create DB的語法
  commandText.AppendFormat(
   "CREATE DATABASE {0} ON (NAME = N'{0}', FILENAME = '{1}.mdf');",
   this.DatabaseName,
   fileName);

  connection.Open();
  var cmd = connection.CreateCommand();
  cmd.CommandText = commandText.ToString();
  cmd.ExecuteNonQuery();
 }
}

/// <summary>
/// Detaches the database.
/// </summary>
private void DetachDatabase()
{
 using (var connection = new SqlConnection(LocalDbMasterConnectionString))
 {
  connection.Open();
  var cmd = connection.CreateCommand();
  cmd.CommandText = string.Format("exec sp_detach_db '{0}'", this.DatabaseName);
  try
  {
   cmd.ExecuteNonQuery();
  }
  catch
  {
   Console.WriteLine("Could not detach");
  }
 }
}

/// <summary>
/// Cleanups the database.
/// </summary>
/// <returns>System.String.</returns>
private string CleanupDatabase()
{
 var fileName = string.Concat(@"G:\",this.DatabaseName);
 try
 {
  var mdfPath = string.Concat(fileName, ".mdf");
  var ldfPath = string.Concat(fileName, "_log.ldf");

  var mdfExists = File.Exists(mdfPath);
  var ldfExists = File.Exists(ldfPath);

  if (mdfExists) File.Delete(mdfPath);
  if (ldfExists) File.Delete(ldfPath);
 }
 catch
 {
  Console.WriteLine("Could not delete the files (open in Visual Studio?)");
 }
 return fileName;
}

/// <summary>
        /// 使用 EntityFramework 的 Database 類別 Delete 方法，確認 LocalDB 存在後再移除.
        /// </summary>
        public static void DeleteLocalDb(string dbName)
        {
            using (var connection = new SqlConnection(
                                        string.Format(TestConnectionString,dbName, dbName)))
            {
                if (Database.Exists(connection))
                {
                    try
                    {
                        SqlConnection.ClearAllPools();
                        Database.Delete(connection);
                    }
                    catch (Exception)
                    {
                        using (SqlConnection masterConnection = new SqlConnection(LocalDbMasterConnectionString))
                        {
                            SqlCommand cmd = masterConnection.CreateCommand();
                            cmd.CommandText = string.Format(
                                @"ALTER DATABASE [{0}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
                                 DROP DATABASE [{0}];", connection.Database);

                            masterConnection.Open();
                            cmd.ExecuteNonQuery();
                        }
                    }
                }
            }
        }

var DatabaseName = "TestCreateDB";
DeleteLocalDb(DatabaseName);

string Date = "2017/1/20";
Regex reg = new Regex(@"^(?<Year>\d{4})/(?<Month>\d{1,2})/(?<Day>\d{1,2})");
var Match = reg.Match(Date);

Console.WriteLine(string.Concat("年 :", Match.Groups["Year"].Value));
Console.WriteLine(string.Concat("月 :",Match.Groups["Month"].Value));
Console.WriteLine(string.Concat("日 :",Match.Groups["Day"].Value));

string Date = "2017/1/20";
Regex reg = new Regex(@"^(\d{4})/(\d{1,2})/(\d{1,2})");

Console.WriteLine(reg.Replace(Date,@"$1年$2月$3日"));

using (var DbContext = new NorthwindEntities())
{
 //Do Something

}

void Main()
{
 for (int i = 0; i < 10; i++)
 {
  SqlConnection conn = new SqlConnection(this.Connection.ConnectionString);
  conn.Open();
  SqlCommand command = new SqlCommand("select top 1 CustomerID from Customers", conn);
  var Result = command.ExecuteScalar().ToString();
  Result.Dump();
 }
}

void Main()
{

 for (int i = 0; i < 10; i++)
 {
  SqlConnection conn = new SqlConnection(this.Connection.ConnectionString);
  conn.Open();
  SqlCommand command = new SqlCommand("select top 1 CustomerID from Customers", conn);
  var Result = command.ExecuteScalar().ToString();
  Result.Dump();
  conn.Close(); //有呼叫Close
 }
}

void Main()
{
 for (int i = 0; i < 10; i++)
 {
  var context = new TypedDataContext();
  context.Customers.FirstOrDefault().CustomerID.Dump();
 }
}

void Main()
{
 for (int i = 0; i < 10; i++)
 {
    using (var context = new TypedDataContext())
    {
        context.Customers.FirstOrDefault().CustomerID.Dump();
    }
 }
}

public class Parent 
{
 public string Name {get;set;}
}

public class ChildA :Parent
{
 public string ChildACustomProperty {get;set;}
}

public class ChildB : Parent
{
 public string ChildBCustomProperty { get; set; }
}

public class ChildAValidators : AbstractValidator<ChildA>
{
 public ChildAValidators()
 {
  // Name
  this.RuleFor(x => x.Name)
   .NotEmpty()
   .WithErrorCode("400")
   .WithMessage("Name 不能為空值")
   .NotNull()
   .WithErrorCode("400")
   .WithMessage("Name 不能為Null");

  // ChildACustomProperty
  this.RuleFor(x => x.ChildACustomProperty)
   .Length(1,6)
   .WithErrorCode("400")
   .WithMessage("ChildACustomProperty 必須介於1~6個字之間");
 }
}

public class ChildBValidators : AbstractValidator<ChildB>
{
 public ChildBValidators()
 {
  // Name
  this.RuleFor(x => x.Name)
   .NotEmpty()
   .WithErrorCode("400")
   .WithMessage("Name 不能為空值")
   .NotNull()
   .WithErrorCode("400")
   .WithMessage("Name 不能為Null");

  // ChildACustomProperty
  this.RuleFor(x => x.ChildBCustomProperty)
   .Length(1, 12)
   .WithErrorCode("400")
   .WithMessage("ChildBCustomProperty 必須介於1~12個字之間");
 }
}

public class ChildAValidators : ParentValidators<ChildA>
{
 public ChildAValidators()
 {
  // ChildACustomProperty
  this.RuleFor(x => x.ChildACustomProperty)
   .Length(1,6)
   .WithErrorCode("400")
   .WithMessage("ChildACustomProperty 必須介於1~6個字之間");
 }
}

public class ChildBValidators : ParentValidators<ChildB>
{
 public ChildBValidators()
 {
  // ChildACustomProperty
  this.RuleFor(x => x.ChildBCustomProperty)
   .Length(1, 12)
   .WithErrorCode("400")
   .WithMessage("ChildBCustomProperty 必須介於1~12個字之間");
 }
}

public class ParentValidators<T> : AbstractValidator<T>
  where T : Parent
{
 public ParentValidators()
 {
  // Name
  this.RuleFor(x => x.Name)
   .NotEmpty()
   .WithErrorCode("400")
   .WithMessage("Name 不能為空值")
   .NotNull()
   .WithErrorCode("400")
   .WithMessage("Name 不能為Null");
 }
}

void Main()
{
 //要用來排序的欄位
 OrderByColumnEnum OrderByColumn = OrderByColumnEnum.Pin;
 //排序的方法
 OrderByEnum OrderBy = OrderByEnum.ASC;

 //準備資料
 var BuildingList = new List<Building>();
 for (int i = 0; i < 5; i++)
 {
  BuildingList.Add(new Building 
  {
   Age = 1 * (i+1),
   Pin = 1 * (i+1),
   CaseDate = DateTime.Now.AddDays(i +1)
  });
 }

 //排序欄位
 switch (OrderByColumn)
 {
  case OrderByColumnEnum.Pin:
   switch (OrderBy)
   {
    case OrderByEnum.ASC:
     //因為裡面用到的欄位不同,又是強型別,只能寫死...
     BuildingList = BuildingList.OrderBy(x => x.Pin).ToList();
     break;
    case OrderByEnum.DESC:
     BuildingList = BuildingList.OrderByDescending(x => x.Pin).ToList();
     break;
   }
   break;
  case OrderByColumnEnum.Age:
   switch (OrderBy)
   {
    case OrderByEnum.ASC:
     BuildingList = BuildingList.OrderBy(x => x.Age).ToList();
     break;
    case OrderByEnum.DESC:
     BuildingList = BuildingList.OrderByDescending(x =>x.Age).ToList();
     break;
   }
   break;
  case OrderByColumnEnum.CaseDate:
   switch (OrderBy)
   {
    case OrderByEnum.ASC:
     BuildingList = BuildingList.OrderBy(x => x.CaseDate).ToList();
     break;
    case OrderByEnum.DESC:
     BuildingList = BuildingList.OrderByDescending(x => x.CaseDate).ToList();
     break;
   }
   break;
 }
 BuildingList.Dump();
}

public class Building
{
 public int Pin { get; set; }
 public int Age { get; set; }
 public DateTime CaseDate { get; set; }

}

/// <summary>
/// 排序欄位
/// </summary>
public enum OrderByColumnEnum
{
 /// <summary>
 /// 成交日期
 /// </summary>
 CaseDate,
 /// <summary>
 /// 建坪
 /// </summary>
 Pin,
 /// <summary>
 /// 屋齡
 /// </summary>
 Age

}

/// <summary>
/// 排序方法
/// </summary>
public enum OrderByEnum
{
 ASC = 1,
 DESC = 2
}

//要用來排序的欄位
 OrderByColumnEnum OrderByColumn = OrderByColumnEnum.Pin;
 //排序的方法
 OrderByEnum OrderBy = OrderByEnum.ASC;

 //準備資料
 var BuildingList = new List<Building>();
 for (int i = 0; i < 5; i++)
 {
  BuildingList.Add(new Building 
  {
   Age = 1 * (i+1),
   Pin = 1 * (i+1),
   CaseDate = DateTime.Now.AddDays(i +1)
  });
 }

 //排序欄位
 var param = OrderByColumnEnum.Pin.ToString();

 //透過PropertyInfo操作
 var propertyInfo = typeof(Building).GetProperty(param);
 switch (OrderBy)
 {
  case OrderByEnum.ASC:
   BuildingList = BuildingList.OrderBy(x => propertyInfo.GetValue(x, null)).ToList();
   break;
  case OrderByEnum.DESC:
   BuildingList = BuildingList.OrderByDescending(x => propertyInfo.GetValue(x, null)).ToList();
   break;
 }

 BuildingList.Dump();