QueryBuildDataSource的应用
来源:互联网 发布:淘宝卖家怎么收款 编辑:程序博客网 时间:2024/06/08 11:44
void getDataFromJobTable()
{
Query query;
QueryRun qr;
QueryBuildDataSource qbdsJobTable;
JaxJobTable curJobTable;
EajProdMaterialCountLine curCountLine;
;
delete_from curCountLine where curCountLine.EajProdMaterialCountId == EajProdMaterialCountTable.EajProdMaterialCountId;
frDateTime = EajProdMaterialCountTable.FromDateTime;
toDateTime = EajProdMaterialCountTable.ToDateTime;
//Inquiries the Job order
query = new Query();
qbdsJobTable = query.addDataSource(tablenum(JaxJobTable));
if(frDateTime && toDateTime)
{
sysQuery::findOrCreateRange(qbdsJobTable,fieldnum(JaxJobTable,JobFromDate)).value(QueryRange(frDateTime,toDateTime));
}
else if(frDateTime && !toDateTime && frDateTime <= DateTimeUtil::utcNow())
{
sysQuery::findOrCreateRange(qbdsJobTable,fieldnum(JaxJobTable,JobtoDate)).value(queryValue(frDateTime) + '..');
}
else if(!frDateTime && toDateTime)
{
sysQuery::findOrCreateRange(qbdsJobTable,fieldnum(JaxJobTable,JobtoDate)).value('..'+ queryValue(toDateTime));
}
//if(emplIdStr)
// sysQuery::findOrCreateRange(qbdsJobTable,fieldnum(JaxJobTable,EmplId)).value(queryValue(emplIdStr));
if(EajProdMaterialCountTable.WrkCtrId)
sysQuery::findOrCreateRange(qbdsJobTable,fieldnum(JaxJobTable,WrkCtrId)).value(queryValue(EajProdMaterialCountTable.WrkCtrId));
sysQuery::findOrCreateRange(qbdsJobTable,fieldnum(JaxJobTable,JaxJobType)).value(queryValue(0));
//sysQuery::findOrCreateRange(qbdsJobTable,fieldnum(JaxJobTable,Posted)).value(queryValue(0));
qr = new QueryRun(query);
while(qr.next())
{
curJobTable = qr.get(tablenum(JaxJobTable));
if(!curJobTable.Posted)
{
curCountLine.EajSelected = true;
}
curCountLine.EajProdMaterialCountId = EajProdMaterialCountTable.EajProdMaterialCountId;
curCountLine.JobId = curJobTable.JobId;
curCountLine.Posted = curJobTable.Posted;
curCountLine.ManualPosted = curJobTable.Posted;
curCountLine.ProdId = curJobTable.ProdId;
curCountLine.GrossWeightOut = curJobTable.dispOSGPW();
curCountLine.GrossWeightIn = curCountLine.GrossWeightOut;
curCountLine.ProdQtyOut = curJobTable.dispOPOQ();
curCountLine.GoldWeightOut = curJobTable.dispOGW();
curCountLine.insert();
}
//EajProdMaterialCountLine_ds.executeQuery();
}
- QueryBuildDataSource的应用
- pivot 的应用,有图有应用
- Servlet应用---HttpServletRequest的应用
- Servlet应用---HttpServletRequest的应用
- Servlet应用---HttpServletRequest的应用
- Servlet应用---HttpServletRequest的应用
- Servlet应用---HttpServletRequest的应用
- Servlet应用---HttpServletRequest的应用
- Servlet应用---HttpServletRequest的应用
- AndroidMenu的应用之OptionMenu的应用
- 模型的应用 && Xib &&代理模式的应用【应用管理】
- 工作流的应用之shark+jawe应用
- 应用图在地图方面的应用
- LBFGS应用---alglib的c++版本应用
- 基于应用程度的系统应用优化
- 基于应用程度的系统应用优化
- [Struts2应用开发] JSON的应用
- 应用里面调用安装应用的方法
- 政府工作汇报,PPT已成常态
- Qt4中ui文件生成vcproj
- xml文件结构
- 锻造软件需求人员的六大要素
- fcntl函数的简单应用
- QueryBuildDataSource的应用
- VC实现文件的拷贝移动
- 测试用例模板
- Smarty模板引擎基本语法的学习
- 2010.05.28 生成验证码的类
- 测试报告模板
- C++学习经典!~
- dll用法
- Oracle中CHAR类型自动补足空格的问题