//treeNode 单击事件 private void TreeNodeMouseClick(TreeNode curNode, string tableName, string columnStr1, string whereStr, string ID, string columnStr2) { //用户信息填充 id = (int)curNode.Tag; //listView1.Clear(); listView1.Items.Clear(); DataTable userInfoTable = (DataTable)dataDisposes.Select(tableName, columnStr1, whereStr + curNode.Tag); ListViewItem lisitem = new ListViewItem(userInfoTable.Rows[0][ID].ToString(), 0); for (int i = 1; i < userInfoTable.Columns.Count; i++) { lisitem.SubItems.Add(userInfoTable.Rows[0][i].ToString()); } listView1.Items.Add(lisitem); //异常信息填充 listView2.Items.Clear(); List <ExceptionsInfo> list = ExceptionsInfoManage.FindAll(whereStr + curNode.Tag); foreach (ExceptionsInfo ex in list) { ListViewItem lvi = new ListViewItem(ex.ID.ToString()); lvi.SubItems.Add(ex.UserID); lvi.SubItems.Add(ex.ProjectName.ToString()); lvi.SubItems.Add(ex.TypeID.ToString()); lvi.SubItems.Add(ex.ExcepitionID); lvi.SubItems.Add(ex.ExcepitionName); lvi.SubItems.Add(ex.ExcepitionDescri); lvi.SubItems.Add(ex.Solution); lvi.SubItems.Add(ex.Remarks); listView2.Items.Add(lvi); } }
//确定键单击事件 private void btnOK_Click(object sender, EventArgs e) { bool check = false; try { UserID = convertNametoID("select userid from userinfo where username ='******'", "userid"); ProID = convertNametoID("select projectid from projectinfo where projectName ='" + cmbPro.Text.Trim() + "'", "projectid"); if (UserID == null | ProID == null | txtExName.Text.Trim() == null) { lblErr.Text = " 请填正确写必要信息!"; return; } } catch (Exception err) { lblErr.Text = err.Message; return; } if (this.Text == "添加异常信息") { string sqlExInfo = "insert into exceptionsInfo values('" + txtID.Text.Trim() + "','" + UserID + "','" + ProID + "','" + TypeID + "','" + txtExID.Text + "','" + txtExName.Text.Trim() + "','" + txtDescripe.Text.Trim() + "','" + txtSolution.Text.Trim() + "','" + txtRemarks.Text.Trim() + "')"; try { DBHelper.ExcuteCommand(sqlExInfo); } catch (Exception ex) { lblErr.Text = "异常类型不存在请添加."; return; } } if (this.Text == "修改异常信息") { check = ExceptionsInfoManage.updateExinfo(ID, UserID, ProID, TypeID, txtExID.Text, txtExName.Text.Trim(), txtDescripe.Text.Trim(), txtSolution.Text.Trim(), txtRemarks.Text.Trim()); } if (check) { this.Close(); this.Dispose(); } else { lblErr.Text = "保存失败!"; } }
private void cmbExType_TextChanged(object sender, EventArgs e) { TypeID = ExceptionsTypeManage.getIDbyName(cmbExType.Text.Trim()); if (TypeID != "") { if (TypeID == _tempTypeID) { txtExID.Text = _tempExInfoID; } else { string strTemp = "TLW-" + TypeID + "-"; txtExID.Text = ExceptionsInfoManage.getMaxExInfoID(strTemp); } } }
/// <summary> /// 通过ID查询异常信息 /// </summary> /// <param name="listID"></param> private void queryByName(List <int> listID) { int count = 0; flowLayoutPanel1.Controls.Clear(); foreach (int ex in listID) { string whereStr = _columnID + "=" + ex; List <ExceptionsInfo> list; if (_pageIndex > 1) { list = ExceptionsInfoManage.findTop(_pageIndex, _pageSize, whereStr); } else { list = ExceptionsInfoManage.findFirstPage(_pageSize, whereStr); } AddResult(list); count = ExceptionsInfoManage.returnCount(whereStr); _count += count; } pnlResultDorkSetting(); }
/// <summary> /// 根据用户选择的查询方式查询 /// </summary> private void DoQuery() { if (cmbo.Text != "" && _whereTemp != "") { _count = 0; _listbtn.Clear(); string whereStr = null; List <ExceptionsInfo> list = null; IGraphicsContainer pGContainer = axMapControl1.Map as IGraphicsContainer; pGContainer.DeleteAllElements(); switch (cmbo.Text) { case "ID": whereStr = "ID like '%" + _whereTemp + "%'"; break; case "用户名": List <int> listUserID = UserInfoManage.FindByNameArr(_whereTemp); queryByName(listUserID); return; //完全跳出 case "项目名称": List <int> listProID = ProjectInfoManage.FindByNameArr(_whereTemp); queryByName(listProID); return; //完全跳出 case "异常类型": List <int> listTypeID = ExceptionsTypeManage.FindByNameArr(_whereTemp); queryByName(listTypeID); return; //完全跳出 case "异常ID": whereStr = "exceptionID like '%" + _whereTemp + "%'"; break; case "异常名称": whereStr = "exceptionName like '%" + _whereTemp + "%'"; break; default: break; } if (whereStr != null) { if (_pageIndex > 1) { list = ExceptionsInfoManage.findTop(_pageIndex, _pageSize, whereStr); } else { list = ExceptionsInfoManage.findFirstPage(_pageSize, whereStr); } flowLayoutPanel1.Controls.Clear(); AddResult(list); _count = ExceptionsInfoManage.returnCount(whereStr); } } }