续：DataSource中QueryBuilder的编辑器

1 using System;
2 using System.Reflection;
3 using System.Drawing.Design;
4 using System.ComponentModel;
5 using System.Windows.Forms;
6 using System.Windows.Forms.Design;
7
8 namespace FaibClass.Data.Controls
9 {
10     /// <summary>
11     /// 构造器
12     /// </summary>
13     public class QueryParameterEditor : UITypeEditor
14     {
15
16         public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value)
17         {
18             //得到数据模型类型
19             Type model = ((DataSource)context.Instance).DataModel;
20             FormQueryParemeter frm = new FormQueryParemeter(model);
21             if (value != null)
22             {
23                 frm.Query = (QueryBuilder)value;
24             }
25             if (frm.ShowDialog() == DialogResult.OK)
26             {
27                 value = frm.Query;
28             }
29             return value;
30         }
31
32         public override UITypeEditorEditStyle GetEditStyle(ITypeDescriptorContext context)
33         {
34             return UITypeEditorEditStyle.Modal;
35         }
36     }
37 }
38

  1 using System;
  2 using System.Reflection;
  3 using System.Drawing.Design;
  4 using System.ComponentModel;
  5 using System.Windows.Forms;
  6 using System.Windows.Forms.Design;
  7
  8 namespace FaibClass.Data.Controls
  9 {
10
11     /// <summary>
12     /// 数据模型字段编辑器
13     /// </summary>
14     public class ModelFieldEditor : UITypeEditor
15     {
16         private ModelFieldUI modelUI;
17
18         public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value)
19         {
20             if (provider != null)
21             {
22                 //得到数据模型类型
23                 Type model = ((QueryParameter)context.Instance).modelType;
24                 IWindowsFormsEditorService edSvc = (IWindowsFormsEditorService)provider.GetService(typeof(IWindowsFormsEditorService));
25                 if (edSvc == null)
26                 {
27                     return value;
28                 }
29                 if (this.modelUI == null)
30                 {
31                     this.modelUI = new ModelFieldUI(this, model);
32                 }
33                 this.modelUI.Start(edSvc, value);
34                 edSvc.DropDownControl(this.modelUI);
35                 value = this.modelUI.Value;
36                 this.modelUI.End();
37             }
38             return value;
39         }
40
41         /// <summary>
42         /// 设置编辑器的弹出样式。
43         /// </summary>
44         /// <param name="context"></param>
45         /// <returns></returns>
46         public override UITypeEditorEditStyle GetEditStyle(ITypeDescriptorContext context)
47         {
48             return UITypeEditorEditStyle.DropDown;
49         }
50
51         /// <summary>
52         /// 设置编辑器是否可调大小。
53         /// </summary>
54         public override bool IsDropDownResizable
55         {
56             get
57             {
58                 return true;
59             }
60         }
61
62         private class ModelFieldUI : TreeView
63         {
64             private UITypeEditor editor;
65             private IWindowsFormsEditorService edSvc;
66             private object value;
67             private Type modelType;
68             private ImageList imglist;
69
70             public ModelFieldUI(UITypeEditor editor, Type type)
71             {
72                 this.editor = editor;
73                 this.modelType = type;
74                 base.Height = 200;
75                 base.Width = 200;
76                 base.BorderStyle = BorderStyle.None;
77                 base.ShowRootLines = false;
78                 base.ShowPlusMinus = false;
79                 base.NodeMouseClick += new TreeNodeMouseClickEventHandler(BaseModelUI_NodeMouseClick);
80                 imglist = new ImageList();
81                 imglist.ImageSize = new System.Drawing.Size(16, 16);
82                 imglist.ColorDepth = ColorDepth.Depth32Bit;
83                 //添加图标资源
84                 imglist.Images.Add(Properties.Resources._const.ToBitmap());
85
86                 base.ImageList = imglist;
87             }
88
89             void BaseModelUI_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
90             {
91                 if (base.SelectedNode == null) return;
92                 value = e.Node.Text;
93                 this.edSvc.CloseDropDown();
94             }
95
96             /// <summary>
97             ///
98             /// </summary>
99             public void End()
100             {
101                 this.edSvc = null;
102                 this.value = null;
103             }
104
105             /// <summary>
106             ///
107             /// </summary>
108             /// <param name="edSvc"></param>
109             /// <param name="value"></param>
110             public void Start(IWindowsFormsEditorService edSvc, object value)
111             {
112                 this.edSvc = edSvc;
113                 this.value = value;
114
115                 this.Nodes.Clear();
116                 if (modelType != null)
117                 {
118                     //取出模型类中静态的字段常量
119                     foreach(FieldInfo finfo in modelType.GetFields(BindingFlags.Static | BindingFlags.Public | BindingFlags.Instance))
120                     {
121                         if (finfo.Name == "_TableName" || finfo.Name == "_PrimaryKey") continue;
122                         string value1 = finfo.GetValue(null).ToString();
123                         TreeNode node = new TreeNode(value1);
124                         node.ImageIndex = 0;
125                         if (value != null)
126                         {
127                             if (value.ToString() == value1)
128                             {
129                                 base.SelectedNode = node;
130                             }
131                         }
132                         base.Nodes.Add(node);
133                     }
134                 }
135             }
136
137             /// <summary>
138             /// 当前选定的类名称
139             /// </summary>
140             public object Value
141             {
142                 get
143                 {
144                     return this.value;
145                 }
146             }
147         }
148     }
149 }
150

  1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Data;
  5 using System.Drawing;
  6 using System.Text;
  7 using System.Windows.Forms;
  8
  9 namespace FaibClass.Data.Controls
10 {
11     /// <summary>
12     /// 用于编辑查询参数的窗体
13     /// </summary>
14     public partial class FormQueryParemeter : Form
15     {
16         private Type modelType;
17
18         public FormQueryParemeter(Type modelType)
19         {
20             InitializeComponent();
21             this.modelType = modelType;
22         }
23
24         public QueryBuilder Query
25         {
26             get
27             {
28                 //返回当前修改的参数集合
29                 QueryParameterCollection collection = new QueryParameterCollection();
30                 foreach(ListViewItem item in lvwParameter.Items)
31                 {
32                     collection.InternalAdd(item.Tag as QueryParameterBase);
33                 }
34                 //QueryParameterCollection转换到QueryBuilder
35                 return (QueryBuilder)collection;
36             }
37             set
38             {
39                 //将参数集合添加到列表中
40                 QueryParameterCollection collection = value.QueryParameters.Clone();
41                 foreach(QueryParameterBase p in collection)
42                 {
43                     p.modelType = modelType;
44                     ListViewItem item = MakeItem(p);
45                     item.Tag = p;
46                     lvwParameter.Items.Add(item);
47                 }
48             }
49         }
50
51         private ListViewItem MakeItem(QueryParameterBase p)
52         {
53             string text = "";
54             int index = 0;
55             if (p is QueryParameter)
56             {
57                 text = (p as QueryParameter).Field;
58                 index = 0;
59             }
60             //左括号
61             else if (p is QueryLeftBracket)
62             {
63                 text = "(";
64                 index = 1;
65             }
66             //右括号
67             else if (p is QueryRightBracket)
68             {
69                 text = ")";
70                 index = 2;
71             }
72             ListViewItem item = new ListViewItem(text, index);
73             item.Tag = p;
74             return item;
75         }
76
77         /// <summary>
78         /// 添加一个参数
79         /// </summary>
80         /// <param name="sender"></param>
81         /// <param name="e"></param>
82         private void btnAdd_Click(object sender, EventArgs e)
83         {
84             QueryParameter p = new QueryParameter();
85             p.modelType = modelType;
86             ListViewItem item = new ListViewItem("[未定义]", 0);
87             item.Tag = p;
88             lvwParameter.Items.Add(item);
89             item.Selected = true;
90         }
91
92         private void 左括号ToolStripMenuItem_Click(object sender, EventArgs e)
93         {
94             QueryLeftBracket p = new QueryLeftBracket();
95             p.modelType = modelType;
96             ListViewItem item = new ListViewItem("(", 1);
97             item.Tag = p;
98             lvwParameter.Items.Add(item);
99             item.Selected = true;
100         }
101
102         private void 右括号ToolStripMenuItem_Click(object sender, EventArgs e)
103         {
104             QueryRightBracket p = new QueryRightBracket();
105             p.modelType = modelType;
106             ListViewItem item = new ListViewItem(")", 2);
107             item.Tag = p;
108             lvwParameter.Items.Add(item);
109             item.Selected = true;
110         }
111
112         private void pgParemeter_PropertyValueChanged(object s, PropertyValueChangedEventArgs e)
113         {
114             if (lvwParameter.SelectedItems[0].Tag is QueryParameter)
115             {
116                 string text = (lvwParameter.SelectedItems[0].Tag as QueryParameter).Field;
117                 lvwParameter.SelectedItems[0].Text = string.IsNullOrEmpty(text) ? "[未定义]" : text;
118             }
119         }
120
121         private void btnOk_Click(object sender, EventArgs e)
122         {
123             //检查左右括号是否匹配
124             int l = 0, r = 0;
125             foreach (ListViewItem item in lvwParameter.Items)
126             {
127                 if (item.Tag is QueryLeftBracket) l++;
128                 else if (item.Tag is QueryRightBracket) r++;
129             }
130             if (r != l)
131             {
132                 MessageBox.Show("左右括号没有成对出现,不符合Sql语法规则。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
133                 return;
134             }
135
136             DialogResult = DialogResult.OK;
137         }
138
139         /// <summary>
140         /// 移除
141         /// </summary>
142         /// <param name="sender"></param>
143         /// <param name="e"></param>
144         private void btnRemove_Click(object sender, EventArgs e)
145         {
146             if (lvwParameter.SelectedItems.Count == 0) return;
147             lvwParameter.SelectedItems[0].Remove();
148             pgParemeter.SelectedObject = null;
149             lblPg.Text = "{} 的属性:";
150         }
151
152         private void lvwParameter_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)
153         {
154             if (e.IsSelected)
155             {
156                 pgParemeter.SelectedObject = e.Item.Tag;
157                 if (e.Item.Tag is QueryParameter)
158                 {
159                     lblPg.Text = (e.Item.Tag as QueryParameter).Field + " 的属性:";
160                 }
161                 else
162                 {
163                     lblPg.Text = "括号的属性:";
164                 }
165             }
166         }
167
168         private void btnOther_Click(object sender, EventArgs e)
169         {
170             contextMenuStrip1.Show(this, btnOther.Left, btnOther.Top + btnOther.Height);
171         }
172
173         /// <summary>
174         /// 上移
175         /// </summary>
176         /// <param name="sender"></param>
177         /// <param name="e"></param>
178         private void btnUp_Click(object sender, EventArgs e)
179         {
180             if (lvwParameter.SelectedItems.Count == 0)
181                 return;
182             if (lvwParameter.SelectedItems[0].Index == 0)
183                 return;
184             ListViewItem old = (ListViewItem)lvwParameter.SelectedItems[0].Clone();
185             int index = lvwParameter.SelectedItems[0].Index;
186             lvwParameter.Items[index] = (ListViewItem)lvwParameter.Items[index - 1].Clone();
187             lvwParameter.Items[index - 1] = old;
188             old.Selected = true;
189         }
190
191         /// <summary>
192         /// 下移
193         /// </summary>
194         /// <param name="sender"></param>
195         /// <param name="e"></param>
196         private void btnDown_Click(object sender, EventArgs e)
197         {
198             if (lvwParameter.SelectedItems.Count == 0)
199                 return;
200             if (lvwParameter.SelectedItems[0].Index == lvwParameter.SelectedItems.Count - 1)
201                 return;
202             ListViewItem old = (ListViewItem)lvwParameter.SelectedItems[0].Clone();
203             int index = lvwParameter.SelectedItems[0].Index;
204             lvwParameter.Items[index] = (ListViewItem)lvwParameter.Items[index + 1].Clone();
205             lvwParameter.Items[index + 1] = old;
206             old.Selected = true;
207         }
208     }
209 }

1 using System;
2 using System.ComponentModel;
3 using System.Globalization;
4 using System.Windows.Forms;
5
6 namespace FaibClass.Data.Controls
7 {
8     /// <summary>
9     /// Object数组转换器
10     /// </summary>
11     public class ObjectValueConverter : StringConverter
12     {
13         public override bool CanConvertTo(ITypeDescriptorContext context, Type destinationType)
14         {
15             return true;
16         }
17
18         public override bool CanConvertFrom(ITypeDescriptorContext context, Type sourceType)
19         {
20             return true;
21         }
22
23         public override object ConvertTo(ITypeDescriptorContext context, CultureInfo culture, object value, Type destinationType)
24         {
25             if (value == null)
26                 return "";
27             string ss = "";
28             //将object[]转换为字符串显示,长度跟QueryBuilder中的Append有关
29             //效果为值1,值2
30             foreach (object v in (object[])value)
31             {
32                 ss += v.ToString() + ",";
33             }
34             return ss.Trim(',');
35         }
36
37         public override object ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, object value)
38         {
39             if (value == null)
40                 return null;
41             if (value.ToString().Length == 0)
42                 return null;
43
44             //将字符串转换为object[]
45             Type model = ((QueryParameterBase)context.Instance).modelType;
46             Type ptype = model.GetProperty(((QueryParameter)context.Instance).Field).PropertyType;
47             //取模型字段的类型
48             TypeCode tc = Type.GetTypeCode(ptype);
49
50             string[] ss = value.ToString().Split(',');
51             object[] result = new object[ss.Length];
52             int i = 0;
53             foreach (string v in ss)
54             {
55                 if (v.Length == 0)
56                 {
57                     result[i++] = null;
58                 }
59                 else
60                 {
61                     //转换
62                     result[i++] = Convert.ChangeType(v.ToString(), tc);
63                 }
64             }
65             return result;
66         }
67     }
68 }
69

faib的技术专栏

公告