/// <summary>
/// 保存到工作区
/// </summary>
/// <param name="checkedNodes">选中的节点</param>
public static bool SaveToWorkspace(List <LineBean> checkedNodes)
{
bool isScud = false;
try
{
foreach (LineBean checkedLb in checkedNodes)
{
DataTable dt = LineObsBll.Instance.GetDataTable("select obvdate,obvvalue from t_obsrvtntb where OBSLINECODE = '" + checkedLb.OBSLINECODE + "'");
NpoiCreator npcreator = new NpoiCreator();
string savefile = Application.StartupPath + "/远程信息库缓存";
npcreator.TemplateFile = savefile;
npcreator.NpoiExcel(dt, checkedLb.OBSLINECODE + ".xls", savefile + "/" + checkedLb.OBSLINECODE + ".xls");
TreeBean tb = new TreeBean();
tb.KeyFieldName = checkedLb.OBSLINECODE;
tb.ParentFieldName = checkedLb.SITECODE;
tb.Caption = checkedLb.OBSLINENAME;
}
isScud = true;
}
catch (Exception ex)
{
isScud = false;
throw new Exception(ex.Message);
}
return(isScud);
}
/// <summary>
/// 获取场地选择状态的数据主键ID集合 lwl
/// </summary>
/// <param name="parentNode">父级节点</param>
private void GetSiteCheckedNode(TreeListNode parentNode, ref List <SiteBean> lblist)
{
if (parentNode.Nodes.Count == 0)
{
return;//递归终止
}
foreach (TreeListNode node in parentNode.Nodes)
{
if (node.CheckState == CheckState.Checked)
{
TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean;
LineBean lb = nodeInfo.Tag as LineBean;
if (lb == null)
{
SiteBean tag = SiteBll.Instance.GetWhere(new { SITECODE = nodeInfo.Tag.ToString() }).ToList()[0];
if (tag != null)
{
lblist.Add(tag);
}
}
}
GetSiteCheckedNode(node, ref lblist);
}
}
/// <summary>
/// 刷新
/// </summary>
public void RefreshWorkspace(bool isnewlinename)
{
try
{
List <TreeBean> treebData = null;
TreeList treelist = this.treeListData;
// treelist.Cursor = Cursors.WaitCursor;
treebData = treelist.DataSource as List <TreeBean>;
List <String> excelList = new List <string>();
excelList = getFile(SystemInfo.DatabaseCache);
foreach (string lineCode in excelList)
{
try
{
string subLineCode = lineCode.Substring(0, lineCode.Length - 4);
TreeBean tb = new TreeBean();
tb.KeyFieldName = subLineCode;
string obslinename = isnewlinename ? "OBSLINENAME" : "NAMEBEFORE";
tb.Caption = LineBll.Instance.GetNameByID(obslinename, "OBSLINECODE", subLineCode);
string sitecode = LineBll.Instance.GetNameByID("SITECODE", "OBSLINECODE", subLineCode);
if (string.IsNullOrEmpty(sitecode))
{
continue;
}
tb.ParentFieldName = sitecode;
tb.Tag = LineBll.Instance.GetInfoByID(subLineCode);
if (treebData.Find(n => n.KeyFieldName == subLineCode) == null)
{
treebData.Add(tb);
}
}
catch
{
continue;
}
}
treelist.RefreshDataSource();
treelist.Cursor = Cursors.Arrow;
}
catch { }
}
private List <TreeBean> GetCheckedNode()
{
List <TreeBean> tblist = new List <TreeBean>();
foreach (TreeListNode node in this.treeListData.Nodes)
{
if (node.CheckState == CheckState.Checked)
{
TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean;
tblist.Add(nodeInfo);
}
}
return(tblist);
}
/// <summary>
/// 刷新场地节点
/// </summary>
/// <param name="sitecode">场地编码</param>
public void RefreshSiteNode(string sitecode)
{
SiteBean sb = SiteBll.Instance.GetWhere(new { SiteCode = sitecode }).ToList()[0];
List <TreeBean> treeData = this.treeListData.DataSource as List <TreeBean>;
TreeBean tb = treeData.Find(n => n.KeyFieldName == sitecode);
tb.KeyFieldName = sitecode;
tb.ParentFieldName = sb.UnitCode;
tb.Caption = sb.SiteName;
tb.SiteType = sb.SiteType;
tb.Tag = sb.SiteCode;
//treeData.Add(tb);
treeListData.RefreshDataSource();
}
private void GetSiteNodesRec(TreeListNode parentNode, string keyfieldname, ref List <TreeListNode> lblist)
{
if (parentNode.Nodes.Count == 0)
{
return;//递归终止
}
foreach (TreeListNode node in parentNode.Nodes)
{
TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean;
if (nodeInfo.KeyFieldName == keyfieldname)
{
lblist.Add(node);
}
GetSiteNodesRec(node, keyfieldname, ref lblist);
}
}
/// <summary>
/// 获取测线选择状态的数据主键ID集合 lwl
/// </summary>
/// <param name="parentNode">父级节点</param>
private void GetCheckedNode(TreeListNode parentNode, ref List <LineBean> lblist)
{
if (parentNode.Nodes.Count == 0)
{
return;//递归终止
}
foreach (TreeListNode node in parentNode.Nodes)
{
if (node.CheckState == CheckState.Checked)
{
TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean;
LineBean tag = nodeInfo.Tag as LineBean;
if (tag != null)
{
lblist.Add(tag);
}
}
GetCheckedNode(node, ref lblist);
}
}
/// <summary>
/// 初始化测项树列表
/// </summary>
private void InitTree()
{
List <String> remoteExcelList = new List <string>();
remoteExcelList = getFile(SystemInfo.DatabaseCache);
List <TreeBean> tblist = new List <TreeBean>();
foreach (string remoteLineCode in remoteExcelList)
{
try
{
string subLineCode = remoteLineCode.Substring(0, remoteLineCode.Length - 4);
LineBean ol = LineBll.Instance.GetInfoByID(subLineCode);
TreeBean tb = new TreeBean();
tb.KeyFieldName = ol.OBSLINECODE;
tb.ParentFieldName = ol.SITECODE;
tb.Caption = ol.OBSLINENAME;
tb.Tag = ol;//lwl
tblist.Add(tb);
}
catch (Exception ex)
{
continue;
}
}
this.treeListData.ClearNodes();
this.treeListData.DataSource = tblist;
//树列表显示
this.treeListData.KeyFieldName = "KeyFieldName"; //这里绑定的ID的值必须是独一无二的
this.treeListData.ParentFieldName = "ParentFieldName"; //表示使用parentID进行树形绑定
this.treeListData.OptionsView.ShowCheckBoxes = true;
this.treeListData.OptionsBehavior.AllowRecursiveNodeChecking = true;
this.treeListData.OptionsBehavior.Editable = false;
this.treeListData.ExpandAll();
}
/// <summary>
/// 加载远程库树列表
/// </summary>
/// <param name="gmmkks">GMAP控件</param>
public void bSignDbTree()
{
try
{
this.treeListData.ClearNodes();
this.treeListData.DataSource = null;
List <TreeBean> treeData = new List <TreeBean>();
DataTable ubEnumt = UnitInfoBll.Instance.GetDataTable("select UNITNAME,UNITCODE from t_unittb where HASSITES=1");
foreach (DataRow dr in ubEnumt.Rows)
{
TreeBean tb = new TreeBean();
tb.TreeName = treeListData.Name;
tb.KeyFieldName = dr["UNITCODE"].ToString();
tb.ParentFieldName = "0";
tb.Caption = dr["UNITNAME"].ToString();
tb.SiteType = "";
tb.LineStatus = "";
tb.Tag = new UnitInfoBean {
UnitName = dr["UNITNAME"].ToString(), UnitCode = dr["UNITCODE"].ToString(), HASSITES = 1
}; //lwl
treeData.Add(tb);
}
List <SiteBean> sbEnumt = new List <SiteBean>();
DataTable sitedt = SiteBll.Instance.GetDataTable(@"select sitecode, unitcode,sitename from t_siteinfodb");
foreach (DataRow sitedr in sitedt.Rows)
{
SiteBean sgsb = new SiteBean();
sgsb.SiteCode = sitedr["sitecode"].ToString();
sgsb.SiteName = sitedr["sitename"].ToString();
sgsb.UnitCode = sitedr["unitcode"].ToString();
sbEnumt.Add(sgsb);
}
//场地列表显示
List <string> olSiteCode = new List <string>();
foreach (SiteBean sb in sbEnumt)
{
olSiteCode.Add(sb.SiteCode);
TreeBean tb = new TreeBean();
tb.KeyFieldName = sb.SiteCode;
tb.ParentFieldName = sb.UnitCode;
tb.Caption = sb.SiteName;
tb.SiteType = sb.SiteType;
tb.Tag = sb.SiteCode;//lwl
treeData.Add(tb);
}
//树列表显示
this.treeListData.KeyFieldName = "KeyFieldName"; //这里绑定的ID的值必须是独一无二的
this.treeListData.ParentFieldName = "ParentFieldName"; //表示使用parentID进行树形绑定
this.treeListData.DataSource = treeData; //绑定数据源
this.treeListData.OptionsView.ShowCheckBoxes = true;
this.treeListData.OptionsBehavior.AllowRecursiveNodeChecking = true;
this.treeListData.OptionsBehavior.Editable = false;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, "错误");
}
}
/// <summary>
/// 加载测项合并数列表
/// </summary>
/// <returns></returns>
public List <TreeBean> ObslineMergeTree()
{
List <TreeBean> tblist = new List <TreeBean>();
try
{
IEnumerable <UnitInfoBean> ubEnumt = UnitInfoBll.Instance.GetAll();
foreach (UnitInfoBean sb in ubEnumt)
{
TreeBean tb = new TreeBean();
if (sb.UnitCode == "152002" || sb.UnitCode == "152003" ||
sb.UnitCode == "152006" || sb.UnitCode == "152008" ||
sb.UnitCode == "152009" || sb.UnitCode == "152010" ||
sb.UnitCode == "152012" || sb.UnitCode == "152015" ||
sb.UnitCode == "152022" || sb.UnitCode == "152023" ||
sb.UnitCode == "152026" || sb.UnitCode == "152029" ||
sb.UnitCode == "152032" || sb.UnitCode == "152034" ||
sb.UnitCode == "152035" || sb.UnitCode == "152036" ||
sb.UnitCode == "152039" || sb.UnitCode == "152040" ||
sb.UnitCode == "152041" || sb.UnitCode == "152042" ||
sb.UnitCode == "152043" || sb.UnitCode == "152044" ||
sb.UnitCode == "152045" || sb.UnitCode == "152046" ||
sb.UnitCode == "152001" || sb.UnitCode == "152047")
{
continue;
}
tb.KeyFieldName = sb.UnitCode;
tb.ParentFieldName = "0";
tb.Caption = sb.UnitName;
tb.SiteType = "";
tb.LineStatus = "";
tb.Tag = sb;//lwl
tblist.Add(tb);
}
List <SiteBean> sbEnumt = new List <SiteBean>();
DataTable dt = SiteBll.Instance.GetDataTable(@"select sitecode, unitcode,sitename from t_siteinfodb");
foreach (DataRow dr in dt.Rows)
{
SiteBean sgsb = new SiteBean();
sgsb.SiteCode = dr["sitecode"].ToString();
sgsb.SiteName = dr["sitename"].ToString();
sgsb.UnitCode = dr["unitcode"].ToString();
sbEnumt.Add(sgsb);
}
//场地列表显示
List <string> olSiteCode = new List <string>();
foreach (SiteBean sb in sbEnumt)
{
olSiteCode.Add(sb.SiteCode);
TreeBean tb = new TreeBean();
tb.KeyFieldName = sb.SiteCode;
tb.ParentFieldName = sb.UnitCode;
tb.Caption = sb.SiteName;
tb.SiteType = sb.SiteCode.Substring(0, 1) == "L" ? "流动" : "定点";
tb.Tag = sb.SiteCode;//lwl
tblist.Add(tb);
}
List <String> remoteExcelList = new List <string>();
remoteExcelList = getFile(SystemInfo.DatabaseCache);
foreach (string remoteLineCode in remoteExcelList)
{
string subLineCode = remoteLineCode.Substring(0, remoteLineCode.Length - 4);
LineBean ol = LineBll.Instance.GetInfoByID(subLineCode);
if (olSiteCode.Contains(ol.SITECODE))
{
TreeBean tb = new TreeBean();
tb.KeyFieldName = ol.OBSLINECODE;
tb.ParentFieldName = ol.SITECODE;
tb.Caption = ol.OBSLINENAME;
tb.Tag = ol;//lwl
tblist.Add(tb);
}
}
}
catch
{
//throw new Exception(ex.Message);
}
return(tblist);
}
