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