private void CreateLRProductSheet(IExcel excelApp)
{
excelApp.SetCellValue(1, "A", "BusiNo");
excelApp.SetCellValue(1, "B", "CompanyCode");
excelApp.SetCellValue(1, "C", "ReInsuranceContNo");
excelApp.SetCellValue(1, "D", "ReInsuranceContName");
excelApp.SetCellValue(1, "E", "ReInsuranceContTitle");
excelApp.SetCellValue(1, "F", "MainReInsuranceContNo");
excelApp.SetCellValue(1, "G", "ContOrAmendmentType");
excelApp.SetCellValue(1, "H", "ProductCode");
excelApp.SetCellValue(1, "I", "ProductName");
excelApp.SetCellValue(1, "J", "GPFlag");
excelApp.SetCellValue(1, "K", "ProductType");
excelApp.SetCellValue(1, "L", "LiabilityCode");
excelApp.SetCellValue(1, "M", "LiabilityName");
excelApp.SetCellValue(1, "N", "ReinsurerCode");
excelApp.SetCellValue(1, "O", "ReinsurerName");
excelApp.SetCellValue(1, "P", "ReinsuranceShare");
excelApp.SetCellValue(1, "Q", "ReinsurMode");
excelApp.SetCellValue(1, "R", "ReInsuranceType");
excelApp.SetCellValue(1, "S", "TermType");
excelApp.SetCellValue(1, "T", "RetentionAmount");
excelApp.SetCellValue(1, "U", "RetentionPercentage");
excelApp.SetCellValue(1, "V", "QuotaSharePercentage");
excelApp.SetColumnTextType("Sheet1", 1);
excelApp.SetColumnTextType("Sheet1", 2);
excelApp.SetColumnTextType("Sheet1", 10);
excelApp.SetColumnTextType("Sheet1", 14);
excelApp.SetColumnTextType("Sheet1", 18);
excelApp.Save();
}
private void CreateLRInsureContSheet(IExcel excelApp)
{
excelApp.SetCellValue(1, "A", "BusiNo");
excelApp.SetCellValue(1, "B", "CompanyCode");
excelApp.SetCellValue(1, "C", "ReInsuranceContNo");
excelApp.SetCellValue(1, "D", "ReInsuranceContName");
excelApp.SetCellValue(1, "E", "ReInsuranceContTitle");
excelApp.SetCellValue(1, "F", "MainReInsuranceContNo");
excelApp.SetCellValue(1, "G", "ContOrAmendmentType");
excelApp.SetCellValue(1, "H", "ContAttribute");
excelApp.SetCellValue(1, "I", "ContStatus");
excelApp.SetCellValue(1, "J", "TreatyOrFacultativeFlag");
excelApp.SetCellValue(1, "K", "ContSigndate");
excelApp.SetCellValue(1, "L", "PeriodFrom");
excelApp.SetCellValue(1, "M", "PeriodTo");
excelApp.SetCellValue(1, "N", "ContType");
excelApp.SetCellValue(1, "O", "ReinsurerCode");
excelApp.SetCellValue(1, "P", "ReinsurerName");
excelApp.SetCellValue(1, "Q", "ChargeType");
excelApp.SetColumnTextType("Sheet1", 1);
excelApp.SetColumnTextType("Sheet1", 2);
excelApp.SetColumnTextType("Sheet1", 15);
excelApp.SetColumnDateType("Sheet1", 11);
excelApp.SetColumnDateType("Sheet1", 12);
excelApp.SetColumnDateType("Sheet1", 13);
excelApp.Save();
}
private void CreateLJInvoiceRelationSheet(IExcel excelApp)
{
excelApp.SetCellValue("Sheet1", 1, "A", "BusiNo");
excelApp.SetCellValue("Sheet1", 1, "B", "CompanyCode");
excelApp.SetCellValue("Sheet1", 1, "C", "GrpPolicyNo");
excelApp.SetCellValue("Sheet1", 1, "D", "PolicyNo");
excelApp.SetCellValue("Sheet1", 1, "E", "GPFlag");
excelApp.SetCellValue("Sheet1", 1, "F", "BussinessType");
excelApp.SetCellValue("Sheet1", 1, "G", "BussinessCode");
excelApp.SetCellValue("Sheet1", 1, "H", "InvoiceNo");
excelApp.SetCellValue("Sheet1", 1, "I", "InvoiceCode");
excelApp.SetColumnTextType("Sheet1", 1);
excelApp.SetColumnTextType("Sheet1", 2);
excelApp.Save();
}
private void CreateLRAccountSheet(IExcel excelApp)
{
excelApp.SetCellValue(1, "A", "BusiNo");
excelApp.SetCellValue(1, "B", "CompanyCode");
excelApp.SetCellValue(1, "C", "AccountID");
excelApp.SetCellValue(1, "D", "AccountingPeriodfrom");
excelApp.SetCellValue(1, "E", "AccountingPeriodto");
excelApp.SetCellValue(1, "F", "ReinsurerCode");
excelApp.SetCellValue(1, "G", "ReinsurerName");
excelApp.SetCellValue(1, "H", "ReInsuranceContNo");
excelApp.SetCellValue(1, "I", "ReInsuranceContName");
excelApp.SetCellValue(1, "J", "Currency");
excelApp.SetCellValue(1, "K", "ReinsurancePremium");
excelApp.SetCellValue(1, "L", "ReinsuranceCommssionRate");
excelApp.SetCellValue(1, "M", "ReinsuranceCommssion");
excelApp.SetCellValue(1, "N", "ReturnReinsurancePremium");
excelApp.SetCellValue(1, "O", "ReturnReinsuranceCommssion");
excelApp.SetCellValue(1, "P", "ReturnSurrenderPay");
excelApp.SetCellValue(1, "Q", "ReturnClaimPay");
excelApp.SetCellValue(1, "R", "ReturnMaturity");
excelApp.SetCellValue(1, "S", "ReturnAnnuity");
excelApp.SetCellValue(1, "T", "ReturnLivBene");
excelApp.SetCellValue(1, "U", "AccountStatus");
excelApp.SetCellValue(1, "V", "PairingStatus");
excelApp.SetCellValue(1, "W", "PairingDate");
excelApp.SetCellValue(1, "X", "CurrentRate");
excelApp.SetColumnTextType("Sheet1", 1);
excelApp.SetColumnTextType("Sheet1", 2);
excelApp.SetColumnTextType("Sheet1", 6);
excelApp.SetColumnTextType("Sheet1", 10);
excelApp.SetColumnDateType("Sheet1", 4);
excelApp.SetColumnDateType("Sheet1", 5);
excelApp.SetColumnDateType("Sheet1", 23);
excelApp.Save();
}
private void CreateLRClaimSheet(IExcel excelApp)
{
excelApp.SetCellValue(1, "A", "BusiNo");
excelApp.SetCellValue(1, "B", "CompanyCode");
excelApp.SetCellValue(1, "C", "GrpPolicyNo");
excelApp.SetCellValue(1, "D", "GrpProductNo");
excelApp.SetCellValue(1, "E", "PolicyNo");
excelApp.SetCellValue(1, "F", "ProductNo");
excelApp.SetCellValue(1, "G", "GPFlag");
excelApp.SetCellValue(1, "H", "MainProductNo");
excelApp.SetCellValue(1, "I", "MainProductFlag");
excelApp.SetCellValue(1, "J", "ProductCode");
excelApp.SetCellValue(1, "K", "LiabilityCode");
excelApp.SetCellValue(1, "L", "LiabilityName");
excelApp.SetCellValue(1, "M", "GetLiabilityCode");
excelApp.SetCellValue(1, "N", "GetLiabilityName");
excelApp.SetCellValue(1, "O", "BenefitType");
excelApp.SetCellValue(1, "P", "TermType");
excelApp.SetCellValue(1, "Q", "ManageCom");
excelApp.SetCellValue(1, "R", "SignDate");
excelApp.SetCellValue(1, "S", "EffDate");
excelApp.SetCellValue(1, "T", "PolYear");
excelApp.SetCellValue(1, "U", "InvalidDate");
excelApp.SetCellValue(1, "V", "UWConclusion");
excelApp.SetCellValue(1, "W", "PolStatus");
excelApp.SetCellValue(1, "X", "Status");
excelApp.SetCellValue(1, "Y", "BasicSumInsured");
excelApp.SetCellValue(1, "Z", "RiskAmnt");
excelApp.SetCellValue(1, "AA", "Premium");
excelApp.SetCellValue(1, "AB", "DeductibleType");
excelApp.SetCellValue(1, "AC", "Deductible");
excelApp.SetCellValue(1, "AD", "ClaimRatio");
excelApp.SetCellValue(1, "AE", "AccountValue");
excelApp.SetCellValue(1, "AF", "FacultativeFlag");
excelApp.SetCellValue(1, "AG", "AnonymousFlag");
excelApp.SetCellValue(1, "AH", "WaiverFlag");
excelApp.SetCellValue(1, "AI", "WaiverPrem");
excelApp.SetCellValue(1, "AJ", "FinalCashValue");
excelApp.SetCellValue(1, "AK", "InsuredNo");
excelApp.SetCellValue(1, "AL", "InsuredName");
excelApp.SetCellValue(1, "AM", "InsuredSex");
excelApp.SetCellValue(1, "AN", "InsuredCertType");
excelApp.SetCellValue(1, "AO", "InsuredCertNo");
excelApp.SetCellValue(1, "AP", "OccupationType");
excelApp.SetCellValue(1, "AQ", "AppntAge");
excelApp.SetCellValue(1, "AR", "PreAge");
excelApp.SetCellValue(1, "AS", "FinalLiabilityReserve");
excelApp.SetCellValue(1, "AT", "ProfessionalFee");
excelApp.SetCellValue(1, "AU", "SubStandardFee");
excelApp.SetCellValue(1, "AV", "EMRate");
excelApp.SetCellValue(1, "AW", "ProjectFlag");
excelApp.SetCellValue(1, "AX", "InsurePeoples");
excelApp.SetCellValue(1, "AY", "SaparateFlag");
excelApp.SetCellValue(1, "AZ", "ReInsuranceContNo");
excelApp.SetCellValue(1, "BA", "ReinsurerCode");
excelApp.SetCellValue(1, "BB", "ReinsurerName");
excelApp.SetCellValue(1, "BC", "ReinsurMode");
excelApp.SetCellValue(1, "BD", "ReinsuranceAmnt");
excelApp.SetCellValue(1, "BE", "RetentionAmount");
excelApp.SetCellValue(1, "BF", "QuotaSharePercentage");
excelApp.SetCellValue(1, "BG", "ClaimNo");
excelApp.SetCellValue(1, "BH", "AccidentDate");
excelApp.SetCellValue(1, "BI", "ClmSettDate");
excelApp.SetCellValue(1, "BJ", "PayStatusCode");
excelApp.SetCellValue(1, "BK", "ClaimMoney");
excelApp.SetCellValue(1, "BL", "BackClaimMoney");
excelApp.SetCellValue(1, "BM", "BackDate");
excelApp.SetCellValue(1, "BN", "Currency");
excelApp.SetCellValue(1, "BO", "ReComputationsDate");
excelApp.SetCellValue(1, "BP", "AccountGetDate");
excelApp.SetColumnTextType("Sheet1", 1);
excelApp.SetColumnTextType("Sheet1", 2);
excelApp.SetColumnTextType("Sheet1", 3);
excelApp.SetColumnTextType("Sheet1", 4);
excelApp.SetColumnTextType("Sheet1", 5);
excelApp.SetColumnTextType("Sheet1", 6);
excelApp.SetColumnTextType("Sheet1", 7);
excelApp.SetColumnTextType("Sheet1", 8);
excelApp.SetColumnTextType("Sheet1", 9);
excelApp.SetColumnTextType("Sheet1", 17);
excelApp.SetColumnTextType("Sheet1", 23);
excelApp.SetColumnTextType("Sheet1", 24);
excelApp.SetColumnTextType("Sheet1", 52);
excelApp.SetColumnTextType("Sheet1", 53);
excelApp.SetColumnTextType("Sheet1", 37);
excelApp.SetColumnTextType("Sheet1", 59);
excelApp.SetColumnTextType("Sheet1", 62);
excelApp.SetColumnDateType("Sheet1", 18);
excelApp.SetColumnDateType("Sheet1", 19);
excelApp.SetColumnDateType("Sheet1", 21);
excelApp.SetColumnDateType("Sheet1", 60);
excelApp.SetColumnDateType("Sheet1", 65);
excelApp.SetColumnDateType("Sheet1", 67);
excelApp.SetColumnDateType("Sheet1", 68);
excelApp.SetColumnDateType("Sheet1", 61);
excelApp.SetColumnDecimalsType("Sheet1", 63);
excelApp.SetColumnDecimalsType("Sheet1", 64);
excelApp.Save();
}
private void CreateLREdorSheet(IExcel excelApp)
{
excelApp.SetCellValue(1, "A", "BusiNo");
excelApp.SetCellValue(1, "B", "CompanyCode");
excelApp.SetCellValue(1, "C", "GrpPolicyNo");
excelApp.SetCellValue(1, "D", "GrpProductNo");
excelApp.SetCellValue(1, "E", "PolicyNo");
excelApp.SetCellValue(1, "F", "ProductNo");
excelApp.SetCellValue(1, "G", "GPFlag");
excelApp.SetCellValue(1, "H", "MainProductNo");
excelApp.SetCellValue(1, "I", "MainProductFlag");
excelApp.SetCellValue(1, "J", "ProductCode");
excelApp.SetCellValue(1, "K", "LiabilityCode");
excelApp.SetCellValue(1, "L", "LiabilityName");
excelApp.SetCellValue(1, "M", "Classification");
excelApp.SetCellValue(1, "N", "TermType");
excelApp.SetCellValue(1, "O", "ManageCom");
excelApp.SetCellValue(1, "P", "SignDate");
excelApp.SetCellValue(1, "Q", "EffDate");
excelApp.SetCellValue(1, "R", "PolYear");
excelApp.SetCellValue(1, "S", "InvalidDate");
excelApp.SetCellValue(1, "T", "UWConclusion");
excelApp.SetCellValue(1, "U", "PolStatus");
excelApp.SetCellValue(1, "V", "Status");
excelApp.SetCellValue(1, "W", "BasicSumInsured");
excelApp.SetCellValue(1, "X", "RiskAmnt");
excelApp.SetCellValue(1, "Y", "Premium");
excelApp.SetCellValue(1, "Z", "AccountValue");
excelApp.SetCellValue(1, "AA", "FacultativeFlag");
excelApp.SetCellValue(1, "AB", "AnonymousFlag");
excelApp.SetCellValue(1, "AC", "WaiverFlag");
excelApp.SetCellValue(1, "AD", "WaiverPrem");
excelApp.SetCellValue(1, "AE", "FinalCashValue");
excelApp.SetCellValue(1, "AF", "FinalLiabilityReserve");
excelApp.SetCellValue(1, "AG", "InsuredNo");
excelApp.SetCellValue(1, "AH", "InsuredName");
excelApp.SetCellValue(1, "AI", "InsuredSex");
excelApp.SetCellValue(1, "AJ", "InsuredCertType");
excelApp.SetCellValue(1, "AK", "InsuredCertNo");
excelApp.SetCellValue(1, "AL", "OccupationType");
excelApp.SetCellValue(1, "AM", "AppntAge");
excelApp.SetCellValue(1, "AN", "PreAge");
excelApp.SetCellValue(1, "AO", "ProfessionalFee");
excelApp.SetCellValue(1, "AP", "SubStandardFee");
excelApp.SetCellValue(1, "AQ", "EMRate");
excelApp.SetCellValue(1, "AR", "ProjectFlag");
excelApp.SetCellValue(1, "AS", "InsurePeoples");
excelApp.SetCellValue(1, "AT", "EndorAcceptNo");
excelApp.SetCellValue(1, "AU", "EndorsementNo");
excelApp.SetCellValue(1, "AV", "EdorType");
excelApp.SetCellValue(1, "AW", "EdorValiDate");
excelApp.SetCellValue(1, "AX", "EdorConfDate");
excelApp.SetCellValue(1, "AY", "EdorMoney");
excelApp.SetCellValue(1, "AZ", "SaparateFlag");
excelApp.SetCellValue(1, "BA", "ReInsuranceContNo");
excelApp.SetCellValue(1, "BB", "ReinsurerCode");
excelApp.SetCellValue(1, "BC", "ReinsurerName");
excelApp.SetCellValue(1, "BD", "ReinsurMode");
excelApp.SetCellValue(1, "BE", "QuotaSharePercentage");
excelApp.SetCellValue(1, "BF", "PreInsuredAge");
excelApp.SetCellValue(1, "BG", "PreBasicSumInsured");
excelApp.SetCellValue(1, "BH", "PreRiskAmnt");
excelApp.SetCellValue(1, "BI", "PreReinsuranceAmnt");
excelApp.SetCellValue(1, "BJ", "PreRetentionAmount");
excelApp.SetCellValue(1, "BK", "PrePremium");
excelApp.SetCellValue(1, "BL", "PreAccountValue");
excelApp.SetCellValue(1, "BM", "PreWaiverPrem");
excelApp.SetCellValue(1, "BN", "ProjectAcreageChange");
excelApp.SetCellValue(1, "BO", "ProjectCostChange");
excelApp.SetCellValue(1, "BP", "ReinsuranceAmntChange");
excelApp.SetCellValue(1, "BQ", "RetentionAmount");
excelApp.SetCellValue(1, "BR", "ReinsurancePremiumChange");
excelApp.SetCellValue(1, "BS", "ReinsuranceCommssionChange");
excelApp.SetCellValue(1, "BT", "Currency");
excelApp.SetCellValue(1, "BU", "ReComputationsDate");
excelApp.SetCellValue(1, "BV", "AccountGetDate");
excelApp.SetColumnTextType("Sheet1", 1);
excelApp.SetColumnTextType("Sheet1", 2);
excelApp.SetColumnTextType("Sheet1", 3);
excelApp.SetColumnTextType("Sheet1", 4);
excelApp.SetColumnTextType("Sheet1", 5);
excelApp.SetColumnTextType("Sheet1", 6);
excelApp.SetColumnTextType("Sheet1", 7);
excelApp.SetColumnTextType("Sheet1", 8);
excelApp.SetColumnTextType("Sheet1", 9);
excelApp.SetColumnTextType("Sheet1", 13);
excelApp.SetColumnTextType("Sheet1", 15);
excelApp.SetColumnTextType("Sheet1", 21);
excelApp.SetColumnTextType("Sheet1", 22);
excelApp.SetColumnTextType("Sheet1", 53);
excelApp.SetColumnTextType("Sheet1", 54);
excelApp.SetColumnTextType("Sheet1", 33);
excelApp.SetColumnTextType("Sheet1", 48);
excelApp.SetColumnTextType("Sheet1", 72);
excelApp.SetColumnDateType("Sheet1", 16);
excelApp.SetColumnDateType("Sheet1", 17);
excelApp.SetColumnDateType("Sheet1", 19);
excelApp.SetColumnDateType("Sheet1", 49);
excelApp.SetColumnDateType("Sheet1", 50);
excelApp.SetColumnDateType("Sheet1", 73);
excelApp.SetColumnDateType("Sheet1", 74);
excelApp.Save();
}