Nice.DataAccess

Nuget Package Manager

Install-Package Nice.DataAccess -Version x.x.x      

1、程序启动，创建数据库操作对象

   DataUtil.Create(new DatabaseConfig()
   {
      ConnString = Configuration["ConnString"],
      ProviderName = Configuration["ProviderName"]
   });

2、实体层为实体和属性添加特性(Attribute)

 [Table(Name = "tbl_user_info")]        
 public class UserInfo:TEntity       
 {      
       [Id(GenerateType = IdGenerateType.Assign)]   
       public string UserId { get; set; }   
       public string UserName { get; set; }  
       ........
       [Column(IsReadOnly = true)]
       public DateTime CreateTime { get; set; }
       [Valid(1, 0)]
       [Column(Name = "nState")]
       public byte NState { get; set; }
       ........
  }          

3、初始化DAL操作对象

private GeneralDAL<UserInfo> dal = DALFactory<UserInfo>.Create();   

4、操作实体对象

 public bool Insert(UserInfo entity)
 {
     return dal.Insert(entity);
 }
 public bool Update(UserInfo entity)
 {
     return dal.Update(entity);
 }
 public bool UpdateState(UserInfo entity)
 {
    return dal.Update(entity, o => o.NState, o => o.ModifyTime);
 }
 public bool Delete(string UserId)
 {
    return dal.Delete(UserId);
 }
 public bool VirtualDelete(string UserId)
 {
     return dal.VirtualDelete(UserId);
 }
 public UserInfo Get(string UserId)
 {
     return dal.Get(UserId);
 }
 public UserInfo GetByName(string UserName)
 {
    return dal.Get(o => o.UserName == UserName);
 }
 public IList<UserInfo> GetList()
 {
    return dal.GetList();
 }
 public IList<UserInfo> GetList(PageInfo page)
 {
    return dal.GetList(page);
 }
 public bool IsExists(string PropertyName, object PropertyValue, object IdValue)
 {
     return dal.IsExist(PropertyName, PropertyValue, IdValue);
 }
 public string GetMaxId()
 {
     return dal.Max<string>(false);
 }

5、SQL操作

 //private  QueryDAL<InfraElementInfo> query = new QueryDAL<InfraElementInfo>();
 private QueryDAL<InfraElementInfo> query = QueryDALFactory<InfraElementInfo>.Create();
 
 public IList<InfraElementInfo> GetListByRoleId(int RoleId)
 {
       StringBuilder sb = new StringBuilder();
       sb.Append(" select * from infra_element_info e,sys_role_data r ");
       sb.Append(" WHERE e.ElementId=r.DataId and r.DataType=1");
       sb.Append(" and r.RoleId=@RoleId");

       return query.GetListBySQL(sb.ToString(),new IDataParameter[] 
       {
          DataUtil.GetDataHelper().CreateParameter("@RoleId",RoleId)
       });
 }
 
 public IList<InfraElementInfo> GetListByRoleId(int RoleId)
 {
       StringBuilder sb = new StringBuilder();
       sb.Append(" select * from infra_element_info e,sys_role_data r ");
       sb.Append(" WHERE e.ElementId=r.DataId and r.DataType=1");
       sb.Append(" and r.RoleId=?");

       return query.GetListBySQL2(sb.ToString(),new object[] { RoleId });
 }