v1.2版本发布,修复了动态试图生成的bug,修复了无法正常分页的错误;将基础操作类单独分离出来.....
详情请访问:https://github.com/xiaose1205/HelloData
自定义的sql书写模式,与数据库交互更加便捷,有生成实体类的t4模版,sqlite内存数据库(效率比较高) 多个数据库同时操作(不区分数据库累心) url重写 多区域语言(页面自动生成,无需更多的代码) redis分布式缓存 webcache缓存 。框架可以扩展。异常捕捉,调试更加方便
/// /// 自定义视图 /// public cms_user viewtestModel() { using (SelectAction action = new SelectAction(“”)) { action.SqlClomns = “_cms_user.*,_cms_manager.name as managername”; { //添加视图的关联关系 List field = new List(); field.Add(new WhereField() { FiledName = “mangerid”, Condition = ConditionEnum.And, Value = “id” }); action.AddJoin(ViewJoinEnum.leftjoin, “cms_user”, “cms_manager”, field); }
action.SqlWhere(cms_user.Columns.username, “admin”); action.SqlWhere(cms_user.Columns.password, “123456”); PageList lists= action.QueryPage(1); return null; } }
/// /// 删除多个数据 /// /// /// internal int DeleteMuilt(string ids) { //第一个数据库的操作 using (DeleteAction delete = new DeleteAction(Entity, 0)) { delete.SqlWhere(cms_user.Columns.id, “1,2,3,4,5”, RelationEnum.In); delete.Excute(); return delete.ReturnCode; } //第二个数据库的操作 using (DeleteAction delete = new DeleteAction(Entity, 1)) { delete.SqlWhere(cms_user.Columns.id, ids, RelationEnum.In); delete.Excute(); return delete.ReturnCode; } }