/// <summary>
/// 页面公用ViewBag
/// </summary>
/// <param name="PageCode">页面编码（菜单编码）</param>
/// <param name="RightCode">权限编码 用于页面级权限验证</param>
/// <param name="PageTitle">页面标题 标题为空自动获取页面标题及上级页面标题</param>
public void pubViewBag(string PageCode, string RightCode, string PageTitle)
{
CookieModel cookieInfo = SystemCls.getCookieInfo();
ViewBag.getPageMenuStr = getPageMenuStr(PageCode);
ViewBag.PageCode = PageCode;
string curORGNo = SystemCls.getCurUserOrgNo();
if (PublicCls.OrgIsShi(curORGNo))
{
curORGNo = ConfigCls.getConfigValue("ProvincialCapital");//州府所在地行政区划编码
}
//获取火险等级
ViewBag.fireLevel = YJ_DANGERCLASSCls.getLevelByOrgNo(new YJ_DANGERCLASS_SW {
BYORGNO = curORGNo
});
//获取滚动信息
if (T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW {
PARAMFLAG = "LoginInfo"
}).ToString() == "0")
{
ViewBag.marqueeSysInfo = T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW {
PARAMFLAG = "marqueeIndexInfo"
}).ToString();
}
else
{
ViewBag.marqueeSysInfo = YJ_WEATHERCls.getWeather(new YJ_WEATHER_SW {
BYORGNO = curORGNo
});
}
ViewBag.PageLeftMenu = getPageLeftMenu(PageCode); //左侧菜单
ViewBag.isPageRight = SystemCls.isRight(RightCode); //判断页面是否有权限
ViewBag.SystemName = ConfigCls.getSystemName(); //系统名称
ViewBag.noticeRefreshTimeInterval = ConfigCls.noticeRefreshTimeInterval(); //菜单自动刷新间隔
ViewBag.PageTitle = PageTitle;
//如果页面标题为空，则自动通过页面编码从系统菜单表中获取菜单名称及上级菜单名称
if (string.IsNullOrEmpty(PageTitle))
{
ViewBag.PageTitle = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW {
MENUCODE = PageCode, SYSFLAG = ConfigCls.getSystemFlag()
}).MENUNAME;
}
ViewBag.Title = ConfigCls.getSystemName() + "-" + ViewBag.PageTitle; //Title名称
ViewBag.SystemLogo = ConfigCls.getSystemLogo(); //获取系统logo图片
ViewBag.trueName = cookieInfo.trueName; //当前登录用户姓名
ViewBag.TopFireAlarm = ConfigCls.getTopFireAlarm(); //是否火情报警
ViewBag.TopFireLevel = ConfigCls.getTopFireLevel(); //是否显示火险等级
ViewBag.depName = StateSwitch.GetOrgNameByOrgNO(SystemCls.getCurUserOrgNo()); //部门名称
string systemFlag = ConfigCls.getSystemFlag(); //系统标识 如Springer
ViewBag.T_UrlReferrer = Request.UrlReferrer;
}
public FileResult CollectCountExportExcel()
{
string BYORGNO = Request.Params["BYORGNO"];
string TIMEBegin = Request.Params["TIMEBegin"];
string TIMEEnd = Request.Params["TIMEEnd"];
string HID = Request.Params["HID"];
string SYSTYPEVALUE = Request.Params["SYSTYPEVALUE"];
var vMenu = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW {
MENUCODE = "004004", SYSFLAG = ConfigCls.getSystemFlag()
});
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //添加一个sheet
sheet1.IsPrintGridlines = true; //打印时显示网格线
sheet1.DisplayGridlines = true; //查看时显示网格线
IRow row = sheet1.CreateRow(0);
row.CreateCell(0).SetCellValue(vMenu.MENUNAME);
row.GetCell(0).CellStyle = getCellStyleTitle(book);
IEnumerable <T_IPSCOL_COLLECT_TypeCountModel> typeModel;
var list = T_IPSCOL_COLLECTCls.getModelCount(new T_IPSCOL_COLLECT_SW {
TopORGNO = BYORGNO, DateBegin = TIMEBegin, DateEnd = TIMEEnd
}, out typeModel);
int typeCount = 0;//计算类别有多少列
foreach (var v in typeModel)
{
typeCount++;
}
sheet1.SetColumnWidth(0, 30 * 256);
sheet1.SetColumnWidth(1, 20 * 256);
for (int i = 0; i < typeCount; i++)
{
sheet1.SetColumnWidth(i + 2, 20 * 256);
}
row = sheet1.CreateRow(1);
if (PublicCls.OrgIsZhen(BYORGNO) == false)
{
row.CreateCell(0).SetCellValue("单位");
}
else
{
row.CreateCell(0).SetCellValue("姓名");
}
row.CreateCell(1).SetCellValue("总数");
int indexType = 2;//从第二列开始
foreach (var v in typeModel)
{
row.CreateCell(indexType).SetCellValue(v.typeName);
indexType++;
}
for (int i = 0; i < typeCount + 2; i++)
{
row.GetCell(i).CellStyle = getCellStyleHead(book);
}
sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, typeCount + 1));
int rowI = 0; //数据行
foreach (var v in list) //循环获取数据
{
row = sheet1.CreateRow(rowI + 2);
if (string.IsNullOrEmpty(v.ORGName) == false)
{
row.CreateCell(0).SetCellValue(v.ORGName);
row.GetCell(0).CellStyle = getCellStyleLeft(book);
}
else
{
row.CreateCell(0).SetCellValue(v.HName);
row.GetCell(0).CellStyle = getCellStyleCenter(book);
}
row.CreateCell(1).SetCellValue(v.CollectCount);
row.GetCell(1).CellStyle = getCellStyleCenter(book);
int TypeI = 2;//类型开始列
foreach (var vv in v.TypeCountModel)
{
row.CreateCell(TypeI).SetCellValue(vv.typeCount);
row.GetCell(TypeI).CellStyle = getCellStyleCenter(book);
TypeI++;
}
rowI++;
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
string fileName = vMenu.MENUNAME + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
return(File(ms, "application/vnd.ms-excel", fileName));
}
/// <summary>
/// 导出
/// </summary>
/// <returns></returns>
public FileResult HUCountExportExcel()
{
var vMenu = T_SYS_MENUCls.getModel(new T_SYS_MENU_SW {
MENUCODE = "004001", SYSFLAG = ConfigCls.getSystemFlag()
});
//vMenu.MENUNAME 页面/菜单名称
NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook();
//添加一个sheet
NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1");
sheet1.IsPrintGridlines = true; //打印时显示网格线
sheet1.DisplayGridlines = true; //查看时显示网格线
sheet1.SetColumnWidth(0, 50 * 256);
sheet1.SetColumnWidth(1, 10 * 256);
sheet1.SetColumnWidth(2, 10 * 256);
sheet1.SetColumnWidth(3, 10 * 256);
sheet1.SetColumnWidth(4, 10 * 256);
sheet1.SetColumnWidth(5, 10 * 256);
IRow row = sheet1.CreateRow(0);
row.CreateCell(0).SetCellValue(vMenu.MENUNAME);
row.GetCell(0).CellStyle = getCellStyleTitle(book);
row = sheet1.CreateRow(1);
row.CreateCell(0).SetCellValue("单位");
row.CreateCell(1).SetCellValue("总数");
row.CreateCell(2).SetCellValue("性别");
row.CreateCell(4).SetCellValue("固/兼职");
row.GetCell(0).CellStyle = getCellStyleHead(book);
row.GetCell(1).CellStyle = getCellStyleHead(book);
row.GetCell(2).CellStyle = getCellStyleHead(book);
row.GetCell(4).CellStyle = getCellStyleHead(book);
row = sheet1.CreateRow(2);
row.CreateCell(2).SetCellValue("男");
row.CreateCell(3).SetCellValue("女");
row.CreateCell(4).SetCellValue("固职");
row.CreateCell(5).SetCellValue("兼职");
row.GetCell(2).CellStyle = getCellStyleHead(book);
row.GetCell(3).CellStyle = getCellStyleHead(book);
row.GetCell(4).CellStyle = getCellStyleHead(book);
row.GetCell(5).CellStyle = getCellStyleHead(book);
sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, 5));
sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 1, 2, 3));
sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 1, 4, 5));
sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 2, 0, 0));
sheet1.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(1, 2, 1, 1));
T_IPSFR_USER_SW sw = new T_IPSFR_USER_SW();
sw.TopORGNO = Request.Params["TopORGNO"];
var list = HUReportCls.getHUCountModel(sw);
int rowI = 0;
foreach (var item in list)
{
row = sheet1.CreateRow(rowI + 3);
row.CreateCell(0).SetCellValue(item.ORGName);
row.CreateCell(1).SetCellValue(item.HUCount);
row.CreateCell(2).SetCellValue(item.Sex0Count);
row.CreateCell(3).SetCellValue(item.Sex1Count);
row.CreateCell(4).SetCellValue(item.Onstate0Count);
row.CreateCell(5).SetCellValue(item.Onstate1Count);
for (int i = 0; i < 6; i++)
{
if (i == 0)
{
row.GetCell(0).CellStyle = getCellStyleLeft(book);
}
else
{
row.GetCell(i).CellStyle = getCellStyleCenter(book);
}
}
rowI++;
}
// 写入到客户端
System.IO.MemoryStream ms = new System.IO.MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
string fileName = vMenu.MENUNAME + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
return(File(ms, "application/vnd.ms-excel", fileName));
}
