public JsonResult Delete(string id) { MyJsonResult mjr = new MyJsonResult(); using (DbAccessor dba = DbAccessor.Create()) { try { dba.BeginTran(); _menuService.DeleteRecursive(id, dba); dba.CommitTran(); mjr.Success = true; } catch (Exception ex) { dba.RollbackTran(); mjr.Success = false; mjr.Message = ex.Message; } } return(Json(mjr)); }
public void BeginTran() { using (DbAccessor dba = DbAccessor.Create()) { dba.BeginTran(); dba.ExecuteNonQuery("update sys_product set ProductName='abc' where ProductId=#ProductId#", new { ProductId = 1 }); dba.RollbackTran(); } }
public JsonResult Save(SecUser model) { MyJsonResult mjr = new MyJsonResult(); using (var dba = DbAccessor.Create()) { try { dba.BeginTran(); model.ModifiedById = SecurityContext.Current.User.UserId; model.ModifiedDate = DateTime.Now; if (model.UserId == null) { #region 校验数据 dynamic count = _dba.ExecuteScalar <dynamic>("SecuritySettings.User.CountByLoginName", new { LoginName = model.LoginName, Status = (int)StatusType.Enabled }); if (count > 0) { mjr.Success = false; mjr.Message = "登录名已存在!"; goto End; } #endregion model.UserId = Guid.NewGuid().ToString(); model.Status = (int)StatusType.Enabled; model.CreatedById = SecurityContext.Current.User.UserId; model.CreatedDate = DateTime.Now; dba.Insert <SecUser>(model); } else { dba.UpdateFields(model, "LoginName", "Password", "Name", "Sex", "Birthday", "MobilePhone", "OrganizationId", "ModifiedById", "ModifiedDate"); } dba.CommitTran(); mjr.Success = true; mjr.Message = "保存成功!"; } catch (Exception ex) { dba.RollbackTran(); mjr.Success = false; mjr.Message = ex.Message; } } End: return(Json(mjr)); }
public void Trace() { DbAccessor dba = DbAccessor.Create(); dba.PreCommandExecute += new TraceHandler().PrintSqlByConsole; var dt = _dba.QueryDataTable("select top 10 * from sys_product"); Console.WriteLine(DataTableUtil.ToString(dt)); }
public void SetConnectionString(string connectionString) { Accessor = DbAccessor.Create(Provider, connectionString); StructureGateway = new DbStructureGateway(Accessor); if (!Accessor.CanConnect) { throw new NdbException(string.Format( "Can't connect to \"{0}\" using {1} provider", connectionString, Provider)); } }
public JsonResult Save(SecOrganization model) { MyJsonResult mjr = new MyJsonResult(); using (var dba = DbAccessor.Create()) { try { dba.BeginTran(); model.ModifiedById = SecurityContext.Current.User.UserId; model.ModifiedDate = DateTime.Now; if (model.OrganizationId == null) { model.OrganizationId = Guid.NewGuid().ToString(); model.Status = (int)StatusType.Enabled; model.CreatedById = SecurityContext.Current.User.UserId; model.CreatedDate = DateTime.Now; dba.ExecuteNonQuery("Security.Organization.Insert", model); } else { dba.UpdateFields(model, "Name", "Code", "MobilePhone", "ModifiedById", "ModifiedDate"); } dba.CommitTran(); mjr.Success = true; mjr.Message = "保存成功!"; } catch (Exception ex) { dba.RollbackTran(); mjr.Success = false; mjr.Message = ex.Message; } } return(Json(mjr)); }
public void ImportFromExcel(string [] args) { if (args.Length > 4) { string SourceFileConnectionString = args[3]; string assemblyName = args[4]; var assembly = Assembly.LoadFrom(assemblyName); Type[] types = DbAttributesManager.LoadDbRecordTypes(assembly); var Source = (ExcelAccessor)DbAccessor.Create(DbProvider.Excel, SourceFileConnectionString); Accessor.ShareConnection = true; var Target = new DbGateway(Accessor); DbExcelExport export = new DbExcelExport(Source, Target); export.Export(types, true); ExitCode = ExitCode.Success; } else { ExitCode = ExitCode.Exception; } }
/// <summary> /// Initializes a new instance of the <see cref="DbExcelExport"/> class. /// </summary> /// <param name="sourceConnectionStringName">Name of the source connection string.</param> /// <param name="targetConnectionStringName">Name of the target connection string.</param> public DbExcelExport(string sourceConnectionStringName, string targetConnectionStringName) { Source = (ExcelAccessor)DbAccessor.Create(sourceConnectionStringName); Target = new DbGateway(DbAccessor.Create(targetConnectionStringName)); }
public MsSqlCeDbStructureGatewayTests() : base(DbAccessor.Create("MsSqlCe")) { }
public PostgreDbGatewayTests() : base(DbAccessor.Create("Postgre")) { }
public SqLiteDbGatewayTests() : base(DbAccessor.Create("SqLite")) { }
public MsSqlDbGatewayTests() : base(DbAccessor.Create("MsSql")) { }