📄 productresultlist.cpp
字号:
// allpqty=reader->GetString(0);
// break;
//}
//reader->Close();
//oDB->blnCnnClose();
//// sSQL = S"";
//// //sSQL = String::Concat(sSQL, S" " nvl(CALE.NAME_B, ' ') as NAME_B );
//// sSQL = String::Concat(sSQL, S"select" );
//// sSQL = String::Concat(sSQL, S" LST.YMD, " );
//// sSQL = String::Concat(sSQL, S" nvl(PS.shift, ' ') as scheduled_shift, " );
//// sSQL = String::Concat(sSQL, S" LST.PRODUCT_CODE," );
//// sSQL = String::Concat(sSQL, S" LST.LOT, " );
//// sSQL = String::Concat(sSQL, S" NVL(PS.QTY,0) PS_QTY," );
//// sSQL = String::Concat(sSQL, S" NVL(PR.QTY,0) PR_QTY, " );
//// //sSQL = String::Concat(sSQL, S" NVL(trunc((PR.QTY)/(PS.QTY)*100),0) PERCENTAGE " );
//// //张//开始
//// //原始
//// //sSQL = String::Concat(sSQL, S" case when PS.QTY!=0 then NVL(trunc((PR.QTY)-(PS.QTY)),0) else 0 end as PERCENTAGE " );
//// sSQL = String::Concat(sSQL, S" NVL(trunc((PR.QTY)-(PS.QTY)),-(PS.QTY)) PERCENTAGE " );
//// //张//结束
//// /*sSQL = String::Concat(sSQL, S" case when PS.QTY!=0 then NVL(trunc((PR.QTY)/(PS.QTY)*100),0) else 0 end as PERCENTAGE " );*/
//////sSQL = String::Concat(sSQL, S" case when sum(PS_QTY)!=0 then NVL(trunc((sum(PR_QTY))/( sum(PS_QTY))*100),0) else 0 end as PERCENTAGE " );
//// sSQL = String::Concat(sSQL, S"from " );
//// sSQL = String::Concat(sSQL, S" ( " );
//// sSQL = String::Concat(sSQL, S" select distinct " );
//// sSQL = String::Concat(sSQL, S" YMD, " );
//// sSQL = String::Concat(sSQL, S" FACTORY_CODE," );
//// sSQL = String::Concat(sSQL, S" PROCESS_NO," );
//// sSQL = String::Concat(sSQL, S" PRODUCT_CODE," );
//// sSQL = String::Concat(sSQL, S" LOT" );
//// sSQL = String::Concat(sSQL, S" from " );
//// sSQL = String::Concat(sSQL, S" PRODUCT_SCHEDULE " );
//// sSQL = String::Concat(sSQL, S" where " );
//// sSQL = String::Concat(sSQL, S" PROCESS_NO='",sProcessNo,S"' and" );
//// //sSQL = String::Concat(sSQL, S" ymd>=to_date('",trunc(dateTimePickerFrom->Value).ToString,S"','yyyy-mm-dd') and ymd<=to_date('",trunc(dateTimePickerTo->Value).ToString,S"','yyyy-mm-dd') " );//condition from comobox
//// //if (comboBoxUnit->SelectedIndex==0)
//// //{
//// sSQL = String::Concat(sSQL, S" ymd>=to_date('",dateTimePickerFrom->Text,S"','yyyy-mm-dd') and ymd<=to_date('",dateTimePickerTo->Text,S"','yyyy-mm-dd') " );
//// //}
//// //else
//// //{
//// // sSQL = String::Concat(sSQL, S" ymd>=to_date('",dateTimePickerFrom->Text,S"','yyyy-mm') and ymd< ADD_MONTHS(to_date('",dateTimePickerTo->Text,S"','yyyy-mm'),1) " );
//// //}
////
//// sSQL = String::Concat(sSQL, S" union" );
//// sSQL = String::Concat(sSQL, S" select distinct" );
//// sSQL = String::Concat(sSQL, S" YMD, " );
//// sSQL = String::Concat(sSQL, S" FACTORY_CODE," );
//// sSQL = String::Concat(sSQL, S" PROCESS_NO," );
//// sSQL = String::Concat(sSQL, S" PRODUCT_CODE," );
//// sSQL = String::Concat(sSQL, S" LOT" );
//// sSQL = String::Concat(sSQL, S" from" );
//// sSQL = String::Concat(sSQL, S" PRODUCT_RESULT_DATA " );
//// sSQL = String::Concat(sSQL, S" where " );
//// sSQL = String::Concat(sSQL, S" PROCESS_NO='",sProcessNo,S"' and " );//condition from comobox
//// sSQL = String::Concat(sSQL, S" ymd>=to_date('",dateTimePickerFrom->Text,S"','yyyy-mm-dd') and ymd<=to_date('",dateTimePickerTo->Text,S"','yyyy-mm-dd') " );
//// ////if (comboBoxUnit->SelectedIndex==0)
//// ////{
//// //sSQL = String::Concat(sSQL, S" ymd>=to_date('",dateTimePickerFrom->Text,S"','yyyy-mm-dd') and ymd<=to_date('",dateTimePickerTo->Text,S"','yyyy-mm-dd') " );
//// ////}
//// ////else
//// ////{
//// //// sSQL = String::Concat(sSQL, S" ymd>=to_date('",dateTimePickerFrom->Text,S"','yyyy-mm') and ymd<= ADD_MONTHS(to_date('",dateTimePickerTo->Text,S"','yyyy-mm'),1) " );
//// //}
//// sSQL = String::Concat(sSQL, S" ) LST," );
//// sSQL = String::Concat(sSQL, S" ( " );
//// sSQL = String::Concat(sSQL, S" select " );
//// sSQL = String::Concat(sSQL, S" ymd," );
//// sSQL = String::Concat(sSQL, S" shift," );
//// 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" NVL(PRODUCT_QTY,0) as QTY " );
//// sSQL = String::Concat(sSQL, S" from" );
//// sSQL = String::Concat(sSQL, S" PRODUCT_SCHEDULE" );
//// sSQL = String::Concat(sSQL, S" ) PS," );
//// 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" NVL(PRODUCT_QTY,0) as QTY " );
//// sSQL = String::Concat(sSQL, S" from " );
//// sSQL = String::Concat(sSQL, S" PRODUCT_RESULT_DATA " );
//// sSQL = String::Concat(sSQL, S" ) PR " );
//// sSQL = String::Concat(sSQL, S"where " );
//// sSQL = String::Concat(sSQL, S" LST.FACTORY_CODE = PS.FACTORY_CODE(+) and " );
//// sSQL = String::Concat(sSQL, S" LST.FACTORY_CODE = PR.FACTORY_CODE(+) and" );
//// sSQL = String::Concat(sSQL, S" LST.PROCESS_NO = PS.PROCESS_NO(+) and" );
//// sSQL = String::Concat(sSQL, S" LST.PROCESS_NO = PR.PROCESS_NO(+) and" );
//// sSQL = String::Concat(sSQL, S" LST.PRODUCT_CODE = PS.PRODUCT_CODE(+) and" );
//// sSQL = String::Concat(sSQL, S" LST.PRODUCT_CODE = PR.PRODUCT_CODE(+) and" );
//// sSQL = String::Concat(sSQL, S" LST.LOT = PS.LOT(+) and " );
//// sSQL = String::Concat(sSQL, S" LST.LOT = PR.LOT(+) " );
//// sSQL = String::Concat(sSQL, S" and lst.YMD = ps.ymd(+) " );
//// sSQL = String::Concat(sSQL, S" and lst.YMD = pr.ymd(+) " );
//// sSQL = String::Concat(sSQL, S"order by " );
//// sSQL = String::Concat(sSQL, S" LST.YMD,LST.PRODUCT_CODE, LST.LOT " );
////
sMySQLDay=sSQL;
}
void ProductResultList::GetDataGridMinorForDay(String* sProcessNo)
{
//BindingManagerBase* oBM;
//DataRow* oDR;
//String* sLot;
//Get selected Lot
//oBM = dataGridMainForDay->BindingContext->get_Item(oDataTableMain);
//oDR = (dynamic_cast<DataRowView*>(oBM->Current))->Row;
//sLot = oDR->get_Item(S"LOT")->ToString();//get current selected LOT field's value
//
// dataGridMinor->DataSource = NULL;
// dataGridMinor->Refresh();
//String *sSQL = S"";
//String* saLang[] = {S"C", S"J", S"E"};
/*if(comboBoxUnit->SelectedIndex==0)
{*/
//sSQL = String::Concat(sSQL, S" " );
//sSQL = String::Concat(sSQL, S"select " );
//sSQL = String::Concat(sSQL, S" CALE.LOT as LOT, " );
//sSQL = String::Concat(sSQL, S" to_char(CALE.YMD,'yyyy-mm-dd') as YMD_DATE, " );
//sSQL = String::Concat(sSQL, S" nvl(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(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(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 ");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -