public string ActiveDDL_Init() { DataSet ds = new DataSet(); //加载外键字段. Paras ps = new Paras(); ps.SQL = "SELECT KeyOfEn AS No, Name FROM Sys_MapAttr WHERE UIContralType=1 AND FK_MapData=" + SystemConfig.AppCenterDBVarStr + "FK_MapData AND KeyOfEn!=" + SystemConfig.AppCenterDBVarStr + "KeyOfEn"; ps.Add("FK_MapData", this.FK_MapData); ps.Add("KeyOfEn", this.KeyOfEn); //var sql = "SELECT KeyOfEn AS No, Name FROM Sys_MapAttr WHERE UIContralType=1 AND FK_MapData='" + this.FK_MapData + "' AND KeyOfEn!='" + this.KeyOfEn + "'"; DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(ps); dt.TableName = "Sys_MapAttr"; dt.Columns[0].ColumnName = "No"; dt.Columns[1].ColumnName = "Name"; ds.Tables.Add(dt); if (dt.Rows.Count == 0) { return("err@表单中没有要级联的下拉框."); } //加载数据源. SFDBSrcs srcs = new SFDBSrcs(); srcs.RetrieveAll(); DataTable dtSrc = srcs.ToDataTableField(); dtSrc.TableName = "Sys_SFDBSrc"; ds.Tables.Add(dtSrc); // 加载mapext 数据. MapExt me = new MapExt(); int i = me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.ActiveDDL, MapExtAttr.FK_MapData, this.FK_MapData, MapExtAttr.AttrOfOper, this.KeyOfEn); if (i == 0) { me.FK_MapData = this.FK_MapData; me.AttrOfOper = this.KeyOfEn; me.FK_DBSrc = "local"; } if (me.FK_DBSrc == "") { me.FK_DBSrc = "local"; } //去掉 ' 号. me.SetValByKey("Doc", me.Doc); dt = me.ToDataTableField(); dt.TableName = "Sys_MapExt"; ds.Tables.Add(dt); return(BP.Tools.Json.ToJson(ds)); }
public string DDLFullCtrl_Init() { DataSet ds = new DataSet(); //加载数据源. SFDBSrcs srcs = new SFDBSrcs(); srcs.RetrieveAll(); DataTable dtSrc = srcs.ToDataTableField(); dtSrc.TableName = "Sys_SFDBSrc"; ds.Tables.Add(dtSrc); // 加载 mapext 数据. MapExt me = new MapExt(); int i = me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.DDLFullCtrl, MapExtAttr.FK_MapData, this.FK_MapData, MapExtAttr.AttrOfOper, this.KeyOfEn); if (i == 0) { me.FK_MapData = this.FK_MapData; me.AttrOfOper = this.KeyOfEn; me.FK_DBSrc = "local"; } me.W = i; if (me.FK_DBSrc == "") { me.FK_DBSrc = "local"; } //去掉 ' 号. me.SetValByKey("Doc", me.Doc); DataTable dt = me.ToDataTableField(); dt.TableName = "Sys_MapExt"; ds.Tables.Add(dt); return(BP.Tools.Json.ToJson(ds)); }