/// <summary>
/// 向entity中写入数据，SQL语句形式
/// </summary>
/// <param name="db">entity实例</param>
/// <param name="data">数据对象</param>
/// <returns></returns>
public bool Insert(GeologyDB_EF db, DGObjectDef objectDef, DataTable table)
{
try
{
for (int i = 0; i < table.Rows.Count; i++)
{
string sql = "INSERT INTO " + objectDef.Code;
string column = "s(";
string value = " VALUES(";
foreach (PropertyMeta meta in objectDef.PropertyContainer)
{
string dataCell = table.Rows[i][meta.PropertyName].ToString();
if (dataCell != null)
{
column += meta.PropertyName + ",";
value += "'" + dataCell + "',";
}
}
column = column.TrimEnd(',') + ") ";
value = value.TrimEnd(',') + ") ";
sql += column + value;
db.Boreholes.SqlQuery(sql);
db.Database.ExecuteSqlCommand(sql);
//ExecuteSqlCommand(sql);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message);
return(false);
}
}
public void Data2DB(DataSet dataSet, DataStandardDef standardDef)
{
try
{
string domainName = dataSet.DataSetName;
DomainDef domain = standardDef.DomainContainer.Find(x => x.Code == domainName);
if (domain != null)
{
// get current assembly(程序集)
//Assembly assembly = Assembly.GetExecutingAssembly();
//create Entity for specific domain
//dynamic db = assembly.CreateInstance("iS3_DataManager.DataManager." + domainName + "DB_EF");
GeologyDB_EF db = new GeologyDB_EF();
foreach (DataTable table in dataSet.Tables)
{
DGObjectDef objectDef = domain.DGObjectContainer.Find(x => x.Code == table.TableName);
Insert(db, objectDef, table);
}
}
System.Windows.MessageBox.Show("数据导入成功");
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message);
}
}
/// <summary>
/// 向entity中写入数据,实例形式
/// </summary>
/// <param name="db">entity实例</param>
/// <param name="data">数据对象</param>
/// <returns></returns>
public bool BoreholeInsert(GeologyDB_EF db, DGObjectDef objectDef, DataTable table)
{
for (int i = 3; i < table.Rows.Count; i++)
{
int j = 0;
List <object> data = new List <object>();
foreach (PropertyMeta property in objectDef.PropertyContainer)
{
data.Add(table.Rows[i][j.ToString()]);
}
Borehole borehole = new Borehole {
};
db.Boreholes.Add(borehole);
}
db.SaveChanges();
return(false);
}