Beispiel #1
0
        /// <summary>
        /// 訂單詳情頁面列表
        /// </summary>
        /// <returns></returns>
        public HttpResponseBase GetTicketDetailAllCodeList()
        {
            string jsonStr = string.Empty;
            try
            {
                TicketDetailQuery query = new TicketDetailQuery();
                query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
                if (!string.IsNullOrEmpty(Request.Params["limit"]))
                {
                    query.Limit = Convert.ToInt32(Request.Params["limit"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["flag_status"]))
                {
                    query.flag = int.Parse(Request.Params["flag_status"]);
                }
                if (!string.IsNullOrEmpty(Request.Params["search_content"]))
                {
                    query.ticket_code = Request.Params["search_content"].ToString();
                }
                int totalCount = 0;
                _ITicketDetail = new TicketDetailMgr(mySqlConnectionString);

                DataTable _dt = _ITicketDetail.GetTicketDetailAllCodeTable(query, out totalCount);

                IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
                //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式     
                timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(_dt, 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);
                jsonStr = "{success:false,msg:0}";
            }
            this.Response.Clear();
            this.Response.Write(jsonStr.ToString());
            this.Response.End();
            return this.Response;
        }