C# 自定义控件字段绑定示例

自定义控件的编辑框引用自Devexpress的TextEdit控件.定义了两个DataSet类型,一个存放记录数据源,一个存放字段数据源 主界面调用字段界面时取两个数据源, ds为记录数据源 dm为字段数据源 SysData.DataHelper myHelper = new SysData.DataHelper(); Hashtable ht = new Hashtable(); ht.Add("@id", -1); DataSet ds = myHelper.GetDs(strSQL, ht); DataSet dm = myHelper.GetDs(strSQL, ht,true); BinSource.DataSource = ds.Tables[0]; DBClass.BindControl(gBox, BinSource.DataSource,dm.Tables[0]); blnBind = true; </pre></div><div style="font-family:Arial; font-size:14px; line-height:22.4px">DBEdit自定义控件的字段绑定方式其中Mask.EditMask的设置尚未处理完成<pre name="code" class="csharp"> txtEdit.DataBindings.Clear(); txtEdit.DataBindings.Add("EditValue", DataSource, DataField); DataTable dt = (DataTable)DataSchema; //判断字段类型,小数/整数/文本 foreach (DataColumn dc in dt.Columns) { if (dc.Caption == DataField) { //判断是否为空 Request = dc.AllowDBNull; if (Request) label.ForeColor = Color.Black; else label.ForeColor = Color.Red; //设置最大长度 txtEdit.Properties.MaxLength = dc.MaxLength; //设置输入格式 if (dc.DataType == typeof(int) || dc.DataType == typeof(Int16) || dc.DataType == typeof(Int32) || dc.DataType == typeof(Int64)) { txtEdit.Properties.Mask.EditMask = ""; txtEdit.Properties.Mask.MaskType = MaskType.Numeric; } else if (dc.DataType == typeof(string)) { txtEdit.Properties.Mask.MaskType = MaskType.Simple; } //double类型会映射为decimal,待验证 else if (dc.DataType == typeof(Single) || dc.DataType == typeof(double) || dc.DataType == typeof(Decimal)) { txtEdit.Properties.Mask.EditMask = ""; txtEdit.Properties.Mask.MaskType = MaskType.Numeric; } //其他类型暂不处理,待验证 //else MessageBox.Show("Other"+dc.DataType.Name); } } DataHelper调用源码,此方式为Remoting与WebService的中间件调用 /// <summary> /// 带参数SQL,并返回结果数据集 /// </summary> /// <param name="strSQL">查询语句</param> /// <param name="parm">参数</param> /// <param name="Schema">是否返回字段映射表</param> /// <returns></returns> public DataSet GetDs(string strSQL, Hashtable parm, bool Schema=false) { string err = ""; if (SysData.SysParam.intConnect == 0) { ChimService.Service myService = GetService(); byte[] bytes = DataSetCompression.SerializeData(parm); byte[] bUserData = myService.GetOtherByte(ref err, SysData.SysParam.strDB, strSQL, bytes, Schema); if (err != "") { MessageBox.Show(err, "错误"); err = ""; return null; } DataSet ds = DataSetCompression.DecompressionDataSet(bUserData); return ds; } else { CenterLib.Service obj = GetObj(); byte[] bUserData = obj.GetOtherByte(ref err, SysData.SysParam.strDB, strSQL, parm); if (err != "") { MessageBox.Show(err, "错误"); err = ""; return null; } DataSet ds = DataSetCompression.DecompressionDataSet(bUserData); return ds; } } SQLHelper调用参考         /// <summary> /// 执行SQL命令 带命令类型 带参数 返回Dataset /// </summary> /// <param name="connection">SQL连接对象</param> /// <param name="commandType">命令类型</param> /// <param name="commandText">SQL语句</param> /// <param name="commandParameters">参数</param> /// <returns></returns> public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText, bool Schema = false, params SqlParameter[] commandParameters) //3 { SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, connection, null, commandType, commandText, commandParameters); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); <pre name="code" class="csharp" style="font-size: 14px; line-height: 22.4px;"><span style="white-space:pre"> </span> da.Fill(ds); if (Schema) da.FillSchema(ds, SchemaType.Mapped); cmd.Parameters.Clear(); return ds; }