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());
}
public void GetData(int index, out String key, out String 통신사, out String 지역, out String 대리점명, out String 마케터, out String 단위당손익, out String 월capa, out String 가입자수,
out String 직영점판매수익, out String 선택여부, out String mExcelFileName,
out CBasicInput mBI, out CBusinessData mDI, out CResultData mRD)
{
key = "";
통신사 = "";
지역 = "";
대리점명 = "";
마케터 = "";
단위당손익 = "";
월capa = "";
가입자수 = "";
직영점판매수익 = "";
선택여부 = "N";
mExcelFileName = "";
mBI = new CBasicInput();
mDI = new CBusinessData();
mRD = new CResultData();
if (mXmlDoc != null)
{
XmlNode nodeItems = mXmlDoc.FirstChild;
XmlNode nodeItem = nodeItems.ChildNodes.Item(index);
foreach (XmlNode nodeItem2 in nodeItem)
{
switch (nodeItem2.Name)
{
case "key":
key = nodeItem2.InnerText;
break;
case "지역":
지역 = nodeItem2.InnerText;
break;
case "통신사":
통신사 = nodeItem2.InnerText;
break;
case "대리점명":
대리점명 = nodeItem2.InnerText;
break;
case "마케터":
마케터 = nodeItem2.InnerText;
break;
case "단위당손익":
단위당손익 = nodeItem2.InnerText;
break;
case "월capa":
월capa = nodeItem2.InnerText;
break;
case "가입자수":
가입자수 = nodeItem2.InnerText;
break;
case "직영점판매수익":
직영점판매수익 = nodeItem2.InnerText;
break;
case "선택여부":
선택여부 = nodeItem2.InnerText;
break;
case "mExcelFileName":
mExcelFileName = nodeItem2.InnerText;
break;
//기본입력 데이터
case "기본입력_도매_누적가입자수":
mBI.set도매_누적가입자수(nodeItem2.InnerText);
break;
case "기본입력_도매_월평균판매대수_신규":
mBI.set도매_월평균판매대수_신규(nodeItem2.InnerText);
break;
case "기본입력_도매_월평균판매대수_기변":
mBI.set도매_월평균판매대수_기변(nodeItem2.InnerText);
break;
case "기본입력_도매_월평균유통모델출고대수_LG":
mBI.set도매_월평균유통모델출고대수_LG(nodeItem2.InnerText);
break;
case "기본입력_도매_월평균유통모델출고대수_SS":
mBI.set도매_월평균유통모델출고대수_SS(nodeItem2.InnerText);
break;
case "기본입력_도매_거래선수_개통사무실":
mBI.set도매_거래선수_개통사무실(nodeItem2.InnerText);
break;
case "기본입력_도매_거래선수_판매점":
mBI.set도매_거래선수_판매점(nodeItem2.InnerText);
break;
case "기본입력_도매_직원수_간부급":
mBI.set도매_직원수_간부급(nodeItem2.InnerText);
break;
case "기본입력_도매_직원수_평사원":
mBI.set도매_직원수_평사원(nodeItem2.InnerText);
break;
case "기본입력_소매_월평균판매대수_신규":
mBI.set소매_월평균판매대수_신규(nodeItem2.InnerText);
break;
case "기본입력_소매_월평균판매대수_기변":
mBI.set소매_월평균판매대수_기변(nodeItem2.InnerText);
break;
case "기본입력_소매_거래선수_직영점":
mBI.set소매_거래선수_직영점(nodeItem2.InnerText);
break;
case "기본입력_소매_직원수_간부급":
mBI.set소매_직원수_간부급(nodeItem2.InnerText);
break;
case "기본입력_소매_직원수_평사원":
mBI.set소매_직원수_평사원(nodeItem2.InnerText);
break;
//상세입력 데이터
case "상세입력_도매_수익_월평균관리수수료":
mDI.set도매_수익_월평균관리수수료(nodeItem2.InnerText);
break;
case "상세입력_도매_수익_CS관리수수료":
mDI.set도매_수익_CS관리수수료(nodeItem2.InnerText);
break;
case "상세입력_도매_수익_사업자모델매입관련추가수익":
mDI.set도매_수익_사업자모델매입관련추가수익(nodeItem2.InnerText);
break;
case "상세입력_도매_수익_유통모델매입관련추가수익_현금DC":
mDI.set도매_수익_유통모델매입관련추가수익_현금DC(nodeItem2.InnerText);
break;
case "상세입력_도매_수익_유통모델매입관련추가수익_VolumeDC":
mDI.set도매_수익_유통모델매입관련추가수익_VolumeDC(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_대리점투자금액_신규":
mDI.set도매_비용_대리점투자금액_신규(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_대리점투자금액_기변":
mDI.set도매_비용_대리점투자금액_기변(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_직원급여_간부급":
mDI.set도매_비용_직원급여_간부급(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_직원급여_평사원":
mDI.set도매_비용_직원급여_평사원(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_지급임차료":
mDI.set도매_비용_지급임차료(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_운반비":
mDI.set도매_비용_운반비(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_차량유지비":
mDI.set도매_비용_차량유지비(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_지급수수료":
mDI.set도매_비용_지급수수료(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_판매촉진비":
mDI.set도매_비용_판매촉진비(nodeItem2.InnerText);
break;
case "상세입력_도매_비용_건물관리비":
mDI.set도매_비용_건물관리비(nodeItem2.InnerText);
break;
case "상세입력_소매_수익_월평균업무취급수수료":
mDI.set소매_수익_월평균업무취급수수료(nodeItem2.InnerText);
break;
case "상세입력_소매_수익_직영매장판매수익":
mDI.set소매_수익_직영매장판매수익(nodeItem2.InnerText);
break;
case "상세입력_소매_비용_직원급여_간부급":
mDI.set소매_비용_직원급여_간부급(nodeItem2.InnerText);
break;
case "상세입력_소매_비용_직원급여_평사원":
mDI.set소매_비용_직원급여_평사원(nodeItem2.InnerText);
break;
case "상세입력_소매_비용_지급임차료":
mDI.set소매_비용_지급임차료(nodeItem2.InnerText);
break;
case "상세입력_소매_비용_지급수수료":
mDI.set소매_비용_지급수수료(nodeItem2.InnerText);
break;
case "상세입력_소매_비용_판매촉진비":
mDI.set소매_비용_판매촉진비(nodeItem2.InnerText);
break;
case "상세입력_소매_비용_건물관리비":
mDI.set소매_비용_건물관리비(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_복리후생비":
mDI.set도소매_비용_복리후생비(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_통신비":
mDI.set도소매_비용_통신비(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_공과금":
mDI.set도소매_비용_공과금(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_소모품비":
mDI.set도소매_비용_소모품비(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_이자비용":
mDI.set도소매_비용_이자비용(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_부가세":
mDI.set도소매_비용_부가세(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_법인세":
mDI.set도소매_비용_법인세(nodeItem2.InnerText);
break;
case "상세입력_도소매_비용_기타":
mDI.set도소매_비용_기타(nodeItem2.InnerText);
break;
//결과 단위당 데이터
case "결과_도매_수익_가입자관리수수료":
mRD.set도매_수익_가입자관리수수료(nodeItem2.InnerText);
break;
case "결과_도매_수익_CS관리수수료":
mRD.set도매_수익_CS관리수수료(nodeItem2.InnerText);
break;
case "결과_소매_수익_업무취급수수료":
mRD.set소매_수익_업무취급수수료(nodeItem2.InnerText);
break;
case "결과_도매_수익_사업자모델매입에따른추가수익":
mRD.set도매_수익_사업자모델매입에따른추가수익(nodeItem2.InnerText);
break;
case "결과_도매_수익_유통모델매입에따른추가수익_현금_Volume":
mRD.set도매_수익_유통모델매입에따른추가수익_현금_Volume(nodeItem2.InnerText);
break;
case "결과_소매_수익_직영매장판매수익":
mRD.set소매_수익_직영매장판매수익(nodeItem2.InnerText);
break;
case "결과_전체_비용_대리점투자비용":
mRD.set전체_비용_대리점투자비용(nodeItem2.InnerText);
break;
case "결과_전체_비용_인건비_급여_복리후생비":
mRD.set전체_비용_인건비_급여_복리후생비(nodeItem2.InnerText);
break;
case "결과_전체_비용_임차료":
mRD.set전체_비용_임차료(nodeItem2.InnerText);
break;
case "결과_전체_비용_이자비용":
mRD.set전체_비용_이자비용(nodeItem2.InnerText);
break;
case "결과_전체_비용_부가세":
mRD.set전체_비용_부가세(nodeItem2.InnerText);
break;
case "결과_전체_비용_법인세":
mRD.set전체_비용_법인세(nodeItem2.InnerText);
break;
case "결과_도매_비용_대리점투자비용":
mRD.set도매_비용_대리점투자비용(nodeItem2.InnerText);
break;
case "결과_도매_비용_인건비_급여_복리후생비":
mRD.set도매_비용_인건비_급여_복리후생비(nodeItem2.InnerText);
break;
case "결과_도매_비용_임차료":
mRD.set도매_비용_임차료(nodeItem2.InnerText);
break;
case "결과_도매_비용_이자비용":
mRD.set도매_비용_이자비용(nodeItem2.InnerText);
break;
case "결과_도매_비용_부가세":
mRD.set도매_비용_부가세(nodeItem2.InnerText);
break;
case "결과_도매_비용_법인세":
mRD.set도매_비용_법인세(nodeItem2.InnerText);
break;
case "결과_도매_비용_기타판매관리비":
mRD.set도매_비용_기타판매관리비(nodeItem2.InnerText);
break;
case "결과_소매_비용_인건비_급여_복리후생비":
mRD.set소매_비용_인건비_급여_복리후생비(nodeItem2.InnerText);
break;
case "결과_소매_비용_임차료":
mRD.set소매_비용_임차료(nodeItem2.InnerText);
break;
case "결과_소매_비용_이자비용":
mRD.set소매_비용_이자비용(nodeItem2.InnerText);
break;
case "결과_소매_비용_부가세":
mRD.set소매_비용_부가세(nodeItem2.InnerText);
break;
case "결과_소매_비용_법인세":
mRD.set소매_비용_법인세(nodeItem2.InnerText);
break;
case "결과_소매_비용_기타판매관리비":
mRD.set소매_비용_기타판매관리비(nodeItem2.InnerText);
break;
}
}
}
}