개정판 353c2919
issue #000: Valve Grouping Setting
Change-Id: I2e1cc8b9348997a5bcf582550519ce46c5995a4d
| DTI_PID/ID2PSN/DB.cs | ||
|---|---|---|
| 733 | 733 |
{
|
| 734 | 734 |
try |
| 735 | 735 |
{
|
| 736 |
var query = "SELECT B.Name + '/' + Attribute AS SymbolAttribute, A.SymbolType_UID ,Attribute ,DisplayAttribute ,AttributeType, Expression FROM SymbolAttribute A INNER JOIN Symbol B ON A.SymbolType_UID = B.UID;";
|
|
| 736 |
var query = "SELECT B.Name AS SymbolName, Attribute AS SymbolAttribute, A.SymbolType_UID ,Attribute ,DisplayAttribute ,AttributeType, Expression FROM SymbolAttribute A INNER JOIN Symbol B ON A.SymbolType_UID = B.SymbolType_UID; ";
|
|
| 737 | 737 |
using (var ds = connection.ExecuteDataSet(connection.GetSqlStringCommand(query))) |
| 738 | 738 |
{
|
| 739 | 739 |
dt = ds.Tables[0].Copy(); |
| DTI_PID/ID2PSN/Form/ValveGroupingSetting.cs | ||
|---|---|---|
| 101 | 101 | |
| 102 | 102 |
SymbolList = DB.SelectAllSymbolAttribute(); |
| 103 | 103 | |
| 104 |
//선택 Symbol에 따라 Combobox값 변경해줘야함 (어려우니 그냥 넣는걸로..) |
|
| 104 |
//repositoryAttributeItem.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; |
|
| 105 |
//repositoryAttributeItem.AppearanceDropDown.Font = Font; |
|
| 106 |
//repositoryAttributeItem.Items.Add("NoSelection");
|
|
| 107 |
//foreach (DataRow dr in SymbolList.Rows) |
|
| 108 |
//{
|
|
| 109 |
// repositoryAttributeItem.Items.Add(dr["SymbolAttribute"].ToString()); |
|
| 110 |
//} |
|
| 111 |
//repositoryAttributeItem.Items.Add("");
|
|
| 112 | ||
| 105 | 113 |
repositoryAttributeItem.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; |
| 106 | 114 |
repositoryAttributeItem.AppearanceDropDown.Font = Font; |
| 107 |
repositoryAttributeItem.Items.Add("NoSelection");
|
|
| 108 |
foreach(DataRow dr in SymbolList.Rows) |
|
| 109 |
{
|
|
| 110 |
repositoryAttributeItem.Items.Add(dr["SymbolAttribute"].ToString()); |
|
| 111 |
|
|
| 112 |
} |
|
| 113 |
//repositoryAttributeItem.Items.Add("");
|
|
| 114 | 115 |
gridValveGroup.RepositoryItems.Add(repositoryAttributeItem); |
| 115 | 116 | |
| 116 | 117 |
gridColumn = gridViewValveGroup.Columns[2]; |
| ... | ... | |
| 129 | 130 |
RepositoryItemTreeListLookUpEdit treeListLookUpEdit = new RepositoryItemTreeListLookUpEdit(); |
| 130 | 131 |
gridValveGroup.RepositoryItems.Add(treeListLookUpEdit); |
| 131 | 132 |
SetSymbol(treeListLookUpEdit); |
| 133 |
|
|
| 132 | 134 |
// gridColumn.ColumnEdit = treeListLookUpEdit; |
| 133 | 135 |
gridViewValveGroup.Columns["SppidSymbolName"].ColumnEdit = treeListLookUpEdit; |
| 134 | 136 | |
| ... | ... | |
| 138 | 140 |
gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False; |
| 139 | 141 |
gridColumn.VisibleIndex = 4; |
| 140 | 142 |
gridColumn.MaxWidth = 16; |
| 141 |
|
|
| 143 |
|
|
| 142 | 144 |
gridColumn.ColumnEdit = btnRemove; |
| 143 | 145 |
gridColumn.ShowButtonMode = DevExpress.XtraGrid.Views.Base.ShowButtonModeEnum.ShowAlways; |
| 146 |
gridViewValveGroup.CustomRowCellEditForEditing += gridView1_CustomRowCellEditForEditing; |
|
| 144 | 147 |
//gridViewKeyword.CustomDrawColumnHeader += GridViewKeyword_CustomDrawColumnHeader; |
| 145 |
|
|
| 146 |
} |
|
| 148 | ||
| 149 | ||
| 150 |
} |
|
| 151 | ||
| 152 |
private void gridView1_CustomRowCellEditForEditing(object sender, DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs e) |
|
| 153 |
{
|
|
| 154 |
if (e.Column == (sender as GridView).Columns["AttributeName"]) |
|
| 155 |
{
|
|
| 156 |
DevExpress.XtraGrid.Views.Base.ColumnView columnView = sender as DevExpress.XtraGrid.Views.Base.ColumnView; |
|
| 157 |
DataTable dt = gridValveGroup.DataSource as DataTable; |
|
| 158 |
string SppidSymbolName = dt.Rows[columnView.FocusedRowHandle]["SppidSymbolName"].ToString(); |
|
| 159 |
|
|
| 160 |
if(string.IsNullOrEmpty(SppidSymbolName)) |
|
| 161 |
{
|
|
| 162 |
MessageBox.Show("Choose a symbol !", "ID2 " + ID2Info.ProgramName, MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
| 163 |
return; |
|
| 164 |
} |
|
| 165 | ||
| 166 |
repositoryAttributeItem.Items.Clear(); |
|
| 167 |
repositoryAttributeItem.Items.Add("NoSelection");
|
|
| 168 |
foreach (DataRow dr in SymbolList.Rows) |
|
| 169 |
{
|
|
| 170 |
if(dr["SymbolName"].ToString().ToUpper().Equals(SppidSymbolName.ToUpper())) |
|
| 171 |
{
|
|
| 172 |
repositoryAttributeItem.Items.Add(dr["SymbolAttribute"].ToString()); |
|
| 173 |
} |
|
| 174 |
} |
|
| 175 |
//repositoryAttributeItem.Items.Add("");
|
|
| 176 |
} |
|
| 177 |
} |
|
| 147 | 178 | |
| 148 | 179 |
private void GridViewKeyword_CustomDrawColumnHeader(object sender, ColumnHeaderCustomDrawEventArgs e) |
| 149 | 180 |
{
|
| ... | ... | |
| 193 | 224 |
|
| 194 | 225 |
} |
| 195 | 226 |
|
| 196 | ||
| 197 | 227 |
private void removeSymbolButton_Click(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) |
| 198 | 228 |
{
|
| 199 |
// string value = gridViewValveGroup.GetFocusedRowCellValue("OID").ToString();
|
|
| 200 | 229 |
DataTable dt = gridValveGroup.DataSource as DataTable; |
| 201 | ||
| 202 |
//DevExpress.XtraGrid.Views.Base.ColumnView columnView = sender as DevExpress.XtraGrid.Views.Base.ColumnView; |
|
| 203 |
|
|
| 204 | ||
| 205 |
// DataRow[] rows = dt. |
|
| 206 |
//if (rows.Length.Equals(1)) |
|
| 207 |
// dt.Rows.Remove(rows.First()); |
|
| 208 |
//ReNumbering(currentValveGroupInfo); |
|
| 230 |
DataRow rows = dt.Rows[gridViewValveGroup.FocusedRowHandle]; |
|
| 231 |
if (rows != null) |
|
| 232 |
dt.Rows.Remove(rows); |
|
| 209 | 233 |
} |
| 210 | 234 | |
| 211 | 235 |
public void SetSymbol(RepositoryItemTreeListLookUpEdit treeListLookUpEdit) |
내보내기 Unified diff