public bool get_ColumnSetting(string colname, out ColumnSetting cs) { foreach (string key in _sqlKey.Keys) { if (_sqlKey[key].ColumnSetting.ContainsKey (colname )) { cs = _sqlKey[key].ColumnSetting[colname]; return true ; } } cs = null; return false; }
public void SetColumnSetting(DBLClass dblc, ColumnSetting cs,params object[] param) { if (dblc != null) { Dictionary<string, ColumnSetting> dcs = new Dictionary<string, ColumnSetting>(); SqlListItem sqli = null; _columnSetting = cs; if (dblc.get_ColumnSetting(cs.LinkDataSQLString, ref dcs, out sqli)) { if (_selectData != null) { _selectData.Clear(); _selectData.Dispose(); _selectData = new DataTable(); } dblc.get_Data(string.Format(sqli.SQLString, param), ref _selectData); this.SelectItemdataGridView.DataSource = _selectData; dblc.set_dataColumn(dcs, this.SelectItemdataGridView); } } }
//载入列设置数据 /// <summary> /// 载入列设置数据 /// </summary> /// <param name="dt"></param> public void SetColumnSettingDataByTable(DataTable dt) { //注意 //这里只检查了表格列数量,未作其他检查 if (dt.Columns.Count != 14) { return; } foreach (DataRow dr in dt.Rows) { ColumnSetting cs = new ColumnSetting(); cs.id = Convert.ToInt32(dr[0]); cs.ColName = Convert.ToString(dr[1]); cs.Visiable = Convert.ToBoolean(dr[2]); cs.HeadText = Convert.ToString(dr[3]); cs.Width = Convert.ToInt32(dr[4]); cs.Localtion = Convert.ToInt32(dr[5]); cs.LinkData = Convert.ToBoolean(dr[6]); cs.LinkDataSQLString = Convert.ToInt32(dr[7]); cs.LinkColumnName = Convert.ToString(dr[8]); cs.ActionName = Convert.ToString(dr[9]); cs.DefaultValue = dr[10]; cs.ReadOnly = Convert.ToBoolean(dr[11]); cs.IdentityIS = Convert.ToBoolean(dr[12]); cs.Expression = dr[13]; if (!_dcs.ContainsKey(cs.ColName)) { _dcs.Add(cs.ColName, cs); } } }