public IList<PVFItem> GetPVFByCompanyID(int companyId)
{
IList<PVFItem> result = new List<PVFItem>();
Query query = new Query("PeakValleyFlat");
query.AddCriterion("CompanyID", companyId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
DataTable dt = dataFactory.Query(query);
foreach (DataRow row in dt.Rows)
{
PVFItem item = new PVFItem();
item.ID = int.Parse(row["ID"].ToString());
item.GroupID = int.Parse(row["GroupID"].ToString());
item.CompanyID = int.Parse(row["CompanyID"].ToString());
item.EndTime = row["EndTime"].ToString().Trim();
item.StartTime = row["StartTime"].ToString().Trim();
item.Flag = (bool)row["Flag"];
item.Type = int.Parse(row["Type"].ToString());
result.Add(item);
}
return result;
}
public IList <PVFItem> GetPVFByCompanyID(int companyId)
{
IList <PVFItem> result = new List <PVFItem>();
Query query = new Query("PeakValleyFlat");
query.AddCriterion("CompanyID", companyId, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal);
DataTable dt = dataFactory.Query(query);
foreach (DataRow row in dt.Rows)
{
PVFItem item = new PVFItem();
item.ID = int.Parse(row["ID"].ToString());
item.GroupID = int.Parse(row["GroupID"].ToString());
item.CompanyID = int.Parse(row["CompanyID"].ToString());
item.EndTime = row["EndTime"].ToString().Trim();
item.StartTime = row["StartTime"].ToString().Trim();
item.Flag = (bool)row["Flag"];
item.Type = int.Parse(row["Type"].ToString());
result.Add(item);
}
return(result);
}