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