private void btnImportEventConfig_Click(object sender, EventArgs e)
{
var formSysMessage = FormSysMessage.ShowLoading();
var filePath = TxtEventConfigFile.Text;
if (string.IsNullOrEmpty(filePath) || !File.Exists(filePath))
{
throw new CustomException("请输入上传文件存储地址！", ExceptionType.Warn);
}
List <EventDetail> listEventDetail = new List <EventDetail>();
using (var fileStream = new FileStream(filePath, FileMode.Open)) {
IWorkbook workbook = new XSSFWorkbook(fileStream);
ISheet sheet = workbook.GetSheetAt(0);
for (int i = (sheet.FirstRowNum + 1); i < sheet.LastRowNum - 1; i++)
{
IRow row = sheet.GetRow(i);
EventDetail entity = new EventDetail();
if (string.IsNullOrEmpty(row.GetCell(0).ToString()) ||
string.IsNullOrEmpty(row.GetCell(1).ToString()))
{
continue;
}
entity.EventId = row.GetCell(0).ToString();
entity.EventName = row.GetCell(1).ToString();
entity.EventDate = Convert.ToDateTime(row.GetCell(2).ToString());
listEventDetail.Add(entity);
}
}
if (listEventDetail.Any())
{
EventDetailBLL.CreateInstance().Insert(listEventDetail);
}
formSysMessage.SetMessage("上传成功！");
FormMain.LoadNewControl(EventConfigList.Instance); // 载入该模块的信息列表界面至主窗体显示。
}
/// <summary>
/// 对DataGridView控件的数据源进行绑定。
/// </summary>
public static void BindDataGrid()
{
instance.PageBar.DataControl = instance.DgvGrid;
instance.PageBar.DataSource = EventDetailBLL.CreateInstance().GetPageList(instance.PageBar.PageSize, instance.PageBar.CurPage);
instance.PageBar.DataBind();
}
