/// <summary> /// 初始化数据 /// </summary> /// <param name="dataAccessName">访问数据库</param> /// <param name="strSQL">获取数据的SQL语句</param> /// <param name="valueMember">绑定的内码值</param> /// <param name="displayMember">绑定的显示值</param> public void InitialData(DataAccessEnum.DataAccessName dataAccessName, string strSQL, string valueMember, string displayMember) { IDataAccess dataAccess = DataAccessFactory.CreateDataAccess(dataAccessName); dataAccess.Open(); DataTable dtData = dataAccess.GetTable(strSQL, null); dataAccess.Close(); InitialData(dtData, valueMember, displayMember); }
public static IDataAccess CreateDataAccess(DataAccessEnum.DataAccessName dataAccessName) { string conStr = string.Empty; switch (dataAccessName) { case DataAccessEnum.DataAccessName.DataAccessName_Manufacture: conStr = ConfigurationManager.ConnectionStrings["Manufacture"].ToString(); //读连接字符串 break; case DataAccessEnum.DataAccessName.DataAccessName_Uniquegrade: conStr = ConfigurationManager.ConnectionStrings["Uniquegrade"].ToString(); //读连接字符串 break; case DataAccessEnum.DataAccessName.DataAccessName_GWT: conStr = ConfigurationManager.ConnectionStrings["GWT"].ToString(); //读连接字符串 break; } return(new MSSQLDAL(conStr)); }