示例#1
0
 /// <summary>
 ///     修改试题库
 /// </summary>
 /// <param name="SortID"></param>
 /// <param name="qSort"></param>
 /// <returns></returns>
 public int ModifyByID(int SortID, tbQuestionSort qSort)
 {
     try
     {
         MongoCollection <tbQuestionSort> coll =
             BaseDB.CreateInstance().GetCollection <tbQuestionSort>("tbQuestionSort");
         var update = new UpdateDocument
         {
             { "FatherID", qSort.FatherID },
             { "Title", qSort.Title },
             { "Description", qSort.Description },
             { "Status", qSort.Status }
         };
         coll.Update(Query.EQ("_id", SortID), update);
         return(SortID);
     }
     catch
     {
         return(0);
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#2
0
 /// <summary>
 ///     根据ID修改分类
 /// </summary>
 /// <returns></returns>
 public int ModifyByID(int id, tbExampaperSort sort)
 {
     try
     {
         MongoCollection <tbExampaperSort> coll =
             BaseDB.CreateInstance().GetCollection <tbExampaperSort>("tbExampaperSort");
         var b = new UpdateDocument
         {
             { "Description", sort.Description },
             { "Title", sort.Title },
             { "FatherID", sort.FatherID },
             { "Status", sort.Status }
         };
         coll.Update(Query.EQ("_id", id), b);
         return(id);
     }
     catch
     {
         return(0);
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#3
0
 /// <summary>
 ///     获取所有的试题
 /// </summary>
 /// <returns></returns>
 public List <tbQuestion> GetQuestionList()
 {
     try
     {
         MongoCollection <tbQuestion> coll = BaseDB.CreateInstance().GetCollection <tbQuestion>("tbQuestion");
         return(coll.Find(Query.EQ("Status", 0)).ToList());
     }
     catch
     {
         return(new List <tbQuestion>());
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#4
0
 /// <summary>
 ///     根据ID获取单个实体
 /// </summary>
 /// <returns></returns>
 public tbExampaper GetExampaper(int id)
 {
     try
     {
         MongoCollection <tbExampaper> coll = BaseDB.CreateInstance().GetCollection <tbExampaper>("tbExampaper");
         return(coll.FindOne(Query.EQ("_id", id)));
     }
     catch
     {
         return(new tbExampaper());
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#5
0
 /// <summary>
 ///     获取已删除的试卷列表
 /// </summary>
 /// <returns></returns>
 public List <tbExampaper> GetAllDeleteExampaperList()
 {
     try
     {
         MongoCollection <tbExampaper> coll = BaseDB.CreateInstance().GetCollection <tbExampaper>("tbExampaper");
         return(coll.Find(Query.EQ("Status", 1)).ToList());
     }
     catch
     {
         return(new List <tbExampaper>());
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#6
0
        /// <summary>
        /// 根据课程ID和学员ID 获取一条数据
        /// </summary>
        /// <param name="relationId"></param>
        /// <param name="UserId"></param>
        /// <returns></returns>
        public tbExamSendStudent GetExamSendStudentBySQL2008(int relationId, int UserId, int CoursePaperId, int ExamPaperID, int SourceType)
        {
            try
            {
                MongoCollection <tbExamSendStudent> coll = BaseDB.CreateInstance().GetCollection <tbExamSendStudent>("tbExamSendStudent");

                return(coll.FindOne(Query.And(new[] { Query.EQ("RelationID", relationId), Query.EQ("SourceType", SourceType), Query.EQ("UserID", UserId), Query.EQ("CoursePaperId", CoursePaperId), Query.EQ("ExamPaperID", ExamPaperID) })));
            }
            catch
            {
                return(new tbExamSendStudent());
            }
            finally
            {
                BaseDB.MongoService.Disconnect();
            }
        }
示例#7
0
 /// <summary>
 ///     根据ID修改单个实体
 /// </summary>
 /// <returns></returns>
 public bool UpdateExampaper(tbExampaper tbE)
 {
     try
     {
         MongoCollection <tbExampaper> coll = BaseDB.CreateInstance().GetCollection <tbExampaper>("tbExampaper");
         tbExampaper exam = coll.FindOne(Query.EQ("_id", tbE._id));
         tbE.UserID = exam.UserID;
         coll.Remove(Query.EQ("_id", tbE._id));
         coll.Insert(tbE);
         return(true);
     }
     catch
     {
         return(false);
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#8
0
        public int UpdateTestTimes(int tbexamsendstudentid, int TestTimes)
        {
            try
            {
                MongoCollection <tbExamSendStudent> coll =
                    BaseDB.CreateInstance().GetCollection <tbExamSendStudent>("tbExamSendStudent");
                //var update = new UpdateDocument
                //    {
                //        {"Number", number}
                //    };
                //coll.Update(Query.EQ("_id", tbexamsendstudentid), update,UpdateFlags.Multi);,

                //修改单条数据
                coll.Update(Query.EQ("_id", tbexamsendstudentid), Update.Set("PaperScore", 0));
                coll.Update(Query.EQ("_id", tbexamsendstudentid), Update.Set("TestTimes", TestTimes));
                coll.Update(Query.EQ("_id", tbexamsendstudentid), Update.Set("StudentAnswerList", ""));

                //var update = new UpdateDocument
                //      {
                //          {"PaperScore",  0},
                //          {"TestTimes", TestTimes},
                //          {"Number",0}

                //      };
                //coll.Update(Query.EQ("_id", tbexamsendstudentid), update);

                return(tbexamsendstudentid);
            }
            catch
            {
                return(0);
            }
            finally
            {
                BaseDB.MongoService.Disconnect();
            }
        }
示例#9
0
 /// <summary>
 /// 修改课程是否获得学时 0:没有获得  1:获得  获得后后面的考试就不在获得学时 标志位
 /// </summary>
 /// <param name="tbexamsendstudentid">id</param>
 /// <param name="number">0:1</param>
 /// <returns></returns>
 public int UpdateNumber(int tbexamsendstudentid, int number)
 {
     try
     {
         MongoCollection <tbExamSendStudent> coll =
             BaseDB.CreateInstance().GetCollection <tbExamSendStudent>("tbExamSendStudent");
         //var update = new UpdateDocument
         //    {
         //        {"Number", number}
         //    };
         //coll.Update(Query.EQ("_id", tbexamsendstudentid), update,UpdateFlags.Multi);
         //修改单条数据
         coll.Update(Query.EQ("_id", tbexamsendstudentid), Update.Set("Number", number));
         return(tbexamsendstudentid);
     }
     catch
     {
         return(0);
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#10
0
 /// <summary>
 ///     根据ID删除单个实体
 /// </summary>
 /// <returns></returns>
 public bool DeleteExampaper(int id, bool isTrueDelete)
 {
     try
     {
         MongoCollection <tbExampaper> coll = BaseDB.CreateInstance().GetCollection <tbExampaper>("tbExampaper");
         if (isTrueDelete)
         {
             coll.Remove(Query.EQ("_id", id));
         }
         else
         {
             coll.Update(Query.EQ("_id", id), Update.Set("Status", "1"));
         }
         return(true);
     }
     catch
     {
         return(false);
     }
     finally
     {
         BaseDB.MongoService.Disconnect();
     }
 }
示例#11
0
        /// <summary>
        ///     根据ID批量删除单个实体
        /// </summary>
        /// <returns></returns>
        public bool DeleteExampapers(string idlist)
        {
            try
            {
                MongoCollection <tbExampaper> coll = BaseDB.CreateInstance().GetCollection <tbExampaper>("tbExampaper");
                //BsonArray b = new BsonArray();
                string[] ids = idlist.Split(',');
                for (int i = 0; i < ids.Length - 1; i++)
                {
                    //b.Add(ids[i].StringToInt32());
                    coll.Update(Query.EQ("_id", Convert.ToInt32(ids[i])), Update.Set("Status", 1));
                }

                return(true);
            }
            catch
            {
                return(false);
            }
            finally
            {
                BaseDB.MongoService.Disconnect();
            }
        }