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