基于.net EF6 MVC5+WEB Api 的Web系统框架总结（2）-业务项目搭建

本节将介绍如何进行业务项目搭建。

本业务项目示例是简单的企业信息管理功能，业务项目采用code first方式，搭建包括：

1. 创建实体项目
2. 创建实体数据表映射
3. 创建业务处理项目
4. 创建业务web项目

搭建完项目效果：

1、创建实体项目-shiquan.company.entity

创建企业信息实体

示例中企业信息包括：编号、名称、负责人、联系人、联系电话、联系地址等

using system;
using system.collections.generic;
using system.componentmodel.dataannotations;
using system.linq;
using system.text;
using system.threading.tasks;

namespace shiquan.company.entity
{
    /// <summary>
    /// 企业信息
    /// </summary>
    public class companyinfoentity:basiccompanyentity
    {
        /// <summary>
        /// 编号
        /// </summary>
        [display(name = "编号"), maxlength(50)]
        public string code { get; set; }
        /// <summary>
        /// 编号
        /// </summary>
        [display(name = "编号"), maxlength(100)]
        public string name { get; set; }
        /// <summary>
        /// 负责人
        /// </summary>
        [display(name = "负责人"), maxlength(50)]
        public string leader { get; set; }
        /// <summary>
        /// 联系人
        /// </summary>
        [display(name = "联系人"), maxlength(50)]
        public string linkman { get; set; }
        /// <summary>
        /// 联系电话
        /// </summary>
        [display(name = "联系电话"), maxlength(50)]
        public string phone { get; set; }
        /// <summary>
        /// 联系地址
        /// </summary>
        [display(name = "联系地址"), maxlength(255)]
        public string address { get; set; }
        /// <summary>
        /// 备注说明
        /// </summary>
        [display(name = "备注说明"), maxlength(255)]
        public string remark { get; set; }
    }
}

 

2、创建实体数据表映射项目-shiquan.company.mapping

创建空数据库

创建项目

创建企业信息数据表映射

using shiquan.company.entity;
using system;
using system.collections.generic;
using system.data.entity.modelconfiguration;
using system.linq;
using system.text;
using system.threading.tasks;

namespace shiquan.company.mapping
{
    /// <summary>
    /// 实体数据映射
    /// </summary>
    public class companyinfomap : entitytypeconfiguration<companyinfoentity>
    {
        public companyinfomap()
        {
            #region 表、主键
            //表
            this.totable("companyinfo");
            //主键
            this.haskey(t => t.id);
            #endregion

            #region 配置关系
            #endregion
        }
    }
}

创建实体数据库上下文

选择空code first 模型

namespace shiquan.company.mapping
{
    using system;
    using system.data.entity;
    using system.data.entity.modelconfiguration.conventions;
    using system.linq;

    public class companydbcontext : dbcontext
    {
        //您的上下文已配置为从您的应用程序的配置文件(app.config 或 web.config)
        //使用“companydbcontext”连接字符串。默认情况下，此连接字符串针对您的 localdb 实例上的
        //“shiquan.company.mapping.companydbcontext”数据库。
        // 
        //如果您想要针对其他数据库和/或数据库提供程序，请在应用程序配置文件中修改“companydbcontext”
        //连接字符串。
        public companydbcontext()
            : base("name=companydbcontext")
        {
        }

        //为您要在模型中包含的每种实体类型都添加 dbset。有关配置和使用 code first  模型
        //的详细信息，请参阅 http://go.microsoft.com/fwlink/?linkid=390109。

        // public virtual dbset<myentity> myentities { get; set; }
        /// <summary>
        /// 重写数据型号创建，添加企业信息数据表映射
        /// </summary>
        /// <param name="modelbuilder"></param>
        protected override void onmodelcreating(dbmodelbuilder modelbuilder)
        {
            modelbuilder.conventions.remove<pluralizingtablenameconvention>();
            
            modelbuilder.configurations.add(new companyinfomap());

            base.onmodelcreating(modelbuilder);
        }
    }
}

 

配置数据库连接

  <connectionstrings>
    <add name="companydbcontext" connectionstring="server=127.0.0.1;initial catalog=vsd_companydb;user id=sa;password=123456*a" providername="system.data.sqlclient" />
  </connectionstrings>

配置数据库上下文允许进行更新升级

using system;
using system.collections.generic;
using system.data.entity.migrations;
using system.linq;
using system.text;
using system.threading.tasks;

namespace shiquan.company.mapping.migrations
{
    internal sealed class configuration : dbmigrationsconfiguration<companydbcontext>
    {
        public configuration()
        {
            //配置允许数据库更新升级
            automaticmigrationsenabled = true;
            automaticmigrationdatalossallowed = true;
        }

        protected override void seed(companydbcontext dbcontext)
        {
            
        }
    }
}

 

使用update-database 对数据库进行升级更新

 

3、创建企业信息管理业务处理项目-shiquan.company.business

创建企业信息库业务处理基础类，实现实体查询、删除和保存功能。

using learun.database.repository;
using learun.util;
using shiquan.company.entity;
using system;
using system.collections.generic;
using system.configuration;
using system.data;
using system.linq;
using system.linq.expressions;
using system.text;
using system.threading.tasks;

namespace shiquan.company.business
{
    /// <summary>
    /// 企业信息管理库业务处理基础类
    /// </summary>
    /// <typeparam name="t"></typeparam>
    public class basiccompanybll<t> : repositoryfactory<t> where t : class,new()
    {
        protected string dbconn = "";

        /// <summary>
        /// 构造函数
        /// </summary>
        public basiccompanybll()
        {
            //this.dbconn = configurationmanager.connectionstrings["companydbcontext"].connectionstring;
            this.dbconn = "companydbcontext";
        }
        #region 获取数据
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="pagination">分页</param>
        /// <param name="queryjson">查询参数</param>
        /// <returns>返回分页列表</returns>
        public virtual ienumerable<t> getpagelist(pagination pagination, string queryjson)
        {
            var expression = linqextensions.true<t>();
            expression = querystringtoexpression(expression, queryjson);
            return this.baserepository(dbconn).findlist(expression, pagination);
        }
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="pagination">分页</param>
        /// <param name="queryjson">查询参数</param>
        /// <returns>返回分页列表</returns>
        public virtual ienumerable<t> getpagelist(pagination pagination, expression<func<t, bool>> linq)
        {
            return this.baserepository(dbconn).findlist(linq, pagination);
        }
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="queryjson">查询参数</param>
        /// <returns>返回列表</returns>
        public virtual ienumerable<t> getlist(string queryjson)
        {
            var expression = linqextensions.true<t>();
            expression = querystringtoexpression(expression, queryjson);
            return this.baserepository(dbconn).iqueryable(expression);
        }
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="queryjson">查询参数</param>
        /// <returns>返回列表</returns>
        public virtual iqueryable<t> getlist(expression<func<t, bool>> linq)
        {
            return this.baserepository(dbconn).iqueryable(linq);
        }
        /// <summary>
        /// 获取实体
        /// </summary>
        /// <param name="keyvalue">主键值</param>
        /// <returns></returns>
        public virtual t getentity(string keyvalue)
        {
            return this.baserepository(dbconn).findentity(keyvalue);
        }

        /// <summary>
        /// 根据条件获取实体
        /// </summary>
        /// <param name="linq">linq条件</param>
        /// <returns></returns>
        public virtual t findentity(expression<func<t, bool>> linq)
        {
            return this.baserepository(dbconn).findentity(linq);
        }
        /// <summary>
        /// 获取数据
        /// </summary>
        /// <param name="queryjson"></param>
        /// <returns></returns>
        public virtual datatable gettable(string queryjson)
        {
            string sql = getsql(queryjson);
            return this.baserepository(dbconn).findtable(sql);
        }
        /// <summary>
        /// 获取数据
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public virtual datatable gettablebysql(string sql)
        {
            //string sql = getsql(queryjson);
            return this.baserepository(dbconn).findtable(sql);
        }
        /// <summary>
        /// 获取分页列表,返回datatable
        /// </summary>
        /// <param name="queryjson">查询参数</param>
        /// <returns>返回列表</returns>
        public virtual datatable getpagetable(pagination pagination, string queryjson)
        {
            string sql = getsql(queryjson);
            return this.baserepository(dbconn).findtable(sql, pagination);
        }
        /// <summary>
        /// 获取分页列表,返回datatable
        /// </summary>
        /// <param name="sql">查询参数</param>
        /// <returns>返回列表</returns>
        public virtual datatable getpagetablebysql(pagination pagination, string sql)
        {
            //string sql = getsql(queryjson);
            return this.baserepository(dbconn).findtable(sql, pagination);
        }
        #endregion

        #region 提交数据
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="keyvalue">主键</param>
        public virtual void removeform(string keyvalue)
        {
            string[] dels = keyvalue.split(',');
            if (dels.length > 1)
            {
                irepository db = new repositoryfactory().baserepository(dbconn).begintrans();
                try
                {
                    foreach (var item in dels)
                    {
                        db.delete(item);
                    }
                    db.commit();
                }
                catch (exception)
                {
                    db.rollback();
                    throw;
                }
            }
            else
            {
                this.baserepository(dbconn).delete(keyvalue);
            }
        }
        /// <summary>
        /// 保存表单（新增、修改）
        /// </summary>
        /// <param name="keyvalue">主键值</param>
        /// <param name="entity">实体对象</param>
        /// <returns></returns>
        public virtual void saveform(string keyvalue, t entity)
        {
            if (!string.isnullorempty(keyvalue))
            {
                this.baserepository(dbconn).update(entity);
            }
            else
            {
                this.baserepository(dbconn).insert(entity);
            }
        }
        #endregion

        #region 帮助函数
        /// <summary>
        /// 生成查询表达式
        /// </summary>
        /// <param name="queryjson">查询对象</param>
        /// <returns></returns>
        protected virtual expression<func<t, bool>> querystringtoexpression(expression<func<t, bool>> expression, string queryjson)
        {
            if (string.isnullorempty(queryjson))
                return expression;
            var queryparam = queryjson.tojobject();
            if (!queryparam["condition"].isempty() && !queryparam["keyword"].isempty())
            {
                string condition = queryparam["condition"].tostring();
                string keyword = queryparam["keyword"].tostring();
                switch (condition)
                {
                    default: break;
                }
            }
            return expression;
        }
        /// <summary>
        /// 根据实体生成sql
        /// </summary>
        /// <param name="queryjson">查询对象</param>
        /// <returns></returns>
        protected virtual string getsql(string queryjson)
        {
            stringbuilder sb = new stringbuilder();
            var queryparam = queryjson.tojobject();
            if (!queryparam["condition"].isempty() && !queryparam["keyword"].isempty())
            {
                string condition = queryparam["condition"].tostring();
                string keyword = queryparam["keyword"].tostring();
                sb.append(" and " + condition + " like '%" + keyword + "%'");
            }
            return sb.tostring();
        }
        #endregion
    }
}

创建企业信息业务处理类，继承基础业务处理类，重写保存、过滤条件方法。

using shiquan.company.entity;
using system;
using system.collections.generic;
using system.linq;
using system.text;
using system.threading.tasks;
using system.linq.expressions;
using learun.util;
using learun.util.operat;

namespace shiquan.company.business
{
    /// <summary>
    /// 实现企业信息管理业务处理，继承企业信息库基础业务处理
    /// </summary>
    public class companyinfobll : basiccompanybll<companyinfoentity>
    {
        /// <summary>
        /// 数据保存
        /// </summary>
        /// <param name="keyvalue"></param>
        /// <param name="entity"></param>
        public override void saveform(string keyvalue, companyinfoentity entity)
        {
            try
            {
                if (string.isnullorempty(keyvalue))
                {
                    entity.id = guid.newguid().tostring();
                }
                else
                    entity.id = keyvalue;

                base.saveform(keyvalue, entity);
            }
            catch (exception ex)
            {

                throw;
            }
        }
        /// <summary>
        /// 重写查询过滤条件
        /// </summary>
        /// <param name="expression"></param>
        /// <param name="queryjson"></param>
        /// <returns></returns>
        protected override expression<func<companyinfoentity, bool>> querystringtoexpression(expression<func<companyinfoentity, bool>> expression, string queryjson)
        {
            if (string.isnullorempty(queryjson))
                return expression;
            var queryparam = queryjson.tojobject();
            if (queryparam["code"].isempty() == false)
            {
                string keyword = queryparam["code"].tostring();
                expression = expression.and(my => my.code == keyword);
            }
            if (!queryparam["condition"].isempty() && !queryparam["keyword"].isempty())
            {
                string condition = queryparam["condition"].tostring();
                string keyword = queryparam["keyword"].tostring();
                switch (condition)
                {
                    default: break;
                }
            }
            return expression;
        }
    }
}

 

4、创建企业信息管理web项目-shiquan.company.web

创建空的企业信息管理控制器，实现列表、编辑视图，数据查询、删除、保存方法。

using learun.application.web;
using learun.util;
using shiquan.company.business;
using shiquan.company.entity;
using system;
using system.collections.generic;
using system.linq;
using system.web;
using system.web.mvc;

namespace shiquan.company.web.areas.companymanage.controllers
{
    /// <summary>
    /// 企业信息管理
    /// </summary>
    public class companyinfocontroller : mvccontrollerbase
    {
        // get: companymanage/companyinfo
        companyinfobll service = new companyinfobll();
        /// <summary>
        /// 列表视图
        /// </summary>
        /// <returns></returns>
        public actionresult companyinfoindex()
        {
            return view();
        }
        /// <summary>
        /// 编辑视图
        /// </summary>
        /// <returns></returns>
        public actionresult companyinfoform()
        {
            return view();
        }

        #region 获取数据
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="pagination">分页参数</param>
        /// <param name="queryjson">查询参数</param>
        /// <returns>返回分页列表json</returns>
        [httpget]
        public actionresult getpagelistjson(string pagination, string queryjson)
        {
            pagination paginationobj = pagination.toobject<pagination>();
            var watch = commonhelper.timerstart();
            var data = service.getpagelist(paginationobj, queryjson);
            var jsondata = new
            {
                rows = data,
                total = paginationobj.total,
                page = paginationobj.page,
                records = paginationobj.records,
                costtime = commonhelper.timerend(watch)
            };
            //return tojsonresult(jsondata);
            return success(jsondata);
        }
        /// <summary>
        /// 获取列表
        /// </summary>
        /// <param name="queryjson">查询参数</param>
        /// <returns>返回列表json</returns>
        [httpget]
        public actionresult getlistjson(string queryjson)
        {
            var data = service.getlist(queryjson);
            return tojsonresult(data);
        }
        /// <summary>
        /// 获取实体 
        /// </summary>
        /// <param name="keyvalue">主键值</param>
        /// <returns>返回对象json</returns>
        [httpget]
        public actionresult getformjson(string keyvalue)
        {
            var data = service.getentity(keyvalue);
            return tojsonresult(data);
        }
        #endregion

        #region 提交数据
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="keyvalue">主键值</param>
        /// <returns></returns>
        [httppost]
        [validateantiforgerytoken]
        [ajaxonly]
        public actionresult removeform(string keyvalue)
        {
            service.removeform(keyvalue);
            return success("删除成功。");
        }
        /// <summary>
        /// 保存表单（新增、修改）
        /// </summary>
        /// <param name="keyvalue">主键值</param>
        /// <param name="entity">实体对象</param>
        /// <returns></returns>
        [httppost]
        [validateantiforgerytoken]
        [ajaxonly]
        public actionresult saveform(string keyvalue, companyinfoentity entity)
        {
            service.saveform(keyvalue, entity);
            return success("操作成功。", entity);
        }
        #endregion
    }
}

创建列表界面

@{
    viewbag.title = "客户管理";
    layout = "~/views/shared/_index.cshtml";
}
<div class="lr-layout">
    <div class="lr-layout-center">
        <div class="lr-layout-wrap lr-layout-wrap-notitle">
            <div class="lr-layout-tool">
                <div class="lr-layout-tool-left">
                    <div class="lr-layout-tool-item">
                        <input id="txt_keyword" type="text" class="form-control" placeholder="请输查询关键字" />
                    </div>
                    <div class="lr-layout-tool-item">
                        <a id="btn_search" class="btn btn-primary btn-sm"><i class="fa fa-search"></i>&nbsp;<span class="lrlg">查询</span></a>
                    </div>
                </div>
                <div class="lr-layout-tool-right">
                    <div class="btn-group btn-group-sm">
                        <a id="btnreload" class="btn btn-default"><i class="fa fa-refresh"></i></a>
                    </div>
                    <div class="btn-group btn-group-sm" learun-authorize="yes">
                        <a id="btnadd" class="btn btn-default"><i class="fa fa-plus"></i>&nbsp;<span class="lrlg">新增</span></a>
                        <a id="btnedit" class="btn btn-default"><i class="fa fa-pencil-square-o"></i>&nbsp;<span class="lrlg">编辑</span></a>
                        <a id="btndelete" class="btn btn-default"><i class="fa fa-trash-o"></i>&nbsp;<span class="lrlg">删除</span></a>
                    </div>
                </div>
            </div>
            <div class="lr-layout-body" id="gridtable"></div>
        </div>
    </div>
</div>
<script type="text/javascript">
    var refreshgirddata; // 更新数据
    var selectedrow;
    var bootstrap = function ($, learun) {
        "use strict";
        var page = {
            init: function () {
                page.initgrid();
                page.bind();
            },
            bind: function () {
                // 查询
                $('#btn_search').on('click', function () {
                    var keyword = $('#txt_keyword').val();
                    page.search({ keyword: keyword });
                });
                // 刷新
                $('#btnreload').on('click', function () {
                    location.reload();
                });
                // 新增
                $('#btnadd').on('click', function () {
                    selectedrow = null;//新增前请清空已选中行
                    learun.layerform({
                        id: 'form',
                        title: '新增客户',
                        url: top.$.rooturl + '/companymanage/companyinfo/companyinfoform',
                        width: 600,
                        height: 400,
                        maxmin: true,
                        callback: function (id) {
                            return top[id].acceptclick(refreshgirddata);
                        }
                    });
                });
                // 编辑
                $('#btnedit').on('click', function () {
                    selectedrow = $('#gridtable').jfgridget('rowdata');
                    var keyvalue = $('#gridtable').jfgridvalue('id');
                    if (learun.checkrow(keyvalue)) {
                        learun.layerform({
                            id: 'form',
                            title: '编辑客户',
                            url: top.$.rooturl + '/companymanage/companyinfo/companyinfoform',
                            width: 600,
                            height: 400,
                            maxmin: true,
                            callback: function (id) {
                                return top[id].acceptclick(refreshgirddata);
                            }
                        });
                    }
                });
                // 删除
                $('#btndelete').on('click', function () {
                    var keyvalue = $('#gridtable').jfgridvalue('id');
                    if (learun.checkrow(keyvalue)) {
                        learun.layerconfirm('是否确认删除该项！', function (res) {
                            if (res) {
                                learun.deleteform(top.$.rooturl + '/companymanage/companyinfo/deleteform', { keyvalue: keyvalue }, function () {
                                    refreshgirddata();
                                });
                            }
                        });
                    }
                });
            },
            initgrid: function () {
                $('#gridtable').jfgrid({
                    url: top.$.rooturl + '/companymanage/companyinfo/getpagelistjson',
                    headdata: [
                        { label: '编号', name: 'code', width: 100, align: 'left' },
                        { label: '名称', name: 'name', width: 200, align: 'left' },
                        { label: '负责人', name: 'leader', width: 100, align: 'left' },
                        { label: '联系人', name: 'linkman', width: 100, align: 'left' },
                        { label: '联系电话', name: 'phone', width: 100, align: 'left' },
                        { label: '联系地址', name: 'address', width: 200, align: 'left' },
                        {
                            label: "最后更新", name: "modifydate", width: 140, align: "left",
                            formatter: function (cellvalue) {
                                return learun.formatdate(cellvalue, 'yyyy-mm-dd hh:mm');
                            }
                        },
                        { label: '备注', name: 'remark', width: 200, align: 'left' },
                    ],
                    mainid: 'id',
                    reloadselected: true,
                    ispage: true,
                    sidx: 'code'
                });
                page.search();
            },
            search: function (param) {
                $('#gridtable').jfgridset('reload', param);
            }
        };
        // 保存数据后回调刷新
        refreshgirddata = function () {
            page.search();
        }
        page.init();
    }
</script>

 

创建编辑界面

@{
    viewbag.title = "客户添加";
    layout = "~/views/shared/_form.cshtml";
}
<div class="lr-form-wrap" id="form">
    <div class="col-xs-12 lr-form-item">
        <div class="lr-form-item-title">编号<font face="宋体">*</font></div>
        <input id="code" type="text" class="form-control" isvalid="yes" checkexpession="notnull" />
    </div>
    <div class="col-xs-12 lr-form-item">
        <div class="lr-form-item-title">名称<font face="宋体">*</font></div>
        <input id="name" type="text" class="form-control" isvalid="yes" checkexpession="notnull" />
    </div>
    <div class="col-xs-12 lr-form-item">
        <div class="lr-form-item-title">负责人<font face="宋体">*</font></div>
        <input id="leader" type="text" class="form-control" isvalid="yes" checkexpession="notnull" />
    </div>
    <div class="col-xs-12 lr-form-item">
        <div class="lr-form-item-title">联系人</div>
        <input id="linkman" type="text" class="form-control" isvalid="no" checkexpession="notnull" />
    </div>
    <div class="col-xs-12 lr-form-item">
        <div class="lr-form-item-title">联系电话</div>
        <input id="phone" type="text" class="form-control" />
    </div>
    <div class="col-xs-12 lr-form-item">
        <div class="lr-form-item-title">联系地址</div>
        <input id="address" type="text" class="form-control" />
    </div>
    <div class="col-xs-12 lr-form-item">
        <div class="lr-form-item-title">备注</div>
        <textarea id="remark" class="form-control" style="height: 50px;"></textarea>
    </div>
</div>
<script type="text/javascript">
    var acceptclick;
    var keyvalue = '';
    var bootstrap = function ($, learun) {
        "use strict";
        var selectedrow = learun.frametab.currentiframe().selectedrow;
        var page = {
            init: function () {
                page.bind();
                page.initdata();
            },
            bind: function () {
                // 客户级别
                //$('#f_custlevelid').lrdataitemselect({ code: 'client_level', maxheight: 230 });
                //// 客户类别
                //$('#f_custtypeid').lrdataitemselect({ code: 'client_sort', maxheight: 230 });
                //// 客户程度
                //$('#f_custdegreeid').lrdataitemselect({ code: 'client_degree', maxheight: 230 });
                ////跟进人员
                //$('#f_traceuserid').lrformselect({
                //    layerurl: top.$.rooturl + '/lr_organizationmodule/user/selectform',
                //    layerurlw: 800,
                //    layerurlh: 520,
                //    dataurl: top.$.rooturl + '/lr_organizationmodule/user/getlistbyuserids'
                //});
                ////公司行业
                //$('#f_custindustryid').lrdataitemselect({ code: 'client_trade', maxheight: 230 });
            },
            initdata: function () {
                if (!!selectedrow) {
                    keyvalue = selectedrow.id;
                    $('#form').lrsetformdata(selectedrow);
                }
            }
        };
        // 保存数据
        acceptclick = function (callback) {
            if (!$('#form').lrvalidform()) {
                return false;
            }
            var postdata = $('#form').lrgetformdata(keyvalue);
            $.lrsaveform(top.$.rooturl + '/companymanage/companyinfo/saveform?keyvalue=' + keyvalue
                , postdata
                , function (res) {
                // 保存成功后才回调
                if (!!callback) {
                    callback();
                }
            });
        };
        page.init();
    }
</script>

 

业务项目，至此搭建完成，接下来，使用web项目进行引用，

配置业务项目数据表映射

  <!-- 实体类映射库名称 -->
  <add key="datamapper" value="learun.application.mapping.dll,shiquan.company.mapping.dll"/>

配置业务项目数据库连接，添加配置功能菜单

运行系统效果

更多精彩，且听下回分解！