XXXX系统V1.0 15
HBMDL.EditFormSettings.VisibleIndex = 24; //换表倍率
GridViewDataColumn HBBL =
GG.PubCommonControl.AddDataColumn2GridView(this.ASPxGridView1, \换表倍率\
HorizontalAlign.Center, HorizontalAlign.Left, 0, false); HBBL.EditFormSettings.VisibleIndex = 27; //增 删 改
GG.PubCommonControl.AddCmdColumn2GridView(this.ASPxGridView1, true, true, true, 0);
#endregion
ASPxGridView1.SettingsEditing.EditFormColumnCount = 3;//编辑时显示的列数
GG.PubCommonWebHelper.SetWHGridViewTS(ASPxGridView1, 13);//分页时单页显示行数 }
#endregion
#region 获取建筑全称
protected void cbkJZQC_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e) {
Session[\ }
#endregion
#region 获取建筑编码
protected void cbkJZBM_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e) {
Session[\ }
#endregion
#region 获取部门编码
protected void cbkBMBM_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e) {
Session[\ }
#endregion
#region 获取父表编号
protected void cbkFBBH_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e) {
Session[\ }
#endregion
#region 增 删 改 #region 新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) {
this.ASPxGridView_RowInserting(this.ASPxGridView1, e, false); }
protected override bool ASPxGridView_RowInserting_User(ASPxGridView
XXXX系统V1.0 16
ASPxGridView1, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) {
try {
DataRow dr = _dt.NewRow();
dr[\DNCJJG..B_DBXX\
dr[\
dr[\ dr[\ if (Session[\ {
dr[\ Session[\ } else
throw new Exception(\获取父表名称失败，请重新选择！\ if (Convert.ToInt16(dr[\
dr[\没有父级表 表编号路径等于他本身 else {
//有父级表 表编号路径等于上级表编号路径加','加上本身表编号 string SJBM = DbOpt.ExecuteScalar(\DNCJJG..B_DBXX where BBH=\ dr[\ }
dr[\ dr[\ dr[\ dr[\ 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[\ if (e.NewValues[\ dr[\
else dr[\ dr[\ dr[\ if (Session[\ {
XXXX系统V1.0 17
dr[\ Session[\ } else
throw new Exception(\获取所属建筑失败，请重新选择！\ if (Session[\ {
dr[\ Session[\ } else
throw new Exception(\获取所属部门失败，请重新选择！\ 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[\ 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[\
XXXX系统V1.0 18
dr[\
else dr[\ if (e.NewValues[\ dr[\
else dr[\ _dt.Rows.Add(dr); return true; }
catch (Exception) {
throw;
return false; } }
#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) {
XXXX系统V1.0 19
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 {
//改变了父级表 更改表编号路径
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][\