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