Example #1
0
        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);
            }
        }
Example #2
0
        /// <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);
            }
        }