public async Task <bool> UpdateItemAsync(Item item)
{
SQLiteAsyncConnection connection = await GetDatabaseConnection();
try
{
StatisticsEntity statisticsEntity = await connection.Table <StatisticsEntity>()
.FirstOrDefaultAsync(i => i.Id == item.Id);
if (statisticsEntity == null)
{
return(false);
}
statisticsEntity.Date = item.Date;
statisticsEntity.Value = item.Value ?? 0;
await connection.UpdateAsync(statisticsEntity);
}
finally
{
await connection.CloseAsync();
}
return(true);
}
public async Task <Item> GetItemAsync(int id)
{
SQLiteAsyncConnection connection = await GetDatabaseConnection();
try
{
StatisticsEntity statisticsEntity = await connection.Table <StatisticsEntity>()
.FirstOrDefaultAsync(i => i.Id == id);
if (statisticsEntity == null)
{
return(null);
}
Item item = new Item()
{
Id = statisticsEntity.Id,
Date = statisticsEntity.Date,
Value = statisticsEntity.Value
};
return(item);
}
finally
{
await connection.CloseAsync();
}
}
public StatisticsEntity GetStatistics(TimeSpan?timeSpan)
{
StatisticsEntity statistics = new StatisticsEntity();
IEnumerable <CategoryEntity> categories = categoryRepository.GetAll().Select(c => c.ToBllCategory());
if (timeSpan == null)
{
foreach (var item in categories)
{
statistics.Categories.Add(item.Name);
statistics.TotalNumberOfLots.Add(item.Lots.Count());
statistics.NumberOfSoldLots.Add(item.Lots.Count(l => l.State == LotStateEntity.Sold));
statistics.NumberOfForSaleLots.Add(item.Lots.Count(l => l.State == LotStateEntity.ForSale));
statistics.NumberOfUnsoldLots.Add(item.Lots.Count(l => l.State == LotStateEntity.Unsold));
}
}
else
{
foreach (var item in categories)
{
statistics.Categories.Add(item.Name);
statistics.TotalNumberOfLots.Add(item.Lots.Count(l => l.StartDate > DateTime.Now - timeSpan));
statistics.NumberOfSoldLots.Add(item.Lots.Count(l => l.StartDate > DateTime.Now - timeSpan && l.State == LotStateEntity.Sold));
statistics.NumberOfForSaleLots.Add(item.Lots.Count(l => l.StartDate > DateTime.Now - timeSpan && l.State == LotStateEntity.ForSale));
statistics.NumberOfUnsoldLots.Add(item.Lots.Count(l => l.StartDate > DateTime.Now - timeSpan && l.State == LotStateEntity.Unsold));
}
}
return(statistics);
}
private async Task <TableResult> StoreOrUpdateStatisticEntityAsync(StatisticsEntity statistic)
{
await this.EnsureInitializedAsync().ConfigureAwait(false);
TableOperation addOrUpdateOperation = TableOperation.InsertOrReplace(statistic);
return(await this.statisticsCloudTable.ExecuteAsync(addOrUpdateOperation).ConfigureAwait(false));
}
public ActionResult GetHtNumChangeChart(string queryJson)
{
var curUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); //当前用户
var queryParam = queryJson.ToJObject();
string deptCode = curUser.DeptCode; //部门
string year = DateTime.Now.Year.ToString(); //年度
if (!queryParam["year"].IsEmpty())
{
year = queryParam["year"].ToString();
}
string hidPoint = ""; //区域
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = deptCode;
hentity.sYear = year;
hentity.sArea = hidPoint;
hentity.sAction = "7";
var dt = htbaseinfobll.QueryStatisticsByAction(hentity);
IList <fseries> slist = new List <fseries>();
fseries s1 = new fseries();
s1.name = "所有隐患";
fseries s2 = new fseries();
s2.name = "一般隐患";
fseries s3 = new fseries();
s3.name = "重大隐患";
List <decimal> list1 = new List <decimal>();
List <decimal> list2 = new List <decimal>();
List <decimal> list3 = new List <decimal>();
foreach (DataRow row in dt.Rows)
{
decimal total = Convert.ToDecimal(row["aChangeVal"].ToString()); //总的整改率
decimal ordinary = Convert.ToDecimal(row["oChangeVal"].ToString()); //一般隐患整改率
decimal great = Convert.ToDecimal(row["iChangeVal"].ToString()); //重大隐患整改率
list1.Add(total);
list2.Add(ordinary);
list3.Add(great);
}
s1.data = list1;
s2.data = list2;
s3.data = list3;
slist.Add(s1);
slist.Add(s2);
slist.Add(s3);
return(Content(slist.ToJson()));
}
public static StatisticsViewModel ToMvcStatistics(this StatisticsEntity statistics)
{
return(new StatisticsViewModel()
{
Categories = statistics.Categories,
TotalNumberOfLots = statistics.TotalNumberOfLots,
NumberOfSoldLots = statistics.NumberOfSoldLots,
NumberOfForSaleLots = statistics.NumberOfForSaleLots,
NumberOfUnsoldLots = statistics.NumberOfUnsoldLots
});
}
/// <summary>
/// Saves or updates the NBA statistics into Azure Table storage.
/// </summary>
/// <param name="statistic">The statistic to save or update.</param>
/// <returns>A <see cref="Task"/> that would resolve successfully if the data has been properly saved.</returns>
public Task UpsertNbaStatisticAsync(StatisticsEntity statistic)
{
if (statistic is null)
{
throw new ArgumentNullException(nameof(statistic));
}
statistic.PartitionKey = PartitionKey;
statistic.RowKey = statistic.StatisticsId.ToString(CultureInfo.InvariantCulture);
return(this.StoreOrUpdateStatisticEntityAsync(statistic));
}
public int BalancedString(string s)
{
//平衡线
var aimNum = s.Length / 4;
//得到从右边开始的极限位置
var rigthCountEntity = new StatisticsEntity();
for (int i = s.Length - 1; i >= 0; i--)
{
var curChar = s[i];
if (!rigthCountEntity.CurComposed.ContainsKey(curChar))
{
rigthCountEntity.CurComposed[curChar] = 0;
}
if (rigthCountEntity.CurComposed[curChar] == aimNum)
{
rigthCountEntity.CurIndex = i + 1;
break;
}
rigthCountEntity.CurComposed[curChar]++;
}
//从左边开始,探索新的极限
var forReturn = rigthCountEntity.CurIndex;
var leftCountEntity = new StatisticsEntity();
for (int j = 0; j < s.Length; j++)
{
var curChar = s[j];
leftCountEntity.CurIndex = j;
if (!leftCountEntity.CurComposed.ContainsKey(curChar))
{
leftCountEntity.CurComposed[curChar] = 0;
}
if (leftCountEntity.CurComposed[curChar] == aimNum)
{
break;
}
leftCountEntity.CurComposed[curChar]++;
VerifyAndChange(s, leftCountEntity, rigthCountEntity);
forReturn = Math.Min(forReturn, rigthCountEntity.CurIndex - leftCountEntity.CurIndex - 1);
}
return(forReturn);
}
private string GetInsertionStatisticsLine(StatisticsEntity statistics)
{
return($"(" + $"{statistics.UserId}, " + $"{statistics.PublicAnsweredQuestions}, " +
$"{statistics.AskedQuestions}, " + $"{statistics.PublicAnsweredQuestions}, " +
$"{statistics.AnsweredQuestions}, " + $"{statistics.SeenQuestions}, " +
$"{statistics.PublicFavoriteQuestions}, " + $"{statistics.FavoriteQuestions}, " +
$"{statistics.CommentsWritten}, " + $"{statistics.UserQuestionsShows}, " +
$"{statistics.UserQuestionsAnswers}, " + $"{statistics.Followers}, " +
$"{statistics.FollowTo}, " + $"{statistics.QuestionsCommentsGot}, " +
$"{statistics.QuestionsLikesGot}, " + $"{statistics.CommentsDislikesGot}, " +
$"{statistics.CommentsLikesGot}, " + $"{statistics.CommentsDislikesGot}, " +
$"{statistics.QuestionsLikesMade}, " + $"{statistics.QuestionsDislikesMade}, " +
$"{statistics.CommentsLikesMade}, " + $"{statistics.CommentsDislikesMade}" + $")");
}
/// <summary>
/// 隐患整改情况饼图
/// </summary>
/// <param name="queryJson"></param>
/// <returns></returns>
public ActionResult GetHtNumReadjustChart(string queryJson)
{
var curUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); //当前用户
var queryParam = queryJson.ToJObject();
string deptCode = curUser.DeptCode; //部门
string year = queryParam["year"].ToString(); //年度
string hidRank = ""; //隐患级别
if (!queryParam["level"].IsEmpty())
{
hidRank = queryParam["level"].ToString().Replace("请选择", "");
}
string hidPoint = ""; //区域
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = deptCode; //整改部门
hentity.sArea = hidPoint; //区域
hentity.sYear = year; //年度
hentity.sHidRank = hidRank; //隐患级别
hentity.sAction = "6"; //对比图分析
//列表
var dt = htbaseinfobll.QueryStatisticsByAction(hentity);
IList <series> slist = new List <series>();
List <int> oVal = new List <int>();
List <int> iVal = new List <int>();
series s1 = new series();
s1.name = "已整改";
series s2 = new series();
s2.name = "未整改";
//图表分析
foreach (DataRow row in dt.Rows)
{
//y 轴Value
oVal.Add(Convert.ToInt32(row["yValue"].ToString()));
iVal.Add(Convert.ToInt32(row["wValue"].ToString()));
}
s1.data = oVal; //已整改
s2.data = iVal; //未整改
slist.Add(s1);
slist.Add(s2);
var jsonData = new { tdata = dt, sdata = slist };
return(Content(jsonData.ToJson()));
}
public static StatisticsEntity Map(this Definition.Models.TextStatistics tsm)
{
var se = new StatisticsEntity();
if (tsm != null)
{
se.Id = tsm.Id;
se.Guid = tsm.Guid;
se.HyphenCount = tsm.HyphenCount;
se.SpacesCount = tsm.SpacesCount;
se.WordCount = tsm.WordCount;
}
return(se);
}
// intentionally not using automapper.
public static Definition.Models.TextStatistics Map(this StatisticsEntity sE)
{
var tsm = new Definition.Models.TextStatistics();
if (sE != null)
{
tsm.Id = sE.Id;
tsm.Guid = sE.Guid;
tsm.HyphenCount = sE.HyphenCount;
tsm.SpacesCount = sE.SpacesCount;
tsm.WordCount = sE.WordCount;
}
return(tsm);
}
public void AddStatistic(StatisticsObject statistic)
{
StatisticsEntity entity = new StatisticsEntity();
entity.PartitionKey = string.Empty;
entity.RowKey = Guid.NewGuid().ToString();
entity.CL_UnitFrom = statistic.CL_UnitFrom;
entity.CL_ValueFrom = statistic.CL_ValueFrom.ToString();
entity.CL_UnitTo = statistic.CL_UnitTo;
entity.CL_ValueTo = statistic.CL_ValueTo.ToString();
entity.CL_UnitType = statistic.CL_UnitType;
entity.CL_Date = statistic.CL_Date;
Console.WriteLine(entity.ToString());
TableOperation insertOperation = TableOperation.Insert(entity);
table.Execute(insertOperation);
}
public string GetHtLevelChart(string queryJson)
{
var curUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); //当前用户
var queryParam = queryJson.ToJObject();
string deptCode = curUser.DeptCode; //部门
string year = DateTime.Now.ToString(); //年度
if (!queryParam["year"].IsEmpty())
{
year = queryParam["year"].ToString();
}
//判断是否是厂级用户或者是公司用户
string hidPlantLevel = dataitemdetailbll.GetItemValue("HidPlantLevel");
string hidOrganize = dataitemdetailbll.GetItemValue("HidOrganize");
string CompanyRole = hidPlantLevel + "," + hidOrganize;
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = deptCode;
hentity.sYear = year;
hentity.sAction = "2";
hentity.sOrganize = curUser.OrganizeId;
var userList = userbll.GetUserListByDeptCode(curUser.DeptCode, CompanyRole, false, curUser.OrganizeId).Where(p => p.UserId == curUser.UserId).ToList();
//当前用户是厂级
if (userList.Count() > 0)
{
hentity.isCompany = true;
}
else
{
hentity.isCompany = false;
}
//隐患等级统计图
var hidrank = htbaseinfobll.QueryStatisticsByAction(hentity);
return(hidrank.ToJson());
}
public async Task <bool> AddItemAsync(Item item)
{
SQLiteAsyncConnection connection = await GetDatabaseConnection();
try
{
StatisticsEntity statisticsEntity = new StatisticsEntity()
{
Date = item.Date,
Value = item.Value ?? 0
};
await connection.InsertAsync(statisticsEntity);
}
finally
{
await connection.CloseAsync();
}
return(true);
}
/// <summary>
/// 当左面的收集导致超限时,去右面去缩减
/// </summary>
private void VerifyAndChange(string s, StatisticsEntity leftEntity, StatisticsEntity rightEntity)
{
var aimNum = s.Length / 4;
foreach (var leftValue in leftEntity.CurComposed)
{
if (!rightEntity.CurComposed.ContainsKey(leftValue.Key))
{
continue;
}
var sumNum = leftValue.Value + rightEntity.CurComposed[leftValue.Key];
while (sumNum > aimNum)
{
var curChar = s[rightEntity.CurIndex];
rightEntity.CurIndex++;
rightEntity.CurComposed[curChar]--;
sumNum = leftValue.Value + rightEntity.CurComposed[leftValue.Key];
}
}
}
public async Task <bool> DeleteItemAsync(int id)
{
SQLiteAsyncConnection connection = await GetDatabaseConnection();
try
{
StatisticsEntity statisticsEntity = await connection.Table <StatisticsEntity>()
.FirstOrDefaultAsync(i => i.Id == id);
if (statisticsEntity == null)
{
return(false);
}
await connection.DeleteAsync(statisticsEntity);
}
finally
{
await connection.CloseAsync();
}
return(true);
}
/// <summary>
/// 监管任务数量表格
/// </summary>
/// <param name="queryJson"></param>
/// <returns></returns>
public ActionResult QuerySupervisonNumberComparisonList(string queryJson)
{
try
{
var queryParam = queryJson.ToJObject();
string deptCode = queryParam["deptCode"].ToString(); //部门
string startDate = queryJson.Contains("startDate") ? queryParam["startDate"].ToString() : ""; //起始日期
string endDate = queryJson.Contains("endDate") ? queryParam["endDate"].ToString() : ""; //截止日期
var curUser = new OperatorProvider().Current(); //当前用户
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = string.IsNullOrEmpty(deptCode) ? curUser.DeptCode : deptCode;
hentity.startDate = startDate;
hentity.endDate = endDate;
hentity.sAction = "2"; //对比图分析
hentity.sMark = 0;
//当前用户是厂级
if (curUser.RoleName.Contains("厂级") || curUser.RoleName.Contains("公司级"))
{
hentity.isCompany = true;
}
else
{
hentity.isCompany = false;
}
var treeList = new List <TreeGridEntity>();
//列表
var dt = tasksharebll.QueryStatisticsByAction(hentity);
//结果集合
return(ToJsonResult(dt));
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 旁站监管数量对比图
/// </summary>
/// <param name="queryJson"></param>
/// <returns></returns>
public ActionResult QuerySupervisonNumberComparison(string queryJson)
{
try
{
var queryParam = queryJson.ToJObject();
string deptCode = queryParam["deptCode"].ToString(); //部门
string startDate = queryJson.Contains("startDate") ? queryParam["startDate"].ToString() : ""; //起始日期
string endDate = queryJson.Contains("endDate") ? queryParam["endDate"].ToString() : ""; //截止日期
var curUser = new OperatorProvider().Current(); //当前用户
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = string.IsNullOrEmpty(deptCode) ? curUser.DeptCode : deptCode;
hentity.startDate = startDate;
hentity.endDate = endDate;
hentity.sAction = "2"; //对比图分析
hentity.sMark = 0;
//当前用户是厂级
if (curUser.RoleName.Contains("厂级") || curUser.RoleName.Contains("公司级"))
{
hentity.isCompany = true;
}
else
{
hentity.isCompany = false;
}
//列表
var dt = tasksharebll.QueryStatisticsByAction(hentity);
//x 轴Title
List <dseries> xdata = new List <dseries>();
//x 轴Title
List <dseries> sdata = new List <dseries>();
//未监督
List <dseries_child> yblist = new List <dseries_child>();
//已监督
List <dseries_child> zdlist = new List <dseries_child>();
dseries s1 = new dseries();
s1.name = "需监管";
s1.id = "ybyh";
dseries s2 = new dseries();
s2.name = "已监管";
s2.id = "zdyh";
//图表分析
foreach (DataRow row in dt.Rows)
{
string dname = row["fullname"].ToString();
string drillId = row["createuserdeptcode"].ToString();
//需监管
dseries_child ybyh = new dseries_child();
ybyh.name = dname;
ybyh.y = Convert.ToInt32(row["ordinaryhid"].ToString());
ybyh.drilldown = "yb" + drillId;//部门编码
yblist.Add(ybyh);
//已监管
dseries_child zdyh = new dseries_child();
zdyh.name = row["fullname"].ToString();
zdyh.y = Convert.ToInt32(row["ImportanHid"].ToString());
zdyh.drilldown = "zd" + drillId;//部门编码
zdlist.Add(zdyh);
}
s1.data = yblist; //需监管
xdata.Add(s1);
s2.data = zdlist; //已监管
xdata.Add(s2);
//结果集合
var jsonData = new { tdata = dt, xdata = xdata, sdata = sdata, iscompany = hentity.isCompany ? 1 : 0 };
return(Content(jsonData.ToJson()));
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 监督任务数量表格
/// </summary>
/// <param name="queryJson"></param>
/// <returns></returns>
public ActionResult QueryHidNUmberComparisonList(string queryJson)
{
try
{
var queryParam = queryJson.ToJObject();
string deptCode = queryParam["deptCode"].ToString(); //部门
string startDate = queryJson.Contains("startDate") ? queryParam["startDate"].ToString() : ""; //起始日期
string endDate = queryJson.Contains("endDate") ? queryParam["endDate"].ToString() : ""; //截止日期
var curUser = new OperatorProvider().Current(); //当前用户
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = string.IsNullOrEmpty(deptCode) ? curUser.DeptCode : deptCode;
hentity.startDate = startDate;
hentity.endDate = endDate;
hentity.sAction = "1"; //对比图分析
hentity.sMark = 2;
//当前用户是厂级
if (curUser.RoleName.Contains("厂级") || curUser.RoleName.Contains("公司级"))
{
hentity.isCompany = true;
}
else
{
hentity.isCompany = false;
}
var treeList = new List <TreeGridEntity>();
//列表
var dt = tasksharebll.QueryStatisticsByAction(hentity);
foreach (DataRow row in dt.Rows)
{
TreeListForHidden tentity = new TreeListForHidden();
tentity.createuserdeptcode = row["createuserdeptcode"].ToString();
tentity.fullname = row["fullname"].ToString();
tentity.sortcode = row["sortcode"].ToString();
tentity.departmentid = row["departmentid"].ToString();
if (row["parentid"].ToString() != "0")
{
tentity.parent = row["parentid"].ToString();
}
tentity.importanhid = Convert.ToDecimal(row["importanhid"].ToString());
tentity.ordinaryhid = Convert.ToDecimal(row["ordinaryhid"].ToString());
tentity.total = Convert.ToDecimal(row["total"].ToString());
TreeGridEntity tree = new TreeGridEntity();
bool hasChildren = dt.Select(string.Format(" parentid ='{0}'", tentity.departmentid)).Count() == 0 ? false : true;
tentity.haschild = hasChildren;
tree.id = row["departmentid"].ToString();
tree.parentId = row["parentid"].ToString();
string itemJson = tentity.ToJson();
tree.entityJson = itemJson;
tree.expanded = false;
tree.hasChildren = hasChildren;
treeList.Add(tree);
}
//结果集合
return(Content(treeList.TreeJson("0")));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult GetHtNumChart(string queryJson)
{
var curUser = ERCHTMS.Code.OperatorProvider.Provider.Current(); //当前用户
var queryParam = queryJson.ToJObject();
string deptCode = curUser.DeptCode; //部门
string year = DateTime.Now.Year.ToString();
if (!queryParam["year"].IsEmpty())
{
year = queryParam["year"].ToString();
}
string hidPoint = ""; //区域
string hidRank = string.Empty;
if (!queryParam["level"].IsEmpty())
{
hidRank = queryParam["level"].ToString().Replace("请选择", ""); //隐患级别
}
string ischeck = "";
string checkType = "";
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = deptCode;
hentity.sYear = year;
hentity.sArea = hidPoint;
hentity.sHidRank = hidRank;
hentity.sAction = "4";
hentity.isCheck = ischeck;
hentity.sCheckType = checkType;
var dt = htbaseinfobll.QueryStatisticsByAction(hentity);
IList <series> slist = new List <series>();
if (!string.IsNullOrEmpty(hidRank))
{
string[] arr = hidRank.Split(',');
//单个或多个隐患级别
foreach (string aStr in arr)
{
series s = new series();
s.name = aStr;
List <int> dlist = new List <int>();
foreach (DataRow row in dt.Rows)
{
int tempValue = 0;
if (aStr == "一般隐患")
{
tempValue = Convert.ToInt32(row["OrdinaryHid"].ToString());
}
else //重大隐患
{
tempValue = Convert.ToInt32(row["ImportanHid"].ToString());
}
dlist.Add(tempValue);
}
s.data = dlist;
slist.Add(s);
}
}
else //无隐患级别条件
{
series s = new series();
s.name = "所有隐患";
List <int> dlist = new List <int>();
foreach (DataRow row in dt.Rows)
{
int tempValue = Convert.ToInt32(row["allhid"].ToString());
dlist.Add(tempValue);
}
s.data = dlist;
slist.Add(s);
}
return(Content(slist.ToJson()));
}
/// <summary>
/// 旁站监督统计
/// </summary>
/// <param name="sentity"></param>
/// <returns></returns>
public DataTable QueryStatisticsByAction(StatisticsEntity sentity)
{
return(service.QueryStatisticsByAction(sentity));
}
public ActionResult ExportStatisticExcel(string queryJson)
{
try
{
var queryParam = queryJson.ToJObject();
string deptCode = queryParam["deptCode"].ToString(); //部门
string startDate = queryJson.Contains("startDate") ? queryParam["startDate"].ToString() : ""; //起始日期
string endDate = queryJson.Contains("endDate") ? queryParam["endDate"].ToString() : ""; //截止日期
string stype = queryJson.Contains("stype") ? queryParam["stype"].ToString() : ""; //导出类型
var curUser = new OperatorProvider().Current(); //当前用户
StatisticsEntity hentity = new StatisticsEntity();
hentity.sDeptCode = string.IsNullOrEmpty(deptCode) ? curUser.DeptCode : deptCode;
hentity.startDate = startDate;
hentity.endDate = endDate;
if (stype == "监管图")
{
hentity.sAction = "2"; //对比图分析
hentity.sMark = 0;
}
else if (stype == "监督图")
{
hentity.sAction = "1"; //对比图分析
hentity.sMark = 2;
}
//当前用户是厂级
if (curUser.RoleName.Contains("厂级") || curUser.RoleName.Contains("公司级"))
{
hentity.isCompany = true;
}
else
{
hentity.isCompany = false;
}
var treeList = new List <TreeGridEntity>();
//列表
var dt = tasksharebll.QueryStatisticsByAction(hentity);
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 16;
excelconfig.IsAllSizeColumn = true;
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
if (stype == "监管图")
{
excelconfig.Title = "旁站监管统计";
excelconfig.FileName = "旁站监管统计.xls";
//需跟数据源列顺序保持一致
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "fullname", ExcelColumn = "部门名称", Width = 40
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "ordinaryhid", ExcelColumn = "需监管", Width = 40
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "importanhid", ExcelColumn = "已监管", Width = 40
});
}
else if (stype == "监督图")
{
excelconfig.Title = "旁站监督统计";
excelconfig.FileName = "旁站监督统计.xls";
//需跟数据源列顺序保持一致
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "fullname", ExcelColumn = "部门名称", Width = 40
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "importanhid", ExcelColumn = "已监督", Width = 40
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "total", ExcelColumn = "需监督", Width = 40
});
}
//调用导出方法
ExcelHelper.ExcelDownload(dt, excelconfig);
}
catch (Exception ex)
{
}
return(Success("导出成功。"));
}
