XXXX系统V1.0 10
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 DevExpress.Web.ASPxGridView; using System.Text;
using System.Text.RegularExpressions; using JNJGPT.GG;
using System.Data.SqlClient; using System.Drawing;
using DevExpress.Web.ASPxGridView.Export; using System.Collections.Generic; using DevExpress.Web.ASPxEditors; namespace JNJGPT.DNCJJG {
public partial class B_DBGL : GG.Form.Form3 {
#region 页面加载
protected new void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
//根据分辨率设置ASPxSplitter的高度
GG.PubCommonWebHelper.SetASPxH(ASPxSplitter1, 444); //加载网关树 如果建筑下没网关 树不显示 InitTreeList();
//获取 TreeList 数据 ViewState[\
GG.PubCommonWebHelper.GetJZWG(\ //根据分辨率设置GridView的高度
GG.PubCommonWebHelper.SetGridViewH(ASPxGridView1, 344); //初始 Gridview 结构 DBInfoGridview(); }
//绑定 TreeList 数据
GG.PubCommonControl.BASPxTreeList(this.ASPxTreeList1, (DataTable)ViewState[\ //设置 TreeList 图标
ASPxTreeList1.Templates.DataCell = new WHTreeLable(1);
if (Session[\ {
XXXX系统V1.0 11
InitBase();
_dt = (DataTable)Session[\
GG.PubCommonControl.BASPxGridView(ASPxGridView1, _dt, \ } else {
InitBase();
this.OpenDataTable(\
GG.PubCommonControl.BASPxGridView(ASPxGridView1, _dt, \ } }
#endregion
#region 初始Sql语句
protected override void InitBase() {
strSql = \ }
#endregion
#region 初始化区域树形结构 private void InitTreeList() {
this.ASPxTreeList1.Columns.Clear();
this.ASPxTreeList1.Settings.ShowColumnHeaders = false; //建筑名称
GG.PubCommonControl.AddTreeListDataColumn(ASPxTreeList1, \建筑名称\
HorizontalAlign.Center, HorizontalAlign.Left, true);
GG.PubCommonControl.AddTreeListDataColumn(ASPxTreeList1, \建筑编码\
HorizontalAlign.Center, HorizontalAlign.Left, false); }
#endregion
#region 初始化电表信息数据 private void DBInfoGridview() {
#region 动态列 //电表编号
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \编 号\ HorizontalAlign.Center, HorizontalAlign.Left, 0, true); //电表名称
GridViewDataColumn dbmc =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \电表名称\
HorizontalAlign.Center, HorizontalAlign.Left, 0, true); dbmc.EditFormSettings.VisibleIndex = 0; //所属网关
GridViewDataComboBoxColumn WGMC =
GG.PubCommonControl.AddComboColumn2GridView(ASPxGridView1, \
DbOpt.Execute_Query(\\所属网关\ WGMC.Visible = false;
WGMC.EditFormSettings.VisibleIndex = 9;
XXXX系统V1.0 12
//多费率
GridViewDataCheckColumn DFL =
GG.PubCommonControl.AddCheckColumn2GridView(ASPxGridView1, \多费率\DevExpress.Web.ASPxClasses.DefaultBoolean.True); DFL.EditFormSettings.VisibleIndex = 2;
DFL.PropertiesCheckEdit.ValueUncheckedString = \ //电表生产厂家
GridViewDataColumn SCCJ =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \生产厂家\11, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); SCCJ.EditFormSettings.VisibleIndex = 18; //倍率
GridViewDataColumn BL =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \倍 率\8, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, true); BL.EditFormSettings.VisibleIndex = 8; //电表型号
GridViewDataColumn dbxh =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \电表型号\5, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); dbxh.EditFormSettings.VisibleIndex = 21; //用电类型
GridViewDataComboBoxColumn YDLX =
GG.PubCommonControl.AddComboColumn2GridView(this.ASPxGridView1, \用电类型\ YDLX.EditFormSettings.VisibleIndex = 7; //平电价
GridViewDataColumn pdj =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \平 电 价\7, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); pdj.EditFormSettings.VisibleIndex = 11; //用电性质
GridViewDataComboBoxColumn YDXZ =
GG.PubCommonControl.AddComboColumn2GridView(this.ASPxGridView1, \用电性质\ YDXZ.EditFormSettings.VisibleIndex = 10; //尖电价
GridViewDataColumn jdj =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \尖 电 价\10, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); jdj.EditFormSettings.VisibleIndex = 14; //电表地址
GridViewDataColumn dbdz =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \安装地址\
HorizontalAlign.Center, HorizontalAlign.Left, 0, true); dbdz.EditFormSettings.VisibleIndex = 15; //初始电量
XXXX系统V1.0 13
GridViewDataColumn csdl =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \初始电量\
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); csdl.EditFormSettings.VisibleIndex = 19; //峰电价
GridViewDataColumn fdj =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \峰 电 价\13, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); fdj.EditFormSettings.VisibleIndex = 17; //电表编号路径
GridViewDataColumn BBHLJ =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \电表编号路径\ HorizontalAlign.Center, HorizontalAlign.Left, 0, false); ////建筑编码
//GridViewDataColumn JZBM =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \建筑编码\
// HorizontalAlign.Center, HorizontalAlign.Left, 0, false); //用电人数
GridViewDataColumn YDRS =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \用电人数\
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); YDRS.EditFormSettings.VisibleIndex = 16; //谷电价
GridViewDataColumn gdj =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \谷 电 价\16, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); gdj.EditFormSettings.VisibleIndex = 20; //电表通讯地址
GridViewDataColumn TXDZ =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \电表通讯地址\ HorizontalAlign.Center, HorizontalAlign.Left, 0, false); TXDZ.EditFormSettings.VisibleIndex = 12; //固定电话
GridViewDataColumn dh =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \固定电话\18, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); dh.EditFormSettings.VisibleIndex = 28; //异常控制
GridViewDataComboBoxColumn YCKZ =
GG.PubCommonControl.AddComboColumn2GridView(this.ASPxGridView1, \异常控制\
YCKZ.CellStyle.HorizontalAlign = HorizontalAlign.Center; YCKZ.EditFormSettings.VisibleIndex = 23; //负责人
GridViewDataColumn fzr =
XXXX系统V1.0 14
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \负 责 人\20, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); fzr.EditFormSettings.VisibleIndex = 22; //手机
GridViewDataColumn sj =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \手机号码\21, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); sj.EditFormSettings.VisibleIndex = 25; //异常预警电量
GridViewDataColumn yjdl =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \异常预警电量\
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); yjdl.EditFormSettings.VisibleIndex = 26; //状态
GridViewDataComboBoxColumn ZT =
GG.PubCommonControl.AddComboColumn2GridView(this.ASPxGridView1, \电表状态\
ZT.CellStyle.HorizontalAlign = HorizontalAlign.Center; ZT.EditFormSettings.VisibleIndex = 13; //备注
GridViewDataColumn bz =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \备 注\24, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); bz.EditFormSettings.VisibleIndex = 30; bz.EditFormSettings.ColumnSpan = 2; //计算电量
GridViewDataCheckColumn JSDL =
GG.PubCommonControl.AddCheckColumn2GridView(ASPxGridView1, \计算电量\27, DevExpress.Web.ASPxClasses.DefaultBoolean.True); JSDL.Visible = false;
JSDL.EditFormSettings.VisibleIndex = 5; //电表全称
GridViewDataColumn dbqc =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \电表全称\
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); dbqc.EditFormSettings.VisibleIndex = 29; dbqc.EditFormSettings.ColumnSpan = 2; //电表序号
GridViewDataColumn BXH =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \电表序号\28, DevExpress.Web.ASPxClasses.DefaultBoolean.True,
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); BXH.EditFormSettings.VisibleIndex = 3; //换表末电量
GridViewDataColumn HBMDL =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \换表末电量\
HorizontalAlign.Center, HorizontalAlign.Left, 0, false);
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,免费范文网,提供经典小说综合文库3源代码-XX系统V1[1].0(3)在线全文阅读。
相关推荐: