private void LacRemitListExcelDownload(FlowModelData data)
{
WaitFile(data.File.FullName, () =>
{
logger.Info("3-2.정산내역 ( 정산관리 > 정산내역 조회 > 옥션 정산내역 관리 ) Excel");
logger.Debug("IacRemitListExcelDownload");
logger.Debug("IacRemitListExcelDownload Excel analysis");
BuilderExcelEntity <LacRemitListExcel> builder = new BuilderExcelEntity <LacRemitListExcel>();
List <LacRemitListExcel> list = builder.Builder(data.File.FullName);
int index = 0;
foreach (var item in list)
{
SetPackageData(1, index++, ToExcelJson(ReflectFlyweight[typeof(LacRemitListExcel)], item));
}
list.Clear();
try
{
DateTime enddate = DateTime.Now;
DateTime startdate = enddate.AddYears(-1).AddDays(1);
this.buffer.Append("https://www.esmplus.com/Escrow/Delivery/GeneralDelivery?");
this.buffer.Append(CreateGetParameter(new Dictionary <String, String>()
{
{ "gbn", "0" },
{ "status", "0" },
{ "type", "" },
{ "searchAccount", idcode + "^1" },
{ "searchDateType", "" },
{ "searchSDT", startdate.ToString("yyyy-MM-dd") },
{ "searchEDT", enddate.ToString("yyyy-MM-dd") },
{ "searchKey", "" },
{ "searchKeyword", "" },
{ "searchDeliveryType", "nomal" },
{ "searchOrderType", "" },
{ "searchPacking", "" },
{ "totalAccumulate", "-" },
{ "searchTransPolicyType", "" }
}));
base.Navigate(this.buffer.ToString());
}
finally
{
this.buffer.Clear();
}
});
}
private void BuyDecisionExcel(FlowModelData data)
{
WaitFile(data.File.FullName, () =>
{
logger.Info("2-2.매출내역 ( 주문관리 > 구매결정완료 ) Excel");
logger.Debug("BuyDecisionExcel");
logger.Debug("BuyDecisionExcel Excel analysis");
BuilderExcelEntity <BuyDecisionExcel> builder = new BuilderExcelEntity <BuyDecisionExcel>();
List <BuyDecisionExcel> list = builder.Builder(data.File.FullName);
logger.Debug("It complete to build excel ");
int index = 0;
foreach (var item in list)
{
SetPackageData(0, index++, ToExcelJson(ReflectFlyweight[typeof(BuyDecisionExcel)], item));
}
list.Clear();
base.Navigate("http://www.esmplus.com/Member/Settle/IacSettleDetail?menuCode=TDM298");
});
}
private void GeneralDeliveryExcel(FlowModelData data)
{
WaitFile(data.File.FullName, () =>
{
logger.Info("4-2.정산예정금 - ( 주문관리 > 발송처리 ) Excel");
logger.Debug("GeneralDeliveryExcel");
logger.Debug("GeneralDeliveryExcel Excel analysis");
BuilderExcelEntity <GeneralDeliveryExcel> builder = new BuilderExcelEntity <GeneralDeliveryExcel>();
List <GeneralDeliveryExcel> list = builder.Builder(data.File.FullName);
int index = 0;
foreach (var item in list)
{
SetPackageData(2, index++, ToExcelJson(ReflectFlyweight[typeof(GeneralDeliveryExcel)], item));
}
list.Clear();
base.Navigate("https://www.esmplus.com/Escrow/Delivery/Sending?menuCode=TDM111");
});
}
private void BuyDecisionExcel2(FlowModelData data)
{
WaitFile(data.File.FullName, () =>
{
logger.Info("4-5.정산예정금 ( 주문관리 > 구매결정완료 ) Excel");
logger.Debug("BuyDecisionExcel2");
logger.Debug("BuyDecisionExcel2 Excel analysis");
BuilderExcelEntity <BuyDecisionExcel> builder = new BuilderExcelEntity <BuyDecisionExcel>();
List <BuyDecisionExcel> list = builder.Builder(data.File.FullName);
logger.Debug("It complete to build excel ");
int index = 0;
foreach (var item in list)
{
SetPackageData(4, index++, ToExcelJson(ReflectFlyweight[typeof(BuyDecisionExcel)], item));
}
list.Clear();
base.Navigate("https://www.esmplus.com/Escrow/Claim/ReturnRequestManagement?menuCode=TDM118");
});
}
private void SendingExcel(FlowModelData data)
{
WaitFile(data.File.FullName, () =>
{
logger.Info("4-4.정산예정금 ( 주문관리 > 배송중/배송완료 )");
logger.Debug("SendingExcel");
logger.Debug("SendingExcel Excel analysis");
BuilderExcelEntity <SendingExcel> builder = new BuilderExcelEntity <SendingExcel>();
List <SendingExcel> list = builder.Builder(data.File.FullName);
int index = 0;
foreach (var item in list)
{
SetPackageData(3, index++, ToExcelJson(ReflectFlyweight[typeof(SendingExcel)], item));
}
list.Clear();
//중복플로우 처리변경
SetModifyBuyDecision();
base.Navigate("https://www.esmplus.com/Escrow/Delivery/BuyDecision?menuCode=TDM112");
});
}
private void ExcelDownload(FlowModelData data)
{
WaitFile(data.File.FullName, () =>
{
logger.Info("5-2.반품율 (클레임관리 > 반품관리 ) Excel");
logger.Debug("ExcelDownload");
logger.Debug("ExcelDownload Excel analysis");
BuilderExcelEntity <ReturnRequest> builder = new BuilderExcelEntity <ReturnRequest>();
List <ReturnRequest> list = builder.Builder(data.File.FullName);
logger.Debug("It complete to build excel ");
int index = 0;
foreach (var item in list)
{
SetPackageData(5, index++, ToExcelJson(ReflectFlyweight[typeof(ReturnRequest)], item));
}
list.Clear();
base.Navigate("http://www.esmplus.com/Sell/Items/ItemsMng?menuCode=TDM100");
//base.Navigate("http://www.esmplus.com/Areas/Manual/SellerGuide/main.html");
});
}
private IList <ExcelTemplate> ReadExcel(String excelpath)
{
BuilderExcelEntity <ExcelTemplate> builder = new BuilderExcelEntity <ExcelTemplate>();
return(builder.Builder(excelpath, false));
}