private void btn_extport_Click(object sender, EventArgs e)
{
ExportToExcelHelper.ExportToExcel(string.Format("{0}_{1}", UnitField.LogList, this.dtp_date.DateTime.ToString("yyyyMMdd")), new IPrintable[]
{
this.gridControl1
});
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingMaterialConsumption.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.iffsPackingMaterialDetail.Description.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingMaterialConsumptions = records.Select(record => new
{
record.iffsPackingMaterialDetail.Description,
record.Date,
record.Requested,
record.Consumed,
record.Returned,
record.Remarks,
MeasurmentUnit = record.iffsPackingMaterialDetail.lupMeasurementUnit.Name
}).ToList().Select(record => new
{
record.Description,
record.Date,
record.Requested,
record.Consumed,
record.Returned,
record.Remarks,
record.MeasurmentUnit
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingMaterialConsumptions);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, _SurveyRequest.ExportToExcel(searchText));
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _ReceivingClient.GetAll();
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.ContactPerson.ToUpper().Contains(searchText.ToUpper()) ||
p.Address.ToUpper().Contains(searchText.ToUpper()) ||
p.Telephone.ToUpper().Contains(searchText.ToUpper())) : records;
var ReceivingClients = records.Select(obj => new
{
obj.Id,
obj.Name,
obj.ContactPerson,
obj.Telephone,
obj.Mobile,
obj.Email,
obj.AlternativeEmail,
obj.Address
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, ReceivingClients);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _serviceAgreement.GetAll();
records = searchText != "" ? records.Where(p => p.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
(p.iffsQuotationHeader == null ? false : p.iffsQuotationHeader.QuotationNo.ToUpper().Contains(searchText.ToUpper())) ||
p.AgreementFile.ToUpper().Contains(searchText.ToUpper()) ||
p.Remark.ToUpper().Contains(searchText.ToUpper())) : records;
var serviceAgreements = records.Select(item => new
{
item.Id,
Date = String.Format("{0:MMMM dd, yyyy}", item.Date),
item.CustomerId,
Customer = item.iffsCustomer.Name,
item.QuotationId,
Quotation = item.iffsQuotationHeader == null ? "" : item.iffsQuotationHeader.QuotationNo,
item.AgreementFile,
item.Remark
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, serviceAgreements);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _customer.GetAll();
records = searchText != "" ? records.Where(p => p.iffsLupCustomerGroup.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Code.ToUpper().Contains(searchText.ToUpper()) ||
(p.TinNo == null ? false : p.TinNo.ToUpper().Contains(searchText.ToUpper())) ||
p.Email.ToUpper().Contains(searchText.ToUpper()) ||
p.Telephone.ToUpper().Contains(searchText.ToUpper()) ||
p.Address.ToUpper().Contains(searchText.ToUpper())) : records;
var customers = records.Select(record => new
{
record.Id,
record.CustomerGroupId,
CustomerGroup = record.iffsLupCustomerGroup.Name,
record.Name,
record.Code,
record.TinNo,
record.Address,
record.Email,
record.Telephone
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, customers);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _jobOrderHeader.GetAll().AsQueryable().Where(j => j.ParentJobOrderId == null);
records = searchText != "" ? records.Where(p => p.JobOrderNo.ToUpper().Contains(searchText.ToUpper()) ||
p.UltimateClient.ToUpper().Contains(searchText.ToUpper()) ||
p.ReceivingClient.ToUpper().Contains(searchText.ToUpper())) : records;
var jobOrders = records.Select(record => new
{
record.Id,
record.JobOrderNo,
ReceivingClient = record.ReceivingClient,
record.PreparedDate,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true
}).ToList().Select(record => new
{
record.Id,
record.JobOrderNo,
record.ReceivingClient,
Date = string.Format("{0:MMMM dd, yyyy}", record.PreparedDate),
record.IsChecked,
record.IsApproved
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, jobOrders);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _ShipmentType.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Code.ToUpper().Contains(searchText.ToUpper()) ||
p.Type.ToUpper().Contains(searchText.ToUpper())) : records;
var ShipmentTypes = records.Select(record => new
{
record.Id,
record.Name,
record.Code,
record.Type
}).ToList().Select(record => new
{
record.Id,
record.Name,
record.Code,
record.Type
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, ShipmentTypes);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _quotationHeader.GetAll();
records = searchText != "" ? records.Where(p => p.iffsServiceRequest.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.QuotationNo.ToUpper().Contains(searchText.ToUpper())) : records;
var customers = records.Select(record => new
{
record.Id,
record.QuotationNo,
Customer = record.iffsServiceRequest.iffsCustomer.Name,
record.Date,
PreparedBy = record.hrmsEmployee.corePerson.FirstName + " " + record.hrmsEmployee.corePerson.FatherName,
record.Remark,
// record.TermsAndConditions,
record.ValidityDate,
record.IsAccepted,
ApprovedBy = record.ApprovedById.HasValue? record.hrmsEmployee2.corePerson.FirstName + " " + record.hrmsEmployee2.corePerson.FatherName:"",
record.ApprovalDate,
CheckedBy = record.CheckedById.HasValue? record.hrmsEmployee1.corePerson.FirstName + " " + record.hrmsEmployee1.corePerson.FatherName:"",
record.CheckedDate,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true,
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, customers);
}
public FileContentResult ExportToExcel(int month)
{
var title = month > 12 ? "Budget Data" : "Budget Data for " + CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(month);
var exportToExcelViewModel = _unitOfWork.BudgetItemsRepository.GenerateExportToExcelViewModel(User.Identity.Name, month);
List <TransactionData> transactionDataList = exportToExcelViewModel.TransactionDataList;
byte[] fileContent = ExportToExcelHelper.ExportExcel(transactionDataList, title, true);
return(File(fileContent, ExportToExcelHelper.ExcelContentType, "BudgetData.xlsx"));
}
public async Task <Stream> ExportSearchSectionsToStreamAsync(string company, EntitySearchRequest searchRequest, string format = ListAndSearchExportFormat.Excel)
{
var searchResult = await SearchSectionsAsync(company, searchRequest, true);
var dataTable = await ConvertSearchResultToDataTableAsync(company, tradeGridCode, searchRequest.GridViewId, searchResult);
var formatedClauses = await GenerateFormatedClauses(company, searchRequest, tradeGridCode);
var stream = ExportToExcelHelper.Export(dataTable, new ExcelFileProperties {
Author = _identityService.GetUserPrincipalName(), Company = $"LDC - {company}", Title = "Atlas Trades Export",
}, formatedClauses);
return(stream);
}
private static async System.Threading.Tasks.Task ExportAndUploadToDriveAsync <T>(List <T> dataList, List <IList <Object> > writeValues, string extension, string contentType, string fileName, bool includeHeaders = true)
{
//Generate and Save Excel File locally
Logger.Info("Generating Excel File");
List <List <T> > splittedData = ExportToExcelHelper.Split(dataList, 1000000);
List <byte> data = new List <byte>();
foreach (var dt in splittedData)
{
var r = ExportToExcelHelper.ExportToExcel(dt, extension, includeHeaders).ToList();
data.AddRange(r);
}
Logger.Info("Saving Excel File in ReportFiles folder");
string filePath = GetFilePath(fileName);
using (var stream = new FileStream(filePath, FileMode.Append))
{
stream.Write(data.ToArray(), 0, data.ToArray().Length);
}
//System.IO.File.WriteAllBytes(filePath, data.ToArray());
//Google Drive Folder Name
string folderName = _iconfiguration.GetSection("GoogleDriveFolderName").Value;
IList <File> folders = GetFolders();
var folder = folders.FirstOrDefault(a => a.Name == folderName);
if (folder == null)
{
folder = service.CreateFolder(folderName);
}
if (folder != null)
{
Logger.Info($"Folder: {folder.Name} Found");
var fs = GetFilesByName(Path.GetFileNameWithoutExtension(fileName));
if (fs.Count == 1)
{
//UpdateFile(filePath, folder, fs.FirstOrDefault(), contentType);
await UpdateFileUsingGoogleSheetAsync <T>(fs.FirstOrDefault(), writeValues, Path.GetFileNameWithoutExtension(fileName));
}
else
{
CreateFile(filePath, folder, contentType);
}
}
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _operation.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.OperationNo.ToUpper().Contains(searchText.ToUpper())) : records;
var jobOrders = records.Select(record => new
{
record.Id,
record.OperationNo,
record.Date,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true,
PreparedByFirst = record.hrmsEmployee.corePerson.FirstName,
PreparedByFather = record.hrmsEmployee.corePerson.FatherName,
CheckedByFirst = record.CheckedById != null ? record.hrmsEmployee1.corePerson.FirstName : "",
CheckedByFather = record.CheckedById != null ? record.hrmsEmployee1.corePerson.FatherName : "",
ApprovedByFirst = record.ApprovedById != null ? record.hrmsEmployee2.corePerson.FirstName : "",
ApprovedByFather = record.ApprovedById != null ? record.hrmsEmployee2.corePerson.FatherName : "",
record.PreparedDate,
record.CheckedDate,
record.ApprovalDate
}).ToList().Select(record => new
{
record.Id,
record.OperationNo,
Date = string.Format("{0:MMMM dd, yyyy}", record.Date),
record.IsChecked,
record.IsApproved,
PreparedBy = record.PreparedByFirst + " " + record.PreparedByFather,
CheckedBy = record.CheckedByFirst + " " + record.CheckedByFather,
ApprovedBy = record.ApprovedByFirst + " " + record.ApprovedByFather,
PreparedDate = string.Format("{0:MMMM dd, yyyy}", record.PreparedDate),
CheckedDate = string.Format("{0:MMMM dd, yyyy}", record.CheckedDate),
ApprovalDate = string.Format("{0:MMMM dd, yyyy}", record.ApprovalDate)
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, jobOrders);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _invoiceHeader.GetAll().AsQueryable().OrderByDescending(o => o.Date).AsQueryable();
records = searchText != "" ? records.
Where(p =>
p.InvoiceNo.ToUpper().Contains(searchText.ToUpper()) ||
p.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.OperationNo.ToUpper().Contains(searchText.ToUpper()) ||
p.iffsLupOperationType.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.FsNo.ToUpper().Contains(searchText.ToUpper()) ||
(p.hrmsEmployee.corePerson.FirstName + " " + p.hrmsEmployee.corePerson.FatherName).ToUpper().Contains(searchText.ToUpper())
) : records;
var customers = records.Select(record => new
{
record.Id,
OperationType = record.iffsLupOperationType.Name,
record.InvoiceNo,
record.Date,
Customer = record.iffsCustomer.Name,
record.FsNo,
record.CustomerReferenceNo,
record.BL_AWB,
record.Carrier,
record.Remark,
record.Container,
record.ExchangeRate,
record.HBL,
record.OperationNo,
PreparedBy = record.CheckedById.HasValue ? record.hrmsEmployee.corePerson.FirstName + " " + record.hrmsEmployee.corePerson.FatherName : "",
record.PreparedDate,
IsChecked = record.CheckedById == null ? false : true,
IsApproved = record.ApprovedById == null ? false : true
}).ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, customers);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingMaterialHeader.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.Number.ToUpper().Contains(searchText.ToUpper()) ||
p.ToDept.ToUpper().Contains(searchText.ToUpper()) ||
p.RequestedDept.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingMaterials = records.Select(record => new
{
record.Number,
PreparedBy = GetFullName(record.PreparedById),
CheckedBy = record.CheckedById.HasValue ? GetFullName(record.CheckedById.Value) : "",
ApprovedBy = record.ApprovedById.HasValue ? GetFullName(record.ApprovedById.Value) : "",
record.ApprovalDate,
record.CheckedDate,
record.PreparedDate,
record.ToDept,
record.RequestedDept,
record.RequestedDate,
}).ToList().Select(record => new
{
record.Number,
record.ToDept,
record.RequestedDept,
record.RequestedDate,
record.PreparedBy,
record.CheckedBy,
record.ApprovedBy,
record.ApprovalDate,
record.CheckedDate,
record.PreparedDate,
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingMaterials);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var Type = int.Parse(Request.QueryString["Type"].ToString());
MaterialType materialType = Type == 1 ? MaterialType.Standard : MaterialType.CrateAndBox;
var records = _PackingMaterialSetting.FindAllQueryable(p => p.MaterialType == materialType);
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
p.Description.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingMaterialSettings = records.Select(record => new
{
record.Name,
record.Description,
record.MeasurmentUnit,
record.Length,
record.Width,
record.Height,
record.SizeCMB,
record.MaterialType,
record.Remark
}).ToList().Select(record => new
{
record.Name,
record.Description,
record.MeasurmentUnit,
record.Length,
record.Width,
record.Height,
record.SizeCMB,
record.MaterialType,
record.Remark
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingMaterialSettings);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _CrateAndBoxRequestHeader.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.OrderNumber.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployeeApprovedBy.corePerson.FatherName.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployeePreparedBy.corePerson.GrandFatherName.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingCrateAndBoxRequests = records.Select(record => new
{
record.Id,
record.OperationId,
record.OrderNumber,
record.PrevOrderNumber,
record.PreparedDate,
record.RequestedDate,
record.PreparedBy,
record.IsIronSheetCover,
record.Remark
}).ToList().Select(record => new
{
record.Id,
record.OperationId,
record.OrderNumber,
record.PrevOrderNumber,
record.PreparedDate,
record.RequestedDate,
record.PreparedBy,
record.IsIronSheetCover,
record.Remark
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingCrateAndBoxRequests);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"];
var records = _service.GetAll();
records = searchText != "" ? records.Where(p => p.Name.ToUpper().Contains(searchText.ToUpper()) ||
(p.Description == null ? false : p.Description.ToUpper().Contains(searchText.ToUpper())) ||
p.Code.ToUpper().Contains(searchText.ToUpper())) : records;
var services = records.Select(record => new
{
record.Id,
record.Name,
record.Description,
record.Code,
record.IsTaxable
}).Cast <object>().ToList();
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, services);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingDamageReport.GetAll().AsQueryable();
//records = searchText != "" ? records.Where(p => p.Number.ToUpper().Contains(searchText.ToUpper()) ||
// p.iffsCustomer.Name.ToUpper().Contains(searchText.ToUpper()) ||
// p.iffsReceivingClient.Name.ToUpper().Contains(searchText.ToUpper())) : records;
var PackingDamageReports = records.Select(record => new
{
record.Id,
record.Remarks,
}).ToList().Select(record => new
{
record.Id,
record.Remarks,
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, PackingDamageReports);
}
public void ExportToExcel()
{
var searchText = Request.QueryString["st"].ToString();
var records = _PackingHeader.GetAll().AsQueryable();
records = searchText != "" ? records.Where(p => p.ActivityType.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployee.corePerson.FatherName.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployee.corePerson.FatherName.ToUpper().Contains(searchText.ToUpper()) ||
p.hrmsEmployee.corePerson.GrandFatherName.ToUpper().Contains(searchText.ToUpper())) : records;
var Packings = records.Select(record => new
{
record.ActivityType,
Supervisor = GetFullName(record.SupervisorId),
PreparedBy = GetFullName(record.PreparedBy),
record.ActualVolume,
record.ActualWeight,
record.StartDate,
record.EndDate,
Date = record.PreparedDate
}).ToList().Select(record => new
{
record.ActivityType,
record.Supervisor,
record.PreparedBy,
record.ActualVolume,
record.ActualWeight,
record.StartDate,
record.EndDate,
record.Date
});
var exportToExcelHelper = new ExportToExcelHelper();
exportToExcelHelper.ToExcel(Response, Packings);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
string regionid = context.Request.QueryString["regionid"], reg = "";
string beginDate = context.Request.QueryString["beginDate"];
string endDate = context.Request.QueryString["endDate"];
string property = context.Request.QueryString["property"];
string func = context.Request.QueryString["func"];
if (regionid == "" || regionid.Contains("-1"))
{
GetRegionIdHelper grih = new GetRegionIdHelper();
regionid = grih.GetRegionID();
}
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Title");
dt.Columns.Add("PublishDate");
dt.Columns.Add("ViewsCounts");
dt.Columns.Add("Region");
dt.Columns.Add("Property");
dt.Columns.Add("Url");
try
{
string strWhere = "";
ArrayList strWhereList = new ArrayList();
strWhereList.Add(" RegionID in (" + regionid + ")");
strWhereList.Add(" Keyword like \'SM\'");
if (beginDate != "" && endDate != "")
{
strWhereList.Add(" PublishDate>=\'" + beginDate + "\' and PublishDate<=\'" + endDate + " 23:59:59.999\'");
}
if (property != "" && !property.Contains("全部"))
{
//strWhereList.Add(" Property=N\'" + (property == "空" ? "" : property) + "\'");
//" (Property=N\'" + (p == "空" ? "" : p) + "\' or Property=N\'" + p + "\'")
string[] props = property.Split(',');
string tmpSql = "";
foreach (string p in props)
{
tmpSql += " or Property=N\'" + (p == "空" ? "" : p) + "\'";
}
tmpSql = tmpSql.Substring(tmpSql.IndexOf("or") + 2, tmpSql.Length - 3);
strWhereList.Add(" (" + tmpSql + ") ");
}
switch (strWhereList.Count)
{
case 2:
strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString();
break;
case 3:
strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString() + " and " + strWhereList[2].ToString();
break;
case 4:
strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString() + " and " + strWhereList[2].ToString() + " and " + strWhereList[3].ToString();
break;
default:
break;
}
SM.YuQing.BLL.MonitorInfos monitorInfoBll = new SM.YuQing.BLL.MonitorInfos();
List <SM.YuQing.Model.MonitorInfos> monitorInfoList = monitorInfoBll.GetModelList(strWhere);
foreach (SM.YuQing.Model.MonitorInfos monitorInfo in monitorInfoList)
{
DataRow dr = dt.NewRow();
dr["ID"] = monitorInfo.ID;
dr["Title"] = monitorInfo.Title;
dr["PublishDate"] = monitorInfo.PublishDate.ToString("yyyy-MM-dd");
dr["ViewsCounts"] = monitorInfo.ViewsCounts;
if (monitorInfo.RegionID > 0)
{
SM.YuQing.BLL.Regions regionBll = new SM.YuQing.BLL.Regions();
SM.YuQing.Model.Regions region = regionBll.GetModel(Convert.ToInt32(monitorInfo.RegionID));
reg = region.Mall;
}
else
{
reg = "";
}
dr["Region"] = reg;
dr["Property"] = monitorInfo.Property;
dr["Url"] = monitorInfo.Url;
dt.Rows.Add(dr);
}
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dr["ID"] = "";
dr["Title"] = "未查询到数据";
dr["PublishDate"] = "";
dr["ViewsCounts"] = "";
dr["Region"] = "";
dr["Property"] = "";
dr["Url"] = "";
dt.Rows.Add(dr);
}
//context.Response.Write("<script>lert(\'ManageInfos.DoSearch\');</script>");
}
catch (Exception ex)
{
throw ex;
//DataRow dr = dt.NewRow();
//dr["ID"] = "";
//dr["Title"] = "Error in ProcessRequest():" + ex.Message;
//dr["PublishDate"] = "";
//dr["ViewsCounts"] = "";
//dr["Region"] = "";
//dr["Property"] = "";
//dr["Url"] = "";
//dt.Rows.Add(dr);
}
if (func == "1") //导出excel
{
ExportToExcelHelper eteh = new ExportToExcelHelper();
eteh.ExportToExcel(dt, "ManageInfoResult.xls", "[监测管理] -> [监测数据管理]");
}
else
{
context.Response.Write(JsonConvert.SerializeObject(dt));
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
string regionid = context.Request.QueryString["RegionId"];
string beginDate = context.Request.QueryString["beginDate"];
string endDate = context.Request.QueryString["endDate"];
string func = context.Request.QueryString["func"];
if (regionid == "" || regionid.Contains("-1"))
{
GetRegionIdHelper grih = new GetRegionIdHelper();
regionid = grih.GetRegionID();
}
DataTable dt = new DataTable();
dt.Columns.Add("Region");
dt.Columns.Add("Positive");
dt.Columns.Add("Negative");
dt.Columns.Add("Neutral");
dt.Columns.Add("Empty");
dt.Columns.Add("Total");
try
{
string strWhere = "";
ArrayList strWhereList = new ArrayList();
//strWhereList.Add(" RegionID in (" + regionid + ")");
//strWhereList.Add(" Keyword like \'SM\'");
if (beginDate != "" && endDate != "")
{
if (regionid != "")
{
string[] regs = regionid.Split(',');
foreach (string regid in regs)
{
strWhere = " PublishDate>=\'" + beginDate + "\' and PublishDate<=\'" + endDate + " 23:59:59.999\'" + " and RegionID=" + regid;
SM.YuQing.BLL.Regions regionBll = new SM.YuQing.BLL.Regions();
SM.YuQing.Model.Regions region = regionBll.GetModel(Convert.ToInt32(regid));
dt = GetDataRow(dt, null, region.Mall, strWhere);
}
}
else
{
SM.YuQing.BLL.Regions regionBll = new SM.YuQing.BLL.Regions();
List <SM.YuQing.Model.Regions> regionList = regionBll.GetModelList("");
foreach (SM.YuQing.Model.Regions region in regionList)
{
strWhere = " PublishDate>=\'" + beginDate + "\' and PublishDate<=\'" + endDate + " 23:59:59.999\'" + " and RegionID=" + region.ID;
dt = GetDataRow(dt, region, "", strWhere);
}
}
}
else
{
if (regionid != "")
{
string[] regs = regionid.Split(',');
foreach (string regid in regs)
{
SM.YuQing.BLL.Regions regionBll = new SM.YuQing.BLL.Regions();
SM.YuQing.Model.Regions region = regionBll.GetModel(Convert.ToInt32(regid));
dt = GetDataRow(dt, null, region.Mall, " RegionID=" + regid);
}
}
else
{
SM.YuQing.BLL.Regions regionBll = new SM.YuQing.BLL.Regions();
List <SM.YuQing.Model.Regions> regionList = regionBll.GetModelList("");
foreach (SM.YuQing.Model.Regions region in regionList)
{
dt = GetDataRow(dt, region, "", " RegionID=" + region.ID.ToString());
}
}
}
}
catch (Exception ex)
{
throw ex;
//DataRow dr = dt.NewRow();
//dr["Region"] = "Error in ProcessRequest():" + ex.Message; ;
//dr["Positive"] = "";
//dr["Negative"] = "";
//dr["Neutral"] = "";
//dr["Empty"] = "";
//dr["Total"] = "";
//dt.Rows.Add(dr);
}
if (func == "1") //导出excel
{
ExportToExcelHelper eteh = new ExportToExcelHelper();
eteh.ExportToExcel(dt, "StatisticsResult.xls", "[监测管理] -> [监测性质统计表]");
}
else
{
context.Response.Write(JsonConvert.SerializeObject(dt));
}
}
public DataTable RealTimeMonitor(HttpContext context, int level)
{
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
string regionid = context.Request.QueryString["regionid"];
string keyword = context.Request.QueryString["keyword"];
string website = context.Request.QueryString["website"];
string searchLevel = context.Request.QueryString["sl"];
string func = context.Request.QueryString["func"];
if (regionid == "" || regionid.Contains("-1"))
{
GetRegionIdHelper grih = new GetRegionIdHelper();
regionid = grih.GetRegionID();
}
//keyword = System.Web.HttpUtility.UrlDecode(keyword);
DataTable dt = new DataTable();
dt.Columns.Add("Title");
dt.Columns.Add("PublishDate");
dt.Columns.Add("ViewsCounts");
dt.Columns.Add("Region");
dt.Columns.Add("RegionID");
dt.Columns.Add("MonitorUrl");
dt.Columns.Add("Keyword");
dt.Columns.Add("Url");
SM.YuQing.BLL.RealTimeMonitorHelper rtmh = new SM.YuQing.BLL.RealTimeMonitorHelper();
try
{
if (website != "")
{
//dt = RemoveCommonRecord(rtmh.GetDataRows(dt, website, keyword, null, null));
//searchLevel 搜索级别
if (searchLevel == "1")
{
dt = rtmh.GetDataRows(dt, website, keyword, null, null);
}
else if (searchLevel == "2")
{
dt = rtmh.GetData(dt, website, keyword, null, null);
}
}
else
{
string[] regs = regionid.Split(',');
foreach (string reg in regs)
{
SM.YuQing.BLL.Regions regionBll = new SM.YuQing.BLL.Regions();
SM.YuQing.Model.Regions region = regionBll.GetModel(Convert.ToInt32(reg.Trim()));
SM.YuQing.BLL.MonitorWebs webBll = new SM.YuQing.BLL.MonitorWebs();
List <SM.YuQing.Model.MonitorWebs> webList = webBll.GetModelList("RegionID=" + reg.Trim());
foreach (SM.YuQing.Model.MonitorWebs web in webList)
{
if (web.Status == "启用")
{
if (searchLevel == "1")
{
dt = rtmh.GetDataRows(dt, web.Url, keyword, region, web);
}
else if (searchLevel == "2")
{
dt = rtmh.GetData(dt, web.Url, keyword, region, web);
}
}
}
}
}
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dr["Title"] = "未匹配到关键字“" + keyword + "”";
dr["PublishDate"] = "";
dr["ViewsCounts"] = "";
dr["Region"] = "";
dr["RegionID"] = "";
dr["MonitorUrl"] = "";
dr["Keyword"] = "";
dr["Url"] = "";
dt.Rows.Add(dr);
}
else
{
//DataTable去重
int rowsCount = dt.Rows.Count;
for (int i = 0; i < rowsCount - 1; i++)
{
for (int j = i + 1; j < rowsCount;)
{
if (dt.Rows[i]["Url"].ToString() == dt.Rows[j]["Url"].ToString())
{
dt.Rows.RemoveAt(j);
rowsCount--;
dt.AcceptChanges();
}
else
{
j++;
}
}
}
if (func != "1")
{
//写入数据库
rtmh.RecordToDatabase(dt, context.User.Identity.Name);
//写入日志Log
SM.YuQing.Model.Log log = new SM.YuQing.Model.Log();
log.LogType = "实时监测";
log.Message = "本次共新增 " + dt.Rows.Count.ToString() + " 条数据";
log.IP = context.Request.UserHostAddress;
log.MenuID = 0;
log.PersonID = 0;
log.CreateTime = DateTime.Now;
SM.YuQing.BLL.Log logBll = new SM.YuQing.BLL.Log();
logBll.Add(log);
}
}
}
catch (Exception ex)
{
throw ex;
//DataRow dr = dt.NewRow();
//dr["Title"] = "Error in ProcessRequest():" + ex.Message;
//dr["PublishDate"] = "";
//dr["ViewsCounts"] = "";
//dr["Region"] = "";
//dr["RegionID"] = "";
//dr["MonitorUrl"] = "";
//dr["Keyword"] = "";
//dr["Url"] = "";
//dt.Rows.Add(dr);
}
if (func == "1") //导出excel
{
ExportToExcelHelper eteh = new ExportToExcelHelper();
eteh.ExportToExcel(dt, "RealTimeResult.xls", "[监测管理] -> [实时监测]");
}
else
{
context.Response.Write(JsonConvert.SerializeObject(dt));
}
return(dt);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
string regionid = context.Request.QueryString["regionid"], reg = "";
string beginDate = context.Request.QueryString["beginDate"];
string endDate = context.Request.QueryString["endDate"];
string keyword = context.Request.QueryString["keyword"];
string func = context.Request.QueryString["func"];
if (regionid == "" || regionid.Contains("-1"))
{
GetRegionIdHelper grih = new GetRegionIdHelper();
regionid = grih.GetRegionID();
}
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Title");
dt.Columns.Add("PublishDate");
dt.Columns.Add("ViewsCounts");
dt.Columns.Add("Keyword");
dt.Columns.Add("Region");
dt.Columns.Add("Url");
try
{
string strWhere = "";
ArrayList strWhereList = new ArrayList();
if (beginDate != "" && endDate != "")
{
strWhereList.Add(" PublishDate>=\'" + beginDate + "\' and PublishDate<=\'" + endDate + " 23:59:59.999\'");
}
if (regionid != "")
{
strWhereList.Add(" RegionID in (" + regionid + ")");
}
if (keyword != "")
{
strWhereList.Add(" Keyword like N\'%" + keyword + "%\'");
}
switch (strWhereList.Count)
{
case 1:
strWhere = strWhereList[0].ToString();
break;
case 2:
strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString();
break;
case 3:
strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString() + " and " + strWhereList[2].ToString();
break;
default:
break;
}
SM.YuQing.BLL.MonitorInfos monitorInfoBll = new SM.YuQing.BLL.MonitorInfos();
List <SM.YuQing.Model.MonitorInfos> monitorInfoList = monitorInfoBll.GetModelList(strWhere);
foreach (SM.YuQing.Model.MonitorInfos monitorInfo in monitorInfoList)
{
DataRow dr = dt.NewRow();
dr["ID"] = monitorInfo.ID;
dr["Title"] = monitorInfo.Title;
dr["PublishDate"] = monitorInfo.PublishDate.ToString("yyyy-MM-dd");
dr["ViewsCounts"] = monitorInfo.ViewsCounts;
dr["Keyword"] = monitorInfo.Keyword;
if (monitorInfo.RegionID > 0)
{
SM.YuQing.BLL.Regions regionBll = new SM.YuQing.BLL.Regions();
SM.YuQing.Model.Regions region = regionBll.GetModel(Convert.ToInt32(monitorInfo.RegionID));
reg = region.Mall;
}
else
{
reg = "";
}
dr["Region"] = reg;
dr["Url"] = monitorInfo.Url;
dt.Rows.Add(dr);
}
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dr["ID"] = "";
dr["Title"] = "未查询到数据";
dr["PublishDate"] = "";
dr["ViewsCounts"] = "";
dr["Keyword"] = "";
dr["Region"] = "";
dr["Url"] = "";
dt.Rows.Add(dr);
}
}
catch (Exception ex)
{
throw ex;
//DataRow dr = dt.NewRow();
//dr["Title"] = "Error in ProcessRequest():" + ex.Message;
//dr["PublishDate"] = "";
//dr["ViewsCounts"] = "";
//dr["Keyword"] = "";
//dr["Region"] = "";
//dr["Url"] = "";
//dt.Rows.Add(dr);
}
if (func == "1") //导出excel
{
ExportToExcelHelper eteh = new ExportToExcelHelper();
eteh.ExportToExcel(dt, "IndustryResult.xls", "[监测管理] -> [行业监测]");
}
else
{
context.Response.Write(JsonConvert.SerializeObject(dt));
}
}
