• R/O
  • SSH
  • HTTPS

nextcrm: Commit


Commit MetaInfo

Revision575 (tree)
Time2013-03-31 20:15:40
Authorsatouyouhei

Log Message

2.4.4 公開

Change Summary

Incremental Difference

--- 2_source/1_製品紹介サイト/1_顧客分析君CRM/4_CSVファイルの構成.html (revision 574)
+++ 2_source/1_製品紹介サイト/1_顧客分析君CRM/4_CSVファイルの構成.html (revision 575)
@@ -356,52 +356,39 @@
356356 <COL style="WIDTH: 16pt" span=31 width=21></COLGROUP>
357357 <TBODY>
358358 <TR style="HEIGHT: 13.5pt" height=18>
359-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
360- class=xl66 height=18 width=63 colSpan=3 align="center">1???</TD>
361-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
362- class=xl66 width=42 colSpan=2 align="center">2???</TD>
363-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
364- class=xl66 width=84 colSpan=4 align="center">3???</TD>
365-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
366- class=xl66 width=42 colSpan=2 align="center">4???</TD>
367-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
368- class=xl66 width=63 colSpan=3 align="center">5???</TD>
369-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
370- class=xl66 width=84 colSpan=4 align="center">6???</TD>
371-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
372- class=xl66 width=42 colSpan=2 align="center">7???</TD>
373-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
374- class=xl66 width=63 colSpan=3 align="center">8???</TD>
375-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
376- class=xl66 width=105 colSpan=5 align="center">9???</TD>
377-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
378- class=xl66 width=63 colSpan=3 align="center">10???</TD></TR>
359+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=18 width=63 colSpan=3 align="center">1???</TD>
360+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 colSpan=2 align="center">2???</TD>
361+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 colSpan=4 align="center">3???</TD>
362+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 colSpan=2 align="center">4???</TD>
363+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">5???</TD>
364+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 colSpan=4 align="center">6???</TD>
365+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 colSpan=2 align="center">7???</TD>
366+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">8???</TD>
367+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=105 colSpan=5 align="center">9???</TD>
368+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">10???</TD>
369+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">11???</TD>
370+</TR>
379371 <TR style="HEIGHT: 13.5pt" height=18>
380-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
381- class=xl67 height=18 colSpan=3 align="center">?ڋqID</TD>
382-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
383- class=xl67 colSpan=2 align="center">????</TD>
384-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
385- class=xl67 colSpan=4 align="center">?????J?i</TD>
386-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
387- class=xl67 colSpan=2 align="center">????</TD>
388-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
389- class=xl67 colSpan=3 align="center">?N??</TD>
390-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
391- class=xl67 colSpan=4 align="center">?X?֔ԍ?</TD>
392-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
393- class=xl67 colSpan=2 align="center">?Z??</TD>
394-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
395- class=xl67 colSpan=3 align="center">TEL</TD>
396-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
397- class=xl67 colSpan=5 align="center">???[???A?h???X</TD>
398-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
399- class=xl67 colSpan=3 align="center">???l</TD></TR></TBODY></TABLE>
400-<P>?y??z</P><PRE>"US-1","????A","?V???C?A","?j??","42","111-2222","?????s","00-1111-2222","te@aa.ne.jp",""
401-"US-2","????B","?V???C?r","????","23","333-4444","?????s","33-4444-5555","d0@bb.ne.jp",""
402-"US-3","","","","","","","","",""
372+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=18 colSpan=3 align="center">?ڋqID</TD>
373+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=2 align="center">????</TD>
374+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=4 align="center">?????J?i</TD>
375+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=2 align="center">????</TD>
376+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">?N??</TD>
377+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=4 align="center">?X?֔ԍ?</TD>
378+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=2 align="center">?Z??</TD>
379+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">TEL</TD>
380+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=5 align="center">???[???A?h???X</TD>
381+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">?????}?K????</TD>
382+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">???l</TD>
383+</TR>
384+</TBODY></TABLE>
385+<P>?y??z</P>
386+<PRE>
387+"US-1","????A","?V???C?A","?j??","1979/12/20","111-2222","?????s","00-1111-2222","?s??","te@aa.ne.jp",""
388+"US-2","????B","?V???C?r","????","2002/1/8","333-4444","?????s","33-4444-5555","??","d0@bb.ne.jp",""
389+"US-3","","","","","","","","","",""
403390 </PRE>
404-<P>?T???v???F<A href="http://garfie.weblogs.jp/kokyakubunseki2010/files/sample2.csv">sample2.csv</A> </P>
391+<P>?T???v???F<A href="http://garfie.weblogs.jp/crm_2/file/sample2.csv">sample2.csv</A> </P>
405392 <P>?@</P>
406393 <P>?Q?A?u?I???s??CSV?t?@?C???ɏo?́v?{?^???ō쐬?????t?@?C???̓??e?B</P>
407394 <P>?y?\???z</P>
@@ -410,51 +397,38 @@
410397 <COL style="WIDTH: 16pt" span=31 width=21></COLGROUP>
411398 <TBODY>
412399 <TR style="HEIGHT: 13.5pt" height=18>
413-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
414- class=xl66 height=18 width=63 colSpan=3 align="center">1???</TD>
415-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
416- class=xl66 width=42 colSpan=2 align="center">2???</TD>
417-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
418- class=xl66 width=84 colSpan=4 align="center">3???</TD>
419-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
420- class=xl66 width=42 colSpan=2 align="center">4???</TD>
421-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
422- class=xl66 width=63 colSpan=3 align="center">5???</TD>
423-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
424- class=xl66 width=84 colSpan=4 align="center">6???</TD>
425-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
426- class=xl66 width=42 colSpan=2 align="center">7???</TD>
427-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
428- class=xl66 width=63 colSpan=3 align="center">8???</TD>
429-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
430- class=xl66 width=105 colSpan=5 align="center">9???</TD>
431-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
432- class=xl66 width=63 colSpan=3 align="center">10???</TD></TR>
400+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=18 width=63 colSpan=3 align="center">1???</TD>
401+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 colSpan=2 align="center">2???</TD>
402+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 colSpan=4 align="center">3???</TD>
403+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 colSpan=2 align="center">4???</TD>
404+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">5???</TD>
405+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 64pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=84 colSpan=4 align="center">6???</TD>
406+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 32pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=42 colSpan=2 align="center">7???</TD>
407+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">8???</TD>
408+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=105 colSpan=5 align="center">9???</TD>
409+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">10???</TD>
410+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; WIDTH: 48pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=63 colSpan=3 align="center">11???</TD>
411+</TR>
433412 <TR style="HEIGHT: 13.5pt" height=18>
434-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
435- class=xl67 height=18 colSpan=3 align="center">?ڋqID</TD>
436-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
437- class=xl67 colSpan=2 align="center">????</TD>
438-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
439- class=xl67 colSpan=4 align="center">?????J?i</TD>
440-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
441- class=xl67 colSpan=2 align="center">????</TD>
442-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
443- class=xl67 colSpan=3 align="center">?N??</TD>
444-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
445- class=xl67 colSpan=4 align="center">?X?֔ԍ?</TD>
446-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
447- class=xl67 colSpan=2 align="center">?Z??</TD>
448-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
449- class=xl67 colSpan=3 align="center">TEL</TD>
450-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
451- class=xl67 colSpan=5 align="center">???[???A?h???X</TD>
452-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid"
453- class=xl67 colSpan=3 align="center">???l</TD></TR></TBODY></TABLE>
454-<P>?y??z</P><PRE>"?ڋqID","????","?????J?i","????","?N??","?X?֔ԍ?","?Z??","TEL","???[???A?h???X","???l"
455-"US-1","????A","?V???C?A","?j??","42","111-2222","?????s","00-1111-2222","te@aa.ne.jp",""
456-"US-2","????B","?V???C?r","????","23","333-4444","?????s","33-4444-5555","d0@bb.ne.jp",""
457-"US-3","","","","","","","","",""
413+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=18 colSpan=3 align="center">?ڋqID</TD>
414+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=2 align="center">????</TD>
415+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=4 align="center">?????J?i</TD>
416+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=2 align="center">????</TD>
417+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">?N??</TD>
418+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=4 align="center">?X?֔ԍ?</TD>
419+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=2 align="center">?Z??</TD>
420+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">TEL</TD>
421+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=5 align="center">???[???A?h???X</TD>
422+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">?????}?K????</TD>
423+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=3 align="center">???l</TD>
424+</TR>
425+</TBODY></TABLE>
426+<P>?y??z</P>
427+<PRE>
428+"?ڋqID","????","?????J?i","????","?N??","?X?֔ԍ?","?Z??","TEL","???[???A?h???X","???l"
429+"US-1","????A","?V???C?A","?j??","1979/12/20","111-2222","?????s","00-1111-2222","?s??","te@aa.ne.jp",""
430+"US-2","????B","?V???C?r","????","2002/1/8","333-4444","?????s","33-4444-5555","??","d0@bb.ne.jp",""
431+"US-3","","","","","","","","","",""
458432 </PRE>
459433 <P>?@</P>
460434 <HR>
@@ -617,7 +591,8 @@
617591 <TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 colSpan=2 align="center">7???</TD>
618592 <TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 colSpan=3 align="center">8???</TD>
619593 <TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 colSpan=5 align="center">9???</TD>
620-<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 colSpan=3 align="center">10???</TD></TR>
594+<TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #ffffcc; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 colSpan=3 align="center">10???</TD>
595+</TR>
621596 <TR style="HEIGHT: 13.5pt" height=18>
622597 <TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 13.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=18 colSpan=3 align="center">?ڋqID</TD>
623598 <TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 colSpan=2 align="center">????</TD>
--- 2_source/4_顧客分析君CRM/顧客分析君/C06DB共通.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/C06DB共通.cs (revision 575)
@@ -23,7 +23,6 @@
2323 public static 顧客分析君.D03販売履歴TableAdapters.D03商品ta d03商品ta;
2424 public static 顧客分析君.D03販売履歴TableAdapters.D03対象期間内の顧客ta d03対象期間内の顧客ta;
2525 public static 顧客分析君.D03販売履歴TableAdapters.D03販売履歴ta d03販売履歴ta;
26- public static 顧客分析君.D10顧客TableAdapters.D10顧客検索ta d10顧客検索ta;
2726 public static 顧客分析君.D05計算TableAdapters.D05RFMta d05RFMta;
2827 public static 顧客分析君.D05計算TableAdapters.D05RFM計算条件ta d05RFM計算条件ta;
2928 public static 顧客分析君.D05計算TableAdapters.D05RFM別顧客数ta d05RFM別顧客数ta;
@@ -55,6 +54,7 @@
5554 public static 顧客分析君.D10顧客TableAdapters.D10顧客2ta d10顧客2ta;
5655 public static 顧客分析君.D10顧客TableAdapters.D10顧客ta d10顧客ta;
5756 public static 顧客分析君.D10顧客TableAdapters.D10顧客補足ta d10顧客補足ta;
57+ public static 顧客分析君.D10顧客TableAdapters.D10顧客検索ta d10顧客検索ta;
5858 public static 顧客分析君.D11メール配信TableAdapters.D11メールテンプレートta d11メールテンプレートta;
5959 public static 顧客分析君.D12スタッフTableAdapters.D12オープン可能画面ta d12オープン可能画面ta;
6060 public static 顧客分析君.D12スタッフTableAdapters.D12スタッフta d12スタッフta;
@@ -143,6 +143,8 @@
143143 d13コンタクト履歴ta = new 顧客分析君.D13コンタクトTableAdapters.D13コンタクト履歴ta();
144144 d14操作履歴ta = new 顧客分析君.D14操作履歴TableAdapters.D14操作履歴ta();
145145 d15FMta = new 顧客分析君.D15FM分析TableAdapters.D15FMta();
146+ d15FMランク別顧客数ta = new 顧客分析君.D15FM分析TableAdapters.D15FMランク別顧客数ta();
147+ d15表示年ta = new 顧客分析君.D15FM分析TableAdapters.D15表示年ta();
146148 d16広告ta = new 顧客分析君.D16広告TableAdapters.D16広告ta();
147149 d16広告検索ta = new 顧客分析君.D16広告TableAdapters.D16広告検索ta();
148150 d17PR履歴ta = new 顧客分析君.D17PR履歴TableAdapters.D17PR履歴ta();
--- 2_source/4_顧客分析君CRM/顧客分析君/202顧客一覧.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/202顧客一覧.cs (revision 575)
@@ -96,10 +96,13 @@
9696 break;
9797
9898 case CSV取込列.byt生年月日:
99- if (!IsValidate共通(value, true, C_最大文字数.年月日, C_正規表現.半角英数
100- , Properties.Resources.DGV列名_生年月日))
101- return false;
99+ if (value == "")
100+ break;
102101
102+ if (!IsValidate共通(value, true, C_最大文字数.年月日, C_正規表現.半角英数
103+ , Properties.Resources.DGV列名_生年月日))
104+ return false;
105+
103106 // 日付型チェック
104107 DateTime dt;
105108 if (DateTime.TryParse(value, out dt) == false)
@@ -174,7 +177,12 @@
174177 row.氏名 = values[CSV取込列.byt氏名];
175178 row.氏名カナ = values[CSV取込列.byt氏名カナ];
176179 row.性別 = values[CSV取込列.byt性別];
177- row.生年月日 = DateTime.Parse(values[CSV取込列.byt生年月日]);
180+
181+ if (values[CSV取込列.byt生年月日] == "")
182+ row.生年月日 = DateTime.Parse("1900/1/1");
183+ else
184+ row.生年月日 = DateTime.Parse(values[CSV取込列.byt生年月日]);
185+
178186 row.郵便番号 = values[CSV取込列.byt郵便番号];
179187 row.住所 = values[CSV取込列.byt住所];
180188 row.TEL = values[CSV取込列.bytTEL];
--- 2_source/4_顧客分析君CRM/顧客分析君/407FM分析.Designer.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/407FM分析.Designer.cs (revision 575)
@@ -30,24 +30,24 @@
3030 {
3131 this.components = new System.ComponentModel.Container();
3232 System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(_407FM分析));
33- System.Windows.Forms.DataVisualization.Charting.ChartArea chartArea3 = new System.Windows.Forms.DataVisualization.Charting.ChartArea();
34- System.Windows.Forms.DataVisualization.Charting.Legend legend3 = new System.Windows.Forms.DataVisualization.Charting.Legend();
35- System.Windows.Forms.DataVisualization.Charting.Series series12 = new System.Windows.Forms.DataVisualization.Charting.Series();
36- System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
37- System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();
38- System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();
39- System.Windows.Forms.DataVisualization.Charting.ChartArea chartArea4 = new System.Windows.Forms.DataVisualization.Charting.ChartArea();
40- System.Windows.Forms.DataVisualization.Charting.Legend legend4 = new System.Windows.Forms.DataVisualization.Charting.Legend();
41- System.Windows.Forms.DataVisualization.Charting.Series series13 = new System.Windows.Forms.DataVisualization.Charting.Series();
42- System.Windows.Forms.DataVisualization.Charting.Series series14 = new System.Windows.Forms.DataVisualization.Charting.Series();
43- System.Windows.Forms.DataVisualization.Charting.Series series15 = new System.Windows.Forms.DataVisualization.Charting.Series();
44- System.Windows.Forms.DataVisualization.Charting.Series series16 = new System.Windows.Forms.DataVisualization.Charting.Series();
45- System.Windows.Forms.DataVisualization.Charting.Series series17 = new System.Windows.Forms.DataVisualization.Charting.Series();
46- System.Windows.Forms.DataVisualization.Charting.Series series18 = new System.Windows.Forms.DataVisualization.Charting.Series();
47- System.Windows.Forms.DataVisualization.Charting.Series series19 = new System.Windows.Forms.DataVisualization.Charting.Series();
48- System.Windows.Forms.DataVisualization.Charting.Series series20 = new System.Windows.Forms.DataVisualization.Charting.Series();
49- System.Windows.Forms.DataVisualization.Charting.Series series21 = new System.Windows.Forms.DataVisualization.Charting.Series();
50- System.Windows.Forms.DataVisualization.Charting.Series series22 = new System.Windows.Forms.DataVisualization.Charting.Series();
33+ System.Windows.Forms.DataVisualization.Charting.ChartArea chartArea1 = new System.Windows.Forms.DataVisualization.Charting.ChartArea();
34+ System.Windows.Forms.DataVisualization.Charting.Legend legend1 = new System.Windows.Forms.DataVisualization.Charting.Legend();
35+ System.Windows.Forms.DataVisualization.Charting.Series series1 = new System.Windows.Forms.DataVisualization.Charting.Series();
36+ System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
37+ System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();
38+ System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
39+ System.Windows.Forms.DataVisualization.Charting.ChartArea chartArea2 = new System.Windows.Forms.DataVisualization.Charting.ChartArea();
40+ System.Windows.Forms.DataVisualization.Charting.Legend legend2 = new System.Windows.Forms.DataVisualization.Charting.Legend();
41+ System.Windows.Forms.DataVisualization.Charting.Series series2 = new System.Windows.Forms.DataVisualization.Charting.Series();
42+ System.Windows.Forms.DataVisualization.Charting.Series series3 = new System.Windows.Forms.DataVisualization.Charting.Series();
43+ System.Windows.Forms.DataVisualization.Charting.Series series4 = new System.Windows.Forms.DataVisualization.Charting.Series();
44+ System.Windows.Forms.DataVisualization.Charting.Series series5 = new System.Windows.Forms.DataVisualization.Charting.Series();
45+ System.Windows.Forms.DataVisualization.Charting.Series series6 = new System.Windows.Forms.DataVisualization.Charting.Series();
46+ System.Windows.Forms.DataVisualization.Charting.Series series7 = new System.Windows.Forms.DataVisualization.Charting.Series();
47+ System.Windows.Forms.DataVisualization.Charting.Series series8 = new System.Windows.Forms.DataVisualization.Charting.Series();
48+ System.Windows.Forms.DataVisualization.Charting.Series series9 = new System.Windows.Forms.DataVisualization.Charting.Series();
49+ System.Windows.Forms.DataVisualization.Charting.Series series10 = new System.Windows.Forms.DataVisualization.Charting.Series();
50+ System.Windows.Forms.DataVisualization.Charting.Series series11 = new System.Windows.Forms.DataVisualization.Charting.Series();
5151 this.groupBox3 = new System.Windows.Forms.GroupBox();
5252 this.label24 = new System.Windows.Forms.Label();
5353 this.label27 = new System.Windows.Forms.Label();
@@ -321,38 +321,38 @@
321321 resources.ApplyResources(this.chtFMランク別顧客数円グラフ, "chtFMランク別顧客数円グラフ");
322322 this.chtFMランク別顧客数円グラフ.BorderlineDashStyle = System.Windows.Forms.DataVisualization.Charting.ChartDashStyle.Solid;
323323 this.chtFMランク別顧客数円グラフ.BorderlineWidth = 2;
324- chartArea3.Area3DStyle.Enable3D = true;
325- chartArea3.Area3DStyle.IsClustered = true;
326- chartArea3.Area3DStyle.IsRightAngleAxes = false;
327- chartArea3.AxisX.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
328- chartArea3.AxisX.MajorGrid.Enabled = false;
329- chartArea3.AxisX.MajorGrid.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
330- chartArea3.AxisX.MajorTickMark.Enabled = false;
331- chartArea3.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
332- chartArea3.Name = "ChartArea1";
333- this.chtFMランク別顧客数円グラフ.ChartAreas.Add(chartArea3);
324+ chartArea1.Area3DStyle.Enable3D = true;
325+ chartArea1.Area3DStyle.IsClustered = true;
326+ chartArea1.Area3DStyle.IsRightAngleAxes = false;
327+ chartArea1.AxisX.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
328+ chartArea1.AxisX.MajorGrid.Enabled = false;
329+ chartArea1.AxisX.MajorGrid.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
330+ chartArea1.AxisX.MajorTickMark.Enabled = false;
331+ chartArea1.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
332+ chartArea1.Name = "ChartArea1";
333+ this.chtFMランク別顧客数円グラフ.ChartAreas.Add(chartArea1);
334334 this.chtFMランク別顧客数円グラフ.IsSoftShadows = false;
335- legend3.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F);
336- legend3.IsEquallySpacedItems = true;
337- legend3.IsTextAutoFit = false;
338- legend3.Name = "Legend1";
339- this.chtFMランク別顧客数円グラフ.Legends.Add(legend3);
335+ legend1.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F);
336+ legend1.IsEquallySpacedItems = true;
337+ legend1.IsTextAutoFit = false;
338+ legend1.Name = "Legend1";
339+ this.chtFMランク別顧客数円グラフ.Legends.Add(legend1);
340340 this.chtFMランク別顧客数円グラフ.Name = "chtFMランク別顧客数円グラフ";
341- series12.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
342- series12.ChartArea = "ChartArea1";
343- series12.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
344- series12.Color = System.Drawing.Color.FromArgb(((int)(((byte)(180)))), ((int)(((byte)(65)))), ((int)(((byte)(140)))), ((int)(((byte)(240)))));
345- series12.CustomProperties = "MinimumRelativePieSize=20, PieDrawingStyle=Concave, CollectedLabel=Other, Doughnu" +
341+ series1.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));
342+ series1.ChartArea = "ChartArea1";
343+ series1.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie;
344+ series1.Color = System.Drawing.Color.FromArgb(((int)(((byte)(180)))), ((int)(((byte)(65)))), ((int)(((byte)(140)))), ((int)(((byte)(240)))));
345+ series1.CustomProperties = "MinimumRelativePieSize=20, PieDrawingStyle=Concave, CollectedLabel=Other, Doughnu" +
346346 "tRadius=25";
347- series12.Font = new System.Drawing.Font("Trebuchet MS", 8.25F, System.Drawing.FontStyle.Bold);
348- series12.IsValueShownAsLabel = true;
349- series12.LabelFormat = "{P0}";
350- series12.Legend = "Legend1";
351- series12.MarkerStyle = System.Windows.Forms.DataVisualization.Charting.MarkerStyle.Circle;
352- series12.Name = "Series1";
353- series12.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Double;
354- series12.YValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Double;
355- this.chtFMランク別顧客数円グラフ.Series.Add(series12);
347+ series1.Font = new System.Drawing.Font("Trebuchet MS", 8.25F, System.Drawing.FontStyle.Bold);
348+ series1.IsValueShownAsLabel = true;
349+ series1.LabelFormat = "{P0}";
350+ series1.Legend = "Legend1";
351+ series1.MarkerStyle = System.Windows.Forms.DataVisualization.Charting.MarkerStyle.Circle;
352+ series1.Name = "Series1";
353+ series1.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Double;
354+ series1.YValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Double;
355+ this.chtFMランク別顧客数円グラフ.Series.Add(series1);
356356 //
357357 // label3
358358 //
@@ -372,33 +372,33 @@
372372 this.dgvFM分析表.AllowUserToDeleteRows = false;
373373 resources.ApplyResources(this.dgvFM分析表, "dgvFM分析表");
374374 this.dgvFM分析表.BackgroundColor = System.Drawing.SystemColors.Window;
375- dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
376- dataGridViewCellStyle4.BackColor = System.Drawing.SystemColors.Control;
377- dataGridViewCellStyle4.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
378- dataGridViewCellStyle4.ForeColor = System.Drawing.SystemColors.WindowText;
379- dataGridViewCellStyle4.SelectionBackColor = System.Drawing.SystemColors.Highlight;
380- dataGridViewCellStyle4.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
381- dataGridViewCellStyle4.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
382- this.dgvFM分析表.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle4;
375+ dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
376+ dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control;
377+ dataGridViewCellStyle1.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
378+ dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;
379+ dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;
380+ dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
381+ dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
382+ this.dgvFM分析表.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
383383 this.dgvFM分析表.ColumnHeadersVisible = false;
384- dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
385- dataGridViewCellStyle5.BackColor = System.Drawing.SystemColors.Window;
386- dataGridViewCellStyle5.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
387- dataGridViewCellStyle5.ForeColor = System.Drawing.SystemColors.ControlText;
388- dataGridViewCellStyle5.SelectionBackColor = System.Drawing.SystemColors.Highlight;
389- dataGridViewCellStyle5.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
390- dataGridViewCellStyle5.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
391- this.dgvFM分析表.DefaultCellStyle = dataGridViewCellStyle5;
384+ dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
385+ dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Window;
386+ dataGridViewCellStyle2.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
387+ dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.ControlText;
388+ dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;
389+ dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
390+ dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
391+ this.dgvFM分析表.DefaultCellStyle = dataGridViewCellStyle2;
392392 this.dgvFM分析表.Name = "dgvFM分析表";
393393 this.dgvFM分析表.ReadOnly = true;
394- dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
395- dataGridViewCellStyle6.BackColor = System.Drawing.SystemColors.Control;
396- dataGridViewCellStyle6.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
397- dataGridViewCellStyle6.ForeColor = System.Drawing.SystemColors.WindowText;
398- dataGridViewCellStyle6.SelectionBackColor = System.Drawing.SystemColors.Highlight;
399- dataGridViewCellStyle6.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
400- dataGridViewCellStyle6.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
401- this.dgvFM分析表.RowHeadersDefaultCellStyle = dataGridViewCellStyle6;
394+ dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
395+ dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Control;
396+ dataGridViewCellStyle3.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
397+ dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.WindowText;
398+ dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight;
399+ dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
400+ dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
401+ this.dgvFM分析表.RowHeadersDefaultCellStyle = dataGridViewCellStyle3;
402402 this.dgvFM分析表.RowHeadersVisible = false;
403403 this.dgvFM分析表.RowTemplate.Height = 21;
404404 this.dgvFM分析表.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;
@@ -436,95 +436,95 @@
436436 // chtFMランク別顧客数推移
437437 //
438438 resources.ApplyResources(this.chtFMランク別顧客数推移, "chtFMランク別顧客数推移");
439- chartArea4.Name = "ChartArea1";
440- this.chtFMランク別顧客数推移.ChartAreas.Add(chartArea4);
441- legend4.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F);
442- legend4.IsTextAutoFit = false;
443- legend4.Name = "Legend1";
444- legend4.TitleFont = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold);
445- this.chtFMランク別顧客数推移.Legends.Add(legend4);
439+ chartArea2.Name = "ChartArea1";
440+ this.chtFMランク別顧客数推移.ChartAreas.Add(chartArea2);
441+ legend2.Font = new System.Drawing.Font("Microsoft Sans Serif", 10F);
442+ legend2.IsTextAutoFit = false;
443+ legend2.Name = "Legend1";
444+ legend2.TitleFont = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Bold);
445+ this.chtFMランク別顧客数推移.Legends.Add(legend2);
446446 this.chtFMランク別顧客数推移.Name = "chtFMランク別顧客数推移";
447- series13.BorderWidth = 10;
448- series13.ChartArea = "ChartArea1";
449- series13.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
450- series13.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F);
451- series13.Legend = "Legend1";
452- series13.Name = "顧客総数";
453- series13.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
454- series14.BorderWidth = 5;
455- series14.ChartArea = "ChartArea1";
456- series14.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
457- series14.Legend = "Legend1";
458- series14.Name = "F:3 M:3";
459- series14.SmartLabelStyle.CalloutLineWidth = 10;
460- series14.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
461- series15.BorderWidth = 5;
462- series15.ChartArea = "ChartArea1";
463- series15.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
464- series15.IsXValueIndexed = true;
465- series15.Legend = "Legend1";
466- series15.Name = "F:3 M:2";
467- series15.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
468- series15.YValuesPerPoint = 2;
469- series16.BorderWidth = 5;
470- series16.ChartArea = "ChartArea1";
471- series16.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
472- series16.IsXValueIndexed = true;
473- series16.Legend = "Legend1";
474- series16.Name = "F:3 M:1";
475- series16.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
476- series17.BorderWidth = 5;
477- series17.ChartArea = "ChartArea1";
478- series17.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
479- series17.IsXValueIndexed = true;
480- series17.Legend = "Legend1";
481- series17.Name = "F:2 M:3";
482- series17.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
483- series18.BorderWidth = 5;
484- series18.ChartArea = "ChartArea1";
485- series18.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
486- series18.IsXValueIndexed = true;
487- series18.Legend = "Legend1";
488- series18.Name = "F:2 M:2";
489- series18.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
490- series19.BorderWidth = 5;
491- series19.ChartArea = "ChartArea1";
492- series19.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
493- series19.IsXValueIndexed = true;
494- series19.Legend = "Legend1";
495- series19.Name = "F:2 M:1";
496- series19.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
497- series20.BorderWidth = 5;
498- series20.ChartArea = "ChartArea1";
499- series20.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
500- series20.IsXValueIndexed = true;
501- series20.Legend = "Legend1";
502- series20.Name = "F:1 M:3";
503- series20.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
504- series21.BorderWidth = 5;
505- series21.ChartArea = "ChartArea1";
506- series21.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
507- series21.IsXValueIndexed = true;
508- series21.Legend = "Legend1";
509- series21.Name = "F:1 M:2";
510- series21.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.UInt32;
511- series22.BorderWidth = 5;
512- series22.ChartArea = "ChartArea1";
513- series22.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
514- series22.IsXValueIndexed = true;
515- series22.Legend = "Legend1";
516- series22.Name = "F:1 M:1";
517- series22.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.UInt32;
518- this.chtFMランク別顧客数推移.Series.Add(series13);
519- this.chtFMランク別顧客数推移.Series.Add(series14);
520- this.chtFMランク別顧客数推移.Series.Add(series15);
521- this.chtFMランク別顧客数推移.Series.Add(series16);
522- this.chtFMランク別顧客数推移.Series.Add(series17);
523- this.chtFMランク別顧客数推移.Series.Add(series18);
524- this.chtFMランク別顧客数推移.Series.Add(series19);
525- this.chtFMランク別顧客数推移.Series.Add(series20);
526- this.chtFMランク別顧客数推移.Series.Add(series21);
527- this.chtFMランク別顧客数推移.Series.Add(series22);
447+ series2.BorderWidth = 10;
448+ series2.ChartArea = "ChartArea1";
449+ series2.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
450+ series2.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F);
451+ series2.Legend = "Legend1";
452+ series2.Name = "顧客総数";
453+ series2.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
454+ series3.BorderWidth = 5;
455+ series3.ChartArea = "ChartArea1";
456+ series3.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
457+ series3.Legend = "Legend1";
458+ series3.Name = "F:3 M:3";
459+ series3.SmartLabelStyle.CalloutLineWidth = 10;
460+ series3.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
461+ series4.BorderWidth = 5;
462+ series4.ChartArea = "ChartArea1";
463+ series4.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
464+ series4.IsXValueIndexed = true;
465+ series4.Legend = "Legend1";
466+ series4.Name = "F:3 M:2";
467+ series4.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
468+ series4.YValuesPerPoint = 2;
469+ series5.BorderWidth = 5;
470+ series5.ChartArea = "ChartArea1";
471+ series5.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
472+ series5.IsXValueIndexed = true;
473+ series5.Legend = "Legend1";
474+ series5.Name = "F:3 M:1";
475+ series5.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
476+ series6.BorderWidth = 5;
477+ series6.ChartArea = "ChartArea1";
478+ series6.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
479+ series6.IsXValueIndexed = true;
480+ series6.Legend = "Legend1";
481+ series6.Name = "F:2 M:3";
482+ series6.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
483+ series7.BorderWidth = 5;
484+ series7.ChartArea = "ChartArea1";
485+ series7.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
486+ series7.IsXValueIndexed = true;
487+ series7.Legend = "Legend1";
488+ series7.Name = "F:2 M:2";
489+ series7.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
490+ series8.BorderWidth = 5;
491+ series8.ChartArea = "ChartArea1";
492+ series8.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
493+ series8.IsXValueIndexed = true;
494+ series8.Legend = "Legend1";
495+ series8.Name = "F:2 M:1";
496+ series8.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
497+ series9.BorderWidth = 5;
498+ series9.ChartArea = "ChartArea1";
499+ series9.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
500+ series9.IsXValueIndexed = true;
501+ series9.Legend = "Legend1";
502+ series9.Name = "F:1 M:3";
503+ series9.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32;
504+ series10.BorderWidth = 5;
505+ series10.ChartArea = "ChartArea1";
506+ series10.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
507+ series10.IsXValueIndexed = true;
508+ series10.Legend = "Legend1";
509+ series10.Name = "F:1 M:2";
510+ series10.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.UInt32;
511+ series11.BorderWidth = 5;
512+ series11.ChartArea = "ChartArea1";
513+ series11.ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Line;
514+ series11.IsXValueIndexed = true;
515+ series11.Legend = "Legend1";
516+ series11.Name = "F:1 M:1";
517+ series11.XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.UInt32;
518+ this.chtFMランク別顧客数推移.Series.Add(series2);
519+ this.chtFMランク別顧客数推移.Series.Add(series3);
520+ this.chtFMランク別顧客数推移.Series.Add(series4);
521+ this.chtFMランク別顧客数推移.Series.Add(series5);
522+ this.chtFMランク別顧客数推移.Series.Add(series6);
523+ this.chtFMランク別顧客数推移.Series.Add(series7);
524+ this.chtFMランク別顧客数推移.Series.Add(series8);
525+ this.chtFMランク別顧客数推移.Series.Add(series9);
526+ this.chtFMランク別顧客数推移.Series.Add(series10);
527+ this.chtFMランク別顧客数推移.Series.Add(series11);
528528 //
529529 // grp表示データ
530530 //
--- 2_source/4_顧客分析君CRM/顧客分析君/Program.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/Program.cs (revision 575)
@@ -38,8 +38,8 @@
3838 return;
3939
4040 #if RELEASE
41- Properties.Settings.Default.KB = Properties.Settings.Default.R_KB;
42- Properties.Settings.Default.MASTER = Properties.Settings.Default.R_MASTER;
41+ //Properties.Settings.Default.KB = Properties.Settings.Default.R_KB;
42+ //Properties.Settings.Default.MASTER = Properties.Settings.Default.R_MASTER;
4343 Properties.Settings.Default.SQLSERVER_SERVICE_NAME = Properties.Settings.Default.R_SQLSERVER_SERVICE_NAME;
4444 Properties.Settings.Default.Save();
4545 #endif
@@ -67,7 +67,7 @@
6767 #if RELEASE
6868 if (C05DBCommon.ChkSQLServer(Properties.Settings.Default.SQLSERVER_MACHIN_NAME
6969 , Properties.Settings.Default.SQLSERVER_SERVICE_NAME
70- , Properties.Settings.Default.MASTER
70+ , Properties.Settings.Default.KB
7171 , ref strTmp) == false)
7272 {
7373 C05DBCommon.SQLServer起動(Properties.Settings.Default.SQLSERVER_MACHIN_NAME
@@ -75,7 +75,7 @@
7575
7676 if (C05DBCommon.ChkSQLServer(Properties.Settings.Default.SQLSERVER_MACHIN_NAME
7777 , Properties.Settings.Default.SQLSERVER_SERVICE_NAME
78- , Properties.Settings.Default.MASTER
78+ , Properties.Settings.Default.KB
7979 , ref strTmp) == false)
8080 {
8181
--- 2_source/4_顧客分析君CRM/顧客分析君/C02業務共通処理.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/C02業務共通処理.cs (revision 575)
@@ -366,13 +366,27 @@
366366 // //return null;
367367 // return 0;
368368 //}
369- if (str性別名 == null)
370- str性別名 = "";
371369
372- //D01業務共通TableAdapters.D01属性ta ta = new D01業務共通TableAdapters.D01属性ta();
373- return (int)C06DB共通.d01属性ta.Scalar属性No(C_属性区分.性別, str性別名);
374- }
370+ //if (str性別名 == null)
371+ // str性別名 = "";
375372
373+ ////D01業務共通TableAdapters.D01属性ta ta = new D01業務共通TableAdapters.D01属性ta();
374+ //return (int)C06DB共通.d01属性ta.Scalar属性No(C_属性区分.性別, str性別名);
375+
376+ if (str性別名 == "男性")
377+ return 2;
378+ else if (str性別名 == "女性")
379+ return 3;
380+ //手入力した際、性別がIDで表示されるバグ用の、一時的な処置 START
381+ if (str性別名 == "2")
382+ return 2;
383+ else if (str性別名 == "3")
384+ return 3;
385+ //手入力した際、性別がIDで表示されるバグ用の、一時的な処置 END
386+ else
387+ return 1;
388+ }
389+
376390 public static int Getメルマガ許諾No(int iメルマガ許諾No, string strメルマガ許諾名)
377391 {
378392 if (iメルマガ許諾No != 0)
--- 2_source/4_顧客分析君CRM/顧客分析君/Properties/AssemblyInfo.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/Properties/AssemblyInfo.cs (revision 575)
@@ -34,6 +34,6 @@
3434 // すべての値を指定するか、下のように '*' を使ってビルドおよびリビジョン番号を
3535 // 既定値にすることができます:
3636 // [assembly: AssemblyVersion("1.0.*")]
37-[assembly: AssemblyVersion("2.4.3.*")]
37+[assembly: AssemblyVersion("2.4.4.*")]
3838 //[assembly: AssemblyFileVersion("2.2.*")]
3939 [assembly: NeutralResourcesLanguageAttribute("")]
--- 2_source/4_顧客分析君CRM/顧客分析君/Properties/Settings.Designer.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/Properties/Settings.Designer.cs (revision 575)
@@ -23,36 +23,6 @@
2323 }
2424 }
2525
26- [global::System.Configuration.ApplicationScopedSettingAttribute()]
27- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
28- [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
29- [global::System.Configuration.DefaultSettingValueAttribute("Data Source=192.168.21.101;Initial Catalog=master;Persist Security Info=True;Conn" +
30- "ection Timeout=60;User ID=sa;Password=sato;")]
31- public string KB {
32- get {
33- return ((string)(this["KB"]));
34- }
35- set
36- {
37- this["KB"] = value;
38- }
39- }
40-
41- [global::System.Configuration.ApplicationScopedSettingAttribute()]
42- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
43- [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
44- [global::System.Configuration.DefaultSettingValueAttribute("Data Source=192.168.21.101;Initial Catalog=master;Persist Security Info=True;Conn" +
45- "ection Timeout=60;User ID=sa;Password=sato;")]
46- public string MASTER {
47- get {
48- return ((string)(this["MASTER"]));
49- }
50- set
51- {
52- this["MASTER"] = value;
53- }
54- }
55-
5626 [global::System.Configuration.UserScopedSettingAttribute()]
5727 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
5828 [global::System.Configuration.DefaultSettingValueAttribute("C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data")]
@@ -65,28 +35,6 @@
6535 }
6636 }
6737
68- [global::System.Configuration.ApplicationScopedSettingAttribute()]
69- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
70- [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
71- [global::System.Configuration.DefaultSettingValueAttribute("Data Source=localhost\\sqlexpress;Initial Catalog=master;Integrated Security=True;" +
72- "Connection Timeout=60;")]
73- public string R_KB {
74- get {
75- return ((string)(this["R_KB"]));
76- }
77- }
78-
79- [global::System.Configuration.ApplicationScopedSettingAttribute()]
80- [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
81- [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
82- [global::System.Configuration.DefaultSettingValueAttribute("Data Source=localhost\\sqlexpress;Initial Catalog=master;Integrated Security=True;" +
83- "Connection Timeout=60;")]
84- public string R_MASTER {
85- get {
86- return ((string)(this["R_MASTER"]));
87- }
88- }
89-
9038 [global::System.Configuration.UserScopedSettingAttribute()]
9139 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
9240 [global::System.Configuration.DefaultSettingValueAttribute("1")]
@@ -323,5 +271,16 @@
323271 return ((int)(this["CommandTimeout"]));
324272 }
325273 }
274+
275+ [global::System.Configuration.ApplicationScopedSettingAttribute()]
276+ [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
277+ [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
278+ [global::System.Configuration.DefaultSettingValueAttribute("Data Source=localhost\\sqlexpress;Initial Catalog=master;Integrated Security=True;" +
279+ "Connect Timeout=30")]
280+ public string KB {
281+ get {
282+ return ((string)(this["KB"]));
283+ }
284+ }
326285 }
327286 }
--- 2_source/4_顧客分析君CRM/顧客分析君/301計算.cs (revision 574)
+++ 2_source/4_顧客分析君CRM/顧客分析君/301計算.cs (revision 575)
@@ -1490,7 +1490,7 @@
14901490
14911491 お勧め商品_RFMを計算(7, 8);
14921492
1493- 緯度経度を計算(8, 8);
1493+ //緯度経度を計算(8, 8);
14941494
14951495 //計算条件を保存
14961496 計算条件保存();
Show on old repository browser