/// <summary>
/// 根据SPID获取指定属性
/// 作者：苑峰 时间：2009-7-31
/// 修改： 时间：
/// </summary>
public string GetPropertyBySPID(string SPID, string PropertyName, object SPDataObj)
{
string propertyValue = "";
if (SPDataObj == null)
{
return(propertyValue);
}
//string aa = SPDataObj.GetType().ToString() ;
DataTable dt = null;
if (SPDataObj.GetType().Name == "SPData")
{
SPData SPData = (SPData)SPDataObj;
dt = SPData.Tables[SPData.TableName];
}
//else if (SPDataObj.GetType().Name == "SPIPListData")
//{
// SPIPListData SPIPListData = (SPIPListData)SPDataObj;
// dt = SPIPListData.Tables[SPIPListData.TableName];
//}
//else if (SPDataObj.GetType().Name == "SPInterfaceLimitData")
//{
// SPInterfaceLimitData SPInterfaceLimitData = (SPInterfaceLimitData)SPDataObj;
// dt = SPInterfaceLimitData.Tables[SPInterfaceLimitData.TableName];
//}
if (dt.Rows.Count == 0)
{
return(propertyValue);
}
foreach (DataRow row in dt.Rows)
{
if (SPID == Convert.ToString(row[SPData.Field_SPID]))
{
propertyValue = Convert.ToString(row[PropertyName]);
break;
}
}
return(propertyValue);
}
/// <summary>
/// 从数据库获取SP数据集合
/// 作者：苑峰 时间：2009-7-31
/// 修改： 时间：
/// </summary>
private object GetSPData(string SPDataCacheName)
{
object ResultData = null;
DataSet tmpData = new DataSet();
try
{
SqlCommand selCmd = new SqlCommand();
selCmd.CommandType = CommandType.Text;
DataTable dt = new DataTable();
if (SPDataCacheName == "SPData")
{
selCmd.CommandText = SPInfoManager.SqlGetSPInfo;
SPData SPData = new SPData();
dt = SPData.Tables[SPData.TableName];
ResultData = SPData;
}
else if (SPDataCacheName == "SPIPListData")
{
selCmd.CommandText = SPInfoManager.SqlGetSPIPList;
SPIPListData SPIPListData = new SPIPListData();
dt = SPIPListData.Tables[SPIPListData.TableName];
ResultData = SPIPListData;
}
else if (SPDataCacheName == "SPInterfaceLimitData")
{
selCmd.CommandText = SPInfoManager.SqlGetSPInterfaceLimit;
SPInterfaceLimitData SPInterfaceLimitData = new SPInterfaceLimitData();
dt = SPInterfaceLimitData.Tables[SPInterfaceLimitData.TableName];
ResultData = SPInterfaceLimitData;
}
else if (SPDataCacheName == "SPCAData")
{
selCmd.CommandText = SPInfoManager.SqlGetSPCAInfo;
SPCAData SPCAData = new SPCAData();
dt = SPCAData.Tables[SPCAData.TableName];
ResultData = SPCAData;
}
// 获取数据
tmpData = DBUtility.FillData(selCmd, DBUtility.BestToneCenterConStr);
// 数据转换
// DataSet --> Object
int intTargetColumnCount = dt.Columns.Count;
foreach (DataRow row in tmpData.Tables[0].Rows)
{
object[] newRow = new object[intTargetColumnCount];
for (int j = 0; j < intTargetColumnCount; j++)
{
newRow[j] = row[j];
}
dt.Rows.Add(newRow);
}
}
catch (Exception Ex)
{
throw Ex;
}
return(ResultData);
}
