/// <summary>
/// 插入教练信息和绑定信息
/// </summary>
/// <param name="coach"></param>
/// <returns></returns>
private static bool ImportCoach(Sys.Models.Coach coach)
{
System.Data.IDbConnection connection = Comm.Helper.DapperHelper.Instance;
connection.Open();
System.Data.IDbTransaction transaction = connection.BeginTransaction();
try
{
int coach_id = connection.Insert <Sys.Models.Coach>(coach, transaction);
var student_venue_result = connection.Insert <Sys.Models.Coach_Venue>(new Sys.Models.Coach_Venue()
{
AddTime = DateTime.Now,
CoachID = coach_id,
VenueID = coach.VenueID,
}, transaction);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
logs.Error("教练添加失败", ex);
transaction.Rollback();
return(false);
}
finally
{
connection.Close();
}
}
/// <summary>
/// 检查教练与教练是否已经绑定
/// </summary>
/// <param name="coach"></param>
/// <returns></returns>
public static bool IsExistInVenue(Sys.Models.Coach coach)
{
var sql = @"select count(cv.CVID) from Coach_Venue as cv join Coach as c on c.CoachID=cv.CoachID
where c.UserName=@userName and cv.VenueID=@venueID";
var count = Comm.Helper.DapperHelper.Instance.Query <int>(sql,
new
{
userName = coach.UserName,
venueID = coach.VenueID
});
return(count.FirstOrDefault() > 0);
}
/// <summary>
/// 为场馆添加一个
/// </summary>
/// <param name="coach">教练信息</param>
/// <returns></returns>
public static bool Create(Sys.Models.Coach coach)
{
//todo 并发暂时不考虑
try
{
bool isExistVenueCode = VenueService.IsExistVenueCode(coach.VenueID.Value);
if (!isExistVenueCode)
{
throw new Comm.YYException.YYException("场馆编码不存在");
}
bool isExistCoach = IsExist(coach);
if (!isExistCoach)
{
return(ImportCoach(coach));
}
else
{
bool isExistStudentVenue = IsExistInVenue(coach);
if (isExistStudentVenue)
{
throw new Comm.YYException.YYException(coach.FullName + "教练已经绑定");
}
var coach_info = FindCoachByUserName(coach.UserName);
var coach_venue_result = Comm.Helper.DapperHelper.Instance.Insert(new Sys.Models.Coach_Venue()
{
AddTime = DateTime.Now,
CoachID = coach_info.CoachID,
VenueID = coach.VenueID,
});
return(coach_venue_result > 0);
}
}
catch (Comm.YYException.YYException)
{
throw;
}
catch (Exception ex)
{
logs.Error("教练添加失败", ex);
return(false);
}
}
/// <summary>
/// 教练是否存在
/// </summary>
/// <param name="coach"></param>
/// <returns></returns>
public static bool IsExist(Sys.Models.Coach coach)
{
if (coach == null)
{
throw new Comm.YYException.YYException("参数不能为空");
}
if (string.IsNullOrWhiteSpace(coach.UserName) || coach.VenueID <= 0)
{
throw new Comm.YYException.YYException("参数不能为空");
}
var sql = "select count([CoachID]) from [Coach] where [UserName]=@userName";
var count = Comm.Helper.DapperHelper.Instance.Query <int>(sql,
new
{
username = coach.UserName
});
return(count.FirstOrDefault() > 0);
}
/// <summary>
/// 教练注册
/// </summary>
/// <param name="coach"></param>
/// <returns></returns>
public static bool Reginster(Sys.Models.Coach coach)
{
try
{
if (!string.IsNullOrWhiteSpace(coach.OpenID))
{
var sql = "select * from WxUserInfo where OpenId=@openId";
var wxuserInfo = Comm.Helper.DapperHelper.Instance.QueryFirst <Sys.Models.WxUserInfo>(sql, new
{
openId = coach.OpenID
});
coach.NickName = wxuserInfo.NickName;
coach.HeadUrl = wxuserInfo.HeadImgUrl;
}
int coach_id = Comm.Helper.DapperHelper.Instance.Insert <Sys.Models.Coach>(coach);
var student_venue_result = Comm.Helper.DapperHelper.Instance.Insert <Sys.Models.Coach_Venue>(new Sys.Models.Coach_Venue()
{
AddTime = DateTime.Now,
CoachID = coach_id,
VenueID = coach.VenueID,
WageMore = 0,
PriceMore = 0,
Price = 0,
Wage = 0
});
return(true);
}
catch (Exception ex)
{
logs.Error("教练注册失败", ex);
return(false);
}
}
