3源代码-XX系统V1[1].0

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[\

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库3源代码-XX系统V1[1].0在线全文阅读。