/// <summary>
/// 学生注册
/// </summary>
/// <param name="coach"></param>
/// <returns></returns>
public static bool Reginster(Sys.Models.Student student)
{
if (!string.IsNullOrWhiteSpace(student.OpenID))
{
var sql = "select * from WxUserInfo where OpenId=@openId";
var wxuserInfo = Comm.Helper.DapperHelper.Instance.QueryFirst <Sys.Models.WxUserInfo>(sql, new
{
openId = student.OpenID
});
student.NickName = wxuserInfo.NickName;
student.HeadUrl = wxuserInfo.HeadImgUrl;
}
System.Data.IDbConnection connection = Comm.Helper.DapperHelper.Instance;
connection.Open();
System.Data.IDbTransaction transaction = connection.BeginTransaction();
try
{
student.State = 1;
int student_id = connection.Insert <Sys.Models.Student>(student, transaction);
var student_venue_result = connection.Insert <Sys.Models.Student_Venue>(new Sys.Models.Student_Venue()
{
AddTime = DateTime.Now,
StudentID = student_id,
VenueID = student.VenueID,
}, transaction);
transaction.Commit();
return(true);
}
catch (Exception ex)
{
logs.Error("学生注册失败", ex);
transaction.Rollback();
return(false);
}
finally
{
connection.Close();
}
}
/// <summary>
/// 学生是否存在
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
public static bool IsExist(Sys.Models.Student student)
{
if (student == null)
{
throw new Comm.YYException.YYException("参数不能为空");
}
if (string.IsNullOrWhiteSpace(student.UserName) || student.VenueID <= 0)
{
throw new Comm.YYException.YYException("参数不能为空");
}
var sql = "select count(studentID) from student where username=@username";
var count = Comm.Helper.DapperHelper.Instance.Query <int>(sql,
new
{
username = student.UserName
});
return(count.FirstOrDefault() > 0);
}
