private void buttonOK_Click(object sender, EventArgs e)
{
//
Dictionary <string, string> lst = new Dictionary <string, string>();
for (int i = 0; i < dataGridView1.RowCount; i++)
{
string name = VPLUtil.ObjectToString(dataGridView1.Rows[i].Cells[0].Value);
string val = VPLUtil.ObjectToString(dataGridView1.Rows[i].Cells[1].Value);
if (!string.IsNullOrEmpty(name) || !string.IsNullOrEmpty(val))
{
if (string.IsNullOrEmpty(name))
{
name = val;
}
if (string.IsNullOrEmpty(val))
{
val = name;
}
}
if (!string.IsNullOrEmpty(name))
{
lst.Add(name, val);
}
}
WebDataEditorLookup de = this.SelectedEditor as WebDataEditorLookup;
if (de == null)
{
de = new WebDataEditorLookup();
this.SetSelection(de);
}
de.values = lst;
this.DialogResult = DialogResult.OK;
}
private void buttonOK_Click(object sender, EventArgs e)
{
//
List <string> lst = new List <string>();
for (int i = 0; i < dataGridView1.RowCount; i++)
{
string name = VPLUtil.ObjectToString(dataGridView1.Rows[i].Cells[0].Value);
if (!string.IsNullOrEmpty(name))
{
lst.Add(name);
}
}
string[] valueList = new string[lst.Count];
lst.CopyTo(valueList, 0);
DataEditorLookup de = this.SelectedEditor as DataEditorLookup;
if (de == null)
{
de = new DataEditorLookup();
this.SetSelection(de);
}
de.values = valueList;
this.DialogResult = DialogResult.OK;
}
public void CreateHtmlContent(XmlNode node, EnumWebElementPositionType positionType, int groupId)
{
XmlUtil.SetAttribute(node, "tabindex", this.TabIndex);
WebPageCompilerUtility.SetWebControlAttributes(this, node);
for (int i = 0; i < Items.Count; i++)
{
string v;
string s = VPLUtil.ObjectToString(Items[i]);
if (!string.IsNullOrEmpty(s))
{
int n = s.IndexOf('|');
if (n >= 0)
{
v = s.Substring(n + 1).Trim();
s = s.Substring(0, n).Trim();
}
else
{
v = s;
}
}
else
{
v = string.Empty;
}
XmlElement oNode = node.OwnerDocument.CreateElement("option");
node.AppendChild(oNode);
XmlUtil.SetAttribute(oNode, "value", v);
oNode.InnerText = s;
oNode.IsEmpty = false;
}
//
StringBuilder sb = new StringBuilder();
//
sb.Append("background-color:");
sb.Append(ObjectCreationCodeGen.GetColorString(this.BackColor));
sb.Append("; ");
//
sb.Append("color:");
sb.Append(ObjectCreationCodeGen.GetColorString(this.ForeColor));
sb.Append("; ");
//
WebPageCompilerUtility.CreateWebElementZOrder(this.zOrder, sb);
WebPageCompilerUtility.CreateElementPosition(this, sb, positionType);
WebPageCompilerUtility.CreateWebElementCursor(cursor, sb, false);
//
if (_dataNode != null)
{
XmlNode pNode = _dataNode.SelectSingleNode(string.Format(CultureInfo.InvariantCulture,
"{0}[@name='Visible']", XmlTags.XML_PROPERTY));
if (pNode != null)
{
string s = pNode.InnerText;
if (!string.IsNullOrEmpty(s))
{
try
{
bool b = Convert.ToBoolean(s, CultureInfo.InvariantCulture);
if (!b)
{
sb.Append("display:none; ");
}
}
catch
{
}
}
}
sb.Append(ObjectCreationCodeGen.GetFontStyleString(this.Font));
//
pNode = _dataNode.SelectSingleNode(string.Format(CultureInfo.InvariantCulture,
"{0}[@name='disabled']", XmlTags.XML_PROPERTY));
if (pNode != null)
{
string s = pNode.InnerText;
if (!string.IsNullOrEmpty(s))
{
try
{
bool b = Convert.ToBoolean(s, CultureInfo.InvariantCulture);
if (b)
{
XmlUtil.SetAttribute(node, "disabled", "disabled");
}
}
catch
{
}
}
}
}
XmlUtil.SetAttribute(node, "style", sb.ToString());
StringBuilder dbs = new StringBuilder();
if (this.DataBindings != null && this.DataBindings.Count > 0)
{
string tbl2 = null;
string sIdx = string.Empty;
string slItem = string.Empty;
string slValue = string.Empty;
for (int i = 0; i < DataBindings.Count; i++)
{
if (DataBindings[i].DataSource != null)
{
if (string.Compare(DataBindings[i].PropertyName, "SelectedIndex", StringComparison.OrdinalIgnoreCase) == 0 || string.Compare(DataBindings[i].PropertyName, "selectedIndex", StringComparison.OrdinalIgnoreCase) == 0)
{
sIdx = string.Format(CultureInfo.InvariantCulture, "{0}:{1}:SelectedIndex",
DataBindings[i].BindingMemberInfo.BindingPath, DataBindings[i].BindingMemberInfo.BindingMember);
}
else if (string.Compare(DataBindings[i].PropertyName, "SelectedItem", StringComparison.OrdinalIgnoreCase) == 0)
{
tbl2 = DataBindings[i].BindingMemberInfo.BindingPath;
slItem = DataBindings[i].BindingMemberInfo.BindingField;
}
else if (string.Compare(DataBindings[i].PropertyName, "SelectedValue", StringComparison.OrdinalIgnoreCase) == 0)
{
tbl2 = DataBindings[i].BindingMemberInfo.BindingPath;
slValue = DataBindings[i].BindingMemberInfo.BindingField;
}
}
}
if (!string.IsNullOrEmpty(sIdx))
{
dbs.Append(sIdx);
}
if (!string.IsNullOrEmpty(tbl2))
{
if (dbs.Length > 0)
{
dbs.Append(";");
}
dbs.Append(tbl2);
dbs.Append(":");
dbs.Append(slItem);
dbs.Append(":");
dbs.Append(slValue);
}
if (dbs.Length > 0)
{
XmlUtil.SetAttribute(node, "jsdb", dbs.ToString());
}
if (this.AddBlankOnDataBinding)
{
XmlUtil.SetAttribute(node, "useblank", "true");
}
}
//
if (this.Items.Count == 0)
{
node.InnerText = "";
}
XmlElement xe = (XmlElement)node;
xe.IsEmpty = false;
}
public void CreateHtmlContent(XmlNode node, EnumWebElementPositionType positionType, int groupId)
{
XmlUtil.SetAttribute(node, "tabindex", this.TabIndex);
WebPageCompilerUtility.SetWebControlAttributes(this, node);
XmlNode okNode = node.OwnerDocument.CreateElement("img");
if (this.HideButtons)
{
XmlUtil.SetAttribute(okNode, "style", "display:none;cursor:pointer;");
}
else
{
XmlUtil.SetAttribute(okNode, "style", "display:inline;cursor:pointer;");
}
XmlUtil.SetAttribute(okNode, "onclick", string.Format(CultureInfo.InvariantCulture, "document.getElementById('{0}').jsData.onOK();", CodeName));
node.AppendChild(okNode);
bool b;
string imgFile = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "ok.png");
WebResourceFile wf = new WebResourceFile(imgFile, WebResourceFile.WEBFOLDER_Images, out b);
_resourceFiles.Add(wf);
if (b)
{
imgFile = wf.ResourceFile;
}
XmlUtil.SetAttribute(okNode, "src", string.Format(CultureInfo.InvariantCulture, "{0}/{1}", WebResourceFile.WEBFOLDER_Images, Path.GetFileName(imgFile)));
//
XmlNode spaceNode = node.OwnerDocument.CreateElement("span");
spaceNode.InnerText = " ";
node.AppendChild(spaceNode);
//
XmlNode cancelNode = node.OwnerDocument.CreateElement("img");
if (this.HideButtons)
{
XmlUtil.SetAttribute(cancelNode, "style", "display:none;cursor:pointer;");
}
else
{
XmlUtil.SetAttribute(cancelNode, "style", "display:inline;cursor:pointer;");
}
XmlUtil.SetAttribute(cancelNode, "onclick", string.Format(CultureInfo.InvariantCulture, "document.getElementById('{0}').jsData.onCancel();", CodeName));
imgFile = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "cancel.png");
wf = new WebResourceFile(imgFile, WebResourceFile.WEBFOLDER_Images, out b);
_resourceFiles.Add(wf);
if (b)
{
imgFile = wf.ResourceFile;
}
XmlUtil.SetAttribute(cancelNode, "src", string.Format(CultureInfo.InvariantCulture, "{0}/{1}", WebResourceFile.WEBFOLDER_Images, Path.GetFileName(imgFile)));
node.AppendChild(cancelNode);
//
spaceNode = node.OwnerDocument.CreateElement("span");
spaceNode.InnerText = " ";
node.AppendChild(spaceNode);
//
XmlNode chkAllNode = node.OwnerDocument.CreateElement("img");
if (this.HideButtons)
{
XmlUtil.SetAttribute(chkAllNode, "style", "display:none;cursor:pointer;");
}
else
{
XmlUtil.SetAttribute(chkAllNode, "style", "display:inline;cursor:pointer;");
}
XmlUtil.SetAttribute(chkAllNode, "onclick", string.Format(CultureInfo.InvariantCulture, "document.getElementById('{0}').jsData.selectAll();", CodeName));
imgFile = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "checkbox.png");
wf = new WebResourceFile(imgFile, WebResourceFile.WEBFOLDER_Images, out b);
_resourceFiles.Add(wf);
if (b)
{
imgFile = wf.ResourceFile;
}
XmlUtil.SetAttribute(chkAllNode, "src", string.Format(CultureInfo.InvariantCulture, "{0}/{1}", WebResourceFile.WEBFOLDER_Images, Path.GetFileName(imgFile)));
node.AppendChild(chkAllNode);
//
spaceNode = node.OwnerDocument.CreateElement("span");
spaceNode.InnerText = " ";
node.AppendChild(spaceNode);
//
chkAllNode = node.OwnerDocument.CreateElement("img");
if (this.HideButtons)
{
XmlUtil.SetAttribute(chkAllNode, "style", "display:none;cursor:pointer;");
}
else
{
XmlUtil.SetAttribute(chkAllNode, "style", "display:inline;cursor:pointer;");
}
XmlUtil.SetAttribute(chkAllNode, "onclick", string.Format(CultureInfo.InvariantCulture, "document.getElementById('{0}').jsData.selectNone();", CodeName));
imgFile = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "box.png");
wf = new WebResourceFile(imgFile, WebResourceFile.WEBFOLDER_Images, out b);
_resourceFiles.Add(wf);
if (b)
{
imgFile = wf.ResourceFile;
}
XmlUtil.SetAttribute(chkAllNode, "src", string.Format(CultureInfo.InvariantCulture, "{0}/{1}", WebResourceFile.WEBFOLDER_Images, Path.GetFileName(imgFile)));
node.AppendChild(chkAllNode);
//
XmlNode brNode = node.OwnerDocument.CreateElement("br");
node.AppendChild(brNode);
XmlNode lstNode = node.OwnerDocument.CreateElement("select");
node.AppendChild(lstNode);
XmlUtil.SetAttribute(lstNode, "id", string.Format(CultureInfo.InvariantCulture, "{0}_sel", CodeName));
for (int i = 0; i < _listBox.Items.Count; i++)
{
string v;
string s = VPLUtil.ObjectToString(_listBox.Items[i]);
if (!string.IsNullOrEmpty(s))
{
int n = s.IndexOf('|');
if (n >= 0)
{
v = s.Substring(n + 1).Trim();
s = s.Substring(0, n).Trim();
}
else
{
v = s;
}
}
else
{
v = string.Empty;
}
XmlElement oNode = node.OwnerDocument.CreateElement("option");
lstNode.AppendChild(oNode);
XmlUtil.SetAttribute(oNode, "value", v);
oNode.InnerText = s;
oNode.IsEmpty = false;
}
Graphics g = this.CreateGraphics();
SizeF sf = g.MeasureString("H", this.Font);
float h = (float)this.Height / sf.Height;
XmlUtil.SetAttribute(lstNode, "size", Convert.ToInt32(h + 1));
XmlUtil.SetAttribute(lstNode, "multiple", "multiple");
//
StringBuilder sblst = new StringBuilder();
StringBuilder sb = new StringBuilder();
//
sb.Append("background-color:");
sb.Append(ObjectCreationCodeGen.GetColorString(this.BackColor));
sb.Append("; ");
//
sb.Append("color:");
sb.Append(ObjectCreationCodeGen.GetColorString(this.ForeColor));
sb.Append("; ");
//
sblst.Append(sb.ToString());
sblst.Append(ObjectCreationCodeGen.GetFontStyleString(this.Font));
XmlUtil.SetAttribute(lstNode, "style", sblst.ToString());
//
WebPageCompilerUtility.CreateWebElementZOrder(this.zOrder, sb);
WebPageCompilerUtility.CreateElementPosition(this, sb, positionType);
WebPageCompilerUtility.CreateWebElementCursor(cursor, sb, false);
//
if (_dataNode != null)
{
XmlNode pNode = _dataNode.SelectSingleNode(string.Format(CultureInfo.InvariantCulture,
"{0}[@name='Visible']", XmlTags.XML_PROPERTY));
if (pNode != null)
{
string s = pNode.InnerText;
if (!string.IsNullOrEmpty(s))
{
try
{
b = Convert.ToBoolean(s, CultureInfo.InvariantCulture);
if (!b)
{
sb.Append("display:none; ");
}
}
catch
{
}
}
}
sb.Append(ObjectCreationCodeGen.GetFontStyleString(this.Font));
//
pNode = _dataNode.SelectSingleNode(string.Format(CultureInfo.InvariantCulture,
"{0}[@name='disabled']", XmlTags.XML_PROPERTY));
if (pNode != null)
{
string s = pNode.InnerText;
if (!string.IsNullOrEmpty(s))
{
try
{
b = Convert.ToBoolean(s, CultureInfo.InvariantCulture);
if (b)
{
XmlUtil.SetAttribute(node, "disabled", "disabled");
}
}
catch
{
}
}
}
}
XmlUtil.SetAttribute(node, "style", sb.ToString());
//
StringBuilder dbs = new StringBuilder();
if (this.DataBindings != null && this.DataBindings.Count > 0)
{
string tbl2 = null;
string sIdx = string.Empty;
string slItem = string.Empty;
string slValue = string.Empty;
for (int i = 0; i < DataBindings.Count; i++)
{
if (DataBindings[i].DataSource != null)
{
if (string.Compare(DataBindings[i].PropertyName, "SelectedIndex", StringComparison.OrdinalIgnoreCase) == 0)
{
sIdx = string.Format(CultureInfo.InvariantCulture, "{0}:{1}:SelectedIndex",
DataBindings[i].BindingMemberInfo.BindingPath, DataBindings[i].BindingMemberInfo.BindingMember);
}
else if (string.Compare(DataBindings[i].PropertyName, "SelectedItem", StringComparison.OrdinalIgnoreCase) == 0)
{
tbl2 = DataBindings[i].BindingMemberInfo.BindingPath;
slItem = DataBindings[i].BindingMemberInfo.BindingField;
}
else if (string.Compare(DataBindings[i].PropertyName, "SelectedValue", StringComparison.OrdinalIgnoreCase) == 0)
{
tbl2 = DataBindings[i].BindingMemberInfo.BindingPath;
slValue = DataBindings[i].BindingMemberInfo.BindingField;
}
}
}
if (!string.IsNullOrEmpty(sIdx))
{
dbs.Append(sIdx);
}
if (!string.IsNullOrEmpty(tbl2))
{
if (dbs.Length > 0)
{
dbs.Append(";");
}
dbs.Append(tbl2);
dbs.Append(":");
dbs.Append(slItem);
dbs.Append(":");
dbs.Append(slValue);
}
if (dbs.Length > 0)
{
XmlUtil.SetAttribute(lstNode, "jsdb", dbs.ToString());
}
}
if (_listBox.Items.Count == 0)
{
lstNode.InnerText = "";
}
XmlElement xe = (XmlElement)lstNode;
xe.IsEmpty = false;
}
public FieldList GetFields(string tbl)
{
FieldList flds = null;
if (_columns == null)
{
_columns = new Dictionary <string, FieldList>();
}
if (!_columns.TryGetValue(tbl, out flds))
{
if (bOpened)
{
DbDataReader dr = null;
string sSQL;
sSQL = string.Format(System.Globalization.CultureInfo.InvariantCulture,
"select COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,COLUMN_KEY,COLUMN_TYPE, EXTRA from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = '{0}' and TABLE_SCHEMA = '{1}' order by ORDINAL_POSITION", tbl, Schema);
DbCommand cmd = _connection.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = sSQL;
try
{
if (_connection.State == System.Data.ConnectionState.Closed)
{
_connection.Open();
}
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
flds = new FieldList();
int n = 0;
while (dr.Read())
{
EPField fld = new EPField();
fld.Name = (string)dr[0];
fld.Indexed = (string.CompareOrdinal("PRI", VPLUtil.ObjectToString(dr[3])) == 0);
fld.Index = n;
fld.FromTableName = tbl;
bool bUnsigned = (VPLUtil.ObjectToString(dr[4]).IndexOf("unsigned", StringComparison.OrdinalIgnoreCase) >= 0);
fld.OleDbType = stringToOleDbType(VPLUtil.ObjectToString(dr[1]), bUnsigned);
if (dr[2] != null && dr[2] != DBNull.Value)
{
fld.DataSize = VPLUtil.ObjectToInt(dr[2]);
}
fld.IsIdentity = (string.Compare("auto_increment", VPLUtil.ObjectToString(dr[5]), StringComparison.OrdinalIgnoreCase) == 0);
flds.Add(fld);
n++;
}
_columns.Add(tbl, flds);
}
finally
{
if (dr != null)
{
dr.Close();
dr = null;
}
if (_connection.State != System.Data.ConnectionState.Closed)
{
_connection.Close();
}
}
}
}
if (flds == null)
{
flds = new FieldList();
}
return(flds);
}
public PropertyDescriptorCollection GetProperties(Attribute[] attributes)
{
PropertyDescriptorCollection ps = TypeDescriptor.GetProperties(this, attributes, true);
List <PropertyDescriptor> list = new List <PropertyDescriptor>();
foreach (PropertyDescriptor p in ps)
{
if (IsDataOnly)
{
PropertyDescriptorForDisplay p0 = new PropertyDescriptorForDisplay(this.GetType(), p.Name, VPLUtil.ObjectToString(p.GetValue(this)), attributes);
list.Add(p0);
}
else
{
list.Add(p);
}
}
ps = new PropertyDescriptorCollection(list.ToArray());
return(ps);
}
public PropertyDescriptorCollection GetProperties(Attribute[] attributes)
{
PropertyDescriptorCollection ps = TypeDescriptor.GetProperties(this, attributes, true);
List <PropertyDescriptor> list = new List <PropertyDescriptor>();
bool isString = typeof(string).Equals(_type);
if (IsDataOnly)
{
foreach (PropertyDescriptor p in ps)
{
if ((string.CompareOrdinal(p.Name, "DefaultData") == 0) || (string.CompareOrdinal(p.Name, "DataType") == 0))
{
PropertyDescriptorForDisplay p0 = new PropertyDescriptorForDisplay(this.GetType(), p.Name, VPLUtil.ObjectToString(p.GetValue(this)), attributes);
list.Add(p0);
}
}
}
else
{
if (isString)
{
PropertyDescriptor[] a = new PropertyDescriptor[ps.Count];
ps.CopyTo(a, 0);
list.AddRange(a);
}
else
{
//remove Encrypted if not a string value
foreach (PropertyDescriptor p in ps)
{
if (string.CompareOrdinal(p.Name, "Encrypted") != 0)
{
list.Add(p);
}
}
}
}
PropertyInfo pif = typeof(ConfigProperty).GetProperty("DefaultData");
PropertyDescriptorValue pv = new PropertyDescriptorValue("Data", attributes, pif, _type, typeof(ConfigProperty));
list.Add(pv);
ps = new PropertyDescriptorCollection(list.ToArray());
return(ps);
}
