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