原

保存方法

2796人阅读 2022/11/16 16:09 总访问：16920 评论：0 收藏：0 手机

分类: 技术

保存的方法接口
#region 保存

        /// <summary>
        /// 保存
        /// Api</summary>
        [Route("Save")]
        [HttpPost]
        [AdviceWebApi]
        public HttpResponseMessage Save()
        {
            var response = Request.GetData(out var data);
            if (response != null) return response;

            var service = new TaxRegisterMasterService();
            var datas = DataUtility.JsonToObject<YNRF.Models.Executive.TaxRegisters>(data);
            if (datas.TaxRegisterMaster == null)
            {
                return Request.CreateParamErrorResponse(nameof(YNRF.Models.Executive.TaxRegisterMaster));
            }

            if (datas.TaxRegisterMaster.Id > 0)
            {
                datas.TaxRegisterMaster = service.SelectSingleByPK(datas.TaxRegisterMaster.Id);
                JsonUtility.StringJsonPopulateToObject(DataUtility.GetValue(data, nameof(YNRF.Models.Executive.TaxRegisters.TaxRegisterMaster)), datas.TaxRegisterMaster);
            }

            var model = service.Save(datas);
            var result = service.GetDatas(model);

            return Request.CreateSuccessResponse(result);
        }

        #endregion

 #region 从表中通过主键获取符合条件的第一条数据 SelectSingleByPK方法

        /// <summary>
        /// 从表中通过主键获取符合条件的第一条数据
        /// BLL</summary>
        public YNRF.Models.Executive.TaxRegisterMaster SelectSingleByPK(int id)
        {
            if (id <= 0) return null;

            return dal.SelectSingleByPK(id);
        }

        #endregion


        /// <summary>
        /// DAL从表中通过主键获取符合条件的第一条数据
        /// </summary>
        public YNRF.Models.Executive.TaxRegisterMaster SelectSingleByPK(int id, JCPX.DB.Database db = null)
        {
            if (id <= 0) return null;

            return SelectSingle($"Id={id}", "", db);
        }

      #endregion
 
    	/// <summary>
        ///  从表中获取符合条件的第一条数据
        ///DAL</summary>
        public YNRF.Models.Executive.TaxRegisterMaster SelectSingle(string where, string orderby = "", JCPX.DB.Database db = null)
        {
            var sql = "SELECT TOP 1 * FROM [dbo].[tbd_TaxRegisterMaster]";
            sql = JCPX.Utility.StringUtility.AppendStringBySeparator(sql, where, " WHERE ");
            sql = JCPX.Utility.StringUtility.AppendStringBySeparator(sql, orderby, " ORDER BY ");

            var result = JCPX.DAL.DbUtility.CreateDatabase(db)
                .CreateSqlCommand(sql)
                .Fetch<YNRF.Models.Executive.TaxRegisterMaster>(db);

            return result;
        }

        #endregion

👈{{preArticle.title}}

👉{{nextArticle.title}}

评价

初学者

我没有个性，不需要那些花里胡哨的东东

博主信息

排名

文章

粉丝

文章类别

技术 8篇

保存方法

{{titleitem}} {{titleitem}}

{{titleitem}} {{titleitem}}