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