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