/// <summary>
/// 根据Type获取DataTable
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static DataTable SelectData(Type type)
{
if (mySqlclient == null)
{
mySqlclient = MySqlClient.GetMySqlClient();
}
DataAttr dataAttr = (DataAttr)type.GetCustomAttribute(typeof(DataAttr), false);
StringBuilder sb = new StringBuilder();
sb.Append("SELECT ");
PropertyInfo[] propertyInfos = type.GetProperties();
foreach (PropertyInfo info in propertyInfos)
{
DataAttr infoAttr = (DataAttr)info.GetCustomAttribute(typeof(DataAttr), false);
if (infoAttr == null)
{
continue;
}
sb.Append(info.Name + ",");
}
sb.Remove(sb.Length - 1, 1);//移除 多余的 ","
sb.Append(" FROM " + dataAttr.TableName + " WHERE CompanyId= ");
sb.Append(SystemConst.companyId);
DataSet ds = mySqlclient.GetDataSet(sb.ToString(), CommandType.Text);
return(ds.Tables[0]);
}
