/// <summary>
/// 删除一条数据，及子表所有相关数据
/// </summary>
public bool Delete(int id)
{
List <string> sqllist = new List <string>();
//删除管理角色权限
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "manager_role_value ");
strSql.Append(" where role_id=@0");
sqllist.Add(strSql.ToString());
//删除管理角色
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "manager_role ");
strSql2.Append(" where id=@0");
sqllist.Add(strSql2.ToString());
int rowsAffected = WriteDataBase.ExecuteSqlTran(sqllist, id);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 执行插件SQL语句
/// </summary>
public bool ExeSqlStr(string dirPath, string xPath)
{
bool result = true;
int count = 0;
List <string> ls = ReadChildNodesValue(dirPath + DTKeys.FILE_PLUGIN_XML_CONFING, xPath);
if (ls != null)
{
using (IDbConnection conn = new DapperView().Context())
{
using (IDbTransaction trans = conn.BeginTransaction())
{
try
{
count += WriteDataBase.ExecuteSqlTran(conn, trans, ls);
trans.Commit();
return(count > 0);
}
catch (Exception ex)
{
trans.Rollback();
return(false);
}
finally
{
conn.Close();
}
}
}
}
return(result);
}
/// <summary>
/// 执行插件SQL语句
/// </summary>
public bool ExeSqlStrs(string dirPath, string xPath)
{
bool result = true;
List <string> ls = ReadChildNodesValue(dirPath + DTKeys.FILE_PLUGIN_XML_CONFING, xPath);
if (ls != null)
{
if (WriteDataBase.ExecuteSqlTran(ls) == 0)
{
result = false;
}
}
return(result);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
List <string> sqllist = new List <string>();
//删除规则内容表
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "weixin_request_content");
strSql2.Append(" where rule_id=@0 ");
sqllist.Add(strSql2.ToString());
//删除规则主表
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "weixin_request_rule");
strSql.Append(" where id=@0");
sqllist.Add(strSql.ToString());
return(WriteDataBase.ExecuteSqlTran(sqllist, id) > 0);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
List <string> sqllist = new List <string>();
//删除微信请求回复内容表
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("delete " + databaseprefix + "weixin_request_content");
strSql1.Append(" where account_id=@0");
sqllist.Add(strSql1.ToString());
//删除微信请求回复规格表
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete " + databaseprefix + "weixin_request_rule");
strSql2.Append(" where account_id=@0");
sqllist.Add(strSql2.ToString());
//删除微信公众平台回复信息表
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("delete from " + databaseprefix + "weixin_response_content");
strSql3.Append(" where account_id=@0");
sqllist.Add(strSql3.ToString());
//删除微信ACCESS TOKEN存储表
StringBuilder strSql4 = new StringBuilder();
strSql4.Append("delete from " + databaseprefix + "weixin_access_token");
strSql4.Append(" where account_id=@0");
sqllist.Add(strSql4.ToString());
//删除微信公众号主表
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "weixin_account");
strSql.Append(" where id=@0");
sqllist.Add(strSql.ToString());
return(WriteDataBase.ExecuteSqlTran(sqllist, id) > 0);
}