QT qxorm查询语句

https://www.cnblogs.com/wl-blog/p/16471075.html

QList<precheck> list_of_reel;
QString query_type = "lotMoveInTime";
QString date = QDate::currentDate().toString("yyyy-MM-dd");
QDateTime date2 = QDateTime::currentDateTime();
QString start_date = date + "00:00";
QString end_date = date + "23:59";

//QString sql = QString("WHERE %1 BETWEEN '%2' AND '%3' ORDER BY %4 ASC").arg(query_type).arg(date).arg(date).arg(query_type); //默认前面是select * from xxtab

//qx::QxSqlQuery query(sql); //默认前面是 select * from user
//query.bind(QString(":%1").arg(query_type), date);// "SLA12470E6DDCAA");
QList<QString> q_list;
//QString com_sql = QString("UPDATE book_info SET book_ibsn='ibsn1',book_price='%1' WHERE book_name='yuwen2'").arg(price_value);
//daoError = qx::dao::fetch_by_query(query, list_of_reel);
//return list_of_reel;

//model.setWhere("date_field BETWEEN '" + start_date + "' AND '" + end_date + "'");
// QxOrm::Model model("my_table");
//model.setWhere("date_field = '" + currentDate + "'");
//model.loadAll();

qx_query in_query1;
//in_query1.where(query_type+"='2025-03-28 00:00:00'");
//in_query1.where(query_type).isBetween(date, date);


//return q_list;
QDate startDate = QDate(2023,1,1); // 例如：2023年1月1日
QDate endDate = QDate(2026,12,31); // 例如：2023年12月31日

// 创建查询对象

// 设置查询条件，查询日期在startDate和endDate之间的记录
//in_query1.where("lotMoveInTime >= :startDate AND date <= :endDate")
// .bind(":startDate", startDate)
//.bind(":endDate", endDate);
//daoError = qx::dao::fetch_by_query(in_query1, list_of_reel);

//qx_query in_query1;
in_query1.where("lotMoveInTime").isBetween(start_date, endDate);
//in_query1.where("sn_reel").isEqualTo("1");
//in_query1.where("lotMoveInTime").isEqualTo(date);
daoError = qx::dao::fetch_by_query(in_query1, list_of_reel);
return q_list;