public static CResultData g_SimResultStoreTotal = new CResultData(); //시뮬레이션 당대리점 총계
#endregion Fields
#region Methods
internal static void clearAllData()
{
g_BasicInput = new CBasicInput(); //기본입력
g_DetailInput = new CBusinessData(); //상세입력
//설정된 업계평균은 레지스트리 또는 파일에 항상 가지고 있어야 함.
//파일 실행시 레지스트리 또는 파일에서 읽어 변수에 세팅
g_BusinessAvg = new CBusinessData(); //업계평균, 관리자가 배포한 데이타 및 현재 클라이언트 계산에 적용하는 값
g_ResultBusinessTotal = new CResultData(); //업계 총계
g_ResultBusiness = new CResultData(); //업계 단위금액
g_ResultStoreTotal = new CResultData(); //당대리점 총계
g_ResultStore = new CResultData(); //당대리점 단위금액
g_ResultFutureTotal = new CResultData(); //미래수익 총계
g_ResultFuture = new CResultData(); //미래수익 단위금액
//파일에서 읽은 데이터 저장 용
//기본입력(g_BasicInput)과 상세입력(g_DetailInput)에 입력하여 현재세팅된 업계평균을 적용하여 결과를 계산할 수 있다
//계산 없이 결과를 보기위해 g_FileResultBusinessTotal등의 아래값을 출력하면 됨
g_FileBasicInput = new CBasicInput(); //파일에서 읽은 기본입력
g_FileDetailInput = new CBusinessData(); //파일에서 읽은 상세입력
//public static CBusinessData g_FileBusinessAvg; //파일에서 읽은 업계평균
g_FileResultBusinessTotal = new CResultData(); //업계 총계
g_FileResultBusiness = new CResultData(); //업계 단위금액
g_FileResultStoreTotal = new CResultData(); //당대리점 총계
g_FileResultStore = new CResultData(); //당대리점 단위금액
g_FileResultFutureTotal = new CResultData(); //미래수익 총계
g_FileResultFuture = new CResultData(); //미래수익 단위금액
//보고서용 데이터
g_ReportData = new CReportData(); // 리포트에 추가적으로 들어갈 자료(이름, 코멘트 등)
clearSimulData();
}
private void setDataTableForAnalysis(DataTable[] tables, CResultData total, CResultData agency, CBusinessData bd)
{
if (total == null || agency == null) return;
for (int j = 0; j < tables.Length; j++)
{
DataTable t = tables[j];
DataRow r = t.NewRow();
Double[] totalArr = null;
Double[] agencyArr = null;
switch (j) {
case 0:
totalArr = total.getArr전체_리포트용(bd);
agencyArr = agency.getArr전체_리포트용(bd);
break;
case 1:
//totalArr = total.getArr전체_리포트용(bd);
//agencyArr = agency.getArr전체_리포트용(bd);
totalArr = total.getArr도매_수익_비용_및_계산포함();
agencyArr = agency.getArr도매_수익_비용_및_계산포함();
break;
case 2:
totalArr = total.getArr소매_수익_비용_및_계산포함();
agencyArr = agency.getArr소매_수익_비용_및_계산포함();
break;
}
for (int i = 0; i < totalArr.Length; i++)
{
r[i * 2] = getAddCommar(totalArr[i]);
r[i * 2 + 1] = getAddCommar(agencyArr[i]);
}
t.Rows.Add(r);
}
}
internal static void clearSimulData()
{
g_SimBasicInput = new CBasicInput(); //시뮬레이션 기본입력
g_SimDetailInput = new CBusinessData(); //시뮬레이션 상세입력
g_SimResultBusinessTotal = new CResultData(); //시뮬레이션 업계 총계
g_SimResultBusiness = new CResultData(); //시뮬레이션 업계 단위금액
g_SimResultStoreTotal = new CResultData(); //시뮬레이션 당대리점 총계
g_SimResultStore = new CResultData(); //시뮬레이션 당대리점 단위금액
g_SimResultFutureTotal = new CResultData(); //시뮬레이션 미래수익 총계
g_SimResultFuture = new CResultData(); //시뮬레이션 미래수익 단위금액
}
/// <summary>
///
/// </summary>
/// <param name="_WorkSheet"></param>
public static void WriteExcelFileToDataResultBusiness(excel.Worksheet _WorkSheet, CResultData businessTotal, CResultData business)
{
_WorkSheet.get_Range("D7", Type.Missing).Value2 = businessTotal.전체_수익_가입자관리수수료;
_WorkSheet.get_Range("D8", Type.Missing).Value2 = businessTotal.전체_수익_CS관리수수료;
_WorkSheet.get_Range("D9", Type.Missing).Value2 = businessTotal.전체_수익_업무취급수수료;
_WorkSheet.get_Range("D10", Type.Missing).Value2 = businessTotal.전체_수익_사업자모델매입에따른추가수익;
_WorkSheet.get_Range("D11", Type.Missing).Value2 = businessTotal.전체_수익_유통모델매입에따른추가수익_현금_Volume;
_WorkSheet.get_Range("D12", Type.Missing).Value2 = businessTotal.전체_수익_직영매장판매수익;
_WorkSheet.get_Range("D13", Type.Missing).Value2 = businessTotal.전체_수익_소계;
_WorkSheet.get_Range("D14", Type.Missing).Value2 = businessTotal.get전체_비용_대리점투자비용();
_WorkSheet.get_Range("D15", Type.Missing).Value2 = businessTotal.get전체_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("D16", Type.Missing).Value2 = businessTotal.get전체_비용_임차료();
_WorkSheet.get_Range("D17", Type.Missing).Value2 = businessTotal.get전체_비용_이자비용();
_WorkSheet.get_Range("D18", Type.Missing).Value2 = businessTotal.get전체_비용_부가세();
_WorkSheet.get_Range("D19", Type.Missing).Value2 = businessTotal.get전체_비용_법인세();
_WorkSheet.get_Range("D20", Type.Missing).Value2 = businessTotal.get전체_비용_기타판매관리비();
_WorkSheet.get_Range("D21", Type.Missing).Value2 = businessTotal.전체_비용_소계;
_WorkSheet.get_Range("D22", Type.Missing).Value2 = businessTotal.전체손익계;
_WorkSheet.get_Range("D28", Type.Missing).Value2 = businessTotal.get도매_수익_가입자관리수수료();
_WorkSheet.get_Range("D29", Type.Missing).Value2 = businessTotal.get도매_수익_CS관리수수료();
_WorkSheet.get_Range("D30", Type.Missing).Value2 = businessTotal.get도매_수익_사업자모델매입에따른추가수익();
_WorkSheet.get_Range("D31", Type.Missing).Value2 = businessTotal.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
_WorkSheet.get_Range("D32", Type.Missing).Value2 = businessTotal.도매_수익_소계;
_WorkSheet.get_Range("D33", Type.Missing).Value2 = businessTotal.get도매_비용_대리점투자비용();
_WorkSheet.get_Range("D34", Type.Missing).Value2 = businessTotal.get도매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("D35", Type.Missing).Value2 = businessTotal.get도매_비용_임차료();
_WorkSheet.get_Range("D36", Type.Missing).Value2 = businessTotal.get도매_비용_이자비용();
_WorkSheet.get_Range("D37", Type.Missing).Value2 = businessTotal.get도매_비용_부가세();
_WorkSheet.get_Range("D38", Type.Missing).Value2 = businessTotal.get도매_비용_법인세();
_WorkSheet.get_Range("D39", Type.Missing).Value2 = businessTotal.get도매_비용_기타판매관리비();
_WorkSheet.get_Range("D40", Type.Missing).Value2 = businessTotal.도매_비용_소계;
_WorkSheet.get_Range("D41", Type.Missing).Value2 = businessTotal.도매손익계;
_WorkSheet.get_Range("D46", Type.Missing).Value2 = businessTotal.get소매_수익_업무취급수수료();
_WorkSheet.get_Range("D47", Type.Missing).Value2 = businessTotal.get소매_수익_직영매장판매수익();
_WorkSheet.get_Range("D48", Type.Missing).Value2 = businessTotal.소매_수익_소계;
_WorkSheet.get_Range("D49", Type.Missing).Value2 = businessTotal.get소매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("D50", Type.Missing).Value2 = businessTotal.get소매_비용_임차료();
_WorkSheet.get_Range("D51", Type.Missing).Value2 = businessTotal.get소매_비용_이자비용();
_WorkSheet.get_Range("D52", Type.Missing).Value2 = businessTotal.get소매_비용_부가세();
_WorkSheet.get_Range("D53", Type.Missing).Value2 = businessTotal.get소매_비용_법인세();
_WorkSheet.get_Range("D54", Type.Missing).Value2 = businessTotal.get소매_비용_기타판매관리비();
_WorkSheet.get_Range("D55", Type.Missing).Value2 = businessTotal.소매_비용_소계;
_WorkSheet.get_Range("D56", Type.Missing).Value2 = businessTotal.소매손익계;
_WorkSheet.get_Range("D57", Type.Missing).Value2 = businessTotal.점별손익추정;
_WorkSheet.get_Range("E7", Type.Missing).Value2 = business.전체_수익_가입자관리수수료;
_WorkSheet.get_Range("E8", Type.Missing).Value2 = business.전체_수익_CS관리수수료;
_WorkSheet.get_Range("E9", Type.Missing).Value2 = business.전체_수익_업무취급수수료;
_WorkSheet.get_Range("E10", Type.Missing).Value2 = business.전체_수익_사업자모델매입에따른추가수익;
_WorkSheet.get_Range("E11", Type.Missing).Value2 = business.전체_수익_유통모델매입에따른추가수익_현금_Volume;
_WorkSheet.get_Range("E12", Type.Missing).Value2 = business.전체_수익_직영매장판매수익;
_WorkSheet.get_Range("E13", Type.Missing).Value2 = business.전체_수익_소계;
_WorkSheet.get_Range("E14", Type.Missing).Value2 = business.get전체_비용_대리점투자비용();
_WorkSheet.get_Range("E15", Type.Missing).Value2 = business.get전체_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("E16", Type.Missing).Value2 = business.get전체_비용_임차료();
_WorkSheet.get_Range("E17", Type.Missing).Value2 = business.get전체_비용_이자비용();
_WorkSheet.get_Range("E18", Type.Missing).Value2 = business.get전체_비용_부가세();
_WorkSheet.get_Range("E19", Type.Missing).Value2 = business.get전체_비용_법인세();
_WorkSheet.get_Range("E20", Type.Missing).Value2 = business.get전체_비용_기타판매관리비();
_WorkSheet.get_Range("E21", Type.Missing).Value2 = business.전체_비용_소계;
_WorkSheet.get_Range("E22", Type.Missing).Value2 = business.전체손익계;
_WorkSheet.get_Range("E28", Type.Missing).Value2 = business.get도매_수익_가입자관리수수료();
_WorkSheet.get_Range("E29", Type.Missing).Value2 = business.get도매_수익_CS관리수수료();
_WorkSheet.get_Range("E30", Type.Missing).Value2 = business.get도매_수익_사업자모델매입에따른추가수익();
_WorkSheet.get_Range("E31", Type.Missing).Value2 = business.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
_WorkSheet.get_Range("E32", Type.Missing).Value2 = business.도매_수익_소계;
_WorkSheet.get_Range("E33", Type.Missing).Value2 = business.get도매_비용_대리점투자비용();
_WorkSheet.get_Range("E34", Type.Missing).Value2 = business.get도매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("E35", Type.Missing).Value2 = business.get도매_비용_임차료();
_WorkSheet.get_Range("E36", Type.Missing).Value2 = business.get도매_비용_이자비용();
_WorkSheet.get_Range("E37", Type.Missing).Value2 = business.get도매_비용_부가세();
_WorkSheet.get_Range("E38", Type.Missing).Value2 = business.get도매_비용_법인세();
_WorkSheet.get_Range("E39", Type.Missing).Value2 = business.get도매_비용_기타판매관리비();
_WorkSheet.get_Range("E40", Type.Missing).Value2 = business.도매_비용_소계;
_WorkSheet.get_Range("E41", Type.Missing).Value2 = business.도매손익계;
_WorkSheet.get_Range("E46", Type.Missing).Value2 = business.get소매_수익_업무취급수수료();
_WorkSheet.get_Range("E47", Type.Missing).Value2 = business.get소매_수익_직영매장판매수익();
_WorkSheet.get_Range("E48", Type.Missing).Value2 = business.소매_수익_소계;
_WorkSheet.get_Range("E49", Type.Missing).Value2 = business.get소매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("E50", Type.Missing).Value2 = business.get소매_비용_임차료();
_WorkSheet.get_Range("E51", Type.Missing).Value2 = business.get소매_비용_이자비용();
_WorkSheet.get_Range("E52", Type.Missing).Value2 = business.get소매_비용_부가세();
_WorkSheet.get_Range("E53", Type.Missing).Value2 = business.get소매_비용_법인세();
_WorkSheet.get_Range("E54", Type.Missing).Value2 = business.get소매_비용_기타판매관리비();
_WorkSheet.get_Range("E55", Type.Missing).Value2 = business.소매_비용_소계;
_WorkSheet.get_Range("E56", Type.Missing).Value2 = business.소매손익계;
_WorkSheet.get_Range("E57", Type.Missing).Value2 = business.점별손익추정;
}
internal static void setInputData(string[] txtWrite, string[] txtWrite2, CBasicInput bi, CBusinessData di, CResultData[] rdts, CResultData[] rds, CResultData rdt, CResultData rd, CResultData businessTotal, CResultData business)
{
bi.setArrData_BasicInput(txtWrite);
di.setArrData_DetailInput(txtWrite2);
CommonUtil.ReadFileManagerToData();
for (int i = 0; i < rdts.Length; i++)
{
// 당대리점 결과(현재:0, 미래:1)
rdt = rdts[i];
rd = rds[i];
// 도매
// 총액
// 수익
rdt.set도매_수익_가입자관리수수료(i == 0 ? di.get도매_수익_월평균관리수수료() : CommonUtil.Division(di.get도매_수익_월평균관리수수료(), bi.get도매_누적가입자수()) * 18 * bi.get월평균판매대수_소계_합계());
rdt.set도매_수익_CS관리수수료(i == 0 ? di.get도매_수익_CS관리수수료() : CommonUtil.Division(di.get도매_수익_CS관리수수료(), bi.get도매_누적가입자수()) * 18 * bi.get월평균판매대수_소계_합계());
rdt.set도매_수익_사업자모델매입에따른추가수익(di.get도매_수익_사업자모델매입관련추가수익());
rdt.set도매_수익_유통모델매입에따른추가수익_현금_Volume(di.get도매_수익_유통모델매입관련추가수익_현금DC() + di.get도매_수익_유통모델매입관련추가수익_VolumeDC());
rdt.도매_수익_소계 = rdt.get도매_수익_가입자관리수수료() + rdt.get도매_수익_CS관리수수료() + rdt.get도매_수익_사업자모델매입에따른추가수익() + rdt.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
// 비용
rdt.set도매_비용_대리점투자비용(di.get도매_비용_대리점투자금액_신규() * bi.get도매_월평균판매대수_신규() + di.get도매_비용_대리점투자금액_기변() * bi.get도매_월평균판매대수_기변());
rdt.set도매_비용_인건비_급여_복리후생비(
di.get도매_비용_직원급여_간부급() * bi.get도매_직원수_간부급() +
di.get도매_비용_직원급여_평사원() * bi.get도매_직원수_평사원() +
Convert.ToDouble(
CommonUtil.Division(
Convert.ToDouble(
di.get도소매_비용_복리후생비()
),
Convert.ToDouble(
bi.get월평균판매대수_소계_합계()
)
) * bi.get도매_월평균판매대수_소계()
)
);
rdt.set도매_비용_임차료(di.get도매_비용_지급임차료());
rdt.set도매_비용_이자비용(Convert.ToDouble(CommonUtil.Division(Convert.ToDouble(di.get도소매_비용_이자비용()), Convert.ToDouble(bi.get월평균판매대수_소계_합계())) * Convert.ToDouble(bi.get도매_월평균판매대수_소계())));
rdt.set도매_비용_부가세(Convert.ToDouble(CommonUtil.Division(Convert.ToDouble(di.get도소매_비용_부가세()), Convert.ToDouble(bi.get월평균판매대수_소계_합계())) * Convert.ToDouble(bi.get도매_월평균판매대수_소계())));
rdt.set도매_비용_법인세(Convert.ToDouble(CommonUtil.Division(Convert.ToDouble(di.get도소매_비용_법인세()), Convert.ToDouble(bi.get월평균판매대수_소계_합계())) * Convert.ToDouble(bi.get도매_월평균판매대수_소계())));
/* 기타판매관리비
* SUM(
* 'Input(기본+세부항목)'!F35,
* 'Input(기본+세부항목)'!F36,
* 'Input(기본+세부항목)'!F37,
* 'Input(기본+세부항목)'!F38,
* 'Input(기본+세부항목)'!F39
* )
* +
* (
* SUM(
* 'Input(기본+세부항목)'!F48, // 복리후생비
* 'Input(기본+세부항목)'!F49,
* 'Input(기본+세부항목)'!F50,
* 'Input(기본+세부항목)'!F51,
* 'Input(기본+세부항목)'!F53
* )
* / 'Input(기본+세부항목)'!G10 * 'Input(기본+세부항목)'!E10
* )
*/
rdt.set도매_비용_기타판매관리비(
di.get도매_비용_운반비() + di.get도매_비용_차량유지비() + di.get도매_비용_지급수수료() + di.get도매_비용_판매촉진비() + di.get도매_비용_건물관리비() +
Convert.ToDouble(
CommonUtil.Division(
Convert.ToDouble(
di.get도소매_비용_통신비() + di.get도소매_비용_공과금() + di.get도소매_비용_소모품비() + di.get도소매_비용_기타()
),
Convert.ToDouble(
bi.get월평균판매대수_소계_합계()
)
) * bi.get도매_월평균판매대수_소계()
)
);
rdt.도매_비용_소계 = rdt.get도매_비용_대리점투자비용() + rdt.get도매_비용_인건비_급여_복리후생비() + rdt.get도매_비용_임차료() + rdt.get도매_비용_이자비용() + rdt.get도매_비용_부가세() + rdt.get도매_비용_법인세() + rdt.get도매_비용_기타판매관리비();
rdt.도매손익계 = rdt.도매_수익_소계 - rdt.도매_비용_소계;
// 단위당 금액
// 수익
rd.set도매_수익_가입자관리수수료(CommonUtil.Division(rdt.get도매_수익_가입자관리수수료(), bi.get도매_월평균판매대수_소계()));
rd.set도매_수익_CS관리수수료(CommonUtil.Division(rdt.get도매_수익_CS관리수수료(), bi.get도매_월평균판매대수_소계()));
rd.set도매_수익_사업자모델매입에따른추가수익(CommonUtil.Division(rdt.get도매_수익_사업자모델매입에따른추가수익(), bi.get도매_월평균판매대수_소계()));
rd.set도매_수익_유통모델매입에따른추가수익_현금_Volume(CommonUtil.Division(rdt.get도매_수익_유통모델매입에따른추가수익_현금_Volume(), bi.get도매_월평균판매대수_소계()));
rd.도매_수익_소계 = CommonUtil.Division(rdt.도매_수익_소계, bi.get도매_월평균판매대수_소계());
// 비용
rd.set도매_비용_대리점투자비용(CommonUtil.Division(rdt.get도매_비용_대리점투자비용(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_인건비_급여_복리후생비(CommonUtil.Division(rdt.get도매_비용_인건비_급여_복리후생비(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_임차료(CommonUtil.Division(rdt.get도매_비용_임차료(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_이자비용(CommonUtil.Division(rdt.get도매_비용_이자비용(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_부가세(CommonUtil.Division(rdt.get도매_비용_부가세(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_법인세(CommonUtil.Division(rdt.get도매_비용_법인세(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_기타판매관리비(CommonUtil.Division(rdt.get도매_비용_기타판매관리비(), bi.get도매_월평균판매대수_소계()));
rd.도매_비용_소계 = CommonUtil.Division(rdt.도매_비용_소계, bi.get도매_월평균판매대수_소계());
rd.도매손익계 = CommonUtil.Division(rdt.도매손익계, bi.get도매_월평균판매대수_소계());
// 소매
// 총액
// 수익
rdt.set소매_수익_업무취급수수료(di.get소매_수익_월평균업무취급수수료());
rdt.set소매_수익_직영매장판매수익(di.get소매_수익_직영매장판매수익());
rdt.소매_수익_소계 = rdt.get소매_수익_업무취급수수료() + rdt.get소매_수익_직영매장판매수익();
// 비용
rdt.set소매_비용_인건비_급여_복리후생비(
di.get소매_비용_직원급여_간부급() * bi.get소매_직원수_간부급() +
di.get소매_비용_직원급여_평사원() * bi.get소매_직원수_평사원() +
Convert.ToDouble(
CommonUtil.Division(
Convert.ToDouble(
di.get도소매_비용_복리후생비()
),
Convert.ToDouble(
bi.get월평균판매대수_소계_합계()
)
) * bi.get소매_월평균판매대수_소계()
)
);
rdt.set소매_비용_임차료(di.get소매_비용_지급임차료());
rdt.set소매_비용_이자비용(CommonUtil.Division(di.get도소매_비용_이자비용(), bi.get월평균판매대수_소계_합계()) * bi.get소매_월평균판매대수_소계());
rdt.set소매_비용_부가세(CommonUtil.Division(di.get도소매_비용_부가세(), bi.get월평균판매대수_소계_합계()) * bi.get소매_월평균판매대수_소계());
rdt.set소매_비용_법인세(CommonUtil.Division(di.get도소매_비용_법인세(), bi.get월평균판매대수_소계_합계()) * bi.get소매_월평균판매대수_소계());
rdt.set소매_비용_기타판매관리비(
(
di.get소매_비용_지급수수료() + di.get소매_비용_판매촉진비() + di.get소매_비용_건물관리비()
) +
Convert.ToDouble(
CommonUtil.Division(
Convert.ToDouble(
di.get도소매_비용_통신비() + di.get도소매_비용_공과금() + di.get도소매_비용_소모품비() + di.get도소매_비용_기타()
),
Convert.ToDouble(bi.get월평균판매대수_소계_합계())
) *
bi.get소매_월평균판매대수_소계()
)
);
rdt.소매_비용_소계 = rdt.get소매_비용_인건비_급여_복리후생비() + rdt.get소매_비용_임차료() + rdt.get소매_비용_이자비용() + rdt.get소매_비용_부가세() + rdt.get소매_비용_법인세() + rdt.get소매_비용_기타판매관리비();
rdt.소매손익계 = rdt.소매_수익_소계 - rdt.소매_비용_소계;
rdt.점별손익추정 = CommonUtil.Division(rdt.소매손익계, bi.get거래선수_직영점_합계());
// 단위당 금액
// 수익
rd.set소매_수익_업무취급수수료(CommonUtil.Division(rdt.get소매_수익_업무취급수수료(), bi.get소매_월평균판매대수_소계()));
rd.set소매_수익_직영매장판매수익(CommonUtil.Division(rdt.get소매_수익_직영매장판매수익(), bi.get소매_월평균판매대수_소계()));
rd.소매_수익_소계 = CommonUtil.Division(rdt.소매_수익_소계, bi.get소매_월평균판매대수_소계());
// 비용
rd.set소매_비용_인건비_급여_복리후생비(CommonUtil.Division(rdt.get소매_비용_인건비_급여_복리후생비(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_임차료(CommonUtil.Division(rdt.get소매_비용_임차료(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_이자비용(CommonUtil.Division(rdt.get소매_비용_이자비용(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_부가세(CommonUtil.Division(rdt.get소매_비용_부가세(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_법인세(CommonUtil.Division(rdt.get소매_비용_법인세(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_기타판매관리비(CommonUtil.Division(rdt.get소매_비용_기타판매관리비(), bi.get소매_월평균판매대수_소계()));
rd.소매_비용_소계 = CommonUtil.Division(rdt.소매_비용_소계, bi.get소매_월평균판매대수_소계());
rd.소매손익계 = CommonUtil.Division(rdt.소매손익계, bi.get소매_월평균판매대수_소계());
rd.점별손익추정 = bi.get거래선수_직영점_합계();
// 전체
// 총액
// 수익
rdt.set전체_수익_가입자관리수수료(rdt.get도매_수익_가입자관리수수료());
rdt.set전체_수익_CS관리수수료(rdt.get도매_수익_CS관리수수료());
rdt.set전체_수익_업무취급수수료(rdt.get소매_수익_업무취급수수료());
rdt.set전체_수익_사업자모델매입에따른추가수익(rdt.get도매_수익_사업자모델매입에따른추가수익());
rdt.set전체_수익_유통모델매입에따른추가수익_현금_Volume(rdt.get도매_수익_유통모델매입에따른추가수익_현금_Volume());
rdt.set전체_수익_직영매장판매수익(rdt.get소매_수익_직영매장판매수익());
rdt.전체_수익_소계 = rdt.get전체_수익_가입자관리수수료() + rdt.get전체_수익_CS관리수수료() + rdt.get전체_수익_업무취급수수료() + rdt.get전체_수익_사업자모델매입에따른추가수익() + rdt.get전체_수익_유통모델매입에따른추가수익_현금_Volume() + rdt.get전체_수익_직영매장판매수익();
// 비용
rdt.set전체_비용_대리점투자비용(rdt.get도매_비용_대리점투자비용());
rdt.set전체_비용_인건비_급여_복리후생비(rdt.get도매_비용_인건비_급여_복리후생비() + rdt.get소매_비용_인건비_급여_복리후생비());
rdt.set전체_비용_임차료(rdt.get도매_비용_임차료() + rdt.get소매_비용_임차료());
rdt.set전체_비용_이자비용(di.get도소매_비용_이자비용());
rdt.set전체_비용_부가세(di.get도소매_비용_부가세());
rdt.set전체_비용_법인세(di.get도소매_비용_법인세());
//rdt.set전체_비용_기타판매관리비(di.get도매_비용_운반비() + di.get도매_비용_차량유지비() + di.get도매_비용_지급수수료() + di.get도매_비용_판매촉진비() + di.get도매_비용_건물관리비() + di.get소매_비용_지급수수료() + di.get소매_비용_판매촉진비() + di.get소매_비용_건물관리비() + di.get도소매_비용_통신비() + di.get도소매_비용_공과금() + di.get도소매_비용_소모품비() + di.get도소매_비용_기타());
rdt.set전체_비용_기타판매관리비(rdt.get도매_비용_기타판매관리비() + rdt.get소매_비용_기타판매관리비());
rdt.전체_비용_소계 = rdt.get전체_비용_대리점투자비용() + rdt.get전체_비용_인건비_급여_복리후생비() + rdt.get전체_비용_임차료() + rdt.get전체_비용_이자비용() + rdt.get전체_비용_부가세() + rdt.get전체_비용_법인세() + rdt.get전체_비용_기타판매관리비();
rdt.전체손익계 = rdt.전체_수익_소계 - rdt.전체_비용_소계;
// 단위당 금액
// 수익
rd.set전체_수익_가입자관리수수료(CommonUtil.Division(rdt.get전체_수익_가입자관리수수료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_CS관리수수료(CommonUtil.Division(rdt.get전체_수익_CS관리수수료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_업무취급수수료(CommonUtil.Division(rdt.get전체_수익_업무취급수수료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_사업자모델매입에따른추가수익(CommonUtil.Division(rdt.get전체_수익_사업자모델매입에따른추가수익(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_유통모델매입에따른추가수익_현금_Volume(CommonUtil.Division(rdt.get전체_수익_유통모델매입에따른추가수익_현금_Volume(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_직영매장판매수익(CommonUtil.Division(rdt.get전체_수익_직영매장판매수익(), bi.get월평균판매대수_소계_합계()));
rd.전체_수익_소계 = CommonUtil.Division(rdt.전체_수익_소계, bi.get월평균판매대수_소계_합계());
// 비용
rd.set전체_비용_대리점투자비용(CommonUtil.Division(rdt.get전체_비용_대리점투자비용(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_인건비_급여_복리후생비(CommonUtil.Division(rdt.get전체_비용_인건비_급여_복리후생비(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_임차료(CommonUtil.Division(rdt.get전체_비용_임차료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_이자비용(CommonUtil.Division(rdt.get전체_비용_이자비용(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_부가세(CommonUtil.Division(rdt.get전체_비용_부가세(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_법인세(CommonUtil.Division(rdt.get전체_비용_법인세(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_기타판매관리비(CommonUtil.Division(rdt.get전체_비용_기타판매관리비(), bi.get월평균판매대수_소계_합계()));
rd.전체_비용_소계 = CommonUtil.Division(rdt.전체_비용_소계, bi.get월평균판매대수_소계_합계());
rd.전체손익계 = CommonUtil.Division(rdt.전체손익계, bi.get월평균판매대수_소계_합계());
}
// 업계 평균적용 결과
Boolean isOver2000 = bi.get월평균판매대수_소계_합계() >= 2000;
rdt = businessTotal;
rd = business;
di = CDataControl.g_BusinessAvg; // 관리자가 배포한 업계 단위비용
// 도매
// 총액
// 수익
rdt.set도매_수익_가입자관리수수료(di.get도매_수익_월평균관리수수료() * bi.get도매_누적가입자수());
rdt.set도매_수익_CS관리수수료(di.get도매_수익_CS관리수수료() * bi.get도매_누적가입자수());
Double 사업자모델매입에따른추가수익_단위금액 = Convert.ToDouble(Convert.ToDouble(di.ASP_사업자_소계) * (isOver2000 ? 0.01 : 0.005));
di.set도매_수익_사업자모델매입관련추가수익(사업자모델매입에따른추가수익_단위금액); // 프린트용 정보 저장
rdt.set도매_수익_사업자모델매입에따른추가수익(
사업자모델매입에따른추가수익_단위금액 * // 판매량이 2000대 이상일때는 asp의 1%, 미만일때는 asp의 0.5%
(bi.get월평균판매대수_소계_합계() - bi.get월평균유통모델출고대수_소계_합계())
);
/* 유통모델관련 추가수익
* 현금DC
* 월평균유통모델출고대수_LG_소계*유통모델_LG*0.8%+
* 월평균유통모델출고대수_SS_소계*유통모델_SS*0.6%
*
* Volume DC
* IF('Input(기본+세부항목)'!G10>2000,
* 월평균유통모델출고대수_LG_소계*3%*유통모델_LG+
* 월평균유통모델출고대수_SS_소계*유통모델_SS*2.2%,
*
* 월평균유통모델출고대수_LG_소계*1.5%*유통모델_LG+
* 월평균유통모델출고대수_SS_소계*유통모델_SS*1%)
*/
Double 유통모델매입에따른추가수익_단위금액 =
Convert.ToDouble(CommonUtil.Division((bi.get월평균유통모델출고대수_SS_합계() * Convert.ToDouble(di.ASP_유통_SS) * 0.006 + bi.get월평균유통모델출고대수_LG_합계() * Convert.ToDouble(di.ASP_유통_LG) * 0.008), bi.get월평균유통모델출고대수_소계_합계())) + // 현금DC
Convert.ToDouble(CommonUtil.Division((bi.get월평균유통모델출고대수_SS_합계() * Convert.ToDouble(di.ASP_유통_SS) * (isOver2000 ? 0.022 : 0.01) + bi.get월평균유통모델출고대수_LG_합계() * Convert.ToDouble(di.ASP_유통_LG) * (isOver2000 ? 0.03 : 0.015)), bi.get월평균유통모델출고대수_소계_합계())); // Volume DC
di.set도매_수익_유통모델매입관련추가수익_현금DC(Convert.ToDouble(CommonUtil.Division((bi.get월평균유통모델출고대수_SS_합계() * Convert.ToDouble(di.ASP_유통_SS) * 0.006 + bi.get월평균유통모델출고대수_LG_합계() * Convert.ToDouble(di.ASP_유통_LG) * 0.008), bi.get월평균유통모델출고대수_소계_합계())));
di.set도매_수익_유통모델매입관련추가수익_VolumeDC(Convert.ToDouble(CommonUtil.Division((bi.get월평균유통모델출고대수_SS_합계() * Convert.ToDouble(di.ASP_유통_SS) * (isOver2000 ? 0.022 : 0.01) + bi.get월평균유통모델출고대수_LG_합계() * Convert.ToDouble(di.ASP_유통_LG) * (isOver2000 ? 0.03 : 0.015)), bi.get월평균유통모델출고대수_소계_합계())));
rdt.set도매_수익_유통모델매입에따른추가수익_현금_Volume(
유통모델매입에따른추가수익_단위금액 * bi.get월평균유통모델출고대수_소계_합계()
);
rdt.도매_수익_소계 = rdt.get도매_수익_가입자관리수수료() + rdt.get도매_수익_CS관리수수료() + rdt.get도매_수익_사업자모델매입에따른추가수익() + rdt.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
// 비용
rdt.set도매_비용_대리점투자비용(di.get도매_비용_대리점투자금액_신규() * bi.get도매_월평균판매대수_신규() + di.get도매_비용_대리점투자금액_기변() * bi.get도매_월평균판매대수_기변());
rdt.set도매_비용_인건비_급여_복리후생비(di.get도매_비용_직원급여_간부급() * bi.get도매_직원수_간부급() + di.get도매_비용_직원급여_평사원() * bi.get도매_직원수_평사원() + di.get도소매_비용_복리후생비() * bi.get도매_직원수_소계());
rdt.set도매_비용_임차료(di.get도매_비용_지급임차료() * bi.get도매_거래선수_개통사무실());
rdt.set도매_비용_이자비용(di.get도소매_비용_이자비용() * bi.get도매_월평균판매대수_소계());
/* 부가세 및 법인세 단위금액의 수식
* (
* (
* (
* 월평균관리수수료(CS관리수수료포함) * 누적가입자수+
* (
* (
* ASP전체계-리베이트
* )
* *소매_월평균판매대수_계
* )
* +
* 월단위취급수수료(단위금액) * 전체_월평균판매대수_계+직영매장수익(단위금액) * 소매_월평균판매대수_계+리베이트*도매_월평균판매대수_계+
* (
* (
* ASP전체계-리베이트
* )
* *전체_월평균판매대수_계
* )
* -
* (
* 전체_월평균판매대수_계*ASP전체계
* )
* )
* *10%
* )
* +
* (
* SUM(
* 월평균관리수수료(CS관리수수료포함) * 누적가입자수,
* 사업자모델매입관련추가수익(단위금액) * (전체_월평균판매대수_계 - 전체_월평균유통모델출고대수_계),
* 유통모델매입관련추가수익(현금DC)(단위금액) * 전체_월평균유통모델출고대수_계,
* 유통모델매입관련추가수익(VolumeDC)(단위금액) * 전체_월평균유통모델출고대수_계,
* 월단위취급수수료(단위금액) * 전체_월평균판매대수_계,
* 직영매장수익(단위금액) * 소매_월평균판매대수_계
* )
* -
* SUM(
* 대리점투자금액(신규) *도매_월평균판매대수_신규 +대리점투자금액(기변) *도매_월평균판매대수_기변,
* 직원급여(간부급) *도매_직원수_간부급 +직원급여(평사원) *도매_직원수_평사원,
* 복리후생비 *도매_직원수_소계,
* 통신비 *도매_직원수_소계,
* 세금과공과금 *도매_직원수_소계,
* 지급임차료 *도매_거래선수_개통사무실,
* 운반비 *도매_월평균판매대수_소계,
* 소모품비 *도매_월평균판매대수_소계,
* 지급수수료 *도매_월평균판매대수_소계,
* 판매촉진비 *도매_월평균판매대수_소계,
* 건물관리비 *도매_거래선수_개통사무실,
* 이자비용 *도매_월평균판매대수_소계,
* 차량유지비 *도매_직원수_소계,
* 기타 *도매_월평균판매대수_소계,
* 소매_직원급여(간부급) *소매_직원수_간부급 +소매_직원급여(평사원)*소매_직원수_평사원,
* 복리후생비 *소매_직원수_소계,
* 통신비 *소매_직원수_소계,
* 세금과공과금 *소매_직원수_소계,
* 지급임차료 *소매_거래선수_소계,
* 소모품비 *소매_월평균판매대수_소계,
* 지급수수료 *소매_월평균판매대수_소계,
* 판매촉진비 *소매_월평균판매대수_소계,
* 건물관리비 *소매_거래선수_소계,
* 이자비용 *소매_월평균판매대수_소계,
* 기타 *소매_월평균판매대수_소계,
* )
* -
* (
* (
* 월평균관리수수료(CS관리수수료포함) * 누적가입자수+
* (
* (
* ASP전체계-리베이트
* )
* *
* 소매_월평균판매대수_계
* )
* +
* 월단위취급수수료(단위금액) * 전체_월평균판매대수_계+직영매장수익(단위금액) * 소매_월평균판매대수_계+리베이트*도매_월평균판매대수_계
* +
* (
* (
* ASP전체계-리베이트
* )
* *
* 전체_월평균판매대수_계
* )
* -
* (
* 전체_월평균판매대수_계*ASP전체계
* )
* )
* *
* 10%
* )
* )
* *
* 22%
* )
* /
* 전체_월평균판매대수_계
*/
// 부가세
/*
* (
* (
* 월평균관리수수료(CS관리수수료포함) * 누적가입자수+
* (
* (
* ASP전체계-리베이트
* )
* *소매_월평균판매대수_계
* )
* +
* 월단위취급수수료(단위금액) * 전체_월평균판매대수_계+직영매장수익(단위금액) * 소매_월평균판매대수_계+리베이트*도매_월평균판매대수_계+
* (
* (
* ASP전체계-리베이트
* )
* *전체_월평균판매대수_계
* )
* -
* (
* 전체_월평균판매대수_계*ASP전체계
* )
* )
* *10%
* )
* /
* 전체_월평균판매대수_계
*/
//nIAOut[k++] += CommonUtil.Division(di.get도소매_비용_부가세() , bi.get월평균판매대수_소계_합계());
Double Doubleasp전체계 = Convert.ToDouble(di.ASP_총계);
Double Double리베이트 = Convert.ToDouble(di.Rebate);
Double 부가세_단위금액 = Convert.ToDouble(CommonUtil.Division(
(
(di.get도매_수익_월평균관리수수료() + di.get도매_수익_CS관리수수료()) * bi.get누적가입자수_합계() +
(
(Doubleasp전체계 - Double리베이트) * bi.get소매_월평균판매대수_소계()
) + di.get소매_수익_월평균업무취급수수료() * bi.get월평균판매대수_소계_합계() + di.get소매_수익_직영매장판매수익() * bi.get소매_월평균판매대수_소계() + Double리베이트 * bi.get도매_월평균판매대수_소계() +
(
(Doubleasp전체계 - Double리베이트) * bi.get월평균판매대수_소계_합계()
) -
(
bi.get월평균판매대수_소계_합계() * Doubleasp전체계
)
) * 0.1 , bi.get월평균판매대수_소계_합계())
);
di.set도소매_비용_부가세(부가세_단위금액);
rdt.set도매_비용_부가세(부가세_단위금액 * bi.get도매_월평균판매대수_소계());
// 법인세
/* (
* (
* SUM(
* 월평균관리수수료(CS관리수수료포함) * 누적가입자수,
* 사업자모델매입관련추가수익(단위금액) * (전체_월평균판매대수_계 - 전체_월평균유통모델출고대수_계),
* 유통모델매입관련추가수익(현금DC)(단위금액) * 전체_월평균유통모델출고대수_계,
* 유통모델매입관련추가수익(VolumeDC)(단위금액) * 전체_월평균유통모델출고대수_계,
* 월단위취급수수료(단위금액) * 전체_월평균판매대수_계,
* 직영매장수익(단위금액) * 소매_월평균판매대수_계
* )
* -
* SUM(
* 대리점투자금액(신규) *도매_월평균판매대수_신규 +대리점투자금액(기변) *도매_월평균판매대수_기변,
* 직원급여(간부급) *도매_직원수_간부급 +직원급여(평사원) *도매_직원수_평사원,
* 복리후생비 *도매_직원수_소계,
* 통신비 *도매_직원수_소계,
* 세금과공과금 *도매_직원수_소계,
* 지급임차료 *도매_거래선수_개통사무실,
* 운반비 *도매_월평균판매대수_소계,
* 소모품비 *도매_월평균판매대수_소계,
* 지급수수료 *도매_월평균판매대수_소계,
* 판매촉진비 *도매_월평균판매대수_소계,
* 건물관리비 *도매_거래선수_개통사무실,
* 이자비용 *도매_월평균판매대수_소계,
* 차량유지비 *도매_직원수_소계,
* 기타 *도매_월평균판매대수_소계,
* 소매_직원급여(간부급) *소매_직원수_간부급 +소매_직원급여(평사원)*소매_직원수_평사원,
* 복리후생비 *소매_직원수_소계,
* 통신비 *소매_직원수_소계,
* 세금과공과금 *소매_직원수_소계,
* 지급임차료 *소매_거래선수_소계,
* 소모품비 *소매_월평균판매대수_소계,
* 지급수수료 *소매_월평균판매대수_소계,
* 판매촉진비 *소매_월평균판매대수_소계,
* 건물관리비 *소매_거래선수_소계,
* 이자비용 *소매_월평균판매대수_소계,
* 기타 *소매_월평균판매대수_소계,
* )
* -
* (
* (
* 월평균관리수수료(CS관리수수료포함) * 누적가입자수+
* (
* (
* ASP전체계-리베이트
* )
* *
* 소매_월평균판매대수_계
* )
* +
* 월단위취급수수료(단위금액) * 전체_월평균판매대수_계+직영매장수익(단위금액) * 소매_월평균판매대수_계+리베이트*도매_월평균판매대수_계
* +
* (
* (
* ASP전체계-리베이트
* )
* *
* 전체_월평균판매대수_계
* )
* -
* (
* 전체_월평균판매대수_계*ASP전체계
* )
* )
* *
* 10%
* )
* )
* *
* 22%
* )
* /
* 전체_월평균판매대수_계
*/
/* 수익합계
* SUM(
* 월평균관리수수료(CS관리수수료포함) * 누적가입자수,
* 사업자모델매입관련추가수익(단위금액) * (전체_월평균판매대수_계 - 전체_월평균유통모델출고대수_계),
* 유통모델매입관련추가수익(현금DC)(단위금액) * 전체_월평균유통모델출고대수_계,
* 유통모델매입관련추가수익(VolumeDC)(단위금액) * 전체_월평균유통모델출고대수_계,
* 월단위취급수수료(단위금액) * 전체_월평균판매대수_계,
* 직영매장수익(단위금액) * 소매_월평균판매대수_계
* )
*/
Double 수익합계 =
(di.get도매_수익_월평균관리수수료()+di.get도매_수익_CS관리수수료()) * bi.get누적가입자수_합계() +
사업자모델매입에따른추가수익_단위금액 * (bi.get월평균판매대수_소계_합계() - bi.get월평균유통모델출고대수_소계_합계()) +
유통모델매입에따른추가수익_단위금액 * bi.get월평균유통모델출고대수_소계_합계() +
di.get소매_수익_월평균업무취급수수료() * bi.get월평균판매대수_소계_합계() +
di.get소매_수익_직영매장판매수익() * bi.get소매_월평균판매대수_소계();
/* 비용합계
* SUM(
* 대리점투자금액(신규) *도매_월평균판매대수_신규 +대리점투자금액(기변) *도매_월평균판매대수_기변,
* 직원급여(간부급) *도매_직원수_간부급 +직원급여(평사원) *도매_직원수_평사원,
* 복리후생비 *도매_직원수_소계,
* 복리후생비 *소매_직원수_소계,
* 통신비 *도매_직원수_소계,
* 통신비 *소매_직원수_소계,
* 세금과공과금 *도매_직원수_소계,
* 세금과공과금 *소매_직원수_소계,
* 지급임차료 *도매_거래선수_개통사무실,
* 운반비 *도매_월평균판매대수_소계,
* 소모품비 *도매_월평균판매대수_소계,
* 소모품비 *소매_월평균판매대수_소계,
* 지급수수료 *도매_월평균판매대수_소계,
* 판매촉진비 *도매_월평균판매대수_소계,
* 건물관리비 *도매_거래선수_개통사무실,
* 이자비용 *도매_월평균판매대수_소계,
* 차량유지비 *도매_직원수_소계,
* 기타 *도매_월평균판매대수_소계,
* 소매_직원급여(간부급) *소매_직원수_간부급 +소매_직원급여(평사원)*소매_직원수_평사원,
* 지급임차료 *소매_거래선수_소계,
* 지급수수료 *소매_월평균판매대수_소계,
* 판매촉진비 *소매_월평균판매대수_소계,
* 건물관리비 *소매_거래선수_소계,
* 이자비용 *소매_월평균판매대수_소계,
* 기타 *소매_월평균판매대수_소계,
* )
*/
Double 비용합계 =
di.get도매_비용_대리점투자금액_신규() * bi.get도매_월평균판매대수_신규() + di.get도매_비용_대리점투자금액_기변() * bi.get도매_월평균판매대수_기변() +
di.get도매_비용_직원급여_간부급_총액(bi.get도매_직원수_간부급()) + di.get도매_비용_직원급여_평사원_총액(bi.get도매_직원수_평사원()) +
di.get도소매_비용_복리후생비()/*소매포함*/ * bi.get직원수_소계_합계() +
di.get도소매_비용_통신비()/*소매포함*/ * bi.get직원수_소계_합계() +
di.get도소매_비용_공과금()/*소매포함*/ * bi.get직원수_소계_합계() +
di.get도매_비용_지급임차료() * bi.get도매_거래선수_개통사무실() +
di.get도매_비용_운반비() * bi.get도매_월평균판매대수_소계() +
di.get도소매_비용_소모품비() * bi.get월평균판매대수_소계_합계() +
di.get도매_비용_지급수수료() * bi.get도매_월평균판매대수_소계() +
di.get도매_비용_판매촉진비() * bi.get도매_월평균판매대수_소계() +
di.get도매_비용_건물관리비() * bi.get도매_거래선수_개통사무실() +
di.get도소매_비용_이자비용() * bi.get월평균판매대수_소계_합계() +
di.get도매_비용_차량유지비() * bi.get도매_직원수_소계() +
di.get도소매_비용_기타() * bi.get월평균판매대수_소계_합계() +
di.get소매_비용_직원급여_간부급_총액(bi.get소매_직원수_간부급()) + di.get소매_비용_직원급여_평사원_총액(bi.get소매_직원수_평사원()) +
di.get소매_비용_지급임차료() * bi.get소매_거래선수_소계() +
di.get소매_비용_지급수수료() * bi.get소매_월평균판매대수_소계() +
di.get소매_비용_판매촉진비() * bi.get소매_월평균판매대수_소계() +
di.get소매_비용_건물관리비() * bi.get소매_거래선수_소계();
Double 법인세_단위금액 = Convert.ToDouble(CommonUtil.Division((수익합계 - 비용합계 - 부가세_단위금액 * bi.get월평균판매대수_소계_합계()) * 0.22, bi.get월평균판매대수_소계_합계()));
di.set도소매_비용_법인세(법인세_단위금액);
rdt.set도매_비용_법인세(법인세_단위금액 * bi.get도매_월평균판매대수_소계());
// '# Detail3. 업계평균vs.해당대리점'!K10+'# Detail3. 업계평균vs.해당대리점'!K11+'# Detail3. 업계평균vs.해당대리점'!K13+'# Detail3. 업계평균vs.해당대리점'!K14+'# Detail3. 업계평균vs.해당대리점'!K15+'# Detail3. 업계평균vs.해당대리점'!K16+'# Detail3. 업계평균vs.해당대리점'!K17+'# Detail3. 업계평균vs.해당대리점'!K18+'# Detail3. 업계평균vs.해당대리점'!K20
rdt.set도매_비용_기타판매관리비((di.get도매_비용_운반비() + di.get도매_비용_지급수수료() + di.get도매_비용_판매촉진비() + di.get도소매_비용_소모품비() + di.get도소매_비용_기타()) * bi.get도매_월평균판매대수_소계()
+ (di.get도매_비용_건물관리비()) * bi.get도매_거래선수_개통사무실()
+ (di.get도매_비용_차량유지비() + di.get도소매_비용_통신비() + di.get도소매_비용_공과금()) * bi.get도매_직원수_소계());
rdt.도매_비용_소계 = rdt.get도매_비용_대리점투자비용() + rdt.get도매_비용_인건비_급여_복리후생비() + rdt.get도매_비용_임차료() + rdt.get도매_비용_이자비용() + rdt.get도매_비용_부가세() + rdt.get도매_비용_법인세() + rdt.get도매_비용_기타판매관리비();
rdt.도매손익계 = rdt.도매_수익_소계 - rdt.도매_비용_소계;
// 단위당 금액
// 수익
rd.set도매_수익_가입자관리수수료(CommonUtil.Division(rdt.get도매_수익_가입자관리수수료(), bi.get도매_월평균판매대수_소계()));
rd.set도매_수익_CS관리수수료(CommonUtil.Division(rdt.get도매_수익_CS관리수수료(), bi.get도매_월평균판매대수_소계()));
rd.set도매_수익_사업자모델매입에따른추가수익(CommonUtil.Division(rdt.get도매_수익_사업자모델매입에따른추가수익(), bi.get도매_월평균판매대수_소계()));
rd.set도매_수익_유통모델매입에따른추가수익_현금_Volume(CommonUtil.Division(rdt.get도매_수익_유통모델매입에따른추가수익_현금_Volume(), bi.get도매_월평균판매대수_소계()));
rd.도매_수익_소계 = CommonUtil.Division(rdt.도매_수익_소계, bi.get도매_월평균판매대수_소계());
// 비용
rd.set도매_비용_대리점투자비용(CommonUtil.Division(rdt.get도매_비용_대리점투자비용(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_인건비_급여_복리후생비(CommonUtil.Division(rdt.get도매_비용_인건비_급여_복리후생비(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_임차료(CommonUtil.Division(rdt.get도매_비용_임차료(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_이자비용(CommonUtil.Division(rdt.get도매_비용_이자비용(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_부가세(CommonUtil.Division(rdt.get도매_비용_부가세(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_법인세(CommonUtil.Division(rdt.get도매_비용_법인세(), bi.get도매_월평균판매대수_소계()));
rd.set도매_비용_기타판매관리비(CommonUtil.Division(rdt.get도매_비용_기타판매관리비(), bi.get도매_월평균판매대수_소계()));
rd.도매_비용_소계 = CommonUtil.Division(rdt.도매_비용_소계, bi.get도매_월평균판매대수_소계());
rd.도매손익계 = CommonUtil.Division(rdt.도매손익계, bi.get도매_월평균판매대수_소계());
// 소매
// 총액
// 수익
rdt.set소매_수익_업무취급수수료(di.get소매_수익_월평균업무취급수수료() * bi.get월평균판매대수_소계_합계());
rdt.set소매_수익_직영매장판매수익(di.get소매_수익_직영매장판매수익() * bi.get소매_월평균판매대수_소계());
rdt.소매_수익_소계 = rdt.get소매_수익_업무취급수수료() + rdt.get소매_수익_직영매장판매수익();
// 비용
rdt.set소매_비용_인건비_급여_복리후생비(di.get소매_비용_직원급여_간부급() * bi.get소매_직원수_간부급() + di.get소매_비용_직원급여_평사원() * bi.get소매_직원수_평사원() + di.get도소매_비용_복리후생비() * bi.get소매_직원수_소계());
rdt.set소매_비용_임차료(di.get소매_비용_지급임차료() * bi.get소매_거래선수_소계());
rdt.set소매_비용_이자비용(di.get도소매_비용_이자비용() * bi.get소매_월평균판매대수_소계());
rdt.set소매_비용_부가세(부가세_단위금액 * bi.get소매_월평균판매대수_소계());
rdt.set소매_비용_법인세(법인세_단위금액 * bi.get소매_월평균판매대수_소계());
// '# Detail3. 업계평균vs.해당대리점'!L10+'# Detail3. 업계평균vs.해당대리점'!L11+'# Detail3. 업계평균vs.해당대리점'!L13+'# Detail3. 업계평균vs.해당대리점'!L14+'# Detail3. 업계평균vs.해당대리점'!L15+'# Detail3. 업계평균vs.해당대리점'!L16+'# Detail3. 업계평균vs.해당대리점'!L17+'# Detail3. 업계평균vs.해당대리점'!L18+'# Detail3. 업계평균vs.해당대리점'!L20
rdt.set소매_비용_기타판매관리비((di.get소매_비용_지급수수료() + di.get소매_비용_판매촉진비() + di.get도소매_비용_소모품비() + di.get도소매_비용_기타()) * bi.get소매_월평균판매대수_소계()
+ (di.get소매_비용_건물관리비()) * bi.get소매_거래선수_소계()
+ (di.get도소매_비용_통신비() + di.get도소매_비용_공과금()) * bi.get소매_직원수_소계());
rdt.소매_비용_소계 = rdt.get소매_비용_인건비_급여_복리후생비() + rdt.get소매_비용_임차료() + rdt.get소매_비용_이자비용() + rdt.get소매_비용_부가세() + rdt.get소매_비용_법인세() + rdt.get소매_비용_기타판매관리비();
rdt.소매손익계 = rdt.소매_수익_소계 - rdt.소매_비용_소계;
rdt.점별손익추정 = CommonUtil.Division(rdt.소매손익계, bi.get거래선수_직영점_합계());
// 단위당 금액
// 수익
rd.set소매_수익_업무취급수수료(CommonUtil.Division(rdt.get소매_수익_업무취급수수료(), bi.get소매_월평균판매대수_소계()));
rd.set소매_수익_직영매장판매수익(CommonUtil.Division(rdt.get소매_수익_직영매장판매수익(), bi.get소매_월평균판매대수_소계()));
rd.소매_수익_소계 = CommonUtil.Division(rdt.소매_수익_소계, bi.get소매_월평균판매대수_소계());
// 비용
rd.set소매_비용_인건비_급여_복리후생비(CommonUtil.Division(rdt.get소매_비용_인건비_급여_복리후생비(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_임차료(CommonUtil.Division(rdt.get소매_비용_임차료(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_이자비용(CommonUtil.Division(rdt.get소매_비용_이자비용(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_부가세(CommonUtil.Division(rdt.get소매_비용_부가세(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_법인세(CommonUtil.Division(rdt.get소매_비용_법인세(), bi.get소매_월평균판매대수_소계()));
rd.set소매_비용_기타판매관리비(CommonUtil.Division(rdt.get소매_비용_기타판매관리비(), bi.get소매_월평균판매대수_소계()));
rd.소매_비용_소계 = CommonUtil.Division(rdt.소매_비용_소계, bi.get소매_월평균판매대수_소계());
rd.소매손익계 = CommonUtil.Division(rdt.소매손익계, bi.get소매_월평균판매대수_소계());
rd.점별손익추정 = bi.get거래선수_직영점_합계();
// 전체
// 총액
// 수익
rdt.set전체_수익_가입자관리수수료(rdt.get도매_수익_가입자관리수수료());
rdt.set전체_수익_CS관리수수료(rdt.get도매_수익_CS관리수수료());
rdt.set전체_수익_업무취급수수료(rdt.get소매_수익_업무취급수수료());
rdt.set전체_수익_사업자모델매입에따른추가수익(rdt.get도매_수익_사업자모델매입에따른추가수익());
rdt.set전체_수익_유통모델매입에따른추가수익_현금_Volume(rdt.get도매_수익_유통모델매입에따른추가수익_현금_Volume());
rdt.set전체_수익_직영매장판매수익(rdt.get소매_수익_직영매장판매수익());
rdt.전체_수익_소계 = rdt.get전체_수익_가입자관리수수료() + rdt.get전체_수익_CS관리수수료() + rdt.get전체_수익_업무취급수수료() + rdt.get전체_수익_사업자모델매입에따른추가수익() + rdt.get전체_수익_유통모델매입에따른추가수익_현금_Volume() + rdt.get전체_수익_직영매장판매수익();
// 비용
rdt.set전체_비용_대리점투자비용(rdt.get도매_비용_대리점투자비용());
rdt.set전체_비용_인건비_급여_복리후생비(rdt.get도매_비용_인건비_급여_복리후생비() + rdt.get소매_비용_인건비_급여_복리후생비());
rdt.set전체_비용_임차료(rdt.get도매_비용_임차료() + rdt.get소매_비용_임차료());
rdt.set전체_비용_이자비용(rdt.get도매_비용_이자비용() + rdt.get소매_비용_이자비용());
rdt.set전체_비용_부가세(rdt.get도매_비용_부가세() + rdt.get소매_비용_부가세());
rdt.set전체_비용_법인세(rdt.get도매_비용_법인세() + rdt.get소매_비용_법인세());
rdt.set전체_비용_기타판매관리비(rdt.get도매_비용_기타판매관리비() + rdt.get소매_비용_기타판매관리비());
rdt.전체_비용_소계 = rdt.get전체_비용_대리점투자비용() + rdt.get전체_비용_인건비_급여_복리후생비() + rdt.get전체_비용_임차료() + rdt.get전체_비용_이자비용() + rdt.get전체_비용_부가세() + rdt.get전체_비용_법인세() + rdt.get전체_비용_기타판매관리비();
rdt.전체손익계 = rdt.전체_수익_소계 - rdt.전체_비용_소계;
// 단위당 금액
// 수익
rd.set전체_수익_가입자관리수수료(CommonUtil.Division(rdt.get전체_수익_가입자관리수수료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_CS관리수수료(CommonUtil.Division(rdt.get전체_수익_CS관리수수료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_업무취급수수료(CommonUtil.Division(rdt.get전체_수익_업무취급수수료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_사업자모델매입에따른추가수익(CommonUtil.Division(rdt.get전체_수익_사업자모델매입에따른추가수익(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_유통모델매입에따른추가수익_현금_Volume(CommonUtil.Division(rdt.get전체_수익_유통모델매입에따른추가수익_현금_Volume(), bi.get월평균판매대수_소계_합계()));
rd.set전체_수익_직영매장판매수익(CommonUtil.Division(rdt.get전체_수익_직영매장판매수익(), bi.get월평균판매대수_소계_합계()));
rd.전체_수익_소계 = CommonUtil.Division(rdt.전체_수익_소계, bi.get월평균판매대수_소계_합계());
// 비용
rd.set전체_비용_대리점투자비용(CommonUtil.Division(rdt.get전체_비용_대리점투자비용(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_인건비_급여_복리후생비(CommonUtil.Division(rdt.get전체_비용_인건비_급여_복리후생비(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_임차료(CommonUtil.Division(rdt.get전체_비용_임차료(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_이자비용(CommonUtil.Division(rdt.get전체_비용_이자비용(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_부가세(CommonUtil.Division(rdt.get전체_비용_부가세(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_법인세(CommonUtil.Division(rdt.get전체_비용_법인세(), bi.get월평균판매대수_소계_합계()));
rd.set전체_비용_기타판매관리비(CommonUtil.Division(rdt.get전체_비용_기타판매관리비(), bi.get월평균판매대수_소계_합계()));
rd.전체_비용_소계 = CommonUtil.Division(rdt.전체_비용_소계, bi.get월평균판매대수_소계_합계());
rd.전체손익계 = CommonUtil.Division(rdt.전체손익계, bi.get월평균판매대수_소계_합계());
}
/// <summary>
///
/// </summary>
/// <param name="_WorkSheet"></param>
public static void WriteExcelFileToDataResultStore(excel.Worksheet _WorkSheet, CResultData storeTotal, CResultData store)
{
_WorkSheet.get_Range("I7", Type.Missing).Value2 = storeTotal.전체_수익_가입자관리수수료;
_WorkSheet.get_Range("I8", Type.Missing).Value2 = storeTotal.전체_수익_CS관리수수료;
_WorkSheet.get_Range("I9", Type.Missing).Value2 = storeTotal.전체_수익_업무취급수수료;
_WorkSheet.get_Range("I10", Type.Missing).Value2 = storeTotal.전체_수익_사업자모델매입에따른추가수익;
_WorkSheet.get_Range("I11", Type.Missing).Value2 = storeTotal.전체_수익_유통모델매입에따른추가수익_현금_Volume;
_WorkSheet.get_Range("I12", Type.Missing).Value2 = storeTotal.전체_수익_직영매장판매수익;
_WorkSheet.get_Range("I13", Type.Missing).Value2 = storeTotal.전체_수익_소계;
_WorkSheet.get_Range("I14", Type.Missing).Value2 = storeTotal.get전체_비용_대리점투자비용();
_WorkSheet.get_Range("I15", Type.Missing).Value2 = storeTotal.get전체_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("I16", Type.Missing).Value2 = storeTotal.get전체_비용_임차료();
_WorkSheet.get_Range("I17", Type.Missing).Value2 = storeTotal.get전체_비용_이자비용();
_WorkSheet.get_Range("I18", Type.Missing).Value2 = storeTotal.get전체_비용_부가세();
_WorkSheet.get_Range("I19", Type.Missing).Value2 = storeTotal.get전체_비용_법인세();
_WorkSheet.get_Range("I20", Type.Missing).Value2 = storeTotal.get전체_비용_기타판매관리비();
_WorkSheet.get_Range("I21", Type.Missing).Value2 = storeTotal.전체_비용_소계;
_WorkSheet.get_Range("I22", Type.Missing).Value2 = storeTotal.전체손익계;
_WorkSheet.get_Range("I28", Type.Missing).Value2 = storeTotal.get도매_수익_가입자관리수수료();
_WorkSheet.get_Range("I29", Type.Missing).Value2 = storeTotal.get도매_수익_CS관리수수료();
_WorkSheet.get_Range("I30", Type.Missing).Value2 = storeTotal.get도매_수익_사업자모델매입에따른추가수익();
_WorkSheet.get_Range("I31", Type.Missing).Value2 = storeTotal.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
_WorkSheet.get_Range("I32", Type.Missing).Value2 = storeTotal.도매_수익_소계;
_WorkSheet.get_Range("I33", Type.Missing).Value2 = storeTotal.get도매_비용_대리점투자비용();
_WorkSheet.get_Range("I34", Type.Missing).Value2 = storeTotal.get도매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("I35", Type.Missing).Value2 = storeTotal.get도매_비용_임차료();
_WorkSheet.get_Range("I36", Type.Missing).Value2 = storeTotal.get도매_비용_이자비용();
_WorkSheet.get_Range("I37", Type.Missing).Value2 = storeTotal.get도매_비용_부가세();
_WorkSheet.get_Range("I38", Type.Missing).Value2 = storeTotal.get도매_비용_법인세();
_WorkSheet.get_Range("I39", Type.Missing).Value2 = storeTotal.get도매_비용_기타판매관리비();
_WorkSheet.get_Range("I40", Type.Missing).Value2 = storeTotal.도매_비용_소계;
_WorkSheet.get_Range("I41", Type.Missing).Value2 = storeTotal.도매손익계;
_WorkSheet.get_Range("I46", Type.Missing).Value2 = storeTotal.get소매_수익_업무취급수수료();
_WorkSheet.get_Range("I47", Type.Missing).Value2 = storeTotal.get소매_수익_직영매장판매수익();
_WorkSheet.get_Range("I48", Type.Missing).Value2 = storeTotal.소매_수익_소계;
_WorkSheet.get_Range("I49", Type.Missing).Value2 = storeTotal.get소매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("I50", Type.Missing).Value2 = storeTotal.get소매_비용_임차료();
_WorkSheet.get_Range("I51", Type.Missing).Value2 = storeTotal.get소매_비용_이자비용();
_WorkSheet.get_Range("I52", Type.Missing).Value2 = storeTotal.get소매_비용_부가세();
_WorkSheet.get_Range("I53", Type.Missing).Value2 = storeTotal.get소매_비용_법인세();
_WorkSheet.get_Range("I54", Type.Missing).Value2 = storeTotal.get소매_비용_기타판매관리비();
_WorkSheet.get_Range("I55", Type.Missing).Value2 = storeTotal.소매_비용_소계;
_WorkSheet.get_Range("I56", Type.Missing).Value2 = storeTotal.소매손익계;
_WorkSheet.get_Range("I57", Type.Missing).Value2 = storeTotal.점별손익추정;
_WorkSheet.get_Range("J7", Type.Missing).Value2 = store.전체_수익_가입자관리수수료;
_WorkSheet.get_Range("J8", Type.Missing).Value2 = store.전체_수익_CS관리수수료;
_WorkSheet.get_Range("J9", Type.Missing).Value2 = store.전체_수익_업무취급수수료;
_WorkSheet.get_Range("J10", Type.Missing).Value2 = store.전체_수익_사업자모델매입에따른추가수익;
_WorkSheet.get_Range("J11", Type.Missing).Value2 = store.전체_수익_유통모델매입에따른추가수익_현금_Volume;
_WorkSheet.get_Range("J12", Type.Missing).Value2 = store.전체_수익_직영매장판매수익;
_WorkSheet.get_Range("J13", Type.Missing).Value2 = store.전체_수익_소계;
_WorkSheet.get_Range("J14", Type.Missing).Value2 = store.get전체_비용_대리점투자비용();
_WorkSheet.get_Range("J15", Type.Missing).Value2 = store.get전체_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("J16", Type.Missing).Value2 = store.get전체_비용_임차료();
_WorkSheet.get_Range("J17", Type.Missing).Value2 = store.get전체_비용_이자비용();
_WorkSheet.get_Range("J18", Type.Missing).Value2 = store.get전체_비용_부가세();
_WorkSheet.get_Range("J19", Type.Missing).Value2 = store.get전체_비용_법인세();
_WorkSheet.get_Range("J20", Type.Missing).Value2 = store.get전체_비용_기타판매관리비();
_WorkSheet.get_Range("J21", Type.Missing).Value2 = store.전체_비용_소계;
_WorkSheet.get_Range("J22", Type.Missing).Value2 = store.전체손익계;
_WorkSheet.get_Range("J28", Type.Missing).Value2 = store.get도매_수익_가입자관리수수료();
_WorkSheet.get_Range("J29", Type.Missing).Value2 = store.get도매_수익_CS관리수수료();
_WorkSheet.get_Range("J30", Type.Missing).Value2 = store.get도매_수익_사업자모델매입에따른추가수익();
_WorkSheet.get_Range("J31", Type.Missing).Value2 = store.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
_WorkSheet.get_Range("J32", Type.Missing).Value2 = store.도매_수익_소계;
_WorkSheet.get_Range("J33", Type.Missing).Value2 = store.get도매_비용_대리점투자비용();
_WorkSheet.get_Range("J34", Type.Missing).Value2 = store.get도매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("J35", Type.Missing).Value2 = store.get도매_비용_임차료();
_WorkSheet.get_Range("J36", Type.Missing).Value2 = store.get도매_비용_이자비용();
_WorkSheet.get_Range("J37", Type.Missing).Value2 = store.get도매_비용_부가세();
_WorkSheet.get_Range("J38", Type.Missing).Value2 = store.get도매_비용_법인세();
_WorkSheet.get_Range("J39", Type.Missing).Value2 = store.get도매_비용_기타판매관리비();
_WorkSheet.get_Range("J40", Type.Missing).Value2 = store.도매_비용_소계;
_WorkSheet.get_Range("J41", Type.Missing).Value2 = store.도매손익계;
_WorkSheet.get_Range("J46", Type.Missing).Value2 = store.get소매_수익_업무취급수수료();
_WorkSheet.get_Range("J47", Type.Missing).Value2 = store.get소매_수익_직영매장판매수익();
_WorkSheet.get_Range("J48", Type.Missing).Value2 = store.소매_수익_소계;
_WorkSheet.get_Range("J49", Type.Missing).Value2 = store.get소매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("J50", Type.Missing).Value2 = store.get소매_비용_임차료();
_WorkSheet.get_Range("J51", Type.Missing).Value2 = store.get소매_비용_이자비용();
_WorkSheet.get_Range("J52", Type.Missing).Value2 = store.get소매_비용_부가세();
_WorkSheet.get_Range("J53", Type.Missing).Value2 = store.get소매_비용_법인세();
_WorkSheet.get_Range("J54", Type.Missing).Value2 = store.get소매_비용_기타판매관리비();
_WorkSheet.get_Range("J55", Type.Missing).Value2 = store.소매_비용_소계;
_WorkSheet.get_Range("J56", Type.Missing).Value2 = store.소매손익계;
_WorkSheet.get_Range("J57", Type.Missing).Value2 = store.점별손익추정;
}
/// <summary>
///
/// </summary>
/// <param name="_WorkSheet"></param>
public static void WriteExcelFileToDataResultFuture(excel.Worksheet _WorkSheet, CResultData futureTotal, CResultData future)
{
_WorkSheet.get_Range("N7", Type.Missing).Value2 = futureTotal.전체_수익_가입자관리수수료;
_WorkSheet.get_Range("N8", Type.Missing).Value2 = futureTotal.전체_수익_CS관리수수료;
_WorkSheet.get_Range("N9", Type.Missing).Value2 = futureTotal.전체_수익_업무취급수수료;
_WorkSheet.get_Range("N10", Type.Missing).Value2 = futureTotal.전체_수익_사업자모델매입에따른추가수익;
_WorkSheet.get_Range("N11", Type.Missing).Value2 = futureTotal.전체_수익_유통모델매입에따른추가수익_현금_Volume;
_WorkSheet.get_Range("N12", Type.Missing).Value2 = futureTotal.전체_수익_직영매장판매수익;
_WorkSheet.get_Range("N13", Type.Missing).Value2 = futureTotal.전체_수익_소계;
_WorkSheet.get_Range("N14", Type.Missing).Value2 = futureTotal.get전체_비용_대리점투자비용();
_WorkSheet.get_Range("N15", Type.Missing).Value2 = futureTotal.get전체_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("N16", Type.Missing).Value2 = futureTotal.get전체_비용_임차료();
_WorkSheet.get_Range("N17", Type.Missing).Value2 = futureTotal.get전체_비용_이자비용();
_WorkSheet.get_Range("N18", Type.Missing).Value2 = futureTotal.get전체_비용_부가세();
_WorkSheet.get_Range("N19", Type.Missing).Value2 = futureTotal.get전체_비용_법인세();
_WorkSheet.get_Range("N20", Type.Missing).Value2 = futureTotal.get전체_비용_기타판매관리비();
_WorkSheet.get_Range("N21", Type.Missing).Value2 = futureTotal.전체_비용_소계;
_WorkSheet.get_Range("N22", Type.Missing).Value2 = futureTotal.전체손익계;
_WorkSheet.get_Range("N28", Type.Missing).Value2 = futureTotal.get도매_수익_가입자관리수수료();
_WorkSheet.get_Range("N29", Type.Missing).Value2 = futureTotal.get도매_수익_CS관리수수료();
_WorkSheet.get_Range("N30", Type.Missing).Value2 = futureTotal.get도매_수익_사업자모델매입에따른추가수익();
_WorkSheet.get_Range("N31", Type.Missing).Value2 = futureTotal.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
_WorkSheet.get_Range("N32", Type.Missing).Value2 = futureTotal.도매_수익_소계;
_WorkSheet.get_Range("N33", Type.Missing).Value2 = futureTotal.get도매_비용_대리점투자비용();
_WorkSheet.get_Range("N34", Type.Missing).Value2 = futureTotal.get도매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("N35", Type.Missing).Value2 = futureTotal.get도매_비용_임차료();
_WorkSheet.get_Range("N36", Type.Missing).Value2 = futureTotal.get도매_비용_이자비용();
_WorkSheet.get_Range("N37", Type.Missing).Value2 = futureTotal.get도매_비용_부가세();
_WorkSheet.get_Range("N38", Type.Missing).Value2 = futureTotal.get도매_비용_법인세();
_WorkSheet.get_Range("N39", Type.Missing).Value2 = futureTotal.get도매_비용_기타판매관리비();
_WorkSheet.get_Range("N40", Type.Missing).Value2 = futureTotal.도매_비용_소계;
_WorkSheet.get_Range("N41", Type.Missing).Value2 = futureTotal.도매손익계;
_WorkSheet.get_Range("N46", Type.Missing).Value2 = futureTotal.get소매_수익_업무취급수수료();
_WorkSheet.get_Range("N47", Type.Missing).Value2 = futureTotal.get소매_수익_직영매장판매수익();
_WorkSheet.get_Range("N48", Type.Missing).Value2 = futureTotal.소매_수익_소계;
_WorkSheet.get_Range("N49", Type.Missing).Value2 = futureTotal.get소매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("N50", Type.Missing).Value2 = futureTotal.get소매_비용_임차료();
_WorkSheet.get_Range("N51", Type.Missing).Value2 = futureTotal.get소매_비용_이자비용();
_WorkSheet.get_Range("N52", Type.Missing).Value2 = futureTotal.get소매_비용_부가세();
_WorkSheet.get_Range("N53", Type.Missing).Value2 = futureTotal.get소매_비용_법인세();
_WorkSheet.get_Range("N54", Type.Missing).Value2 = futureTotal.get소매_비용_기타판매관리비();
_WorkSheet.get_Range("N55", Type.Missing).Value2 = futureTotal.소매_비용_소계;
_WorkSheet.get_Range("N56", Type.Missing).Value2 = futureTotal.소매손익계;
_WorkSheet.get_Range("N57", Type.Missing).Value2 = futureTotal.점별손익추정;
_WorkSheet.get_Range("O7", Type.Missing).Value2 = future.전체_수익_가입자관리수수료;
_WorkSheet.get_Range("O8", Type.Missing).Value2 = future.전체_수익_CS관리수수료;
_WorkSheet.get_Range("O9", Type.Missing).Value2 = future.전체_수익_업무취급수수료;
_WorkSheet.get_Range("O10", Type.Missing).Value2 = future.전체_수익_사업자모델매입에따른추가수익;
_WorkSheet.get_Range("O11", Type.Missing).Value2 = future.전체_수익_유통모델매입에따른추가수익_현금_Volume;
_WorkSheet.get_Range("O12", Type.Missing).Value2 = future.전체_수익_직영매장판매수익;
_WorkSheet.get_Range("O13", Type.Missing).Value2 = future.전체_수익_소계;
_WorkSheet.get_Range("O14", Type.Missing).Value2 = future.get전체_비용_대리점투자비용();
_WorkSheet.get_Range("O15", Type.Missing).Value2 = future.get전체_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("O16", Type.Missing).Value2 = future.get전체_비용_임차료();
_WorkSheet.get_Range("O17", Type.Missing).Value2 = future.get전체_비용_이자비용();
_WorkSheet.get_Range("O18", Type.Missing).Value2 = future.get전체_비용_부가세();
_WorkSheet.get_Range("O19", Type.Missing).Value2 = future.get전체_비용_법인세();
_WorkSheet.get_Range("O20", Type.Missing).Value2 = future.get전체_비용_기타판매관리비();
_WorkSheet.get_Range("O21", Type.Missing).Value2 = future.전체_비용_소계;
_WorkSheet.get_Range("O22", Type.Missing).Value2 = future.전체손익계;
_WorkSheet.get_Range("O28", Type.Missing).Value2 = future.get도매_수익_가입자관리수수료();
_WorkSheet.get_Range("O29", Type.Missing).Value2 = future.get도매_수익_CS관리수수료();
_WorkSheet.get_Range("O30", Type.Missing).Value2 = future.get도매_수익_사업자모델매입에따른추가수익();
_WorkSheet.get_Range("O31", Type.Missing).Value2 = future.get도매_수익_유통모델매입에따른추가수익_현금_Volume();
_WorkSheet.get_Range("O32", Type.Missing).Value2 = future.도매_수익_소계;
_WorkSheet.get_Range("O33", Type.Missing).Value2 = future.get도매_비용_대리점투자비용();
_WorkSheet.get_Range("O34", Type.Missing).Value2 = future.get도매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("O35", Type.Missing).Value2 = future.get도매_비용_임차료();
_WorkSheet.get_Range("O36", Type.Missing).Value2 = future.get도매_비용_이자비용();
_WorkSheet.get_Range("O37", Type.Missing).Value2 = future.get도매_비용_부가세();
_WorkSheet.get_Range("O38", Type.Missing).Value2 = future.get도매_비용_법인세();
_WorkSheet.get_Range("O39", Type.Missing).Value2 = future.get도매_비용_기타판매관리비();
_WorkSheet.get_Range("O40", Type.Missing).Value2 = future.도매_비용_소계;
_WorkSheet.get_Range("O41", Type.Missing).Value2 = future.도매손익계;
_WorkSheet.get_Range("O46", Type.Missing).Value2 = future.get소매_수익_업무취급수수료();
_WorkSheet.get_Range("O47", Type.Missing).Value2 = future.get소매_수익_직영매장판매수익();
_WorkSheet.get_Range("O48", Type.Missing).Value2 = future.소매_수익_소계;
_WorkSheet.get_Range("O49", Type.Missing).Value2 = future.get소매_비용_인건비_급여_복리후생비();
_WorkSheet.get_Range("O50", Type.Missing).Value2 = future.get소매_비용_임차료();
_WorkSheet.get_Range("O51", Type.Missing).Value2 = future.get소매_비용_이자비용();
_WorkSheet.get_Range("O52", Type.Missing).Value2 = future.get소매_비용_부가세();
_WorkSheet.get_Range("O53", Type.Missing).Value2 = future.get소매_비용_법인세();
_WorkSheet.get_Range("O54", Type.Missing).Value2 = future.get소매_비용_기타판매관리비();
_WorkSheet.get_Range("O55", Type.Missing).Value2 = future.소매_비용_소계;
_WorkSheet.get_Range("O56", Type.Missing).Value2 = future.소매손익계;
_WorkSheet.get_Range("O57", Type.Missing).Value2 = future.점별손익추정;
}
public void saveAsInput()
{
CReportData rptd = CDataControl.g_ReportData;
CBasicInput bi = CDataControl.g_BasicInput;
CBusinessData di = CDataControl.g_DetailInput;
CResultData[] rdts = new CResultData[]{CDataControl.g_ResultStoreTotal, CDataControl.g_ResultFutureTotal};
CResultData[] rds = new CResultData[]{CDataControl.g_ResultStore, CDataControl.g_ResultFuture};
CResultData rdt = null;
CResultData rd = null;
rptd.set통신사(통신사.SelectedIndex == -1 ? "" : 통신사.Items[통신사.SelectedIndex].ToString());
rptd.set지역(지역.SelectedIndex == -1 ? "" : 지역.Items[지역.SelectedIndex].ToString());
rptd.set대리점(대리점명.Text);
rptd.set마케터(마케터.Text);
bi.set통신사(통신사.SelectedIndex == -1 ? "" : 통신사.Items[통신사.SelectedIndex].ToString());
bi.set지역(지역.SelectedIndex == -1 ? "" : 지역.Items[지역.SelectedIndex].ToString());
bi.set대리점(대리점명.Text);
bi.set마케터(마케터.Text);
String[] txtWrite = new String[14] { txtInput1.Text, txtInput2.Text, txtInput3.Text, txtInput5.Text, txtInput6.Text,
txtInput8.Text, txtInput9.Text, txtInput11.Text, txtInput12.Text, txtInput14.Text, txtInput15.Text, txtInput17.Text, txtInput19.Text, txtInput20.Text};
String[] txtWrite2 = new String[31] {
txtDetail1.Text, txtDetail2.Text, txtDetail4.Text, txtDetail5.Text, txtDetail6.Text, // 도매 수익
txtDetail7.Text, txtDetail8.Text, txtDetail11.Text, txtDetail12.Text, txtDetail13.Text, txtDetail14.Text, txtDetail15.Text, txtDetail16.Text, txtDetail17.Text, txtDetail18.Text, // 도매 비용
txtDetail19.Text, txtDetail20.Text, txtDetail23.Text, txtDetail24.Text, txtDetail25.Text, txtDetail26.Text, txtDetail27.Text, txtDetail28.Text, // 소매
txtDetail29.Text, txtDetail30.Text, txtDetail31.Text, txtDetail32.Text, txtDetail33.Text, txtDetail34.Text, txtDetail35.Text, txtDetail36.Text // 도소매합산
};
CommonUtil.setInputData(txtWrite, txtWrite2, bi, di, rdts, rds, rdt, rd, CDataControl.g_ResultBusinessTotal, CDataControl.g_ResultBusiness);
}
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);
}
//OpInspsr 정보를 파일로 저장한다
public void AddSaveData(String 통신사, String 지역, String 대리점명, String 마케터, String 단위당손익, String 월capa, String 가입자수,
String 직영점판매수익, String 선택여부, String mExcelFileName,
CBasicInput mBI, CBusinessData mDI, CResultData mRD)
{
XmlNode nodeItems = null;
//int nkey = 0;
if (mXmlDoc.FirstChild == null)
{
//XmlDocument xmlDoc = new XmlDocument();
nodeItems = mXmlDoc.CreateNode("element", "Items", "");
//nkey = 0;
//XmlAttribute xmlAtt = mXmlDoc.CreateAttribute("key");
//xmlAtt.Value = "0";
}
else
{
nodeItems = mXmlDoc.FirstChild;
}
XmlNode nodeItem = mXmlDoc.CreateNode("element", "Item", "");
XmlNode node0 = mXmlDoc.CreateNode("element", "key", "");
node0.InnerText = getKey();
//리스트 기본 데이터
XmlNode node통신사 = mXmlDoc.CreateNode("element", "통신사", "");
node통신사.InnerText = 통신사;
XmlNode node1 = mXmlDoc.CreateNode("element", "지역", "");
node1.InnerText = 지역;
XmlNode node2 = mXmlDoc.CreateNode("element", "대리점명", "");
node2.InnerText = 대리점명;
XmlNode node3 = mXmlDoc.CreateNode("element", "마케터", "");
node3.InnerText = 마케터;
XmlNode node4 = mXmlDoc.CreateNode("element", "단위당손익", "");
node4.InnerText = 단위당손익;
XmlNode node5 = mXmlDoc.CreateNode("element", "월capa", "");
node5.InnerText = 월capa;
XmlNode node6 = mXmlDoc.CreateNode("element", "가입자수", "");
node6.InnerText = 가입자수;
XmlNode node7 = mXmlDoc.CreateNode("element", "직영점판매수익", "");
node7.InnerText = 직영점판매수익;
XmlNode node8 = mXmlDoc.CreateNode("element", "선택여부", "");
node8.InnerText = 선택여부;
XmlNode node9 = mXmlDoc.CreateNode("element", "엑셀파일명", "");
node9.InnerText = mExcelFileName;
//기본입력 데이터
XmlNode node10 = mXmlDoc.CreateNode("element", "기본입력_도매_누적가입자수", "");
node10.InnerText = mBI.getstr도매_누적가입자수();
XmlNode node11 = mXmlDoc.CreateNode("element", "기본입력_도매_월평균판매대수_신규", "");
node11.InnerText = mBI.getstr도매_월평균판매대수_신규();
XmlNode node12 = mXmlDoc.CreateNode("element", "기본입력_도매_월평균판매대수_기변", "");
node12.InnerText = mBI.getstr도매_월평균판매대수_기변();
XmlNode node13 = mXmlDoc.CreateNode("element", "기본입력_도매_월평균유통모델출고대수_LG", "");
node13.InnerText = mBI.getstr도매_월평균유통모델출고대수_LG();
XmlNode node14 = mXmlDoc.CreateNode("element", "기본입력_도매_월평균유통모델출고대수_SS", "");
node14.InnerText = mBI.getstr도매_월평균유통모델출고대수_SS();
XmlNode node15 = mXmlDoc.CreateNode("element", "기본입력_도매_거래선수_개통사무실", "");
node15.InnerText = mBI.getstr도매_거래선수_개통사무실();
XmlNode node16 = mXmlDoc.CreateNode("element", "기본입력_도매_거래선수_판매점", "");
node16.InnerText = mBI.getstr도매_거래선수_판매점();
XmlNode node17 = mXmlDoc.CreateNode("element", "기본입력_도매_직원수_간부급", "");
node17.InnerText = mBI.getstr도매_직원수_간부급();
XmlNode node18 = mXmlDoc.CreateNode("element", "기본입력_도매_직원수_평사원", "");
node18.InnerText = mBI.getstr도매_직원수_평사원();
XmlNode node19 = mXmlDoc.CreateNode("element", "기본입력_소매_월평균판매대수_신규", "");
node19.InnerText = mBI.getstr소매_월평균판매대수_신규();
XmlNode node20 = mXmlDoc.CreateNode("element", "기본입력_소매_월평균판매대수_기변", "");
node20.InnerText = mBI.getstr소매_월평균판매대수_기변();
XmlNode node21 = mXmlDoc.CreateNode("element", "기본입력_소매_거래선수_직영점", "");
node21.InnerText = mBI.getstr소매_거래선수_직영점();
XmlNode node22 = mXmlDoc.CreateNode("element", "기본입력_소매_직원수_간부급", "");
node22.InnerText = mBI.getstr소매_직원수_간부급();
XmlNode node23 = mXmlDoc.CreateNode("element", "기본입력_소매_직원수_평사원", "");
node23.InnerText = mBI.getstr소매_직원수_평사원();
//상세입력 데이터
XmlNode node24 = mXmlDoc.CreateNode("element", "상세입력_도매_수익_월평균관리수수료", "");
node24.InnerText = mDI.getstr도매_수익_월평균관리수수료();
XmlNode node25 = mXmlDoc.CreateNode("element", "상세입력_도매_수익_CS관리수수료", "");
node25.InnerText = mDI.getstr도매_수익_CS관리수수료();
XmlNode node26 = mXmlDoc.CreateNode("element", "상세입력_도매_수익_사업자모델매입관련추가수익", "");
node26.InnerText = mDI.getstr도매_수익_사업자모델매입관련추가수익();
XmlNode node27 = mXmlDoc.CreateNode("element", "상세입력_도매_수익_유통모델매입관련추가수익_현금DC", "");
node27.InnerText = mDI.getstr도매_수익_유통모델매입관련추가수익_현금DC();
XmlNode node28 = mXmlDoc.CreateNode("element", "상세입력_도매_수익_유통모델매입관련추가수익_VolumeDC", "");
node28.InnerText = mDI.getstr도매_수익_유통모델매입관련추가수익_VolumeDC();
XmlNode node29 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_대리점투자금액_신규", "");
node29.InnerText = mDI.getstr도매_비용_대리점투자금액_신규();
XmlNode node30 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_대리점투자금액_기변", "");
node30.InnerText = mDI.getstr도매_비용_대리점투자금액_기변();
XmlNode node31 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_직원급여_간부급", "");
node31.InnerText = mDI.getstr도매_비용_직원급여_간부급();
XmlNode node32 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_직원급여_평사원", "");
node32.InnerText = mDI.getstr도매_비용_직원급여_평사원();
XmlNode node33 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_지급임차료", "");
node33.InnerText = mDI.getstr도매_비용_지급임차료();
XmlNode node34 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_운반비", "");
node34.InnerText = mDI.getstr도매_비용_운반비();
XmlNode node35 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_차량유지비", "");
node35.InnerText = mDI.getstr도매_비용_차량유지비();
XmlNode node36 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_지급수수료", "");
node36.InnerText = mDI.getstr도매_비용_지급수수료();
XmlNode node37 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_판매촉진비", "");
node37.InnerText = mDI.getstr도매_비용_판매촉진비();
XmlNode node38 = mXmlDoc.CreateNode("element", "상세입력_도매_비용_건물관리비", "");
node38.InnerText = mDI.getstr도매_비용_건물관리비();
XmlNode node39 = mXmlDoc.CreateNode("element", "상세입력_소매_수익_월평균업무취급수수료", "");
node39.InnerText = mDI.getstr소매_수익_월평균업무취급수수료();
XmlNode node40 = mXmlDoc.CreateNode("element", "상세입력_소매_수익_직영매장판매수익", "");
node40.InnerText = mDI.getstr소매_수익_직영매장판매수익();
XmlNode node41 = mXmlDoc.CreateNode("element", "상세입력_소매_비용_직원급여_간부급", "");
node41.InnerText = mDI.getstr소매_비용_직원급여_간부급();
XmlNode node42 = mXmlDoc.CreateNode("element", "상세입력_소매_비용_직원급여_평사원", "");
node42.InnerText = mDI.getstr소매_비용_직원급여_평사원();
XmlNode node43 = mXmlDoc.CreateNode("element", "상세입력_소매_비용_지급임차료", "");
node43.InnerText = mDI.getstr소매_비용_지급임차료();
XmlNode node44 = mXmlDoc.CreateNode("element", "상세입력_소매_비용_지급수수료", "");
node44.InnerText = mDI.getstr소매_비용_지급수수료();
XmlNode node45 = mXmlDoc.CreateNode("element", "상세입력_소매_비용_판매촉진비", "");
node45.InnerText = mDI.getstr소매_비용_판매촉진비();
XmlNode node46 = mXmlDoc.CreateNode("element", "상세입력_소매_비용_건물관리비", "");
node46.InnerText = mDI.getstr소매_비용_건물관리비();
XmlNode node47 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_복리후생비", "");
node47.InnerText = mDI.getstr도소매_비용_복리후생비();
XmlNode node48 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_통신비", "");
node48.InnerText = mDI.getstr도소매_비용_통신비();
XmlNode node49 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_공과금", "");
node49.InnerText = mDI.getstr도소매_비용_공과금();
XmlNode node50 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_소모품비", "");
node50.InnerText = mDI.getstr도소매_비용_소모품비();
XmlNode node51 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_이자비용", "");
node51.InnerText = mDI.getstr도소매_비용_이자비용();
XmlNode node52 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_부가세", "");
node52.InnerText = mDI.getstr도소매_비용_부가세();
XmlNode node53 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_법인세", "");
node53.InnerText = mDI.getstr도소매_비용_법인세();
XmlNode node54 = mXmlDoc.CreateNode("element", "상세입력_도소매_비용_기타", "");
node54.InnerText = mDI.getstr도소매_비용_기타();
//결과 단위당 데이터
XmlNode node55 = mXmlDoc.CreateNode("element", "결과_도매_수익_가입자관리수수료", "");
node55.InnerText = mRD.getstr도매_수익_가입자관리수수료();
XmlNode node56 = mXmlDoc.CreateNode("element", "결과_도매_수익_CS관리수수료", "");
node56.InnerText = mRD.getstr도매_수익_CS관리수수료();
XmlNode node57 = mXmlDoc.CreateNode("element", "결과_소매_수익_업무취급수수료", "");
node57.InnerText = mRD.getstr소매_수익_업무취급수수료();
XmlNode node58 = mXmlDoc.CreateNode("element", "결과_도매_수익_사업자모델매입에따른추가수익", "");
node58.InnerText = mRD.getstr도매_수익_사업자모델매입에따른추가수익();
XmlNode node59 = mXmlDoc.CreateNode("element", "결과_도매_수익_유통모델매입에따른추가수익_현금_Volume", "");
node59.InnerText = mRD.getstr도매_수익_유통모델매입에따른추가수익_현금_Volume();
XmlNode node60 = mXmlDoc.CreateNode("element", "결과_소매_수익_직영매장판매수익", "");
node60.InnerText = mRD.getstr소매_수익_직영매장판매수익();
XmlNode node61 = mXmlDoc.CreateNode("element", "결과_전체_비용_대리점투자비용", "");
node61.InnerText = mRD.getstr전체_비용_대리점투자비용();
XmlNode node62 = mXmlDoc.CreateNode("element", "결과_전체_비용_인건비_급여_복리후생비", "");
node62.InnerText = mRD.getstr전체_비용_인건비_급여_복리후생비();
XmlNode node63 = mXmlDoc.CreateNode("element", "결과_전체_비용_임차료", "");
node63.InnerText = mRD.getstr전체_비용_임차료();
XmlNode node64 = mXmlDoc.CreateNode("element", "결과_전체_비용_이자비용", "");
node64.InnerText = mRD.getstr전체_비용_이자비용();
XmlNode node65 = mXmlDoc.CreateNode("element", "결과_전체_비용_부가세", "");
node65.InnerText = mRD.getstr전체_비용_부가세();
XmlNode node66 = mXmlDoc.CreateNode("element", "결과_전체_비용_법인세", "");
node66.InnerText = mRD.getstr전체_비용_법인세();
XmlNode node67 = mXmlDoc.CreateNode("element", "결과_도매_비용_대리점투자비용", "");
node67.InnerText = mRD.getstr도매_비용_대리점투자비용();
XmlNode node68 = mXmlDoc.CreateNode("element", "결과_도매_비용_인건비_급여_복리후생비", "");
node68.InnerText = mRD.getstr도매_비용_인건비_급여_복리후생비();
XmlNode node69 = mXmlDoc.CreateNode("element", "결과_도매_비용_임차료", "");
node69.InnerText = mRD.getstr도매_비용_임차료();
XmlNode node70 = mXmlDoc.CreateNode("element", "결과_도매_비용_이자비용", "");
node70.InnerText = mRD.getstr도매_비용_이자비용();
XmlNode node71 = mXmlDoc.CreateNode("element", "결과_도매_비용_부가세", "");
node71.InnerText = mRD.getstr도매_비용_부가세();
XmlNode node72 = mXmlDoc.CreateNode("element", "결과_도매_비용_법인세", "");
node72.InnerText = mRD.getstr도매_비용_법인세();
XmlNode node73 = mXmlDoc.CreateNode("element", "결과_도매_비용_기타판매관리비", "");
node73.InnerText = mRD.getstr도매_비용_기타판매관리비();
XmlNode node74 = mXmlDoc.CreateNode("element", "결과_소매_비용_인건비_급여_복리후생비", "");
node74.InnerText = mRD.getstr소매_비용_인건비_급여_복리후생비();
XmlNode node75 = mXmlDoc.CreateNode("element", "결과_소매_비용_임차료", "");
node75.InnerText = mRD.getstr소매_비용_임차료();
XmlNode node76 = mXmlDoc.CreateNode("element", "결과_소매_비용_이자비용", "");
node76.InnerText = mRD.getstr소매_비용_이자비용();
XmlNode node77 = mXmlDoc.CreateNode("element", "결과_소매_비용_부가세", "");
node77.InnerText = mRD.getstr소매_비용_부가세();
XmlNode node78 = mXmlDoc.CreateNode("element", "결과_소매_비용_법인세", "");
node78.InnerText = mRD.getstr소매_비용_법인세();
XmlNode node79 = mXmlDoc.CreateNode("element", "결과_소매_비용_기타판매관리비", "");
node79.InnerText = mRD.getstr소매_비용_기타판매관리비();
nodeItem.AppendChild(node0);
nodeItem.AppendChild(node통신사);
nodeItem.AppendChild(node1);
nodeItem.AppendChild(node2);
nodeItem.AppendChild(node3);
nodeItem.AppendChild(node4);
nodeItem.AppendChild(node5);
nodeItem.AppendChild(node6);
nodeItem.AppendChild(node7);
nodeItem.AppendChild(node8);
nodeItem.AppendChild(node9);
nodeItem.AppendChild(node10);
nodeItem.AppendChild(node11);
nodeItem.AppendChild(node12);
nodeItem.AppendChild(node13);
nodeItem.AppendChild(node14);
nodeItem.AppendChild(node15);
nodeItem.AppendChild(node16);
nodeItem.AppendChild(node17);
nodeItem.AppendChild(node18);
nodeItem.AppendChild(node19);
nodeItem.AppendChild(node20);
nodeItem.AppendChild(node21);
nodeItem.AppendChild(node22);
nodeItem.AppendChild(node23);
nodeItem.AppendChild(node24);
nodeItem.AppendChild(node25);
nodeItem.AppendChild(node26);
nodeItem.AppendChild(node27);
nodeItem.AppendChild(node28);
nodeItem.AppendChild(node29);
nodeItem.AppendChild(node30);
nodeItem.AppendChild(node31);
nodeItem.AppendChild(node32);
nodeItem.AppendChild(node33);
nodeItem.AppendChild(node34);
nodeItem.AppendChild(node35);
nodeItem.AppendChild(node36);
nodeItem.AppendChild(node37);
nodeItem.AppendChild(node38);
nodeItem.AppendChild(node39);
nodeItem.AppendChild(node40);
nodeItem.AppendChild(node41);
nodeItem.AppendChild(node42);
nodeItem.AppendChild(node43);
nodeItem.AppendChild(node44);
nodeItem.AppendChild(node45);
nodeItem.AppendChild(node46);
nodeItem.AppendChild(node47);
nodeItem.AppendChild(node48);
nodeItem.AppendChild(node49);
nodeItem.AppendChild(node50);
nodeItem.AppendChild(node51);
nodeItem.AppendChild(node52);
nodeItem.AppendChild(node53);
nodeItem.AppendChild(node54);
nodeItem.AppendChild(node55);
nodeItem.AppendChild(node56);
nodeItem.AppendChild(node57);
nodeItem.AppendChild(node58);
nodeItem.AppendChild(node59);
nodeItem.AppendChild(node60);
nodeItem.AppendChild(node61);
nodeItem.AppendChild(node62);
nodeItem.AppendChild(node63);
nodeItem.AppendChild(node64);
nodeItem.AppendChild(node65);
nodeItem.AppendChild(node66);
nodeItem.AppendChild(node67);
nodeItem.AppendChild(node68);
nodeItem.AppendChild(node69);
nodeItem.AppendChild(node70);
nodeItem.AppendChild(node71);
nodeItem.AppendChild(node72);
nodeItem.AppendChild(node73);
nodeItem.AppendChild(node74);
nodeItem.AppendChild(node75);
nodeItem.AppendChild(node76);
nodeItem.AppendChild(node77);
nodeItem.AppendChild(node78);
nodeItem.AppendChild(node79);
nodeItems.AppendChild(nodeItem);
mXmlDoc.AppendChild(nodeItems);
mXmlDoc.Save(mXmlFileName);
}
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;
}
}
}
}
public void setmRD(CResultData value)
{
mRD = value;
}
// chart1 - 수익계정 전체 CResultData
//private void OpenChart(Chart chart, excel.Worksheet sheet)
private void OpenChart(Chart chart, CResultData _bizResult, CResultData _storeResult)
{
if (_bizResult == null || _storeResult == null) return;
double[] yValues = null;
double[] yValues2 = null;
string[] xValues = null;
if (chart.Name == "chart1")
{
xValues = new string[6] { "A", "B", "C", "D", "E", "F" };
yValues = new double[6]{
Convert.ToDouble(_bizResult.get전체_수익_가입자관리수수료()),
Convert.ToDouble(_bizResult.get전체_수익_CS관리수수료()),
Convert.ToDouble(_bizResult.get전체_수익_업무취급수수료()),
Convert.ToDouble(_bizResult.get전체_수익_사업자모델매입에따른추가수익()),
Convert.ToDouble(_bizResult.get전체_수익_유통모델매입에따른추가수익_현금_Volume()),
Convert.ToDouble(_bizResult.get전체_수익_직영매장판매수익())
};
yValues2 = new double[6]{
Convert.ToDouble(_storeResult.get전체_수익_가입자관리수수료()),
Convert.ToDouble(_storeResult.get전체_수익_CS관리수수료()),
Convert.ToDouble(_storeResult.get전체_수익_업무취급수수료()),
Convert.ToDouble(_storeResult.get전체_수익_사업자모델매입에따른추가수익()),
Convert.ToDouble(_storeResult.get전체_수익_유통모델매입에따른추가수익_현금_Volume()),
Convert.ToDouble(_storeResult.get전체_수익_직영매장판매수익())
};
}
else if (chart.Name == "chart5")
{
xValues = new string[7] { "A", "B", "C", "D", "E", "F", "G" };
yValues = new double[7]{
Convert.ToDouble(_bizResult.get전체_비용_대리점투자비용()),
Convert.ToDouble(_bizResult.get전체_비용_인건비_급여_복리후생비()),
Convert.ToDouble(_bizResult.get전체_비용_임차료()),
Convert.ToDouble(_bizResult.get전체_비용_이자비용()),
Convert.ToDouble(_bizResult.get전체_비용_부가세()),
Convert.ToDouble(_bizResult.get전체_비용_법인세()),
Convert.ToDouble(_bizResult.get전체_비용_기타판매관리비())
};
yValues2 = new double[7]{
Convert.ToDouble(_storeResult.get전체_비용_대리점투자비용()),
Convert.ToDouble(_storeResult.get전체_비용_인건비_급여_복리후생비()),
Convert.ToDouble(_storeResult.get전체_비용_임차료()),
Convert.ToDouble(_storeResult.get전체_비용_이자비용()),
Convert.ToDouble(_storeResult.get전체_비용_부가세()),
Convert.ToDouble(_storeResult.get전체_비용_법인세()),
Convert.ToDouble(_storeResult.get전체_비용_기타판매관리비())
};
}
chart.Series[0].Name = "업계평균";
chart.Series[1].Name = "당대리점";
chart.Series[0].Points.DataBindXY(xValues, yValues);
chart.Series[1].Points.DataBindXY(xValues, yValues2);
}
private void SaveAsInput()
{
CBasicInput bi = CDataControl.g_SimBasicInput;
CBusinessData di = CDataControl.g_SimDetailInput;
CResultData[] rdts = new CResultData[] { CDataControl.g_SimResultStoreTotal, CDataControl.g_SimResultFutureTotal };
CResultData[] rds = new CResultData[] { CDataControl.g_SimResultStore, CDataControl.g_SimResultFuture };
CResultData rdt = null;
CResultData rd = null;
bi.set통신사(통신사);
bi.set지역(area);
bi.set대리점(beanch);
bi.set마케터(name);
String[] txtWrite = new String[14] { txtInput10.Text, txtInput11.Text, txtInput12.Text, txtInput13.Text, txtInput14.Text,
txtInput15.Text, txtInput16.Text, txtInput17.Text, txtInput18.Text, txtInput24.Text, txtInput25.Text, txtInput26.Text, txtInput27.Text, txtInput28.Text};
String[] txtWrite2 = new String[31] {
txtDetail37.Text, txtDetail38.Text, txtDetail39.Text, txtDetail40.Text, txtDetail41.Text,
txtDetail43.Text, txtDetail44.Text, txtDetail45.Text, txtDetail46.Text, txtDetail47.Text, txtDetail48.Text, txtDetail49.Text, txtDetail50.Text, txtDetail51.Text, txtDetail52.Text,
txtDetail54.Text, txtDetail55.Text,
txtDetail57.Text, txtDetail58.Text, txtDetail59.Text, txtDetail60.Text, txtDetail61.Text, txtDetail62.Text,
txtDetail64.Text, txtDetail65.Text, txtDetail66.Text, txtDetail67.Text, txtDetail68.Text, txtDetail69.Text, txtDetail70.Text, txtDetail71.Text
};
CommonUtil.setInputData(txtWrite, txtWrite2, bi, di, rdts, rds, rdt, rd, CDataControl.g_SimResultBusinessTotal, CDataControl.g_SimResultBusiness);
}