示例#1
0
        public HttpResponseMessage Post([FromBody] All userData)
        {
            return(Request.CreateResponse(HttpStatusCode.OK,
                                          SamgoGameHelper.AddUserData(userData)));

            //UserBuild ub = new UserBuild();
            //userData.Time = Function.GetUTCTime();
            //SamgoModels.UserInfo ui = new SamgoModels.UserInfo();
            //UserValue uLord = new UserValue();
            //UserValue uProsperity = new UserValue();
            //UserPower up = new UserPower();
            //UserTechnique ut = new UserTechnique();
            //UserOrdnance uo = new UserOrdnance();

            //var userInfo = new SamgoModels.UserInfo();
            //userData.SeqNo = DapperHelper.Search<int>(
            //   connectionString, " exec [samgo_add_user_and_group] N'" +
            //   userData.Role + "' , N'" + userData.Legion + "'").FirstOrDefault();
            //ConvertDataToModels(ref ub, ref ui, ref uLord, ref uProsperity, ref up, userData);

            //DapperHelper.InsertSQLNormal<UserBuild>(connectionString, "Build", ub);
            ////DapperHelper.InsertSQL<SamgoModels.UserInfo>(connectionString, "SamgoGame", ui);
            //DapperHelper.InsertSQLNormal<UserValue>(connectionString, "Lord", uLord);
            //DapperHelper.InsertSQLNormal<UserValue>(connectionString, "Prosperity", uProsperity);
            //DapperHelper.InsertSQLNormal<UserPower>(connectionString, "SamgoGamePower", up);
            //ConvertDataToModels(ref ut, ref uo, userData);

            //DapperHelper.InsertSQLNormal<UserTechnique>(connectionString, "Technique", ut);
            //var response = DapperHelper.InsertSQLNormal<UserOrdnance>(connectionString, "Ordnance", uo);

            //return Request.CreateResponse(HttpStatusCode.OK, userData.SeqNo);
        }
示例#2
0
        public HttpResponseMessage Get()
        {
            var allData = DapperHelper.Search <AllString>(SamgoGameHelper.connectionString,
                                                          "exec [samgo_get_user_info_list]");
            int count = 3;

            return(Request.CreateResponse(HttpStatusCode.OK, SamgoGameHelper.FillDataForView(allData, count)));
        }
示例#3
0
        public HttpResponseMessage PostUserSearch(Inner data)
        {
            AllString ob = new AllString();

            try
            {
                UserDetail uDetail = new UserDetail();
                UserData   ud      = DapperHelper.Search <UserData>(SamgoGameHelper.connectionString,
                                                                    "exec [samgo_get_user_info] N'" + data.Role + "', N'" + data.Legion + "'").FirstOrDefault();
                uDetail = DapperHelper.Search <UserDetail>(SamgoGameHelper.connectionString,
                                                           "exec [samgo_get_user_tech_info] N'" + data.Role + "', N'" + data.Legion + "'").FirstOrDefault();
                SamgoGameHelper.ConvertDataToModels(ref ob, ud, uDetail);
            }
            catch (Exception) { }
            if (ob.Role == null)
            {
                ob.Role   = data.Role;
                ob.Legion = data.Legion;
            }
            return(Request.CreateResponse(HttpStatusCode.OK, ob));
        }