public string Data_ReportBySTAFF_Detail(string cxdata)
{
token = appClass.CRM_Gettoken();
CRM_BF_REPORT_BYSTAFF_PARAMS model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BF_REPORT_BYSTAFF_PARAMS>(cxdata);
CRM_BF_BFDJList[] data = crmModels.BF_BF.ReadKHBF_ReportByStaff_Detail(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Data_ReportBySTAFF_SummaryTotal(string cxdata)
{
string token = appClass.CRM_Gettoken();
CRM_BF_REPORT_BYSTAFF_PARAMS model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BF_REPORT_BYSTAFF_PARAMS>(cxdata);
CRM_BF_REPORT_BYSTAFF_SUMMARYTOTAL[] data = crmModels.BF_BF.ReadKHBF_ReportByStaff_SummaryTotal(model, token);
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string Data_ReportByDate_SummaryTotal(string cxdata)
{
token = appClass.CRM_Gettoken();
DataTablePlus data = new DataTablePlus();
CRM_BF_REPORT_BYSTAFF_PARAMS model = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BF_REPORT_BYSTAFF_PARAMS>(cxdata);
DataTable data1 = crmModels.BF_BF.ReadKHBF_ReportByDate_Summary(model, token);
string title = data1.Columns[0].ColumnName;
for (int i = 1; i < data1.Columns.Count; i++)
{
title = title + "," + data1.Columns[i].ColumnName;
}
data.DATA = data1;
data.TITLE = title;
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public DataTable ReadKHBF_ReportByDate_Summary(CRM_BF_REPORT_BYSTAFF_PARAMS model, string ptoken)
{
return(client.ReadKHBF_ReportByDate_Summary(model, ptoken));
}
public CRM_BF_BFDJList[] ReadKHBF_ReportByStaff_Detail(CRM_BF_REPORT_BYSTAFF_PARAMS model, string ptoken)
{
return(client.ReadKHBF_ReportByStaff_Detail(model, ptoken));
}
public CRM_BF_REPORT_BYSTAFF_SUMMARY[] ReadKHBF_ReportByStaff_Summary(CRM_BF_REPORT_BYSTAFF_PARAMS model, string ptoken)
{
return(client.ReadKHBF_ReportByStaff_Summary(model, ptoken));
}
public string Data_Daochu_BaiFangSummaryAndMX(string cxdata, string starttime, string endtime)
{
token = appClass.CRM_Gettoken();
try
{
CRM_BF_REPORT_BYSTAFF_PARAMS data = Newtonsoft.Json.JsonConvert.DeserializeObject <CRM_BF_REPORT_BYSTAFF_PARAMS>(cxdata);
CRM_BF_REPORT_BYSTAFF_SUMMARYTOTAL[] model = crmModels.BF_BF.ReadKHBF_ReportByStaff_SummaryTotal(data, token);
FileStream file = new FileStream(FileSavePath + @"\ExcelTemplate/拜访报表-人员.xls", FileMode.Open, FileAccess.Read);
IWorkbook workbook = new HSSFWorkbook(file);
ISheet worksheet1 = workbook.GetSheet("汇总");
ISheet worksheet2 = workbook.GetSheet("各类型拜访次数");
ISheet worksheet3 = workbook.GetSheet("拜访明细");
if (worksheet1 == null || worksheet2 == null || worksheet3 == null)
{
return("工作薄中没有工作表");
}
//worksheet1.AddMergedRegion(new CellRangeAddress(1, 2, 3, 4));
int row1 = 1, row2 = 1, row3 = 1;
for (int i = 0; i < model.Length; i++)
{
NPOI.SS.UserModel.IRow row_hz = worksheet1.CreateRow(row1);
row_hz.CreateCell(0).SetCellValue(model[i].STAFFNAME);
row_hz.CreateCell(1).SetCellValue(model[i].STAFFNO);
row_hz.CreateCell(2).SetCellValue(model[i].DEPNAME);
row_hz.CreateCell(3).SetCellValue(model[i].TOTAL_COUNT);
row1++;
CRM_BF_REPORT_BYSTAFF_PARAMS cxmodel = new CRM_BF_REPORT_BYSTAFF_PARAMS();
cxmodel.STAFFID = model[i].STAFFID;
cxmodel.BEGINDATE = starttime;
cxmodel.ENDDATE = endtime;
CRM_BF_REPORT_BYSTAFF_SUMMARY[] BFCSdata = crmModels.BF_BF.ReadKHBF_ReportByStaff_Summary(cxmodel, token);
for (int j = 0; j < BFCSdata.Length; j++)
{
NPOI.SS.UserModel.IRow row_bfcs = worksheet2.CreateRow(row2);
row_bfcs.CreateCell(0).SetCellValue(model[i].STAFFNAME);
row_bfcs.CreateCell(1).SetCellValue(model[i].STAFFNO);
row_bfcs.CreateCell(2).SetCellValue(model[i].DEPNAME);
row_bfcs.CreateCell(3).SetCellValue(BFCSdata[j].BFLXDES);
row_bfcs.CreateCell(4).SetCellValue(BFCSdata[j].FINISHCOUNTS);
row2++;
CRM_BF_REPORT_BYSTAFF_PARAMS cxmodel2 = new CRM_BF_REPORT_BYSTAFF_PARAMS();
cxmodel2.BEGINDATE = starttime;
cxmodel2.ENDDATE = endtime;
cxmodel2.STAFFID = model[i].STAFFID;
cxmodel2.BFLX = BFCSdata[j].BFLX;
CRM_BF_BFDJList[] MXdata = crmModels.BF_BF.ReadKHBF_ReportByStaff_Detail(cxmodel2, token);
for (int k = 0; k < MXdata.Length; k++)
{
NPOI.SS.UserModel.IRow row_mx = worksheet3.CreateRow(row3);
row_mx.CreateCell(0).SetCellValue(MXdata[k].BFLXDES);
row_mx.CreateCell(1).SetCellValue(MXdata[k].BFJHMC);
row_mx.CreateCell(2).SetCellValue(MXdata[k].KHMC);
row_mx.CreateCell(3).SetCellValue(MXdata[k].CRMID);
row_mx.CreateCell(4).SetCellValue(MXdata[k].KHLXDES);
row_mx.CreateCell(5).SetCellValue(MXdata[k].STAFFNAME);
row_mx.CreateCell(6).SetCellValue(MXdata[k].JHBFJSSJ);
row_mx.CreateCell(7).SetCellValue(MXdata[k].BFDZ);
row_mx.CreateCell(8).SetCellValue(MXdata[k].LXR);
row_mx.CreateCell(9).SetCellValue(MXdata[k].LXRTEL);
row_mx.CreateCell(10).SetCellValue(MXdata[k].LXRZWDES);
row_mx.CreateCell(11).SetCellValue(MXdata[k].BFMDDES);
row_mx.CreateCell(12).SetCellValue(MXdata[k].BFJGDES);
row_mx.CreateCell(13).SetCellValue(MXdata[k].QTXX);
row_mx.CreateCell(14).SetCellValue(MXdata[k].KQJL + "米");
row_mx.CreateCell(15).SetCellValue(MXdata[k].KQISACTIVE == 1 ? "是" : "否");
row3++;
}
}
}
worksheet1.ForceFormulaRecalculation = true;
worksheet2.ForceFormulaRecalculation = true;
worksheet3.ForceFormulaRecalculation = true;
string now = DateTime.Now.ToString("yyyyMMddHHmmss");
FileStream file1 = new FileStream(FileSavePath + @"\upload\" + now + ".xls", FileMode.Create);
workbook.Write(file1);
file1.Close();
DaoRuMsg msg = new DaoRuMsg();
msg.Msg = now + ".xls";
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
catch (Exception e)
{
DaoRuMsg msg = new DaoRuMsg();
msg.Msg = "err：" + e.ToString();
return(Newtonsoft.Json.JsonConvert.SerializeObject(msg));
}
}
