Beispiel #1
0
        public HttpResponseBase PaperClassDelete()
        {
            string json = string.Empty;
            PaperClass pc = new PaperClass();
            _paperClassMgr = new PaperClassMgr(mySqlConnectionString);
            try
            {
                if (!string.IsNullOrEmpty(Request.Params["id"]))
                {
                    pc.id = int.Parse(Request.Params["id"]);
                }
                if (_paperClassMgr.Delete(pc) > 0)
                {
                    json = "{success:true}";
                }
            }
            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;
        }
Beispiel #2
0
        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;
        }
Beispiel #3
0
 public JsonResult UpdateClassState()
 {
     string ids = Request.Params["id"];
     //string rids = Request.Params["id"];
     ids = ids.TrimEnd(',');
     int activeValue = Convert.ToInt32(Request.Params["active"]);
     _paperClassMgr = new PaperClassMgr(mySqlConnectionString);
     if (_paperClassMgr.UpdateState(ids, activeValue) > 0)
     {
         return Json(new { success = "true", msg = "" });
     }
     else
     {
         return Json(new { success = "false", msg = "" });
     }
 }
Beispiel #4
0
 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;
 }