public async Task <IHttpActionResult> GetHANGSX(int id)
{
HANGSX hANGSX = await db.HANGSX.FindAsync(id);
if (hANGSX == null)
{
return(NotFound());
}
return(Ok(hANGSX));
}
public void DeleteHANGSX(HANGSX hang)
{
string query = "delete HANGSX where ID=@id";
string[] para = new string[1] {
"@id"
};
object[] value = new object[1] {
hang.ID
};
cn.Excute_Sql(query, CommandType.Text, para, value);
}
public void UpdateHANGSX(HANGSX hang)
{
string query = "update HANGSX set TEN = @ten where ID = @id";
string[] para = new string[2] {
"@id", "@ten"
};
object[] value = new object[2] {
hang.ID, hang.TEN
};
cn.Excute_Sql(query, CommandType.Text, para, value);
}
public void InsertHANGSX(HANGSX hang)
{
string query = "insertHSX";
string[] para = new string[1] {
"@ten"
};
object[] value = new object[1] {
hang.TEN
};
cn.Excute_Sql(query, CommandType.StoredProcedure, para, value);
}
public async Task <IHttpActionResult> PostHANGSX(HANGSX hANGSX)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//db.HANGSX.Add(hANGSX);
//await db.SaveChangesAsync();
hsxDAO.InsertHANGSX(hANGSX);
return(CreatedAtRoute("DefaultApi", new { id = hANGSX.ID }, hANGSX));
}
public async Task <IHttpActionResult> DeleteHANGSX(int id)
{
HANGSX hANGSX = await db.HANGSX.FindAsync(id);
if (hANGSX == null)
{
return(NotFound());
}
db.HANGSX.Remove(hANGSX);
await db.SaveChangesAsync();
return(Ok(hANGSX));
}
public HANGSX GetHANGSXbyId(int id)
{
string query = "select * from HANGSX where id = @id";
string[] para = new string[1] {
"@id"
};
object[] value = new object[1] {
id
};
DataTable tb = cn.FillDataTable(query, CommandType.Text, para, value);
HANGSX sp = cn.ConvertToList <HANGSX>(tb)[0];
return(sp);
}
public async Task <IHttpActionResult> PutHANGSX(HANGSX hANGSX)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Entry(hANGSX).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
}
return(StatusCode(HttpStatusCode.NoContent));
}
