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