public override List<PropagationModelCategory> ParameterInit(string category, Type modelType) { PropagationModelCategory item; List<PropagationModelCategory> list = new List<PropagationModelCategory>(); string commandText = "select * from PropModelKeenanMotley"; using (AccessHelper helper = new AccessHelper()) { helper.OpenConnection(); using (OleDbDataReader dataReader = helper.ExecuteReader(commandText, null)) { item = base.ParameterInitForCategory(dataReader, modelType); } } item.CategoryName = category; list.Add(item); return list; }
private void InitTable() { try { string strCommandText1 = "select name from MSysObjects where type=1 and flags=0"; accessHelper = new AccessHelper("Interference.mdb"); accessHelper.OpenConnection(); m_Table = accessHelper.ExecuteDataset(strCommandText1, null); } finally { accessHelper.CloseConnection(); } }
/// <summary> /// 从数据库读取速度信道字典 /// </summary> public void GetChannelTypeInfo() { lock (m_Object) { string strCommondText = "select * from ChannelType"; //AccessHelper.DefineUserConnectionString("BUPT data.mdb");//定义北邮读的数据库 //DataTable tempDataTable = AccessHelper.ExecuteDataset(strCommondText,AccessType.UserDefine, null); //华为要求所做的修改 AccessHelper accessHelper = new AccessHelper("BUPT data.mdb"); accessHelper.OpenConnection(); DataTable tempDataTable = accessHelper.ExecuteDataset(strCommondText, null); accessHelper.CloseConnection(); InitialSpeedChannelDic(tempDataTable); } }
public override List<PropagationModelCategory> ParameterInit(string category, Type modelType) { PropagationModelCategory item; if (modelType != typeof(SpacePropagationModel)) { throw new Exception("The PropagationModelBase as SpacePropagationModel is null."); } List<PropagationModelCategory> list = new List<PropagationModelCategory>(); string commandText = "select * from PropModelParaSpace"; using (AccessHelper helper = new AccessHelper()) { helper.OpenConnection(); using (OleDbDataReader dataReader = helper.ExecuteReader(commandText, null)) { item = base.ParameterInitForCategory(dataReader, modelType); } } item.CategoryName = category; list.Add(item); return list; }
private void Init() { try { AccessHelper accessHelper = new AccessHelper("Interference.mdb"); accessHelper.OpenConnection(); foreach (DataRow row in m_Table.Rows) { string name = row[0].ToString(); string strCommandText = "SELECT * FROM " + name; DataTable tempDataTable = accessHelper.ExecuteDataset(strCommandText, null); m_TableDIC.Add(name, tempDataTable); } } finally { accessHelper.CloseConnection(); } }
private void GetDataFromNetType() { using (AccessHelper helper = new AccessHelper()) { helper.OpenConnection(); foreach (NetWorkType type in Enum.GetValues(typeof(NetWorkType))) { if ((type & this.m_NetType) == type) { this.NetTypeReceiveCIDic.Add(type, this.dataBaseDic[type](helper)); } } } }