public Int32 UpdateReportPerson(ReportPerson reportPerson)
{
String sql = ORMapping.GetUpdateSql(reportPerson, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return(result);
}
public List <ReportPerson> GetReportPersonList(WhereSqlClauseBuilder builder)
{
String sql = String.Format("SELECT * FROM {0} WHERE {1} ", ReportPersonDBConst.TableName, builder.ToSqlString());
DataTable dt = _DataHelper.GetDataTable(sql);
List <ReportPerson> result = new List <ReportPerson>();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
ReportPerson info = new ReportPerson();
ORMapping.DataRowToObject(dt.Rows[i], info);
result.Add(info);
}
return(result);
}
public Int32 UpdateReportPerson(ReportPerson reportPerson)
{
String sql = ORMapping.GetUpdateSql(reportPerson, BuilderEx.TSqlBuilderInstance);
int result = _DataHelper.ExecuteSql(sql);
return result;
}
public List<ReportPerson> GetReportPersonList(WhereSqlClauseBuilder builder)
{
String sql = String.Format("SELECT * FROM {0} WHERE {1} ", ReportPersonDBConst.TableName, builder.ToSqlString());
DataTable dt = _DataHelper.GetDataTable(sql);
List<ReportPerson> result = new List<ReportPerson>();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
ReportPerson info = new ReportPerson();
ORMapping.DataRowToObject(dt.Rows[i], info);
result.Add(info);
}
return result;
}