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; }