using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
using System.Web.UI;
|
using System.Web.UI.WebControls;
|
using CY.BLL;
|
using CY.Model;
|
using CY.Infrastructure.Query;
|
using CY.Infrastructure.Common;
|
using CY.BLL.OA;
|
using CY.BLL.Sys;
|
using System.IO;
|
using NPOI.SS.UserModel;
|
using NPOI.XSSF.UserModel;
|
using System.Transactions;
|
using CY.BLL.EC;
|
using CY.BLL.Inquiry;
|
using CY.Model.Inquiry;
|
|
namespace CY.WebForm.Pages.financial
|
{
|
public partial class ShiJuanBiaoQianList : BasePage
|
{
|
|
OA_ShiJuanBiaoQianBLL _ShiJuanBiaoQianBLL = new OA_ShiJuanBiaoQianBLL();
|
|
|
protected void Page_Load(object sender, EventArgs e)
|
{
|
UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
|
if (!IsPostBack)
|
{
|
|
|
BindList();
|
}
|
|
if (Request["Target"] != null && Request["Target"] == "BatchDelete")
|
{
|
CY.WebForm.cs.WebUtil.DeleteData(_ShiJuanBiaoQianBLL.DeleteDataByIds, CurrentUser.ShortName);//调用通用删除方法
|
Response.End();
|
}
|
|
}
|
|
|
/// <summary>
|
/// 加载全部数据
|
/// </summary>
|
private void BindList()
|
{
|
|
Pagination pa = new Pagination();
|
pa.PageSize = this.UCPager1.AspNetPager.PageSize;
|
pa.PageIndex = this.UCPager1.AspNetPager.CurrentPageIndex;
|
|
this.RepSubjeSetctList.DataSource = _ShiJuanBiaoQianBLL.SelectModelPage(pa,CurrentUser.MemberId,this.txtBeginData.Value.Trim(),this.txtEndDate.Value.Trim(),
|
this.txtBianhao.Value.Trim(), this.txtQuyu.Value.Trim(), this.txtXuexiao.Value.Trim(), this.txtNianji.Value.Trim(), this.txtKemu.Value.Trim());
|
|
this.RepSubjeSetctList.DataBind();
|
UCPager1.AspNetPager.RecordCount = pa.RecordCount;
|
|
}
|
|
protected void AspNetPager1_PageChanged(object src, EventArgs e)
|
{
|
BindList();
|
}
|
|
protected void btn_Register_Click(object sender, EventArgs e)
|
{
|
BindList();
|
}
|
|
|
|
protected void btn_Submit_Click(object sender, EventArgs e)
|
{
|
|
var files = Request.Files;
|
if (files.Count <= 0)
|
return;
|
|
var file = files[0];
|
if (file == null)
|
{
|
JavaScript.MessageBox("请选择文件", this);
|
return;
|
}
|
|
//初始化上传参数
|
var maxSize = 1024 * 1024 * 5; //上传大小5M
|
|
var fileName = file.FileName;
|
var fileExt = Path.GetExtension(fileName).ToLowerInvariant();
|
|
//检查大小
|
if (file.ContentLength > maxSize)
|
{
|
|
JavaScript.MessageBox("上传文件大小超过限制，最大允许上传5M", this);
|
return;
|
}
|
|
string FileTypes = "xlsx";//xls,
|
//检查文件扩展名
|
if (string.IsNullOrEmpty(fileExt) ||
|
Array.IndexOf(FileTypes.Split(','), fileExt.Substring(1).ToLower()) == -1)
|
{
|
JavaScript.MessageBox("上传文件扩展名是不允许的扩展名,请上传后缀名为：" + FileTypes, this);
|
return;
|
}
|
var lie = new List<OA_ShiJuanBiaoQian>();
|
|
using (var fileStream = file.InputStream)
|
{
|
// 使用HSSFWorkbook打开.xls格式的文件
|
IWorkbook workbook = new XSSFWorkbook(fileStream);
|
|
// 获取第一个工作表
|
ISheet sheet = workbook.GetSheetAt(0);
|
|
|
|
|
|
|
|
// 迭代工作表中的所有行
|
for (int i = 1; i <= sheet.LastRowNum; i++)
|
{
|
var hang = new OA_ShiJuanBiaoQian();
|
|
|
|
IRow row = sheet.GetRow(i);
|
if (row == null) continue; // 跳过空行
|
|
|
ICell cell0 = row.GetCell(0);
|
if (cell0 == null)
|
{
|
JavaScript.MessageBox("第" + (i + 1) + "编号不能为空", this);
|
return;
|
}
|
hang.Bianhao = getcellvalue(cell0);
|
|
ICell cell1 = row.GetCell(1);
|
if (cell1 == null)
|
{
|
JavaScript.MessageBox("第" + (i + 1) + "片区不能为空", this);
|
return;
|
}
|
hang.Quyu = getcellvalue(cell1);
|
|
ICell cell2 = row.GetCell(2);
|
if (cell2 == null)
|
{
|
JavaScript.MessageBox("第" + (i + 1) + "学校不能为空", this);
|
return;
|
}
|
hang.Xuexiao = getcellvalue(cell2);
|
|
ICell cell3 = row.GetCell(3);
|
if (cell3 == null)
|
{
|
JavaScript.MessageBox("第" + (i + 1) + "年级不能为空", this);
|
return;
|
}
|
hang.Nianji = getcellvalue(cell3);
|
|
ICell cell4 = row.GetCell(4);
|
if (cell4 == null)
|
{
|
JavaScript.MessageBox("第" + (i + 1) + "科目不能为空", this);
|
return;
|
}
|
hang.Kemu = getcellvalue(cell4);
|
|
ICell cell5 = row.GetCell(5);
|
if (cell5 == null)
|
{
|
JavaScript.MessageBox("第" + (i + 1) + "大不能为空", this);
|
return;
|
}
|
hang.Da = getcellvalue(cell5);
|
|
ICell cell6 = row.GetCell(6);
|
if (cell6 == null)
|
{
|
JavaScript.MessageBox("第" + (i + 1) + "小不能为空", this);
|
return;
|
}
|
hang.Xiao = getcellvalue(cell6);
|
lie.Add(hang);
|
|
}
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required,
|
new TransactionOptions
|
{
|
IsolationLevel = IsolationLevel.ReadCommitted,
|
Timeout = TransactionManager.MaximumTimeout
|
}
|
))
|
{
|
|
|
if (lie != null && lie.Count > 0)
|
{
|
var creater= CurrentUser.ShortName;
|
var creattiem = DateTime.Now;
|
var FirmId = CurrentUser.MemberId;
|
for (int j = 0; j < lie.Count; j++)
|
{
|
|
lie[j].Creater = creater;
|
lie[j].Updater = creater;
|
lie[j].CreateTime = creattiem;
|
lie[j].LastUpdateTime = creattiem;
|
lie[j].FirmId = FirmId;
|
|
var id = _ShiJuanBiaoQianBLL.InsertModel(lie[j]);
|
|
|
|
|
}
|
|
|
}
|
else
|
{
|
|
|
JavaScript.MessageBox("表格无数据", this);
|
return;
|
}
|
scope.Complete();
|
}
|
|
|
|
|
|
|
JavaScript.MessageBox("上传文件成功", this);
|
BindList();
|
|
return;
|
}
|
|
|
|
|
/// <summary>
|
/// 计划订单上传接口
|
/// </summary>
|
/// <returns></returns>
|
public string getcellvalue(ICell cell)
|
{
|
string cellvalue = "";
|
switch (cell.CellType)
|
{
|
case CellType.String:
|
// Console.WriteLine(cell.StringCellValue);
|
cellvalue = cell.StringCellValue.Trim();
|
break;
|
case CellType.Numeric:
|
//Console.WriteLine(cell.NumericCellValue);
|
cellvalue = cell.NumericCellValue.ToString().Trim();
|
break;
|
case CellType.Boolean:
|
//Console.WriteLine(cell.BooleanCellValue);
|
cellvalue = cell.BooleanCellValue.ToString().Trim();
|
break;
|
case CellType.Error:
|
// Console.WriteLine(cell.ErrorCellValue);
|
cellvalue = cell.ErrorCellValue.ToString().Trim();
|
break;
|
case CellType.Blank:
|
// Console.WriteLine(cell.ErrorCellValue);
|
cellvalue = "";
|
break;
|
// 可以添加其他类型的case
|
}
|
|
return cellvalue;
|
}
|
|
|
}
|
}
|
