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