public HttpResponseBase GetMoney() { List<OrderMoneyReturnQuery> stores = new List<OrderMoneyReturnQuery>(); string json = string.Empty; try { OrderMoneyReturnQuery query = new OrderMoneyReturnQuery(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 query.order_id = Convert.ToUInt32(Request.Params["Order_Id"].ToString()); _tabshow = new TabShowMgr(mySqlConnectionString); int totalCount = 0; stores = _tabshow.GetMoney(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,'msg':'user',totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, 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; }
public HttpResponseBase SaveCSNote() { OrderMoneyReturnQuery query = new OrderMoneyReturnQuery(); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Params["money_id"])) { query.money_id = Convert.ToUInt32(Request.Params["money_id"]); } if (!string.IsNullOrEmpty(Request.Params["cs_note"])) { query.cs_note = Request.Params["cs_note"].Replace("\n"," "); } _orderMoneyReturnMgr = new OrderMoneyReturnMgr(mySqlConnectionString); json = _orderMoneyReturnMgr.SaveCSNote(query); } 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; }
public List<OrderMoneyReturnQuery> GetMoney(OrderMoneyReturnQuery store, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlcount = new StringBuilder(); try { sql.AppendFormat(@"SELECT omr.money_id,omr.order_id,omr.money_type,pay.parameterName AS moneytype,omr.money_total,CASE omr.money_status WHEN '1' THEN '已退款' ELSE '待退款' END AS states,omr.money_note,omr.money_source,omr.cs_note,"); sql.AppendFormat(@"omr.bank_name,omr.bank_branch,omr.bank_account,omr.bank_note,omr.account_name,FROM_UNIXTIME(omr.money_createdate) AS createdate,omr.money_updatedate,omr.money_ipfrom "); sql.AppendFormat(@"FROM order_money_return omr "); sql.AppendFormat(@"LEFT JOIN (SELECT * FROM t_parametersrc WHERE parameterType='payment') pay ON pay.parameterCode=omr.money_type "); sql.AppendFormat(@"WHERE omr.order_id={0} ORDER BY money_createdate ASC, money_id ASC ", store.order_id); sqlcount.AppendFormat(@"SELECT count(*) as search_total FROM order_money_return omr LEFT JOIN (SELECT * FROM t_parametersrc WHERE parameterType='payment') pay ON pay.parameterCode=omr.money_type WHERE order_id={0} ", store.order_id); totalCount = 0; if (store.IsPage) { System.Data.DataTable _dt = _access.getDataTable(sqlcount.ToString()); if (_dt != null && _dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0]["search_total"]); } sql.AppendFormat(" limit {0},{1}", store.Start, store.Limit); } return _access.getDataTableForObj<OrderMoneyReturnQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("TabShowDao-->GetMoney " + ex.Message + sql.ToString(), ex); } }