/// <summary> /// 获取通用美容服务码发放记录 /// </summary> /// <param name="packageRecordId"></param> /// <returns></returns> public async Task <ThirdPartyBeautyPackageRecordModel> GetGeneralBeautyServerCodeSendRecordById(int pkid) { ThirdPartyBeautyPackageRecordModel result = null; try { result = await _DalGeneralBeautyServerCode.GetGeneralBeautyServerCodeSendRecordById(pkid); } catch (Exception ex) { _logger.Error(ex.Message, ex); } return(result); }
public async Task <ThirdPartyBeautyPackageRecordModel> GetGeneralBeautyServerCodeSendRecordById(int pkid) { #region SQL string sql = @"SELECT TOP 1 [PKID] ,[PackageId] ,[Phone] ,[SerialNumber] ,[CreatedDateTime] ,[UpdatedDateTime] ,[Status] ,[UserId] ,[OrderId] FROM [Tuhu_groupon].[dbo].[ThirdPartyBeautyPackageRecord] WITH(NOLOCK) WHERE PKID=@PKID"; #endregion ThirdPartyBeautyPackageRecordModel result = null; using (var conn = new SqlConnection(strConn_OnlyRead)) { var sqlPara = new[] { new SqlParameter("PKID", pkid), }; var dateRow = SqlHelper.ExecuteDataRow(conn, CommandType.Text, sql, sqlPara); if (dateRow != null) { result = new ThirdPartyBeautyPackageRecordModel { PKID = dateRow.GetValue <Int32>("PKID"), PackageId = dateRow.GetValue <Guid>("PackageId"), Phone = dateRow.GetValue <String>("Phone"), SerialNumber = dateRow.GetValue <String>("SerialNumber"), CreatedDateTime = dateRow.GetValue <DateTime>("CreatedDateTime"), UpdatedDateTime = dateRow.GetValue <DateTime>("UpdatedDateTime"), UserId = dateRow.GetValue <Guid>("UserId"), OrderId = dateRow.GetValue <Int32>("OrderId"), } } ; } return(await Task.FromResult(result)); }