public bool AddJKINFO(MapApp.Entities.JKINFO OBJJKINFO, String MDBFileName) { String SQL = String.Format("INSERT INTO JKINFO (NDH,SBLX)values({0},{1})" , OBJJKINFO.NDH, OBJJKINFO.SBLX); return(MDBHelp.ExcuteSQL(MDBFileName, SQL)); }
static void Main(string[] args) { string mdbFile = @"G:\Projects\Visual Studio Project\Phillip\AccessProject\mdb\Logger.mdb"; //默認路徑 MDBHelp mdbHelp = new MDBHelp(mdbFile); DataTable dt = null; try { mdbHelp.Open(); // 打開數據庫 dt = mdbHelp.GetDataTable("select* from events where datatime > '2005/08/23 08:47:46.734'"); for (int i = 0; i < dt.Rows.Count; i++) { foreach (DataColumn item in dt.Columns) { Console.Write(item.ColumnName + ":" + dt.Rows[i][item].ToString() + "\t"); } Console.WriteLine(); } mdbHelp.Close(); // 關閉數據庫 } finally { mdbHelp = null; } Console.ReadKey(); }
public bool EditJKINFO(MapApp.Entities.JKINFO OBJJKINFO, String MDBFileName) { String SQL = String.Format("UPDATE JKINFO SET NDH={0},SBLX={1} WHERE MAPINFO_ID ={2}" , OBJJKINFO.NDH, OBJJKINFO.SBLX, OBJJKINFO.MAPINFO_ID); return(MDBHelp.ExcuteSQL(MDBFileName, SQL)); }
private void InputData(string gun, String db) { var msg = ""; string mdbFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, db); MDBHelp mdbHelp = new MDBHelp(mdbFile); SQLiteHelper sqlHelper = new SQLiteHelper(); //sqlHelper.Execute("DROP TABLE 'SLR'"); sqlHelper.Execute("CREATE TABLE \"" + gun + "\" ( \"ID\" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, \"dataNo\" TEXT ( 255 ), \"datas\" TEXT ( 255 ), \"descs\" TEXT ( 255 ) );"); try { mdbHelp.Open(); var d = new Dictionary <string, string>(); var ds1 = mdbHelp.GetDataSet("select * from M24狙;"); var ColumnsList = ds1.Tables[0].Columns; foreach (DataRow item in ds1.Tables[0].Rows) { msg = "<ROW "; d = new Dictionary <string, string>(); foreach (DataColumn item1 in ColumnsList) { var ColumnName = item1.ColumnName; d.Add(ColumnName, item[ColumnName].ToString()); } int _id = Convert.ToInt32(d["ID"]); string dataNo = d["弹道编号"]; string datas = d["弹道数据"]; string descs = d["弹道备注"]; msg += string.Format("ID=\"{0}\" 弹道编号=\"{1}\" 弹道数据=\"{2}\" 弹道备注=\"{3}\" ", _id, dataNo, datas, descs); msg += "></ROW>"; // 写入sqlite string sql = string.Format("INSERT INTO \"" + gun + "\" (\"ID\", \"dataNo\", \"datas\", \"descs\") VALUES ({0}, '{1}', '{2}', '{3}');", _id, dataNo, datas, descs); int i = sqlHelper.Execute(sql); //LogHelper.ShowLog("row info: {0}", msg); //LogHelper.ShowLog("inset status: {0}", i); } } catch (Exception e) { LogHelper.ShowLog("open MDB {0}", e.Message); } finally { /** * mdbHelp.Close(); * mdbHelp = null; * sqlHelper.Close(); * sqlHelper = null; **/ } LogHelper.ShowLog("{0} 数据导入完成", gun); }
public bool DeleteJKINFO(Int32 NDH, String MDBFileName) { MapApp.Entities.JKINFO OBJJKINFO = new MapApp.Entities.JKINFO(); String SQL = String.Format("DELETE FROM JKINFO WHERE NDH={0}" , NDH); return(MDBHelp.ExcuteSQL(MDBFileName, SQL)); }
public DataSet GetList(String MDBFileName, String Where) { String SQL = "SELECT * FROM JKINFO "; if (!String.IsNullOrEmpty(Where) && Where != "*") { SQL += " WHERE " + Where; } return(MDBHelp.GetDataSet(MDBFileName, SQL)); }
public DataSet Query(string tableNameSQL, string orderSQL, string conditionSQL) { DataSet ds = new DataSet(); string[] names = tableNameSQL.Split(_separator); string[] orders = null; string[] conditions = null; if (orderSQL != null) { orders = orderSQL.Split(_separator); } if (conditionSQL != null) { conditions = conditionSQL.Split(_separator); } for (int i = 0; i < names.Count(); ++i) { string tableName = TableNamePrex + names[i]; string strCmd = ""; if (conditions != null && i < conditions.Count()) { string cond = conditions[i]; strCmd = getSelectCmd(tableName, cond); } else { strCmd = "SELECT * FROM " + tableName + ""; } if (orders != null && i < orders.Count()) { strCmd += OrderSQL(orders[i]); } DataSet _ds = MDBHelp.Query(strCmd); if (_ds.Tables.Count > 0) { DataTable dt = _ds.Tables[0]; _ds.Tables.RemoveAt(0); dt.TableName = tableName; ds.Tables.Add(dt); } } return(ds); }
public void initializeDataService(string dbFilePath) { MDBHelp.SetConncetionString(dbFilePath); }
// Get record count of a table int getRecordCount(string tableNameSQL) { return(MDBHelp.GetRecordCount(tableNameSQL)); }
public MapApp.Entities.JKINFO GetJKINFO(Int32 NDH, String MDBFileName) { MapApp.Entities.JKINFO OBJJKINFO = new MapApp.Entities.JKINFO(); String SQL = String.Format("SELECT * FROM JKINFO WHERE NDH={0}" , NDH); DataSet ds = MDBHelp.GetDataSet(MDBFileName, SQL); if (ds == null || ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0) { return(null); } else { OBJJKINFO.ADDR = ds.Tables[0].Rows[0]["ADDR"].ToString(); try { OBJJKINFO.BJZ = Convert.ToInt32(ds.Tables[0].Rows[0]["BJZ"].ToString()); } catch { } try { OBJJKINFO.DDZ = Convert.ToInt32(ds.Tables[0].Rows[0]["DDZ"].ToString()); } catch { } try { OBJJKINFO.DKH = Convert.ToInt32(ds.Tables[0].Rows[0]["DKH"].ToString()); } catch { } OBJJKINFO.DW = ds.Tables[0].Rows[0]["DW"].ToString(); try { OBJJKINFO.FZH = Convert.ToInt32(ds.Tables[0].Rows[0]["FZH"].ToString()); } catch { } try { OBJJKINFO.MAPINFO_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["MAPINFO_ID"].ToString()); } catch { } try { OBJJKINFO.NDH = Convert.ToInt32(ds.Tables[0].Rows[0]["NDH"].ToString()); } catch { } try { OBJJKINFO.SBLX = Convert.ToInt32(ds.Tables[0].Rows[0]["SBLX"].ToString()); } catch { } OBJJKINFO.SJ = ds.Tables[0].Rows[0]["SJ"].ToString(); try { OBJJKINFO.ZT = Convert.ToInt32(ds.Tables[0].Rows[0]["ZT"].ToString()); } catch { } return(OBJJKINFO); } }