public static CaseCollection GetList()
{
CaseCollection list = new CaseCollection();
string sql = @"select * from t_case";
MySqlDataReader reader = DbHelper.ExecuteDataReader(sql);
if (reader.HasRows)
{
while(reader.Read())
{
list.Add(FillDataRecord(reader));
}
}
reader.Close();
return list;
}
public static CaseCollection GetCasesByCustomerID(Int64 CustomerID)
{
CaseCollection c = new CaseCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetCasesByCustomerID, new System.Data.SqlClient.SqlParameter("CustomerID", CustomerID));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Case o = new Case();
LoadCaseByReader(row, o);
c.Add(o);
}
}
return(c);
}
protected void SetCaseObjects <TCase, TCollection>(TCollection value)
where TCase : CaseObjectBase
where TCollection : List <TCase>
{
if (value != null)
{
var result = new CaseCollection(value.Count);
foreach (var itemObject in value)
{
var item = new Case();
item.Min = itemObject.Min;
item.Max = itemObject.Max;
item.Item = itemObject.Item;
result.Add(item);
}
Cases = result;
}
else
{
Cases = null;
}
}
