//用户管理
private void btnUsermanager_Click(object sender, EventArgs e)
{
listView1.ContextMenuStrip = cmsUser;
treeView1.Nodes.Clear();
DataTable provinceTable = (DataTable)dataDisposes.Select("userinfo", "province", "");
ArrayList arrProvince = new ArrayList();
for (int i = 0; i < provinceTable.Rows.Count; i++)
{
if (arrProvince.Contains(provinceTable.Rows[i][0].ToString()) == false)
{
arrProvince.Add(provinceTable.Rows[i][0].ToString());
}
}
TreeNode node0 = new TreeNode();
node0.Text = "用户列表";
for (int i = 0; i < arrProvince.Count; i++)
{
TreeNode node1 = new TreeNode();
node1.Text = arrProvince[i].ToString();
DataTable userNameTable = (DataTable)dataDisposes.Select("userinfo", "username ,userid", "where province='" + node1.Text + "'");
for (int j = 0; j < userNameTable.Rows.Count; j++)
{
TreeNode node2 = new TreeNode();
node2.Text = userNameTable.Rows[j][0].ToString();
node2.Tag = userNameTable.Rows[j]["userid"];
node1.Nodes.Add(node2);
}
node0.Nodes.Add(node1);
}
treeView1.Nodes.Add(node0);
treeView1.ExpandAll();
}
//刷新treeview
private void RefreshTree(string tableName, string columnStr1, string nodeStr, string columnStr2, string whereStr, string idType)
{
treeView1.Nodes.Clear();
DataTable provinceTable = (DataTable)dataDisposes.Select(tableName, columnStr1, "");
ArrayList arrProvince = new ArrayList();
for (int i = 0; i < provinceTable.Rows.Count; i++)
{
arrProvince.Add(provinceTable.Rows[i][0].ToString());
}
TreeNode node0 = new TreeNode();
node0.Text = nodeStr;
for (int i = 0; i < arrProvince.Count; i++)
{
TreeNode node1 = new TreeNode();
node1.Text = arrProvince[i].ToString();
DataTable userNameTable = (DataTable)dataDisposes.Select(tableName, columnStr2, whereStr + node1.Text + "'");
for (int j = 0; j < userNameTable.Rows.Count; j++)
{
TreeNode node2 = new TreeNode();
node2.Text = userNameTable.Rows[j][0].ToString();
node2.Tag = userNameTable.Rows[j][idType];
node1.Nodes.Add(node2);
}
node0.Nodes.Add(node1);
}
treeView1.Nodes.Add(node0);
treeView1.ExpandAll();
}
private void projectfrm_Load(object sender, EventArgs e)
{
State = false;
if (this.Text == "添加项目")
{
DataTable maxid = (DataTable)dataDisposes.Select("projectinfo", "max(projectid) as maxid ", "");
int newid = (int)maxid.Rows[0]["maxid"] + 1;
txtProID.Text = newid.ToString();
txtProName.Text = ProName;
}
else
{
DataTable curUser = (DataTable)dataDisposes.Select("projectinfo", "*", "where projectid=" + id);
txtProID.Text = curUser.Rows[0]["projectid"].ToString();
txtProName.Text = curUser.Rows[0]["projectname"].ToString();
txtProvince.Text = curUser.Rows[0]["province"].ToString();
txtRemarks.Text = curUser.Rows[0]["remarks"].ToString();
}
}
private void typefrm_Load(object sender, EventArgs e)
{
State = false;
if (this.Text == "添加类型")
{
DataTable maxid = (DataTable)dataDisposes.Select("exceptionstype", "max(typeid) as maxid ", "");
int newid = (int)maxid.Rows[0]["maxid"] + 1;
txtTypeID.Text = newid.ToString();
txtTypeName.Text = TypeName;
}
else
{
DataTable curUser = (DataTable)dataDisposes.Select("exceptionstype", "*", "where typeid=" + id);
txtTypeID.Text = curUser.Rows[0]["typeid"].ToString();
txtTypeName.Text = curUser.Rows[0]["typename"].ToString();
txtCategory.Text = curUser.Rows[0]["category"].ToString();
txtRemarks.Text = curUser.Rows[0]["remarks"].ToString();
}
}
private void userFrom_Load(object sender, EventArgs e)
{
State = false;
if (this.Text == "添加用户")
{
DataTable maxid = (DataTable)dataDisposes.Select("userinfo", "max(userid) as maxid ", "");
int newid = (int)maxid.Rows[0]["maxid"] + 1;
txtUserID.Text = newid.ToString();
txtUserName.Text = UserName;
}
else
{
DataTable curUser = (DataTable)dataDisposes.Select("userinfo", "*", "where userid=" + id);
txtUserID.Text = curUser.Rows[0]["userid"].ToString();
txtUserName.Text = curUser.Rows[0]["username"].ToString();
txtProvince.Text = curUser.Rows[0]["province"].ToString();
txtPhone.Text = curUser.Rows[0]["phone"].ToString();
txtRemark.Text = curUser.Rows[0]["remarks"].ToString();
}
}
private AutoCompleteStringCollection getSuggestSource(string tableName, string column)
{
DataDisposes dataDisposes = new DataDisposes();
AutoCompleteStringCollection strings = new AutoCompleteStringCollection();
DataTable userTable = (DataTable)dataDisposes.Select(tableName, "*", "");
foreach (DataRow dr in userTable.Rows)
{
strings.Add(dr[column].ToString());
}
return(strings);
}
string _tempExInfoID = ""; //修改时载入的异常信息ID tlw-1-1
private void EXInfoFrm_Load(object sender, EventArgs e)
{
cmbUser.AutoCompleteCustomSource = getSuggestSource("userinfo", "username", cmbUser);
cmbPro.AutoCompleteCustomSource = getSuggestSource("projectinfo", "projectName", cmbPro);
cmbExType.AutoCompleteCustomSource = getSuggestSource("exceptionstype", "typeName", cmbExType);
txtExName.AutoCompleteCustomSource = getSuggestSource("exceptionsinfo", "exceptionname");
if (this.Text == "添加异常信息")
{
DataTable maxid = (DataTable)dataDisposes.Select("exceptionsinfo", "max(id) as maxid ", "");
int newid = (int)maxid.Rows[0]["maxid"] + 1;
txtID.Text = newid.ToString();
}
else
{
txtID.Text = ID.ToString();
string[] IDCollections = new string[3];
string sql = "select * from exceptionsinfo where id=" + ID;
OleDbDataReader odr = DBHelper.GetReader(sql);
while (odr.Read())
{
_tempProID = odr["projectid"].ToString(); //初始化tempID值
_tempTypeID = odr["typeid"].ToString();
_tempExInfoID = odr["exceptionid"].ToString();
IDCollections[0] = odr["userid"].ToString();
IDCollections[1] = odr["projectid"].ToString();
IDCollections[2] = odr["typeid"].ToString();
txtExName.Text = odr["exceptionName"].ToString();
txtDescripe.Text = odr["exceptiondescription"].ToString();
txtSolution.Text = odr["solution"].ToString();
txtRemarks.Text = odr["remarks"].ToString();
}
odr.Close();
cmbUser.Text = IDtoName("select username from userinfo where userid=" + IDCollections[0], "username");
cmbPro.Text = IDtoName("select projectname from projectinfo where projectid=" + IDCollections[1], "projectname");
cmbExType.Text = IDtoName("select typeName from exceptionstype where typeid=" + IDCollections[2], "typeName");
txtExID.Text = _tempExInfoID; //以免发生变化
}
}
private void btnTypeCre_Click(object sender, EventArgs e)
{
DataTable pDataTable = (DataTable)dataDisposes.Select("userinfo", "*", "");
}