public CDataAccessBase[] getObjList(IDataAccessBase obj, int RecordCount)
{
CClassQuery ccq = obj.generateListSql(RecordCount);
if (ccq == null)
{
return(null);
}
Type t = obj.GetType();
DataTable dt = this.ExecQuery(ccq.sql, ccq.parameters);
CDataAccessBase[] ba = null;
if (dt.Rows.Count > 0)
{
ba = new CDataAccessBase[dt.Rows.Count];
}
int i = 0;
foreach (DataRow dr in dt.Rows)
{
CDataAccessBase k = (CDataAccessBase)Activator.CreateInstance(t);
k.InitFromDataRow(dr);
ba[i] = k;
i++;
}
return(ba);
}
/// <summary>
/// 判断对象是否在数据库中存在
/// </summary>
/// <param name="obj">对象</param>
/// <returns></returns>
public bool CheckObj(IDataAccessBase obj)
{
CClassQuery ccq = obj.CheckObj();
if (ccq == null)
{
return(false);
}
return(HasRecord(ccq.sql, ccq.parameters));
}
public CDataAccessBase getObj(IDataAccessBase obj)
{
CClassQuery ccq = obj.CheckObj();
if (ccq == null)
{
return(null);
}
Type t = obj.GetType();
DataTable dt = this.ExecQuery(ccq.sql, ccq.parameters);
CDataAccessBase ba = null;
int i = 0;
foreach (DataRow dr in dt.Rows)
{
CDataAccessBase k = (CDataAccessBase)Activator.CreateInstance(t);
k.InitFromDataRow(dr);
ba = k;
break;
}
return(ba);
}
