public List <BuildModels> Inquire(int Build_ID)
{
command.CommandText = $@"SELECT Table_build.Build_ID, Table_build.Build_date , Table_Class.Class_name , Table_build.Build_money,Table_Image.Image_text,Table_build.Build_class
FROM Table_build
JOIN Table_Class on Build_class=Table_Class.Class_id
join Table_Image on Table_Image.Build_id = Table_build.Build_ID
WHERE Table_build.Build_ID = {Build_ID}";
var quire = command.ExecuteReader();
List <BuildModels> list = new List <BuildModels>();
while (quire.Read())
{
BuildModels models = new BuildModels();
models.Build_ID = (int)quire["Build_ID"];
models.Build_Date = ((DateTime)quire["Build_date"]).ToShortDateString();
models.Build_Money = (int)quire["Build_money"];
models.Class_name = (String)quire["Class_name"];
models.Image_text = (String)quire["Image_text"];
models.Class_ID = (int)quire["Build_class"];
list.Add(models);
}
return(list);
}
public IHttpActionResult InsertClass([FromBody] BuildModels models)
{
using (ClassService insert = new ClassService())
{
int insertclass = insert.Insertclass(models.Class_name);
return(Ok(insertclass));
}
}
public IHttpActionResult Update([FromBody] BuildModels models)
{
using (UpdateService up = new UpdateService())
{
int date = up.Updata(models.Build_Class, models.Build_Money, models.Build_ID);
return(Ok(date));
}
}
public CcBuildModel BuildModelFor(float percent)
{
foreach (var k in BuildModels)
{
if (k.UpperBound >= percent)
{
return(k);
}
}
return(BuildModels.Last());
}
public IHttpActionResult Insertrecord([FromBody] BuildModels buildModels)
{
using (BuildService buildservice = new BuildService())
{
int insertdata = buildservice.InsertData(buildModels.Build_Date, buildModels.Class_ID, buildModels.Build_Money);
if (insertdata == 1)
{
String status = buildservice.InsertImg(buildModels.Img_Base);
if (status.Equals("新增成功"))
{
return(Ok("新增成功"));
}
else
{
return(Ok("圖片新增失敗"));
}
}
else
{
return(Ok("新增失敗"));
}
}
}
