XXXX系统V1.0 25
if (e.NewValues[\
Encoding.Default.GetByteCount(e.NewValues[\ {
AddError(e.Errors, ASPxGridView1.Columns[\生产厂家内容过长!应为50个字符以内。\ }
if (e.NewValues[\
Encoding.Default.GetByteCount(e.NewValues[\ {
AddError(e.Errors, ASPxGridView1.Columns[\电表型号内容过长!应为20个字符以内。\ }
if (YCKZ == 1 && e.NewValues[\ {
AddError(e.Errors, ASPxGridView1.Columns[\在异常控制模式下异常预警电量必须填写且只能为数字!\ }
if (e.NewValues[\
Encoding.Default.GetByteCount(e.NewValues[\ {
AddError(e.Errors, ASPxGridView1.Columns[\备注内容过长!应为200个字符以内。\ }
if (e.NewValues[\
Encoding.Default.GetByteCount(e.NewValues[\ {
AddError(e.Errors, ASPxGridView1.Columns[\电表全称内容过长!应为200个字符以内。\ }
if (e.NewValues[\
Encoding.Default.GetByteCount(e.NewValues[\ {
AddError(e.Errors, ASPxGridView1.Columns[\电表序号内容过长!应为20个字符以内。\ }
if (e.NewValues[\ {
AddError(e.Errors, ASPxGridView1.Columns[\换表时 电表倍率必须填写！\ }
if (string.IsNullOrEmpty(e.RowError) && e.Errors.Count > 0) e.RowError = \请正确填写数据!\ }
private void AddError(Dictionary
if (errors.ContainsKey(column)) return; errors[column] = errorText; }
#endregion
#region 刷新表编号路径(纠错)
protected void ASPxCallback1_Callback(object sender, EventArgs e) {
XXXX系统V1.0 26
GG.PubCommonData.BuildDNCJJG_DBLJ_ALL(DataQuery.QueryDataType.DNCJJG); }
#endregion #region 查询
protected void btnChaXun_Click(object sender, EventArgs e) {
InitBase();
if (txtBBH.Text.Trim() != \
OpenDataTable(string.Format(\ else if (txtBBH.Text.Trim() == \ OpenDataTable(string.Format(\txtTXDZ.Text.Trim()));
else if (txtBBH.Text.Trim() != \
OpenDataTable(string.Format(\txtBBH.Text.Trim(), txtTXDZ.Text.Trim())); else {
if (_dt != null)
_dt.Rows.Clear();
GG.PubCommonControl.BASPxGridView(ASPxGridView1, _dt, \ return; }
Session[\ //绑定 Gridview 数据
GG.PubCommonControl.BASPxGridView(ASPxGridView1, _dt, \ if (_dt.Rows.Count > 0) {
txtBBH.Text = txtTXDZ.Text = \ } }
#endregion
#region ASPxTreeList选中事件
protected void ASPxTreeList1_FocusedNodeChanged(object sender, EventArgs e) {
if (ASPxTreeList1.FocusedNode != null) {
TreeListNode node = this.ASPxTreeList1.FocusedNode; string key = node.Key.ToString(); string str = key.Substring(0, 1);
if (str == \选中的是网关 绑定数据 {
ViewState[\ InitBase();
this.OpenDataTable(\ Session[\ //绑定 Gridview 数据
GG.PubCommonControl.BASPxGridView(ASPxGridView1, _dt, \
} else {
XXXX系统V1.0 27
if (_dt != null)
_dt.Rows.Clear();
GG.PubCommonControl.BASPxGridView(ASPxGridView1, _dt, \
} } }
#endregion
#region 重写更新函数UpdateData protected override int UpdateData() {
int row2 = 0;
if (_dt != null && strSql.Length > 0) {
row2 = DbOpt.Update(_dt, strSql); Session[\ }
return row2; }
#endregion
#region 设置默认值
protected void ASPxGridView1_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e) {
string field_lx_xx = \网关 field_lx_xx += \用电类型 field_lx_xx += \用电性质 field_lx_xx += \否\异常控制 field_lx_xx += \状态
field_lx_xx += \多费率 field_lx_xx += \计算电量 field_lx_xx += \倍率
field_lx_xx += \初始电量
PubCommonControl.SetDefaultValue(field_lx_xx, e.Editor, e.Column.FieldName); return; }
#endregion } }
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;
XXXX系统V1.0 28
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[\ {
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()
XXXX系统V1.0 29
{
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; //多费率
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 =