XXXX系统V1.0
源代码
XXXX系统V1.0 1
using System;
using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web;
using System.Web.Security; using System.Web.UI;
using System.Web.UI.HtmlControls; using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using Empiresoft.Data.DB;
using DevExpress.Web.ASPxTreeList; using System.Collections.Generic; namespace JNJGPT.DNCJJG {
public partial class AddFCJDB : System.Web.UI.Page {
#region 页面加载
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
if (Request.QueryString[\ {
ViewState[\ ViewState[\ }
DateTime _dtNow = GG.PubCommonMethod.GetNow(); if (Convert.ToInt16(ViewState[\Convert.ToInt16(ViewState[\ {
ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.CurrentHandler, typeof(System.Web.UI.Page),
\为了保证数据准确性，请不要提前新增电表!');window.opener=null;window.close();\ return; }
ViewState[\
if (((DataTable)ViewState[\ {
XXXX系统V1.0 3
InitTreeList();
GG.PubCommonControl.BASPxTreeList(this.ASPxTreeList1, (DataTable)ViewState[\ } else {
this.lblTitle.Text = \当前没有非数据采集电表，请先转到系统管理—>电表管理 添加！\\n 状态为无效的电表是非采集电表\
lblTitle.ForeColor = System.Drawing.Color.Red; return; } }
else GG.PubCommonControl.BASPxTreeList(this.ASPxTreeList1, (DataTable)ViewState[\ }
#endregion
#region 初始化树形结构 private void InitTreeList() {
this.ASPxTreeList1.Columns.Clear();
//this.ASPxTreeList1.Settings.ShowColumnHeaders = false; //建筑名称
GG.PubCommonControl.AddTreeListDataColumn(ASPxTreeList1, \1, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, true);
GG.PubCommonControl.AddTreeListDataColumn(ASPxTreeList1, \1, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, false); }
#endregion
#region 控制有非电表节点不加选择框
protected void treeList_DataBound(object sender, EventArgs e) {
TreeListNodeIterator iterator = ASPxTreeList1.CreateNodeIterator(); TreeListNode node; while (true) {
node = iterator.GetNext(); if (node == null) break;
node.AllowSelect = !node.HasChildren; } }
#endregion
#region 构建 建筑+非采集电表数据 private DataTable GetJZDB() {
DataTable dtTreeData = null; string strSqlJZ = string.Empty; string strSqlDB = string.Empty; DataTable dtJZ = null; DataTable dtDB = null;
strSqlJZ = \SJBH,JZMC,JZLX,JZBM \
XXXX系统V1.0 4
\ strSqlDB = @\
'J'+convert(varchar,b.JZBH) SJBH,DBMC JZMC,null JZLX,a.JZBM from \
\and a.ZT=4\
dtJZ = DbOpt.Execute_Query(strSqlJZ); dtDB = DbOpt.Execute_Query(strSqlDB); for (int i = dtJZ.Rows.Count - 1; i >= 0; i--) {
string strJZBM = dtJZ.Rows[i][\
DataRow[] dra = dtDB.Select(\strJZBM + \
if (dra == null || dra.Length == 0) {
dtJZ.Rows.RemoveAt(i); } }
dtTreeData = dtJZ.Copy();
for (int i = 0; i < dtDB.Rows.Count; i++) {
dtTreeData.Rows.Add(dtDB.Rows[i].ItemArray); }
return dtTreeData; }
#endregion
#region 将选中电表插入数据补录表
protected void btnSubmit_Click(object sender, EventArgs e) {
if (ASPxTreeList1.GetSelectedNodes().Count <= 0) return; DataTable SJdt = DbOpt.Execute_Query(\
s.BBH,s.nd,s.yd,s.cdl,s.mdl,s.ydl,s.ydje,d.bmbm,d.jzbm,d.ydlx,d.ydxz,d.jsdl,s.cbr,s.cbsj \ \d.bbh=s.bbh\
DataTable DBdt = DbOpt.Execute_Query(\from dncjjg..b_dbxx where zt = 4\
foreach (TreeListNode item in ASPxTreeList1.GetSelectedNodes()) {
ViewState[\
if (BoolQx(ViewState[\ {
DataRow dr = SJdt.NewRow();
dr[\ dr[\ dr[\
object a = DbOpt.ExecuteScalar(\DNCJJG..B_SJ_BL where BBH=\ if (a.ToString() !=\ dr[\ else dr[\
dr[\ViewState[\
dr[\ViewState[\