private void btnDelete_Click(object sender, EventArgs e) { try { if (dataGridView.SelectedRows.Count < 1) { return; } string E_ID = dataGridView.SelectedRows[0].Cells["E_ID"].Value.ToString(); string E_Code = dataGridView.SelectedRows[0].Cells["E_Code"].Value.ToString(); if (untCommon.QuestionMsg("您确定删除[" + E_Code + "]该项吗?")) { InspectBLL inspectbll = new InspectBLL(); if (inspectbll.Delete(E_ID) > 0) { untCommon.InfoMsg("删除成功!"); Refresh(); } else { untCommon.InfoMsg("删除失败!"); } } } catch (Exception ex) { untCommon.ErrorMsg("设备管理删除数据异常:" + ex.Message); } }
/// <summary> /// 刷新数据 /// </summary> private void Refresh() { try { InspectBLL inspectbll = new InspectBLL(); int count = inspectbll.getRowCount(sqlwhere.ToString()); //获得总行数 pagerControl.DrawControl(count); int star = (pagerControl.PageSize * pagerControl.PageIndex) - pagerControl.PageSize; //开始行 int end = pagerControl.PageSize * pagerControl.PageIndex; //结束行 var rows = inspectbll.getPagerData(star, end, sqlwhere.ToString()); //加载数据 if (rows == null || rows.Count < 1) { untCommon.InfoMsg("没有任何数据!"); return; } dataGridView.DataSource = rows; } catch (Exception ex) { untCommon.ErrorMsg("巡检记录查询加载数据异常:" + ex.Message); } }