public int AddSysApi(SysApiEntity model)
{
string sql = "INSERT INTO SysApi(AppId,ApiName,ApiType,ApiDescription,ApiOwner,ApiAddress,ApiStatus,Remark,AddTime) VALUES(@AppId,@ApiName,@ApiType,@ApiDescription,@ApiOwner,@ApiAddress,@ApiStatus,@Remark,GETDATE())";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int UpdateSysApi(SysApiEntity model)
{
string sql = "UPDATE SysApi SET AppId=@AppId,ApiName=@ApiName,ApiType=@ApiType,ApiDescription=@ApiDescription,ApiOwner=@ApiOwner,ApiAddress=@ApiAddress,ApiStatus=@ApiStatus,Remark=@Remark WHERE SysApiId=@SysApiId ";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int AddSysApi(SysApiEntity model)
{
return(sysApiDal.AddSysApi(model));
}
public int UpdateSysApi(SysApiEntity model)
{
return(sysApiDal.UpdateSysApi(model));
}
