public static bool SaveOrUpdateCollectionAnswer(CollectionQuestionAndAnswer cqa) { bool result = false; try { using (MainDataContext db = new MainDataContext()) { CollectionQuestionAndAnswer info = db.CollectionQuestionAndAnswers.FirstOrDefault(p => p.AnswerID == cqa.AnswerID); if (info == null) { db.CollectionQuestionAndAnswers.InsertOnSubmit(cqa); } else { info = cqa; info.ModefiedTime = DateTime.Now.ToString(); } db.SubmitChanges(); result = true; } } catch (Exception ex) { } return result; }
public static bool SaveOrUpdateQuestionCount(int QuestionCount) { using (MainDataContext db = new MainDataContext()) { SysDict dict = db.SysDicts.FirstOrDefault(p => p.DictName == "QuestionPageCount"); if (dict == null) { dict = new SysDict() { DictName = "QuestionPageCount", DictValue = QuestionCount.ToString(), DictCode = "QuestionPageCount", Remark = "QuestionPageCount", ModefyDate = DateTime.Now.ToString() }; db.SysDicts.InsertOnSubmit(dict); db.SubmitChanges(); } else { dict.DictValue = QuestionCount.ToString(); dict.ModefyDate = DateTime.Now.ToString(); db.SubmitChanges(); } } return true; }
public static bool SaveOrUpdateCollectionInfo(CollectionInfo ci) { bool result = false; try { using (MainDataContext db = new MainDataContext()) { CollectionInfo info = db.CollectionInfos.FirstOrDefault(p => p.CollectionID == ci.CollectionID); if (info == null) { db.CollectionInfos.InsertOnSubmit(ci); } else { info.QuestionCount = ci.QuestionCount; info.CollectionName = ci.CollectionName; info.CollectionUrl = ci.CollectionUrl; info.CreatorHash = ci.CreatorHash; info.CreatorName = ci.CreatorName; info.ModefiedTime = DateTime.Now.ToString(); } db.SubmitChanges(); result = true; } } catch (Exception ex) { } return result; }
public static int GetQuestionPageCount() { using (MainDataContext db = new MainDataContext()) { SysDict dict = db.SysDicts.FirstOrDefault(p => p.DictName == "QuestionPageCount"); return dict == null ? 0 : int.Parse(dict.DictValue) - db.QuestionInfos.Count()/20-2; } }
public static IEnumerable<CollectionInfo> GetAllCollectionInfos() { using (MainDataContext db = new MainDataContext()) { var res = db.CollectionInfos.Select(p => p).ToList(); return res; } }
public static CollectionInfo GetCollectionInfoById(string CollectionId) { using (MainDataContext db = new MainDataContext()) { var res = db.CollectionInfos.FirstOrDefault(p => p.CollectionID.ToString() == CollectionId); db.Dispose(); return res; } }
public static int GetAnswerCountByCollectionId(string CollectionId) { using (MainDataContext db = new MainDataContext()) { var res= db.CollectionQuestionAndAnswers.Count(p => p.CollectionID.ToString() == CollectionId); db.Dispose(); return res; } }
public static int GetDownLoadPageCount() { int count = 0; using (MainDataContext db = new MainDataContext()) { SysDict dict = db.SysDicts.FirstOrDefault(p => p.DictName == "DownLoadPageCount"); count = dict == null ? 0 : int.Parse(dict.DictValue); } return count; }
public static QuestionInfo FindQuestionInfoById(int questionId) { QuestionInfo qi = null; try { using (MainDataContext db = new MainDataContext()) { qi = db.QuestionInfos.FirstOrDefault(p => p.QuestionID == questionId); } } catch (Exception ex) { } return qi; }
public static bool DeleteQuestionInfoList(IEnumerable<QuestionInfo> InfoList) { bool result = false; try { if (InfoList != null) { using (MainDataContext db = new MainDataContext()) { db.QuestionInfos.DeleteAllOnSubmit(InfoList); db.SubmitChanges(); result = true; } } } catch (Exception ex) { } return result; }
public static bool DeleteQuestionInfoById(int questionId) { bool result = false; try { using (MainDataContext db = new MainDataContext()) { QuestionInfo Info = db.QuestionInfos.FirstOrDefault(p => p.QuestionID == questionId); if (Info != null) { db.QuestionInfos.DeleteOnSubmit(Info); } db.SubmitChanges(); result = true; } } catch (Exception ex) { } return result; }
public static void SaveOrUpdateDownLoadPageCount(int count) { using (MainDataContext db = new MainDataContext()) { SysDict dict = db.SysDicts.FirstOrDefault(p => p.DictName == "DownLoadPageCount"); if (dict == null) { dict = new SysDict() { DictValue = count.ToString(), DictName = "DownLoadPageCount", DictCode = "DownLoadPageCount", ModefyDate = DateTime.Now.ToString(), }; db.SysDicts.InsertOnSubmit(dict); } else { dict.DictValue = count.ToString(); dict.ModefyDate = DateTime.Now.ToString(); } db.SubmitChanges(); } }
public static bool SaveOrUpdateQuestionInfo(QuestionInfo qi) { bool result = false; try { using (MainDataContext db = new MainDataContext()) { QuestionInfo Info = db.QuestionInfos.FirstOrDefault(p => p.QuestionID == qi.QuestionID); if (Info == null) { db.QuestionInfos.InsertOnSubmit(qi); } else { Info = qi; } db.SubmitChanges(); result = true; } } catch (Exception ex) { } return result; }