public void Data2DataBase(DataSet dataSet, StandardDef standard)
{
try
{
foreach (DataTable table in dataSet.Tables)
{
DGObjectDef dGObject = standard.GetDGObjectDefByName(table.TableName);
string typeName = "iS3_DataManager.ObjectModels." + dGObject.Code;
Type type = Type.GetType(typeName);
var properties = type.GetProperties();
int count = properties.Length;
foreach (DataRow row in table.Rows)
{
object[] project = new object[35];
int index = 0;
foreach (PropertyMeta meta in dGObject.PropertyContainer)
{
project[index++] = row[meta.LangStr];
}
var instance = Activator.CreateInstance(type, project);
}
}
}
catch (Exception x)
{
throw x;
}
}
public DataSet Import(string path, StandardDef standard)
{
try
{
string domainName = Path.GetFileNameWithoutExtension(path);
DomainDef domain = standard.DomainContainer.Find(x => x.Code == domainName | x.LangStr == domainName);
DataSet ds = new DataSet(domainName);
IWorkbook wb = ReadWorkbook(path);
List <string> sheetNames = GetSheetNames(wb);
//sheetNames equal to objectName
foreach (string sheetName in sheetNames)
{
DGObjectDef objectDef = standard.GetDGObjectDefByName(sheetName);
DataTable dt = ReadSheet(wb.GetSheet(sheetName), objectDef);
if (dt != null)
{
ds.Tables.Add(dt);
}
}
return(ds);
}
catch (Exception)
{
System.Windows.MessageBox.Show("Check if the Standard adapt to data");
return(null);
}
}
public DataSet Import(string path, StandardDef standard)
{
//try
//{
string domainName = Path.GetFileNameWithoutExtension(path);
// StageDef domain = standard.StageContainer.Find(x => x.Code == domainName | x.LangStr == domainName);
DataSet ds = new DataSet()
{
DataSetName = domainName
};
try
{
IWorkbook wb = ReadWorkbook(path);
List <string> sheetNames = GetSheetNames(wb);
//sheetNames equal to objectName
foreach (string sheetName in sheetNames)
{
DGObjectDef objectDef = standard.GetDGObjectDefByName(sheetName);
DataTable dt = ReadSheet(wb.GetSheet(sheetName), objectDef);
if (dt != null)
{
ds.Tables.Add(dt);
}
}
return(ds);
}
catch (Exception ex)
{
return(null);
}
}