原创

【C#编程最佳实践 八】MVC流程实践

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-NC-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://tianmaolin.blog.csdn.net/article/details/78871413

近期参与了工作台开发任务,亲身实践了mvc一个流程:(Model层)创建数据表—(Model层)创建Entity实体类—(Model层)创建数据表和实体的映射关系或调用通用的映射关系—(Model层)创建存储过程—(Model层)创建Dao层代码—(Model层)创建Provider层代码—(Controller层)在控制层写业务逻辑接口调用Model的provider,并返回给前端(View)—(View层)前端。体会了MVC全流程实践,也体会了团队合作如何实现。

Model层

Model层相当于一块功能的封装,为控制层接口提供服务。一般会涉及到对数据表的操作,那么一般会涉及到以下操作。

创建数据表

USE [***LandingSite]
GO

/****** Object:  Table [dbo].[WorkBenchScene]    Script Date: 2017/12/22 11:39:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WorkBenchScene](
    [ID] [uniqueidentifier] NOT NULL,
    [Name] [nvarchar](200) NOT NULL,
    [PID] [uniqueidentifier] NULL,
    [Application] [nvarchar](50) NULL,
    [TenantID] [int] NULL,
    [MetaObjectName] [varchar](100) NOT NULL,
    [CreatedBy] [int] NOT NULL,
    [CreatedTime] [datetime] NOT NULL,
    [ModifiedBy] [int] NULL,
    [ModifiedTime] [datetime] NULL,
    [ProcessJson] [nvarchar](max) NOT NULL,
    [IsEnabled] [bit] NULL,
 CONSTRAINT [PK_WorkBenchScene] PRIMARY KEY CLUSTERED 
(
    [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP (1000) [ID]
      ,[Name]
      ,[PID]
      ,[Application]
      ,[TenantID]
      ,[MetaObjectName]
      ,[CreatedBy]
      ,[CreatedTime]
      ,[ModifiedBy]
      ,[ModifiedTime]
      ,[ProcessJson]
      ,[IsEnabled]
  FROM [***LandingSite].[dbo].[WorkBenchScene]

创建实体类

using System;
using System.Runtime.Serialization;

namespace ***.Implementation.Entity.WorkBench
{
    /// <summary>
    /// 场景表对应的实体类
    /// </summary>
    public class WorkBenchScene : BaseEntity
    {
        /// <summary>
        /// 场景名
        /// </summary>
        [DataMember]
        public string Name { get; set; }

        /// <summary>
        /// 场景父ID
        /// </summary>
        public Guid PID { get; set; }

        /// <summary>
        /// 应用名
        /// </summary>
        public string Application { get; set; }

        /// <summary>
        /// 租户ID
        /// </summary>
        public int TenantID { get; set; }

        /// <summary>
        /// 实体名
        /// </summary>
        public string MetaObjectName { get; set; }

        /// <summary>
        /// 创建人
        /// </summary>
        public int CreatedBy { get; set; }

        /// <summary>
        /// 修改人
        /// </summary>
        public int ModifiedBy { get; set; }

        /// <summary>
        /// 修改时间
        /// </summary>
        public DateTime ModifiedTime { get; set; }

        /// <summary>
        /// 流程json字符串ProcessJson
        /// </summary>
        public string ProcessJson { get; set; }

        /// <summary>
        /// 是否启用
        /// </summary>
        public bool IsEnabled { get; set; }
    }
}

创建数据表和实体的映射关系

创建自定义映射关系

  #region 私有 mapper

        private ***.Data.MapperDelegates.RecordMapper<API> GetMapper()
        {
            return delegate (IRecord record, API model)
            {
                model.ID = record.Get<Guid>("ID");
                model.Application = record.GetOrDefault<string>("Application", string.Empty);
                model.ApiType = record.GetOrDefault<int>("ApiType", 0);
                model.ResourceCode = record.GetOrDefault<string>("ResourceCode", string.Empty);
                model.ResourceName = record.GetOrDefault<string>("ResourceName", string.Empty);
                model.GetListAPI = record.GetOrDefault<string>("GetListAPI", string.Empty);
                model.ImportDataAPI = record.GetOrDefault<string>("ImportDataAPI", string.Empty);
                model.Enabled = record.GetOrDefault<bool>("Enabled", true);
                model.CreatedTime = record.GetOrDefault<DateTime>("CreatedTime", DateTime.MinValue);
                model.ShowFields = record.GetOrDefault("ShowFields", string.Empty);
                model.WhiteList = record.GetOrDefault("WhiteList", string.Empty);
            };
        }

        #endregion 私有 mapper

调用默认的映射关系

注意,默认的映射规则,实体的属性名和数据表的列名一定要对的上。

  protected ***.Data.MapperDelegates.RecordMapper<T> GetMapper()
        {
            return delegate (IRecord record, T model)
            {
                if (Properties != null)
                {
                    foreach (var item in Properties)
                    {
                        try
                        {
                            SetValue(item, record, ref model);
                        }
                        catch (Exception e)
                        {
                            System.Console.WriteLine($"error: {EntityName}.{ item.Name}"); //todo ....logger
                        }
                    }
                }
            };
        }

        private static void SetValue(PropertyInfo item, IRecord record, ref T model)
        {
            var fieldName = item.Name;
            switch (item.PropertyType.FullName)
            {
                case "System.Int32":
                    item.SetValue(model, record.GetOrDefault<int>(fieldName, 0));
                    break;

                case "System.String":
                    item.SetValue(model, record.GetOrDefault<string>(fieldName, string.Empty));
                    break;

                case "System.Boolean":
                    item.SetValue(model, record.GetOrDefault<Boolean>(fieldName, false));
                    break;

                case "System.DateTime":
                    item.SetValue(model, record.GetOrDefault<DateTime>(fieldName, DateTime.MinValue));
                    break;

                case "System.Float":
                    item.SetValue(model, record.GetOrDefault<float>(fieldName, 0));
                    break;

                case "System.Double":
                    item.SetValue(model, record.GetOrDefault<Double>(fieldName, 0));
                    break;

                case "System.Guid":
                    item.SetValue(model, record.GetOrDefault<Guid>(fieldName, Guid.Empty));
                    break;

                default:
                    throw new TypeLoadException($"未知字段类型异常.fieldName:{fieldName},type:{item.PropertyType.FullName}");
            }
        }

创建存储过程

USE [***LandingSite]
GO
/****** Object:  StoredProcedure [dbo].[WorkBenchScene_GetByMetaObjectName]    Script Date: 2017/12/22 12:09:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      tianmaolin
-- Create date: 2017-12-22
-- Description: 根据实体编码获取场景
-- =============================================
ALTER PROCEDURE [dbo].[WorkBenchScene_GetByMetaObjectName](
@MetaObjectName varchar(100)
)
AS

SELECT  *  FROM dbo.WorkBenchScene where MetaObjectName=@MetaObjectName

创建Dao层代码

这里写图片描述

创建Provider层代码

这里写图片描述

Controller层

 /// <summary>
        /// 公有方法:通过实体名获取场景名和场景ID列表组
        /// </summary>
        /// <param name="metaObjectName"></param>
        /// <returns></returns>
        [HttpGet]   //通过get方式获取
        public JsonResult GetByMetaObjectName(string metaObjectName)
        {
            if (!string.IsNullOrEmpty(metaObjectName))
            {
                List<WorkBenchScene> lw = WorkBenchSceneProvider.Instance.GetByMetaObjectName(metaObjectName);  //获取场景列表
                if (lw == null || lw.Count == 0)
                {
                    return Json(new Helper.OperationResult { code = (int)CodeType.Failure, message = "场景列表获取失败" }, JsonRequestBehavior.AllowGet);
                }

                List<WorkBenchDic> list = new List<WorkBenchDic>();
                foreach (var item in lw)
                {
                    list.Add(new WorkBenchDic(item.ID.ToString(), item.Name));
                }

                return Json(new Helper.OperationResult { code = (int)CodeType.Success, message = "获取成功", param = list }, JsonRequestBehavior.AllowGet);
            }

            return Json(new Helper.OperationResult { code = (int)CodeType.Failure, message = "参数为空" }, JsonRequestBehavior.AllowGet);
        }

        /// <summary>
        /// 公有方法:通过场景id获取该场景详情
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [HttpGet]
        public JsonResult GetByID(Guid id)
        {
            if (!string.IsNullOrEmpty(id.ToString()))
            {
                WorkBenchScene wbs = WorkBenchSceneProvider.Instance.GetById(id); //获取确定场景
                if (wbs == null)
                {
                    return Json(new Helper.OperationResult { code = (int)CodeType.Failure, message = "场景获取失败" }, JsonRequestBehavior.AllowGet);
                }

                return Json(new Helper.OperationResult { code = (int)CodeType.Success, message = "获取成功", param = wbs.ProcessJson }, JsonRequestBehavior.AllowGet);
            }

            return Json(new Helper.OperationResult { code = (int)CodeType.Failure, message = "参数为空" }, JsonRequestBehavior.AllowGet);
        }

View层

SettingValue是页面

这里写图片描述

文章最后发布于: 2017-12-22 11:27:49
展开阅读全文
0 个人打赏
私信求帮助

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: Age of Ai 设计师: meimeiellie

分享到微信朋友圈

×

扫一扫,手机浏览