public DataTable OrderPaymentNccc(SinopacDetailQuery store, string sql) { try { return _IorderpaymentDao.OrderPaymentNccc(store,sql); } catch (Exception ex) { throw new Exception("OrderPaymentNcccMgr-->OrderPaymentNccc-->" + ex.Message, ex); } }
/// <summary> /// 供應商出貨單中的訂單轉單日期 /// </summary> /// <param name="store"></param> /// <returns></returns> public DataTable OrderPaymentNccc(SinopacDetailQuery store,string sql) { StringBuilder sb = new StringBuilder(); try { sb.AppendFormat(" select order_id,FROM_UNIXTIME(nccc_createdate) as pay_time from order_payment_nccc where 1=1 "); if (!string.IsNullOrEmpty(sql)) { sb.Append(sql); } return _access.getDataTable(sb.ToString()); } catch (Exception ex) { throw new Exception("OrderPaymentNcccDao->OrderPaymentNccc->" + ex.Message + sb.ToString(), ex); } }