예제 #1
0
파일: CommonUtil.cs 프로젝트: wanbok/kiwi
 public static void deepCopyBasicInput(CBasicInput srcBasicInput, CBasicInput dstBasicInput)
 {
     dstBasicInput.set통신사(srcBasicInput.get통신사());
     dstBasicInput.set지역(srcBasicInput.get지역());
     dstBasicInput.set대리점(srcBasicInput.get대리점());
     dstBasicInput.set마케터(srcBasicInput.get마케터());
     dstBasicInput.setArrData(srcBasicInput.getArrData());
 }
예제 #2
0
파일: CommonUtil.cs 프로젝트: wanbok/kiwi
        /// <summary>
        /// 
        /// </summary>
        /// <param name="_WorkSheet"></param>
        public static void WriteDataToExcelFileDasicInput(excel.Worksheet _WorkSheet, CBasicInput g_BasicInput)
        {
            _WorkSheet.get_Range("I63", Type.Missing).Value2 = g_BasicInput.get통신사();
            _WorkSheet.get_Range("C63", Type.Missing).Value2 = g_BasicInput.get지역();
            _WorkSheet.get_Range("E63", Type.Missing).Value2 = g_BasicInput.get대리점();
            _WorkSheet.get_Range("G63", Type.Missing).Value2 = g_BasicInput.get마케터();

            //도매
            _WorkSheet.get_Range("F7", Type.Missing).Value2 = g_BasicInput.get도매_누적가입자수();

            _WorkSheet.get_Range("F8", Type.Missing).Value2 = g_BasicInput.get도매_월평균판매대수_신규();
            _WorkSheet.get_Range("F9", Type.Missing).Value2 = g_BasicInput.get도매_월평균판매대수_기변();
            _WorkSheet.get_Range("F10", Type.Missing).Value2 = g_BasicInput.get도매_월평균판매대수_소계();

            _WorkSheet.get_Range("F11", Type.Missing).Value2 = g_BasicInput.get도매_월평균유통모델출고대수_LG();
            _WorkSheet.get_Range("F12", Type.Missing).Value2 = g_BasicInput.get도매_월평균유통모델출고대수_SS();
            _WorkSheet.get_Range("F13", Type.Missing).Value2 = g_BasicInput.get도매_월평균유통모델출고대수_소계();

            _WorkSheet.get_Range("F14", Type.Missing).Value2 = g_BasicInput.get도매_거래선수_개통사무실();
            _WorkSheet.get_Range("F16", Type.Missing).Value2 = g_BasicInput.get도매_거래선수_판매점();
            _WorkSheet.get_Range("F17", Type.Missing).Value2 = g_BasicInput.get도매_거래선수_소계();

            _WorkSheet.get_Range("F18", Type.Missing).Value2 = g_BasicInput.get도매_직원수_간부급();
            _WorkSheet.get_Range("F19", Type.Missing).Value2 = g_BasicInput.get도매_직원수_평사원();
            _WorkSheet.get_Range("F20", Type.Missing).Value2 = g_BasicInput.get도매_직원수_소계();

            //소매
            _WorkSheet.get_Range("G8", Type.Missing).Value2 = g_BasicInput.get소매_월평균판매대수_신규();
            _WorkSheet.get_Range("G9", Type.Missing).Value2 = g_BasicInput.get소매_월평균판매대수_기변();
            _WorkSheet.get_Range("G10", Type.Missing).Value2 = g_BasicInput.get소매_월평균판매대수_소계();

            _WorkSheet.get_Range("G15", Type.Missing).Value2 = g_BasicInput.get소매_거래선수_직영점();
            _WorkSheet.get_Range("G17", Type.Missing).Value2 = g_BasicInput.get소매_거래선수_소계();

            _WorkSheet.get_Range("G18", Type.Missing).Value2 = g_BasicInput.get소매_직원수_간부급();
            _WorkSheet.get_Range("G19", Type.Missing).Value2 = g_BasicInput.get소매_직원수_평사원();
            _WorkSheet.get_Range("G20", Type.Missing).Value2 = g_BasicInput.get소매_직원수_소계();

            //합계
            _WorkSheet.get_Range("H7", Type.Missing).Value2 = g_BasicInput.get누적가입자수_합계();

            _WorkSheet.get_Range("H8", Type.Missing).Value2 = g_BasicInput.get월평균판매대수_신규_합계();
            _WorkSheet.get_Range("H9", Type.Missing).Value2 = g_BasicInput.get월평균판매대수_기변_합계();
            _WorkSheet.get_Range("H10", Type.Missing).Value2 = g_BasicInput.get월평균판매대수_소계_합계();

            _WorkSheet.get_Range("H11", Type.Missing).Value2 = g_BasicInput.get월평균유통모델출고대수_LG_합계();
            _WorkSheet.get_Range("H12", Type.Missing).Value2 = g_BasicInput.get월평균유통모델출고대수_SS_합계();
            _WorkSheet.get_Range("H13", Type.Missing).Value2 = g_BasicInput.get월평균유통모델출고대수_소계_합계();

            _WorkSheet.get_Range("H14", Type.Missing).Value2 = g_BasicInput.get거래선수_개통사무실_합계();
            _WorkSheet.get_Range("H15", Type.Missing).Value2 = g_BasicInput.get거래선수_직영점_합계();
            _WorkSheet.get_Range("H16", Type.Missing).Value2 = g_BasicInput.get거래선수_판매점_합계();
            _WorkSheet.get_Range("H17", Type.Missing).Value2 = g_BasicInput.get거래선수_소계_합계();

            _WorkSheet.get_Range("H18", Type.Missing).Value2 = g_BasicInput.get직원수_간부급_합계();
            _WorkSheet.get_Range("H19", Type.Missing).Value2 = g_BasicInput.get직원수_평사원_합계();
            _WorkSheet.get_Range("H20", Type.Missing).Value2 = g_BasicInput.get직원수_소계_합계();
        }