MSFrame 1.1.0

You can Make a BaseModel and basic base class like this:

using System; using System.Data; using System.Collections.Generic; using MSFrame; namespace Enterprise.Base

{ #region TBConfigBase public partial class TBConfigBase : BaseCore { #region Base public bool Exists(string ID) { OQL q=new OQL(); q.Add(TBConfigModel.Fields.ID,ID); return ORMUtil.Exists<TBConfigModel>(q); } public bool Exists(OQL q) { return ORMUtil.Exists<TBConfigModel>(q); } public int GetCount(OQL q) { return ORMUtil.GetCount<TBConfigModel>(q); } public object GetScalar(OQL q) { return ORMUtil.GetScalar<TBConfigModel>(q); } public string GetScalarString(OQL q) { return StringPlus.Get(ORMUtil.GetScalar<TBConfigModel>(q)); } public bool Insert(TBConfigModel model, bool debug = false) { return ORMUtil.Insert<TBConfigModel>(model,debug); } public bool Update(TBConfigModel model, bool debug = false) { return ORMUtil.Update<TBConfigModel>(model,debug); } public bool Update(OQL q) { return ORMUtil.Update<TBConfigModel>(q); } public bool Delete(TBConfigModel model, bool debug = false) { return ORMUtil.Delete<TBConfigModel>(model,debug); } public bool Delete(string ID) { OQL q=new OQL(); q.Add(TBConfigModel.Fields.ID,ID); return ORMUtil.Delete<TBConfigModel>(q); } public bool Delete(OQL q) { return ORMUtil.Delete<TBConfigModel>(q); } public TBConfigModel GetModel(string ID) { OQL q=new OQL(); q.Add(TBConfigModel.Fields.ID,ID); return ORMUtil.GetModel<TBConfigModel>(q); } public TBConfigModel GetModel(OQL q) { return ORMUtil.GetModel<TBConfigModel>(q); } public List<TBConfigModel> GetList(OQL q) { return ORMUtil.GetList<TBConfigModel>(q); } public List<TBConfigModel> GetList(DataTable dt) { return ORMUtil.GetList<TBConfigModel>(dt); } public List<TBConfigModel> GetPageList(OQL q) { return ORMUtil.GetPageList<TBConfigModel>(q); }

    public DataTable GetDataTable(OQL q)
    {
        return ORMUtil.GetDataTable<TBConfigModel>(q);
    }

    public DataTable GetPageDataTable(OQL q)
    {
        return ORMUtil.GetPageDataTable<TBConfigModel>(q);
    }
    public DataTable GetPageTable(OQL q)
    {
        return  ORMUtil.GetPageTable<TBConfigModel>(q);
    }

#endregion

}
#endregion

 #region  TBConfigModel
 [TableAttr(Name = "TBConfig", PrimaryKey = "ID",Description="")]
 public class TBConfigModel : BaseModel
 {

     #region  TBConfigFields
     public class Fields
     {
         public const string Table = "TBConfig";
         /// <summary>
         /// ID
         /// </summary>
         public const string ID = "ID";
         /// <summary>
         /// LocationID
         /// </summary>
         public const string LocationID = "LocationID";
     }
     #endregion
     private String _id ="";
     /// <summary>
     /// ID
     /// </summary>
     [FieldAttr(Name = "ID", IsKey = true, Length = 20, IsRequire = true, DbType = "nvarchar", Description="ID", IsIdentity=false, DefaultValue="")]
     public String ID
     {
         get{ return _id; }
         set{ _id = value; 
             Set("ID"); 
         }
     }

     private String _locationid ="";
     /// <summary>
     /// LocationID
     /// </summary>
     [FieldAttr(Name = "LocationID", IsKey = false, Length = 20, IsRequire = false, DbType = "nvarchar", Description="LocationID", IsIdentity=false, DefaultValue="")]
     public String LocationID
     {
         get{ return _locationid; }
         set{ _locationid = value; 
             Set("LocationID"); 
         }
     }

 }

#endregion }