public void TestSQLServer() { DbAccessor dbAccessor = null; //带构造函数不带参数 dbAccessor = (DbAccessor)Assembly.Load("HBG.Data.Common").CreateInstance("HBG.Data.Common.SQLServerDbAccessorAdapter", false); //带构造函数带参数 Type t = Assembly.Load("HBG.Data.Common").GetType("HBG.Data.Common.SQLServerDbAccessorAdapter"); string connString = ConfigurationManager.ConnectionStrings["SqlServer.主数据库"].ToString(); dbAccessor = (SQLServerDbAccessorAdapter)Activator.CreateInstance(t, new object[] { connString, 180 }); //增 string insertCmdText = "insert into T_USER(UserId,UserName,UserPwd) values('3','hbg','123');"; int insertResult = dbAccessor.ExecuteNonQuery(insertCmdText); //删 string delCmdText = "delete from T_USER where UserId='3';"; int delResult = dbAccessor.ExecuteNonQuery(delCmdText); //改 string updateCmdText = "update T_USER set UserPwd='123456' where UserId='2';"; int updateResult = dbAccessor.ExecuteNonQuery(updateCmdText); //查 string selectCmdText = "select * from T_USER;"; DataSet ds = dbAccessor.ExecuteDataSet(selectCmdText); }
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 void DeleteRecursive(string id, DbAccessor dba) { string strSql = "select * from Sec_Menu where ParentId=#ParentId#"; var childrenMenu = dba.QueryEntities<SecMenu>(strSql, new { ParentId = id }); foreach (var item in childrenMenu) { DeleteRecursive(item.MenuId, dba); } dba.ExecuteNonQuery("Security.Menu.Delete", new { MenuId = id }); }
public void DeleteRecursive(string id) { string strSql = "select * from Sec_Organization where ParentId=#ParentId#"; var children = _dba.QueryEntities <SecOrganization>(strSql, new { ParentId = id }); foreach (var item in children) { DeleteRecursive(item.OrganizationId); } _dba.ExecuteNonQuery("Security.Organization.Delete", new { OrganizationId = id }); }
public void DeleteRecursive(string id, DbAccessor dba) { string strSql = "select * from Sec_Menu where ParentId=#ParentId#"; var childrenMenu = dba.QueryEntities <SecMenu>(strSql, new { ParentId = id }); foreach (var item in childrenMenu) { DeleteRecursive(item.MenuId, dba); } dba.ExecuteNonQuery("Security.Menu.Delete", new { MenuId = id }); }