關於Dapper的使用筆記2

標籤：des   io   ar   使用   sp   on   資料   bs   cti   

 

public class t_SoDtl
{
[System.ComponentModel.Description("KeySeq")]
public Guid ID { get; set; } //資料庫中的列名KeySeq

[System.ComponentModel.Description("SoKeySeq")]
public Guid SoKeySeq { get; set; }

[System.ComponentModel.Description("ItemId")]
public string ItemNo { get; set; }

[System.ComponentModel.Description("ItemName")]
public string ItemName { get; set; }

[System.ComponentModel.Description("Price")]
public decimal Price { get; set; }

[System.ComponentModel.Description("Qty")]
public decimal Quality { get; set; }//資料庫中的列名Qty

[System.ComponentModel.Description("Amount")]
public decimal Amount { get; set; }
}

SqlMapper.ITypeMap ---> CustomPropertyTypeMap

//建立自訂映射
var map = new CustomPropertyTypeMap(typeof(t_SoDtl),
(type, columnName) => type.GetProperties()
.Where(prop => prop.GetCustomAttributes(false).OfType<DescriptionAttribute>().Any(attr => attr.Description == columnName)) //找出Decsription = Column的屬性
.FirstOrDefault());

Dapper.SqlMapper.SetTypeMap(typeof(t_SoDtl), map);

//查詢
DbConnection con = this.GetConnection();
return con.Query<t_SoDtl>("select * from dbo.t_SoDtl where SoKeySeq = @SoKeySeq", new {SoKeySeq = soKeySeq}).ToList();

//插入 (注意參數的名稱與實體屬性的對應)
string strSQL = @"
INSERT INTO dbo.t_so(KeySeq,SoNo,SoDate,CustomerName,Remark)
VALUES(@KeySeq,@SoNo,@SoDate,@CustomerName,@Remark)";
DbConnection con = this.GetConnection();
//con.Execute(strSQL, new {KeySeq = so.KeySeq, SoNo = so.SoNo, SoDate = so.SoDate, CustomerName = so.CustomerName, Remark = so.Remark});
con.Execute(strSQL, so);

關於Dapper的使用筆記2