예제 #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
파일: FormAdmin.cs 프로젝트: wanbok/kiwi
        private void setDataForUse(excel.Worksheet worksheet1, excel.Worksheet worksheet2, out CBasicInput mBI, out CBusinessData mDI, out CResultData mRD)
        {
            mBI = new CBasicInput();
            mDI = new CBusinessData();
            mRD = new CResultData();

            if (worksheet1 == null || worksheet2 == null || mBI == null || mDI == null || mRD == null) return;

            //*******CBasicInput
            mBI.set통신사(worksheet1.get_Range("I63", Type.Missing).Value2.ToString());
            mBI.set지역(worksheet1.get_Range("C63", Type.Missing).Value2.ToString());
            mBI.set대리점(worksheet1.get_Range("E63", Type.Missing).Value2.ToString());
            mBI.set마케터(worksheet1.get_Range("G63", Type.Missing).Value2.ToString());

            //도매
            mBI.set도매_누적가입자수(worksheet1.get_Range("F7", Type.Missing).Value2.ToString());

            mBI.set도매_월평균판매대수_신규(worksheet1.get_Range("F8", Type.Missing).Value2.ToString());
            mBI.set도매_월평균판매대수_기변(worksheet1.get_Range("F9", Type.Missing).Value2.ToString());

            mBI.set도매_월평균유통모델출고대수_LG(worksheet1.get_Range("F11", Type.Missing).Value2.ToString());
            mBI.set도매_월평균유통모델출고대수_SS(worksheet1.get_Range("F12", Type.Missing).Value2.ToString());

            mBI.set도매_거래선수_개통사무실(worksheet1.get_Range("F14", Type.Missing).Value2.ToString());
            mBI.set도매_거래선수_판매점(worksheet1.get_Range("F16", Type.Missing).Value2.ToString());

            mBI.set도매_직원수_간부급(worksheet1.get_Range("F18", Type.Missing).Value2.ToString());
            mBI.set도매_직원수_평사원(worksheet1.get_Range("F19", Type.Missing).Value2.ToString());

            //소매
            mBI.set소매_월평균판매대수_신규(worksheet1.get_Range("G8", Type.Missing).Value2.ToString());
            mBI.set소매_월평균판매대수_기변(worksheet1.get_Range("G9", Type.Missing).Value2.ToString());

            mBI.set소매_거래선수_직영점(worksheet1.get_Range("G15", Type.Missing).Value2.ToString());

            mBI.set소매_직원수_간부급(worksheet1.get_Range("G18", Type.Missing).Value2.ToString());
            mBI.set소매_직원수_평사원(worksheet1.get_Range("G19", Type.Missing).Value2.ToString());

            //*******CBusinessData
            //도매
            mDI.set도매_수익_월평균관리수수료(worksheet1.get_Range("G26", Type.Missing).Value2.ToString());
            mDI.set도매_수익_CS관리수수료(worksheet1.get_Range("G27", Type.Missing).Value2.ToString());//월총액
            //mDI.set도매_수익_사업자모델매입관련추가수익(worksheet1.get_Range("G29", Type.Missing).Value2.ToString());
            //mDI.set도매_수익_유통모델매입관련추가수익_현금DC(worksheet1.get_Range("G30", Type.Missing).Value2.ToString());
            //mDI.set도매_수익_유통모델매입관련추가수익_VolumeDC(worksheet1.get_Range("G31", Type.Missing).Value2.ToString());
            mDI.set도매_비용_대리점투자금액_신규(worksheet1.get_Range("G32", Type.Missing).Value2.ToString());
            mDI.set도매_비용_대리점투자금액_기변(worksheet1.get_Range("G33", Type.Missing).Value2.ToString());
            mDI.set도매_비용_직원급여_간부급(worksheet1.get_Range("G36", Type.Missing).Value2.ToString());
            mDI.set도매_비용_직원급여_평사원(worksheet1.get_Range("G37", Type.Missing).Value2.ToString());
            mDI.set도매_비용_지급임차료(worksheet1.get_Range("G38", Type.Missing).Value2.ToString());
            mDI.set도매_비용_운반비(worksheet1.get_Range("G39", Type.Missing).Value2.ToString());
            mDI.set도매_비용_차량유지비(worksheet1.get_Range("G40", Type.Missing).Value2.ToString());
            mDI.set도매_비용_지급수수료(worksheet1.get_Range("G41", Type.Missing).Value2.ToString());
            mDI.set도매_비용_판매촉진비(worksheet1.get_Range("G42", Type.Missing).Value2.ToString());
            mDI.set도매_비용_건물관리비(worksheet1.get_Range("G43", Type.Missing).Value2.ToString());

            mDI.set소매_수익_월평균업무취급수수료(worksheet1.get_Range("G44", Type.Missing).Value2.ToString());
            mDI.set소매_수익_직영매장판매수익(worksheet1.get_Range("G45", Type.Missing).Value2.ToString());
            mDI.set소매_비용_직원급여_간부급(worksheet1.get_Range("G48", Type.Missing).Value2.ToString());
            mDI.set소매_비용_직원급여_평사원(worksheet1.get_Range("G49", Type.Missing).Value2.ToString());
            mDI.set소매_비용_지급임차료(worksheet1.get_Range("G50", Type.Missing).Value2.ToString());
            mDI.set소매_비용_지급수수료(worksheet1.get_Range("G51", Type.Missing).Value2.ToString());
            mDI.set소매_비용_판매촉진비(worksheet1.get_Range("G52", Type.Missing).Value2.ToString());
            mDI.set소매_비용_건물관리비(worksheet1.get_Range("G53", Type.Missing).Value2.ToString());

            mDI.set도소매_비용_복리후생비(worksheet1.get_Range("G54", Type.Missing).Value2.ToString());
            mDI.set도소매_비용_통신비(worksheet1.get_Range("G55", Type.Missing).Value2.ToString());
            mDI.set도소매_비용_공과금(worksheet1.get_Range("G56", Type.Missing).Value2.ToString());
            mDI.set도소매_비용_소모품비(worksheet1.get_Range("G57", Type.Missing).Value2.ToString());
            mDI.set도소매_비용_이자비용(worksheet1.get_Range("G58", Type.Missing).Value2.ToString());
            //mDI.set도소매_비용_부가세(worksheet1.get_Range("G59", Type.Missing).Value2.ToString());
            //mDI.set도소매_비용_법인세(worksheet1.get_Range("G60", Type.Missing).Value2.ToString());
            mDI.set도소매_비용_기타(worksheet1.get_Range("G61", Type.Missing).Value2.ToString());

            //*******CResultData
            mRD.set도매_수익_가입자관리수수료(worksheet2.get_Range("J7", Type.Missing).Value2.ToString());
            mRD.set도매_수익_CS관리수수료(worksheet2.get_Range("J8", Type.Missing).Value2.ToString());
            mRD.set소매_수익_업무취급수수료(worksheet2.get_Range("J9", Type.Missing).Value2.ToString());
            mRD.set도매_수익_사업자모델매입에따른추가수익(worksheet2.get_Range("J10", Type.Missing).Value2.ToString());
            mRD.set도매_수익_유통모델매입에따른추가수익_현금_Volume(worksheet2.get_Range("J11", Type.Missing).Value2.ToString());
            mRD.set소매_수익_직영매장판매수익(worksheet2.get_Range("J12", Type.Missing).Value2.ToString());
            mRD.set전체_비용_대리점투자비용(worksheet2.get_Range("J14", Type.Missing).Value2.ToString());
            mRD.set전체_비용_인건비_급여_복리후생비(worksheet2.get_Range("J15", Type.Missing).Value2.ToString());
            mRD.set전체_비용_임차료(worksheet2.get_Range("J16", Type.Missing).Value2.ToString());
            mRD.set전체_비용_이자비용(worksheet2.get_Range("J17", Type.Missing).Value2.ToString());
            mRD.set전체_비용_부가세(worksheet2.get_Range("J18", Type.Missing).Value2.ToString());
            mRD.set전체_비용_법인세(worksheet2.get_Range("J19", Type.Missing).Value2.ToString());
            mRD.set전체_비용_기타판매관리비(worksheet2.get_Range("J20", Type.Missing).Value2.ToString());

            mRD.set도매_비용_대리점투자비용(worksheet2.get_Range("J33", Type.Missing).Value2.ToString());
            mRD.set도매_비용_인건비_급여_복리후생비(worksheet2.get_Range("J34", Type.Missing).Value2.ToString());
            mRD.set도매_비용_임차료(worksheet2.get_Range("J35", Type.Missing).Value2.ToString());
            mRD.set도매_비용_이자비용(worksheet2.get_Range("J36", Type.Missing).Value2.ToString());
            mRD.set도매_비용_부가세(worksheet2.get_Range("J37", Type.Missing).Value2.ToString());
            mRD.set도매_비용_법인세(worksheet2.get_Range("J38", Type.Missing).Value2.ToString());
            mRD.set도매_비용_기타판매관리비(worksheet2.get_Range("J39", Type.Missing).Value2.ToString());

            mRD.set소매_비용_인건비_급여_복리후생비(worksheet2.get_Range("J49", Type.Missing).Value2.ToString());
            mRD.set소매_비용_임차료(worksheet2.get_Range("J50", Type.Missing).Value2.ToString());
            mRD.set소매_비용_이자비용(worksheet2.get_Range("J51", Type.Missing).Value2.ToString());
            mRD.set소매_비용_부가세(worksheet2.get_Range("J52", Type.Missing).Value2.ToString());
            mRD.set소매_비용_법인세(worksheet2.get_Range("J53", Type.Missing).Value2.ToString());
            mRD.set소매_비용_기타판매관리비(worksheet2.get_Range("J54", Type.Missing).Value2.ToString());
        }
예제 #3
0
파일: FormAdmin.cs 프로젝트: wanbok/kiwi
        private void setDataForUse(String filepath, String spliter, out CBasicInput mBI, out CBusinessData mDI, out CResultData mRD)
        {
            mBI = new CBasicInput();
            mDI = new CBusinessData();
            mRD = new CResultData();

            if (filepath == null || mBI == null || mDI == null || mRD == null) return;

            CReportData reportData = new CReportData();
            String lge = CommonUtil.Base64Decode(System.IO.File.ReadAllText(filepath));
            String[] splittedLge = lge.Split(spliter.ToCharArray());

            int startIndex = 0;
            int length = 7;
            String[] param = splittedLge.Take(length).ToArray<String>();
            reportData.setArrData(param);

            mBI.set통신사(reportData.get통신사());
            mBI.set지역(reportData.get지역());
            mBI.set대리점(reportData.get대리점());
            mBI.set마케터(reportData.get마케터());

            startIndex += length;
            length = 14;
            param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            mBI.setArrData(param);
            startIndex += length;
            length = 31;
            param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            mDI.setArrData(param);
            startIndex += length;
            length = 42;
            //param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            //CDataControl.g_FileResultBusinessTotal.setArrayOutput전체(param);
            startIndex += length;
            //param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            //CDataControl.g_FileResultBusiness.setArrayOutput전체(param);
            startIndex += length;
            //param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            //CDataControl.g_FileResultStoreTotal.setArrayOutput전체(param);
            startIndex += length;
            param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            mRD.setArrayOutput전체(param);
            //startIndex += length;
            //param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            //CDataControl.g_FileResultFutureTotal.setArrayOutput전체(param);
            //startIndex += length;
            //param = splittedLge.Skip(startIndex).Take(length).ToArray<String>();
            //CDataControl.g_FileResultFuture.setArrayOutput전체(param);
        }