Beispiel #1
0
        public IHttpActionResult Getrecord()
        {
            using (BuildService buildservice = new BuildService())
            {
                List <BuildModels> models = buildservice.GetData(@"select Table_build.Build_ID , Build_date ,Build_money, Class_name,Table_Image.Image_text
                                                              from Table_build
                                                              Join Table_Class on Table_build.Build_class = Table_Class.Class_id
							                                  join Table_Image on Table_Image.Build_id = Table_build.Build_ID
                                                              ORDER  BY Build_ID ASC");

                return(Ok(models));
            }
        }