保存方法 电脑版发表于:2022/11/16 16:09 保存的方法接口 #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