void btn_Del_Click(object sender, EventArgs e) { try { // 检查这个类型是否被使用? MapAttrs attrs = new MapAttrs(); QueryObject qo = new QueryObject(attrs); qo.AddWhere(MapAttrAttr.MyDataType, (int)FieldTypeS.FK); qo.addAnd(); qo.AddWhere(MapAttrAttr.KeyOfEn, this.RefNo); int i = qo.DoQuery(); if (i == 0) { BP.Sys.SFTable m = new SFTable(); m.No = this.RefNo; m.Delete(); this.ToMsgPage("外键删除成功"); return; } string msg = "错误:下列数据已经引用了外键您不能删除它。"; foreach (MapAttr attr in attrs) { msg += "\t\n" + attr.Field + "" + attr.Name + " 表" + attr.FK_MapData; } throw new Exception(msg); } catch (Exception ex) { this.ToErrorPage(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { this.Title = "编码表编辑"; if (this.DoType == "Del") { MapAttrs attrs = new MapAttrs(); attrs.Retrieve(MapAttrAttr.UIBindKey, this.RefNo); if (attrs.Count != 0) { this.UCSys1.AddFieldSet("<a href='SFTableList.aspx' ><img src='./../../Img/Btn/Home.gif' border=0/>返回列表</a> - 删除确认"); this.UCSys1.Add("此编码表已经被其它的字段所引用,您不能删除它。"); this.UCSys1.AddH2("<a href='SFTableList.aspx' >返回列表</a>"); this.UCSys1.AddFieldSetEnd(); return; } this.UCSys1.AddFieldSet("<a href='SFTableList.aspx' ><img src='./../../Img/Btn/Home.gif' border=0/>返回列表</a> - 删除确认"); SFTable m = new SFTable(this.RefNo); this.UCSys1.AddH2("<a href='SFTableList.aspx?RefNo=" + this.RefNo + "&DoType=DelReal' >删除:" + m.Name + " 确认.</a>"); this.UCSys1.AddFieldSetEnd(); return; } if (this.DoType == "DelReal") { SFTable m = new SFTable(); m.No = this.RefNo; m.Delete(); SFTables ses = new SFTables(); // ses.Delete(SFTableAttr.SFTableKey, this.RefNo); this.Response.Redirect("SFTableList.aspx", true); return; } if (this.DoType == "New") { this.BindNew(); return; } if (this.RefNo != null) { this.BindIt(); return; } this.UCSys1.AddTable("class=Table width=500px"); this.UCSys1.AddCaption("<img src='./../../Img/Btn/Home.gif' border=0/>列表 - <a href='SFTableList.aspx?DoType=New' ><img border=0 src='./../../Img/Btn/New.gif' >新建</a>"); this.UCSys1.AddTR(); this.UCSys1.AddTDTitle("序"); this.UCSys1.AddTDTitle("编号"); this.UCSys1.AddTDTitle("名称"); //this.UCSys1.AddTDTitle("类型"); this.UCSys1.AddTDTitle("描述"); this.UCSys1.AddTDTitle("操作"); this.UCSys1.AddTREnd(); SFTables sems = new SFTables(); sems.RetrieveAll(); int i = 0; foreach (SFTable se in sems) { i++; this.UCSys1.AddTR(); this.UCSys1.AddTDIdx(i); this.UCSys1.AddTD(se.No); this.UCSys1.AddTDA("SFTableList.aspx?RefNo=" + se.No, se.Name); // this.UCSys1.AddTD(se.SFTableTypeT); this.UCSys1.AddTD(se.TableDesc); this.UCSys1.AddTDA("SFTableList.aspx?RefNo=" + se.No + "&DoType=Del", "<img src='./../../Img/Btn/Delete.gif' border=0 />删除"); //switch (se.HisSFTableType) //{ // case SFTableType.SFTable: // this.UCSys1.AddTDA("SFTableList.aspx?RefNo=" + se.No + "&DoType=Del", "<img src='./../../Img/Btn/Delete.gif' border=0 />删除"); // break; // case SFTableType.ClsLab: // case SFTableType.SysTable: // default: // this.UCSys1.AddTD(); // break; //} this.UCSys1.AddTREnd(); } this.UCSys1.AddTableEnd(); }