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);
}
}
