//用户管理 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", "*", ""); }