/// <summary>
/// 保存学员评价
/// </summary>
/// <param name="ar"></param>
/// <returns></returns>
public static bool SaveStudentEvalute_WX(AttendanceRecord ar)
{
bool ret = false;
StringBuilder sb = new StringBuilder();
sb.Append(" update AttendanceRecord set Evaluate=@Evaluate ");
sb.Append(" , UpdateTime=@UpdateTime ");
sb.Append(" , UpdatorId=@UpdatorId ");
sb.Append(" where ClassID=@ClassID ");
sb.Append(" AND ClassIndex=@ClassIndex ");
sb.Append(" AND StudentID=@StudentID ");
var parameters = new DynamicParameters();
parameters.Add("@StudentID", ar.StudentID);
parameters.Add("@Evaluate", ar.Evaluate);
parameters.Add("@ClassID", ar.ClassID);
parameters.Add("@ClassIndex", ar.ClassIndex);
parameters.Add("@UpdateTime", ar.UpdateTime);
parameters.Add("@UpdatorId", ar.UpdatorId);
if (MsSqlMapperHepler.InsertUpdateOrDeleteSql(sb.ToString(), parameters, DBKeys.PRX) > 0)
{
ret = true;
}
return(ret);
}
/// <summary>
/// 根据ID删除上传作业 ClassListJob表
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static int DELETE_ClassListJob(String ID)
{
StringBuilder sb = new StringBuilder();
sb.Append(" delete from ClassListJob ");
sb.Append(" where ID = @ID");
var parameters = new DynamicParameters();
parameters.Add("@ID", ID);
return(MsSqlMapperHepler.InsertUpdateOrDeleteSql(sb.ToString(), parameters, DBKeys.PRX));
}
/// <summary>
/// 删除dictionaryItem表的数据
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int UpdateDictionaryItem(DictionaryItem DIC)
{
StringBuilder sb = new StringBuilder();
sb.Append(" DELETE FROM DictionaryItem ");
sb.Append(" where DicTypeID=8 AND DicItemID=@DicItemID");
var parameters = new DynamicParameters();
parameters.Add("@DicItemID", DIC.DicItemID);
return(MsSqlMapperHepler.InsertUpdateOrDeleteSql(sb.ToString(), parameters, DBKeys.PRX));
}
/// <summary>
/// 修改enroll表的状态
/// </summary>
/// <param name="btn"></param>
/// <returns></returns>
public static int UpdateEnroll_ed(Enroll enl)
{
StringBuilder sb = new StringBuilder();
sb.Append(" update enroll set StateID=@StateID,UpdatorId=@UpdatorId,UpdateTime=@UpdateTime ");
sb.Append(" where ID=@ID ");
var parameters = new DynamicParameters();
parameters.Add("@UpdateTime", enl.UpdateTime);
parameters.Add("@UpdatorId", enl.UpdatorId);
parameters.Add("@StateID", enl.StateID);
parameters.Add("@ID", enl.ID);
return(MsSqlMapperHepler.InsertUpdateOrDeleteSql(sb.ToString(), parameters, DBKeys.PRX));
}
/// <summary>
/// 根据ID修改Classes的删除人和删除时间
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static int DELETE_Classes(string ID, string userID, DateTime Time)
{
StringBuilder sb = new StringBuilder();
sb.Append(" UPDATE Classes SET ");
sb.Append(" DeletorId = @DeletorId ,");
sb.Append(" DeleteTime = @DeleteTime");
sb.Append(" where ID = @ID");
var parameters = new DynamicParameters();
parameters.Add("@DeletorId", userID);
parameters.Add("@DeleteTime", Time);
parameters.Add("@ID", ID);
return(MsSqlMapperHepler.InsertUpdateOrDeleteSql(sb.ToString(), parameters, DBKeys.PRX));
}
public static int UpdateClassList(ClassList cls)
{
StringBuilder sb = new StringBuilder();
sb.Append(" update ClassList set JobTitle=@JobTitle ");
sb.Append(" , JobContent=@JobContent ");
sb.Append(" where ClassID=@ClassID ");
sb.Append(" AND ClassIndex=@ClassIndex ");
var parameters = new DynamicParameters();
parameters.Add("@JobTitle", cls.JobTitle);
parameters.Add("@JobContent", cls.JobContent);
parameters.Add("@ClassID", cls.ClassID);
parameters.Add("@ClassIndex", cls.ClassIndex);
return(MsSqlMapperHepler.InsertUpdateOrDeleteSql(sb.ToString(), parameters, DBKeys.PRX));
}
public static int UpdateClassList(ClassList cls)
{
///INSERT INTO [PRX].[dbo].[ClassList] ([ClassID], [ClassIndex], [ClassDate], [TimePeriod], [StateID], [TeacherID], [RoomID], [CreateTIme], [CreatorId])
///VALUES (N'CL20170001', '1', '2017-06-15 23:24:28.000', N'2', '1', N'2AB45559B74BAA9962A189CD2D21F478', '1', '2017-06-15 23:25:42.000', N'1');
StringBuilder sb = new StringBuilder();
sb.Append(" update ClassList set ClassDate=@ClassDate ");
sb.Append(" , TimePeriod=@TimePeriod ");
sb.Append(" , TeacherID=@TeacherID ");
sb.Append(" , Teacher2ID=@Teacher2ID ");
sb.Append(" , RoomID=@RoomID ");
sb.Append(" where ClassID=@ClassID ");
sb.Append(" AND ClassIndex=@ClassIndex ");
var parameters = new DynamicParameters();
parameters.Add("@ClassDate", cls.ClassDate);
parameters.Add("@ClassID", cls.ClassID);
parameters.Add("@TeacherID", cls.TeacherID);
parameters.Add("@Teacher2ID", cls.Teacher2ID);
parameters.Add("@RoomID", cls.RoomID);
parameters.Add("@ClassIndex", cls.ClassIndex);
parameters.Add("@TimePeriod", cls.TimePeriod);
return(MsSqlMapperHepler.InsertUpdateOrDeleteSql(sb.ToString(), parameters, DBKeys.PRX));
}