📄 productresultlist.cpp
字号:
//sSQL = String::Concat(sSQL, S" from ");
//sSQL = String::Concat(sSQL, S" PRODUCT_SCHEDULE ");
//sSQL = String::Concat(sSQL, S" group by ");
//sSQL = String::Concat(sSQL, S" YMD, ");
//sSQL = String::Concat(sSQL, S" FACTORY_CODE, ");
//sSQL = String::Concat(sSQL, S" LOT, ");
//sSQL = String::Concat(sSQL, S" LINE_CODE, ");
//sSQL = String::Concat(sSQL, S" PROCESS_NO, ");
//sSQL = String::Concat(sSQL, S" PRODUCT_CODE ");
//sSQL = String::Concat(sSQL, S" ) SCHE, " );
//sSQL = String::Concat(sSQL, S" PRODUCT_RESULT_DATA SR_A, ");
//sSQL = String::Concat(sSQL, S" PRODUCT_RESULT_DATA SR_B ");
//sSQL = String::Concat(sSQL, S"where " );
//sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = '", sFactory, S"' and ");
//sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = '", sProcessNo, S"' and ");
////sSQL = String::Concat(sSQL, S" CALE.LOT = '", sLot, S"' and ");
//////sSQL = String::Concat(sSQL, S" CALE.LOT =ABEF.LOT and ");
///////
//sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = SCHE.FACTORY_CODE(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = SCHE.PROCESS_NO(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.LOT = SCHE.LOT(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.YMD = SCHE.YMD(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = SR_A.FACTORY_CODE(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = SR_A.PROCESS_NO(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.LOT = SR_A.LOT(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.YMD = SR_A.YMD(+) and ");
//sSQL = String::Concat(sSQL, S" SR_A.SHIFT(+) = 'A' and ");
//sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = SR_B.FACTORY_CODE(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = SR_B.PROCESS_NO(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.LOT = SR_B.LOT(+) and ");
//sSQL = String::Concat(sSQL, S" CALE.YMD = SR_B.YMD(+) and ");
//sSQL = String::Concat(sSQL, S" SR_B.SHIFT(+) = 'B' ");
//sSQL = String::Concat(sSQL, S"order by ");
//sSQL = String::Concat(sSQL, S" CALE.YMD ");
/*}
else
{
sSQL = String::Concat(sSQL, S"select " );
sSQL = String::Concat(sSQL, S" to_char(CALE.YMD ,'yyyy-mm') as YMD_DATE, " );
sSQL = String::Concat(sSQL, S" nvl(sum(SCHE.TOTAL),0) as TOTAL, " );
sSQL = String::Concat(sSQL, S" nvl(CALE.NAME_B, ' ') as NAME_B, " );
sSQL = String::Concat(sSQL, S" nvl(to_char(sum(SR_B.PRODUCT_QTY),'999990'),' ') as QTY_B, " );
sSQL = String::Concat(sSQL, S" nvl(CALE.NAME_A, ' ') as NAME_A, " );
sSQL = String::Concat(sSQL, S" nvl(to_char(sum(SR_A.PRODUCT_QTY),'999990'),' ') as QTY_A " );
sSQL = String::Concat(sSQL, S"from " );
sSQL = String::Concat(sSQL, S" ( " );
sSQL = String::Concat(sSQL, S" select distinct " );
sSQL = String::Concat(sSQL, S" CAL.WORK_YMD as YMD, " );
sSQL = String::Concat(sSQL, S" M_M.FACTORY_CODE, " );
sSQL = String::Concat(sSQL, S" M_M.LOT, " );
sSQL = String::Concat(sSQL, S" M_M.LINE_CODE, " );
sSQL = String::Concat(sSQL, S" M_M.PROCESS_NO, " );
sSQL = String::Concat(sSQL, S" M_M.PRODUCT_CODE, " );
sSQL = String::Concat(sSQL, S" CAL.NAME_A, " );
sSQL = String::Concat(sSQL, S" CAL.NAME_B " );
sSQL = String::Concat(sSQL, S" from " );
sSQL = String::Concat(sSQL, S" ( " );
sSQL = String::Concat(sSQL, S" select distinct " );
sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE, " );
sSQL = String::Concat(sSQL, S" CALE.LINE_CODE, " );
sSQL = String::Concat(sSQL, S" CALE.WORK_YMD, " );
sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO, " );
sSQL = String::Concat(sSQL, S" TE_A.NAME_", saLang[iLanguage],S" as NAME_A, " );
sSQL = String::Concat(sSQL, S" TE_B.NAME_", saLang[iLanguage],S" as NAME_B " );
sSQL = String::Concat(sSQL, S" from " );
sSQL = String::Concat(sSQL, S" WORK_CALENDER CALE, " );
sSQL = String::Concat(sSQL, S" TEAM_MST TE_A, " );
sSQL = String::Concat(sSQL, S" TEAM_MST TE_B " );
sSQL = String::Concat(sSQL, S" where " );
sSQL = String::Concat(sSQL, S" CALE.DAY_SHIFT = TE_A.TEAM(+) and " );
sSQL = String::Concat(sSQL, S" CALE.NIGHT_SHIFT = TE_B.TEAM(+) and " );
sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = TE_A.PROCESS_NO(+) and " );
sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = TE_B.PROCESS_NO(+) " );
sSQL = String::Concat(sSQL, S" ) CAL, " );
sSQL = String::Concat(sSQL, S" ( " );
sSQL = String::Concat(sSQL, S" select" );
sSQL = String::Concat(sSQL, S" FACTORY_CODE, " );
sSQL = String::Concat(sSQL, S" LOT, " );
sSQL = String::Concat(sSQL, S" LINE_CODE, " );
sSQL = String::Concat(sSQL, S" PROCESS_NO, " );
sSQL = String::Concat(sSQL, S" PRODUCT_CODE, " );
sSQL = String::Concat(sSQL, S" min(YMD) as W_MIN, " );
sSQL = String::Concat(sSQL, S" max(YMD) as W_MAX " );
sSQL = String::Concat(sSQL, S" from " );
sSQL = String::Concat(sSQL, S" ( " );
sSQL = String::Concat(sSQL, S" select " );
sSQL = String::Concat(sSQL, S" YMD, " );
sSQL = String::Concat(sSQL, S" FACTORY_CODE, " );
sSQL = String::Concat(sSQL, S" LOT, " );
sSQL = String::Concat(sSQL, S" LINE_CODE, " );
sSQL = String::Concat(sSQL, S" PROCESS_NO, " );
sSQL = String::Concat(sSQL, S" PRODUCT_CODE " );
sSQL = String::Concat(sSQL, S" from " );
sSQL = String::Concat(sSQL, S" PRODUCT_SCHEDULE " );
sSQL = String::Concat(sSQL, S" union " );
sSQL = String::Concat(sSQL, S" select " );
sSQL = String::Concat(sSQL, S" YMD, " );
sSQL = String::Concat(sSQL, S" FACTORY_CODE, " );
sSQL = String::Concat(sSQL, S" LOT, " );
sSQL = String::Concat(sSQL, S" LINE_CODE, " );
sSQL = String::Concat(sSQL, S" PROCESS_NO, " );
sSQL = String::Concat(sSQL, S" PRODUCT_CODE " );
sSQL = String::Concat(sSQL, S" from " );
sSQL = String::Concat(sSQL, S" PRODUCT_RESULT_DATA " );
sSQL = String::Concat(sSQL, S" ) M_M " );
sSQL = String::Concat(sSQL, S" group by " );
sSQL = String::Concat(sSQL, S" FACTORY_CODE, LOT, LINE_CODE, PROCESS_NO, PRODUCT_CODE " );
sSQL = String::Concat(sSQL, S" ) M_M " );
sSQL = String::Concat(sSQL, S" where " );
sSQL = String::Concat(sSQL, S" CAL.FACTORY_CODE = M_M.FACTORY_CODE and " );
sSQL = String::Concat(sSQL, S" CAL.LINE_CODE = M_M.LINE_CODE and " );
sSQL = String::Concat(sSQL, S" CAL.PROCESS_NO = M_M.PROCESS_NO and " );
sSQL = String::Concat(sSQL, S" CAL.WORK_YMD >= M_M.W_MIN and " );
sSQL = String::Concat(sSQL, S" CAL.WORK_YMD <= M_M.W_MAX " );
sSQL = String::Concat(sSQL, S" order by " );
sSQL = String::Concat(sSQL, S" M_M.LOT, M_M.PROCESS_NO, CAL.WORK_YMD " );
sSQL = String::Concat(sSQL, S" ) CALE, " );
sSQL = String::Concat(sSQL, S" ( " );
sSQL = String::Concat(sSQL, S" select " );
sSQL = String::Concat(sSQL, S" YMD, " );
sSQL = String::Concat(sSQL, S" FACTORY_CODE, " );
sSQL = String::Concat(sSQL, S" LOT, " );
sSQL = String::Concat(sSQL, S" PROCESS_NO, " );
sSQL = String::Concat(sSQL, S" PRODUCT_CODE, " );
sSQL = String::Concat(sSQL, S" sum(PRODUCT_QTY) as TOTAL " );
sSQL = String::Concat(sSQL, S" from " );
sSQL = String::Concat(sSQL, S" PRODUCT_SCHEDULE " );
sSQL = String::Concat(sSQL, S" group by " );
sSQL = String::Concat(sSQL, S" YMD, " );
sSQL = String::Concat(sSQL, S" FACTORY_CODE, " );
sSQL = String::Concat(sSQL, S" LOT, " );
sSQL = String::Concat(sSQL, S" LINE_CODE, " );
sSQL = String::Concat(sSQL, S" PROCESS_NO, " );
sSQL = String::Concat(sSQL, S" PRODUCT_CODE " );
sSQL = String::Concat(sSQL, S" ) SCHE, " );
sSQL = String::Concat(sSQL, S" PRODUCT_RESULT_DATA SR_A, " );
sSQL = String::Concat(sSQL, S" PRODUCT_RESULT_DATA SR_B " );
sSQL = String::Concat(sSQL, S"where " );
sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = '", sFactory, S"' and " );
sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = '", sProcessNo, S"' and " );
sSQL = String::Concat(sSQL, S" CALE.LOT = '", sLot, S"' and " );
sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = SCHE.FACTORY_CODE(+) and " );
sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = SCHE.PROCESS_NO(+) and " );
sSQL = String::Concat(sSQL, S" CALE.LOT = SCHE.LOT(+) and " );
sSQL = String::Concat(sSQL, S" CALE.YMD = SCHE.YMD(+) and " );
sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = SR_A.FACTORY_CODE(+) and " );
sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = SR_A.PROCESS_NO(+) and " );
sSQL = String::Concat(sSQL, S" CALE.LOT = SR_A.LOT(+) and " );
sSQL = String::Concat(sSQL, S" CALE.YMD = SR_A.YMD(+) and " );
sSQL = String::Concat(sSQL, S" SR_A.SHIFT(+) = 'A' and " );
sSQL = String::Concat(sSQL, S" CALE.FACTORY_CODE = SR_B.FACTORY_CODE(+) and " );
sSQL = String::Concat(sSQL, S" CALE.PROCESS_NO = SR_B.PROCESS_NO(+) and " );
sSQL = String::Concat(sSQL, S" CALE.LOT = SR_B.LOT(+) and " );
sSQL = String::Concat(sSQL, S" CALE.YMD = SR_B.YMD(+) and " );
sSQL = String::Concat(sSQL, S" SR_B.SHIFT(+) = 'B' " );
sSQL = String::Concat(sSQL, S" group by to_char(CALE.YMD,'yyyy-mm'),NAME_B, NAME_A " );
}*/
///////////////////////////////////////开始//////////////////////////////
//For daytime select
//////////////////////////////////////////////////////////////////////////////////////////////
// sMySQLDay2=sSQL;
// String * sAllSQL=S"";
//
// sAllSQL=String::Concat(sAllSQL,S"select null as FLINE,ABEF.YMD as SECYMD,ABEF.YMD,ABEF.scheduled_shift as scheduled_shift,ABEF.PRODUCT_CODE,ABEF.LOT,ABEF.PS_QTY,ABEF.PR_QTY,ABEF.PERCENTAGE,\n");
// sAllSQL=String::Concat(sAllSQL,S"CKSH.YMD_DATE,CKSH.TOTAL,CKSH.NAME_B,CKSH.QTY_B,CKSH.NAME_A,CKSH.QTY_A\n");
//sAllSQL=String::Concat(sAllSQL,S" from (\n");
// sAllSQL=String::Concat(sAllSQL,sMySQLDay);
//
// sAllSQL=String::Concat(sAllSQL,S"\n)ABEF left outer join(\n");
// sAllSQL=String::Concat(sAllSQL,sMySQLDay2);
//
// sAllSQL=String::Concat(sAllSQL,S"\n)CKSH \n");
//
//sAllSQL=String::Concat(sAllSQL,S"on ABEF.lot=CKSH.lot");
// //
//
////取计划日期
//String * finalSQL;
////String * tempSQL;
////String * productSQL;
//finalSQL=S"";
//
//finalSQL=String::Concat(finalSQL,S"select BBTABLE.YMD AS SECYMD,KKTABLE.YMD,KKTABLE.scheduled_shift as scheduled_shift,");
//
//finalSQL=String::Concat(finalSQL,S"CASE WHEN KKTABLE.scheduled_shift='A' THEN KKTABLE.NAME_A WHEN KKTABLE.scheduled_shift='B' THEN KKTABLE.NAME_B END AS TEAMWORK,");
//finalSQL=String::Concat(finalSQL,S"CASE WHEN KKTABLE.scheduled_shift='A' THEN KKTABLE.QTY_A WHEN KKTABLE.scheduled_shift='B' THEN KKTABLE.QTY_B END AS TEAMQTY");
// //KKTABLE.scheduled_shift as scheduled_shift
// finalSQL=String::Concat(finalSQL,S",KKTABLE.PRODUCT_CODE,KKTABLE.LOT,KKTABLE.PS_QTY,KKTABLE.PR_QTY,KKTABLE.PERCENTAGE,\n");
//finalSQL=String::Concat(finalSQL,S"KKTABLE.YMD_DATE,KKTABLE.TOTAL,KKTABLE.NAME_B,KKTABLE.QTY_B,KKTABLE.NAME_A,KKTABLE.QTY_A\n");
//finalSQL=String::Concat(finalSQL,S" from (\n");
//finalSQL=String::Concat(finalSQL,sAllSQL);
//
//finalSQL=String::Concat(finalSQL,S"\n)KKTABLE left outer join(\n");
//
//finalSQL=String::Concat(finalSQL,S"select YMD,lot from product_schedule where ");
//finalSQL = String::Concat(finalSQL, S" ymd>=to_date('",dateTimePickerFrom->Text,S"','yyyy-mm-dd') and ymd<=to_date('",dateTimePickerTo->Text,S"','yyyy-mm-dd') ");
//
//
//finalSQL=String::Concat(finalSQL,S"\n)BBTABLE \n");
//
//finalSQL=String::Concat(finalSQL,S" on KKTABLE.lot=BBTABLE.lot order by KKTABLE.YMD,KKTABLE.PRODUCT_CODE,KKTABLE.LOT");
//tempSQL=finalSQL;
//finalSQL=S"";
//取品名
//switch(iLanguage)
////String* ssaLang[] = {S"C", S"J", S"E"};
////finalSQL=String::Concat(finalSQL,S"select BBTABLE.product_name,KKTABLE.SECYMD,KKTABLE.YMD,KKTABLE.scheduled_shift as scheduled_shift,KKTABLE.PRODUCT_CODE,KKTABLE.LOT,KKTABLE.PS_QTY,KKTABLE.PR_QTY,KKTABLE.PERCENTAGE,\n");
////finalSQL=String::Concat(finalSQL,S"KKTABLE.YMD_DATE,KKTABLE.TOTAL,KKTABLE.NAME_B,KKTABLE.QTY_B,KKTABLE.NAME_A,KKTABLE.QTY_A\n");
////finalSQL=String::Concat(finalSQL,S" from (\n");
////finalSQL=String::Concat(finalSQL,tempSQL);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -