public bool DeleteRelease(int releaseID)
{
bool isSucess = true;
using (var tran = DbContext.DbTransaction)
{
try
{
var releaseQuery = new DapperExQuery <T_RELEASE>().AndWhere(s => s.ID, OperationMethod.Equal, releaseID);
DbContext.Delete <T_RELEASE>(releaseQuery.GetSqlQuery(DbContext));
var releaseSprintsQuery = new DapperExQuery <T_RELEASE_SPRINT>().AndWhere(s => s.R_RELEASE_ID, OperationMethod.Equal, releaseID);
DbContext.Delete <T_RELEASE_SPRINT>(releaseSprintsQuery.GetSqlQuery(DbContext));
}
catch (Exception e)
{
isSucess = false;
throw e;
}
finally
{
if (isSucess)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(isSucess);
}
}
public bool DeleteProject(int projectID)
{
bool isSucess = true;
using (var tran = DbContext.DbTransaction)
{
try
{
var projectQuery = new DapperExQuery <T_PROJECT>().AndWhere(s => s.ID, OperationMethod.Equal, projectID);
DbContext.Delete <T_PROJECT>(projectQuery.GetSqlQuery(DbContext));
var projectMembersQuery = new DapperExQuery <T_PROJECT_MEMBER>().AndWhere(s => s.P_PROJECT_ID, OperationMethod.Equal, projectID);
DbContext.Delete <T_PROJECT_MEMBER>(projectMembersQuery.GetSqlQuery(DbContext));
}
catch (Exception e)
{
isSucess = false;
throw e;
}
finally
{
if (isSucess)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(isSucess);
}
}
/// <summary>
/// 统计指定条件的数据量
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual long GetCount(DapperExQuery <T> query)
{
using (DbBase DbContext = new DbBase(connectionName))
{
return(DbContext.Count <T>(query.GetSqlQuery(DbContext)));
}
}
public bool DeleteTeam(int teamID)
{
bool isSucess = true;
using (var tran = DbContext.DbTransaction)
{
try
{
var teamQuery = new DapperExQuery <T_TEAM>().AndWhere(s => s.ID, OperationMethod.Equal, teamID);
DbContext.Delete <T_TEAM>(teamQuery.GetSqlQuery(DbContext));
var teamMembersQuery = new DapperExQuery <T_TEAM_MEMBER>().AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID);
DbContext.Delete <T_TEAM_MEMBER>(teamMembersQuery.GetSqlQuery(DbContext));
}
catch (Exception e)
{
isSucess = false;
throw e;
}
finally
{
if (isSucess)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(isSucess);
}
}
public bool DeleteSprint(DapperExQuery <T_RELEASE_SPRINT> deleteQuery, T_RELEASE_SPRINT modifySprint)
{
bool isSucess = true;
using (var tran = DbContext.DbTransaction)
{
try
{
bool deleteResult = DbContext.Delete <T_RELEASE_SPRINT>(deleteQuery.GetSqlQuery(DbContext));
if (deleteResult && modifySprint != null)
{
this.Update(modifySprint);
}
}
catch (Exception e)
{
isSucess = false;
throw e;
}
finally
{
if (isSucess)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(isSucess);
}
}
/// <summary>
/// 获得单个实体
/// </summary>
/// <param name="expr">查询对象</param>
/// <param name="operation"></param>
/// <param name="value"></param>
/// <returns></returns>
public virtual T GetEntity(DapperExQuery <T> query)
{
using (DbBase DbContext = new DbBase(connectionName))
{
return(DbContext.SingleOrDefault <T>(query.GetSqlQuery(DbContext)));
}
}
/// <summary>
/// 获得子查询条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public virtual InWhereQuery GetInWhereSql(string selectField, DapperExQuery <T> query)
{
using (DbBase DbContext = new DbBase(connectionName))
{
SqlQuery sql = query.GetSqlQuery(DbContext);
return(query.TranInWhereQuery(selectField, sql));
}
}
/// <summary>
/// 分页_获取指定条件的数据集合（第几页，每页个数）
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="pageIndex">开始位置（默认从1开始）</param>
/// <param name="pageSize">页面显示数量</param>
/// <param name="pageCount">总页数</param>
/// <param name="dataCount">总查询数</param>
/// <returns></returns>
public virtual List <T> GetListByPage(DapperExQuery <T> query, string orderString, int pageIndex, int pageSize, out long dataCount)
{
using (DbBase DbContext = new DbBase(connectionName))
{
//设置Order条件
query.SetOrder(orderString);
return(DbContext.PageData <T>(pageIndex, pageSize, out dataCount, query.GetSqlQuery(DbContext)));
}
}
/// <summary>
/// 获取指定条件的实体集合
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual List <T> GetList(DapperExQuery <T> query, string orderString = "")
{
if (!string.IsNullOrEmpty(orderString))
{
//设置Order条件
query.SetOrder(orderString);
}
return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext)));
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="expr"></param>
/// <param name="operation"></param>
/// <param name="value"></param>
public virtual bool Delete(DapperExQuery <T> query, IDbTransaction transaction = null)
{
bool flag = false;
using (DbBase DbContext = new DbBase(connectionName))
{
flag = DbContext.Delete <T>(query.GetSqlQuery(DbContext), transaction);
DbContext.CloseConnection();
}
return(flag);
}
/// <summary>
/// 获取指定条件的所有数据集合
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual List <T> GetAllList(DapperExQuery <T> query, string orderString = "")
{
using (DbBase DbContext = new DbBase(connectionName))
{
if (!string.IsNullOrEmpty(orderString))
{
//设置Order条件
query.SetOrder(orderString);
}
return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext)));
}
}
public virtual bool IsExist(DapperExQuery <T> query)
{
bool returnBool = false;
using (DbBase DbContext = new DbBase(connectionName))
{
if (DbContext.SingleOrDefault <T>(query.GetSqlQuery(DbContext)) != null)
{
returnBool = true;
}
}
return(returnBool);
}
/// <summary>
/// 获取指定条件的实体集合
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual List <T> GetAllList(string orderString = "")
{
if (!string.IsNullOrEmpty(orderString))
{
DapperExQuery <T> query = new DapperExQuery <T>();
query.SetOrder(orderString);
return(DbContext.QueryData <T>(query.GetSqlQuery(DbContext)));
}
else
{
return(DbContext.QueryData <T>());
}
}
public bool TransformTeam(int teamID, string oldOwnerMail, string newOwnerMail)
{
bool isSucess = true;
using (var tran = DbContext.DbTransaction)
{
try
{
var oldTeamOwnerQuery = new DapperExQuery <T_TEAM_MEMBER>()
.AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID)
.AndWhere(s => s.U_USER_EMAIL, OperationMethod.Equal, oldOwnerMail)
.AndWhere(s => s.R_USER_ROLE_CODE, OperationMethod.Equal, RoleCode.Owner);
var oldTeamOwner = DbContext.SingleOrDefault <T_TEAM_MEMBER>(oldTeamOwnerQuery.GetSqlQuery(DbContext));
var newTeamOwnerQuery = new DapperExQuery <T_TEAM_MEMBER>()
.AndWhere(s => s.T_TEAM_ID, OperationMethod.Equal, teamID)
.AndWhere(s => s.U_USER_EMAIL, OperationMethod.Equal, newOwnerMail);
var newTeamOwner = DbContext.SingleOrDefault <T_TEAM_MEMBER>(newTeamOwnerQuery.GetSqlQuery(DbContext));
if (oldTeamOwner != null && newTeamOwner != null)
{
oldTeamOwner.R_USER_ROLE_CODE = RoleCode.Member;
newTeamOwner.R_USER_ROLE_CODE = RoleCode.Owner;
DbContext.Update(oldTeamOwner);
DbContext.Update(newTeamOwner);
isSucess = true;
}
else
{
isSucess = false;
}
}
catch (Exception e)
{
isSucess = false;
throw e;
}
finally
{
if (isSucess)
{
tran.Commit();
}
else
{
tran.Rollback();
}
}
return(isSucess);
}
}
/// <summary>
/// 分页_获取指定条件的数据集合
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="pageIndex">开始位置（默认从1开始）</param>
/// <param name="pageSize">当前页数</param>
/// <param name="pageCount">总页数</param>
/// <param name="dataCount">总查询数</param>
/// <returns></returns>
public virtual List <T> GetList(DapperExQuery <T> query, string orderString, int pageIndex, int pageSize, out long dataCount)
{
//设置Order条件
query.SetOrder(orderString);
return(DbContext.PageData <T>(pageIndex, pageSize, out dataCount, query.GetSqlQuery(DbContext)));
}
/// <summary>
/// 统计指定条件的数据量
/// </summary>
/// <param name="queryList"></param>
/// <returns></returns>
public virtual long GetCount(DapperExQuery <T> query)
{
return(DbContext.Count <T>(query.GetSqlQuery(DbContext)));
}
/// <summary>
/// 获得子查询条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public virtual InWhereQuery GetInWhereSql(string selectField, DapperExQuery <T> query)
{
SqlQuery sql = query.GetSqlQuery(DbContext);
return(query.TranInWhereQuery(selectField, sql));
}
/// <summary>
/// 分页_获取指定条件的数据集合（开始位置，结束位置）
/// </summary>
/// <param name="query">查询条件</param>
/// <param name="pageIndex">开始位置（默认从1开始）</param>
/// <param name="pageSize">当前页数</param>
/// <param name="pageCount">总页数</param>
/// <param name="dataCount">总查询数</param>
/// <returns></returns>
public virtual List <T> GetListByByRowNumber(DapperExQuery <T> query, string orderString, int startRowNumber, int endRowNumber, out long dataCount)
{
using (DbBase DbContext = new DbBase(connectionName))
{
//设置Order条件
query.SetOrder(orderString);
return(DbContext.PageDataByRowNumber <T>(startRowNumber, endRowNumber, out dataCount, query.GetSqlQuery(DbContext)));
}
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="expr"></param>
/// <param name="operation"></param>
/// <param name="value"></param>
public virtual void Delete(DapperExQuery <T> query)
{
DbContext.Delete <T>(query.GetSqlQuery(DbContext));
}
/// <summary>
/// 获得单个实体
/// </summary>
/// <param name="expr">查询对象</param>
/// <param name="operation"></param>
/// <param name="value"></param>
/// <returns></returns>
public virtual T GetEntity(DapperExQuery <T> query)
{
return(DbContext.SingleOrDefault <T>(query.GetSqlQuery(DbContext)));
}
