protected List <TH_HAZALOCA> GetGridDataSource()
{
var res = new List <TH_HAZALOCA>();
foreach (var row in this.HAZALOCAGrid.Rows)
{
var idkey = (string)row.DataKeys[0];
res.Add(TH_HAZALOCA.FindbyID(idkey));
}
return(res);
}
protected void Btn_AddIn_Click(object sender, EventArgs e)
{
try
{
string strFileName = this.File_Upload.FileName;
//验证是否选择了文件
if ("" == strFileName.Trim())
{
throw new Exception("没有选择文件");
}
//验证文件类型是不是Excel
//if (strFileName.Substring(strFileName.LastIndexOf('.')) != ".xlsx" && strFileName.Substring(strFileName.LastIndexOf('.')) != ".xls")
//{
// throw new Exception("文件类型错误");
//}
if (strFileName.Substring(strFileName.LastIndexOf('.')) != ".xls")
{
throw new Exception("文件类型错误");
}
//获取上载文件内容
var fileStream = File_Upload.PostedFile.InputStream;
NPOI.HSSF.UserModel.HSSFWorkbook wb = new NPOI.HSSF.UserModel.HSSFWorkbook(fileStream);
if (wb == null)
{
throw new Exception("Excel表格数据为空");
}
HSSFSheet sheet = wb.GetSheetAt(0) as HSSFSheet;
var re0 = TH_HAZALOCA.BuildListByNPOISheet(sheet);
if (!re0.Flag)
{
throw new Exception(re0.Msg);
}
if (re0.Flag)
{
Notify.ShowMessage("成功添加条数:" + re0.Msg);
}
else
{
throw new Exception(re0.Msg);
}
}
catch (Exception ex)
{
Notify.ShowMessage(ex.Message);
return;
}
}
/// <summary>
/// 小窗口添加危险源区域按钮反馈
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Btn_AddLOCA_Add_Click(object sender, System.EventArgs e)
{
var name = this.AddLOCA_NAMEText.Text;
var dept = this.dept_tbxMyBox2.Text.Split('_')[0];
if (name == "" || dept == "")
{
Notify.ShowMessage("未填名称或地址");
return;
}
var locaentity = new TH_HAZALOCA(name, dept);
var re = locaentity.AddtoDB();
this.AddLOCA_Window.Hidden = true;
}
protected void Btn_DelLOCA_Click(object sender, EventArgs e)
{
var arr = this.HAZALOCAGrid.SelectedRowIndexArray;
foreach (var index_num in arr)
{
var id_key = (string)this.HAZALOCAGrid.Rows[index_num].DataKeys[0];
var selected_loca = TH_HAZALOCA.FindbyID(id_key);
selected_loca.SetStatsAndSave("删除");
selected_loca.ThisEntitySaveChanges();
}
var db = new SAFEDB();
var haza_loca = (from x in db.TH_HAZALOCA
where x.STATS != "04"
orderby x.ID
select x);
this.BindGrid(haza_loca);
}
