class bbbb{
/// <summary>
/// 执行SQL,并将RSFDBRecords转换为指定的泛型对象/// </summary>
/// <typeparam name="T">对象类型</typeparam>
/// <param name="strSQLText">SQL文本</param>
/// <returns></returns>
public static T SQLToObjects <T>(string strSQLText) where T : IRSFDBRecordCollection
{
return SQLToObjects<T>(ConstEnvironment.Instance.DBAccess, strSQLText);//转对象
}
public static T SQLToObjects<T>(RSFDBAccess DBA, string strSQLText) where T : IRSFDBRecordCollection
{
string strError = "";
RSFDBRecords rs = DBA.Query(strSQLText, ref strError);
Debug.Assert(string.IsNullOrEmpty(strError));
if (!string.IsNullOrEmpty(strError))
return default(T);
T objs = Activator.CreateInstance<T>();//建一个实例
RSFDBConvert.Records2Objects(rs, objs);//将查询出来的数据转对象
return objs;
}
}
调用
bbbb.SQLToObjects<UserName>("select * from User_Name");//UserName 为类名称
---------------------------------------------
public void Set所有项<T>(List<T> objs) where T : RSFDBObject
{
_所有项 = new List<object>();
for (int n = 0; n < objs.Count; n++)
{
//T obj = Activator.CreateInstance<T>();
_所有项.Add(objs[n]);
}
}