/// <summary>/// 給model類自動賦值/// </summary>/// <param name="sqlstring">獲取查詢一個model實例的sql語句</param>/// <param name="obj">model實例對象</param>/// <returns></returns>public object selmodel(string sqlstring,object obj){  DataTable dtsell = lcommonbll.GetTable(sqlstring);  int count = dtsell.Rows.Count;  if (count == 0)  {   return null;  }  else  {   DataRow dr = dtsell.Rows[0];   #region 另一種方法   //foreach (DataColumn col in dr.Table.Columns)   //{   // PropertyInfo pt = seller.GetType().GetProperty(col.ColumnName);   // if (String.IsNullOrEmpty(dr[col.ColumnName].ToString()))   // {   //  break;   // }   // else   // {   //  pt.SetValue(seller, dtsell.Rows[0][0], null);   // }   //}   #endregion   foreach (System.Reflection.PropertyInfo pi in obj.GetType().GetProperties())   {    if (pi.CanWrite)    {     try     {      if (dtsell.Rows[0][pi.Name]!=null)      {       pi.SetValue(obj, dtsell.Rows[0][pi.Name], null);      }      else      {       pi.SetValue(obj, null, null);      }     }     catch     {      pi.SetValue(obj, null, null);     }    }   }   return obj;  }}

Seller seller = new Seller();//實體類bind BIND = new bind();//綁定方法類seller = (Seller)BIND.selmodel("select * from seller where SID=2", seller);//賦值