public static Dictionary <KeyClass, ValueClass> GetKeyValues(int infoId)
{
int typeId = GetTypeIdOfInfo(infoId);
Dictionary <KeyClass, ValueClass> keyvalues = new Dictionary <KeyClass, ValueClass>();
string parentIds = GetAllParentIds(typeId);
if (parentIds != "")
{
parentIds = typeId.ToString() + "," + parentIds;
}
else
{
parentIds = typeId.ToString();
}
DataTable key = SqlDAL.GetRecords("select * from T_KeyInfo where TypeId in (" + parentIds + ")");
if (key != null && key.Rows.Count > 0)
{
for (int i = 0; i < key.Rows.Count; i++)
{
DataTable value = SqlDAL.GetRecords("select * from T_KeyValue where KeyId=" + key.Rows[i]["ID"].ToString());
ValueClass vc = new ValueClass();
if (value != null && value.Rows.Count > 0)
{
vc = new ValueClass((int)value.Rows[0]["ID"], (int)value.Rows[0]["InfoId"], (int)value.Rows[0]["KeyId"], value.Rows[0]["Value"].ToString());
}
keyvalues.Add(new KeyClass((int)key.Rows[i]["ID"], (int)key.Rows[i]["TypeId"], key.Rows[i]["KeyName"].ToString(), key.Rows[i]["FriendName"].ToString(), key.Rows[i]["Unit"].ToString()), vc);
}
}
return(keyvalues);
}
public static List <ValueClass> GetValues(int infoID)
{
List <ValueClass> values = new List <ValueClass>();
List <KeyClass> keys = GetKeys(GetTypeIdOfInfo(infoID), false);
if (keys != null && keys.Count > 0)
{
foreach (KeyClass key in keys)
{
DataTable dt = OleDAL.GetRecords("select * from T_KeyValue where InfoId=" + infoID + " and KeyId=" + key.Id);
ValueClass vc = new ValueClass();
if (dt != null && dt.Rows.Count > 0)
{
vc = new ValueClass((int)dt.Rows[0]["ID"], (int)dt.Rows[0]["InfoId"], key.Id, dt.Rows[0]["Value"].ToString());
}
values.Add(vc);
}
}
return(values);
}