private static void ReadNameExcel()
{
string path = EditorUtility.OpenFilePanel("导入建筑数据Excel", "", "xlsx");
filePath = path;
if (string.IsNullOrEmpty(path))
{
return;
}
ExcelAccessor.ReadCatgoryNames(path, ref categoryNames, ref specieNames);
}
/// <summary>
/// Creates an database accessor for the specifyed database type
/// </summary>
/// <param name="dbProvider"></param>
/// <returns></returns>
public static DbAccessor Create(DbProvider dbProvider)
{
DbAccessor accessor;
switch (dbProvider)
{
case DbProvider.MySql:
accessor = new MySqlAccessor();
break;
case DbProvider.SqLite:
accessor = new SqLiteAccessor();
break;
case DbProvider.Postgre:
accessor = new PostgreAccessor();
break;
case DbProvider.MsSql:
accessor = new MsSqlAccessor();
break;
case DbProvider.MsSqlCe:
accessor = new MsSqlCeAccessor();
break;
case DbProvider.Excel:
accessor = new ExcelAccessor();
break;
default:
throw new NdbConnectionFailedException(string.Format("Provider {0} doesn't supported", dbProvider));
}
accessor.provider = dbProvider;
return(accessor);
}
/// <summary>
/// Initializes a new instance of the <see cref="DbExcelExport"/> class.
/// </summary>
/// <param name="source">The source.</param>
/// <param name="target">The target.</param>
public DbExcelExport(ExcelAccessor source, DbGateway target)
{
Source = source;
Target = target;
}
/// <summary>
/// Initializes a new instance of the <see cref="DbExcelExport"/> class.
/// </summary>
/// <param name="sourceConnectionStringName">Name of the source connection string.</param>
/// <param name="targetConnectionStringName">Name of the target connection string.</param>
public DbExcelExport(string sourceConnectionStringName, string targetConnectionStringName)
{
Source = (ExcelAccessor)DbAccessor.Create(sourceConnectionStringName);
Target = new DbGateway(DbAccessor.Create(targetConnectionStringName));
}
private static void SaveNameExcel()
{
ExcelAccessor.SaveBuildingInfos(filePath, entitySaveOptions);
}
public DynamicResponse <bool> AddCountriesAndCities()
{
DynamicResponse <bool> response = new DynamicResponse <bool>();
try
{
ExcelAccessor _ExcelAccessor = new ExcelAccessor();
//List<ExcelCountriesAndCity> data = _ExcelAccessor.GetList();
CountryAccessor _CountryAccessor = new CountryAccessor();
CityAccessor _CityAccessor = new CityAccessor();
LookUpAccessor _LookUpAccessor = new LookUpAccessor();
LookUpMultiLanguageAccessor _LookUpMultiLanguageAccessor = new LookUpMultiLanguageAccessor();
Country country = new Country();
City city = new City();
LookUp lookUp = new LookUp();
LookUpMultiLanguage lookUpMulti = new LookUpMultiLanguage();
//foreach (ExcelCountriesAndCity item in data)
//{
// country = new Country();
// country = _CountryAccessor.Get(item.iso3);
// //add country
// if (country == null)
// {
// country = _CountryAccessor.Add(item.iso3);
// lookUp = new LookUp();
// lookUp = _LookUpAccessor.Add(item.iso3, countryTableId, 1);
// lookUpMulti = new LookUpMultiLanguage();
// lookUpMulti = _LookUpMultiLanguageAccessor.Add(item.country, lookUp.Id, 1, 1);
// }
//add city
// city = new City();
// city = _CityAccessor.Add(item.city_ascii.ToUpper(), country.Id);
// lookUp = new LookUp();
// lookUp = _LookUpAccessor.Add(item.city_ascii.ToUpper(), cityTableId, 1);
// lookUpMulti = new LookUpMultiLanguage();
// lookUpMulti = _LookUpMultiLanguageAccessor.Add(item.city_ascii, lookUp.Id, 1, 1);
//}
response.Data = true;
response.HttpStatusCode = System.Net.HttpStatusCode.OK;
return(response);
}
catch (Exception ex)
{
response.Data = false;
response.HttpStatusCode = System.Net.HttpStatusCode.InternalServerError;
response.ServerMessage = ex.Message;
return(response);
}
}
