HelloData数据框架,基础类集
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;
}
}