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();
}