clsasswconfiggui.cs

GPRS数据采集驱动源码

using System;
using System.Windows.Forms;
using System.Data;

using CommCLB.Comm;
using CommCLB.asswconf_ws;

namespace GPRSDrvWinApp.gprs
{
	/// <summary>
	/// clsAsswConfigGUI 的摘要说明。
	/// </summary>
	public class clsAsswConfigGUI
	{
		public clsAsswConfigGUI()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}



		//根据序号选择datagrid当前行 -999表示没找到
		public static int SetDataGridRowBySeq(DataGrid dgd ,int iseq)
		{
			DataTable dt=(DataTable)dgd.Tag;
			int i=0;
			bool found=false;
			foreach(DataRow dr in dt.Rows)
			{
				int seq=Convert.ToInt32(dr["fd_seq"]);
				if (seq==iseq)
				{
					found=true;
					break;
				}
				i++;
			}
			if (!found)
				return -999;
			if (dgd.CurrentRowIndex>=0)
				dgd.UnSelect(dgd.CurrentRowIndex);
			dgd.CurrentRowIndex=i;
			dgd.Select(i);
			
			return i;
		}


		/// <summary>
		/// 通过序号查询到上次选择的树记录,递归调用
		/// </summary>
		private static bool bl_fndNode=false;
		public static void SetTVCurrentNodeBySeq(TreeView tv,int iseq)
		{
			bl_fndNode=false; 
			SetTVCurrentNodeBySeqSub(tv.Nodes,iseq,tv);
			if (!bl_fndNode && tv.Nodes.Count>0)
			{
				tv.SelectedNode=tv.Nodes[0];
			}
			bl_fndNode=false;
		}
		public static void SetTVCurrentNodeBySeqSub(TreeNodeCollection nds,int iseq,TreeView tv)
		{
			if (bl_fndNode)
				return;
			int i;
			for(i=0;i<nds.Count;++i)
			{
				DataRow dr=(DataRow)nds[i].Tag;
				if (Convert.ToInt32(dr["fd_seq"])==iseq)
				{
					bl_fndNode=true;
					tv.SelectedNode=nds[i];					
					return;
				}
				SetTVCurrentNodeBySeqSub(nds[i].Nodes,iseq,tv);
			}
			
		}


		/// <summary>
		/// 填充时段和季节cb
		/// </summary>
		/// <param name="cb"></param>
		public static void FillTimeCb(ComboBox cbt,ComboBox cbs)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetSTType();
			DataTable dt=ds.Tables["ttablet"];
			if (dt==null)
				return;
			cbt.DataSource=dt;			
			cbt.DisplayMember="FD_TID";

			DataTable ds1=ds.Tables["ttables"];
			if (ds1==null)
				return;
			cbs.DataSource=ds1;			
			cbs.DisplayMember="FD_SID";

			return;
		}


		/// <summary>
		/// 高亮度显示TreeView第一个节点
		/// </summary>
		/// <param name="tv"></param>
		public static void HightLightTV(TreeView tv)
		{
			if (tv.Nodes.Count>0)
				tv.SelectedNode=tv.Nodes[0];
		}

		/// <summary>
		/// 取得管网列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwNetWork(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwNetWork();			
			DataTable dt=ds.Tables["tb_nwnetwork"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);

		}

		/// <summary>
		///  取得事故类型列表
		/// </summary>
		/// <param name="tv"></param>
		public static void SetEmergcyType(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllEmergcyType();
			DataTable dt=ds.Tables["ttable"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);

		}

		/// <summary>
		/// 取得行政区划列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwAdmArea(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwAdmArea();			
			DataTable dt=ds.Tables["tb_nwadmarea"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}
		/// <summary>
		/// 取得监控类别列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwMonType(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwMonType();			
			DataTable dt=ds.Tables["tb_nwmontype"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}


		/// <summary>
		/// 取得报警配置表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwAlarmCfg(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwAlarmCfg();			
			DataTable dt=ds.Tables["tb_nwalarmcfg"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}

		/// <summary>
		/// 取得监测点监控组表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwMntGroup(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwMntGroup();			
			DataTable dt=ds.Tables["tb_nwMntGroup"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}


		/// <summary>
		/// 取得检测指标类型列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwTgtType(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwTgtType();			
			DataTable dt=ds.Tables["tb_nwtgttype"];
			if (dt==null)
				return;
			tv.Nodes.Clear();
			
			SetTVnwTgtTypeSub(tv.Nodes,dt,"TOP");
			tv.ExpandAll();
			HightLightTV(tv);
			return;
		
		}		
		private static void SetTVnwTgtTypeSub(TreeNodeCollection nds,DataTable dt,string parentid)
		{
			DataRow[] dra=dt.Select("fd_parentno='"+parentid+"'");
			string title="";
			foreach(DataRow dr in dra)
			{
				
				if (Convert.ToInt32(dr["fd_tag"])==1)
					title="*";
				else
					title="";
				TreeNode tn=new TreeNode(title+"["+dr["fd_id"].ToString()+"]"+dr["fd_name"].ToString());
				tn.Tag=dr;
				nds.Add(tn);
				SetTVnwTgtTypeSub(tn.Nodes,dt,dr["fd_id"].ToString());
			}			
		}

		
		/// <summary>
		/// 取得检测指标类型列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwMntSpt(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwMntSpt();			
			DataTable dt=ds.Tables["tb_nwMntSpt"];
			if (dt==null)
				return;
			SetTVnwMntSptData(tv,dt);
		}
		public static void SetTVnwMntSptData(TreeView tv,DataTable dt)
		{
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				string title;
				if (Convert.ToInt32(dr["fd_usestate"])==1)
					title="*";
				else
					title="";
				TreeNode tn=new TreeNode(title+dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}
		
		
		/// <summary>
		/// 填充管网名称选择条；
		/// </summary>
		/// <param name="cb"></param>
		public static DataTable FillNwSeqCb(ComboBox cb)
		{
			cb.Items.Clear();
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwNetWork();	
			DataTable dt=ds.Tables["tb_nwNetWork"];
			if (dt==null)
				return null;

			cb.DataSource=dt;
			cb.ValueMember="FD_SEQ";
			cb.DisplayMember="FD_NAME";
			
			return dt;

		}
		/// <summary>
		/// 填充行政区域名称选择条；
		/// </summary>
		/// <param name="cb"></param>
		public static DataTable FillAdmAreaCb(ComboBox cb)
		{
			cb.Items.Clear();
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwAdmArea();			
			DataTable dt=ds.Tables["tb_nwAdmArea"];
			if (dt==null)
				return null;
			
			cb.DataSource=dt;
			cb.ValueMember="FD_SEQ";
			cb.DisplayMember="FD_NAME";
			
			return dt;


		}
		/// <summary>
		/// 填充监测点类别名称选择条；
		/// </summary>
		/// <param name="cb"></param>
		public static DataTable FillMonTypeCb(ComboBox cb)
		{
			cb.Items.Clear();
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwMonType();
			DataTable dt=ds.Tables["tb_nwmontype"];
			if (dt==null)
				return null;
			cb.DataSource=dt;
			cb.ValueMember="FD_SEQ";
			cb.DisplayMember="FD_NAME";
			
			
			return dt;


		}

		
		/// <summary>
		/// 取得检测指标类型列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwMntSptRtu(TreeView tv,int mntsptseq)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetRTUByMntSptSeq(mntsptseq);
			DataTable dt=ds.Tables["tb_nwMntSptRtu"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode("[设备号："+dr["fd_id"].ToString()+"]"+dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}

		



		/// <summary>
		/// 取得检测指标类型列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwDrvSvc(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwDrvSvc();			
			DataTable dt=ds.Tables["tb_nwdrvsvc"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}

		/// <summary>
		/// 取得某检测组下所有人员列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwMntGrpEmp(TreeView tv,int iseq)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetNwMntGrpEmpByGrpSeq(iseq);			
			DataTable dt=ds.Tables["tb_nwmntgrpemp"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_empname"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}

		/// <summary>
		/// 取得某检测组下所有人员列表数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwMntGrpUnSelectedEmp(TreeView tv,int iseq,string dno)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetnwUnSelectedMntGrpEmp(dno,iseq);
			DataTable dt=ds.Tables["tb_nwmntgrpemp"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_empname"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);
		}

		/// <summary>
		/// 填充驱动层名称选择条；
		/// </summary>
		/// <param name="cb"></param>
		public static DataTable FillDrvSvcCb(ComboBox cb)
		{
			cb.Items.Clear();
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwDrvSvc();			
			DataTable dt=ds.Tables["tb_nwDrvSvc"];
			if (dt==null)
				return null;
			cb.DataSource=dt;
			cb.ValueMember="FD_SEQ";
			cb.DisplayMember="FD_NAME";
			return dt;

		}
		/// <summary>
		/// 填充RTU名称选择条；
		/// </summary>
		/// <param name="cb"></param>
		public static DataTable FillRtuCb(ComboBox cb,int iseq)
		{
			cb.Items.Clear();
			DataSet ds=Class_Comm.GetServiceAsswConf().GetRTUByMntSptSeq(iseq);
			DataTable dt=ds.Tables["tb_nwMntSptRtu"];
			if (dt==null)
				return null;
			cb.DataSource=dt;
			cb.ValueMember="FD_SEQ";
			cb.DisplayMember="FD_ID";
			return dt;

		}

		/// <summary>
		/// 取得部门树
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwDepartment(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceSys().GetAllDepartment();
			DataTable dt=ds.Tables["ts_department"];


			AddTVDepartment(tv.Nodes,dt,"TOP");
			tv.ExpandAll();
			HightLightTV(tv);
		}
		//递归调用取得部门树
		private static void AddTVDepartment(TreeNodeCollection nds,DataTable dt,string parentno)
		{
			DataRow[] drs=dt.Select("fd_parentdeptno='"+parentno+"'");
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_deptname"].ToString());
				tn.Tag=dr;
				nds.Add(tn);
				AddTVDepartment(tn.Nodes,dt,dr["fd_deptno"].ToString());
				
			}
		}

		/// <summary>
		/// 取得标志配置数据并填充treeview
		/// </summary>
		/// <param name="tv"></param>
		public static void SetTVnwMarkCfg(TreeView tv)
		{
			DataSet ds=Class_Comm.GetServiceAsswConf().GetAllNwMarkCfg();			
			DataTable dt=ds.Tables["tb_nwmarkcfg"];
			if (dt==null)
				return;
			tv.Nodes.Clear();

			DataRowCollection drs=dt.Rows;
			foreach(DataRow dr in drs)
			{
				TreeNode tn=new TreeNode(dr["fd_name"].ToString());
				tn.Tag=dr;
				tv.Nodes.Add(tn);
			}
			HightLightTV(tv);

		}

	}
}