/// <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)); }