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);
}
}
