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