不使用反射，“一行代码”实现Web、WinForm窗体表单数据的填充、收集、清除，和到数据库的CRUD

        /// <summary>
    /// 数据映射控件接口
    /// </summary>
    public interface IDataControl
    {
        
        /// <summary>
        /// 与数据库数据项相关联的数据
        /// </summary>
        string LinkProperty
        {
            get;
            set;
        }
        
        /// <summary>
        /// 与数据关联的表名
        /// </summary>
        string LinkObject
        {
            get;
            set;
        }

        /// <summary>
        /// 是否通过服务器验证默认为true
        /// </summary>
        bool IsValid
        {
            get;
        }



        /// <summary>
        /// 数据类型
        /// </summary>
        TypeCode SysTypeCode
        {
            get;
            set;
        }

        /// <summary>
        /// 只读标记
        /// </summary>
        bool ReadOnly
        {
            get;
            set;
        }

        
        /// <summary>
        /// 是否允许空值
        /// </summary>
        bool isNull
        {
            get;
        }

        /// <summary>
        /// 是否是主键
        /// </summary>
        bool PrimaryKey
        {
            get;
            set;
                                  }



        /// <summary>
        /// 设置值
        /// </summary>
        /// <param name="obj"></param>
        void SetValue(object value);

        /// <summary>
        /// 获取值
        /// </summary>
        /// <returns></returns>
        object GetValue();

        /// <summary>
        /// 服务端验证
        /// </summary>
        /// <returns></returns>
        bool Validate();

    }

public partial class DataCalendar : DateTimePicker, IDataControl
{
//数据日历控件
}

public partial class DataCheckBox : CheckBox, IDataControl
{
//数据复选框控件
}

public partial class DataDropDownList : ComboBox, IDataControl
{
//数据下拉选择框控件
}

public class DataLabel : Label, IDataControl
{
//数据标签控件
}

public partial class DataListBox : ListBox, IDataControl
{
//数据列表框控件
}

public partial class DataRadioButton : RadioButton, IDataControl
{
//数据选项按钮控件
}

public class DataTextBox : TextBox, IDataTextBox
{
//数据文本框控件
}

DataTextBox dtb=new DataTextBox();
dtb.SetValue("text1");
string value=dtb.GetValue().ToString();//text1

       public void SetValue(object obj)
        {
            if (obj == null || obj.ToString() == "")
            {
                this.Text = "";
                return;
            }
            //其它检测和格式控制代码略
            this.Text = obj.ToString().Trim();
        }

        public object GetValue()
        {
           //其它检测和格式控制代码略
            return this.Text.Trim();
        }

string LinkProperty{get;set;}//对应字段名或者实体类的属性名
string LinkObject{get;set;}//对应表名或者实体类的类名称

private void btnCreateDB_Click(object sender, EventArgs e)
        {
            string dbpath = Application.StartupPath + "\\TEST.mdb";
            if (!File.Exists(dbpath))
            {
                //创建数据库文件
                PWMIS.AccessExtensions.AccessUility.CreateDataBase(dbpath);
                //创建表
                Access access = new Access();
              access.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + dbpath;

              PWMIS.AccessExtensions.AccessUility.CreateTable(access, new User());
                //配置连接
                PWMIS.AccessExtensions.AccessUility.ConfigConnectionSettings("AccessConn", dbpath);

                MessageBox.Show("创建数据成功！");
                this.btnInsert.Enabled = true;
                this.btnUpdate.Enabled = true;
                this.btnDelete.Enabled = true;
            }
            else
            {
                MessageBox.Show("数据库已经创建过了，如需重新创建，请先删除数据库文件。");
            }
           
        }

 PWMIS.AccessExtensions.AccessUility.CreateTable(access, new User());

public class User:EntityBase
    {
        public User()
        {
            this.TableName = "会员用户表";
            this.IdentityName = "标识";
            this.PrimaryKeys.Add("标识");
        }

        protected override void SetFieldNames()
        {
            PropertyNames = new string[] {"标识","用户名","用户类型","注册时间","消费金额" };
        }

        public int UserID
        {
            get { return getProperty<int>("标识"); }
            set { setProperty("标识", value); }
        }

        public string UserName
        {
            get { return getProperty<string>("用户名"); }
            set { setProperty("用户名", value, 50); }
        }

        public int UserType
        {
            get { return getProperty<int>("用户类型"); }
            set { setProperty("用户类型", value); }
        }


        public DateTime RegisterDate
        {
            get { return getProperty<DateTime>("注册时间"); }
            set { setProperty("注册时间", value); }
        }

        public Single Expenditure
        {
            get { return getProperty<Single>("消费金额"); }
            set { setProperty("消费金额", value); }
        }
    }

 List<User> list = OQL.From<User>().Select().END.ToList<User>();
this.dataGridView1.DataSource =list;

 User user = this.dataGridView1.CurrentRow.DataBoundItem as User;
 EntityQuery<User>.Instance.Update(user);

 private void btnSubmit_Click(object sender, EventArgs e)
{
  //前面检查数据的代码略
   var ibCommandList = MyWinForm.Instance.AutoUpdateIBFormData(this.Controls);
}

  private void btnClear_Click(object sender, EventArgs e)
        {
            WinFormControlDataMap.ClearData(this.Controls);
        }

 private BindingList<User> UserBindingList = new BindingList<User>();
//填充集合的代码，就是将数据从数据库查询出来，然后放到该集合中，代码略
this.dataGridView1.DataSource = UserBindingList;

public abstract class EntityBase : INotifyPropertyChanged, IEntity, ICloneable
{
//... 略
}

 Form1 form1 = this.Owner as Form1;
 User user = form1.GetUserByID(int.Parse(dlbUID.Text));
 //收集数据到实体类中
WinFormControlDataMap.CollectDataToEntityClass(user, this.Controls);