public DataTable CheckTransport(OrderReturnStatusQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
query.Replace4MySQL();
sql.AppendFormat("select orc.orc_deliver_code from order_return_content orc where orc.orc_order_id='{0}' and return_id='{1}' ; ", query.orc_order_id,query.return_id);
DataTable _dt = _access.getDataTable(sql.ToString());
return _dt;
}
catch (Exception ex)
{
throw new Exception("OrderReturnStatusDao-->CheckTransport-->" + ex.Message + sql.ToString(), ex);
}
}
public DataTable CheckOrderId(OrderReturnStatusQuery query)
{
StringBuilder sql = new StringBuilder();
try
{
query.Replace4MySQL();
sql.AppendFormat("select ors.ors_status from order_return_status ors where ors.ors_order_id='{0}' and return_id='{1}' order by ors_status desc; ", query.ors_order_id, query.return_id);
DataTable _dt = _access.getDataTable(sql.ToString());
return _dt;
}
catch (Exception ex)
{
throw new Exception("OrderReturnStatusDao-->CheckOrderId-->" + ex.Message + sql.ToString(), ex);
}
}