public HttpResponseBase GetCancel() { List<OrderCancelMasterQuery> stores = new List<OrderCancelMasterQuery>(); string json = string.Empty; try { OrderCancelMasterQuery query = new OrderCancelMasterQuery(); 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.GetCancel(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 List<OrderCancelMasterQuery> GetCancel(OrderCancelMasterQuery store, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlcount = new StringBuilder(); try { sql.AppendLine(@"SELECT ocm.cancel_id,CASE ocm.cancel_status WHEN '1' THEN '已歸檔' WHEN '2' THEN '刪除' ELSE '待歸檔' END AS cancle_status_string,FROM_UNIXTIME(ocm.cancel_createdate) AS cancel_createdate,ocm.cancel_note,"); sql.AppendLine(@"od.item_id,od.product_name,od.product_spec_name,od.product_freight_set,"); sql.AppendLine(@"od.buy_num,od.single_money,(od.single_money*od.buy_num) AS subtotal, od.deduct_bonus,"); sql.AppendLine(@"ocd.detail_id,od.slave_id,od.detail_note,pf.parameterName AS product_freight_set_string,"); sql.AppendLine(@"ocm.order_id,ocm.bank_note,FROM_UNIXTIME(ocm.cancel_updatedate) AS cancel_updatedate,ocm.cancel_ipfrom "); sql.AppendLine(@"FROM order_cancel_master ocm "); sql.AppendLine(@"LEFT JOIN order_cancel_detail ocd ON ocd.cancel_id=ocm.cancel_id "); sql.AppendLine(@"LEFT JOIN order_detail od ON od.detail_id=ocd.detail_id "); sql.AppendLine(@"LEFT JOIN (SELECT * FROM t_parametersrc WHERE parameterType='product_freight') pf ON pf.parameterCode=od.product_freight_set "); sql.AppendFormat(@"WHERE ocm.order_id={0}", store.order_id); sqlcount.AppendFormat(@"SELECT count(*) as search_total FROM order_cancel_master ocm LEFT JOIN order_cancel_detail ocd ON ocd.cancel_id=ocm.cancel_id LEFT JOIN order_detail od ON od.detail_id=ocd.detail_id WHERE ocm.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<OrderCancelMasterQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("TabShowDao-->GetCancel " + ex.Message + sql.ToString(), ex); } }