private IdName ToIdName(DataRow row)
{
IdName idname= new IdName();
idname.Id = (Guid)row["Id"];
idname.Name = (string)row["Name"];
idname.Category = (string)row["Category"];
return idname;
}
//显示所有
public IdName[] ListAll()
{
DataTable table = SqlHelper.ExecuteDataTable("select * from T_IdName");
IdName[] idname = new IdName[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
idname[i] = ToIdName(table.Rows[i]);
}
return idname;
}
//根据Category获得IdName的数组
public IdName[] GetByCategory(string category)
{
DataTable table = SqlHelper.ExecuteDataTable("select Id,Name from T_IdName where Category=@Category",
new SqlParameter("@Category", category));
IdName[] items = new IdName[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
IdName idname = new IdName();
idname.Id = (Guid)row["Id"];
idname.Name = (string)row["Name"];
items[i] = idname;
}
return items;
}
