var command = new OracleCommand();
command.Connection = conn;
if (tran != null) command.Transaction = tran;
string sql = "SELECT AW.HAWB_NO,RE.MODI_DATE,AR.AR_MAWB_NO,OP.NAME_CN,RE.REMARK FROM REMARK RE,AWB AW,AR_MAWB AR, " +
"OPERATOR OP WHERE AR.AR_MAWB_ID = AW.AR_MAWB_ID AND AW.AWB_ID = RE.AWB_ID AND OP.OPER_ID = RE.MODI_OPER "+
" AND RE.REMARK LIKE '计算费用,原费用是/%' ";
if (comp_id != 0)// AND TO_NUMBER(SUBSTR(RE.REMARK,11,Length(RE.REMARK)-10))>0
{
sql = sql + " AND AR.START_COMP_ID = :COMP_ID ";
}
if (startTime != null && endTime != null)
{
sql = sql + " AND RE.MODI_DATE >= :STARTTIME AND RE.MODI_DATE <= :ENDTIME ";
}
sql = sql + " ORDER BY AR.AR_MAWB_NO,RE.MODI_DATE ";
command.CommandText = sql;
command.CommandType = System.Data.CommandType.Text;
if (comp_id != 0)
{
command.Parameters.Add(new OracleParameter("COMP_ID", OracleType.Number)).Value = comp_id;
}
if (startTime != null && endTime != null)
{
DateTime startDate1 = (DateTime)startTime;
DateTime endDate1 = (DateTime)endTime;
string startTime1 = startDate1.Year + "-" + startDate1.Month + "-" + startDate1.Day;
string endTime1 = endDate1.Year + "-" + endDate1.Month + "-" + endDate1.Day;
command.Parameters.Add(new OracleParameter("STARTTIME", OracleType.DateTime)).Value = DateTime.Parse(startTime1);
command.Parameters.Add(new OracleParameter("ENDTIME", OracleType.DateTime)).Value = DateTime.Parse(endTime1);
}