首页 > 代码库 > ORM框架(ITDOS实战源码)
ORM框架(ITDOS实战源码)
ORM提供了实现持久化层的另一种模式,它采用映射元数据来描述对象关系的映射,使得ORM中间件能在任何一个应用的业务逻辑层和数据库层之间充当桥梁。
如以下示例:
1 public int GetSystemAccreditMessageInfo(AccreditParam param) 2 { 3 var where = new Where<User>(); 4 var countMesage = 0;//记录提醒次数 5 HttpCookie cookie = HttpContext.Current.Request.Cookies["UserLogin"] as HttpCookie; 6 if (cookie["Login_id"] != null) 7 { 8 where.And(d => d.id == cookie["Login_id"].ToString()); 9 }10 where.And(d => d.Del_state == 0);11 var fs = DB.Context.From<User>()12 .Select(User._.All, Power._.All)13 .InnerJoin<Power>((a, b) => a.Role_id == b.id)14 .Where(where);15 if (fs.First().Authority == "0")16 {17 countMesage = 0;18 }19 else if (fs.First().Authority == "1")20 {21 countMesage = DB.Context.From<Accredit>().Where(d => d.OAuditor_signature == null || d.OAuditor_signature == "").Count();22 }23 else if (fs.First().Authority == "2")24 {25 countMesage = DB.Context.From<Accredit>().Where(d => d.TAuditor_signature == null || d.TAuditor_signature == "").Count();26 }27 else if (fs.First().Authority == "3")28 {29 countMesage = DB.Context.From<Accredit>().Where(d => d.OAuditor_signature == null || d.OAuditor_signature == "" || d.TAuditor_signature == null || d.TAuditor_signature == "").Count();30 }31 return countMesage;32 }
1 public BaseResult AddAccreditInfo(AccreditParam param) 2 { 3 var model = new Accredit(); 4 model.id = Guid.NewGuid().ToString(); 5 model.Acceptance_number = param.Acceptance_number; 6 model.Certificate_number = param.Certificate_number; 7 model.Issuing_office = param.Issuing_office; 8 model.Issue_date = param.Issue_date; 9 model.Effective_date = param.Effective_date;10 model.Authorization_projectname = param.Authorization_projectname;11 model.Measuring_range = param.Measuring_range;12 model.Accuracy = param.Accuracy;13 model.Organization_name = param.Organization_name;14 model.Address = param.Address;15 model.Corporate_representative = param.Corporate_representative;16 model.Leading_person = param.Leading_person;17 model.Competent_department = param.Competent_department;18 model.Authorized_area = param.Authorized_area;19 model.Authorization_form = param.Authorization_form;20 model.Approver = param.Approver;21 model.Input_person = param.Input_person;22 model.Input_unit = param.Input_unit;23 model.Acceptance_date = param.Acceptance_date;24 HttpCookie cookie = HttpContext.Current.Request.Cookies["UserLogin"] as HttpCookie;25 if (cookie["OrgId"] != null)26 {27 model.OrgId = cookie["OrgId"].ToString();28 }29 if (cookie["OrgId"]=="63001c38-afa4-4a06-567d-0f39b6b5ca9b")30 {31 model.Processing_state = 0;32 }33 model.Remarks = param.Remarks;34 model.Del_state = 0;35 model.Time = DateTime.Now;36 //model.Processing_state = param.Processing_state;37 model.brand = param.brand;38 var count = DB.Context.Insert<Accredit>(model);39 return new BaseResult(true, model, "", count);40 }
1 public BaseResult UptAccreditInfo(AccreditParam param) 2 { 3 var result = GetUpdateModel(param); 4 if (!result.IsSuccess) 5 return result; 6 7 var model = (Accredit)result.Data; 8 model.Acceptance_number = param.Acceptance_number; 9 model.Certificate_number = param.Certificate_number;10 model.Issuing_office = param.Issuing_office;11 model.Issue_date = param.Issue_date;12 model.Effective_date = param.Effective_date;13 model.Authorization_projectname = param.Authorization_projectname;14 model.Measuring_range = param.Measuring_range;15 model.Accuracy = param.Accuracy;16 model.Organization_name = param.Organization_name;17 model.Address = param.Address;18 model.Corporate_representative = param.Corporate_representative;19 model.Leading_person = param.Leading_person;20 model.Competent_department = param.Competent_department;21 model.Authorized_area = param.Authorized_area;22 model.Authorization_form = param.Authorization_form;23 model.Approver = param.Approver;24 model.Input_person = param.Input_person;25 model.Input_unit = param.Input_unit;26 HttpCookie cookie = HttpContext.Current.Request.Cookies["UserLogin"] as HttpCookie;27 if (cookie["OrgId"] != null)28 {29 model.OrgId = cookie["OrgId"].ToString();30 }31 if (cookie["OrgId"] == "63001c38-afa4-4a06-567d-0f39b6b5ca9b")32 {33 model.Processing_state = 0;34 }35 model.Acceptance_date = param.Acceptance_date;36 model.Remarks = param.Remarks;37 model.Del_state = 0;38 //model.Processing_state = param.Processing_state??model.Processing_state;39 model.Time = DateTime.Now;40 model.brand = param.brand;41 var count = DB.Context.Update(model, d => d.id == param.id);42 return new BaseResult(true, model, "", count);43 }
ORM框架(ITDOS实战源码)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。