将int值转换为数据库中的字符串 [英] Convert int value to string from database

问题描述

我有一个存储MemberId的预订表，但我想通过我的api检索它作为会员名称，我发现很难做到这一点。我必须在api中这样做，以便我的android可以得到名字和姓氏用空格分隔。



我尝试过：



此api将refcode作为参数发送有关预订的所有信息

 private List< BookingView> getMembersBooked（String RefCode）
 {
 DB repo = new DB（）; 
 var result = new ApiResult< List< TimeModel>>（）; 
 try 
 {
 // BookingStatus = 2< =>取消
 
 var list = repo.Fetch< BookingView>（SELECT * FROM BookingView WHERE RefCode = @ 0 AND BookingStatus<> 2，RefCode）; 
返回清单; 
} 
 catch（exception ex）
 {
返回新列表< BookingView>（）; 
} 
最后
 {
 repo.Dispose（）; 
} 
 
} 

此api发送清单android需要列出会员名称

 public ApiResult< TimeModelExtended> GetOneTime（String refCode）
 {
 DB repo = new DB（）; 
 var result = new ApiResult< TimeModelExtended>（）; 
 try 
 {
 
 var NbSlots = repo.SingleOrDefault< Int16>（SELECT Value FROM Settings WHERE Parameter = @ 0，NbSlots）; 
 
 
 TimeModelExtended model = new TimeModelExtended（）
 {
 Date = refCode.Substring（0,8），
 Time = refCode.Substring（8 ，4），
 NbSlots = NbSlots，
 RefCode = refCode，
 Members = getMembersBooked（refCode），
}; 
 
 model.Booked = Convert.ToInt16（model.Members.Count）; 
 
 result.Successfull = 1; 
 
 result.Model = model; 
} 
 catch（Exception ex）
 {
 result.Successfull = 0; 
 result.InternalError = ex.Message; 
 result.Error =来自服务器的错误; 
} 
最后
 {
 repo.Dispose（）; 
} 
 
返回结果; 
 
} 
 

会员名称显示为一个名称，但我希望将其分开用空格分隔的firstname和lastname。

解决方案

SELECT str（Value）value FROM Settings WHERE Parameter = @ 0 - 看它工作在--Database使用查询

I have a booking table storing MemberId,but i want to retrieve it through my api as the member name and i'm finding it hard to do that.i have to do it in the api so that my android can get the firstname and last name separated by a space.

What I have tried:

this api takes refcode as parameter to send the all information about the booking

private List<BookingView> getMembersBooked(String RefCode)
        {
            DB repo = new DB();
            var result = new ApiResult<List<TimeModel>>();
            try
            {
                //BookingStatus = 2 <=> Cancelled

                var list = repo.Fetch<BookingView>("SELECT * FROM BookingView WHERE RefCode=@0 AND BookingStatus<>2 ", RefCode);
                return list;
            }
            catch (Exception ex)
            {
                return new List<BookingView>();
            }
            finally
            {
                repo.Dispose();
            }

        }

this api sends the list needed for the android to list the member names

public ApiResult<TimeModelExtended> GetOneTime(String refCode)
       {
           DB repo = new DB();
           var result = new ApiResult<TimeModelExtended>();
           try
           {

               var NbSlots = repo.SingleOrDefault<Int16>("SELECT Value FROM Settings WHERE Parameter=@0", "NbSlots");


               TimeModelExtended model = new TimeModelExtended()
               {
                   Date = refCode.Substring(0, 8),
                   Time = refCode.Substring(8, 4),
                   NbSlots = NbSlots,
                   RefCode = refCode,
                   Members = getMembersBooked(refCode),
               };

               model.Booked = Convert.ToInt16(model.Members.Count);

               result.Successfull = 1;

               result.Model = model;
           }
           catch (Exception ex)
           {
               result.Successfull = 0;
               result.InternalError = ex.Message;
               result.Error = "Error from server";
           }
           finally
           {
               repo.Dispose();
           }

           return result;

       }

the member names shows as one name but i want it to be separated into firstname and lastname separated by a space.

解决方案

SELECT str(Value) value FROM Settings WHERE Parameter=@0 -- to see it working from --Database using query

这篇关于将int值转换为数据库中的字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！