XXXX系统V1.0 35
else dr[\ if (e.NewValues[\ dr[\
else dr[\ if (e.NewValues[\ dr[\
else dr[\ if (e.NewValues[\ dr[\ else dr[\ if (e.NewValues[\ dr[\ else dr[\ if (e.NewValues[\ dr[\
else dr[\ dr[\ if (e.NewValues[\ dr[\
else dr[\ dr[\ if (e.NewValues[\ dr[\
else dr[\ if (e.NewValues[\ dr[\
else dr[\ if (e.NewValues[\ {
if (Session[\
dr[\e.NewValues[\
else dr[\ }
else dr[\ if (e.NewValues[\ dr[\
else dr[\ if (e.NewValues[\ dr[\
else dr[\ if (e.NewValues[\ dr[\
else dr[\ _dt.Rows.Add(dr); return true; }
catch (Exception) {
throw;
return false; } }
XXXX系统V1.0 36
#endregion #region 删除
protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) {
this.ASPxGridView_RowDeleting(ASPxGridView1, e, false); }
protected override bool ASPxGridView_RowDeleting_User(ASPxGridView ASPxGridView1, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) {
string BBH = e.Keys[0].ToString();
int result = Convert.ToInt16(DbOpt.ExecuteScalar(\DNCJJG..B_DBXX where FBBH='\ if (result > 0) {
throw new Exception(\所选电表下还有子级表，请先删除子级电表再删本电表！\
return false; } else {
DataRow[] dr = _dt.Select(\ if (dr.Length > 0) {
dr[0].Delete(); }
return true; } }
#endregion #region 修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) {
this.ASPxGridView_RowUpdating(this.ASPxGridView1, e, false); }
protected override bool ASPxGridView_RowUpdating_User(ASPxGridView ASPxGridView1, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) {
DataRow[] dr = _dt.Select(\ if (dr.Length > 0) {
dr[0][\
dr[0][\ dr[0][\ if (Session[\ {
dr[0][\ Session[\
if (Convert.ToInt16(dr[0][\
dr[0][\没有父级表 表编号路径等于他本身编号
else
XXXX系统V1.0 37
{
//改变了父级表 更改表编号路径
string SJBM = DbOpt.ExecuteScalar(\DNCJJG..B_DBXX where BBH=\
dr[0][\ //修改本表的下级表
GG.PubCommonData.BuildDNCJJG_DBLJ(DataQuery.QueryDataType.DNCJJG, SJBM, Convert.ToInt16(e.Keys[0]), dr[0][\ } }
dr[0][\ dr[0][\ dr[0][\ dr[0][\ dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\ else dr[0][\ if (e.NewValues[\ dr[0][\ else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ dr[0][\
XXXX系统V1.0 38
if (e.NewValues[\ dr[0][\
else dr[0][\ dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ //改变了所属建筑 更改电表全称
if (Session[\
Session[\ {
//但没有更新电表全称
if (e.NewValues[\e.OldValues[\ {
//更改电表全称
dr[0][\e.NewValues[\ }
else dr[0][\自行更改了 等于更改值
}
else dr[0][\ dr[0][\ if (Session[\ {
dr[0][\ Session[\ }
dr[0][\ if (Session[\ {
dr[0][\ Session[\ }
if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ if (e.NewValues[\ dr[0][\
else dr[0][\ }
return true; }
#endregion #endregion
#region ASPxGridView验证
XXXX系统V1.0 39
protected void ASPxGridView1_ParseValue(object sender, DevExpress.Web.Data.ASPxParseValueEventArgs e) {
if (e.FieldName.Equals(\ {
if (e.Value == null || !(Regex.IsMatch(e.Value.ToString(), @\
throw new Exception(\电表通讯地址不能为空且只能为数字!请重新填写.\
else if (e.Value.ToString().Trim().Length > 12)
throw new Exception(\电表通讯地址应为12位以内数字组成！\ }
if (e.FieldName.Equals(\ {
if (e.Value == null || !(Regex.IsMatch(e.Value.ToString(), @\
throw new Exception(\倍率不能为空且只能为数字！请重新填写.\ }
if (e.FieldName.Equals(\ {
if (e.Value == null || !(Regex.IsMatch(e.Value.ToString(), @\ {
throw new Exception(\平电价不能为空且只能为数字!\ } }
if (e.FieldName.Equals(\ {
if (e.Value != null && !(Regex.IsMatch(e.Value.ToString(), @\ {
throw new Exception(\尖电价只能为数字!请重新填写.\ } }
if (e.FieldName.Equals(\ {
if (e.Value != null && !(Regex.IsMatch(e.Value.ToString(), @\ {
throw new Exception(\峰电价只能为数字!请重新填写.\ } }
if (e.FieldName.Equals(\ {
if (e.Value != null && !(Regex.IsMatch(e.Value.ToString(), @\ {
throw new Exception(\谷电价只能为数字!请重新填写.\ } }
if (e.FieldName.Equals(\ {
if (e.Value != null && !(Regex.IsMatch(e.Value.ToString(), @\ throw new Exception(\初始电量只能为数字！请重新填写.\