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