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