保存的方法接口

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