HelloData數(shù)據(jù)框架,基礎(chǔ)類集
v1.2版本發(fā)布,修復(fù)了動(dòng)態(tài)試圖生成的bug,修復(fù)了無法正常分頁的錯(cuò)誤;將基礎(chǔ)操作類單獨(dú)分離出來.....
詳情請(qǐng)?jiān)L問:https://github.com/xiaose1205/HelloData
自定義的sql書寫模式,與數(shù)據(jù)庫交互更加便捷,有生成實(shí)體類的t4模版,sqlite內(nèi)存數(shù)據(jù)庫(效率比較高) 多個(gè)數(shù)據(jù)庫同時(shí)操作(不區(qū)分?jǐn)?shù)據(jù)庫累心) url重寫 多區(qū)域語言(頁面自動(dòng)生成,無需更多的代碼) redis分布式緩存 webcache緩存 。框架可以擴(kuò)展。異常捕捉,調(diào)試更加方便
///
/// 自定義視圖
///
public cms_user viewtestModel()
{
using (SelectAction action = new SelectAction(""))
{
action.SqlClomns = "_cms_user.*,_cms_manager.name as managername";
{
//添加視圖的關(guān)聯(lián)關(guān)系
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;
}
}
///
/// 刪除多個(gè)數(shù)據(jù)
///
///
///
internal int DeleteMuilt(string ids)
{
//第一個(gè)數(shù)據(jù)庫的操作
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;
}
//第二個(gè)數(shù)據(jù)庫的操作
using (DeleteAction delete = new DeleteAction(Entity, 1))
{
delete.SqlWhere(cms_user.Columns.id, ids, RelationEnum.In);
delete.Excute();
return delete.ReturnCode;
}
}
