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());
}
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());
}
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);
}
