/// <summary>
/// 转让课程，乙方没有报过名
/// </summary>
/// <param name="a"></param>
/// <param name="b"></param>
/// <param name="loginid"></param>
/// <returns></returns>
public static bool TransferAudit2(DataProvider.Entities.Enroll a, DataProvider.Entities.Enroll b, string loginid, Transfer rb)
{
bool ret = false;
DBRepository db = new DBRepository(DBKeys.PRX);
db.BeginTransaction();
try
{
DataProvider.Entities.Enroll j = EnrollData.GetEnrollByID(a.ID); //甲方原始报名记录
TransferRecord tr1 = new TransferRecord(); //甲方的转移记录
tr1.StudentID = j.StudentID;
tr1.BeforeHours = j.ClassHour - j.UsedHour;
tr1.AfterHours = a.ClassHour - a.UsedHour;
tr1.TypeID = 1;//转让产生的
tr1.CreateTime = DateTime.Now;
tr1.CreatorId = loginid;
tr1.Remark = "转班：原报名号:" + a.ID + " 原班级号：" + a.ClassID + " 转至班级：" + b.ClassID;
db.Insert(tr1);
db.Update(a);//扣除课时
TransferRecord tr2 = new TransferRecord();//乙方的转移记录
tr2.StudentID = b.StudentID;
tr2.BeforeHours = 0;
tr2.AfterHours = b.ClassHour - b.UsedHour;
tr2.TypeID = 1;//转让产生的
tr2.CreateTime = DateTime.Now;
tr2.CreatorId = loginid;
tr2.Remark = "转班：来自报名号:" + a.ID + " 来自班级号：" + a.ClassID + " 转至班级：" + b.ClassID;
db.Insert(tr2);
db.Insert(b);
rb.StateID = 2;
rb.ApprovedBy = loginid;
rb.ApprovedTime = DateTime.Now;
db.Update(rb);
ret = true;
db.Commit();
}
catch (Exception ex)
{
db.Rollback();
db.Dispose();
throw new Exception(ex.Message);
}
return(ret);
}
/// <summary>
/// 批量新增报名记录
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static int AddList(List <Enroll> list)
{
int ret = 0;//初始
foreach (var obj in list)
{
int haveenroll = EnrollData.getEnrollByStuidCalssid(obj.StudentID, obj.ClassID);
if (haveenroll > 0)
{
ret = -1;//重复报名
return(ret);
}
}
DBRepository db = new DBRepository(DBKeys.PRX);
db.BeginTransaction();
try
{
foreach (var obj in list)
{
obj.ID = CommonData.DPGetTableMaxId("EN", "ID", "Enroll", 8, db);//走同一个事务
db.Insert <Enroll>(obj);
Appointment ap = db.GetById <Appointment>(obj.APID);
ap.ApStateID = 3;//已报名
db.Update <Appointment>(ap);
FundsFlow fl = new FundsFlow(); //资金流水
fl.TypeID = 1; //类型1报名
fl.Amount = obj.Paid;
fl.KeyID = obj.ID;
fl.CreateTime = DateTime.Now;
fl.CreatorId = obj.CreatorId;
db.Insert(fl);
//Classes ca = ClassesData.GetClassesByID(obj.ClassID);
//ca.PresentEnroll = ca.PresentEnroll + 1;
//MsSqlMapperHepler.Update<Classes>(ca, DBKeys.PRX);//报名数加1
}
ret = 1;//成功
db.Commit();
}
catch (Exception ex)
{
db.Rollback();
db.Dispose();
throw new Exception(ex.Message);
}
return(ret);
}