1. °³¹ß/½ÇÇà Ç÷§Æû (1) OS : winows 7 (2) °³¹ßÅø : felphi 7 (3) »ç¿ë Database : firebird 2.1
2. °³¹ß ÁßÀÎ ÇÁ·Î±×·¥ Àåºñ Á¡°ËÇ¥ ±×·¹ÇÁ
3. Áú¹® ³»¿ë ¾È³çÇϼ¼¿ä? Àåºñ Á¡°ËÇ¥ ÀÌ»óÀ¯¹« °á°ú¸¦ O, X ·Î üũ Çϵµ·Ï ¸¸µé¾ú½À´Ï´Ù. ÀÌ°ÍÀ» Chart Â÷Æ®·Î ±×·¡ÇÁ¸¦ ¸¸µå´Â °úÁ¤¿¡¼ Á¦µ¿ÀÌ °É¸®´Â±Ù¿ä ¹æ¹ýÀº Çѹø¿¡ Äû¸®ÇÏ´Â ¹æ¹ýÀ» ÅÃÇߴµ¥ ¿ùº°·Î ¾çÈ£, ºÒ·® Ä«¿îÆ®¿¡¼ °ªÀÌ Á¦´ë·Î ¾È³ª¿É´Ï´Ù. ºÐ¸íÈ÷ Äû¸® ±¸¼ºÀÌ À߸øµÈ°Í °°Àºµ¥ ½Ç·ÂÀÌ ºÎÁ·Çؼ ´õÀÌ»ó Áøô¸® ¾ÊµË´Ï´Ù. ¾Æ·¡´Â º¯º¯Ä¡¸øÇÑ ¼Ò½ºÀÌ°í¿ä ÷ºÎÆľËÀº ±×·¡ÇÁ ÀÔ´Ï´Ù.±×·¡ÇÁ¸¦ º¸½Ã¸é ºÒ·®°Ç¼ö °¡ ³ª¿Í¾ß Çϴµ¥ ¿ùÀÇ ³¯Â¥¼ö ¸¸ Ä«¿îÆ®µÇ¾î ±×·¡ÇÁ ÆÄ°í°¡ ÀÏÁ¤ÇÏ°Ô ³ª¿É´Ï´Ù. 01 ~ 12 ±îÁö´Â ¿ùº° ÀÌ°í¿ä ck_chk1 ~ ck-xhk3¹ø ±îÁö´Â ¾çÈ£'o', ºÒ·® 'x' ·Î DB¿¡ ÀÚÀåµÈ Ç¥½ÃÀÔ´Ï´Ù.
var sSQL : String; iRow : Integer; MTSum1 : Array[1..13] of Integer; i,j : Integer; iFor : Integer; begin for iFor := 1 to 13 do MTSum1[iFor] := 0; // Á¶È¸ÇÏ°íÁ®ÇÏ´Â ³¯ÀÚ¸¦ ÀÔ·ÂÇÏ¿´À¸¸é... sSQL := ' SELECT ' + ' COUNT(DECODE(FIR_MONTH, ''01'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST1, ' + ' COUNT(DECODE(FIR_MONTH, ''02'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST2, ' + ' COUNT(DECODE(FIR_MONTH, ''03'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST3, ' + ' COUNT(DECODE(FIR_MONTH, ''04'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST4, ' + ' COUNT(DECODE(FIR_MONTH, ''05'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST5, ' + ' COUNT(DECODE(FIR_MONTH, ''06'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST6, ' + ' COUNT(DECODE(FIR_MONTH, ''07'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST7, ' + ' COUNT(DECODE(FIR_MONTH, ''08'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST8, ' + ' COUNT(DECODE(FIR_MONTH, ''09'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST9, ' + ' COUNT(DECODE(FIR_MONTH, ''10'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST10,' + ' COUNT(DECODE(FIR_MONTH, ''11'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST11,' + ' COUNT(DECODE(FIR_MONTH, ''12'',CK_CHK1, ''X'',CK_CHK2, ''X'',CK_CHK3, ''X'', 0)) ST12 ' + ' COUNT(FIR_MONTH) MTSUM ' FROM TF_FIREFIG '+ ' WHERE FIR_DATE BETWEEN ''' + ME_FIR_Date1.Text + ''' '+ ' AND ''' + ME_FIR_Date2.Text + '''';
|