protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
string fk_mapdata = this.Request.QueryString["FK_MapData"];
string RefNo = this.Request.QueryString["RefNo"];
BP.Sys.MapExt ext = new BP.Sys.MapExt();
ext.MyPK = this.ExtType + this.FK_MapData + "_" + this.RefNo;
ext.RetrieveFromDBSources();
this.TB_SQL.Text = ext.Doc;
ArrayList arr = new ArrayList();
SysEnums ens = new SysEnums("DBSrcType");
foreach (SysEnum en in ens)
{
arr.Add(en.Lab);
}
switch (ext.FK_DBSrc)
{
case "1":
this.DDL_DBSrc.SelectedValue = "SQLServer数据库";
break;
case "100":
this.DDL_DBSrc.SelectedValue = "WebService数据源";
break;
case "2":
this.DDL_DBSrc.SelectedValue = "Oracle数据库";
break;
case "3":
this.DDL_DBSrc.SelectedValue = "MySQL数据库";
break;
case "4":
this.DDL_DBSrc.SelectedValue = "Informix数据库";
break;
default:
this.DDL_DBSrc.SelectedValue = "应用系统主数据库(默认)";
break;
}
this.DDL_DBSrc.DataSource = arr;
this.DDL_DBSrc.DataBind();
}
}
protected void Btn_Save_Click(object sender, EventArgs e)
{
BP.Sys.MapExt ext = new BP.Sys.MapExt();
ext.MyPK = this.ExtType + this.FK_MapData + "_" + this.RefNo;
ext.RetrieveFromDBSources();
ext.FK_MapData = this.FK_MapData;
ext.Doc = this.TB_SQL.Text;
ext.AttrOfOper = this.RefNo;
ext.ExtType = "AutoFullDLL";
switch (this.DDL_DBSrc.Text)
{
case "应用系统主数据库(默认)":
ext.FK_DBSrc = "0";
break;
case "SQLServer数据库":
ext.FK_DBSrc = "1";
break;
case "WebService数据源":
ext.FK_DBSrc = "100";
break;
case "Oracle数据库":
ext.FK_DBSrc = "2";
break;
case "MySQL数据库":
ext.FK_DBSrc = "3";
break;
case "Informix数据库":
ext.FK_DBSrc = "4";
break;
default:
break;
}
ext.Save();
}
