Ejemplo n.º 1
0
        public List<OrderPaymentCt> GetOrderPaymentCtList(OrderPaymentCt store, out int totalCount)
        {
            StringBuilder sb = new StringBuilder();
            try
            {
                sb.Append(@"SELECT id,status,errcode ,authcode,originalamt,offsetamt,utilizedpoint,errdesc,xid,awardedpoint,pointbalance ");
                sb.AppendFormat("  FROM   order_master om,order_payment_ct opc WHERE 1=1 AND opc.lidm = om.order_id ");
                sb.AppendFormat(" AND opc.lidm ='{0}'", store.lidm);
                totalCount = 0;
                if (store.IsPage)
                {
                    System.Data.DataTable _dt = _access.getDataTable(sb.ToString());
                    if (_dt != null && _dt.Rows.Count > 0)
                    {
                        totalCount = _dt.Rows.Count;
                    }
                    sb.AppendFormat(" limit {0},{1}", store.Start, store.Limit);
                }

            }
            catch (Exception ex)
            {

                throw new Exception("TabShowDao-->GetOrderPaymentCtList " + ex.Message + sb.ToString(), ex);
            }

            return _access.getDataTableForObj<OrderPaymentCt>(sb.ToString());

        }
Ejemplo n.º 2
0
        /// <summary>
        /// 中國信託
        /// </summary>
        /// <returns></returns>
        public HttpResponseBase GetOrderPaymentCtList()
        {
            string json = string.Empty;

            OrderPaymentCt query = new OrderPaymentCt();
            query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
            query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
            if (!string.IsNullOrEmpty(Request.Params["Order_Id"]))
            {
                query.lidm = int.Parse(Request.Params["Order_Id"]);
            }
            try
            {
                List<OrderPaymentCt> store = new List<OrderPaymentCt>();
                _tbshow = new TabShowMgr(mySqlConnectionString);
                int totalCount = 0;
                store = _tbshow.GetOrderPaymentCtList(query, out  totalCount);
                IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
                //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式     
                timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
                json = "{success:true,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:true,totalCount:0,data:[]}";
            }
            this.Response.Clear();
            this.Response.Write(json);
            this.Response.End();
            return this.Response;

        }
Ejemplo n.º 3
0
 public List<OrderPaymentCt> GetOrderPaymentCtList(OrderPaymentCt store, out int totalCount)
 {
     try
     {
          return _tabshowdao.GetOrderPaymentCtList(store, out totalCount);
     }
     catch (Exception ex)
     {
         throw new Exception("TabShowMgr-->GetOrderPaymentCtList-->" + ex.Message, ex);
     }
 }