private void LoadLines() { DataTable dt = LineHelperClient.GetLineList(); if (dt != null) { treeLines.Nodes.Clear(); TreeNode TopNode = new TreeNode(); TopNode.Name = ""; TopNode.Text = "线路列表"; TopNode.SelectedImageIndex = 1; TopNode.ImageIndex = 0; treeLines.Nodes.Add(TopNode); foreach (DataRow row in dt.Rows) { TreeNode n = new TreeNode(); n.Name = row["ID"].ToString(); n.Text = row["LineName"].ToString(); n.SelectedImageIndex = 2; n.ImageIndex = 2; TopNode.Nodes.Add(n); } } treeLines.ExpandAll(); treeLines.AfterCheck += new TreeViewEventHandler(treeLines_AfterCheck); }
private void btn_save_Click(object sender, EventArgs e) { if (treeView1.SelectedNode != null) { if (treeView1.SelectedNode.Tag.ToString().ToLower() == "true") { Guid destModuleID = new Guid(treeView1.SelectedNode.Name); Boolean flag = LineHelperClient.UpdateSpecialModule(moduleID, destModuleID); MessageBox.Show(flag ? "成功" : "失败"); } } }
private void BindLines() { DataTable dt = LineHelperClient.GetLineList(); //cmbLines.Items.Insert(0, "根据线路选择"); DataRow row = dt.NewRow();//ID,LineName,Description,IPAddress,Port row["ID"] = Guid.NewGuid(); row["LineName"] = "根据线路选择"; row["Description"] = "根据线路选择"; dt.Rows.InsertAt(row, 0); cmbLines.DisplayMember = "Description"; cmbLines.DataSource = dt; }
private void NotifyUserMsgDlg_Load(object sender, EventArgs e) { FpSpread_Info.Columns.Count = 10; FpSpread_Info.ColumnHeader.RowCount = 1; FpSpread_Info.ColumnHeader.Cells[0, 0].Text = "SessionID"; FpSpread_Info.ColumnHeader.Cells[0, 0].Tag = "SessionID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Text = "LineID"; FpSpread_Info.ColumnHeader.Cells[0, 1].Tag = "LineID"; FpSpread_Info.ColumnHeader.Cells[0, 2].Text = "选择"; FpSpread_Info.ColumnHeader.Cells[0, 2].Tag = "SelectTag"; FpSpread_Info.ColumnHeader.Cells[0, 3].Text = "线路名称"; FpSpread_Info.ColumnHeader.Cells[0, 3].Tag = "LineName"; FpSpread_Info.ColumnHeader.Cells[0, 4].Text = "标段名称"; FpSpread_Info.ColumnHeader.Cells[0, 4].Tag = "SegmentName"; FpSpread_Info.ColumnHeader.Cells[0, 5].Text = "单位名称"; FpSpread_Info.ColumnHeader.Cells[0, 5].Tag = "CompanyName"; FpSpread_Info.ColumnHeader.Cells[0, 6].Text = "试验室名称"; FpSpread_Info.ColumnHeader.Cells[0, 6].Tag = "TestRoomName"; FpSpread_Info.ColumnHeader.Cells[0, 7].Text = "用户名"; FpSpread_Info.ColumnHeader.Cells[0, 7].Tag = "UserName"; FpSpread_Info.ColumnHeader.Cells[0, 8].Text = "最后活动时间"; FpSpread_Info.ColumnHeader.Cells[0, 8].Tag = "LastActiveTime"; FpSpread_Info.ColumnHeader.Cells[0, 9].Text = "登录时间"; FpSpread_Info.ColumnHeader.Cells[0, 9].Tag = "LoginTime"; FpSpread_Info.Columns[0].Width = 10; FpSpread_Info.Columns[1].Width = 10; FpSpread_Info.Columns[2].Width = 40; FpSpread_Info.Columns[3].Width = 100; FpSpread_Info.Columns[4].Width = 60; FpSpread_Info.Columns[5].Width = 100; FpSpread_Info.Columns[6].Width = 80; FpSpread_Info.Columns[7].Width = 80; FpSpread_Info.Columns[8].Width = 120; FpSpread_Info.Columns[9].Width = 120; FpSpread_Info.Columns[0].Visible = false; FpSpread_Info.Columns[1].Visible = false; FarPoint.Win.Spread.CellType.DateTimeCellType datetime = new FarPoint.Win.Spread.CellType.DateTimeCellType(); datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.LongDateWithTime; FpSpread_Info.Columns[8].CellType = datetime; FpSpread_Info.Columns[9].CellType = datetime; CheckBoxCellType checkBox = new CheckBoxCellType(); FpSpread_Info.Columns[2].CellType = checkBox; DataOnlineUser = LineHelperClient.GetOnlineUserList(); BindLines(); //BindData(); }
private void bt_uploadGL_All_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.Filter = "压缩文件(*.zip)|*.zip"; dlg.Multiselect = false; if (dlg.ShowDialog() == DialogResult.OK) { if (dlg.FileName != "") { String errorLineName = ""; FileStream stream = null; JZFile f = new JZFile(); f.FileName = Path.GetFileName(dlg.FileName); stream = new FileInfo(dlg.FileName).OpenRead(); Byte[] buffer = new Byte[stream.Length]; stream.Read(buffer, 0, Convert.ToInt32(stream.Length)); f.FileType = "1"; f.FileData = buffer; stream.Close(); DataTable dt = LineHelperClient.GetLineList(); String msg = ""; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Boolean result = UploadHelperClient.UploadFileByLineID(f, dt.Rows[i]["ID"].ToString()); if (!result) { errorLineName += "," + dt.Rows[i]["LineName"].ToString(); } } if (errorLineName != "") { msg = "发布失败,失败线路有" + errorLineName; } else { msg = "全部成功"; } MessageBox.Show(msg); } } } }
private void SpecialUploadDlg_Load(object sender, EventArgs e) { treeView1.Nodes.Clear(); TreeNode TopNode = new TreeNode(); TopNode.Name = ""; TopNode.Text = "模板列表"; TopNode.SelectedImageIndex = 1; TopNode.ImageIndex = 0; treeView1.Nodes.Add(TopNode); DataSet ds = LineHelperClient.GetLineModuleList(); DataTable dt = ds.Tables["dbo.sys_biz_ModuleCatlog"]; DataTable sheetDT = ds.Tables["dbo.sys_module"]; if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { TreeNode node = new TreeNode(); node.Name = row["CatlogCode"].ToString(); node.Text = row["CatlogName"].ToString(); node.SelectedImageIndex = 1; node.ImageIndex = 0; node.Tag = false; TopNode.Nodes.Add(node); DataRow[] sheetRows = sheetDT.Select("CatlogCode like '" + row["CatlogCode"] + "%' ", "Name asc"); if (sheetRows != null && sheetRows.Length > 0) { foreach (DataRow r1 in sheetRows) { TreeNode n = new TreeNode(); n.Name = r1["ID"].ToString(); n.Text = r1["Name"].ToString(); n.SelectedImageIndex = 2; n.ImageIndex = 2; n.Tag = true; node.Nodes.Add(n); } } } } treeView1.ExpandAll(); }
private void ButtonOk_Click(object sender, EventArgs e) { DataTable dt = LineHelperClient.GetLineList(); if (dt != null) { txtResult.Text = string.Format("总共需要{0}条线路需要测试\r\n", dt.Rows.Count) + txtResult.Text; string LineName, IPAddress, Port, errMsg, strFailLines = string.Empty; int i = 1; int iSuccess = 0; int iFail = 0; lblMsg.Text = "开始测试"; foreach (DataRow row in dt.Rows) { LineName = row["LineName"].ToString(); IPAddress = row["IPAddress"].ToString(); Port = row["Port"].ToString(); lblMsg.Text = LineName + "……"; bool bSuccess = TestNetwork(IPAddress, Port, out errMsg); if (bSuccess == true && string.IsNullOrEmpty(errMsg)) { iSuccess++; txtResult.Text = string.Format("{0}、【{1}】连接成功\r\n", i, LineName) + txtResult.Text; } else { iFail++; txtResult.Text = string.Format("{0}、【{1}】连接失败,原因:{2}\r\n", i, LineName, errMsg) + txtResult.Text; strFailLines += LineName + ","; } i++; } lblMsg.Text = "测试结束"; txtResult.Text = string.Format("所有线路测试结束,成功:{0} 失败:{1} 失败线路:{2}\r\n", iSuccess, iFail, strFailLines) + txtResult.Text; } }
private void btnRefresh_Click(object sender, EventArgs e) { chkSelectAll.Checked = false; DataOnlineUser = LineHelperClient.GetOnlineUserList(); BindData(); }
void worker_DoWork(object sender, DoWorkEventArgs e) { Dictionary <Guid, String> lineIDs = new Dictionary <Guid, String>(); List <String> moduleIDs = new List <String>(); string strModuleIDs = string.Empty; Dictionary <Guid, String> dModuleIDs = new Dictionary <Guid, String>(); foreach (TreeNode node in treeLines.Nodes[0].Nodes) { if (node.Checked) { lineIDs.Add(new Guid(node.Name), node.Text); } } foreach (TreeNode node in treeModule.Nodes[0].Nodes) { foreach (TreeNode n in node.Nodes) { if (n.Checked) { moduleIDs.Add(n.Name); strModuleIDs += string.Format("'{0}',", n.Name); dModuleIDs.Add(new Guid(n.Name), n.Text); } } } if (moduleIDs.Count == 0 || lineIDs.Count == 0) { MessageBox.Show("请至少选则一条线路或一个模板!"); return; } strModuleIDs = strModuleIDs.Substring(0, strModuleIDs.Length - 1); string strFMsg = string.Empty; using (DataTable dtForbidLines = ModuleHelperClient.GetForbidLinesByModuleIDs(strModuleIDs, isModule ? 1 : 0)) { foreach (KeyValuePair <Guid, string> pair in lineIDs) { DataRow[] drModuleIDs = dtForbidLines.Select(string.Format("LineID='{0}'", pair.Key)); if (drModuleIDs != null && drModuleIDs.Length > 0) { bool bHasForbidModule = false; for (int j = 0; j < drModuleIDs.Length; j++) { string strFModuleID = drModuleIDs[j]["ModuleID"].ToString(); foreach (string moduleID in moduleIDs) { if (strFModuleID == moduleID) {//禁止发布 bHasForbidModule = true; if (string.IsNullOrEmpty(strFMsg)) { strFMsg = isModule ? "模板" : "表单"; } strFMsg += string.Format("<{0}>", dModuleIDs[new Guid(moduleID)]); } } } if (bHasForbidModule) { strFMsg += string.Format("已经设置不能发布到线路【{0}】", pair.Value); strFMsg += "\n"; } } } } if (!string.IsNullOrEmpty(strFMsg)) { MessageBox.Show(strFMsg); return; } Boolean flag = true; String msg = ""; BackgroundWorker worker = sender as BackgroundWorker; int i = 0; foreach (KeyValuePair <Guid, string> pair in lineIDs) { try { i = i + 1; ProgressScreen.Current.SetStatus = string.Format("正在发布线路:{0}...", pair.Value); worker.ReportProgress((int)(((float)i / (float)lineIDs.Count) * 100)); Boolean subFlag = LineHelperClient.SyncLineAndModule(moduleIDs, new List <Guid>() { pair.Key }, isModule, isRelationSheet); flag = flag & subFlag; if (!subFlag) { msg += "[" + pair.Value + "] "; } } catch { flag = false; } } String str = flag ? "全部更新成功" : "线路" + msg + "更新失败"; MessageBox.Show(str); }