public DataTable getRelate(EQM_EQUIP_RELATE tp)
{
//get后，post传输数据量大，网址后面不会接数据
DataTable list = null;
string Sql = @" select distinct Equiprelate
from EQM_EQUIP_RELATE
where 1=1 ";
list = BSCBO.GetDataTableBySql(Sql);
return(list);
}
public HttpResponseMessage UpdateUser(EQM_EQUIP_RELATE user)
{
try
{
relateBO.UpdateSome(user);
return(Request.CreateResponse(HttpStatusCode.OK, "更新成功"));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "更新出错:" + ex.Message));
}
}
public HttpResponseMessage AddUser(IList <EQM_EQUIP_RELATE> relate)
{
//获得
EQM_EQUIP_RELATE newRelate = null;
using (TransactionScope ts = new TransactionScope())
{
for (int i = 0; i < relate.Count; i++)
{
newRelate = this.relateBO.Insert(relate[i]);
}
ts.Complete();
}
if (newRelate != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, "新增成功"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "新增失败"));
}
}
