public HttpResponseBase PaperClassEdit() { string json = string.Empty; PaperClass pc = new PaperClass(); _paperClassMgr = new PaperClassMgr(mySqlConnectionString); List<PaperClass> store = new List<PaperClass>(); List<PaperClass> oldstore = new List<PaperClass>(); bool success = false; try { PaperClass pcc = new PaperClass(); if (!string.IsNullOrEmpty(Request.Params["paper_id"])) { pc.paperID = int.Parse(Request.Params["paper_id"]);//新的問卷編號 pcc.paperID = int.Parse(Request.Params["paper_id"]); } int totalCount = 0; pcc.IsPage = false; store = _paperClassMgr.GetPaperClassList(pcc, out totalCount);//新的問卷編號查出來的數據 pcc = new PaperClass(); pcc.IsPage = false; if (!string.IsNullOrEmpty(Request.Params["old_paper_id"])) { pcc.paperID = int.Parse(Request.Params["old_paper_id"]);//舊的問卷編號 } string type = Request.Params["type"]; //設定題目編號 規則 paperID+四位自增數字(0001) if (String.IsNullOrEmpty(Request.Params["class_id"])) { if (store.Count > 0) { int classid = store.Max(e => e.classID); pc.classID = classid + 1; } else { pc.classID = int.Parse(pc.paperID.ToString() + "0001"); } } else { //修改問卷的話,題目編號也要相應變動 if (pc.paperID != pcc.paperID) { if (store.Count > 0) { int classid = store.Max(e => e.classID); pc.classID = classid + 1; } else { pc.classID = int.Parse(pc.paperID.ToString() + "0001"); } } else { pc.classID = int.Parse(Request.Params["class_id"]); } } pc.className = Request.Params["class_name"]; pc.classType = Request.Params["class_type"]; //pc.bannerUrl = Request.Params["banner_url"]; if (!string.IsNullOrEmpty(Request.Params["project_num"])) { pc.projectNum = int.Parse(Request.Params["project_num"]); } if (!string.IsNullOrEmpty(Request.Params["ismust"])) { pc.isMust = int.Parse(Request.Params["ismust"]); } if (!string.IsNullOrEmpty(Request.Params["pcontent"])) { string content = Request.Params["pcontent"].ToString(); string[] contents = content.Split(';'); string[] c; for (int i = 0; i < contents.Length - 1; i++) { c = contents[i].Split(','); pc.classContent = c[0].ToString(); pc.orderNum = int.Parse(c[1].ToString()); pc.id = int.Parse(c[2].ToString()); #region 新增 if (String.IsNullOrEmpty(Request.Params["class_id"])) { if (_paperClassMgr.Add(pc) > 0) { success = true; } else { success = false; } } #endregion #region 編輯 else { if (pc.id != 0) { if (_paperClassMgr.Update(pc) > 0) { success = true; } else { success = false; } } //編輯時新增 else { if (_paperClassMgr.Add(pc) > 0) { success = true; } else { success = false; } } } #endregion } } //題目類型選擇的不是單選多選時 else { #region 新增 if (String.IsNullOrEmpty(Request.Params["class_id"])) { if (_paperClassMgr.Add(pc) > 0) { success = true; } else { success = false; } } #endregion #region 編輯 else { if (!string.IsNullOrEmpty(Request.Params["id"])) { pc.id = int.Parse(Request.Params["id"]); } if (_paperClassMgr.Update(pc) > 0) { success = true; } else { success = false; } } #endregion } //如果選擇新的問卷,就重組舊問卷的題目編號 if (Request.Params["paper_id"] != Request.Params["old_paper_id"]) { if (!string.IsNullOrEmpty(Request.Params["class_id"])) { oldstore = _paperClassMgr.GetPaperClassList(pcc, out totalCount);//舊的問卷編號查出來的數據 int class_id = int.Parse(Request.Params["class_id"]); foreach (var item in oldstore) { //一個問卷中,如果舊的題目編號小於當前的題目編號 if (item.classID > class_id) { item.classID = item.classID - 1; _paperClassMgr.UpdateClassID(item); } } } } if (success) { json = "{success:true}"; } else { json = "{success:false}"; } } catch (Exception ex) { json = "{success:false,msg:\"" + "異常" + "\"}"; Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase GetPaperClassList() { string json = string.Empty; List<PaperClass> store = new List<PaperClass>(); PaperClass pc = new PaperClass(); try { pc.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 pc.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量 _paperClassMgr = new PaperClassMgr(mySqlConnectionString); int totalCount = 0; if (!string.IsNullOrEmpty(Request.Params["paper_id"])) { pc.paperID = int.Parse(Request.Params["paper_id"]); } if (!string.IsNullOrEmpty(Request.Params["class_id"])) { pc.classID = int.Parse(Request.Params["class_id"]); } store = _paperClassMgr.GetPaperClassList(pc, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss "; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }