public Result Open(string filename, out IDbHandle db, int flags, string zvfs) { var r = raw.sqlite3_open_v2(filename, out var db3, flags, zvfs); db = new DbHandle(db3); return((Result)r); }
/// <summary> /// 批量删除用户登陆实体。 /// </summary> /// <param name="userIds">用户ID集合</param> /// <returns></returns> public bool Delete(params string[] userIds) { StringBuilder sb = new StringBuilder(); sb.Append(" WHERE"); for (int i = 0; i < userIds.Length - 1; i++) { sb.Append(string.Format(" UserId={0} OR", userIds[i])); } sb.Append(string.Format(" UserId=@0", userIds[userIds.Length - 1])); var sql = string.Format("Delete From {0}{1}", "Sys_UserLogOn", sb.ToString()); var conn = DbHandle.CreateConnectionAndOpen(); var tran = conn.BeginTransaction(); try { conn.Execute(sql, transaction: tran); tran.Commit(); return(true); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { conn.CloseIfOpen(); } }
// GET: Vehicle public ActionResult Index() { DbHandle dbhandle = new DbHandle(); ModelState.Clear(); return(View(dbhandle.GetVehicle())); }
public Result Open(string filename, out IDbHandle db) { Sqlite3.sqlite3 internalDbHandle = null; var ret = (Result) Sqlite3.sqlite3_open(filename, ref internalDbHandle); db = new DbHandle(internalDbHandle); return ret; }
public BerkeleyDbError Open([FromUri] ulong handle, [FromUri] String name, [FromUri] String flags) { DbHandle db = GetDb(handle); BerkeleyDbOpenFlags openFlags = BerkeleyEnumParser.OpenFlags(flags); return(db.Methods.Open(db.Handle, name, openFlags)); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { var ret = SQLite3UWP.Open(filename, out Sqlite3DatabaseHandle internalDbHandle, flags, zvfs); db = new DbHandle(internalDbHandle); return(ret); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { IntPtr dbPtr; Result r = SQLiteApiWin32Internal.sqlite3_open_v2(filename, out dbPtr, flags, zvfs); db = new DbHandle(dbPtr); return r; }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { var r = SQLiteApiGenericInternal.sqlite3_open_v2(filename, out IntPtr dbPtr, flags, zvfs); db = new DbHandle(dbPtr); return(r); }
// GET: Vehicle/Owner/5 public ActionResult Owner(int regNumb) { int registrationNumber = Convert.ToInt32(regNumb); DbHandle vdb = new DbHandle(); return(View(vdb.GetVehicleOwner(registrationNumber))); }
public Result Open(string filename, out IDbHandle db) { Sqlite3.sqlite3 internalDbHandle = null; var ret = (Result)Sqlite3.sqlite3_open(filename, ref internalDbHandle); db = new DbHandle(internalDbHandle); return(ret); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zVfs) { var dbFileName = System.Text.Encoding.UTF8.GetString(filename, 0, filename.Length); Sqlite3.sqlite3 internalDbHandle = null; var ret = (Result)Sqlite3.sqlite3_open_v2(dbFileName, ref internalDbHandle, flags, null); db = new DbHandle(internalDbHandle); return ret; }
public BerkeleyDtoResult PageSize([FromUri] ulong handle) { uint pageSize; DbHandle db = GetDb(handle); BerkeleyDbError error = db.Methods.GetPageSize(db.Handle, out pageSize); return(new BerkeleyDtoResult(error, pageSize.ToString())); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { IntPtr dbPtr; Result r = SQLiteApiAndroidInternal.sqlite3_open_v2(filename, out dbPtr, flags, zvfs); db = new DbHandle(dbPtr); return(r); }
public Result Open(string filename, out IDbHandle db) { Sqlite3DatabaseHandle internalDbHandle; var ret = (Result)NativeMethods.Open(filename, out internalDbHandle); db = new DbHandle(internalDbHandle); return(ret); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zVfs) { string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length -1 ); Database internalDbHandle = null; var ret = (Result)Sqlite3.sqlite3_open_v2(dbFileName, out internalDbHandle, flags, ""); db = new DbHandle(internalDbHandle); return ret; }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length); Sqlite3DatabaseHandle internalDbHandle; var ret = (Result)SQLite3.Open(dbFileName, out internalDbHandle, flags, zvfs); db = new DbHandle(internalDbHandle); return(ret); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zVfs) { string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length); Database internalDbHandle = null; var ret = (Result)Sqlite3.sqlite3_open_v2(dbFileName, out internalDbHandle, flags, ""); db = new DbHandle(internalDbHandle); return(ret); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zVfs) { var dbFileName = System.Text.Encoding.UTF8.GetString(filename, 0, filename.Length); Sqlite3.sqlite3 internalDbHandle = null; var ret = (Result)Sqlite3.sqlite3_open_v2(dbFileName, ref internalDbHandle, flags, null); db = new DbHandle(internalDbHandle); return(ret); }
private static DbHandle GetDb(ulong handle) { DbHandle db = DbInstance.GetDb(handle); if (db.Handle == IntPtr.Zero) { throw new HttpResponseException((HttpStatusCode)422); } return(db); }
public BerkeleyDbError Close([FromUri] ulong handle, BerkeleyDbClose flags) { DbHandle db = DbInstance.RemoveDb(handle); if (db.Handle == IntPtr.Zero) { throw new HttpResponseException((HttpStatusCode)422); } return(db.Methods.Close(db.Handle, flags)); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs, byte[] key) { IntPtr dbPtr; Result r = SQLiteApiSqlCipherInternal.sqlite3_open_v2(filename, out dbPtr, flags, zvfs); db = new DbHandle(dbPtr); if (dbPtr != IntPtr.Zero && key != null) // key { SQLiteApiSqlCipherInternal.sqlite3_key(dbPtr, key, key.Length); } return(r); }
public ActionResult Edit(int id, PlayerModel model) { try { DbHandle sdb = new DbHandle(); sdb.UpdatePlayer(model); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Edit(int id, Vehicle vehicle) { try { DbHandle vdb = new DbHandle(); vdb.UpdateVehicle(vehicle); return(RedirectToAction("Index")); } catch (Exception e) { return(View()); } }
//Home public ActionResult Home() { DbHandle dbhandle = new DbHandle(); var vehicles = dbhandle.GetVehicle(); List <int> regNumb = new List <int>(); foreach (var veh in vehicles) { regNumb.Add(veh.RegistrationNumber); } //ViewBag.RegistrationNumber = new SelectList(vehicles, "RegistrationNumber"); ViewBag.RegistrationNumber = regNumb; return(View(vehicles)); }
// 4. ************* DELETE STUDENT DETAILS ****************** // GET: Student/Delete/5 public ActionResult Delete(int id) { try { DbHandle sdb = new DbHandle(); if (sdb.DeletePlayer(id)) { ViewBag.AlertMsg = "Player Deleted Successfully"; } return(RedirectToAction("Index")); } catch { return(View()); } }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { Sqlite3DatabaseHandle internalDbHandle; Result ret; if (_useWinSqlite) { ret = (Result)WinSQLite3.Open(filename, out internalDbHandle, flags, zvfs); } else { ret = (Result)SQLite3.Open(filename, out internalDbHandle, flags, zvfs); } db = new DbHandle(internalDbHandle); return(ret); }
public ActionResult Delete(int id, FormCollection collection) { try { DbHandle vdb = new DbHandle(); if (vdb.DeleteVehicle(id)) { ViewBag.AlertMsg = "Vehicle Deleted Successfully"; } return(RedirectToAction("Index")); } catch { return(View()); } }
public BerkeleyDtoResult OpenCursor([FromUri] ulong handle, [FromUri] String flags) { DbHandle db = GetDb(handle); BerkeleyDbCursorFlags cursorFlags = flags == null ? 0 : BerkeleyEnumParser.CursorFlags(flags); ulong cursorHandle = 0; IntPtr pdbc; BerkeleyDbError error = BDbcMethods.Create(BDbOffsetOfInstance.Instance, db.Handle, db.Methods.DbType, cursorFlags, out pdbc); if (error == 0) { DbcHandle dbc = new DbcHandle(pdbc, BDbcMethods.GetMethods(db.Methods.DbType)); cursorHandle = DbcInstance.AddDbc(dbc); if (cursorHandle == 0) { dbc.Methods.Close(dbc.Handle); throw new HttpResponseException(HttpStatusCode.InternalServerError); } } return(new BerkeleyDtoResult(error, cursorHandle.ToString())); }
public BerkeleyDtoResult Create([FromUri] BerkeleyDbType type, [FromUri] String flags) { ulong handle = 0; BerkeleyDbFlags bdbFlags = BerkeleyEnumParser.Flags(flags); IntPtr pdb; IntPtr penv = DbenvInstance.Instance.Handle; BerkeleyDbError error = BDbMethods.Create(BDbOffsetOfInstance.Instance, penv, type, bdbFlags, out pdb); if (error == 0) { BDbMethods dbMethods = BDbMethods.GetMethods(type); var db = new DbHandle(pdb, dbMethods); handle = DbInstance.AddDb(db); if (handle == 0) { dbMethods.Close(pdb, 0); throw new HttpResponseException(HttpStatusCode.InternalServerError); } } return new BerkeleyDtoResult(error, handle.ToString()); }
public ActionResult Create(Vehicle vehicle) { try { if (ModelState.IsValid) { DbHandle vdb = new DbHandle(); if (vdb.AddVehicle(vehicle)) { ViewBag.Message = "Vehicle Details Added Successfully"; ModelState.Clear(); } } //return View(); return(RedirectToAction("Index")); } catch (Exception e) { return(View()); } }
public BerkeleyDtoResult Create([FromUri] BerkeleyDbType type, [FromUri] String flags) { ulong handle = 0; BerkeleyDbFlags bdbFlags = BerkeleyEnumParser.Flags(flags); IntPtr pdb; IntPtr penv = DbenvInstance.Instance.Handle; BerkeleyDbError error = BDbMethods.Create(BDbOffsetOfInstance.Instance, penv, type, bdbFlags, out pdb); if (error == 0) { BDbMethods dbMethods = BDbMethods.GetMethods(type); var db = new DbHandle(pdb, dbMethods); handle = DbInstance.AddDb(db); if (handle == 0) { dbMethods.Close(pdb, 0); throw new HttpResponseException(HttpStatusCode.InternalServerError); } } return(new BerkeleyDtoResult(error, handle.ToString())); }
private async void MigrationWindows_Loaded(object sender, RoutedEventArgs e) { await DbHandle.ChangeDb(); DialogResult = true; }
public Result Open(string filename, out IDbHandle db) { Sqlite3DatabaseHandle internalDbHandle; var ret = (Result)NativeMethods.Open(filename, out internalDbHandle); db = new DbHandle(internalDbHandle); return ret; }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { Sqlite3DatabaseHandle internalDbHandle; var ret = (Result)SQLite3.Open(filename, out internalDbHandle, flags, zvfs); db = new DbHandle(internalDbHandle); return ret; }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { Sqlite3DatabaseHandle internalDbHandle; Result ret; if (_useWinSqlite) { ret = (Result)WinSQLite3.Open(filename, out internalDbHandle, flags, zvfs); } else { ret = (Result)SQLite3.Open(filename, out internalDbHandle, flags, zvfs); } db = new DbHandle(internalDbHandle); return ret; }
/// <summary> /// 根据时间删除日志。 /// </summary> /// <param name="keepDate">日志保留时间</param> /// <returns></returns> public int Delete(DateTime keepDate) { return(DbHandle.ExecuteNonQuery("delete from Sys_Log where CreateTime<= @CreateTime", new { CreateTime = keepDate.ToString() })); }
// 3. ************* EDIT STUDENT DETAILS ****************** // GET: Student/Edit/5 public ActionResult Edit(int id) { DbHandle sdb = new DbHandle(); return(View(sdb.GetPlayers().Find(smodel => smodel.Id == id))); }
public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs) { string dbFileName = Encoding.UTF8.GetString(filename, 0, filename.Length); Sqlite3DatabaseHandle internalDbHandle; var ret = (Result)SQLite3.Open(dbFileName, out internalDbHandle, flags, zvfs); db = new DbHandle(internalDbHandle); return ret; }
public static JoinData Get_ord_JoinData(string ord_code) { string strsql = @"select * FROM tbl_Joindata where ord_code=@ord_code"; NameValueCollection nvc = new NameValueCollection { { "ord_code", ord_code } }; DataTable dt = DbControl.Data_Get(strsql, nvc); LessonLib.JoinData n = new LessonLib.JoinData(); OrderLib.OrderData o = OrderLib.Get_ordData(ord_code); n.Id = 0; if (dt.Rows.Count > 0) { n.Id = (int)dt.Rows[0]["joinid"]; n.Status = (string)dt.Rows[0]["status"]; n.TicketKind = (string)dt.Rows[0]["TicketKind"]; n.Articleid = (int)dt.Rows[0]["Articleid"]; n.Ord_code = (string)dt.Rows[0]["ord_code"]; n.OrderData = o; n.LessonData = DbHandle.Get_Lesson(n.Articleid.ToString()); strsql = @"select * FROM tbl_joindetail where joinid=@joinid"; nvc.Clear(); dt.Dispose(); nvc = new NameValueCollection { { "joinid", n.Id.ToString() } }; dt = DbControl.Data_Get(strsql, nvc); List <JoinDetail> detail = new List <JoinDetail>(); foreach (DataRow d in dt.Rows) { strsql = @"select * FROM tbl_joinlog where checkcode=@checkcode"; string checkcode = n.Ord_code + "-" + d["joinid"].ToString() + "-" + d["lessonid"].ToString(); nvc.Clear(); nvc = new NameValueCollection { { "checkcode", checkcode } }; DataTable c = DbControl.Data_Get(strsql, nvc); detail.Add(new JoinDetail { JoinId = (int)d["joinid"], Name = (string)d["username"], Phone = (string)d["phone"], Email = (string)d["email"], Amount = (int)d["Amount"], LessonId = (int)d["lessonid"], Secno = (int)d["secno"], Status = d["status"].ToString(), Unitname = d["Unitname"].ToString(), Postion = d["Postion"].ToString(), checkin = c.Rows.Count == 0 ? "":"Y" }); c.Dispose(); } n.JoinDetail = detail; } return(n); }